{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Read_Me","Formulae","Greeks","Calculator","Historic Volatility"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Read_Me","index":0,"n_rows":28,"n_cols":1,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["In order for this spreadsheet to work, you must…"]
[]
["1) Enable Macros"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2) Open the VB Editor"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["3) Write the macro"]

{"sheet":"Formulae","index":1,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Black Scholes Formulae : "]
[]
["Intermediate Calculations:"]
[]
["d1=IF(ISBLANK(DividendYield),LN(SpotPrice/B6)+((RiskFreeRate + (0.5*(sigma^2)))*TimeToMaturity),LN(SpotPrice/B6)+((RiskFreeRate -DividendYield+ (0.5*(sigma^2)))*TimeToMaturity))/(sigma*TimeToMaturity^0.5)"]
["d2=d1-sigma*TimeToMaturity^0.5"]
["nd1=normsdist(d1)"]
["nd2=normsdist(d2)"]
["nd1'=1/(2*PI())^0.5*(EXP(-(d1^2)/2))"]
["call=(SpotPrice*nd1)-(Strike*exp(-RiskFreeRate*TimetoMaturity)*nd2)"]
["put=(SpotPrice*exp(-RiskFreeRate*TimetoMaturity)*normsdist(-d2))-(SpotPrice*normsdist(-d1))"]
[]
["Greek","Call","Put"]
["Delta","nd1*EXP(-DividendYield * TimeToMaturity)","(nd1 - 1) * EXP(-DividendYield * TimeToMaturity)"]
["Gamma","(nd1' * EXP(-DividendYield * TimeToMaturity)) / (SpotPrice * sigma * (TimeToMaturity ^ (1 / 2)))","(nd1' * EXP(-DividendYield * TimeToMaturity)) / (SpotPrice * sigma * (TimeToMaturity ^ (1 / 2)))"]
["Vega","SpotPrice * (TimeToMaturity ^ (1 / 2)) * nd1` * EXP(-DividendYield * TimeToMaturity)","SpotPrice * (TimeToMaturity ^ (1 / 2)) * nd1` * EXP(-DividendYield * TimeToMaturity)"]
["Theta","-(SpotPrice * nd1` * sigma * EXP(-DividendYield * TimeToMaturity)) / (2 * (TimeToMaturity ^ (1 / 2)))","-(SpotPrice * nd1` * sigma * EXP(-DividendYield * TimeToMaturity)) / (2 * (TimeToMaturity ^ (1 / 2)))"]
[null," + (DividendYield * SpotPrice * nd1 * EXP(-DividendYield * TimeToMaturity)) ","- (DividendYield * SpotPrice * NORMSDIST(-d1) * EXP(-DividendYield * TimeToMaturity)) "]
[null,"- (RiskFreeRate * StrikePrice * EXP(-RiskFreeRate * TimeToMaturity) * nd2)","+ (RiskFreeRate * StrikePrice * EXP(-RiskFreeRate * TimeToMaturity) * NORMSDIST(-nd2))"]

{"sheet":"Greeks","index":2,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Calculator!A37","v":"Greeks:"}]
[]
["Greek","Call ","Put"]
[{"$f":"Calculator!A39","v":"Value"},{"$f":"Calculator!B39","v":7.0349467335971871},{"$f":"Calculator!C39","v":77.224030257836375}]
[{"$f":"Calculator!A40","v":"Delta"},{"$f":"Calculator!B40","v":0.18955228201653163},{"$f":"Calculator!C40","v":-0.81044771798346837}]
[{"$f":"Calculator!A41","v":"Gamma"},{"$f":"Calculator!B41","v":3.8120739016411359E-3},{"$f":"Calculator!C41","v":3.8120739016411359E-3}]
[{"$f":"Calculator!A42","v":"Vega"},{"$f":"Calculator!B42","v":71.456391126383522},{"$f":"Calculator!C42","v":71.456391126383522}]
[{"$f":"Calculator!A43","v":"Theta"},{"$f":"Calculator!B43","v":-55.842900084130513},{"$f":"Calculator!C43","v":-51.671299329340037}]

{"sheet":"Calculator","index":3,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Stock Quote","[Enter Stock Symbol]",null,null,null,"Xignite Free Trial ID:","[Enter Xignite Trial ID]"]
[]
["End date (for volatility calculation):",null,"[Enter End Date]"]
[null,null,null,{"$f":"'Historic Volatility'!D251","v":0.26955412492660341}]
[]
[]
["Black Scholes Value:"]
[]
["ns2:Symbol","ns2:Last","ns2:OptionSymbol","ns2:Type","ns2:Month","ns2:Year","ns2:StrikePrice","ns2:Bid","ns2:Ask","ns2:Change","ns2:Last","ns2:Value"]
["GOOG",628.58000000000004,"GOOGC17123700000","Call",3,2012,700,6.4,6.8,0,6.5,6.1622077360118084]
[]
["Today's Date:",{"$f":"NOW()","v":"2012-01-17T16:58:00.260"}]
["Expiration Date:","2012-03-17"]
["Term (Days):",{"$f":"NETWORKDAYS(B12,B13)","v":44}]
["Term (Years):",{"$f":"B14/250","v":0.17599999999999999}]
[]
["Black-Scholes Inputs:"]
[]
["Stock Price:",{"$f":"B10","v":628.58000000000004}]
["Strike:",700]
["Volatility:",{"$f":"D4","v":0.26955412492660341}]
["Risk Free Rate:",0.01]
["Term:",{"$f":"B15","v":0.17599999999999999}]
["Dividend Yield: ",0]
["Expiration Month:",3]
["Expiration Year:",2012]
[]
["Intermediate Calculations:"]
["d1:",{"$f":"(LN(B19/B20)+(B22+B21^2/2)*B23)/(B21*SQRT(B23))","v":-0.87954736385801102}]
["d2:",{"$f":"B29-B21*SQRT(B23)","v":-0.99263166437152461}]
["nd1:",{"$f":"NORMSDIST(B29)","v":0.18955228201653163}]
["nd2:",{"$f":"NORMSDIST(B30)","v":0.16044474396449915}]
["n'd1:",{"$f":"1/(2*PI())^0.5*(EXP(-(B29^2)/2))","v":0.27097185601477691}]
["Call:",{"$f":"EXP(-B22*B23)*(B19*B31*EXP(B22*B23)-B20*B32)","v":7.0349467335971871}]
["Put:",{"$f":"B20*EXP(-B22*B23)*NORMSDIST(-B30)-(B19*NORMSDIST(-B29))","v":77.224030257836375}]
[]
["Greeks:","Call ","Put"]
[]
["Value",{"$f":"B34","v":7.0349467335971871},{"$f":"B35","v":77.224030257836375}]
["Delta",{"$f":" B31*EXP(-B24 * B23)","v":0.18955228201653163},{"$f":"(B31-1)*EXP(-B23*B24)","v":-0.81044771798346837}]
["Gamma",{"$f":"(B33* EXP(-B24 * B23)) / (B19 * B21* (B23 ^ (1 / 2)))","v":3.8120739016411359E-3},{"$f":"B41*EXP(-B24 * B23)","v":3.8120739016411359E-3}]
["Vega",{"$f":"B19 * (B23 ^ (1 / 2)) * B33* EXP(-B24 * B23)","v":71.456391126383522},{"$f":"B42","v":71.456391126383522}]
["Theta",{"$f":"-(B19 * B33 * B21 * EXP(-B24 * B23)) / (2 * (B23 ^ (1 / 2))) + (B24 * B19 * B31 * EXP(-B24 * B23)) - (B22 * B20 * EXP(-B22 * B24) * B32)","v":-55.842900084130513},{"$f":"-(B19*B33*B21*EXP(-B24*B23))/(2*(B23^(1/2)))-(B24*B19*NORMSDIST(-B29)*EXP(-B24*B23))+(B22 * B20 * EXP(-B22 * B23) * NORMSDIST(-B32))","v":-51.671299329340037}]

{"sheet":"Historic Volatility","index":4,"n_rows":251,"n_cols":4,"rows_kept":251,"cut":false,"hidden":false,"merged":[]}
["ns1:Symbol","ns1:Date","ns1:Last","Log Realtive Prices"]
["goog","1/14/2011",624.17999999999995]
["goog","1/13/2011",616.69000000000005,{"$f":"LN(C3/C2)","v":-1.2072321784592988E-2}]
["goog","1/12/2011",616.87,2.9183825882408667E-4]
["goog","1/11/2011",616.01,-1.3951076171024837E-3]
["goog","1/10/2011",614.21,-2.9263079522223309E-3]
["goog","1/7/2011",616.44000000000005,3.6241050514119176E-3]
["goog","1/6/2011",613.5,-4.7807301162107671E-3]
["goog","1/5/2011",609.07000000000005,-7.2470605177196914E-3]
["goog","1/4/2011",602.12,-1.1476442640943286E-2]
["goog","1/3/2011",604.35,3.696739313162771E-3]
["goog","12/31/2010",593.97,-1.732468726874907E-2]
["goog","12/30/2010",598.86,8.1990348898332392E-3]
["goog","12/29/2010",601,3.5670866086575451E-3]
["goog","12/28/2010",598.91999999999996,-3.4669012656894233E-3]
["goog","12/27/2010",602.38,5.7604421338073065E-3]
["goog","12/23/2010",604.23,3.0664447495742128E-3]
["goog","12/22/2010",605.49,2.0831274272377831E-3]
["goog","12/21/2010",603.07000000000005,-4.0047713549482685E-3]
["goog","12/20/2010",595.05999999999995,-1.3371035427469924E-2]
["goog","12/17/2010",590.79999999999995,-7.1846901404945939E-3]
["goog","12/16/2010",591.71,1.5390993389250095E-3]
["goog","12/15/2010",590.29999999999995,-2.3857677495061061E-3]
["goog","12/14/2010",594.91,7.779251353760645E-3]
["goog","12/13/2010",594.62,-4.8758754423243434E-4]
["goog","12/10/2010",592.21,-4.0612443441519182E-3]
["goog","12/9/2010",591.5,-1.1996182935783907E-3]
["goog","12/8/2010",590.54,-1.6243108711564262E-3]
["goog","12/7/2010",587.14,-5.7740803042065627E-3]
["goog","12/6/2010",578.36,-1.506678008315279E-2]
["goog","12/3/2010",573,-9.3107954451859543E-3]
["goog","12/2/2010",571.82000000000005,-2.0614601734403764E-3]
["goog","12/1/2010",564.35,-1.314963013966383E-2]
["goog","11/30/2010",555.71,-1.5428050956457082E-2]
["goog","11/29/2010",582.11,4.6412857863786433E-2]
["goog","11/26/2010",590,1.3463103590800362E-2]
["goog","11/24/2010",594.97,8.3884472066580243E-3]
["goog","11/23/2010",583.01,-2.0306645244373846E-2]
["goog","11/22/2010",591.22,1.3983859699061593E-2]
["goog","11/19/2010",590.83000000000004,-6.5987058779478844E-4]
["goog","11/18/2010",596.55999999999995,9.6514952622233519E-3]
["goog","11/17/2010",583.54999999999995,-2.2049685377176637E-2]
["goog","11/16/2010",583.72,2.9127794118235313E-4]
["goog","11/15/2010",595.47,1.9929593893050941E-2]
["goog","11/12/2010",603.29,1.3047000115335857E-2]
["goog","11/11/2010",617.19000000000005,2.2778908346317083E-2]
["goog","11/10/2010",622.88,9.1769657078964312E-3]
["goog","11/9/2010",624.82000000000005,3.1097243942915884E-3]
["goog","11/8/2010",626.77,3.1160389230111144E-3]
["goog","11/5/2010",625.08000000000004,-2.7000056343477003E-3]
["goog","11/4/2010",624.27,-1.2966744523027151E-3]
["goog","11/3/2010",620.17999999999995,-6.5732086084609133E-3]
["goog","11/2/2010",615.6,-7.4123565196127185E-3]
["goog","11/1/2010",615,-9.7513415820631828E-4]
["goog","10/29/2010",613.70000000000005,-2.1160584114665185E-3]
["goog","10/28/2010",618.58000000000004,7.9203192630991088E-3]
["goog","10/27/2010",616.47,-3.416869038261953E-3]
["goog","10/26/2010",618.6,3.4492006310806161E-3]
["goog","10/25/2010",616.5,-3.4005376465703033E-3]
["goog","10/22/2010",612.53,-6.4604017931412482E-3]
["goog","10/21/2010",611.99,-8.8197830170979468E-4]
["goog","10/20/2010",607.98,-6.5739558212667077E-3]
["goog","10/19/2010",607.83000000000004,-2.4674908211163113E-4]
["goog","10/18/2010",617.71,1.6123854053196347E-2]
["goog","10/15/2010",601.45000000000005,-2.6675685219284283E-2]
["goog","10/14/2010",540.92999999999995,{"$f":"LN(C66/C65)","v":-0.10605352598369511}]
["goog","10/13/2010",543.29999999999995,4.3717731010907111E-3]
["goog","10/12/2010",541.39,-3.5217471795562947E-3]
["goog","10/11/2010",538.84,-4.7212255475537227E-3]
["goog","10/8/2010",536.35,-4.6317477869289789E-3]
["goog","10/7/2010",530.01,-1.1891058750739491E-2]
["goog","10/6/2010",534.35,8.15518067820694E-3]
["goog","10/5/2010",538.23,7.234923128497093E-3]
["goog","10/4/2010",522.35,-2.9948116815885696E-2]
["goog","10/1/2010",525.62,6.2406569133148567E-3]
["goog","9/30/2010",525.79,3.2337527982691222E-4]
["goog","9/29/2010",527.69000000000005,3.6070965943307059E-3]
["goog","9/28/2010",527.16999999999996,-9.8591290241579143E-4]
["goog","9/27/2010",530.41,6.1272152206747043E-3]
["goog","9/24/2010",527.29,-5.8996105689703955E-3]
["goog","9/23/2010",513.48,-2.6539601603552052E-2]
["goog","9/22/2010",516,4.8956852648368325E-3]
["goog","9/21/2010",513.46,-4.93463593381957E-3]
["goog","9/20/2010",508.28,-1.0139652711409616E-2]
["goog","9/17/2010",490.15,-3.6321010128598466E-2]
["goog","9/16/2010",481.06,-1.8719464256636266E-2]
["goog","9/15/2010",480.64,-8.734533153837244E-4]
["goog","9/14/2010",480.43,-4.3701291964613672E-4]
["goog","9/13/2010",482.27,3.8225869752411519E-3]
["goog","9/10/2010",476.14,-1.2792194556947571E-2]
["goog","9/9/2010",476.18,8.4005376393429831E-5]
["goog","9/8/2010",470.58,-1.1829957558126086E-2]
["goog","9/7/2010",464.4,-1.3219726628893699E-2]
["goog","9/3/2010",470.3,1.2624539127265934E-2]
["goog","9/2/2010",463.18,-1.5255041517327692E-2]
["goog","9/1/2010",460.33,-6.172123848325539E-3]
["goog","8/31/2010",450.02,-2.265159736416426E-2]
["goog","8/30/2010",452.69,5.9155382926299417E-3]
["goog","8/27/2010",458.83,1.3472206572314649E-2]
["goog","8/26/2010",450.98,-1.7256778464763752E-2]
["goog","8/25/2010",454.62,8.0389125499715462E-3]
["goog","8/24/2010",451.39,-7.1301943341315552E-3]
["goog","8/23/2010",464.07,2.7703692079477711E-2]
["goog","8/20/2010",462.02,-4.4272227286412729E-3]
["goog","8/19/2010",467.97,1.279601111084506E-2]
["goog","8/18/2010",482.15,2.9851077657506324E-2]
["goog","8/17/2010",490.52,1.7210783937431914E-2]
["goog","8/16/2010",485.59,-1.0101406441302021E-2]
["goog","8/13/2010",486.35,1.563882862926259E-3]
["goog","8/12/2010",492.01,1.1570512173556521E-2]
["goog","8/11/2010",491.74,-5.4891996295716196E-4]
["goog","8/10/2010",503.71,2.4050584115641069E-2]
["goog","8/9/2010",505.35,3.2505528789817809E-3]
["goog","8/6/2010",500.22,-1.0203256870094555E-2]
["goog","8/5/2010",508.1,1.5630276949109057E-2]
["goog","8/4/2010",506.32,-3.5093981326363957E-3]
["goog","8/3/2010",489.83,-3.3110488335068397E-2]
["goog","8/2/2010",490.41,1.1833837992448462E-3]
["goog","7/30/2010",484.85,-1.1402211180671085E-2]
["goog","7/29/2010",484.99,2.8870741766156205E-4]
["goog","7/28/2010",484.35,-1.3204862958228318E-3]
["goog","7/27/2010",492.63,1.6950599299461723E-2]
["goog","7/26/2010",488.97,-7.4572472722045906E-3]
["goog","7/23/2010",490.06,2.2266946883486099E-3]
["goog","7/22/2010",484.81,-1.077077098292378E-2]
["goog","7/21/2010",477.5,-1.5192901684291096E-2]
["goog","7/20/2010",481.59,8.5289697386477532E-3]
["goog","7/19/2010",466.18,-3.2521304020909074E-2]
["goog","7/16/2010",459.61,-1.4193521850147196E-2]
["goog","7/15/2010",494.02,{"$f":"LN(C130/C129)","v":7.2197698409976446E-2}]
["goog","7/14/2010",491.34,-5.4396496882010434E-3]
["goog","7/13/2010",489.2,-4.3649486971345493E-3]
["goog","7/12/2010",475.83,-2.7710756229439127E-2]
["goog","7/9/2010",467.49,-1.7682689457945395E-2]
["goog","7/8/2010",456.56,-2.3657831897180157E-2]
["goog","7/7/2010",450.2,-1.4028197755820863E-2]
["goog","7/6/2010",436.07,-3.1889147551727504E-2]
["goog","7/2/2010",436.55,1.100135335912425E-3]
["goog","7/1/2010",439.49,6.7120474810034077E-3]
["goog","6/30/2010",444.95,1.2346952565051032E-2]
["goog","6/29/2010",454.26,2.0707805040399128E-2]
["goog","6/28/2010",472.08,3.8478741405643002E-2]
["goog","6/25/2010",472.68,1.2701640219015976E-3]
["goog","6/24/2010",475.1,5.1066814220609401E-3]
["goog","6/23/2010",482.05,1.4522534917513758E-2]
["goog","6/22/2010",486.25,8.6750518222665964E-3]
["goog","6/21/2010",488.56,4.7393939822231793E-3]
["goog","6/18/2010",500.03,2.3205807707384347E-2]
["goog","6/17/2010",500.08,9.998900129328733E-5]
["goog","6/16/2010",501.27,2.3767924506047891E-3]
["goog","6/15/2010",497.99,-6.564881572406275E-3]
["goog","6/14/2010",483.19,-3.0170045459540714E-2]
["goog","6/11/2010",488.5,1.0929520440622578E-2]
["goog","6/10/2010",487.01,-3.0548147301614511E-3]
["goog","6/9/2010",474.02,-2.7035141854918222E-2]
["goog","6/8/2010",484.78,2.2445664880959393E-2]
["goog","6/7/2010",485.52,1.5253017488823823E-3]
["goog","6/4/2010",498.72,2.6824334491427335E-2]
["goog","6/3/2010",505.6,1.37010268136207E-2]
["goog","6/2/2010",493.37,-2.4486443180188062E-2]
["goog","6/1/2010",482.37,-2.254794522802972E-2]
["goog","5/28/2010",485.63,6.7355626547745233E-3]
["goog","5/27/2010",490.46,9.8967091615293906E-3]
["goog","5/26/2010",475.47,-3.1039937728289911E-2]
["goog","5/25/2010",477.07,3.3594421332014865E-3]
["goog","5/24/2010",477.16,1.8863376809982892E-4]
["goog","5/21/2010",472.05,-1.0766952235219512E-2]
["goog","5/20/2010",475.01,6.2509442660911192E-3]
["goog","5/19/2010",494.43,4.0069727469581755E-2]
["goog","5/18/2010",498.37,7.9371891310244316E-3]
["goog","5/17/2010",507.97,1.9079617671326824E-2]
["goog","5/14/2010",507.53,-8.6656824723686267E-4]
["goog","5/13/2010",510.88,6.5789064971591565E-3]
["goog","5/12/2010",505.39,-1.0804320516004585E-2]
["goog","5/11/2010",509.05,7.215835102737554E-3]
["goog","5/10/2010",521.65,2.4450621360773535E-2]
["goog","5/7/2010",493.14,-5.6203755525514765E-2]
["goog","5/6/2010",498.67,1.1151444947486855E-2]
["goog","5/5/2010",509.76,2.1995472385733256E-2]
["goog","5/4/2010",506.37,-6.6723993527375153E-3]
["goog","5/3/2010",530.6,4.6740814334693202E-2]
["goog","4/30/2010",525.70000000000005,-9.2777338782368771E-3]
["goog","4/29/2010",532,1.1912781516241961E-2]
["goog","4/28/2010",529.19000000000005,-5.2959537268516509E-3]
["goog","4/27/2010",529.05999999999995,-2.4568863813666703E-4]
["goog","4/26/2010",531.64,4.8647215764758183E-3]
["goog","4/23/2010",544.99,2.4800877317920914E-2]
["goog","4/22/2010",547.05999999999995,3.7910397494002939E-3]
["goog","4/21/2010",554.29999999999995,1.3147570805305682E-2]
["goog","4/20/2010",555.04,1.3341267956806686E-3]
["goog","4/19/2010",550.1,-8.9401033400270478E-3]
["goog","4/16/2010",550.15,9.0888434509165018E-5]
["goog","4/15/2010",595.29999999999995,7.8874511843422659E-2]
["goog","4/14/2010",589,{"$f":"LN(C194/C193)","v":-1.0639296507757646E-2}]
["goog","4/13/2010",586.77,-3.7932634340506126E-3]
["goog","4/12/2010",572.73,-2.4218518742858425E-2]
["goog","4/9/2010",566.22,-1.1431706213380955E-2]
["goog","4/8/2010",567.49,2.2404327936324151E-3]
["goog","4/7/2010",563.54,-6.9848121787026828E-3]
["goog","4/6/2010",568.22,8.2703517980314174E-3]
["goog","4/5/2010",571.01,4.8980549632504557E-3]
["goog","4/1/2010",568.79999999999995,-3.8778441484770935E-3]
["goog","3/31/2010",567.12,-2.9579569422689737E-3]
["goog","3/30/2010",566.71,-7.2321250605535548E-4]
["goog","3/29/2010",562.45000000000005,-7.5454678018717653E-3]
["goog","3/26/2010",562.69000000000005,4.2661358344733315E-4]
["goog","3/25/2010",562.88,3.3760672691102444E-4]
["goog","3/24/2010",557.33000000000004,-9.9089374517854142E-3]
["goog","3/23/2010",549,-1.5059082587877222E-2]
["goog","3/22/2010",557.5,1.5364061824743246E-2]
["goog","3/19/2010",560,4.4742803949211069E-3]
["goog","3/18/2010",566.4,1.1363758650315003E-2]
["goog","3/17/2010",565.55999999999995,-1.4841516558702884E-3]
["goog","3/16/2010",565.20000000000005,-6.3673991326720675E-4]
["goog","3/15/2010",563.17999999999995,-3.5803579607196242E-3]
["goog","3/12/2010",579.54,2.863539256960668E-2]
["goog","3/11/2010",581.14,2.7570062609465506E-3]
["goog","3/10/2010",576.45000000000005,-8.1030860012432267E-3]
["goog","3/9/2010",560.19000000000005,-2.8612593779864342E-2]
["goog","3/8/2010",562.48,4.0795659918075391E-3]
["goog","3/5/2010",564.21,3.0709447311907251E-3]
["goog","3/4/2010",554.59,-1.7197420616322519E-2]
["goog","3/3/2010",545.32000000000005,-1.6856323687845103E-2]
["goog","3/2/2010",541.05999999999995,-7.8425998909039916E-3]
["goog","3/1/2010",532.69000000000005,-1.5590536972369978E-2]
["goog","2/26/2010",526.79999999999995,-1.111867158552907E-2]
["goog","2/25/2010",526.42999999999995,-7.0260060047812247E-4]
["goog","2/24/2010",531.47,9.5283828939903021E-3]
["goog","2/23/2010",535.07000000000005,6.7508272959108818E-3]
["goog","2/22/2010",542.79999999999995,1.4343348502165024E-2]
["goog","2/19/2010",540.76,-3.7653704645094349E-3]
["goog","2/18/2010",543.22,4.5388369217363011E-3]
["goog","2/17/2010",538.21,-9.2655758443869352E-3]
["goog","2/16/2010",541.29999999999995,5.7248352293781434E-3]
["goog","2/12/2010",533.12,-1.522711426450893E-2]
["goog","2/11/2010",536.4,6.1336118691002264E-3]
["goog","2/10/2010",534.45000000000005,-3.6419706875685451E-3]
["goog","2/9/2010",536.44000000000005,3.7165391227845955E-3]
["goog","2/8/2010",533.47,-5.5518831094000147E-3]
["goog","2/5/2010",531.29,-4.0948252115257065E-3]
["goog","2/4/2010",526.78,-8.5250074455131084E-3]
["goog","2/3/2010",540.82000000000005,2.6303502217148056E-2]
["goog","2/2/2010",531.12,-1.8098521882544752E-2]
["goog","2/1/2010",533.02,3.5709625031111187E-3]
["goog","1/29/2010",529.94000000000005,-5.7951543234752304E-3]
["goog","1/28/2010",534.29,8.1749701209276448E-3]
["goog","1/27/2010",542.1,1.4511723554825186E-2]
["goog","1/26/2010",542.41999999999996,5.9012283643727469E-4]
["goog","1/25/2010",540,-4.4714695444097443E-3]
["goog","1/22/2010",550.01,1.8367320321091084E-2]
[null,null,null,{"$f":"STDEV(D2:D250)*SQRT(250)","v":0.26955412492660341}]