The first step [for the pros only]

Discussion in 'Options' started by babutime, Feb 21, 2012.

  1. Cren1

    Cren1

    I don't rely on Bloomberg platform to analyze volatility, I'd rather use Bloomberg's API in order to have dynamic spreadsheets which I can manipulate according to my needs.

    Using API in Excel is very easy: if your school has a Bloomberg terminal try these formulas...

    =BDP(...) for dynamic datas
    =BDH(...) for historical datas

    ...and use these to analyze IVTS' behaviour in the past and in the present.
     
    #31     Feb 23, 2012
  2. TskTsk

    TskTsk

    Cant you just connect IB TWS to Excel and then analyze the skews directly in Excel?
     
    #32     Feb 24, 2012
  3. Cren1

    Cren1

    I do not really know if it's a problem just of mine, but, when my ActiveX Excel spreadshhet IB connected needs to refresh options prices and IVs, it freezes for a while.

    As this happens every 9 seconds (or less), it's almost impossible to work and make analysis during real time updating, unless you don't wanna wait five minutes (or more) to run a linear regressione or something similar.
     
    #33     Feb 24, 2012
  4. TskTsk

    TskTsk

    Not sure about ActiveX, but I use DDE to feed Excel and it's working perfect, prices are updating instantly...maybe try switching to DDE if you can
     
    #34     Feb 24, 2012
  5. My Excel DDE freezes too.... I hate it.

    I'll be working on a java implementation of it and see if it is smoother that way.
     
    #35     Feb 24, 2012
  6. Cren1

    Cren1

    I switched to ActiveX 'cause some friends suggested me it's more stable than DDE :D
     
    #36     Feb 24, 2012
  7. I just had a thought. I keep hearing buzz about market going into a short term correction. I mean I think it's safe to say its only a matter of when and not if.

    How would one test for this quantitatively? And no, the "stochastics" plot ( which has nothing to do with stochastics or stochastics calculus laughably ) and the "RSI" or any of that stuff is not what I'm looking for. If anything a simple MACD is useful but even that used to be the domain of hedge funds and now that everyone uses it its no longer that relevant.

    Would one look at skews of major indices- SPX, NDX, or perhaps the treasury yields and figure out what the skew is telling along with open interest levels at certain strikes? What about fundamentals data? The market absorbs any news instantly so it's not like any news that is indicative of any future event haven't been priced in.

    Or do you guys not care at all and are in positions that are continually gamma hedged? Or perhaps its as simple as looking at mean reversion parameters?

    Am I even asking the right questions?
     
    #37     Feb 24, 2012
  8. sonoma

    sonoma

    Could you restate what you're asking?
     
    #38     Feb 24, 2012
  9. How do you test whether or not a market is about to reverse?

    (without technical analysis)

    And if you don't, then perhaps the strategy is to be gamma neutral (or some other hedged strategy...) ?

    That was the gist of it...
     
    #39     Feb 24, 2012
  10. IVtrader

    IVtrader

    nope. they have given multiple presentations in a trading community I belong to, and open interests distribution hasn't rated even a "minutes time" compared to the over 15 minutes they spent on the charts using multiple forms of TA. and yet the TA was only one of many factors in their decisionmaking
     
    #40     Feb 25, 2012