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


Investment Strategies / Mechanical Investing
Unthreaded | Threaded | Whole Thread (16) |
Author: FlyingCircus   😊 😞
Number: of 5383 
Subject: Re: Signals
Date: 01/12/26 12:24 AM
Post New | Post Reply | Report Post | Recommend It!
No. of Recommendations: 10
Google Sheets. Set one up. One tab per index to follow. In the upper left of each sheet, put in this formula:
=googlefinance(".inx","all",today()-366,today(),"DAILY") --today()-### for however many days you want to go back.

Sorted by date descending:
=sort(googlefinance(".inx","all",today()-366,today(),"DAILY"),1,0)

Automatically updated as soon as you open it. No macros, no downloads, no scripts.

Not dividend adjusted, usually.

S&P = .inx
Russell 2000 use IJR
Nas = .ixic
S&P midcap = MDY
all the rest use the representative ETF symbol.

FC
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.

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