Trade And Non Trade Receivables (Historical) Formula in Excel

Understanding Trade And Non Trade Receivables (Historical)

Trade And Non Trade Receivables represent two categories of amounts owed to a business:

• Trade receivables stem from sales transactions (e.g., goods shipped or services provided).
• Non-trade receivables include all other receivables like employee loans, inter-company borrowings, or other miscellaneous debt.

When using MarketXLS, the Trade And Non Trade Receivables (Historical) formula helps you:

• Quickly access historical values of both trade and non-trade receivables for a given symbol.
• Compare year-over-year or quarter-over-quarter financial data.
• Make informed decisions about a company's receivables trend over time.

Syntax and Parameters

Use the hf_Trade_and_Non_Trade_Receivables function to retrieve historical trade and non-trade receivables.

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

?? Note: If the Symbol is invalid or there is no data for the specified period, the function returns "NA".

The function returns a numeric value representing the historical trade and non-trade receivables for the specified period.

? Pro Tip: You can reference a date in various ways when specifying time periods:

1. From a cell reference: =hf_Trade_and_Non_Trade_Receivables("MSFT", A1)
2. Directly using a date string: =hf_Trade_and_Non_Trade_Receivables("MSFT", "2024-03-15")
3. Using an Excel date function: =hf_Trade_and_Non_Trade_Receivables("MSFT", TEXT(A1,"yyyy-mm-dd"))

Examples and Usage

Below are some practical examples using actual symbols and different date references:

1. Basic yearly retrieval:

   =hf_Trade_and_Non_Trade_Receivables("MSFT", 2022)

   Retrieves the trade and non-trade receivables for Microsoft in 2022.

2. Year and quarter:

   =hf_Trade_and_Non_Trade_Receivables("MSFT", 2022, 2)

   Retrieves the values specifically for the second quarter of 2022.

3. Trailing Twelve Months (TTM):

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

   Returns the TTM value ending in the third quarter of 2022.

4. Last quarter references (relative):

   =hf_Trade_and_Non_Trade_Receivables("MSFT", "lq")

   Fetches the trade and non-trade receivables for the most recently reported quarter.

5. Past last-quarter offsets:

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

   Retrieves the data for the quarter before the most recently reported quarter.

6. Last year references (relative):

   =hf_Trade_and_Non_Trade_Receivables("MSFT", "ly")

   Returns data for the most recently reported year.

?? Note: In case of invalid license or missing subscription for historical fundamentals, you may receive a “NA” or a corresponding error message.

Common Questions

What if I get “NA” as a result?

“NA” typically means:

• The symbol was invalid.
• No data is available for the specified time period.
• The necessary subscription plan isn’t active.

Does this function work for options, indices, and crypto?

Yes. You can pass them as the Symbol parameter (e.g., "^SPX" for S&P 500 Index, "@MSFT 110122C00020000" for certain options, or "BTCUSD:DEFAULT" for crypto).

Are there any performance considerations?

Fetching historical data may take slightly longer than real-time quotes, especially if you query multiple symbols or quarters repeatedly. To optimize:

• Limit the number of cells calling this function simultaneously.
• Use it alongside caching or referencing cells instead of calling the function repeatedly in multiple places.

Can I use this function for prior years or quarters beyond standard reporting?

Yes, you can. The function supports “lq-1”, “lq-2”, “ly-1”, and “lt-1” formats to shift back multiple quarters or years.

? Pro Tip: Combine Trade And Non Trade Receivables (Historical) with other MarketXLS fundamental functions (e.g., Revenue (Historical), Gross Profit (Historical)) to get a comprehensive financial overview of the company’s historical performance.