Beta calculation

Beta :
Beta measure the volatility of the firm/stock w.r.t market.
if ( Beta > 0) => more volatile .... else less volatile.

NetBeta value of stock x = abs(Long cash Beta) - abs(short cash beta)

Beta of x for market m= Covariance(stock x, Maket m) / variance(m)

eg :

	X	X%	diff from mean	M	M%	Diff with mean	return
	100000			100000
	100055	0.00055	-0.003147525	100360	0.0036	-0.00282108	8.87942E-06
	101706	0.016500924	0.0128034	102765	0.023963731	0.017542651	0.000224606
	101100	-0.005958351	-0.009655875	101912	-0.008300491	-0.014721571	0.00014215
Average		0.003697525			0.00642108		0.000125212	Cov(x,m)
Variance		8.90233E-05			0.000177476
Beta		0.705512902