Excel for Options Trading

Suckow

New member
Kevin,

Have you seen the end of the Trading Group 2 - June 19, 2018 where Bruno Voisin showed IB Options Pricer (BIBOP) excel spreadsheet which works with Interactive Brokers ?


starting at 46 miuntes.
 

Kevin Lee

Member
Gold Member
Kevin,

Have you seen the end of the Trading Group 2 - June 19, 2018 where Bruno Voisin showed IB Options Pricer (BIBOP) excel spreadsheet which works with Interactive Brokers ?


starting at 46 miuntes.

Yes, I think I have seen the IB spreadsheet before in other presentations that he presented. But I haven't used it myself. I use TOS primarily as the live data source.

This reminds me I haven't had time to update the youtube video... totally swamped. Hopefully I can get back to that soon.
 
S

stts

Guest
I have seen that presentation a few minutes ago
It looks pretty good
He said he will start working on a version that will use TOS instead of IB but I am guessing it will use VBA
I was wondering if those 3D charts could be done with older version of excel or will we have to get Office 365 to be able to create them
One thing I don't like about it that it's all protected and cannot be customized that;s why I like Kevin's version because it's done with excel and you get to construct it yourself from scratch and also learn a few things along the way
While waiting for the next presentation I upgraded my excel from 2003 to 2007 which I didn't really wanted to do because I hate that ribbon but I guess I had to do it at some point so I might as well start getting used to it
 

Kevin Lee

Member
Gold Member
I have seen that presentation a few minutes ago
It looks pretty good
He said he will start working on a version that will use TOS instead of IB but I am guessing it will use VBA
I was wondering if those 3D charts could be done with older version of excel or will we have to get Office 365 to be able to create them
One thing I don't like about it that it's all protected and cannot be customized that;s why I like Kevin's version because it's done with excel and you get to construct it yourself from scratch and also learn a few things along the way
While waiting for the next presentation I upgraded my excel from 2003 to 2007 which I didn't really wanted to do because I hate that ribbon but I guess I had to do it at some point so I might as well start getting used to it

3D charts is an Excel function. Once you have the data, creating it is easy. VBA is more convenient but not necessary in most cases. The objecitve of the videos is to help traders create applications without VBA in most part. In the later videos, I might introduce some simple VBA that can spice up the application a lot.

My belief is trading is becoming a data science. My goal to do is help fellow traders get the first step into data analysis by using Excel and that hopefully would lead some people into algorithmic back testing, analysis and eventually algo trading.
 

Robert K

New member
Kevin you are doing a great job. Do not be discouraged. Markets are always changing. I am very interested in what you are doing. Some of us started on Lotus 1-2-3. And maybe even before that. So the important thing to do is to be one step ahead. So you have to think. What is that next step? But being a statistician harnessing data is important if you have not lived through what was before.
 
S

stts

Guest
This reminds me I haven't had time to update the youtube video... totally swamped. Hopefully I can get back to that soon.

Hi Kevin,
Is there any visibility as to when you might have time to continue with this project or is it pretty much abandoned for this year ?
 

Kevin Lee

Member
Gold Member
Hi Kevin,
Is there any visibility as to when you might have time to continue with this project or is it pretty much abandoned for this year ?

Sorry for the delay. My July schedule is packed and I’ll be traveling most of August. I’ll try to find time to do it Sep.
 
Top
Contact Us