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

Retrieve Preferred Securities of Subsidiary Trust Data

The hf_Preferred_securities_of_subsidiary_trust function in MarketXLS allows you to seamlessly pull “Preferred Securities of Subsidiary Trust” data for a specific symbol and time period into Excel. With just a few inputs—ticker symbol, year, quarter, and TTM settings—you can access reliable, up-to-date fundamental information directly in your spreadsheet. This function is particularly useful for assessing a company’s capital structure and evaluating subsidiary-related preferred instruments.

Why Use This Function?

  • Gain quick insight into complex capital items for deeper financial analysis.
  • Access data on a quarterly, annual, or trailing-twelve-month (TTM) basis in seconds.
  • Streamline your modeling workflow by eliminating manual data entry.
  • Remain current with the latest data (including potential refresh statuses).
  • Integrate with other MarketXLS functions for broader fundamental or technical analysis.

By leveraging hf_Preferred_securities_of_subsidiary_trust, analysts and investors can more thoroughly assess companies’ subsidiary-structured financing strategies and risk profiles, all without leaving Excel.

How to Use in Excel

=hf_Preferred_securities_of_subsidiary_trust(Symbol, Year, [Quarter], [TTM])
  1. In any cell, type “=hf_Preferred_securities_of_subsidiary_trust(”.
  2. Enter the company’s ticker symbol (e.g., "AAPL"), and the financial year of interest.
  3. Optionally include the quarter (1, 2, 3, or 4). If omitted, it defaults internally to "1" but may be adjusted to "2" in the final request.
  4. Optionally specify "TTM" to retrieve trailing twelve-month data. Leave it blank ("") otherwise.
  5. Close the parenthesis and press Enter.

MarketXLS automatically performs the license check and data retrieval from the backend. You’ll see the result or a status message (e.g., “NA” if the data is unavailable).

Parameters Explained

Parameter Description Example Values Notes
Symbol A valid ticker symbol (string). "AAPL", "MSFT" If invalid or not covered, function returns "NA".
year Financial year for the data. "2023", "2022" Must be a numeric string; if data not found, returns "NA".
quarter Optional. Quarter of the specified year. "1", "2", "3", "4" Defaults internally to "1" but may be forced to "2" if left blank. If no data, returns "NA".
TTM Optional. Enables trailing twelve-month data retrieval (use "TTM"). "TTM" or "" If "TTM", the function fetches TTM data. Otherwise, it uses quarterly or annual data.

Example Usage

Basic Examples

  1. Annual Data for 2022 (default quarter handling): • Cell formula:
    =hf_Preferred_securities_of_subsidiary_trust("AAPL", "2022")
    • Explanation: Retrieves annual data for Apple (AAPL), year 2022. Quarter is not explicitly set, so the function uses internal defaults.

  2. Quarterly Data for Q3 2023: • Cell formula:
    =hf_Preferred_securities_of_subsidiary_trust("AAPL", "2023", "3")
    • Explanation: Retrieves the Q3 2023 value for Apple’s Subsidiary Trust Preferred Securities.

  3. Trailing Twelve Months (TTM): • Cell formula:
    =hf_Preferred_securities_of_subsidiary_trust("MSFT", "2023", "3", "TTM")
    • Explanation: Fetches trailing twelve-month data through the third quarter of 2023 for Microsoft (MSFT).

Advanced Scenarios

  1. Iterating Across Multiple Quarters: • Use a row of cells referencing different quarters. For example, fill cells with the quarter numbers 1, 2, 3, 4 and reference them in the formula to compare quarterly results.

  2. Linking to Other MarketXLS Functions:
    • Combine hf_Preferred_securities_of_subsidiary_trust with ratio or growth functions to analyze how preferred securities interplay with broader financial metrics.

  3. Integrating with a Trading Model: • Investors often want to see changes in a company’s capital structure before making decisions. Link this function’s output to your risk assessment or portfolio allocation models.

Common Questions and Troubleshooting

  • Why am I getting “NA”?
    • The symbol may be invalid, your subscription may not include this data, or the data is legitimately not available for that period.

  • What if I see “Refreshing”?
    • The data is currently being updated. Try again after a short interval.

  • How does the Quarter argument work if left blank?
    • Internally, if quarter is empty, it first defaults to "1", but the code sets quarter to "2" for the API call if no quarter is specified. This can cause unexpected results if the Q1 data is not available—hence it checks for Q2 data.

  • Does this function support historical or unusual date formats?
    • For standard usage, pass a normal year and valid quarter. If you pass an unsupported format, you may get “NA” or an incorrect value.

When you need precise metrics on a corporation’s preferred securities via its subsidiary trust, hf_Preferred_securities_of_subsidiary_trust is your direct pipeline to clean, ready-to-use data within Excel. Combine it with other MarketXLS features for enhanced stock analysis and fundamental research.