API: Revenue to EBITDA Reconciliation

This data set contains the data we use to calculate EBITDA (Earnings Before Interest, Taxes, Depreciation & Amortization). Updated daily.

API: Revenue to EBITDA Reconciliation: Single Datapoint

Endpoint
URL
Method
/reconciliation/revenue-to-ebitda/:ticker
GET
URL Parameters
Name
Description
Example
:ticker
Ticker of the stock. You can use the coverage endpoint to get full lists of options.
A
Query Parameters
Name
Required
Description
Example
:datapoint
Required
Name of data point. Click here for a full list of available data points
REVENUE
:year
Required
Fiscal year of the data point. We generally cover companies back to the first digital document filed with the SEC.
2017
:quarter
Optional
Fiscal quarter Options:
Omit for annual data
1 = Q1 quarterly data
2 = Q2 quarterly data
3 = Q3 quarterly data
4 = Q4 quarterly data
1
:ttm
Optional
Trailing twelve months (TTM) data Options:
Omit for annual data
1 = TTM data ending with Q1 (indicated fiscal year Q1 + prior fiscal year Q4, Q3, & Q2)
2 = TTM data ending with Q2 (indicated fiscal year Q2 & Q1 + prior fiscal year Q4 & Q3)
3 = TTM data ending with Q3 (indicated fiscal year Q3, Q2, & Q1 + prior fiscal year Q4)
4 = TTM data ending with Q4 (indicated fiscal year Q4, Q3, Q2, & Q1).
1
Header Parameters
Name
Value
x-api-key
[New Constructs-provided API key]
Content-Type
application/json
Return Values
Name
Description
Example
ticker
Ticker of the listed security.
AAPL
year
Fiscal year of the data value.
2017
period
Period of the requested data; 1-4 indicate quarterly or TTM periods and 5 indicates an annual period.
5
periodtype
Period type of the requested data (ANNUAL, QUARTERLY, or TTM)
ANNUAL
periodstring
Period string of the requested data (ANNUAL, QUARTERLY, or TTM)
ANNUAL
datapoint
Name of data point.
REVENUE
datavalue
Value of the requested datapoint in ones.
233715000000.00000000000000000
filingtype
Type of filing the datapoint is from.
10-K
Sample Call:
Check out Python examples and more in our GitHub repo.
curl -i -H 'x-api-key: [New Constructs-provided API key]' -H "Content-Type: application/json" 'https://api.newconstructs.com/v1/reconciliation/revenue-to-ebitda/AAPL?datapoint=REVENUE&year=2015'
Success Response: 

{
  "statusCode": 200,
  "headers": {"Content-Type": "application/json"},
  "body": {
    "results": [
      {
        "ticker": "AAPL",
        "year": 2015,
        "period": 5,
        "periodtype": "ANNUAL",
        "periodstring": "ANNUAL",
        "datapoint": "REVENUE",
        "datavalue": "233715000000.00000000000000000",
      "filingtype": "10-K"
      }
    ]
  }
}

API: Revenue to EBITDA Reconciliation: All Datapoints

