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 (44) |
Author: rayvt 🐝  😊 😞
Number: of 6131 
Subject: Re: A mechanical strategy
Date: 03/26/23 1:22 PM
Post New | Post Reply | Report Post | Recommend It!
No. of Recommendations: 5
Doesn't work. Either of them. For the S&P500 (SPY) starting Jan 1950.

I downloaded that spreadsheet and extended it and plugged in the SPY values from Jan'1950 to June'2017. I normalized the "stock price" for a starting value of 10 (SPY was 17.05).

Mark's definition is "Portfolio control = last month's PC + 50% of prev mo trade amount"
so PC will go up when you buy and down when you sell.

That spreadsheet, PC only goes up. PC does not change on a sell.

On the face of it, it seems like Mark's way is more logical. The Control varies up and down as stock is bought or sold.

Mark's way, you never have a buy signal.
SELL 20
BUY 0
Hold 789

6/1/2017 values
Stock: $0
Cash: $3,149

Spreadsheet way is more active.
SELL 64
BUY 5
Hold 740

6/1/2017 values
Stock: $2,843
Cash: $7,237

B&H for initial $2000 of SPY: $284,271
Bigtime fail!!!!!

------------------------------------
"Buy/sell advise = last months portfolio control - this month stock value
Market order = buy sell advise - safe value"
This cannot be right.
If the advise is 0, then the order will be to sell $(safe value) amount.

"Is there a place where I can upload a spreadsheet."
Upload to dropbox. Or upload to a google sheets.
Either way, share the link.

-------------------------
Critique:
What he calls "SAFE" is what I'd call "threshold to take action" or "guiderail". It is a percentage of the current STOCK value. He uses 10%. That seems to be a very large percentage.
Then it computes the excess (above that threshold) and calls for a buy/sell of the amount of excess but ONLY if the order is for more than 5% of the current cash. That seems...odd. It works to moderate the change of cash.

All in all, it seems to me like he started with some particular stock and adjusted the threshold values until it gave him a result that he liked. As we used to say, Torture the numbers until they confess.
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 (44) |


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