Sale Of Long Term Investments (Historical) Formula in Excel
Discover how to efficiently track and analyze the sale of long-term investments in Excel with MarketXLS. This formula helps you quickly retrieve historical data on how much a company has gained from selling these assets, empowering you to make informed investment decisions.
Understanding Sale Of Long Term Investments (Historical)
The Sale Of Long Term Investments (Historical) formula is designed to:
- Provide insight into a company’s proceeds from selling long-term assets over a given period.
- Help investors, analysts, and traders assess liquidity events and cash flow changes.
- Offer historical context to support fundamental and comparative financial analysis.
? Pro Tip: Use this formula to compare how different firms manage and sell their long-term portfolio assets over various years or quarters.
Syntax and Parameters
=hf_Sale_of_Long_Term_Investments(Symbol, Year, [Quarter], [TTM])
Parameter | Description | Required | Example |
---|---|---|---|
Symbol |
Enter a valid ticker symbol or supported code (e.g., "MSFT", "^SPX", "@MSFT 110122C00020000", "BTCUSD:DEFAULT"). | Yes | "MSFT" |
Year |
Specifies the reporting year or a special period code (e.g., "2022", "lq", "ly", "lt"). | Yes | "2022", "lq", "ly" |
Quarter |
Indicates the calendar quarter (1, 2, 3, or 4). Defaults to "1" if not provided. | No | 2 |
TTM |
Use "TTM" for trailing twelve months data. Leave blank for standard annual/quarterly data. | No | "TTM" |
Return Value
• Returns a numeric value representing the total amount (in the reported currency) gained from the sale of long-term investments during the specified period.
• Returns "NA" in case of invalid symbols, license issues, or any exceptions.
?? Note: This function communicates with MarketXLS data servers. Depending on your plan or network conditions, data retrieval may take slightly longer for large datasets.
Examples and Usage
Below are a few practical ways to use the formula in Excel:
- By referencing a cell for the symbol or year:
» =hf_Sale_of_Long_Term_Investments(A2, A3) - By directly entering a ticker symbol and year:
» =hf_Sale_of_Long_Term_Investments("MSFT", "2022") - By specifying a date in multiple formats if applicable to your scenario:
• =hf_Sale_of_Long_Term_Investments(A1, TEXT(A2,"yyyy-mm-dd"))
• =hf_Sale_of_Long_Term_Investments("BTCUSD:DEFAULT", "2024-03-15") - For quarterly data:
» =hf_Sale_of_Long_Term_Investments("MSFT", "2022", 2) - For trailing twelve months (TTM):
» =hf_Sale_of_Long_Term_Investments("MSFT", "2022", 3, "TTM") - Using special codes for last periods:
• =hf_Sale_of_Long_Term_Investments("MSFT","lq") (Last Quarter)
• =hf_Sale_of_Long_Term_Investments("MSFT","ly") (Last Year)
• =hf_Sale_of_Long_Term_Investments("MSFT","lt") (Last Twelve Months)
Common Questions
-
What if I receive "NA" as a result?
- Double-check the symbol correctness (e.g., "MSFT" or "^SPX").
- Ensure your MarketXLS license is valid and active.
- Verify you’ve used a valid year or period code.
- Check your internet connection since the function retrieves data from MarketXLS servers.
-
Are there any limitations on the time periods?
- Historical data availability may vary by symbol and your MarketXLS subscription plan.
-
How does this differ from other fundamentals formulas like Revenue (Historical) or Cost of Revenue (Historical)?
- While those formulas track income and expenses, the Sale Of Long Term Investments (Historical) focuses on proceeds from selling assets such as bonds, stocks, or property held for the long term.
-
Is there a performance impact when using multiple MarketXLS formulas?
- Each formula call can introduce a slight delay due to web requests. In large spreadsheets, consider batching data requests or using fewer dynamic references to improve performance.
? Pro Tip: Combine this formula with others (e.g., Revenue, Cost Of Revenue) to build a comprehensive Excel dashboard that captures a company’s complete financial performance over time.