Hey Staff,
I would like to point out that both DaysSince and BarsSince return “NA” if date is “as of” date. To me, this is not desirable behavior. I would think that same day should return “0”.
For example, if “as of” date on screener is set to day 5/13/2018 (today):
- DaysSince(20180513) will return “N/A”;
- DaysSince(20180512) will also return “N/A”;
- DaysSince(20180511) will return “0”; and,
- DaysSince(20180510) will return “1”.
Thx.
//dpa
P.S. - An earlier version of this thread reported a bug which was actually user error. My apologies.
Unfortunately, this is more a quirk with the screener than it is with the functions. The screener currently sets the transaction date to the last trading date, since it doesn’t have prices for today or tomorrow. Because of all this, you get the same results you would have seen on Friday.
Enhancements could be made in order to support this use case, and it would also improve the accuracy of other factors relying on the transaction date (DaysFromMergerAnn, PrevBarDaysAgo, WeekDay, et al.).
Aaron,
Based upon discussions with other users, I think a lot us rely on the screener, especially around earnings season, to detect changes and earnings releases / conference calls. The current behavior seems to unnecessarily induce a 1 day information lag. I know you guys have a lot on your plate, so I would defer to your judgement as to whether any enhancements are necessary.
Thank you,
//dpa