Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS

Dividend Yield (Historical)

Live
The dividend yield, expressed as a percentage, is a financial ratio (dividend/price) that shows how much a company pays out in dividends each year relative to its stock price.

How calculated

Dividend / Price

Example usage

=hf_Dividend_Yield("MSFT",2021) - Returns the value for the year 2021.
=hf_Dividend_Yield("MSFT",2021,2) - Returns the value for the year 2021 and the calendar quarter 2
=hf_Dividend_Yield("MSFT",2021,3,"TTM") - Returns the value for the year 2021 and trailing twelve months from the calendar quarter
=hf_Dividend_Yield("MSFT","lq") - Returns the value for the last quarter
=hf_Dividend_Yield("MSFT","lq-1") - Returns the value for the last quarter-1
=hf_Dividend_Yield("MSFT","ly") - Returns the value for the last year
=hf_Dividend_Yield("MSFT","ly-1") - Returns the value for the last year - 1
=hf_Dividend_Yield("MSFT","lt") - Returns the value for the last 12 months.
=hf_Dividend_Yield("MSFT","lt-1") - Returns the value for the previous last 12 months.

Notes

If a company’s dividend yield has been steadily increasing, this could be because they are increasing their dividend, because their share price is declining, or both. Depending on the circumstances, this may be seen as either a positive or a negative sign by investors.

Assets

Stocks