New Members: Be sure to confirm your email address by clicking on the link that was sent to your email inbox. You will not be able to post messages until you click that link.
From the UK - A Simple Scan with the wrong results?
Hi, I hope someone can help with this-
I have used the basic scan builder to try to do this-
Scan for major LSE shares, that have shown a new Elder Red bar for the end of day.
The high must also be below the EMA (65).
I have attached the criteria that stockcharts.com wrote out for me- however, from the results, ITV had blue Elder bar at end of
day, not red. Further scans have also given results where not all end of day bars are red.
Could this be something to do with timing, as they are UK shares? I scan at least 3-4 hours after close of trading, which is 4.30pm UK time.
And this shouldn't be a problem, as the scan is in real time, and shouldn't possibly return anything but red bars!
I used the drop down box from the builder, to say Elder Red Bar is true for 0 days ago.
Must be something I am doing wrong, as I am new to this!
0
Answers
In any case, I transcribed the "plain english" conditions, and they seem to work. I set the run date for "last market close", which in this case would be March 22 (actual run time about 9:45 am eastern time (US) March 23).
Note when you get the results, the charts display as of the current moment, not as of the end of the data the scan engine looks at, so the last bar on the chart may or may not be red if there is data after the scan date you set.
Without seeing the advanced scan page as you ran it, I can't explain the apparent error you saw. I suppose it's possible you ran it during the day at a moment when the bar was red but got results when the bar had turned green or blue. I don't actually know the details of how Elder Bar turns red or green or blue, so that's just a guess.
So here's the advanced scan page code that seems to work as you want:
// begin LSE scan
[exchange is LSE]
and [sma(60, close) > 100]
and [sma(65, close) > high]
and [sma(60, volume) > 1000000]
and [Elder Bar Red is true]
and [ 1 day ago Elder Bar Red is false]
// end LSE scan
Can you see my attachments? I am not sure if they are big enough to view. If so, you can see the code in the first, and the chart in the second....
Having said that, I think that these bars qualify as Elder Red, it it just that they are being sown as the wrong colour. If you see what I mean??
Can you see the attachments? Not sure if they are big enough?
I must also add that I think these bars qualify as Elder Red, even though they are not coloured red, if you see what I mean. But I am still not sure as to what the problem may be.... ?
I just did a few tests on this issue and agree there seems to be something a little off. If I add "rank by elder bar red" at the end of the scan the scan engine returns that they are all "1.00" which is true for Red, but of course we know not all are red. First thing I noticed was the close and volume values on your scan output page are not the same as on the chart you show and I think this is the problem.
It's important to realize the charting database and the scan database are not on the same server. The scan database is smaller and on a very fast server with fast memory, necessary to run scans in a few seconds, it would take several minutes or hours to run a scan using the much larger and slower charting database. This should make sense as when pulling up a chart you are only retrieving data for on symbol, not 10's of thousands at a time.
I think the problem is the timing of when the databases are updated, intraday or current day seems to be a problem, but if I run the scan for 1 or more days ago the results are correct.
Best option here is for you to send in a request to StockCharts thru the support page tab detailing the problem. I'll do the same thing.
Gord