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 March 2025, in the thread "Re: OT, out", Umm asked the members: "Do you think it is because America is made up of magical soil that makes businesses based in America magically profitable?" 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 ✹✺🐝 SILVER
SHREWD
  😊 😞

Number: of 6243 
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,227 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