Sunday, April 13, 2014

Interactive Brokers US Index data/chart problem

Really, really frustrated with Interactive Brokers (IB) market data problem.  We are not talking about individual stock market data.  We are talking about the 2 major Indices : S&P 500 and Dow Jones Industrial Average.  Russell 2000 and Nasdaq happen to be correct.

S&P 500
This is what taken from CBOE.  SPX close at 1815.69, down 17.39 (0.95%)




This is from Think Or Swim (TOS).  SPX closed at 1815.69, down 17.39 (0.95%).  OHLC match CBOE.
This is taken from IB on Saturday, 12-Apr-14 Singapore Time.  SPX last 1817.23 (based on IB calculated value, else no value), down 15.85 (0.86%).
IB calculated value







IB Native Index Prices




This is taken from IB on Sunday, 13-Apr-14 Singapore Time.  Because I got difficultly logining to IB the whole Saturday, I have to continue updating this post on Sunday.  So, I happen to capture this value again on Sunday.  I seriously don't know what IB is doing.  Why is SPX and INDU (Dow Jones Industrial Average) showing a positive change (i.e. up) instead of negative change (i.e. down)???









Dow Jones Industrial Average
THis is taken from Bloomberg


This is from Think Or Swim (TOS).  DOW closed at 16026.75, down 143.47 (0.89%).  OHLC match Bloomberg.

This is from TradeStation (TSS).  DOW closed at 16026.75, down 143.47 (0.89%).  OHLC match Bloomberg.


This is from IB.  DOW last at 16040.90 (but if you read the bar details, close is 16026.80), up 14.20 (0.09%).  OHLC DIDN'T match Bloomberg.



Many candles are not correct.  The last candle has such a long stick (arrow pointing) which TOS or TS chart do not have.

I really hope I can spend more time on the learning of trading option than struggling through the various problems, frustration I face with my broker, specifically IB.





Sunday, April 6, 2014

Weekly Market Reivew N225

N225 has gained 367.74 (2.50%) over the last 5 days in a almost straight line up.  NKVI was almost flat at about 24 over the last 5 days.  This is not a good situation for Iron Condor seller.  As the underlying creep up slowly towards the Short Call strike price, it will be very difficult to adjust with such a low volatility.


Looking at the 6 months data, after breaking down from about 16320 in end December, N225 has been in the range of 14000-15320 in the past 2 months.  The break above 15320 will get it out of this range bound.

NKVI has been in the 20-30 range for past 6 months, with only spike above 30 in February when N225 went down to 14000.


SPX big drop of 23.68 points (1.25%) last Friday would likely bring N225 down on Monday open, bringing it back to the range.  Volatility might goes up a bit.


Saturday, April 5, 2014

Option Greeks: VEGA

Since my main trading strategy is to sell Out of The Money (OTM) Credit Spread, as specified in my Trading Plan, the second Greek that I want to talk about is Vega.

OTM Options contains only Extrinsic Value.  There are 4 factors that determine Extrinsic Value:

  1. Time left to expiration (Theta)
  2. Volatility of the underlying stock (Vega)
  3. Changes in interest rate (Rho)
  4. Dividends of the underlying stock

Besides Theta, Vega is the second greatest influence on Extrinsic Value.  Interest rate and dividend are relatively insignificant.

Vega is an estimate of how much the theoretical value of an option will change when Implied Volatility (IV) changes 1%.  An increase in IV will increase an option's price, a decrease of IV would decrease an option's price.

Vega is expressed as a positive number in Option Chain.  And there is only 1 Vega value for both Calls and Puts at the same Strike Price.  See image below.


Thus, a 1% increase in IV would increase both the Calls and Puts option by the Vega value.  While all Calls and Puts has positive Vega, your position can have either negative or positive Vega.

Vega and the position in the market:

  • Long Calls and Long Puts always have positive Vega
  • Short Calls and Short Puts always have negative Vega
When you Long an option (Calls or Puts) say at $1.00, with Vega say at 0.10, your option will be $1.10 when IV increase by 1% (assuming there is no move in the stock price and Theta is 0). 

When you Short an option (Calls or Puts) say at $1.00, with Vega say at 0.10, your option will be $1.10 when IV increase by 1% (assuming there is no move in the stock price and Theta is 0).  While the option price increase by 0.10, your Short position actually lose value by 0.10.  That is the reason why Short Calls and Short Puts always have negative Vega.

When you have a Spread, you have both a Short options and a Long options.  Take for example, the N225 May08'14 +16250 -16000 Call Bear Spread in the diagram below.



                                               Vega
N225 Jun12'14 16000 Call    12.7140
N225 Jun12'14 16250 Call    10.1607

While both of the Call options (16000 and 16250) are having positive Vega, the Call Bear Spread is having a negative Vega.  This is because in Call Bear Spread, you Short 16000 Call and Long 16250 Call.  The Short 16000 Call will have a negative Vega and the Long 16250 Call will have positive Vega.

-12.7140 + 10.1607 = -2.5533

Thus, the Call Bear Spread is in fact having a negative Vega of -2.5533, as indicated in the Quote Panel above.  The Call Bear Spread position will lose 2.5533 value if IV increase by 1% (assuming there is no move in the stock price and Theta is 0). 

Let's put both Theta and Vega together to see the impact to this Call Bear Spread.  
  • Vega is -2.5533
  • Theta is  0.8185 

IV increase by 1%
If IV increase by 1%, the Call Bear Spread will lose 1.7348 value after 1 day (assuming there is no move in the stock price).
  • -2.5533 + 0.8185 = -1.7348

