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

Posted on Jan 18, 2024 8:17 PM

Reply
6 replies

Jan 19, 2024 7:01 PM in response to BeeVeeDub

BVD,


I tried to edit my post below to include a comment I found in a Motley article about overall return from Purchase to Sale. This site refused my edit attempt because it was busy, or tired, or something.


Anyway, their point was that if the stock pays dividends, the dividends should be incorporated in the gain calculation, making the calculation drastically more difficult for the average Joe. My thought was that incorporating the dividends is something that would make a large enough difference that it could lead to the sort of discrepancy you noted above.


Jerry

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Numbers: Trying to find historical data as a percentage

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.