Page 1
Page 1
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
24150 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 Iowa Golfer
Heaven
Member since Dec 2013
10230 posts
Posted on 12/12/13 at 9:29 pm to
Mispricing by the market?

Only way on an option I know of is if it's in the money, and the intrinsic value is higher then the market price.

Posted by Tigahs
Member since Jan 2004
22836 posts
Posted on 12/12/13 at 9:36 pm to
quote:

Should have started sooner. SMH.



Eh, I'll be fine

quote:

Are you sure you chose the right profession?


for now, but gimme another six months and we'll see...

other than what Ive learned in the six months after I took started the job as market analyst on an energy commodities trading desk, I have ZERO knowledge of trading/ finance. I have undergrad degrees in sociology and political science and a masters in public policy. So what I learn is either on the job or during my free time
This post was edited on 12/12/13 at 9:39 pm
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 foshizzle
Washington DC metro
Member since Mar 2008
40599 posts
Posted on 12/13/13 at 7:24 pm to
Sorry, but I never worked with options professionally. My experience was mostly in mortgage-backed bonds. I studied option theory (incl. Black-Scholes and binary models) but it was a long time ago and your firm probably has a better idea than I do.
Posted by GeneralLee
Member since Aug 2004
13104 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.)
Posted by Tigahs
Member since Jan 2004
22836 posts
Posted on 12/13/13 at 9:40 pm to
Solid advice, started looking at volatility surface against the underlying forward curve (though will probably use the in-house futures forecast I developed for this particular exotic commodity. Thought of incorporating the black-shole volatility calc fixes but the quants said it wasn't necessary given the lack of market depth, small market size (regional) and illiquidity of the options contract for this particular commodity
Posted by Tigahs
Member since Jan 2004
22836 posts
Posted on 12/13/13 at 9:43 pm to
quote:


You could see if short straddles generate statistically significant profits, if so that would suggest market is overpricing risk ( path peso problem.)


Good idea and will probably test the inverse too (long straddles, underpricing risk))
This post was edited on 12/13/13 at 9:44 pm
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