Forum Discussion

Copper Contributor

Mar 08, 2023

Solved

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

Formulas and Functions

Patrick2788
Mar 08, 2023
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

2 Replies

Patrick2788
Silver Contributor
Mar 08, 2023
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
- Ray_Eaton100
  Copper Contributor
  Mar 08, 2023
  Patrick2788
  
  Thanks... I'll give it a try. Ray

Resources