Hi, Shrewd!        Login  
Shrewd'm.com 
A merry & shrewd investing community
Best Of MIBest OfAll BoardsThe Shrewd’m WeeklyLearn to InvestHow to Become Shrewd
Search
Shrewd'm.com Merry shrewd investors
Search
Best Of MIBest OfAll BoardsThe Shrewd’m WeeklyLearn to InvestHow to Become Shrewd


The week's question
In December 2024, in the thread "Re: BRK: Why Not XOM?", BreckHutHigh asked the members: "What about the long road trips with kids?" This week it is put to everyone again. The button below opens the small thread re-asking it - read what others have said so far, then give your own answer as an ordinary reply.
Answer this questionContinue to Shrewd'mThis note won't appear again
Investment Strategies / Mechanical Investing
Unthreaded | Threaded | Whole Thread (7) |
Author: mungofitch 🐝🐝🐝 GOLD
SHREWD
  😊 😞

Number: of 6132 
Subject: Re: Data for "Total Return - 26 wk"
Date: 06/18/26 10:54 AM
Post New | Post Reply | Report Post | Recommend It!
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
Post New | Post Reply | Report Post | Recommend It!
Print the post
Members reply directly to mungofitch here — and replies get answered. Reading is free; so is joining the conversation. Join Shrewd'm »
This community has written 6,115 posts about Mechanical Investing. The article-length ones it recommended most:
Dividend investing · 52 recs · 2025
Non-Mag7 screen · 34 recs · 2025
OT - Div yields and returns · 32 recs · 2024
Using AI to generate backtesting programs · 30 recs · 2025
Rankings for 19Dec2022 · 29 recs · 2022
Unthreaded | Threaded | Whole Thread (7) |


Announcements
Mechanical Investing FAQ
Contact Shrewd'm
Contact the developer of these message boards.

Best Of MI | Best Of | Favourites & Replies | All Boards | Followed Shrewds | Open Questions | Moving a community