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: Philly Tide   😊 😞
Number: of 3957 
Subject: Re: New Highs and New Lows
Date: 04/21/2023 10:11 AM
Post New | Post Reply | Report Post | Recommend It!
No. of Recommendations: 9
Here are the Excel formulas I calculated for this. Hope it saves others some time.

Assuming row 14 (4/1/22) thru 21 (9/1/21)

Column E
=IF(B14=MAX(B14:B20),1,0)

Column F
=IF(C14=MIN(C14:C20),1,0)

Column G
=SUM(E14:E20)

Column H
=SUM(F14:F20)

Column I
=IF(G14>=H14,1,0)
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