API: Economic Book Value Calculation
The data used to calculate Economic Book Value, our measure of the no-growth value of a stock. Updated daily.
API: Economic Book Value Calculation: Single Datapoint
Endpoint
URL
Method
/metrics/ebv/:ticker
GET
URL Parameters
Name
Description
Example
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
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).
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/metrics/ebv/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",
"filingtype": "10-K"
}
]
}
}
API: Economic Book Value Calculation: All Datapoints
Endpoint
URL
Method
/metrics/ebv/:ticker
GET
URL Parameters
Name
Description
Example
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
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).
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/metrics/ebv/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",
"filingtype": "10-K"
},
{
"ticker": "AAPL",
"year": 2015,
"period": 5,
"periodtype": "ANNUAL",
"periodstring": "ANNUAL",
"datapoint": "NOPAT",
"datavalue": "52716962727.16620000000000000",
"filingtype": "10-K"
},
...
]
}
}
Datapoints
Name
Description
Datapoint
NOPAT (Net Operating Profit After Tax)
NOPAT (Net Operating Profit After Tax)
NOPAT
/ WACC (Weighted Average Cost of Capital)*
WACC (Weighted Average Cost of Capital)
WACC
+ 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
= Economic Book Value (EBV)*
Economic book value measures the no-growth value of the company based on the current Net Operating Profit After Tax (NOPAT) of the business.
BOOK_VALUE_ECONOMIC
*Indicates the datapoint is affected by stock price.
API: Fundamental Data Errors
Error
Message
Error Code
DataPointNotFound
The requested datapoint was not found.
404