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.

User profile for user: pyeboy
pyeboy Author
User level: Level 1
8 points

Problem with Annual Dividend Formula in Numbers for UK stocks

I am trying to get my document to auto fill the "Annual Dividend" of a UK stock, but it is just showing a value £0.00. The formula STOCK(SYMBOL Apple Inc.,"annual dividend") seems to work just fine for US stocks like Apple. Anyone had the same problem with UK stock?


See below it is showing the Apple annual dividend okay, but not a UK stock when using the same formula. Its strange as it seems to find the yield and market price okay.



Any help would be much appreciated!

Posted on Sep 5, 2020 8:34 AM

Reply
Question marked as Top-ranking reply
User profile for user: SGIII
SGIII
User level: Level 8
36,134 points

Posted on Sep 5, 2020 11:23 PM

pyeboy wrote:

Its strange as it seems to find the yield and market price okay.


If you have the yield and the price then you could just estimate the annual dividend from those.


=price*yield


SG

View in context

Similar questions

3 replies

Problem with Annual Dividend Formula in Numbers for UK stocks

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