A new data feed in the Intrinio Fintech Marketplace pairs Wall Street Horizon's exceptionally accurate corporate events calendar with Intrinio's extraordinarily intuitive access methods. Users can pull data points such as earnings dates, dividend dates and conference call dates in formats such as Excel, API, and Google Sheets. This article explains what data is included in the Wall Street Horizon Corporate Events Data Feed, how to subscribe to that data, and how to access that data in Excel, CSV, API, or Google Sheets formats.
What data is included
This data feed provides corporate action dates for 6,000+ US companies with 25+- data points depending on the company.
- Dividend pay dates, ex-dates, currency, amount, frequency
- Conference call dates, broadcast URLs
- Company information such as website and stock exchange
- Earnings Dates
- Conference call information including dates and access information
Most users of corporate events dates are looking for either earnings dates or dividend related dates. The former are useful for forecasting the changes in stock prices that typically occur when a company releases its financials while the later are useful for forecasting changes in stock prices surrounding ex-dates or the actual payment of dividends.
The full list of data types is available here and includes data points like earnings dates for the upcoming year, dividend status, and transcript URLs for conference calls. Historical earnings dates will be added in the near future.
How to Subscribe to the Data
Instead of bundling data into a single, expensive, subscription, Intrinio offers an a la cart data marketplace where users can subscribe to just the data feeds they need. You can read about the advantages of this approach here and learn about the marketplace more generally here.
To get started, head over to the Wall Street Horizon Corporate Events data feed page in the marketplace. If Intrinio is running a promotion, you'll see it on this page. You can subscribe directly or chat with our team to ask questions or set up a short trial so you can try before you buy.
Once you have subscribed, you can cancel or change your plan at any time and prices are listed on each product page.
How to access the data via API or CSV
If you are unfamiliar with Intrinio's RESTful API, this article will get you started and includes SDKs in many languages. Using the API explorer will make it simple to build your API calls. Simply select datapoint, which returns the most recent corporate events dates, enter a ticker, and select a corporate events tag from this list.
You can then copy and paste the syntax right into your code:
By varying the ticker in the "identifier" parameter and tag in the "item" parameter, you can pull any dates for any company. You can add multiple parameters to the same call by separating the with a comma, up to 150 parameters per call:
If you click "Download" in the data explorer, you will notice a ".csv" is added to the syntax:
When you paste this into your web browser or embed it in your code, it will download a CSV of the data.
How to access the data via Excel or Google Sheets
If you haven't installed the Google Sheets add-on or the Excel add-in, it is free and easy. The API explorer will also build custom functions that work in Excel or Google Sheets- the formulas are the same on both platforms. You'll simply combine the =intriniodatapoint() function with a ticker and data tag.
The formula will look like this:
When you use an Intrinio custom formula in your spreadsheet, it will pull the most recent data any time you update the spreadsheet. You can use relative references for the ticker and the data tag to quickly drag your formulas and pull many data points for many companies. Simply put a list of tags across the top and a list of tickers on the left.