Is there an API call to use in a Google Spreadsheet to get a stock's Dividend Yield (% annual yield)
To further help with this answer. I tried tb11's answer and did not work for me June 2019. It was the URL that was the issue. I picked another site with a simpler URL and it worked for me. Sample below.
Google, if you could please add an API to allow us to get the divided yield easier, Thanks!!!
I used to be able to pull it from google finance, but that stopped working for me a little while back. I found another one. It's not quite as clean, but it is working for me as of March 2019.
In column B, put your ticker symbol
In column C:
=IF(NOT(ISBLANK(B12)),GoogleFinance(B12,"Price"),"")This will populate the current price, which is used in the next step to calculate the yield
In the column where you want the dividend yield,
Yes, you can use:
This will display the distribution yield for Fidelity Contrafund Fund (aka. FCNTX). According to their docs:
"yieldpct" - The distribution yield, the sum of the prior 12 months' income distributions (stock dividends and fixed income interest payments) and net asset value gains divided by the previous month's net asset value number.
Full docs here: https://support.google.com/docs/answer/3093281?hl=en