Trade Alert US Options Prices | Intrinio

Trade Alert US Options Prices

Provided by Trade Alert
Info
Pricing
Documentation
Resources
Data Explorer

Analyze EOD Options Prices

The Trade Alert US Option Prices data feed brings end of day (EOD) options prices from the United States directly to Excel or API, allowing developers and analysts to build apps and systematic analyses in Excel. Prices are released every morning. Users can access the most recent close data via a subscription or request a bulk download of historical data. Chat with our team for pricing on 3, 6, and 9 years of historical EOD options prices.

Take A Free Trial or Request A Sample Download

The free trial lasts 3 days and allows users to sample both historical and current option data. The $100/mo self-signup subscription includes a license for individual internal use of the most recent (non-historical) EOD options prices. Enterprise and display licenses are available up request. Chat with our team to receive a quote or a sample download of historical data. 

Flexible Access

This data is available via Excel, Google Sheets, Web API.

Have Questions?
Features
  • Close Price, Closing Bid, Closing Ask
  • Close Volume, Close Bid Volume, Close Ask Volume
  • Implied Volatility
  • Open Interest
  • Count of Daily Trades
  • Coverage for all US Securities
  • Current and Historical Prices Dating to 2008
Choose a plan:
Current Prices
terms
Your Price
Questions?
Chat with Us
$
Subscribe
Need to take a test drive?
100 API calls free Free Trial
Looking for an enterprise solution?
High limits, custom terms, flexible licensing Contact Us

Frequently Asked Questions

Below you will find the most frequently asked questions about this data feed. We have also curated some resources to help you get started, listed on the right. As always, feel free to chat with us if you have any questions.
What does “current” mean? Is this real time data?
  • No, “current” refers to the latest end of day data. If you need real time options data, you will need our real time OPRA feed from QUODD.
How much history is available?
  • History is available back to a max of 9 years on a rolling basis upon request. 
What time of day is this data updated in your system?
  • Latest end of day data is available in our system at around 10:00 AM EST next day.
How do I return the price for a single contract?
  • First, use the Options formula with a company ticker to return the list of option contracts for that security with the corresponding IDs. Then, use the contract ID returned in the above formula and plug it into the Options Prices formula.
Can I view this data in Excel?
  • Yes, you’re able to access options data through the API and Excel add-in.
- or -
Data Categories

Intrinio offers a variety of ways to access this data feed. Choose your preferred access method below:

API
Excel
Sheets
CSV

API Documentation

There are two versions of our API. We recommend "v2". To learn which one may be right for you, click here.
API v1
API v2

{{ docSectionTitle }} Documentation

Welcome to the Intrinio Financial Data Platform! Through our Data Marketplace, we offer a wide selection of financial data feeds sourced by our own proprietary processes as well as from many data vendors. The Intrinio API uses HTTPS verbs and a RESTful endpoint structure, which makes it easy to request data from Intrinio. Basic Authentication is administered over HTTPS. Responses are delivered in JSON format.

If you need additional help in using the API, chat with us.

Getting Started

For a quick guide to getting started with our API, please see the Tutorial.

Authentication

Private

For private/trusted environments, use Basic Authentication over HTTPS.

You can find your API Username and API Password on your Account page. You must include these credentials with every request in order to receive access to the API.

To include the credentials in your HTTPS request, specify an Authorization header, with the value Basic (key) , replacing (key) with the Base-64 encoded string API_USERNAME:API_PASSWORD .

If your credentials are not authorized, a status code of 401 will be returned.

Public

For public/untrusted environments (such as client-side JavaScript), use our public key authentication over HTTPS.

You can create a Public Access Key on your Account page. Make sure to specify all domains from which this key may be used. Any domain not listed will be rejected by the API. For development purposes, localhost is listed as a domain by default. Make sure to delete this domain before going to production.

To include a public key in your HTTPS request, specify it as the value of an X-Authorization-Public-Key header.

If your public key is not authorized, a status code of 401 will be returned.

Response Codes

Intrinio uses normal HTTP response codes to indicate the success or failure of an API request. A response code of 200 indicates success and codes in the 4xx range indicate an error that failed given the information provided, and codes in the 5xx range indicate an error with Intrinio’s servers (these are rare).

