Stock Prices From Intrinio

Andrew Carpenter
November 11, 2016

There are many kinds of "stock prices" and there are also many ways to access those prices. This article explains the different types of stock price data available from Intrinio and the different ways investors or developers can access those prices as well as the cost for subscribing.

What Stock Prices and Access Methods are Available?

Here are quick links to articles explaining the various types of prices sold in the marketplace:

  • Real-time stock prices from major US exchanges including NASDAQ, NYSE, options, FX, and commodities
  • Real-time stock prices from the IEX exchange, the most affordable stock prices on the market
  • End of day (High, Low, Open, Close, Adjusted) prices from International Exchanges
  • EOD prices from the United States, including fundamentals and valuation metrics
  • EOD Options prices for the United States

And here are links to documentation for our various access methods:

How Developers Can Access Stock Prices

If you are unfamiliar with Intrinio's REST API, this article will give you a great introduction with links to the documentation and other useful tools. The REST API is used for pulling historical stock prices for US and International stocks. The prices endpoint makes it easy to get multiple high/low/open/close (HLOC) datapoints in a single API call:

https://api-v2.intrinio.com/securities/AAPL/prices

For US securities, you can just vary the ticker parameter and for international securities, you simply add the exchange. You can also get real-time stock prices via REST-API:

https://api-v2.intrinio.com/companies/AAPL/data_point/last_price/number

If you are interested in pulling prices for a specific range of dates, the historical_data endpoint can be used as well as the prices endpoint:

https://api-v2.intrinio.com/companies/AAPL/historical_data/close_price?start_date=2014-01-01&end_date=2015-01-01

To see EOD or real-time prices via REST-API, you simply need to have a subscription to the proper data feed. If you try to pull data from an exchange and aren't subscribed, the API response will tell you which data feed you need to add to your account. There are plenty of SDKs that wrap the Intrinio API to make your life easier; just pick one from your favorite language.

If you are using the API, it can be helpful to note that the securities endpoint can be called with an optional parameter, last_crsp_adj_date, that returns a list of securities that have adjusted their stock prices due to a corporate event. This parameter is useful for configuring your application to only update historical prices if they have changed.

Pulling EOD prices via REST API makes sense for EOD prices or real-time prices if you don't need to update the data very often. If you want to truly stream a high volume of real-time prices, a WebSocket API will work better. Whereas the REST API limits the number of calls you can use in a certain time-span, WebSocket subscriptions allow an unlimited number of price updates from a limited number of stocks.

These WebSocket options make it easy to stream prices from popular exchanges. Request a consultation with our team to find the right solution for your needs.

How Investors Can Access Stock Prices

Typically, non-developers prefer to download financial data to Excel for analysis. Real-time as well as historical EOD stock prices for US and international exchanges and even options prices are available in both formats. In Excel, users can simply use the IntrinioSecurityPrices template that comes with the download.

Alternatively, Excel users can use the "datapoint" function to build custom templates:

To get the most recent close price:

=intriniodatapoint("AAPL", "close_price")

Or the most recent real-time price:

=intriniodatapoint("AAPL", "last_price")

This same "=intriniodatapoint("identifier", "tag") formula can be used to get international EOD prices and EOD options prices as well.

A second formula, "=intriniohistoricaldata" can be used in Excel to pull historical stock prices as well as other data.

=intriniohistoricalprices("AAPL", "low",  1, "2006-01-01", "2016-01-01", "daily")

The historical data include adjusted data points that account for splits, reverse splits, and dividends. Index prices don't include adjusted figures since indexes don't have splits or dividends.

If you have questions about the proper syntax, feel free to try the API Explorer. It builds the syntax for you, and you can always chat with our team to get answers to your questions by clicking the chat bubble in the corner.

How much does this cost?

Our data feeds are customizable. Request a consultation with our sales team to get started.

When choosing a plan for a prices data feed, you need to ask 3 questions:

  • Do I need to redistribute this data or is it for my own, internal use?
  • Do I qualify as a startup, making less than $10,000/month with less than $200,000 in funding?
  • Do I need a large amount of data or just a few datapoints (this article explains how we count data points)?

It's important to note that WebSocket APIs are priced slightly differently than rest APIs. Your typical data feeds (found via Rest APIs and on Excel) are priced based on two things: how the data is used and the amount of data used in a given period of time. On the other hand, WebSocket APIs (like NASDAQ and IEX), are priced in terms of concurrent connections and connections from specific points in time.

The IEX plan, for example, allows for up to 10 concurrent connections at a time, meaning the real time prices for up to 10 stocks can be obtained with a continuous flow of new prices as they are updated on the exchange. The plan allows for a total of 1,000 total daily connections, meaning a user can connect to up to 1,000 different security pricing feeds over the course of a day, changing them as necessary.

Wait, what?

Stock prices are complicated - there are many types of stock prices, many access methods, and even different exchanges and legal requirements to consider. Our support team is really experienced at helping all types of users find the right data, the right subscription, and the right syntax to start pulling data. Just ask, and we will make it easy for you.

Request a Consultation

Sorry, we no longer support Internet Explorer as a web browser.

Please download one of these alternatives and return for the full Intrinio Experience.

Google Chrome web browser icon
Chrome
Mozilla Firefox web browser icon
Firefox
Safari web browser icon
Safari
Microsoft Edge web browser icon
Microsoft Edge