You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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

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.