GOOG Options History — July 2007

In July 2007, GOOG traded between $12.69 and $13.86. ATM implied volatility averaged 28.4%, placing in the 42.5% IV rank vs the trailing year. The 30-day expected move averaged 7.9%. IV traded above realized volatility by 11.0% (HV 20d: 17.4%). Max pain ranged from $12.49 to $13.24. Net GEX was positive for 20 of 21 trading days. Term structure was in contango for 6 of 21 days. Put/call ratio averaged 0.77.

Notable Days

2007-07-20: Highest Volume — 15,523,060 contracts
2007-07-20: Largest IV drop — 28.8% change
2007-07-18: Highest IV Rank — 66.4%
2007-07-18: Largest Expected Move — 10.2%

Monthly Statistics

Metric	Avg	Min	Max	Open	Close
Price	$13.30	$12.69	$13.86	$13.25	$12.74
Max Pain	$12.77	$12.49	$13.24	$12.74	$12.74
ATM IV	28.4%	23.3%	35.4%	26.8%	25.9%
Expected Move	7.9%	6.7%	10.2%	7.7%	7.4%
HV 20d	17.4%	12.2%	23.6%	16.3%	22.8%
HV 60d	17.8%	16.0%	19.9%	16.9%	19.6%
IV Rank	42.5%	24.5%	66.4%	44.4%	33.4%
IV Percentile	65.7%	37.7%	88.9%	77.8%	54.2%
Term Structure	-1.4%	-4.7%	0.9%	-2.1%	-1.1%
VWIV	27.7%	23.6%	35.5%	27.5%	25.5%
Skew 25d	0.9%	-0.1%	2.8%	0.5%	2.6%
Skew 10d	1.9%	-0.2%	5.8%	1.4%	5.8%
Call IV 25d	27.2%	23.2%	34.9%	27.1%	24.6%
Put IV 25d	28.1%	23.9%	36.2%	27.5%	27.2%
Bid-Ask Spread %	8.19	5.18	11.54	10.34	11.31
Gamma HHI	0.11	0.05	0.94	0.07	0.06
Net GEX	-70.9M	-4.00B	193.2M	149.5M	43.8M
Net DEX	-4.72B	-7.49B	-1.17B	-5.06B	-2.30B
Net VEX	-31.4M	-33.8M	-21.6M	-32.0M	-31.8M
Div Yield	0.0%	0.0%	0.0%	0.0%	0.0%
P/C Ratio	0.77	0.40	1.09	0.40	0.84
Total Volume	4,090,330.476	1,238,780	15,523,060	2,795,680	2,672,500
Total OI	21,455,281.905	17,262,120	28,116,940	19,943,640	21,446,060

Daily Data (21 trading days)

