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

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?