First Time Here?
Purpose
What are you looking for in historical options data? Do you want to backtest your trading system? Studying at a university? Do you track existing trades in your portfolio?
Which Product Type
If you are collecting data for backtesting or research, chances are you’re looking for historical data.
If you’re following existing trades or looking for new opportunities, chances are you’re looking for ongoing subscription data.
How many symbols are you following?
Our data set covers all options traded in the U.S. Equities market. That could be over 1.5 million option lines of data each day covering over 5,900 stocks, ETFs and indices. Will you choose a few symbols, or do a broad study?
Tools
How are you going to work with the data? There are three general methods as follows.
-
- Excel spreadshseet
- Custom Programming
- Relational Database
Your first option will be to use the skills and tools you already have. This is the one you are most familiar with. You will quickly discover that a simple Excel spreadsheet can become overwhelming when trying to process the entire dataset, every symbol traded in the U.S. Equities market. To conduct a large-scale study covering more than a dozen symbols, you need to learn how to populate and query a database.
Being able to write computer code (scripts or entire applications) increases the number of symbols you can manage. Writing a SQL query to search is much easier than finding it in Excel.
Which Products?
If you only use Excel, you’re probably only interested in a few symbols, and you’d be better off checking out the “Single Symbols” product. You can choose the desired symbols you want and the date ranges. You may wish to subscribe to that symbol going forward and receive daily updates for it. The most commonly selected single symbol is SPX.
If you have programming skills or have access to a database, you can manage more symbols. You can then choose to receive the data via CSV or SQL. The most common data sold on this website is in CSV format, and users can manipulate the data by scanning the CSV file with custom programming or importing it into their favorite familiar relational database, such as PostGres, MySQL, or MSSQL.
Many people choose MySQL for cost reasons, but many people don’t know that Microsoft offers a free Developer’s Edition. If you are coding on a Linux system, then most likely you will select MySQL or PostGres. If you are coding on a Windows system, you will most likely choose Microsoft SQL.
You can start making these decisions now. We strongly recommend that you visit the samples page and download the file in the same format that you will be purchasing.
Supporting Links
We are listed as an approved vendor for options data under our parent company, DeltaNeutral.com.
Follow this link and click on the Find A Vendor tab. Option Pricing Reporting Authority
What is a CSV file? CSV File Basics
The risks of trading options. Characteristics and Risks
The Developer’s Edition of Microsoft SQL Server. It is the same as the Enterprise
edition, but limited to 10 connections. Microsoft Download Site
MySQL Server
Sample Pages of our data products. Sample Files
What packages we have for sale. Our Catalog
How to BULK INSERT your data
Recommendations to insert the data into a database:
- Create a blank temporary table with no indexes that matches exactly the structure of the CSV file. This file could be an options file, optionstats file, or stockquotes file.
- Perform the BULK INSERT command on one file.
- Copy the results of the insert into your main table (that may already contain other days, and has indexes).
- Truncate the temporary table and repeat using the next CSV file.
- It is very slow and risky to bulk insert into your main table. It would be hard to undo an insert, and the indexes would make it very slow. Use a temporary empty table for this.
- https://sqlserverguides.com/sql-server-bulk-insert-from-csv-file/
- https://www.youtube.com/watch?v=KKiaX0vfulc