Date	Price	Max Pain	ATM IV	Exp Move	HV 20d	IV Rank	VWIV	Skew 25d	Term Str	GEX	DEX	VEX	P/C	Spread %	Call Vol	Put Vol	Call OI	Put OI
2007-07-02	$13.25	$12.74	26.8%	7.7%	16.3%	0.0%	27.5%	0.5%	-2.1%	149.5M	-5.06B	-32.0M	0.40	10.34	1,996,000	799,680	10,873,100	9,070,540
2007-07-03	$13.35	$12.74	27.6%	7.9%	14.6%	0.0%	27.8%	0.7%	-2.5%	162.6M	-5.62B	-32.3M	0.53	10.19	809,240	429,540	11,151,020	9,261,500
2007-07-05	$13.53	$12.74	29.1%	8.3%	15.1%	44.4%	29.6%	1.0%	-3.9%	187.1M	-6.38B	-31.5M	0.76	7.28	2,162,760	1,638,960	11,161,480	9,285,400
2007-07-06	$13.47	$12.49	29.0%	7.4%	15.0%	44.3%	26.2%	0.4%	-0.4%	174.2M	-5.95B	-32.1M	0.69	5.18	978,700	673,800	11,325,760	9,389,700
2007-07-09	$13.55	$12.49	32.7%	7.9%	15.0%	56.9%	27.8%	0.4%	-1.0%	185.1M	-6.33B	-32.1M	0.73	5.25	1,703,860	1,235,720	11,443,400	9,459,980
2007-07-10	$13.57	$12.49	33.1%	8.0%	14.5%	58.4%	28.2%	0.1%	-1.2%	179.4M	-6.32B	-32.0M	1.09	5.18	1,278,760	1,398,880	11,554,780	9,722,800
2007-07-11	$13.60	$12.49	34.8%	8.0%	13.3%	64.2%	28.2%	0.2%	-1.1%	170.2M	-6.36B	-32.2M	0.83	6.98	1,119,400	933,780	11,745,580	10,017,960
2007-07-12	$13.62	$12.49	28.1%	8.1%	13.2%	41.1%	28.4%	0.2%	-1.6%	167.1M	-6.36B	-32.3M	0.84	7.07	1,341,060	1,120,280	11,812,720	10,214,400
2007-07-13	$13.79	$12.74	28.5%	8.2%	13.2%	42.5%	28.8%	-0.1%	-1.8%	193.2M	-7.33B	-32.0M	0.65	7.41	2,377,060	1,536,020	12,014,360	10,596,420
2007-07-16	$13.81	$12.74	30.8%	8.8%	13.2%	50.4%	31.2%	0.1%	-2.8%	147.9M	-5.21B	-21.6M	0.53	5.44	3,881,360	2,073,760	9,317,260	7,944,860
2007-07-17	$13.86	$12.74	31.7%	9.1%	12.2%	53.3%	32.0%	0.3%	-2.9%	191.1M	-7.49B	-32.9M	0.65	8.65	2,176,340	1,423,260	12,904,900	11,328,600
2007-07-18	$13.72	$12.74	35.4%	10.2%	13.0%	66.4%	35.5%	1.2%	-4.7%	122.8M	-6.39B	-33.8M	0.85	7.32	3,413,200	2,889,160	12,883,120	11,481,420
2007-07-19	$13.70	$13.24	33.6%	9.6%	12.4%	60.0%	33.4%	0.8%	-4.1%	115.7M	-6.10B	-33.0M	0.83	8.97	5,076,960	4,199,480	13,592,140	12,176,600
2007-07-20	$12.99	$13.24	23.9%	6.9%	23.6%	26.6%	24.5%	0.4%	0.7%	-4.00B	-1.17B	-29.5M	0.69	9.57	9,189,820	6,333,240	14,853,680	13,263,260
2007-07-23	$12.80	$12.99	23.3%	6.7%	22.9%	24.5%	23.6%	0.5%	0.9%	66.3M	-2.37B	-30.3M	0.89	11.54	2,067,180	1,838,360	10,522,040	7,767,040
2007-07-24	$12.84	$12.99	24.2%	6.9%	22.8%	27.6%	24.4%	1.0%	0.4%	56.2M	-2.52B	-31.3M	0.90	9.88	1,613,860	1,458,660	11,023,260	8,256,920
2007-07-25	$12.73	$12.99	24.3%	7.0%	22.8%	27.8%	24.6%	1.1%	0.5%	37.9M	-2.11B	-31.3M	0.94	7.39	1,562,520	1,466,780	11,210,480	8,525,240
2007-07-26	$12.69	$12.99	24.2%	6.9%	22.7%	27.6%	24.5%	2.6%	0.4%	40.3M	-2.25B	-31.7M	0.96	7.89	1,895,140	1,818,100	11,410,800	8,775,880
2007-07-27	$12.78	$12.74	24.5%	7.0%	23.0%	28.6%	24.5%	2.3%	0.1%	52.0M	-2.49B	-32.4M	0.86	9.64	1,699,500	1,469,740	11,687,680	8,973,080
2007-07-30	$12.89	$12.74	24.6%	7.1%	23.2%	29.1%	25.1%	2.8%	-0.6%	71.2M	-2.95B	-32.0M	0.80	9.58	1,193,280	951,240	11,967,560	9,148,140
2007-07-31	$12.74	$12.74	25.9%	7.4%	22.8%	33.4%	25.5%	2.6%	-1.1%	43.8M	-2.30B	-31.8M	0.84	11.31	1,450,840	1,221,660	12,154,660	9,291,400