API: Accounting Book Value to Invested Capital Reconciliation

This data set contains the adjustments we make to convert reported accounting book value to Invested Capital. Updated daily.

API: Accounting Book Value to Invested Capital Reconciliation: Single Datapoint

Endpoint
URL
Method
/reconciliation/book-value-to-invested-capital/: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/book-value-to-invested-capital/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: Accounting Book Value to Invested Capital Reconciliation: All Datapoints

Endpoint
URL
Method
/reconciliation/book-value-to-invested-capital/: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/book-value-to-invested-capital/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": "EQUITY_SHAREHOLDER",
        "datavalue": "119355000000.00000000000000000",
      "filingtype": "10-K"
      },
      ...
    ]
  }
}

Datapoints

Name
Description
Datapoint
Total Shareholders' Equity
Total shareholders' equity, from the shareholders' equity section of the balance sheet.
EQUITY_SHAREHOLDER
+ Short-Term Debt and Long-Term Debt
Total short-term and long-term non-operating debt.
DEBT
- Total Reported Operating Lease Assets Less Total Reported Operating Lease Liabilities
The total value of operating lease assets minus operating lease liabilities reported on the balance sheet.
TOTAL_REPORTED_OPERATING_LEASES_NET
- Total Hidden Operating Lease Assets Less Total Hidden Operating Lease Liabilities
The total value of operating lease assets hidden on the balance sheet less operating lease liabilities hidden on the balance sheet.
TOTAL_HIDDEN_OPERATING_LEASES_NET
+ Total Standardized Present Value of Operating, Variable and Non-Commenced Leases
Net Present Value of Operating Lease Payments, Variable Leases, and Not Yet Commenced Leases.
LEASES_PRESENT_VALUE_TOTAL
+ Total Long-Term Other Liabilities Less Non-Operating Liabilities
The total value of non-current other liabilities minus the non-current deferred tax and deferred compensation liabilities.
TOTAL_LIABILITIES_NON_CURRENT_OTHER_NET
+ Total Reserves
Sum of the current ending reserve balances for LIFO, inventory, and loan loss reserves.
RESERVES_TOTAL
+ Accumulated Goodwill Amortization
Accumulated Goodwill Amortization
GOODWILL_AMORTIZATION_ADJUSTED_ACCUMULATED
+ Accumulated Asset Write-Downs After-Tax
Total of all write-downs after tax from the current year plus all write-downs from prior years.
WRITE_DOWNS_AFTER_TAX_TOTAL_ACCUMULATED
+ Accumulated Unrecorded Goodwill
Total amount of unrecorded goodwill collected from the current year and all other previous years.
GOODWILL_UNRECORDED_ACCUMULATED
- Unconsolidated Subsidiary Assets (non-operating)
Investment in unconsolidated subsidiaries that are not part of operations. A fixed asset on the balance sheet.
ASSETS_FIXED_UNCONSOLIDATED
- Net Assets from Discontinued Operations
Net Assets from Discontinued Operations
ASSETS_DISCONTINUED_NET
- Total Reported Deferred Tax Assets Less Total Reported Deferred Tax Liabilities
The total value of deferred tax assets minus deferred tax liabilities reported on the balance sheet.
TOTAL_REPORTED_DEFERRED_TAXES_NET
- Total Hidden Deferred Tax Assets Less Total Hidden Deferred Tax Liabilities
The total value of hidden deferred tax assets minus hidden deferred tax liabilities.
TOTAL_HIDDEN_DEFERRED_TAXES_NET
- Total Reported Deferred Compensation Assets Less Total Reported Deferred Compensation Liabilities
The total value of deferred compensation assets minus deferred compensation liabilities reported on the balance sheet.
TOTAL_REPORTED_DEFERRED_COMPENSATION_NET
- Total Hidden Deferred Compensation Assets Less Total Hidden Deferred Compensation Liabilities
The total value of hidden deferred compensation assets minus hidden deferred compensation liabilities.
TOTAL_HIDDEN_DEFERRED_COMPENSATION_NET
- 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
- Over Funded Pensions
Overfunded status of a pension plan (if the pension plan is an unfunded liability this value will be 0).
PENSION_FUNDED_STATUS_LIMITED
- Accumulated OCI (Other Comprehensive Income), Including Quarterly Estimates
Estimate of Accumulated Other Comprehensive Income, from the shareholders' equity section of the balance sheet. Primarily for IFRS companies that don't report OCI in their quarterly filings.
OCI_ADJUSTED
= Invested Capital
Invested capital is the value of the money invested in a business over its lifetime.
CAPITAL_INVESTED
= Invested Capital Financing Approach
Invested Capital calculated by the financing approach (total debt + equity equivalents + common equity).
CAPITAL_INVESTED_FINANCING

*Indicates the datapoint is affected by stock price.

API: Fundamental Data Errors

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