Manually calculate Dividend Yield
Author: girishbhatia
Creation Date: 5/21/2016 8:45 PM
profile picture

girishbhatia

#1
When I plot the Dividend Yield fundamental item, it goes back to only 5-6 years. However, the price chart shows the Dividend annotation for much beyond this timeframe. How can I manually calculate the Dividend Yield, both on a TTM and MRQ? I have obtained the Nasdaq provider data that contains the data, and am unsure how to manually calculate this. When I use the Nasdaq provided data to calculate the Divided Yield, I get incorrect data.

Appreciate any pointers.

Thanks,
G

Edit: I'm using the following line to calculate the Dividend Yield.

CODE:
Please log in to see this code.
profile picture

Eugene

#2
QUOTE:
How can I manually calculate the Dividend Yield, both on a TTM and MRQ?

Please see the FAQ > How can I get TTM, MRQ and FTM values of estimated earnings?

Dividend yield can be calculated like this:
CODE:
Please log in to see this code.


Considering that FundamentalDataSeriesAnnual is buggy you would want to use a workaround i.e. FDSeriesAnnual (user function) or FundamentalDataSeries (built-in):

CODE:
Please log in to see this code.


profile picture

girishbhatia

#3
Awesome! Many Thanks.