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:
-
Regular Stock Symbol:
=DividendPerShare("MSFT")
-
Index Symbol:
=DividendPerShare("^SPX")
-
Options Symbol:
=DividendPerShare("@MSFT 110122C00020000")
-
Cryptocurrency Symbol:
=DividendPerShare("BTCUSD:DEFAULT")
? Pro Tip: Combine this function with other MarketXLS dividend-related functions, such as
ExDividendDate
orDividendYield(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
-
Why am I getting “NA” even though my symbol is correct?
- Check your internet connection and ensure your MarketXLS license is active.
-
How frequently is the data refreshed?
- MarketXLS typically updates data several times per day. Exact refresh intervals can vary.
-
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.
- Maintain a dedicated column for ticker symbols and reference them using cell references (e.g.,
-
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.
- Create a table of symbols in one column and use the
?? 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)