Stock Price API and Excel add-in. Real time and EOD prices

Intrinio’s support team has chatted with thousands of users. One of the most common topics they ask us about is adding new data types to the Intrinio Financial Data Marketplace. They are fed up with data they get from other providers because it is hard to access and expensive. We use those requests to prioritize the data we add next because we know if our users are asking for it it means there aren’t any good solutions out there. The first data we prioritized based on user requests was stock prices. Our stock price API is unprecedentedly affordable and easy to access in Excel or API format.

This article explains the ins and outs of the stock price API, how it is used in Excel, and what comes next from Intrinio for stock prices.

One Stock Price API, Many Data Feeds

Intrinio has a single API that is split into numerous data feeds. Each of those data feeds accesses a different part of Intrinio’s financial database. You can view all of Intrinio’s data feeds that contain stock prices in the marketplace.

One data feed, US Fundamentals and Stock Prices,  includes real time US stock prices in addition to other types of US fundamentals data. Twenty-eight more include end of day (EOD) prices for exchanges from around the world. The IEX Real-Time Stock Prices data feed is technically not a stock price API but rather a web socket. This article explains the difference between a web socket, which streams real time prices, and an API, which pulls real time prices at a point in time.

The benefit of this model, with a single API and multiple feeds, is that it allows Intrinio to make stock prices affordable and easy to access. Affordable because the data feeds aren’t bundled, so you only buy the data segments you need. Easy to access because there is only one API to learn how to use. Other data providers have a separate API for each data vendor.

Using the Stock Price API in Excel

Developers need stock price APIs to build fintech apps and that is why Intrinio provides stock prices in API format. Price Series and Factom are examples of companies that built apps using Intrinio’s API. The most popular app using Intrinio’s stock price API is Excel. You can install the Excel add-in here.

Non-developer financial analysts are often confused as to why their data plans have API call limits when they are accessing the data in Excel. This article explains what an API call is and how they are counted. The Intrinio Excel add-in was built using Intrinio’s API. So, you can type this into a cell to pull the latest real time price for AAPL:

=intriniodatapoint(“AAPL”, “last_price”)

or this to pull the EOD price for a NSE listed stock from India:

=intriniodatapoint(“BHEL:IS”, “close_price”)

or this to see the volume for Microsoft from 1 week ago:

=IntrinioHistoricalPrices(“MSFT”,”volume”, 7, “2014-01-01”, “2016-01-05”, “daily” )

Excel is really using Intrinio’s API to pull the data for you. Excel makes it easy; you don’t have to know the API syntax to pull in the data. The ease of use that comes with using the Excel add-in is made possible by Intrinio’s API. The API makes it simple and affordable for developers to build applications for financial analysts.

What Comes Next For Intrinio Stock Prices

Intrinio gets so many data requests we created a form so users can tell us the data types they need. That way, when we add them to the marketplace, they will be automatically notified that the data they need is available. Fill it out if you are dissatisfied with the existing solutions. Chances are, Intrinio will be making that data type affordable and easy to access before you know it.

Intrinio is currently integrating EOD options pricing for the US into our database and will make that data available presently. Intraday historical prices and real time prices from multiple exchanges are also on the agenda.

The stock price API is just the start of our efforts to expand access to financial data. In the coming year we will be expanding into all types of data because we believe our users will lead more meaningful lives if they save money and make make time by using our platform.