One of our most frequently requested data types is international stock prices. Exchange Data International (EDI) is a trusted source for EOD stock prices from around the globe as well as over the counter (OTC) and corporate actions data. We are pleased to announce that EDI data will now be available in the Intrinio Fintech Marketplace.
Pairing EDI’s much sought after data types with Intrinio’s platform will provide Intrinio’s users with a crucial data source and make it easier than ever to access EDI data. We launched the marketplace to make financial data affordable and easy to access- partnering with EDI allows us to expand that vision.
This article explains which EDI data feeds will be available, how much they cost, and how to access them in Excel or API formats. If you are interested in how Intrinio uses the Security Master to identify stocks across international exchanges, this article is a good resource.
Which EDI Feeds Are Available?
You can search all of the data feeds in the marketplace where you can select “Prices” to see the EDI plans:
You will notice many EDI plans as well as several non-EDI plans that also include stock prices. You can search by continent to see the plans that are available in each region.
Clicking on any of the data feeds will reveal a product page. Each product page includes the basic details of the plan:
- Data types
- Access methods
- Chat support for questions
- Terms and plan limits
- An option to subscribe
EDI international stock prices are separated by exchange and include EOD stock prices. For example, it is possible to subscribe to Bombay Stock Exchange Prices, National Stock Exchange of India (NSE) Prices, Toronto Stock Exchange Prices, or data feeds from more than 150 other exchange data feeds.
The feeds include historical prices back to 2007, high, low, volume, open, and close as well as prices adjusted for splits and dividends.
How much do they cost?
As with all Intrinio data feeds, you can see the pricing plans that are available on each product page:
Intrinio usually splits pricing plans into three categories – Individual, Startup, and Enterprise. Individual plans do not include redistribution but any number of analysts or developers at a firm may be added as collaborators to a single paid plan. Startup plan’s include redistribution and are intended for new firms with less than $10,000 in monthly recurring revenue (MRR) and less than $200,000 in funding. Enterprise plans are designed for larger firms with custom needs and can be tailored to fit redistribution, data volume, and access requests.
In keeping with our mission of increasing the affordability and accessibility of financial data, our goal is to keep the prices of these data feeds competitive with other providers.
How can They be Accessed in Excel?
If you haven’t already installed Intrinio’s free Excel add-in, follow this tutorial. If you have used Excel to access Intrinio data in the past, you might have used this syntax:
The datapoint function is used to pull the most recent data for a stock with the ticker representing a stock symbol and the tag representing a data type. Pulling the most recent close price for Bharat Heavy Electricals Limited, a NSE listed stock, would look like this:
There are thousands of stocks and hundreds of tags that can be used with the data point function in Excel. You can look up the tags for EDI data feeds here and look up the tickers here using OpenFIGI. You can view the documentation for EDI here. The Stock Exchange master, which provides a definitive list of the exchanges covered by Intrinio, is located here.
It is important to note that you must specify an exchange along with a ticker. OpenFIGI makes it possible to look up these combinations since a single ticker symbol might represent different stocks or be on different exchanges.
The Intrinio historical data function is also available for most EDI data feeds:
=intriniohistoricaldata(“ticker”, “tag”, sequence, “start_date”, “end_date”, “frequency”)
This functionality allows an analyst to determine what an EOD price from an international exchange was on a certain date in the past. For example, to see the close price from the previous example for 100 days ago, this syntax would be used:
=IntrinioHistoricalData(“BHEL:IS”, “close_price”, 100, “2007-01-01”, “2017-01-01”, “daily”)
This article gives a more detailed description of the historical data function. Our help page provides great resources for learning how to access EDI data in Excel, including a link to our documentation and the ability to chat with our team.
How can International Stock Prices and Other EDI Data be Accessed in API Format?
If you aren’t already familiar with the Intrinio API, this article will get you started. It includes examples of how to authenticate, sample code in numerous languages, and sample API calls.
The same base syntax that works in Excel for datapoint is also available for EDI data via the API. Here is an example for the close price of BHEL from NSE:
That syntax can be used with any ticker or EDI tag if you are subscribed to the proper EDI data feed. Pulling the historical data would look like this:
To get all EOD data for specific date, use the identifier for the exchange. For page two from 2017-01-24 from NSE:
It is crucial to remember that international stock prices from EDI require an exchange and an identifier concatenated together in this format: ticker:exchange
Why get EDI Data From Intrinio?
Unlike big data providers, Intrinio doesn’t bundle international stock prices into an expensive monthly subscription. Unlike smaller data providers, Intrinio only has one API. This means you can subscribe to the data feeds you need from EDI or other providers while still using a single API or Excel syntax rather than a different syntax for each provider.
This simplicity and cost structure is designed to make financial data easy to access and affordable for fintech developers and financial analysts. Pairing EDI estimates of earnings with Intrinio’s platform is a win for financial data consumers everywhere.