(Historical) Formula in Excel

In this guide, you’ll learn how to use the (Historical) formula in Excel with MarketXLS to quickly retrieve a company’s net earnings before interest and taxes (EBIT) in USD for specified historical dates and periods. Whether you’re analyzing past performance, comparing quarterly results, or reviewing trailing twelve months (TTM) data, this function provides actionable insights directly in your Excel workflow.

Understanding (Historical)

• The (Historical) formula, technically called hf_Earning_Before_Interest_and_Taxes_USD, focuses on retrieving a company’s EBIT in USD for defined historical periods.
• Use this function to compare yearly or quarterly EBIT values, track last-quarter or last-year data, or perform TTM calculations.
• It’s especially beneficial for fundamental analysis, allowing you to see how a company’s profitability has changed over time.

? Pro Tip: Combine the (Historical) formula with other MarketXLS historical fundamental functions to build comprehensive financial models in Excel.

Syntax and Parameters

=hf_Earning_Before_Interest_and_Taxes_USD(Symbol, Year, [Quarter], [TTM])

• Returns a numeric value if the dataset is found.
• Returns “NA” if invalid Symbol, licensing issues, or unavailable data.

?? Note: Ensure your MarketXLS subscription supports historical fundamentals to avoid the “NA” output for licensed data.

Examples and Usage

Below are common ways to use the (Historical) formula in Excel:

1. Retrieve EBIT (USD) for a specific year:

   =hf_Earning_Before_Interest_and_Taxes_USD("MSFT", 2022)

2. Retrieve EBIT (USD) for a specific year and quarter:

   =hf_Earning_Before_Interest_and_Taxes_USD("MSFT", 2022, 2)

3. Retrieve trailing twelve months (TTM) data starting from a given quarter:

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

4. Use special placeholders to reference last quarter/year and offsets:
   • Last quarter:

   =hf_Earning_Before_Interest_and_Taxes_USD("MSFT", "lq")

   • Last quarter minus one:

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

   • Last year:

   =hf_Earning_Before_Interest_and_Taxes_USD("MSFT", "ly")

   • Last 12 months:

   =hf_Earning_Before_Interest_and_Taxes_USD("MSFT", "lt")

? Pro Tip: If your “Year” input is referenced from Excel cells, you can also pass “date” values in various formats, such as:
• Cell references:

=hf_Earning_Before_Interest_and_Taxes_USD(A1)

• Direct date strings:

=hf_Earning_Before_Interest_and_Taxes_USD("2024-03-15")

• Combined with Excel date functions:

=hf_Earning_Before_Interest_and_Taxes_USD(TEXT(A1,"yyyy-mm-dd"))

Common Questions

1. How can I ensure my data is up-to-date?

MarketXLS automatically updates based on your chosen refresh settings. Check your subscription and refresh schedule to ensure you’re pulling the latest historical fundamentals.

2. Why am I seeing “NA” in my cells?

This often indicates:

• Invalid or unrecognized symbol.
• Data not available for the specified period.
• License or subscription level issues with historical data.

3. Can I compare EBIT data with other fundamentals in one sheet?

Absolutely. Combine hf_Earning_Before_Interest_and_Taxes_USD with other MarketXLS historical fundamental functions (e.g., Revenue (Historical), Gross Profit (Historical)) to analyze different metrics side-by-side.

4. Does it impact Excel performance to use many formula calls?

While MarketXLS is optimized for performance, large spreadsheets with multiple historical data calls can slow calculations. Consider:

• Using MarketXLS Real-Time Server for heavier tasks.
• Refreshing on-demand rather than continuously.

?? Note: For best results, ensure your MarketXLS user settings and data source configurations are properly set up to handle historical fundamental data.