No. of Recommendations: 4
The VL database includes columns for Total Return - 1,4,13,26,52 weeks. All of them are updated each week, except for 52 which is updated monthly.
Except when they forget to update the database.
For example, the total return fields were bad or missing on these weekly data release dates:
2025-01-06
2025-01-13
2025-01-20
2025-01-27
2025-02-03
2025-02-10
2025-02-17
2025-02-24
2025-03-03
2025-03-10
2025-07-07
So, you have to do a visual spot check to make sure the current TR field values are sane. The quickest sign of problems is that the TR fields are blank, or identical to each other for a given stock.
Stock prices are all garbage even more often, and the quickest check is to check Microsoft: if the MSFT price is two digits instead of three, it's wrong. When it's wrong, it usually says $92.31 for some unknown reason. The good news is that, as far as I know, either the stock prices are all good, or all bad. In weeks that the stock prices are bad, all the P/E ratios are also bad.
The total return fields are calculated based on the number of weeks in the name of the field, except for 52 week, which is actually one year total return landing at the end of a calendar month. It's updated monthly in the first weekly data release that's at least a little after a month end. I'm not sure, maybe the data release that's around 6-13th of the month??
Jim
