US Executive Contacts & Compensation ExcelDocumentation - Historical data | Intrinio

US Executive Contacts & Compensation

Excel Documentation

Historical Data

Historical Data

Returns the historical compensation data for a given executive ID and data tag.

Function:
=IntrinioHistoricalData(identifier, item, sequence)
Available in Sandbox

Parameters

Name Description Example
identifier
* required
An Intrinio executive ID. @COOK_49578-AAPL
item
* required
An Intrinio data tag (reference). comp_total_summary
start_date
The earliest date for which to return data. 2018-04-02
end_date
The latest date for which to return data. 2018-5-03
frequency
The frequency of the historical prices & valuation data.
Options:
daily
weekly
monthly
quarterly
yearly
show more show less
yearly
type
The type of historical data to fetch. For financial statements, the type reflects the type of financial statement. For Sector data, the type reflect the aggretation (mean, median, max, min) type of the data.
Options:
FY
QTR
TTM
YTD
count
sum
max
75thpctl
mean
median
25thpctl
min
show more show less
FY
sequence
* required
An integer 0 or greater for calling a single historical data point from the first entry, based on sort order. 0
show_date
If true, the function will return the date value, and if false the function will return the data point value for a given query.
Options:
Yes
show more show less
Yes
identifier
* required
An Intrinio executive ID.
item
* required
An Intrinio data tag (reference).
start_date
* required
The earliest date for which to return data.
end_date
* required
The latest date for which to return data.
frequency
* required
The frequency of the historical prices & valuation data.
type
* required
The type of historical data to fetch. For financial statements, the type reflects the type of financial statement. For Sector data, the type reflect the aggretation (mean, median, max, min) type of the data.
sequence
* required
An integer 0 or greater for calling a single historical data point from the first entry, based on sort order.
show_date
* required
If true, the function will return the date value, and if false the function will return the data point value for a given query.

Output Fields

Name Description Type
identifier An Intrinio executive ID. -
item An Intrinio data tag (reference). -
date the date associated with the value -
value the value -
identifier
An Intrinio executive ID.
item
An Intrinio data tag (<a href='https://data.intrinio.com/data-tags/greensight-exec-comp'>reference</a>).
date
the date associated with the value
value
the value