Forum Discussion
Ray_Eaton100
Mar 08, 2023Copper Contributor
How to Auto feed stock price to spreadsheet?
I am trying to learn how to auto feed closing stock prices to an excel spreadsheet. Any suggestions on how to learn how to do this would be greatly appreciated. Ray
Patrick2788
Mar 08, 2023Silver Contributor
You could use the STOCKHISTORY function:
https://support.microsoft.com/en-us/office/stockhistory-function-1ac8b5b3-5f62-4d94-8ab8-7504ec7239a8?ns=excel&version=90&syslcid=1033&uilcid=1033&appver=zxl900&helpid=xlmain11.chm60681&ui=en-us&rs=en-us&ad=us
https://support.microsoft.com/en-us/office/stockhistory-function-1ac8b5b3-5f62-4d94-8ab8-7504ec7239a8?ns=excel&version=90&syslcid=1033&uilcid=1033&appver=zxl900&helpid=xlmain11.chm60681&ui=en-us&rs=en-us&ad=us
- Ray_Eaton100Mar 08, 2023Copper Contributor