Dividend Per Share (TTM) Formula in Excel

The Dividend Per Share (TTM) formula in Excel with MarketXLS allows you to quickly retrieve the total dividend paid by a company over the trailing twelve months (TTM). This function is especially useful for dividend-focused investors looking to compare and evaluate income-generating stocks in real time without having to manually check multiple data sources.

Understanding Dividend Per Share (TTM)

  • Purpose: Retrieves the total dividends paid by a company over the past 12 months.
  • Key Benefits:
    • Streamlines dividend analysis for stocks and other tradable entities.
    • Integrates easily with Excel for quick calculations and analysis.
  • When to Use:
    • Evaluate the regularity and amount of dividend payments.
    • Compare dividend payouts across multiple symbols or market indices.

Syntax and Parameters

Use the following syntax to call the DividendPerShare function:

=DividendPerShare(Symbol)
Parameter Description Required Example
Symbol The ticker or identifier for the asset (stock, index, etc.) Yes "MSFT"

Return Value:

  • The function returns a numeric value representing the total dividend amount distributed over the trailing twelve months.
  • If the symbol is invalid or data is unavailable, the function returns "NA".

?? Note: A valid MarketXLS license and an active internet connection are required for this function to work properly.

Examples and Usage

Below are a few examples showing how to use the DividendPerShare formula with different symbol formats:

  1. Regular Stock Symbol:

    =DividendPerShare("MSFT")
  2. Index Symbol:

    =DividendPerShare("^SPX")
  3. Options Symbol:

    =DividendPerShare("@MSFT 110122C00020000")
  4. Cryptocurrency Symbol:

    =DividendPerShare("BTCUSD:DEFAULT")

? Pro Tip: Combine this function with other MarketXLS dividend-related functions, such as ExDividendDate or DividendYield(TTM), to create a comprehensive dividend tracking dashboard.

Error Handling

  • If the symbol parameter is missing or invalid, the formula returns NA.
  • If your MarketXLS license is inactive or expired, you may see NA.

Special Cases and Limitations

  • Non-dividend-paying stocks will naturally return 0.
  • Occasionally, data could be updated with a slight delay, so ensure your network connection is stable.

Performance Considerations

  • The function fetches data via an API call, so performance depends on your computer’s internet speed and the MarketXLS service responsiveness.
  • Caching mechanisms may speed up repeated queries for the same symbol.

Common Questions

  1. Why am I getting “NA” even though my symbol is correct?

    • Check your internet connection and ensure your MarketXLS license is active.
  2. How frequently is the data refreshed?

    • MarketXLS typically updates data several times per day. Exact refresh intervals can vary.
  3. Best practices for using Dividend Per Share (TTM) in my spreadsheet?

    • Maintain a dedicated column for ticker symbols and reference them using cell references (e.g., =DividendPerShare(A2)) to handle large data sets efficiently.
  4. How do I compare multiple symbols quickly?

    • Create a table of symbols in one column and use the DividendPerShare function for each symbol in the adjacent column. Then, sort or filter as needed.

?? Note: Always verify your data before making any investment decisions.

  • Related dividend functions in MarketXLS:
    • Forward Annual Dividend Yield
    • Ex Dividend Date
    • Dividend Pay Date
    • Dividend Yield (TTM)

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Dividend Per Share (TTM) and Other Financial Formulas
How does MarketXLS work?