API: Market Value to Enterprise Value Reconciliation

This data set contains the adjustments we make to convert equity market value to Enterprise Value. Updated daily.

API: Market Value to Enterprise Value Reconciliation: Single Datapoint

Endpoint
URL
Method
/reconciliation/market-value-to-ev/: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
EXCESS_CASH
: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.
EXCESS_CASH
datavalue
Value of the requested datapoint in ones.
200991700000.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/market-value-to-ev/AAPL?datapoint=EXCESS_CASH&year=2015'
Success Response: 

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

API: Market Value to Enterprise Value Reconciliation: All Datapoints

Endpoint
URL
Method
/reconciliation/market-value-to-ev/: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.
EXCESS_CASH
datavalue
Value of the datapoint in ones.
200991700000.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/market-value-to-ev/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": "EXCESS_CASH",
        "datavalue": "200991700000.00000000000000000"
      },
      {
        "ticker": "AAPL",
        "year": 2015,
        "period": 5,
        "periodtype": "ANNUAL",
        "periodstring": "ANNUAL",
        "datapoint": "EQUITY_MARKET_VALUE",
        "datavalue": "639938756630.00000000000000000"
      },
      ...
    ]
  }
}

Datapoints

Name
Description
Datapoint
Market Value of Basic Equity*
Market Value of Firm's Equity as determined by the stock price and shares outstanding. Market Cap.
EQUITY_MARKET_VALUE
- Excess Cash
The amount of cash on hand over and above what is needed in the current year to fund the operations of the business for the foreseeable future.
EXCESS_CASH
- Net Assets from Discontinued Operations
Net Assets from Discontinued Operations
ASSETS_DISCONTINUED_NET
- Fair Value of Unconsolidated Subsidiary Assets (non-operating)
Fair Value of Unconsolidated Subsidiary Assets (non-operating)
ASSETS_FIXED_UNCONSOLIDATED_ADJUSTED
- Net Deferred Tax Liability
Net Deferred Tax Liability
DEFERRED_TAX_NET_ADJUSTED
- Net Deferred Compensation Assets
Net Deferred Compensation Assets
ASSETS_DEFERRED_COMPENSATION_NET
+ Fair Value of Total Debt
Short-Term Debt and Long-Term Debt adjusted to fair value.
DEBT_ADJUSTED
+ Fair Value of Preferred Capital
Dollar value of the preferred capital adjusted for fair value of preferred stock.
STOCK_PREFERRED_ADJUSTED
+ Fair Value of Minority Interests
Carrying value of minority interests adjusted to fair value.
INTEREST_MINORITY_ADJUSTED
+ Value of Outstanding ESO After-Tax*
The after-tax fair market value of ESOs net of assumed options cancelled.
ESO_TRANCHE_VALUE_AFTER_TAX
- Pensions Net Funded Status
Funded status of pension plans.
PENSION_FUNDED_STATUS_ADJUSTED
= Enterprise Value*
Represents the total value of the company. Enterprise value takes into effect all assets and liabilities that constitute the value of the company. Simply, it is the amount of money needed to purchase the entire company and pay off all debtors and other stakeholders.
ENTERPRISE_VALUE

*Indicates the datapoint is affected by stock price.

API: Fundamental Data Errors

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