Excel spreadsheet for higher order greeks?

Discussion in 'Options' started by TskTsk, Feb 10, 2012.

  1. TskTsk


    Are there any Excel spreadsheets out there that include higher order greeks like vanna, zomma, charm, speed, color, DvegaDtime, vomma, Ultima, dual delta etc?
  2. TskTsk


    Gonna have to bump this
  3. Look for option pricing formulas by haug - should have what you're looking for and more.
  4. We (Blair Hull, John Olagues, Bob Bright, and other pro's) were able to make big $$ with simple options analysis. Time decay (theta), movement (gamma), neutrality (delta), add betas and really, what else do you really need?

    I know that I'll hear some good responses, but with conversions trading at sub-pennies, paralysis analysis may just kick in, LOL.

    Your thoughts?

  5. Our not-so-beloved Jim Cramer of course made his fortune on his option trades. Stories of him back in his "hey days" are impressive....his ability to track over 30 positions in his head and know where the breakeven was.

    Jim was smart enough to realize that options would not have the mass appeal that stocks have. Thus, Mad Money rarely discusses options. In fact I heard something on Friday from a caller about call options and I was almost shocked they took the call.
  6. TskTsk


    Thanks, I checked out the links from you guys, unfortunately these all link to products that require buying. I was hoping there'd be some free spreadsheets for higher order greeks, since there are a lot of free spreadhseets for the standard order greeks. But if no such thing exists then I'll just suck it up and make one myself.

    I'm sure if you manage sub 100k positions then the 4 basic greeks will do. But if you manage a 200MM hedgefund like I do, you're gonna need to go a level deeper.
  7. lol to 200MM. Yes, it sucks to have a freeware mandate when running 9 figures. http://www.mbrm.com/product_uoa.shtml

    Clown shoes. I'd send you a copy, but you may be too sophisticated. Be sure to calc your risk to Totto.
  8. Why are you hanging out with us pikers? You can surely find better resources. No need to help you anymore.
    #10     Feb 18, 2012