Excel Add-In: Data Points

The New Constructs Data Point Excel Add-In function provides immediate access to the list of available data points that are used in our models.

Excel Add-In: Single Data Point

Returns detailed information about a single data point.

Function
Function Name
=NC_DataPoints(datapoint_name)
Parameters
Name
Position
Description
Example
Datapoint Name
1
The name of the datapoint to look up.
LEASES_PAYMENTS
Return Values
Name
Description
Example
Data Point Name
The name of the datapoint which can be used in other API calls.
LEASES_PAYMENTS
Description
A brief description of the datapoint.
Total of all future operating lease payments.
Endpoints
A list of endpoints in which the datapoint appears.
Model Data, Adjusted Fundamentals
Sample Function Call
      
A B C D E
1 =NC_DataPoints("LEASES_PAYMENTS")
2
3
4
Sample Response Data
      
A B C D E
1 LEASES_PAYMENTS Total of all future operating lease payments. Model Data, Adjusted Fundamentals
2
3
4

Excel Add-In: Datapoint Errors

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