Started By
Message
locked post

Options data analysis -- need help

Posted on 12/12/13 at 9:13 pm
Posted by Tigahs
Member since Jan 2004
22836 posts
Posted on 12/12/13 at 9:13 pm
I have historical EOD data for 48 options contracts specific to a single commodities market -- exchange-traded.

So I have the following variables by trade date:

-Instrument type (put/call)
-first and final (expiry) trade date
-Premium price
-Strike price
-Underlying's price, volume, OI (on futures mkt)
-Total volume traded
-Open interest
-Greeks (delta, gamma, theta etc)
-Implied Volatility
-Historical Volatility of underlying

(I calc'd IV using black sholes to derive the theoretical price and wrote a goal seek macro to back out IV values.


So given the above data: what do I do with it? In terms of analysis, that is. What's the best way to determine when there was a mispricing by the market of either the underlying (itself) or options contract (premium) with the data I have?

What trends should I be looking for?

I'm a bit unclear on how to analyse the relationship between historical EOD data for options and the underlying (futures contracts), any suggestions or input?

I'm giving a presentation to the global head of energy commodity X (don't want to name the specific commodity or trading shop to ensure my identity remains anonymous, if you know either of the two I'd appreciate it if you would refrain from posting it -- what desk i work on and the shop i work at) and need to finish the analysis tonight (likely will pull an all-nighter) so any help or insight would be greatly appreciated.
This post was edited on 12/12/13 at 9:42 pm
Posted by lynxcat
Member since Jan 2008
24259 posts
Posted on 12/12/13 at 9:18 pm to
Should have started sooner. SMH.

Are you sure you chose the right profession?

Posted by tagatose
South Carolina
Member since Oct 2005
2008 posts
Posted on 12/12/13 at 9:28 pm to
See if there is any truth in the Option Pain this site claims:

LINK
Posted by Tigahs
Member since Jan 2004
22836 posts
Posted on 12/13/13 at 12:52 am to
Come on LSURussian, help a brutha out

or foshizzle, and Jersey Tiger, whatever ur username is these days
Posted by William Stephenson
Mare Liberum
Member since Oct 2013
556 posts
Posted on 12/13/13 at 10:05 am to
volatility surface, sticky strikes and options skews vs forward curve of futures is where you should begin...



quote:

using black sholes
quote:

goal seek macro

heston model (or other stochastic volatility models) w/ matlab is better direction to go...
Posted by GeneralLee
Member since Aug 2004
13112 posts
Posted on 12/13/13 at 7:56 pm to
You could see if short straddles generate statistically significant profits, if so that would suggest market is overpricing risk ( path peso problem.)
first pageprev pagePage 1 of 1Next pagelast page
refresh

Back to top
logoFollow TigerDroppings for LSU Football News
Follow us on Twitter, Facebook and Instagram to get the latest updates on LSU Football and Recruiting.

FacebookTwitterInstagram