Hi, Shrewd!        Login  
Shrewd'm.com 
A merry & shrewd investing community
 Best Of MI | Best Of | Favourites & Replies | All Boards | Post of the Week!
Search MI
Shrewd'm.com Merry shrewd investors
Best Of MI | Best Of | Favourites & Replies | All Boards | Post of the Week!
Search MI

Investment Strategies / Mechanical Investing
Unthreaded | Threaded | Whole Thread (16) |
Author: TPOTO-2023   😊 😞
Number: of 3958 
Subject: Re: New Highs and New Lows
Date: 04/24/2023 5:20 PM
Post New | Post Reply | Report Post | Recommend It!
No. of Recommendations: 4
Thank you, Flying Circus for your spreadsheet.

From your example, I tried weekly data on Amazon.

Some interesting results if you change/pick/optimize the
two criteria values:
1- how far to lookback to count new highs/lows
2- how far to sum those counts

If you do your own spreadsheet, I encourage you to
plot the results vs viewing just the final numbers.


										
		 # WEEKS 	# WEEKS 			
		 LOOKBACK 	TO SUM AND 			
		 COUNTING 	DETERMINE			
		 HIGHS/LOWS 	BUY/SELL
	                                       SWITCHING   B&H          5/25/98
						                       START
Excel optimizer	>16 	          37	        736.52 	 106.96 	 0.367 
		 31 	          31	        437.17 	 	
		 27 	          27	        244.88 	 	
		 12 	          12	         85.18
Post New | Post Reply | Report Post | Recommend It!
Print the post
Unthreaded | Threaded | Whole Thread (16) |


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

Ticker or Board Name Author

Best Of MI | Best Of | Favourites & Replies | All Boards | Followed Shrewds