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 150. You can see them all here, and 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?

EOD Data for US Stocks

EOD Prices for US Stocks, as well as fundamentals are available in this feed.

The US Public Company Financials Data Feed 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.

EOD Data from International Exchanges

EOD Prices for International Exchanges

The remaining EOD data is dividend between 150+ 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:

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, Google Sheets, 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:

TICKER:EXCHANGE

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

BHEL:IS

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:

Pricing plans for EOD Data

Pricing Plans for EOD Data are On All Product Pages

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.

Chat with Us If You Have Questions About EOD Data
  • Alex Demin

    Link to OTC BB stocks is broken.

  • Rachel Carpenter

    Thanks Alex! Fixed.