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 (130) |
Author: rayvt ✧🐝  😊 😞
Number: of 5822 
Subject: Re: Chart: timing with Nas100 RS screen
Date: 06/14/26 11:02 PM
Post New | Post Reply | Report Post | Recommend It!
No. of Recommendations: 1
In Google Sheets ...

The formula "=GOOGLEFINANCE(J4, "price", today()-365, today(), "daily")" delivers 250 daily closing prices, dated 6/16/2025 through 6/12/2026.
Today being 6/14/2026.

So, data for all the market days in the last 365 calendar days. How's that for doubly confusing?

For weekly it delivers 53 weeks of prices, dates 6/13/2025 through 6/12/2026.

p.s., I run my timings daily in a Linux bash script. For my kids, I gave them a google sheet link that they can look at over the weekend.
Post New | Post Reply | Report Post | Recommend It!
Print the post
Unthreaded | Threaded | Whole Thread (130) |


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