Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Search for stocks (e.g., AAPL, GOOGL, AMZN)
OR logo

OR

NYE
Osisko Gold Royalties Ltd
Basic MaterialsGold
Watchlists:
Last updated: Friday 18th July 2025
27.08
-0.52 (-1.88%)
Prev Close:27.6
Open:27.22
Bid:26.69
Ask:28.05
52 Week Range
15.78
28.22
Volume:858,097
Mkt Cap:5,157 M
Price Target
$31.14
+15.0%

Dividend Yield (TTM)

Live
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.

Notes

TTM dividend/ Price

Assets

Stocks, ETFs