Interactive Brokers or ActiveTick for Options Chain Trading Data via Excel?

(Last Updated On: April 8, 2015)
Learn the Secret

Get  our 2 Free Books

Get these now which land directly to their inbox.
Invalid email address

Interactive Brokers or ActiveTick for Options Chain Trading  Data via Excel?

It seems I am struggling to find a decent way to demo or test options chain for SPX or SPY. It does not appear to be as easy with XLQ for my Excel spreadsheet Matlab link methodology. Sort of frustrating if you ask me. The Google Options Chain Matlab script only works for equity options so it does not work for Index or ETFs with option chain data. So I may need to experiment with Interactive Brokers data feed instead as they will eventually become my broker ultimately considering the hassles I am running into with the various data provider options.

You can download the API client software from here:

 UPDATE: For IB, you cannot retrieve SPX option chain data in demo mode so it needs to be signed up to a real trading account!

But alas, there is also ActiveTick aswell with a basic platform with Excel Add In option to provide the chain data I am after. This will definitely be an easier option instead of relying on the more complicated way through XLQ or Interactive Brokers at this present time. I am sort of apprehensive using ActiveTick with the recent reviews I saw but for $20 per month, I don’t think there is much to risk at this point.

For ActiveTick software:

Join my FREE newsletter to see which path I take for pursuing option chains data



NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!
This entry was posted in Matlab, Quant Development and tagged , , , , , , on by .

About caustic

Hi i there My name is Bryan Downing. I am part of a company called QuantLabs.Net This is specifically a company with a high profile blog about technology, trading, financial, investment, quant, etc. It posts things on how to do job interviews with large companies like Morgan Stanley, Bloomberg, Citibank, and IBM. It also posts different unique tips and tricks on Java, C++, or C programming. It posts about different techniques in learning about Matlab and building models or strategies. There is a lot here if you are into venturing into the financial world like quant or technical analysis. It also discusses the future generation of trading and programming Specialties: C++, Java, C#, Matlab, quant, models, strategies, technical analysis, linux, windows P.S. I have been known to be the worst typist. Do not be offended by it as I like to bang stuff out and put priorty of what I do over typing. Maybe one day I can get a full time copy editor to help out. Do note I prefer videos as they are much easier to produce so check out my many video at