Forum Discussion
CALVIN2021
Jan 09, 2021Copper Contributor
Get historical high with StockHistory function
HI all, Since the stock data types can only get 52 weeks high, I turned to see if Stockhistory function can get the job done. However, with that function, I get a whole list of data, how can I tu...
mathetes
Jan 09, 2021Gold Contributor
Try this: =MAX(STOCKHISTORY("TSLA","1/1/1950",TODAY(),0,0,3))
Let me know if that's what you were looking for.