Note that you can't redistribute this data or generate income through it [0] per the Yahoo TOS [1].
Also note that Yahoo's data is somewhat unreliable [0, 2].
Unfortunately options data is just hard to get access to due to the agreements forced on providers by the exchanges. If you want to build a trading system on it without an institutional budget, the best options I've found so far are QuantConnect [3], which has paid for it and lets you build your system on their platform and OptionWorks [4], which you can pay $150 for and download all the data. You should be able to get a live feed from your broker after that. If you want it for academic research, many universities and colleges have access to much higher quality data.
I would not recommend to use the Yahoo or Google apis to get option prices. Some of the bid/ask prices are completly wrong and some expiration dates are missing. I created an option scanner as a side project and found about this bad data quality the hard way.
How's the data quality of OptionWorks? Do they have the indicies? I bought several years of EOD data for SPX from https://www.historicaloptiondata.com/ and found it to be of only moderate quality. (Charting some of the data on multiple dimensions makes the stuff that is padded stick out like a sore thumb... I ended up tossing about 20% of the data).
Is option prices what I think of when I think "Stock Data"? I've been wanting to download and play around with processing "Stock Data" but I don't really know what I'm looking for. What metrics are stocks judged by? I'm assuming price is only one of many things.
> Is option prices what I think of when I think "Stock Data"?
You may be thinking of simply stock prices or stock fundamentals (income, expenditures, that kind of stuff) but you may also be thinking of other things like sentiment or analyst opinions. There's a huge range of things you can look at. Options prices are certainly one kind of stock data though, they give valuable information like implied volatility (how much the market at a particular time expects the stock to move in a particular period in the then future).
If you're interested in stock data, Quandl (http://quandl.com) has a broad selection of the different kinds available (though you don't have to purchase there) and Quantopian (https://quantopian.com/) has some examples of how to use it.
To be clear though, options are not stocks.
A stock is a share of ownership of a company. You buy it, you sell it, that's it.
An option is a contract between you and another party that gives you the right but not the obligation to buy or sell a stock at a particular price for a certain amount of time.
Practical examples:
- I buy 10 AAPL stock at $100. I now own $1000 worth of Apple. AAPL's stock price rises to $110. I now own $1100 of AAPL stock, which I can sell and make $100.
- I buy a contract that gives me the right to purchase AAPL (an AAPL call option) for $100 (the "strike price" is $100) which expires in 30 days. This right is limited to 100 AAPL shares and I pay $500 for it. For the next 30 days, regardless the price of AAPL stock, I can buy 100 AAPL for $100 each. If the price of AAPL drops, I lose the $500 I paid for the rights. If the price of AAPL rises to the $110 from earlier, I can either buy 100 shares of AAPL for $100 and sell them immediately for $110, making $1000 - $500 (for the contract) = $500, or I can simply sell the rights to someone else and make the profit more cleanly.
This isn't meant to be an exhaustive course on how each security works, just an illustration of exactly how different they are, yet affect each other.
I posted this here because after many years, it has proven difficult to get simple options prices. There seem to be a lot of paid services and misinformation.
This guy [1] has written a neat post on generating option data from historic raw data. Would be quite interesting to compare the results on 1-minute data compared to raw prices. It seems OK for longer holding periods, where you'd mostly look to use options as directional leverage on underlying large caps.
I've seen this too but I don't think it's particularly valuable as it seems to base the prices on measured volatility, while the actual market prices them entirely differently. You can see in his chart at the bottom that the price diverges from real data by a full dollar at points and that's just for SPY, I'd be interested to see how it goes for something like VIX.
I tried using this and got really excited when I thought I found some options that were grossly mispriced (indicating that I could buy them, immediately exercise them, and make a hefty profit). Turns out that Yahoo just has bad data sometimes.
At QuantConnect we offer minute level options trades"es for your backtesting. Its 400TB of data :D. (I'm founder of QC). To backtest it we run it on 5GHZ water cooled machines! We play with really fun toys :D
You can also use symbol=CMG170915P00580000 to get a specific strike and save a lot of bandwidth, unless you happen to need the entire series or all series/expirations
[+] [-] _dvdu|9 years ago|reply
Also note that Yahoo's data is somewhat unreliable [0, 2].
Unfortunately options data is just hard to get access to due to the agreements forced on providers by the exchanges. If you want to build a trading system on it without an institutional budget, the best options I've found so far are QuantConnect [3], which has paid for it and lets you build your system on their platform and OptionWorks [4], which you can pay $150 for and download all the data. You should be able to get a live feed from your broker after that. If you want it for academic research, many universities and colleges have access to much higher quality data.
This should be fine for personal use though.
[0]: https://meumobi.github.io/stocks%20apis/2016/03/13/get-realt...
[1]: https://policies.yahoo.com/us/en/yahoo/terms/product-atos/ap...
[2]: https://seekingalpha.com/instablog/6052771-kevin-wrotenbery/...
[3]: https://quantconnect.com
[4]: https://www.quandl.com/databases/OWCS
[+] [-] Schweigi|9 years ago|reply
I would not recommend to use the Yahoo or Google apis to get option prices. Some of the bid/ask prices are completly wrong and some expiration dates are missing. I created an option scanner as a side project and found about this bad data quality the hard way.
[+] [-] matheweis|9 years ago|reply
[+] [-] imichael|9 years ago|reply
[+] [-] caleblloyd|9 years ago|reply
https://developers.tradeking.com/documentation/market-option...
[+] [-] gravypod|9 years ago|reply
[+] [-] Veratyr|9 years ago|reply
You may be thinking of simply stock prices or stock fundamentals (income, expenditures, that kind of stuff) but you may also be thinking of other things like sentiment or analyst opinions. There's a huge range of things you can look at. Options prices are certainly one kind of stock data though, they give valuable information like implied volatility (how much the market at a particular time expects the stock to move in a particular period in the then future).
If you're interested in stock data, Quandl (http://quandl.com) has a broad selection of the different kinds available (though you don't have to purchase there) and Quantopian (https://quantopian.com/) has some examples of how to use it.
To be clear though, options are not stocks.
A stock is a share of ownership of a company. You buy it, you sell it, that's it.
An option is a contract between you and another party that gives you the right but not the obligation to buy or sell a stock at a particular price for a certain amount of time.
Practical examples:
- I buy 10 AAPL stock at $100. I now own $1000 worth of Apple. AAPL's stock price rises to $110. I now own $1100 of AAPL stock, which I can sell and make $100.
- I buy a contract that gives me the right to purchase AAPL (an AAPL call option) for $100 (the "strike price" is $100) which expires in 30 days. This right is limited to 100 AAPL shares and I pay $500 for it. For the next 30 days, regardless the price of AAPL stock, I can buy 100 AAPL for $100 each. If the price of AAPL drops, I lose the $500 I paid for the rights. If the price of AAPL rises to the $110 from earlier, I can either buy 100 shares of AAPL for $100 and sell them immediately for $110, making $1000 - $500 (for the contract) = $500, or I can simply sell the rights to someone else and make the profit more cleanly.
This isn't meant to be an exhaustive course on how each security works, just an illustration of exactly how different they are, yet affect each other.
[+] [-] cabaalis|9 years ago|reply
https://github.com/eliangcs/pystock-data
Edit: I just noticed the owner has decided to stop maintaining the repo just a few days ago. But you can reproduce it using the tools they used.
[+] [-] frei|9 years ago|reply
They have a certain value, and therefore prices, but are different from actually owning the underlying stock.
[+] [-] ice109|9 years ago|reply
[+] [-] brobinson|9 years ago|reply
RStudio + quantmod is a good playground
[+] [-] chad_strategic|9 years ago|reply
[+] [-] ryankennedyio|9 years ago|reply
[1]: http://www.financial-hacker.com/algorithmic-options-trading/
[+] [-] Veratyr|9 years ago|reply
[+] [-] SnacksOnAPlane|9 years ago|reply
[+] [-] jaredbroad|9 years ago|reply
[+] [-] santa_boy|9 years ago|reply
```r
require(quantmod)
OPTS <- getOptionChain("AAPL", NULL)
OPTS
```
Python, Julia, etc have likely similar functions and other packages for Option and Trading analyses
[+] [-] beezle|9 years ago|reply
[+] [-] iliconvalleys|9 years ago|reply