The problem is that the crossovers I am shown are 1 week old, delayed by one click (for a weekly chart screener). I want the ones that happened this week. What is wrong? See picture. It was taken Monday September 3rd California time at 9 PM, so well into Tuesday September 4th European time, yet it is showing me a cross-over from August 20th, why not from August 27th . I presume that the weeks are labelled by their starting date? Otherwise, today is September 3rd , Monday is finished, so also the week of (ending on) September 3rd should be calculated now. Strangely enough, the formula works fine, i.e. as expected for DAILY charts. I get today’s crossovers, not from 2-3 days ago.
Please use the ‘Insert PRT Code’ button when putting code in your future posts as it makes it far easier for others to read. I have tidied up your post for you. 🙂
You’ll not get result for a cross over on August 27th, since no cross-over occurred on that date. For a cross-over on this date to be confirmed, the stochastic would have been below its signal on August 20th, but it was already above it.
Thanks for your answer, but I think you are missing the point of my question. I am doing a screener on September 3rd, so I am interested in crossovers that have happened THIS week, right now, so to speak. I don’t understand why the system gives me cross-overs that happened two weeks ago in weekly mode, but once that happened today in daily mode (this is the desired behavior). This looks to me like a major bug in the system. My weekly screener results are useless.
I have a typo: “once” should have been “Ones” above.
So, to reiterate, when I screen for Stochastic crossovers on Daily charts, I get stocks that had a crossover today (=the most recent bar), but when I run the same screener code on Weekly charts, I get stocks that had crossovers NOT this week, but TWO weeks ago (=TWO bars ago). Thus they are old crossovers and useless for me AND, as far as I can tell, do not reflect the simple code. The behavior should not be different between Daily and Weekly, right?
If you launch a screener on Sunday on a market shares of which you don’t have real time, the calculations will be done on the Thursday data. So if your account is an “End Of Day” one, to get the data of Friday on a market shares, it is necessary that the current day is the next trading day of the market, in this case the Monday.
.
