Forum Discussion

CALVIN2021

Copper Contributor

Jan 09, 2021

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...

excel

Excel on Mac

Formulas and Functions

CALVIN2021

Copper Contributor

Jan 10, 2021

Thanks Sergei,

I think the MAX() works fine. but it's good to know how to know when was it happened.

I am also thinking about how to calculate its annualized increase in price. getting the price of first-day listing and the current price. Divide them by the amount of time. Sounds like huge work for me.

SergeiBaklan

Diamond Contributor

Jan 10, 2021

CALVIN2021

To ignore errors

Simple MAX() will work the same way if you prefer to have only one column.

I am also thinking about how to calculate its annualized increase in price. getting the price of first-day listing and the current price. Divide them by the amount of time.

Afraid didn't catch what the exact idea is. "annualized" price mean price for the each year, another story is how to calculate. However, in next sentence you say about only two dates - start and current.