Excel Add-In: Data Points

The New Constructs Data Point dataset 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