WHAT IS THE HISTORICAL DATA ENDPOINT?

The historical data endpoint is incredibly flexible, as you're able to utilize that endpoint to bring in data across almost of our data feeds. As such, it's important to know when to use the Frequency parameter, vs. when to use the Type parameter.

WHEN DO I USE THE FREQUENCY PARAMETER?

The Frequency parameter should be used only for non-fundamental items that are updated at a frequency higher than quarterly. Examples include pricing data and marketcap.

For example, to return the historical weekly marketcap for a security, run this in the API:

https://api.intrinio.com/historical_data?identifier=AAPL&item=marketcap&frequency=weekly


or this in Excel:

 =IntrinioHistoricalData("AAPL","marketcap",0,"","","weekly","","false"), =IntrinioHistoricalData("AAPL","marketcap",1,"","","weekly","","false"), =IntrinioHistoricalData("AAPL","marketcap",2,"","","weekly","","false")


Along with weekly, you also have the options for daily, monthly, quarterly, and yearly frequencies.

If no frequency is specified, the endpoint will by default return the highest frequency available for that item. So for marketcap, the below would return the historical daily values:

 https://api.intrinio.com/historical_data?identifier=AAPL&item=marketcap.

WHEN DO I USE THE TYPE PARAMETER?

The Type parameter should be used strictly for fundamental items directly from the 10-K and 10-Qs. Examples include total revenue, debt, and cash from operating activities.

For example, to return the historical QTR total revenue from the 10-Qs, run this in the API:
 https://api.intrinio.com/historical_data?identifier=AAPL&item=totalrevenue&type=QTR

or this in Excel:
 =IntrinioHistoricalData("AAPL","totalrevenue",0,"","","","QTR","false"), =IntrinioHistoricalData("AAPL","totalrevenue",1,"","","","QTR","false"), =IntrinioHistoricalData("AAPL","totalrevenue",2,"","","","QTR","false")

Along with QTR, you also have the options for FY, TTM, and YTD types.

If no type is specified, the endpoint will by default return the quarterly TTM values for income statement and cash flow statement items, and QTR values from the balance sheet. So, for total revenue, the below would return the quarterly TTM values: 

https://api.intrinio.com/historical_data?identifier=AAPL&item=totalrevenue.

There is an exception to the type parameter:

If you specify a frequency with a fundamental item, such as total revenue, it will default to return the TTM values at the specified frequency. So the below would return the quarterly TTM values, same as if you did not specify a Type or Frequency: 

https://api.intrinio.com/historical_data?identifier=AAPL&item=totalrevenue&frequency=quarterly

ADDITIONAL RESOURCES


Did this answer your question?