Hi, in my screener I have a proportion of results which are valid according to the criteria, but are not current. The last value should be from say Friday 29th December 2017, but some of the results I get the instrument stopped trading in July. Clearly no use if I wish to trade it!
It would be good to filter out the instruments which show no bars in this month. Maybe more accurate would be to show only instruments which have bars for today, though this might pose a problem when running the screener on a non trading day (weekend or public holiday).
Thx
P
Could you please share with us an example of this behavior? As I don’t understand clearly the question/request. Thank you.
Hi Nicolas,
an example would be that my CCI screener returns a match on the instrument “FSS” Short sterling Dec 20. If you look it up you should see what I see, this actually refers to 20 Dec 2016 and the last date for trading was 20/12/2016.
Its no use to me, I cannot trade it, it’s past.
So I would like to filter these non results in some way.
I thought that at least one could try to test if the last bar belonged to today, there could be limitations if the screener was run on a weekend, but then we should really be doing better things with our weekend right?
Cheers
Philip
You can refine conditions that happen today with:
test = today=date
But it would be much easier if you could share you code.