Cash Per Share (Historical) Formula in Excel

Leverage the Cash Per Share (Historical) formula in Excel to quickly retrieve a company's historical cash per share data using MarketXLS. This function helps investors and analysts perform fundamental analysis, compare performance across multiple reporting periods, and identify trends in a company's liquidity and cash position.

Understanding Cash Per Share (Historical)

Cash Per Share (Historical) provides a historical view of how much cash is available per outstanding share for a given company (or other symbols like indices, options, or cryptocurrencies).

• Helps you evaluate a company's liquidity.
• Useful for fundamental analysis and stock valuations.
• Ideal for comparing trends across different quarters, years, or trailing twelve months (TTM).

Syntax and Parameters

Below is the syntax for the Cash Per Share (Historical) formula in Excel:

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

?? Note: If an invalid symbol or input is provided, or if your MarketXLS license is not valid for this function, it returns "NA".

Return Value

This formula returns a numeric value representing the historical cash per share for the specified symbol. If the data is unavailable or an error occurs, it returns "NA".

Examples and Usage

Below are several ways to use hf_Cash_per_Share in Excel:

1. Basic usage for a specific year:

   =hf_Cash_per_Share("MSFT", 2022)

   Retrieves Microsoft's cash per share for the year 2022.

2. Specify a quarter:

   =hf_Cash_per_Share("MSFT", 2022, 2)

   Returns the value for the second quarter of 2022.

3. Trailing twelve months (TTM):

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

   Returns the trailing twelve months cash per share from Q3 2022.

4. Last and previous relative periods:

   • Last quarter:

     =hf_Cash_per_Share("MSFT", "lq")

   • Last quarter minus one:

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

   • Last year:

     =hf_Cash_per_Share("MSFT", "ly")

   • Last 12 months:

     =hf_Cash_per_Share("MSFT", "lt")

? Pro Tip: Combine date references with cell references or functions. For example:
• Cell Reference:

=hf_Cash_per_Share(A1, 2022)

• Direct Date Text:

=hf_Cash_per_Share("MSFT", "2022")

Common Questions

1. What happens if I use an invalid symbol?
   If you use an invalid symbol or a symbol not covered under your plan, the function returns "NA".

2. Is the function suitable for cryptocurrencies, indices, and options?
   Yes. Just ensure you use the correct symbol format, such as "@MSFT 110122C00020000" for options, "^SPX" for indices, and "BTCUSD:DEFAULT" for cryptocurrencies.

3. Can I use different date formats for the year parameter?
   Absolutely. Alongside standard years like "2023", you can also use references like "lq" (last quarter) or "ly" (last year) for more flexible calculations.

4. Does the function handle TTM data automatically?
   Yes. Include the optional "TTM" parameter to retrieve trailing twelve months data. Otherwise, it defaults to periodic data.

5. What if no data is available for the specified period?
   If data is missing or not released for that timeframe, the function returns "NA".

?? Note: Use MarketXLS with an appropriate subscription plan to gain full access to historical fundamentals.