Retrieve Other Non-Current Assets with the hf_other_non_current_assets Function

The hf_other_non_current_assets function is designed to fetch the “Other Non-Current Assets” value (often listed on a company's balance sheet) directly in Excel using MarketXLS. By simply providing a ticker symbol, the desired year (and optional quarter or TTM flag), you can quickly evaluate a company’s focus on non-current assets such as long-term receivables or intangibles. This automated retrieval streamlines fundamental analysis and helps you make data-driven decisions faster.

Why Use This Function?

• Quickly access fundamental balance sheet data for US stocks and ETFs.
• Evaluate long-term assets (like goodwill or intangible assets) that might impact the company’s stability.
• Compare annual or quarterly changes to gain focused insights.
• Conveniently retrieve Trailing Twelve Months (TTM) data to see more recent trends.
• Easily integrate with other Excel-based analyses without manual data imports.

How to Use in Excel

=hf_other_non_current_assets(Symbol, Year, Quarter, [Optional TTM])

1. Enter the formula in any cell.
2. Replace Symbol with the valid ticker (e.g., "AAPL" for Apple Inc.).
3. Provide the Year (e.g., "2022") for which you want data.
4. Quarter is optional. If specified (e.g., "4"), the function attempts to pull that quarter's data.
5. [Optional TTM] can be set to "TTM" to get the trailing twelve-month figure.
6. Press Enter to get a numerical result (or "NA" if the data is unavailable).

Parameters Explained

Example Usage

Basic Examples

1. Annual Data for Tesla:
   =hf_other_non_current_assets("TSLA", "2021")
   • Retrieves the "Other Non-Current Assets" for Tesla in 2021 using the most recent available quarter/year data.

2. Quarterly Data for Apple (Q4 of 2022):
   =hf_other_non_current_assets("AAPL", "2022", "4")
   • Returns Apple’s reported Other Non-Current Assets for the fourth quarter of 2022 (if available).

3. TTM Data for Microsoft:
   =hf_other_non_current_assets("MSFT", "2022", , "TTM")
   • Pulls Microsoft’s trailing twelve-month figure for ratio-based analysis, ignoring a specific quarter.

Advanced Scenarios

1. Year-over-Year Comparison in Adjacent Cells:
   • In one cell: =hf_other_non_current_assets("TSLA", "2021")
   • Next cell: =hf_other_non_current_assets("TSLA", "2022")
   Compare the year-over-year shifts to spot trends or divergences.

2. Integrating with Other MarketXLS Functions:
   • Combine with a MarketXLS price function to quickly see if changes in “Other Non-Current Assets” correlate with stock price movement.

3. Historical Tracking Across Quarters:
   • Collect multiple quarters sequentially (Q1, Q2, Q3, Q4) to see if intangible assets or other items rise or fall each quarter, potentially signaling expansions or asset reclassifications.

4. Trading Strategy Examples:
   • Use “Other Non-Current Assets” as part of fundamental screening—combining it with ratios or revenues over time to refine buy/hold/short decisions in Excel.

Common Questions and Troubleshooting

1. Why do I get “NA”?
   • The symbol may be invalid, the data might be unavailable, or your subscription might not support this function.

2. What if I leave Quarter empty?
   • The function makes an internal decision to retrieve the most recent data or defaults to a particular quarter. You can specifically set a quarter to control which period is returned.

3. My output says “Refreshing.” What does that mean?
   • Data is being refreshed or queued. Wait a few moments and try again, or let the automatic caching process resolve.

4. Can I use this for non-US market symbols?
   • Primarily focused on the US market. Non-US data might be limited or unavailable, resulting in “NA.”

By leveraging the hf_other_non_current_assets function, you’ll have immediate access to a crucial piece of a company's financial puzzle. Stay informed and prepared, whether you’re comparing annual performance or peering into more recent quarters or trailing data. Enjoy deeper insights and faster research directly within Excel, courtesy of MarketXLS.