The Intrinio API uses the following error codes:

Code Meaning
200 OK – Everything worked as expected
401 Unauthorized – Your User/Password API Keys are incorrect
403 Forbidden – You are not subscribed to the data feed requested
404 Not Found – The endpoint requested does not exist
429 Too Many Requests – You have hit a limit. See limits
500 Internal Server Error – We had a problem with our server. Try again later.
503 Service Unavailable – You have hit your throttle limit or Intrinio may be experiencing high system load.

Paging

Often there is too much information in our system to serve in a single request of reasonable size. Therefore we limit results to a certain number per request and provide you with paging information which can be used to retrieve the remaining pages of data.

In the Web API, you will notice that most requests contain paging information.

File Downloads may have paging information as well, listed in the first row.

In order to request the next page of data, append a page_number parameter to your request:

https://api.intrinio.com/companies
https://api.intrinio.com/companies?page_number=2
https://api.intrinio.com/companies?page_number=3

Limits

The Intrinio API employs several reasonable limits to ensure that stable, reliable service is provided to all users. These limits can vary based on which data feeds you are subscribed to, as well as which API call you are making. The limits are grouped as: daily calls, 10-minute calls, paging, throttling, and timeouts. If you hit an API limit, the response will contain a 429 code and an explanation of the limit.

Daily Call Limits

Most data feed subscriptions have limited daily usage. This means that you can make up to a certain number of API calls in a 24-hour period (resetting at midnight Eastern). To view the limits for a data feed subscription, go to your Account page, click on Subscriptions, click on the subscription in question, and click on Limits.

10-Minute Call Limits

Some data feed subscriptions have limited 10-minute usage. This means that you can make up to a certain number of API calls in a 10-minute period.

1-Minute Call Limits

As an alternative to Daily Call Limits, some data feeds employ a 1-minute call limit. This means that you can make up to a certain number of API calls in a 1-minute period.

Paging Limits

API endpoints that employ paging are limited by the maximum page size that you may request. This varies by endpoint:

Endpoint Maximum Page Size
/historical_data 1,000
All others 100

Throttle Limits

Users enjoying free data feed subscriptions only are limited to 100 requests-per-second.

Timeout Limits

Each request must be fulfilled within 25 seconds, otherwise it will be dropped with a 503 error. Given the flexibility of our endpoints and the complexity of potential API calls, we leave it to the users to fashion requests which can be satisfied in a reasonable time.

Usage & Limits

The following endpoints will help you to check your API access, limits, and usage:

Note: this is limited to data feeds with daily API call limits.

Endpoints

Below are all of the API endpoints available for this data feed:

Welcome to the Intrinio Financial Data Platform! Through our Data Marketplace, we offer a wide selection of financial data feeds sourced by our own proprietary processes as well as from many data vendors. The Intrinio Excel Add-In allows you to access a variety of datasets right in Excel, using simple, intuitive functions.

The Excel Add-in works on both Mac OS X and Microsoft Windows versions of Excel.

If you need additional help, chat with us.

Getting Started

For a quick guide to getting started with our Excel Add-In, please see the Tutorial.

Functions

Below are all the functions available for this data feed:

Welcome to the Intrinio Financial Data Platform! Through our Data Marketplace, we offer a wide selection of financial data feeds sourced by our own proprietary processes as well as from many data vendors. The Intrinio Google Sheets Add-On allows you to access a variety of datasets right in Google Sheets, using simple, intuitive functions.

If you need additional help, chat with us.

Getting Started

For a quick guide to getting started with our Google Sheets Add-On, please see the Tutorial.

Functions

Below are all the functions available for this data feed:

Welcome to the Intrinio Financial Data Platform! Through our Data Marketplace, we offer a wide selection of financial data feeds sourced by our own proprietary processes as well as from many data vendors. All of our data is available for download in the CSV (comma-separated values) format.

If you need additional help, chat with us.

Getting Started

For a quick guide to getting started with our CSV Download functionality, please see the Tutorial.

Authentication

