Dividends Per Basic Common Share (Historical) Formula in Excel

Get quick access to a company's historical dividend-per-share data using the Dividends Per Basic Common Share (Historical) formula in Excel with MarketXLS. This function helps you stay updated on how much dividend is distributed to each ordinary share holder, making it an essential tool for investors, analysts, and financial professionals.

Understanding Dividends Per Basic Common Share (Historical)

• Purpose and Use Cases
  The hf_Dividends_per_Basic_Common_Share function provides the dividend amount allocated to each basic common share over various historical periods (quarters, years, or trailing twelve months).
• Key Benefits
  • Quickly retrieve historical dividend-per-share information directly in Excel.
  • Ideal for tracking dividend trends over time.
  • Great for comparative analysis across different stocks.
• When to Use
  Use this formula when analyzing a company’s dividend-paying history, comparing dividend policies across periods, or evaluating payout consistency.

Syntax and Parameters

=hf_Dividends_per_Basic_Common_Share(Symbol, year, [quarter], [TTM])

?? Note: If the symbol is invalid or if your MarketXLS historical fundamentals subscription is not active, the function returns "NA".

Return Value

• Returns a numeric value representing the dividend-per-share for the specified period.
• If data is not available or an error occurs, returns "NA".

? Pro Tip: You can reference dates in multiple ways for the year parameter:
• Cell reference with date (e.g., =hf_Dividends_per_Basic_Common_Share(A1))
• Direct date input (e.g., =hf_Dividends_per_Basic_Common_Share("2024-03-15"))
• Excel TEXT function (e.g., =hf_Dividends_per_Basic_Common_Share(TEXT(A1,"yyyy-mm-dd")))

Examples and Usage

Below are common examples illustrating how to use the hf_Dividends_per_Basic_Common_Share function:

1. Retrieve dividend per share for a specific year:

   =hf_Dividends_per_Basic_Common_Share("MSFT", "2022")

2. Fetch data for a particular quarter:

   =hf_Dividends_per_Basic_Common_Share("MSFT", "2022", 2)

3. Get trailing twelve months (TTM) from a specified quarter:

   =hf_Dividends_per_Basic_Common_Share("MSFT", "2022", 3, "TTM")

4. Use special keywords for last year or last quarter:

   =hf_Dividends_per_Basic_Common_Share("MSFT", "lq")
   =hf_Dividends_per_Basic_Common_Share("MSFT", "ly-1")

5. Combine custom offsets (e.g., last quarter minus one quarter):

   =hf_Dividends_per_Basic_Common_Share("MSFT", "lq-1")

6. Last twelve months data:

   =hf_Dividends_per_Basic_Common_Share("MSFT", "lt-1")

?? Note: Large data requests or slow internet connections may affect performance. Keep your queries specific to avoid heavy loads.

Common Questions

1. What if I get "NA" as a result?

   • Check if your symbol is correct, ensure your MarketXLS subscription is active, and verify you have the historical fundamentals add-on.

2. How do I choose the correct quarter?

   • Quarters follow the calendar year: 1 for Q1 (Jan–Mar), 2 for Q2 (Apr–Jun), etc. When in doubt, refer to the company's exact reporting periods.

3. Can I use this formula without a MarketXLS subscription?

   • No. A valid MarketXLS historical fundamentals subscription is required to retrieve the data.

4. Is there any limit on how many times I can call the function?

   • Usage limits depend on your MarketXLS plan. Refer to your plan’s usage details.

5. Are there any alternative functions for related fundamentals?

   • Yes! Here are some related historical fundamental functions in MarketXLS:
     • Revenue (Historical): Returns the company’s total revenue for a specified historical period.
     • Cost Of Revenue (Historical): Returns the company’s total cost of revenue.
     • Gross Profit (Historical): Retrieves the gross profit for a specified historical period.
     • R & D Expenses (Historical): Shows the research and development expenses.
     • Selling General and Administrative Expense (Historical): Returns SG&A expenses for a specific period.

? Pro Tip: Combine fundamental functions (e.g., revenue, net income, dividends) to perform deeper ratio analysis directly in your Excel workbook.