What's an excel formula for tick-by-tick Implied Volatility? (IB's data isn't real-time)

Discussion in 'Options' started by d0rian, Apr 24, 2016.

  1. d0rian

    d0rian

    Thanks - yes, I had actually seen that page (did a fair bit of googling before posting here), though didn't find much actionable info. Mostly just confused commenters talking past each other.
     
    #11     Apr 25, 2016
  2. userque

    userque

    What are you missing, the 'formulas,' a way to do the formulas in excel, or both?
     
    #12     Apr 25, 2016
  3. d0rian

    d0rian

    I'm not quite sure which part of my question is causing the confusion, so I'll just re-state it as simply as possible. Here's the data that my IB real-time data stream pulls into Excel:

    [​IMG]

    When the Bid changes (let's use the 17-Strike) from $0.50 to $0.75, the new Bid ($0.75) is updated by IB's data stream IMMEDIATELY / in real-time, BUT the IV.B value remains at 26.0% until it is updated (every ~2 mins according to IB).

    What I want to know is how I can get the new IV.B value in real-time? As explained, IB only updates that value every few minutes, but I want it in real-time. So I want to know whether there is a formula I can plug into Excel -- and if so, just what that formula is / what inputs it needs -- that will update the IV.B in real-time.
     
    #13     Apr 25, 2016
  4. userque

    userque

    I'll see what I can come up with in a day. Also, maybe IB will tell you what they use in their calculations...have you asked them?
     
    #14     Apr 25, 2016
  5. d0rian

    d0rian

    Yes, I wrote to them yesterday asking the exact same thing. The only info I have to this point is what they'd written to me a few months ago about them using binomial trees and updating the IV values in TWS / data stream every ~2 mins. I emailed them today asking how I could do it myself in the hopes of having real-time IV values.
     
    #15     Apr 25, 2016
  6. userque

    userque

    Ok, I'll post back in a day or so.
     
    #16     Apr 25, 2016
  7. userque

    userque

    @d0rian

    Is Black-Scholes an option, or must it be binomial trees?
     
    #17     Apr 25, 2016
  8. d0rian

    d0rian

    My understanding is that BS is a better option for European style options (rather than American, which is what I'm dealing with)...but would each model result with dramatically different IV figures? If not, then I'm not too picky...
     
    #18     Apr 25, 2016
  9. userque

    userque

    Ok, I'll look into it, just wanted to know all my options first. I'll probably post again within an hour or so. Also, are you using a 'powerful' (Memory, Speed) computer?
     
    #19     Apr 25, 2016
  10. #20     Apr 25, 2016