Stock Annual Dividend function results

You could try selecting the cell with the old data and hitting <delete>. Then reenter the STOCK formula.

SG

Unfortunately, this is one of those problems we cannot duplicate and try different things on because we can't go back in time to get the old result. I am unaware of any documented way to clear the cache. I find it surprising that it doesn't update itself. My guess is that it is getting no data for the dividend now, similar to what would happen if you were offline, so it uses the previously stored value. But, because it will never get an update for that parameter from Yahoo, it will never fix itself.

Just taking a swing at it here, what would happen if you copy the formula from your other document (the one with the error for a dividend) and paste it into this messed up one? If that doesn't work, try it when not connected to the Internet. I know if I am not connected to the Internet and I do this with a STOCK formula set to "price" it brings with it the price from the other document. But I don't know if it will overwrite something that is already there, I've only tried it on a new document.

Also Yahoo! Finance sometimes does not seem to feed stock annual dividend into Numbers. A good workaround is to estimate the annual dividend by having STOCK retrieve the Yield, and multiply that by Price.

SG