Forum Discussion
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...
OMG, just found out the max price is unadjusted. It doesn't take into account the effect on the price for share splitting. cry
You wrote: OMG, just found out the max price is unadjusted. It doesn't take into account the effect on the price for share splitting.
Not true: try entering this formula -- giving yourself lots of room.
=STOCKHISTORY("AAPL",DATE(1980,1,1),TODAY(),,,0,3)
The prices are most assuredly adjusted for splits.
So wipe off those tears.