EOD Data: Global Exchange Prices in Excel and API

Intrinio recently partnered with Exchange Data International to provide EOD data from exchanges around the world. This brings the total number of end of day stock price feeds available in Intrinio’s marketplace to more than 160. This article provides information about what is included in each feed and how Intrinio identifies stocks across so many exchanges. If you are looking for specific examples in Excel or API format, this article is a great resource.

What is Included in Each EOD Data Feed?

The US Fundamentals and Stock Prices provides EOD prices for securities traded in the United States. This article provides sample Excel formulas and API syntax for accessing US EOD prices, including high, low, volume, close, open, and prices adjusted for splits and dividends. US EOD data can be pulled for the most recent trading day, a specific range of trading days historically, or for all historical dates back to the 1980s in daily, weekly, monthly, quarterly, and annual periods.

The remaining EOD data is dividend between 160+ data feeds according to exchange. The image above shows just a handful of the exchanges. Each data feed provides complete EOD pricing coverage for the exchange, including close, high, low, volume, and dividend/split adjustments going back to 2007. Here is a list of the regions that are available for EOD data:

  • North America
  • South America
  • Caribbean
  • Europe
  • Asia
  • Africa
  • Middle-East
  • Pacific

How Does Intrinio Identify Securities Across Exchanges?

When you subscribe to an EOD data feed, you can immediately access EOD prices from that feed in Excel or API format. An obvious problem with this architecture is that the ticker symbol used on one exchange to represent a stock might represent a different stock on another exchange.

Intrinio uses two tools to solve this problem. The first is Open Figi, which provides an architecture for uniquely identifying all global securities even if tickers are duplicated. The second is the Intrinio Security Master, which includes functionality for searching indexes, exchanges, and securities.

In API calls and Excel formulas, these two tools combine to produce syntax like this to identify securities:


For example, BHEL, a company that trades on the NSE exchange, would be identified like this:


The “IS” identifier is the Open Figi syntax for NSE and, if combined with a ticker, provides a unique identifier for that security. For US stocks in the Fundamentals feed, no exchange is needed, but for international securities this system makes it possible to use the familiar datapoint and historicaldata endpoints to access data.

Wait, what?

Intrinio provides end of data from exchanges all over the world. You can see all of the options here. If you click on any of the plans, you can see how much they cost.

You can access the EOD prices in Excel or API. With so many exchanges, ticker symbols get duplicated. Intrinio uses the Open Figi syntax to solve this problem, including the ticker and the exchange in your syntax.

Have questions? Chat with our team.