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 (1) |
Author: FlyingCircus   😊 😞
Number: of 6131 
Subject: Fun with DDD3 (should have just indexed)
Date: 05/06/24 5:09 PM
Post New | Post Reply | Report Post | Recommend It!
No. of Recommendations: 12
I calculated the following trailing 14 year stats using a corrected DDD3 formula*.
TOTAL PORT
- between 25% to 90% GTAA, remainder cash depending on market conditions/intermediate signals.small portion was in MI screens until '19.
CAGR (@Apr 2010-Apr 2024): 4%
DDD3: 7.0%

GTAA section (non-cash asset classes, 20-@60% top 4 to 6 by momentum rank (including some Saul-ish growth stocks, Bowley picks and a bad attempt at high Rev/ROE combo), @40-80% preferreds-bonds depending on market conditions / intermediate signals)
CAGR: 5.5%
DDD3: 12.7%

Vanguard Balanced 60/40 Index: (my benchmark)
CAGR: 6.99%
DDD3: 8.7%

S&P 500
CAGR: 11.45%
DDD3: 10.62%

Bear market of '22 hurt me. GTAA was actually crushing VBINX until end of '21 and then... didn't get out with enough or fast enough. Hasn't recovered well since, without the boost of the crazy SaaS bubble of 19-20.

I'm actually matching VBINX for trailing 3 years but nonetheless...a bit deflating to see how much worse my long term risk-adjusted return has been.

FC

* Corrected = learning that Sheets array formula is not like Excel's. This formula in Excel
{=SQRT(AVERAGE(IF(B64:B2520<0,B64:B2520,0)^2))}

has to be rebuilt as
=SQRT(AVERAGE(ARRAYFORMULA(IF(AN9:AN176<0,POWER(AN9:AN176,2)))))
and not with a cute Averageif function. That took way too long (hence the late hour of this post).
Post New | Post Reply | Report Post | Recommend It!
Print the post
Members reply directly to FlyingCircus 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 (1) |


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