google-sheetsgoogle-finance

Issue regarding getting dividend yield in google sheets from google finance


I am having an issue with getting dividend yield from google finance in google sheets.

I am using this formula =GOOGLEFINANCE("MSFT","yieldpct")

,but this returns a error "Formula parse error"

Am I missing something here ? Is there a need for additional parameters ?


Solution

  • The googlefinance() documentation states that this particular attribute yieldpct is reserved for mutual funds and not stock tickers

    enter image description here


    its working good with mutual funds tickers

    enter image description here