IV decrease by 1%
If IV decrease by 1%, the Call Bear Spread will gain 3.3718 value after 1 day (assuming there is no move in the stock price).
  • 2.5533 + 0.8185 = 3.3718
Therefore, there is an advantage to sell Credit Spread when the IV is high.  So, when IV drop from the high, the Credit Spread will gain value from both Vega and Theta.  However, if you sell Credit Spread when the IV is low, the increase IV will make the Credit Spread lose more value from Vega than the value gained from Theta.


Tuesday, April 1, 2014

Option Greeks: THETA

Since my main trading strategy is to sell Credit Spread, I will start with Theta, one of the Option Greeks.

Theta, a.k.a. time decay, is an estimate of how much the theoretical value of an option will decreases each day, assuming there is no move in either the stock price or volatility.

As mentioned in my previous post Selling Options, Time Decay is an unique feature in Options (not in Stock, Futures, Forex, etc).  All Options lose time value every day.  It loses time value at a faster rate as you get closer to the expiry date.

Theta is expressed as a negative number in Option Chain.  And there is only 1 Theta value for both Calls and Puts at the same Strike Price.  See image below.

Theta





While all Calls and Puts has negative Theta (they lose value each day), your position can have either negative or positive Theta.

Theta and the position in the market:

  • Long Calls and Long Puts always have negative Theta
  • Short Calls and Short Puts always have positive Theta

When you Long an option (Calls or Puts) say at $1.00, with Theta say at -0.10, your option will be $0.90 after 1 day (assuming there is no move in either the stock price or volatility).  Your Long position lose value by 0.10.  Thus, Long Calls and Long Puts always have negative Theta.  Remember all options lose time value very day.

When you Short an option (Calls or Puts) say at $1.00, with Theta say at -0.10, your option will be $0.90 after 1 day (assuming there is no move in either the stock price or volatility).  While the option price lose -0.10, your Short position actually gain value by 0.10.  That is the reason why Short Calls and Short Puts always have positive Theta.

It is not so straight forward when you have a Spread, where you have a Short options and a Long options.  Take for example, the N225 Jun12'14 +17500 -17250 Call Bear Spread in the diagram below.
Call Bear Spread




N225 Jun12'14 17250 Call   -1.8672
N225 Jun12'14 17500 Call   -1.5954

While both of the Call options (17250 and 17500) are having negative Theta, The Call Bear Spread is having a positive Theta.  This is because in Call Bear Spread you Short 17250 Call and Long 17500 Call.  The Short 17250 Call will have positive Theta and the Long 17500 Call will have negative Theta.

+1.8672 - 1.5954 = 0.2718

Thus, the Call Bear Spread is in fact having a positive Theta of 0.2718, as indicated in the Quote Panel above.  The Call Bear Spread position will gain 0.2718 value after 1 day (assuming there is no move in either the stock price or volatility).

For selling vertical spread (credit spread), we will always have positive Theta.  Our vertical spread (credit spread) will gain value slowly each day.




KOSPI 200 Volatility Index

As written in previous post, I was looking for VIX equivalent for Nikkei 225 (N225) and KOSPI 200 (K200).  I posted just a few days ago on the Nikkei Stock Average Volatility Index (NKVI) here.  Now, I am glad that I found VIX equivalent for K200: KOSPI 200 Volatility Index (VKOSPI) here.

Overview
Volatility index(VKOSPI) represents the volatility of the future(30-day maturity) KOSPI200 index as predicted by investors of the KOSPI200 option market based on the KOSPI200 option price. seving as the index to determine the market conditions and investment. It is used to manage (hedge) the market risk arising from the transaction of option and future derivative commodities Volatility index (VKOSPI) has been estimated and published since April 13.2009


Looking at the 6 month chart, VKOSPI usual range is between 12-15, with some spikes above 15 occasionally.  The only big spike is on 4-Feb-2014 to 17+ when K200 is at 245.30, lowest for the 6 months.
VKOSPI 6 month


The 3 months chart show that it stays between 12-15 most of the time, except the spike of 17+ in Feb.
VKOSPI 3 month


The 1 month chart show the same range of 12-15.  There are only 5 days that it is 14+.
VKOSPI 1 month


The 1 week chart shows that VKOSPI has been climbing up towards 14.  Probably is a good time to sell options, unless one is willing to wait till it goes over 14, which happens 5 times in the past month.
VKOSPI 1 week


Similarly, I will take some time to study VKOSPI with K200 to have a better understanding on the correlation before I update my Money Management rules in the Trading Plan.






Monday, March 31, 2014

KOSPI 200 data feed fixed

The K200 data feed problem from Interactive Brokers (IB) is finally fixed today, after 6 trading days of downtime.  While I do get the bar/data for today, 1-Apr-2014, I do not get the bar/data for the previous 6 trading days.  See below.




Will IB correct the data for the past 6 trading days?  We shall see.


KOSPI 200 (K200) Daily updates

The K200 data problem in Interactive Brokers (IB) that I reported in this post is still not fixed.  I no choice but to capture the Daily Closing Index from Korea Stock Exchange here.

K200 Close at 258.11 today, 31-Mar-2014.

K200 has been going up steady over the past week, gaining almost 7 points.  Including today move, it is about 7.5 points up since the last low at 250.68 on 21-Mar-2014.




On a 3 Month chart, we can see that it is approaching the previous high, also a resistance, at 258.