When using the download links, your browser will prompt you for a username and password. These credentials correspond to your access keys, which can be found in your Account page.

Paging

Sometimes there is too much information in our system to put into a single file of reasonable size. Therefore we limit file downloads to 10,000 rows. In order to retrieve the rest of the rows, you will have to request the second "page" of results. The first row of each file will contain paging information: RESULT_COUNT: 6342 , PAGE_SIZE: 10000 , CURRENT_PAGE: 1, TOTAL_PAGES: 1 , API_CALL_CREDITS: 1

  • RESULT_COUNT tells you how many total rows there are in our system
  • PAGE_SIZE tells you how many records you are fetching per page
  • CURRENT_PAGE tells you which page you are currently viewing
  • TOTAL_PAGES tells you how many total pages there are
  • API_CALL_CREDITS tells you how many API calls credits your request consumed

If the TOTAL_PAGES field in your file is greater than 1 and you want to see the other pages, append a page_number parameter to the URL:

https://api.intrinio.com/indices.csv?type=economic&page_number=1
https://api.intrinio.com/indices.csv?type=economic&page_number=2
https://api.intrinio.com/indices.csv?type=economic&page_number=3

To exclude the paging information from your file, include a hide_paging parameter in the URL:

https://api.intrinio.com/indices.csv?type=economic&page_number=1&hide_paging=true

URL Formatting

URLs must be formatted correctly in order for file downloads to be processed successfully. Here are examples of correct URLs:

https://api.intrinio.com/indices.csv
https://api.intrinio.com/indices.csv?type=economic
https://api.intrinio.com/indices.csv?type=economic&query=GDP
https://api.intrinio.com/data_point.csv?identifier=AAPL&item=marketcap,beta

Here are examples of incorrect URLs:

https://api.intrinio.com/indices.csv&type=economic
https://api.intrinio.com/indices.csv?type=economic?query=GDP
https://api.intrinio.com/data_point.csv?identifier=AAPL&item=marketcap/beta

Here is a key to the different parts of a URL:

https://api.intrinio.com /data_point.csv ? identifier = AAPL & item = marketcap,beta
1 2 3 4 5 6 7 8 9 10

  1. Intrinio's API web address.
  2. The location of the data you are trying to access.
  3. The separator between the URL address and the URL parameters.
  4. The name of the URL parameter.
  5. The separator between the name of the URL parameter and the value of the URL parameter.
  6. The value of the URL parameter.
  7. The separator between URL parameters.
  8. The name of the URL parameter.
  9. The separator between the name of the URL parameter and the value of the URL parameter.
  10. The value of the URL parameter. Note some parameters allow multiple values - separate them with a comma.

Functions

Below are all of the CSV file downloads available for this data feed:

Returns the master list of option contracts for a given ticker.

Parameters

expand collapse
Name Description Example
ticker The option ticker symbol, corresponding to the underlying security. AAPL
expiration The contract expiration date. 2018-04-03
type
The contract type.
Options:
put
call
put
page_number An integer greater than or equal to 1 for specifying the page number for the return values. 4
page_size An integer greater than or equal to 1 for specifying the number of results on each page. 10
hide_paging
Hide first row of paging information.
Options:
true
true

Output Fields

expand collapse
Name Description Example
identifier the contract identifier, used for Data Point and Historical Data endpoints AAPL190118C00195000
ticker the option ticker symbol, corresponding to the underlying security AAPL
expiration the contract expiration date, in format YYYY-MM-DD 2019-01-18
strike the contract strike price 195
type the contract type, either put or call call

Sample Data

expand collapse

Options Lookup

Returns the master list of option contracts for a given ticker.
URL: https://api.intrinio.com/options?ticker=AAPL

Options Lookup

Returns the master list of option contracts for a given ticker.
URL: https://api.intrinio.com/options.csv?ticker=AAPL

Options Lookup

Not available for this access method

Options Expirations

Returns all option contract expiration dates for a given ticker.

Parameters

expand collapse
Name Description Example
ticker The option ticker symbol, corresponding to the underlying security. AAPL
hide_paging
Hide first row of paging information.
Options:
true
true

Sample Data

expand collapse

Options Expirations Master

