Numbers, (My Stocks)

I see this as a problem with the data being fed to Numbers by Yahoo, not with the function. I can enter a stock such as MUX and its price has four places after the decimal. So the function is capable of providing the additional decimals if it is given them.

I assume the STOCK function (the one you are having problems with) is pulling data from a different place at Yahoo Finance than STOCKH (the one that is giving you the correct number of decimal places).

I put the symbol MUX into the Portfolio table and the resulting price had four decimals. SEC rules state that. for the US markets, quotes for stocks <$1 have four decimals, those above $1 have two decimals. Here is my screenshot from earlier today. I chose MUX because it was <$1.

I did not try MUX in the 30-day history chart until a few minutes ago and there I see no prices with four decimals, three is the maximum for all date I checked. I find that hard to believe, especially because yesterday's close is the price shown in my screenshot below.

Your stock is quoted in pence online but STOCK and STOCKH return it in pounds. In pence the price needs only two decimals. In pounds it needs four. Somewhere along the line Yahoo is screwing it up. That is my take on the problem.

Hope they can sort out your particular detail. But my advice still stands.

Do not expect Numbers, or Excel or other spreadsheet, to be a full substitute for proper portfolio tracking or trading software that has access to professional data feeds.

Yahoo! Finance is consumer-grade. With or without Numbers, it is fantastically useful for many of us, especially given its price. But it's not meant for precision work, which appears to be what you are expecting.

SG

Can you provide an example stock symbol? The data is from Yahoo Finance. Does Yahoo have it with three decimals?

I was writing a response at the same time as you. I am not so sure I trust MUX either now that I have gone back after the markets opened. The best I see is three decimals, even though it was four this morning. Not a single date in history has all four, at least none that I found. Not even yesterday, which closed at 0.9055, now rounded to 0.9060.

I think you'll be happier using Numbers (or any other spreadsheet) as a convenient tool to conduct analysis, rather than as a precise tool to track small price differences.

If you need to worry about the third decimal point then you probably should be using a more specialized tool designed for traders and investors.

SG

Numbers gets its data from Yahoo! Finance.

Here they they are, compared (using the My Stocks template at File > New in your menu):

SG

1. That trading volume is trading volume per day, not a cumulative number. As trading has increasingly fragmented across different markets and into after hours, that volume number tells you less than it once did, but can give you an idea of a general trend.
2. Those charts (which appear to be "performance charts" and not "portfolio valuations") seem to be different. You don't show the whole charts including the symbol(s) and whatever other criteria you specified, so it's impossible to what the differences are.

SG