How do I get all months of option history from GetOptionHistory?

Hi Thomas, 

1) It's a data issue with the SPY options on 2017/06/01. Data files for options expiring on Oct and Nov are missing. You can check the raw data with our data explorer

Options have a large dataset. We are going to reprocessing the options data in the next few weeks to fix the issue of missing data files.

 2)  The kernel dies when the history data request is huge. Please select a shorter time period to avoid the dead kernel.

Thank you for your reply Jing.  I have a couple questions: 

1) If the data is missing, how come I can see Oct and Nov, when I request a different StartDate ?  See the two examples in the code, one uses StartDate of Sept 2017, the other Jun 2017.  With Sept, I get back:  Sept, Oct, Nov, Dec.  but not with StartDate of Jun 2017.  See code for more detail. 

2) This doesn't make sense to me either, because it works when I only specify the StartDate, but when I specify EndDate (that is less that today) in SetFilter it hangs.   So, there should be even less data coming back. So how can it be running out of memory if it works with even larger time frame? 

E,g,  

this works: 

option_history2 = qb.GetOptionHistory(spy.Symbol, datetime(2017,9,1), sort=True)

this hangs:  

option_history3 = qb.GetOptionHistory(spy.Symbol, datetime(2017,9,1),datetime(2018,9,1))

1) On a specific date, there are hundreds of files of SPY option data. Each file contains the minute data for the specified strike price and expiration date on a single day. If you check the data explorer, the SPY options data on Sep 1 contains the option data expiring on Oct and Nov. The missing files link to a specific day.

2) If you only use one date, it actually requests the history price on that day (the minute history on 09/01/2017) while "datetime(2017,9,1),datetime(2018,9,1)" is trying to retrieve the minute history data for one year, That's a huge amount of data and will account for the dead kernel.

Hi Jing,

Thanks for the answer, but is it possible then to get months of historical data for an option that expires on a certain date? For example, July to Sept data of an SPY call/put option that expires on Sept 27th.  

Thanks

Hi Elyse, 

The code above can do that, clone the notebook and play around with it.  You need to use the setFilter function to get the expirations that you are interested in.  Have you had a look at the Options Tutorials?  

Best, 

Thomas