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: Rabelais   😊 😞
Number: of 5386 
Subject: Re: Signals
Date: 01/12/26 3:52 PM
Post New | Post Reply | Report Post | Recommend It!
No. of Recommendations: 7
You can also open Yahoo history directly using Excel VBA with:

Workbooks.Open "https://finance.yahoo.com/quote/SPY/history/"

This will give you the last year.

Workbooks.Open "https://finance.yahoo.com/quote/SPY/history/?perio..."

This will give you the last five years (to today 1/12/26).

JRB
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