Dividends

Track dividend yields and analyze dividend metrics using MarketXLS functions directly in Excel.

Dividends schema

How To Track Dividend Yield Using MarketXLS Software?

1

Search for Dividend Functions

Go to the MarketXLS tab in the ribbon and hover over the search & help option. Type "dividend yield" in the search panel. You will notice a list containing an ample amount of functions related to the dividend yield along with their short descriptions like dividend yield, forward annual dividend yield, 5-year average dividend yield, dividend record date, etc. Search for the one you need.

Dividend in functions filter in Excel
2

Apply the Function

Now go to the cell, type the function chosen and select the ticker symbol. Press enter. Use flash fill to perform the same function for all the stocks. You will see the list of dividend yields of different stocks.

Dividend yield MSFT selected
3

Add Additional Metrics

Similarly, you can also find out all the other dividend information related to stocks. Here I have also used the function of dividend payout ratio, according to my analysis requirement before investing in a stock.

Dividend payout ratio

Comprehensive Market Data

With the help of MarketXLS, you can stream market data for stocks, ETFs, options, mutual funds, currencies refreshed, or refresh on-demand. You can find all the important fundamental ratios and analyses in a few clicks. You can also get all the historical data (EOD, Intraday) you may need with MarketXLS functions. Update the Excel tables dynamically and save your time in formatting those tables.

Example Function

Use this function to get dividend per share for any stock:

Available Dividend Functions

MarketXLS provides a comprehensive set of dividend-related functions including:

  • Dividend Yield: Current annual dividend as a percentage of stock price
  • Forward Annual Dividend Yield: Expected dividend yield for the next year
  • 5-Year Average Dividend Yield: Historical average over the past 5 years
  • Dividend Record Date: Date to be on record to receive dividend
  • Dividend Per Share: Amount paid per share
  • Dividend Payout Ratio: Percentage of earnings paid as dividends (learn more)
← Previous: Historical Fundamental FunctionsNext: Custom Beta →