Executive Contacts API in the Intrinio Fintech Marketplace

Intrinio is proud to announce that executive contacts and compensation data will now be available in the Fintech Marketplace. This dataset from Greensight is broken into two data feeds, one for the United States and one for international executives. Both feeds include direct email and direct phone numbers for key leaders at major corporations as well as 4+ years of compensation data . This article explains what is included in these new feeds and the cost to subscribe, how to access the data in Excel, and how to access the data in API format.

What is included and what does it cost?

The executive compensation data is split into two data feeds. The US Executive Contacts and Compensation data feed is the smaller of the two datasets, covering 4,604 companies in North America with 52,804 contacts. The International Executive Contacts and Compensation data feed covers 15,684 companies around the world with 87,175 contacts. Both feeds include similar data points for the individuals that run the worlds businesses:

  • 1,300+ new contacts each month
  • Direct emails for 75% of contacts, Direct phone for 27%
  • Data for CEO, CFO, Corporate Secretary, General Counsel, Treasurer, Investor Relations Officer, Corporate Development/Strategy, Board Members
  • Compensation data including 4 years of history, salary, bonus, options

The most obvious use of this data is for getting in touch with decision makers, but another use case is for investors that want to systematically track changes in management. The compensation data is another indicator of company performance that is provides information when analyzing an investment in a firm. Collecting this data manually is time consuming and expensive and can delay decision making.

Intrinio offers separate pricing for the US data feed and the international data feed.

US Executive Contacts API Pricing

Pricing options for the US Executive Contacts API

Screen Shot 2017-05-11 at 10.49.40 AM

International Executive Contacts API Pricing

The international feed costs more than the US data because it includes quite a bit more data. Both data feeds offer free trials so users can test the data. Individual plans are the same as professional plans except the professional plan enables a user to access more data each day. Startup plans offer discounts to companies that meet revenue and funding requirements and need to redistribute data through their application to their own end users. If you need a custom plan because you don't qualify as a startup or need more daily data, just shoot us a message.

Chat The Intrinio Team

How do I access Executive Contacts API Data In Excel?

If you are unfamiliar with Intrinio's Excel add-in, this tutorial will walk you through the install. This free tool will enable you to pull data into Excel and have that data update whenever the data in Intrinio's database updates. This makes it easy to build lists of contacts with emails and phone numbers as well as compensation data for analyses in Excel.

Start by subscribing to a plan for either the US data feed or the international data feed. The trial will update your access keys so you can sample the data and a paid plan will give you a set amount of daily data. Once you have a subscription and have installed the Excel add in, you can use the datapoint function to pull the most recent data for an executive:

=intriniodatapoint("@MUSK_51244-TSLA:US", "comp_total_summary")

Pulling the Total Compensation for Elon Musk into Excel

Pulling the Total Compensation for Elon Musk into Excel

You can also use the historicaldata function to pull in up to 4 years of compensation history:

=IntrinioHistoricalData("@MUSK_51244-TSLA:US","comp_total_summary",0)

Compensation History for Elon Musk

Compensation History for Elon Musk

The full documentation for pulling executive compensation data into Excel is available here. You can look up the different tag options, items like Cash Paid and Option Awards, in the Data Tag Directory. The API explorer is a great tool that will make the syntax easier for custom functions in Excel. Just scroll down through the data types and select the Executive Compensation data types you are interested in:

 

How do I access Executive Contacts Data Via API ?

The full API documentation for these data feeds is available here. Its important to remember that in many cases there are many pages of data- this article gives examples of how to get started with Intrinio's API and how to use the pager.

The API explorer is a great tool for building API calls as well. Simply select the Executive compensation data type and the syntax builder will update the endpoint for you. If you want to pull a list of all executives, start with this call:

https://api.intrinio.com/executives

Sample Executive Compensation API Call

Sample Executive Compensation API Call

This call will return the identifier and name as well as the location of the individual (US/Non-US). You can pass a company symbol to subset the data based on your company of interest:

https://api.intrinio.com/executives?company=AAPL

Just Pulling Contacts From AAPL

Just Pulling Contacts From AAPL

Using these identifiers, you can begin systematically pulling contact and compensation data for these executives:

https://api.intrinio.com/executives/compensations?identifier=@COOK_49578?company=AAPL 

Screening to Pull Executive Data for Apple's Tim Cook

Screening to Pull Executive Data for Apple's Tim Cook

The documentation provides many more examples, but it's easy to see how an executive contacts API would make it easier to systematically track contacts and their compensation and even sort by company. The API explorer is a great tool that will make the syntax easier . Just scroll down through the data types and select the Executive Compensation data types you are interested in:

Sample API call for Executive Compensation Data

You can copy the API syntax directly from the API Explorer and view JSON outputs

Why Use This Feed?

Intrinio works to partner with companies that want to make financial data affordable and accessible. Thats our mission, and its a mission that Greensight shares. Making their executive compensation and contact data available in Excel and via API through Intrinio offers exciting possibilities.

Use the data for your marketing and sales efforts, as well as to pick up alpha in your quant models. Tracking changes and compensation systematically is a creative way to gain insight into the value of a company. Send us your ideas, your questions, and your dreams- we can't wait to see what you build with this new data set.

Chat The Intrinio Team