Endpoint
URL
Method
/reconciliation/revenue-to-ebitda/:ticker
GET
URL Parameters
Name
Description
Example
:ticker
Ticker of the stock. You can use the coverage endpoint to get full lists of options.
A
Query Parameters
Name
Required
Description
Example
:year
Required
Fiscal year of the data point. We generally cover companies back to the first digital document filed with the SEC.
2017
:quarter
Optional
Fiscal quarter Options:
Omit for annual data
1 = Q1 quarterly data
2 = Q2 quarterly data
3 = Q3 quarterly data
4 = Q4 quarterly data
1
:ttm
Optional
Trailing twelve months (TTM) data Options:
Omit for annual data
1 = TTM data ending with Q1 (indicated fiscal year Q1 + prior fiscal year Q4, Q3, & Q2)
2 = TTM data ending with Q2 (indicated fiscal year Q2 & Q1 + prior fiscal year Q4 & Q3)
3 = TTM data ending with Q3 (indicated fiscal year Q3, Q2, & Q1 + prior fiscal year Q4)
4 = TTM data ending with Q4 (indicated fiscal year Q4, Q3, Q2, & Q1).
1
Header Parameters
Name
Value
x-api-key
[New Constructs-provided API key]
Content-Type
application/json
Return Values
Name
Description
Example
ticker
Ticker of the listed security.
AAPL
year
Fiscal year of the data value.
2017
period
Period of the requested data; 1-4 indicate quarterly or TTM periods and 5 indicates an annual period.
5
periodtype
Period type of the requested data (ANNUAL, QUARTERLY, or TTM)
ANNUAL
periodstring
Period string of the requested data (ANNUAL, QUARTERLY, or TTM)
ANNUAL
datapoint
Name of data point.
REVENUE
datavalue
Value of the datapoint in ones.
233715000000.00000000000000000
filingtype
Type of filing the datapoint is from.
10-K
Sample Call:
Check out Python examples and more in our GitHub repo.
curl -i -H 'x-api-key: [New Constructs-provided API key]' -H "Content-Type: application/json" 'https://api.newconstructs.com/v1/reconciliation/revenue-to-ebitda/AAPL?year=2015'
Success Response: 

{
  "statusCode": 200,
  "headers": {"Content-Type": "application/json"},
  "body": {
    "results": [
      {
        "ticker": "AAPL",
        "year": 2015,
        "period": 5,
        "periodtype": "ANNUAL",
        "periodstring": "ANNUAL",
        "datapoint": "REVENUE",
        "datavalue": "233715000000.00000000000000000"
      },
      {
        "ticker": "AAPL",
        "year": 2015,
        "period": 5,
        "periodtype": "ANNUAL",
        "periodstring": "ANNUAL",
        "datapoint": "EBITDA",
        "datavalue": "82487000000.00000000000000000"
      },
      ...
    ]
  }
}

Datapoints

Name
Description
Datapoint
Total Revenue
Total revenue as reported on the income statement.
REVENUE
+ Total Operating Income
Sum of a company's operating income derived outside of revenues.
INCOME_OPERATING
- Total Operating Expense
Total operating expenses disclosed on the income statement.
EXPENSES_OPERATING
- Total Hidden Non-Operating Expense, Net
Total Net Non-Operating Expenses Hidden in Operating Earnings are the net of losses and gains that do not appear directly on the income statement. These items are bundled inside other line items that appear on the income statement. Hidden items are found only in the Management Discussion & Analysis (MD&A) or in the footnotes to the financial statements.
EXPENSES_PRE_TAX_HIDDEN_TOTAL
- ESO Expense (Employee Stock Options)
ESO Expense (Employee Stock Options), net is the cost of issuing (at-the-money) employee stock options (ESOs) to employees before companies were required to expense ESOs. Prior to 2006, businesses were not required to record any cost for issuing ESOs. Using data provided only in footnotes, we charge companies for the cost of all ESO issuances long before FASB required companies to report the expense. This charge only appears in historical filings prior to adoption of the new accounting standards.
ESO_EXPENSE
+ Goodwill Amortization Expense, Net
Goodwill Amortization Expenses, net is a gradual, formulaic reduction in goodwill asset value using any of the several GAAP amortization methods. In 2002, FASB did away with Goodwill amortization and replaced it with the practice of goodwill impairment. This adjustment only appears in historical filings prior to adoption of the new accounting standards.
GOODWILL_AMORTIZATION_ADJUSTED
+ Calculated Single Period Value for Depreciation and Amortization (Cash Flow)
Depreciation and amortization from cash flows from operations section of the cash flow statement. Cash flow statement values are reported cumulatively. This is the single quarter or annual value rather than the cumulative value.
DEPRECIATION_AND_AMORTIZATION_CASH_FLOW_SINGLE_PERIOD
= Adjusted EBITDA/EBTDA
Adjusted operating earnings before interest, taxes, depreciation and amortization. This version of EBITDA is adjusted for unusual gains/losses found only in the footnotes or MD&A.
EBITDA

*Indicates the datapoint is affected by stock price.

API: Fundamental Data Errors

Error
Message
Error Code
DataPointNotFound
The requested datapoint was not found.
404