Preferred Securities Of Subsidiary Trust (Historical) Formula in Excel

Discover how to leverage the “Preferred Securities Of Subsidiary Trust (Historical)” formula in Excel with MarketXLS to quickly retrieve trust-preferred securities information for a specified company and time period. This function provides valuable insights into the trust-preferred securities issued by a bank-holding company’s wholly-owned trust subsidiary.

Understanding Preferred Securities Of Subsidiary Trust (Historical)

• Purpose and Use Cases
  The formula helps you analyze historical trust-preferred securities data issued by banks, vital for in-depth fundamental analysis.
• Key Benefits
  • Quick retrieval of historical values in Excel
  • Flexible parameters for year, quarter, and trailing twelve months (TTM)
  • Streamlined analysis for financial modeling and trend observation
• When to Use
  Use this formula when you need a snapshot of a company’s trust-preferred securities data for specific historical periods.

Syntax and Parameters

Below is the general syntax for the hf_Preferred_Securities_of_Subsidiary_Trust function:

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

Return Value:
• A numeric value if successful (which may be converted to a double in Excel).
• Returns "NA" if the symbol is invalid or the data is not available.

Error Handling:

• If an invalid symbol is provided, the function returns "NA".
• License limitations can also trigger "NA".

?? Note: This function is part of MarketXLS Historical Fundamentals and may require a valid MarketXLS subscription plan.

Examples and Usage

Below are some practical examples showcasing different parameter formats:

=hf_Preferred_Securities_of_Subsidiary_Trust("MSFT", 2022)
=hf_Preferred_Securities_of_Subsidiary_Trust("MSFT", 2022, 2)
=hf_Preferred_Securities_of_Subsidiary_Trust("MSFT", 2022, 3, "TTM")
=hf_Preferred_Securities_of_Subsidiary_Trust("MSFT", "LQ")
=hf_Preferred_Securities_of_Subsidiary_Trust("MSFT", "LY")

? Pro Tip: For Symbol flexibility, you can use formats like "=hf_Preferred_Securities_of_Subsidiary_Trust("^SPX", 2023)" for indices or "=hf_Preferred_Securities_of_Subsidiary_Trust("BTCUSD:DEFAULT", 2023)" for cryptocurrencies.

Passing Year Inputs via Cells or Functions

If you have a year in cell A1:

=hf_Preferred_Securities_of_Subsidiary_Trust("MSFT", A1)

You can also pass a text year directly:

=hf_Preferred_Securities_of_Subsidiary_Trust("MSFT", "2024")

Or use an Excel function to format the year input:

=hf_Preferred_Securities_of_Subsidiary_Trust("MSFT", TEXT(A1,"yyyy"))

Common Questions

1. Can I use relative references like “LQ” or “LY” in place of a specific year?
   Yes. For instance, =hf_Preferred_Securities_of_Subsidiary_Trust("MSFT","LQ") retrieves data for the last quarter.

2. Why am I getting “NA”?

   • You might have entered an invalid ticker symbol.
   • Your MarketXLS subscription plan may not include the required data.
   • The data for the specified period may not be available.

3. Is the data updated in real time?
   Trust-preferred securities data is usually updated quarterly or annually. Check MarketXLS documentation for update frequency details.

4. How to optimize performance for multiple calculations?

   • Use references to cells instead of repeatedly typing the same parameters.
   • Refresh data less frequently if you don’t need constant real-time updates.

?? Note: Always ensure your MarketXLS license is active and covers the required datasets to avoid “NA” returns.

Use the “Preferred Securities Of Subsidiary Trust (Historical)” formula in Excel with MarketXLS to streamline your financial analysis. By passing customizable parameters such as a specific year, quarter, or TTM, you gain comprehensive visibility into a company’s trust-preferred securities over different historical periods.