Returns all option contract expiration dates for a given ticker.
URL: https://api.intrinio.com/options/expirations?ticker=AAPL

Options Expirations Master

Returns all option contract expiration dates for a given ticker.
URL: https://api.intrinio.com/options/expirations.csv?ticker=AAPL

Options Expirations Master

Not available for this access method

Options Current Prices

Returns the current prices for the given option contract(s).

Parameters

expand collapse
Name Description Example
ticker The option ticker symbol, corresponding to the underlying security. AAPL
expiration The contract expiration date. 2017-02-17
type
The contract type, either put or call.
Options:
put
call
put
strike The contract strike price. 136
hide_paging
Hide first row of paging information.
Options:
true
true

Output Fields

expand collapse
Name Description Example
date the price date, in the format YYYY-MM-DD 2017-02-14
expiration the contract expiration date, in the format YYYY-MM-DD 2017-02-17
strike the contract strike price 136
type the contract type, either put or call call
close the closing price of the contract 0.43
close_bid the closing bid price of the contract 0.42
close_ask the closing ask price of the contract 0.44
volume the closing volume of the contract 19349
volume_bid the closing bid volume of the contract 7075
volume_ask the closing ask volume of the contract 6815
trades the number of trades executed that day 915
open_interest the open interest at the end of the day 8538
open_interest_change the change in open interest from the previous day 3074
next_day_open_interest the open interest at the start of the next day 12625
implied_volatility the implied volatility of the contract 0.169001
implied_volatility_change the change in implied volatility that day -0.009107
delta the delta of the contract vs the underlying security 0.321807

Sample Data

expand collapse

Options Current Prices Lookup

Returns the current prices for the given option contract(s).
URL: https://api.intrinio.com/options/current?ticker=AAPL

Options Current Prices Lookup

Returns the current prices for the given option contract(s).
URL: https://api.intrinio.com/options/current.csv?ticker=AAPL

Options Current Prices Lookup

Not available for this access method

Options Historical Prices

Returns the historical prices for the given option contract.

Parameters

expand collapse
Name Description Example
ticker The option ticker symbol, corresponding to the underlying security. AAPL
expiration The contract expiration date. 2017-01-20
type
The contract type.
Options:
put
call
put
strike The contract strike price. 145
page_number An integer greater than or equal to 1 for specifying the page number for the return values. -
page_size An integer greater than or equal to 1 for specifying the number of results on each page. 10
hide_paging
Hide first row of paging information.
Options:
true
true

Output Fields

expand collapse
Name Description Example
date the price date, in the format YYYY-MM-DD 2017-02-14
expiration the contract expiration date, in the format YYYY-MM-DD 2017-02-17
strike the contract strike price 136
type the contract type, either put or call call
close the closing price of the contract 0.43
close_bid the closing bid price of the contract 0.42
close_ask the closing ask price of the contract 0.44
volume the closing volume of the contract 19349
volume_bid the closing bid volume of the contract 7075
volume_ask the closing ask volume of the contract 6815
trades the number of trades executed that day 915
open_interest the open interest at the end of the day 8538
open_interest_change the change in open interest from the previous day 3074
next_day_open_interest the open interest at the start of the next day 12625
implied_volatility the implied volatility of the contract 0.169001
implied_volatility_change the change in implied volatility that day -0.009107
delta the delta of the contract vs the underlying security 0.321807

Sample Data

expand collapse

Options Historical Prices

Returns the historical prices for the given option contract.
URL: https://api.intrinio.com/options/historical?ticker=AAPL&expiration=2017-01-20&type=put&strike=145

Options Historical Prices

Returns the historical prices for the given option contract.
URL: https://api.intrinio.com/options/historical.csv?ticker=AAPL&expiration=2017-01-20&type=put&strike=145

Options Historical Prices

Not available for this access method

Returns the most recent data point for a selected identifier (ticker symbol, stock market index symbol, CIK ID, etc.) for a selected tag. Income statement, cash flow statement, and ratios are returned as trailing twelve months values. All other data points are returned as their most recent value, either as of the last release financial statement or the most recent reported value.

