Numbers: Trying to find historical data as a percentage
I'm using Apple Numbers and I am trying to insert historical stock data as a percentage and nothing that I have been trying is quite working. For example at the time of writing this Apple stock is up 56,615.65% since it's IPO.
I know that I can use the "STOCKH" function to get the price at which APPL IPO'd at (12/12/1980) which returns "$0.13". And I can use STOCK to get a current stock price of AAPL = $182.68. But this returns a gain of approx. 142385.03% not the 56,615.65% mentioned above.
What am I doing wrong and is there a better/simpler way to do what I am trying to do?
Mac Pro