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

Dividend Yield (TTM)

Returns the dividend yield, a ratio indicating the percentage of a company's share price paid out in dividends annually.

How calculated

It is calculated by dividing the ttm dividend (dividend per share) by previous day's closing price.

Example usage

=DividendYield("MSFT") - Returns the TTM dividend yield for MSFT.


TTM dividend/ Price


Stocks ETFs

Top 10 Sectors with High Dividend Yield

Top 10 High-Yield Dividend Stocks