Function: =IntrinioDataPoint(identifier, item)
Function: =IntrinioDataPoint(identifier, item)

Parameters

expand collapse
Name Description Example
identifier An identifier, which can be a security ticker, SEC CIK ID, FRED Series ID, etc. AAPL
item An item, which can be a data tag or a special code. marketcap
hide_paging
Hide first row of paging information.
Options:
true
-

Output Fields

expand collapse
Name Description Example
identifier the ticker or identifier for the data point AAPL
item the requested standardized tag or series ID name

Sample Data

expand collapse

Data Point Lookup

Returns the most recent data point for a selected identifier (ticker symbol, stock market index symbol, CIK ID, etc.) for a selected tag.
URL: https://api.intrinio.com/data_point?identifier=AAPL&item=marketcap

Data Point Lookup

Returns the most recent data point for a selected identifier (ticker symbol, stock market index symbol, CIK ID, etc.) for a selected tag.
URL: https://api.intrinio.com/data_point.csv?identifier=AAPL&item=marketcap

Data Point Lookup

Returns the most recent data point for a selected identifier (ticker symbol, stock market index symbol, CIK ID, etc.) for a selected tag.
Function: =IntrinioDataPoint("AAPL", "marketcap")

Data Point Lookup

Returns the most recent data point for a selected identifier (ticker symbol, stock market index symbol, CIK ID, etc.) for a selected tag.
Function: =IntrinioDataPoint("AAPL", "marketcap")

Data Point Lookup

Not available for this access method

Data Point Multiple

Returns multiple data points matching the given parameters
URL: https://api.intrinio.com/data_point?identifier=GOOGL,AAPL&item=price_date,close_price,percent_change

Data Point Multiple

Returns multiple data points matching the given parameters
URL: https://api.intrinio.com/data_point.csv?identifier=GOOGL,AAPL&item=price_date,close_price,percent_change

Data Point Multiple

Not available for this access method

Historical Data

Returns the historical data for for a selected identifier (ticker symbol or index symbol) for a selected tag. Income statement, cash flow statement, and ratios are returned as trailing twelve months values by default, but can be changed with the type parameter. All other historical data points are returned as their value on a certain day based on filings reported as of that date.

Function: =IntrinioHistoricalData(identifier, item, sequence)

Parameters

expand collapse
Name Description Example
identifier An identifier, which can be a security ticker, SEC CIK ID, FRED Series ID, etc. AAPL
item An item, which can be a data tag or a special code. marketcap
start_date The earliest date for which to return data. 2018-04-02
end_date The latest date for which to return data. 2018-5-03
frequency
The frequency of the historical prices & valuation data.
Options:
daily
weekly
monthly
quarterly
yearly
yearly
type The type of historical data to fetch. For financial statements, the type reflects the type of financial statement. For Sector data, the type reflect the aggretation (mean, median, max, min) type of the data. FY
sequence An integer 0 or greater for calling a single historical data point from the first entry, based on sort order. 0
show_date
If true, the function will return the date value, and if false the function will return the data point value for a given query.
Options:
Yes
Yes
page_number An integer greater than or equal to 1 for specifying the page number for the return values. 4
page_size An integer greater than or equal to 1 for specifying the number of results on each page. 10
hide_paging
Hide first row of paging information.
Options:
true
true

Output Fields

expand collapse
Name Description Example
identifier the ticker or identifier for the data point @MUSK_51244-TSLA:US
item the requested standardized tag or series ID comp_total_summary
date the date associated with the value of the data tag 2016-12-31
value the value of the Intrinio tag of the financial data point 45936

Sample Data

expand collapse

Historical Data Lookup

Returns the historical data for for a selected identifier for a selected tag.
URL: https://api.intrinio.com/historical_data?identifier=AAPL&item=marketcap

Historical Data Lookup

Returns the historical data for for a selected identifier for a selected tag.
URL: https://api.intrinio.com/historical_data.csv?identifier=AAPL&item=marketcap

Historical Data Lookup

Returns the historical data for for a selected identifier for a selected tag.
Function: =IntrinioHistoricalData("AAPL", "marketcap", 0)

Historical Data Lookup

Not available for this access method