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 (39) |
Author: rayvt 🐝  😊 😞
Number: of 6132 
Subject: Re: new screen based on Nasdaq100
Date: 05/26/25 9:29 AM
Post New | Post Reply | Report Post | Recommend It!
No. of Recommendations: 7
Here's a different view of the Portfolio Visualizer comparison - 10 years only.

Portfolio Visualizer being limited to 10 years is a big problem but is good as a "sanity" cross reference.
Did you look at the testfolio link I posted? When I first learned of testfolio I did several cross-checks with PV and found they agreed, so I feel confident in it.

Also, as I mentioned, the annual rebalance backtest gives an artificially high CAGR because of the fortuitous interaction with the 2022 mini-crash. To get a more realistic number you need to look at semiannual or quarterly.

Or, make 12 annual rebalance runs beginning with each month, then take the average. When you plot the value curves on one chart, there is a startling divergence around 2022, looks like an open shark's mouth, some went up and some went down. Other than that, all 12 curves track tightly.
(I did all this with Excel 2003.)

The historical reference information is... difficult... to get at these days.

Yes. But with a bit of cleverness you _can_ get it. Of course, what you need is the "adjusted close" prices, which includes dividends.

-------------

The BIG problems is the inception dates of BTAL(9/2011) and TQQQ (2/2010). That period doesn't include things like the bear markets of 2001 & 2008.

I have a feeling that TQQQ would get absolutely crushed in a bear.
The 2022 downturn, S&P500 lost -20%, TQQQ lost -80%, QQQ lost -34%.
Jan 2001 to Oct 2002, SPY lost -31% and QQQ lost -53%.

And the issue right now is that everybody thinks a bear market is overdue. ;-(

I played around a little bit trying to find a timing method for TQQQ and didn't find one that worked good enough.
Post New | Post Reply | Report Post | Recommend It!
Print the post
Members reply directly to rayvt 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 (39) |


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