Post #5684 by Pandrea on the Mechanical Investing board

Please be respectful of others' privacy, and avoid sharing personal information or sensitive content without their permission. If you are unsure if something is appropriate to share, ask for permission (use the 'Privately email' option when replying to their post) or avoid sharing it altogether.

- Manlobbi

Investment Strategies / Mechanical Investing

Unthreaded | Threaded | Whole Thread (130)

Prev | Next

Post New | Post Reply | Report Post | Recommend It!

No. of Recommendations: 1

Rayvt wrote:
"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".

---

Oh.. my.
All I can say, is thank you for your patience.

Post New | Post Reply | Report Post | Recommend It!

Print the post

Unthreaded | Threaded | Whole Thread (130)

Prev | Next

Announcements

Mechanical Investing FAQ

Contact Shrewd'm
Contact the developer of these message boards.

A community forum supporting civilized, and highly helpful, self-educating investors that come together for Shrewdness and merry spirits. These message boards closely follow the look and feel of the old message boards at boards.fool.com prior to the boards redirected to discussion.fool.com. Shrewd'm is not affiliated with the comprehensive and excellent investment website, The Motley Fool (TMF), in any way. The Shrewd commmunity here has owed, and continues to owe, gratitude to The Motley Fool for nurturing a culture of jovial irreverence towards Wall St, and that tradition will continue here.