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


Stocks A to Z / Stocks B / Berkshire Hathaway (BRK.A)
Unthreaded | Threaded | Whole Thread (9) |
Author: FlyingCircus   😊 😞
Number: of 15061 
Subject: Re: Historical stock data
Date: 11/16/2024 12:45 AM
Post New | Post Reply | Report Post | Recommend It!
No. of Recommendations: 19
A Google Sheet using the =GOOGLEFINANCE(...) function will instantly bring back a lot of data, tabularized, no cutting & pasting or paying extra for services.

There are two patterns - one for stocks & ETFs, the other for mutual funds.
Caveat, the prices/sources are very similar to if not identical to Yahoo Finance. They are not dividend adjusted.

Here's a command for example to bring back 1 year's worth of daily OHLC & Volume for, in this case, IJR:
=sort(googlefinance("IJR","all",today()-365,today(),"DAILY"),1,0)

Several standard individual attributes are available.
https://support.google.com/docs/answer/3093281?hl=...

Then go wild with your own calculations, formula based indicators, specific moving averages, etc.

Outstanding response time, very occasionally down. Happy to share examples if interested.

FC
Post New | Post Reply | Report Post | Recommend It!
Print the post
Unthreaded | Threaded | Whole Thread (9) |


Announcements
Berkshire Hathaway FAQ
Contact Shrewd'm
Contact the developer of these message boards.

Best Of BRK.A | Best Of | Favourites & Replies | All Boards | Followed Shrewds