{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["EoC Exercise 1 DATA","EoC Exercise 1a Template","EoC Exercise 1b Template","EoC Exercise 1c Template","EoC Exercise 2 Template","EoC Exercise 3 DATA","EoC Exercise 3 Template"],"read":"whole","date_system":"1900"}

{"sheet":"EoC Exercise 1 DATA","index":0,"n_rows":64,"n_cols":6,"rows_kept":64}
[]
["Date","S&P500\nVFINX","Exxon Mobile\nXOM","British Petroleum\nBP","Chevron\nCVX","Conoco\nPhillips\nCOP"]
["2009-11-02",91.04482,65.4231,45.40563,65.31213,31.92902]
["2009-12-01",92.81683,59.42722,46.03296,64.43338,31.4973]
["2010-01-04",89.47192,56.1504,44.5639,60.35765,29.60388]
["2010-02-01",92.23825,57.0167,42.89716,61.0874,29.9072]
["2010-03-01",97.78734,58.75352,46.00903,64.06995,31.88233]
["2010-04-01",99.33044,59.44649,42.0426,68.80993,36.87933]
["2010-05-03",91.388,53.39447,35.20324,62.9967,32.64529]
["2010-06-01",86.59035,50.40063,23.671,57.87134,30.90161]
["2010-07-01",92.6483,52.70562,31.53128,64.99226,35.11513]
["2010-08-02",88.45152,52.57578,28.54782,63.7666,33.34094]
["2010-09-01",96.33633,54.95952,33.74429,69.76624,36.5205]
["2010-10-01",99.98586,59.13996,33.44103,71.10044,38.10842]
["2010-11-01",99.98586,62.26016,32.78532,70.29379,38.60892]
["2010-12-01",106.65553,65.44657,36.20319,79.21832,43.69732]
["2011-01-03",109.16951,72.2132,38.90798,82.4131,45.8533]
["2011-02-01",112.89904,76.95767,40.08745,90.74758,50.41027]
["2011-03-01",112.93236,75.69798,36.50629,94.01886,51.69853]
["2011-04-01",116.26151,79.16212,38.16041,95.72449,51.07058]
["2011-05-02",114.92985,75.5301,38.60358,92.47178,47.83363]
["2011-06-01",113.00646,73.6389,36.97561,90.64719,49.1206]
["2011-07-01",110.69339,72.20015,37.93569,91.68729,47.44701]
["2011-08-01",104.66451,67.42133,33.20462,87.81941,44.86342]
["2011-09-01",97.27694,66.15524,30.40596,82.26628,41.7328]
["2011-10-03",107.89355,71.12849,37.24245,93.33701,46.35569]
["2011-11-01",107.64144,73.70557,37.07589,92.07786,47.46716]
["2011-12-01",108.74202,77.6639,36.38631,95.28384,48.49876]
["2012-01-03",113.59691,76.72929,39.08506,92.34652,45.39729]
["2012-02-01",118.48936,79.69204,40.56827,98.46866,51.40995]
["2012-03-01",122.3791,79.90394,38.71018,96.74509,51.04729]
["2012-04-02",121.59644,79.54462,37.34242,96.15854,48.10575]
["2012-05-01",114.27897,72.9405,31.74078,89.51225,46.53909]
["2012-06-01",118.97882,79.37833,35.29269,96.05882,49.85821]
["2012-07-02",120.6088,80.56571,34.73553,99.7737,49.14474]
["2012-08-01",123.30962,81.50944,37.03421,102.94039,51.26616]
["2012-09-04",126.48666,85.38416,37.29837,106.97871,51.61823]
["2012-10-01",124.13461,85.12274,37.76503,101.17822,52.83223]
["2012-11-01",124.82975,82.80896,37.2366,97.83861,52.00116]
["2012-12-03",125.94801,81.31513,37.12959,100.10661,52.96009]
["2013-01-02",132.46736,84.52827,39.69764,106.59586,52.96922]
["2013-02-01",134.24101,84.67119,36.47842,109.2916,53.52631]
["2013-03-01",139.25467,85.20068,38.23913,110.84957,55.51218]
["2013-04-01",141.91245,84.14169,39.3678,113.82559,55.83547]
["2013-05-01",145.21544,86.13281,39.22541,115.43946,57.24503]
["2013-06-03",143.256,86.01856,38.15588,111.29211,56.4611]
["2013-07-01",150.52234,89.25557,37.88164,118.39246,61.17387]
["2013-08-01",146.13931,83.55505,38.24729,114.19326,62.53204]
["2013-09-03",150.69609,82.48136,38.92333,115.20785,65.5596]
["2013-10-01",157.60777,85.9133,43.06293,113.7476,69.85333]
["2013-11-01",162.3808,90.2234,44.06981,117.07406,69.34846]
["2013-12-02",166.46735,97.67445,45.56974,119.43581,67.30039]
["2014-01-02",160.69238,88.94938,43.95732,106.7378,61.87063]
["2014-02-03",168.02101,93.57428,48.00759,111.25519,64.0245]
["2014-03-03",169.40305,94.9448,45.62666,114.7087,67.73118]
["2014-04-01",170.62968,99.54236,48.01707,121.08515,71.54377]
["2014-05-01",174.61378,98.37842,48.40981,119.46272,77.64634]
["2014-06-02",178.19807,98.52521,50.61679,127.01245,83.27021]
["2014-07-01",175.72461,96.82246,46.98965,125.73795,80.8134]
["2014-08-01",182.73111,98.00935,46.465,127.0127,79.55956]
["2014-09-02",180.13966,92.67825,42.68681,117.07343,74.95564]
["2014-10-01",184.50481,95.29945,42.21089,117.69156,71.37408]
["2014-11-03",189.45398,89.86359,38.74807,107.81081,65.35947]
["2014-12-01",188.16721,91.66007,39.25066,110.64298,67.04118]

{"sheet":"EoC Exercise 1a Template","index":1,"n_rows":71,"n_cols":13,"rows_kept":71,"merged":[[0,0,0,12],[1,7,1,12],[7,0,7,5],[7,7,7,12]]}
["4 OIL STOCKS AND THE SP500"]
[{"$nulls":7},"Regression results"]
[{"$nulls":9},"XOM","BP","CVX","COP"]
[{"$nulls":7},"Alpha"]
[{"$nulls":7},"Beta"]
[{"$nulls":7},"R-squared"]
[]
["Stock prices",{"$nulls":6},"Stock returns"]
["Date","S&P500\nVFINX","Exxon Mobile\nXOM","British Petroleum\nBP","Chevron\nCVX","Conoco\nPhillips\nCOP",null,"Date","S&P500\nVFINX","Exxon Mobile\nXOM","British Petroleum\nBP","Chevron\nCVX","Conoco\nPhillips\nCOP"]
["2009-11-02",{"v":91.04482,"d":"91.04"},{"v":65.4231,"d":"65.42"},{"v":45.40563,"d":"45.41"},{"v":65.31213,"d":"65.31"},{"v":31.92902,"d":"31.93"},null,"2009-11-02"]
["2009-12-01",{"v":92.81683,"d":"92.82"},{"v":59.42722,"d":"59.43"},{"v":46.03296,"d":"46.03"},{"v":64.43338,"d":"64.43"},{"v":31.4973,"d":"31.50"},null,"2009-12-01"]
["2010-01-04",{"v":89.47192,"d":"89.47"},{"v":56.1504,"d":"56.15"},{"v":44.5639,"d":"44.56"},{"v":60.35765,"d":"60.36"},{"v":29.60388,"d":"29.60"},null,"2010-01-04"]
["2010-02-01",{"v":92.23825,"d":"92.24"},{"v":57.0167,"d":"57.02"},{"v":42.89716,"d":"42.90"},{"v":61.0874,"d":"61.09"},{"v":29.9072,"d":"29.91"},null,"2010-02-01"]
["2010-03-01",{"v":97.78734,"d":"97.79"},{"v":58.75352,"d":"58.75"},{"v":46.00903,"d":"46.01"},{"v":64.06995,"d":"64.07"},{"v":31.88233,"d":"31.88"},null,"2010-03-01"]
["2010-04-01",{"v":99.33044,"d":"99.33"},{"v":59.44649,"d":"59.45"},{"v":42.0426,"d":"42.04"},{"v":68.80993,"d":"68.81"},{"v":36.87933,"d":"36.88"},null,"2010-04-01"]
["2010-05-03",{"v":91.388,"d":"91.39"},{"v":53.39447,"d":"53.39"},{"v":35.20324,"d":"35.20"},{"v":62.9967,"d":"63.00"},{"v":32.64529,"d":"32.65"},null,"2010-05-03"]
["2010-06-01",{"v":86.59035,"d":"86.59"},{"v":50.40063,"d":"50.40"},{"v":23.671,"d":"23.67"},{"v":57.87134,"d":"57.87"},{"v":30.90161,"d":"30.90"},null,"2010-06-01"]
["2010-07-01",{"v":92.6483,"d":"92.65"},{"v":52.70562,"d":"52.71"},{"v":31.53128,"d":"31.53"},{"v":64.99226,"d":"64.99"},{"v":35.11513,"d":"35.12"},null,"2010-07-01"]
["2010-08-02",{"v":88.45152,"d":"88.45"},{"v":52.57578,"d":"52.58"},{"v":28.54782,"d":"28.55"},{"v":63.7666,"d":"63.77"},{"v":33.34094,"d":"33.34"},null,"2010-08-02"]
["2010-09-01",{"v":96.33633,"d":"96.34"},{"v":54.95952,"d":"54.96"},{"v":33.74429,"d":"33.74"},{"v":69.76624,"d":"69.77"},{"v":36.5205,"d":"36.52"},null,"2010-09-01"]
["2010-10-01",{"v":99.98586,"d":"99.99"},{"v":59.13996,"d":"59.14"},{"v":33.44103,"d":"33.44"},{"v":71.10044,"d":"71.10"},{"v":38.10842,"d":"38.11"},null,"2010-10-01"]
["2010-11-01",{"v":99.98586,"d":"99.99"},{"v":62.26016,"d":"62.26"},{"v":32.78532,"d":"32.79"},{"v":70.29379,"d":"70.29"},{"v":38.60892,"d":"38.61"},null,"2010-11-01"]
["2010-12-01",{"v":106.65553,"d":"106.66"},{"v":65.44657,"d":"65.45"},{"v":36.20319,"d":"36.20"},{"v":79.21832,"d":"79.22"},{"v":43.69732,"d":"43.70"},null,"2010-12-01"]
["2011-01-03",{"v":109.16951,"d":"109.17"},{"v":72.2132,"d":"72.21"},{"v":38.90798,"d":"38.91"},{"v":82.4131,"d":"82.41"},{"v":45.8533,"d":"45.85"},null,"2011-01-03"]
["2011-02-01",{"v":112.89904,"d":"112.90"},{"v":76.95767,"d":"76.96"},{"v":40.08745,"d":"40.09"},{"v":90.74758,"d":"90.75"},{"v":50.41027,"d":"50.41"},null,"2011-02-01"]
["2011-03-01",{"v":112.93236,"d":"112.93"},{"v":75.69798,"d":"75.70"},{"v":36.50629,"d":"36.51"},{"v":94.01886,"d":"94.02"},{"v":51.69853,"d":"51.70"},null,"2011-03-01"]
["2011-04-01",{"v":116.26151,"d":"116.26"},{"v":79.16212,"d":"79.16"},{"v":38.16041,"d":"38.16"},{"v":95.72449,"d":"95.72"},{"v":51.07058,"d":"51.07"},null,"2011-04-01"]
["2011-05-02",{"v":114.92985,"d":"114.93"},{"v":75.5301,"d":"75.53"},{"v":38.60358,"d":"38.60"},{"v":92.47178,"d":"92.47"},{"v":47.83363,"d":"47.83"},null,"2011-05-02"]
["2011-06-01",{"v":113.00646,"d":"113.01"},{"v":73.6389,"d":"73.64"},{"v":36.97561,"d":"36.98"},{"v":90.64719,"d":"90.65"},{"v":49.1206,"d":"49.12"},null,"2011-06-01"]
["2011-07-01",{"v":110.69339,"d":"110.69"},{"v":72.20015,"d":"72.20"},{"v":37.93569,"d":"37.94"},{"v":91.68729,"d":"91.69"},{"v":47.44701,"d":"47.45"},null,"2011-07-01"]
["2011-08-01",{"v":104.66451,"d":"104.66"},{"v":67.42133,"d":"67.42"},{"v":33.20462,"d":"33.20"},{"v":87.81941,"d":"87.82"},{"v":44.86342,"d":"44.86"},null,"2011-08-01"]
["2011-09-01",{"v":97.27694,"d":"97.28"},{"v":66.15524,"d":"66.16"},{"v":30.40596,"d":"30.41"},{"v":82.26628,"d":"82.27"},{"v":41.7328,"d":"41.73"},null,"2011-09-01"]
["2011-10-03",{"v":107.89355,"d":"107.89"},{"v":71.12849,"d":"71.13"},{"v":37.24245,"d":"37.24"},{"v":93.33701,"d":"93.34"},{"v":46.35569,"d":"46.36"},null,"2011-10-03"]
["2011-11-01",{"v":107.64144,"d":"107.64"},{"v":73.70557,"d":"73.71"},{"v":37.07589,"d":"37.08"},{"v":92.07786,"d":"92.08"},{"v":47.46716,"d":"47.47"},null,"2011-11-01"]
["2011-12-01",{"v":108.74202,"d":"108.74"},{"v":77.6639,"d":"77.66"},{"v":36.38631,"d":"36.39"},{"v":95.28384,"d":"95.28"},{"v":48.49876,"d":"48.50"},null,"2011-12-01"]
["2012-01-03",{"v":113.59691,"d":"113.60"},{"v":76.72929,"d":"76.73"},{"v":39.08506,"d":"39.09"},{"v":92.34652,"d":"92.35"},{"v":45.39729,"d":"45.40"},null,"2012-01-03"]
["2012-02-01",{"v":118.48936,"d":"118.49"},{"v":79.69204,"d":"79.69"},{"v":40.56827,"d":"40.57"},{"v":98.46866,"d":"98.47"},{"v":51.40995,"d":"51.41"},null,"2012-02-01"]
["2012-03-01",{"v":122.3791,"d":"122.38"},{"v":79.90394,"d":"79.90"},{"v":38.71018,"d":"38.71"},{"v":96.74509,"d":"96.75"},{"v":51.04729,"d":"51.05"},null,"2012-03-01"]
["2012-04-02",{"v":121.59644,"d":"121.60"},{"v":79.54462,"d":"79.54"},{"v":37.34242,"d":"37.34"},{"v":96.15854,"d":"96.16"},{"v":48.10575,"d":"48.11"},null,"2012-04-02"]
["2012-05-01",{"v":114.27897,"d":"114.28"},{"v":72.9405,"d":"72.94"},{"v":31.74078,"d":"31.74"},{"v":89.51225,"d":"89.51"},{"v":46.53909,"d":"46.54"},null,"2012-05-01"]
["2012-06-01",{"v":118.97882,"d":"118.98"},{"v":79.37833,"d":"79.38"},{"v":35.29269,"d":"35.29"},{"v":96.05882,"d":"96.06"},{"v":49.85821,"d":"49.86"},null,"2012-06-01"]
["2012-07-02",{"v":120.6088,"d":"120.61"},{"v":80.56571,"d":"80.57"},{"v":34.73553,"d":"34.74"},{"v":99.7737,"d":"99.77"},{"v":49.14474,"d":"49.14"},null,"2012-07-02"]
["2012-08-01",{"v":123.30962,"d":"123.31"},{"v":81.50944,"d":"81.51"},{"v":37.03421,"d":"37.03"},{"v":102.94039,"d":"102.94"},{"v":51.26616,"d":"51.27"},null,"2012-08-01"]
["2012-09-04",{"v":126.48666,"d":"126.49"},{"v":85.38416,"d":"85.38"},{"v":37.29837,"d":"37.30"},{"v":106.97871,"d":"106.98"},{"v":51.61823,"d":"51.62"},null,"2012-09-04"]
["2012-10-01",{"v":124.13461,"d":"124.13"},{"v":85.12274,"d":"85.12"},{"v":37.76503,"d":"37.77"},{"v":101.17822,"d":"101.18"},{"v":52.83223,"d":"52.83"},null,"2012-10-01"]
["2012-11-01",{"v":124.82975,"d":"124.83"},{"v":82.80896,"d":"82.81"},{"v":37.2366,"d":"37.24"},{"v":97.83861,"d":"97.84"},{"v":52.00116,"d":"52.00"},null,"2012-11-01"]
["2012-12-03",{"v":125.94801,"d":"125.95"},{"v":81.31513,"d":"81.32"},{"v":37.12959,"d":"37.13"},{"v":100.10661,"d":"100.11"},{"v":52.96009,"d":"52.96"},null,"2012-12-03"]
["2013-01-02",{"v":132.46736,"d":"132.47"},{"v":84.52827,"d":"84.53"},{"v":39.69764,"d":"39.70"},{"v":106.59586,"d":"106.60"},{"v":52.96922,"d":"52.97"},null,"2013-01-02"]
["2013-02-01",{"v":134.24101,"d":"134.24"},{"v":84.67119,"d":"84.67"},{"v":36.47842,"d":"36.48"},{"v":109.2916,"d":"109.29"},{"v":53.52631,"d":"53.53"},null,"2013-02-01"]
["2013-03-01",{"v":139.25467,"d":"139.25"},{"v":85.20068,"d":"85.20"},{"v":38.23913,"d":"38.24"},{"v":110.84957,"d":"110.85"},{"v":55.51218,"d":"55.51"},null,"2013-03-01"]
["2013-04-01",{"v":141.91245,"d":"141.91"},{"v":84.14169,"d":"84.14"},{"v":39.3678,"d":"39.37"},{"v":113.82559,"d":"113.83"},{"v":55.83547,"d":"55.84"},null,"2013-04-01"]
["2013-05-01",{"v":145.21544,"d":"145.22"},{"v":86.13281,"d":"86.13"},{"v":39.22541,"d":"39.23"},{"v":115.43946,"d":"115.44"},{"v":57.24503,"d":"57.25"},null,"2013-05-01"]
["2013-06-03",{"v":143.256,"d":"143.26"},{"v":86.01856,"d":"86.02"},{"v":38.15588,"d":"38.16"},{"v":111.29211,"d":"111.29"},{"v":56.4611,"d":"56.46"},null,"2013-06-03"]
["2013-07-01",{"v":150.52234,"d":"150.52"},{"v":89.25557,"d":"89.26"},{"v":37.88164,"d":"37.88"},{"v":118.39246,"d":"118.39"},{"v":61.17387,"d":"61.17"},null,"2013-07-01"]
["2013-08-01",{"v":146.13931,"d":"146.14"},{"v":83.55505,"d":"83.56"},{"v":38.24729,"d":"38.25"},{"v":114.19326,"d":"114.19"},{"v":62.53204,"d":"62.53"},null,"2013-08-01"]
["2013-09-03",{"v":150.69609,"d":"150.70"},{"v":82.48136,"d":"82.48"},{"v":38.92333,"d":"38.92"},{"v":115.20785,"d":"115.21"},{"v":65.5596,"d":"65.56"},null,"2013-09-03"]
["2013-10-01",{"v":157.60777,"d":"157.61"},{"v":85.9133,"d":"85.91"},{"v":43.06293,"d":"43.06"},{"v":113.7476,"d":"113.75"},{"v":69.85333,"d":"69.85"},null,"2013-10-01"]
["2013-11-01",{"v":162.3808,"d":"162.38"},{"v":90.2234,"d":"90.22"},{"v":44.06981,"d":"44.07"},{"v":117.07406,"d":"117.07"},{"v":69.34846,"d":"69.35"},null,"2013-11-01"]
["2013-12-02",{"v":166.46735,"d":"166.47"},{"v":97.67445,"d":"97.67"},{"v":45.56974,"d":"45.57"},{"v":119.43581,"d":"119.44"},{"v":67.30039,"d":"67.30"},null,"2013-12-02"]
["2014-01-02",{"v":160.69238,"d":"160.69"},{"v":88.94938,"d":"88.95"},{"v":43.95732,"d":"43.96"},{"v":106.7378,"d":"106.74"},{"v":61.87063,"d":"61.87"},null,"2014-01-02"]
["2014-02-03",{"v":168.02101,"d":"168.02"},{"v":93.57428,"d":"93.57"},{"v":48.00759,"d":"48.01"},{"v":111.25519,"d":"111.26"},{"v":64.0245,"d":"64.02"},null,"2014-02-03"]
["2014-03-03",{"v":169.40305,"d":"169.40"},{"v":94.9448,"d":"94.94"},{"v":45.62666,"d":"45.63"},{"v":114.7087,"d":"114.71"},{"v":67.73118,"d":"67.73"},null,"2014-03-03"]
["2014-04-01",{"v":170.62968,"d":"170.63"},{"v":99.54236,"d":"99.54"},{"v":48.01707,"d":"48.02"},{"v":121.08515,"d":"121.09"},{"v":71.54377,"d":"71.54"},null,"2014-04-01"]
["2014-05-01",{"v":174.61378,"d":"174.61"},{"v":98.37842,"d":"98.38"},{"v":48.40981,"d":"48.41"},{"v":119.46272,"d":"119.46"},{"v":77.64634,"d":"77.65"},null,"2014-05-01"]
["2014-06-02",{"v":178.19807,"d":"178.20"},{"v":98.52521,"d":"98.53"},{"v":50.61679,"d":"50.62"},{"v":127.01245,"d":"127.01"},{"v":83.27021,"d":"83.27"},null,"2014-06-02"]
["2014-07-01",{"v":175.72461,"d":"175.72"},{"v":96.82246,"d":"96.82"},{"v":46.98965,"d":"46.99"},{"v":125.73795,"d":"125.74"},{"v":80.8134,"d":"80.81"},null,"2014-07-01"]
["2014-08-01",{"v":182.73111,"d":"182.73"},{"v":98.00935,"d":"98.01"},{"v":46.465,"d":"46.47"},{"v":127.0127,"d":"127.01"},{"v":79.55956,"d":"79.56"},null,"2014-08-01"]
["2014-09-02",{"v":180.13966,"d":"180.14"},{"v":92.67825,"d":"92.68"},{"v":42.68681,"d":"42.69"},{"v":117.07343,"d":"117.07"},{"v":74.95564,"d":"74.96"},null,"2014-09-02"]
["2014-10-01",{"v":184.50481,"d":"184.50"},{"v":95.29945,"d":"95.30"},{"v":42.21089,"d":"42.21"},{"v":117.69156,"d":"117.69"},{"v":71.37408,"d":"71.37"},null,"2014-10-01"]
["2014-11-03",{"v":189.45398,"d":"189.45"},{"v":89.86359,"d":"89.86"},{"v":38.74807,"d":"38.75"},{"v":107.81081,"d":"107.81"},{"v":65.35947,"d":"65.36"},null,"2014-11-03"]
["2014-12-01",{"v":188.16721,"d":"188.17"},{"v":91.66007,"d":"91.66"},{"v":39.25066,"d":"39.25"},{"v":110.64298,"d":"110.64"},{"v":67.04118,"d":"67.04"},null,"2014-12-01"]

{"sheet":"EoC Exercise 1b Template","index":2,"n_rows":83,"n_cols":15,"rows_kept":83,"merged":[[0,0,0,12],[1,7,1,12],[7,7,7,12],[12,7,12,12],[19,0,19,5],[19,7,19,14]]}
["4 OIL STOCKS AND THE SP500"]
[{"$nulls":7},"Regression results:  individual stocks"]
[{"$nulls":8},"SP500","XOM","BP","CVX","COP"]
[{"$nulls":7},"Alpha"]
[{"$nulls":7},"Beta"]
[{"$nulls":7},"R-squared"]
[]
[{"$nulls":7},"Portfolio and regression"]
[{"$nulls":7},"Alpha"]
[{"$nulls":7},"Beta"]
[{"$nulls":7},"R-squared"]
[]
[{"$nulls":7},"Weighted-average alpha, beta, r-squared"]
[{"$nulls":7},"Alpha"]
[{"$nulls":7},"Beta"]
[{"$nulls":7},"R-squared"]
[]
[{"$nulls":7},"Portfolio",null,{"v":0.25,"d":"25.00%"},{"v":0.25,"d":"25.00%"},{"v":0.25,"d":"25.00%"},{"v":0.25,"d":"25.00%"}]
[]
["Stock prices",{"$nulls":6},"Stock and portfolio returns"]
["Date","S&P500\nVFINX","Exxon Mobile\nXOM","British Petroleum\nBP","Chevron\nCVX","Conoco\nPhillips\nCOP",null,"Date","S&P500\nVFINX","Exxon Mobile\nXOM","British Petroleum\nBP","Chevron\nCVX","Conoco\nPhillips\nCOP","Portfolio"]
["2009-11-02",91.98,46.69,45.06,8.24,44.68,null,"2009-11-02"]
["2009-12-01",93.77,48.23,{"v":45.6,"d":"45.60"},9.26,46.99,null,"2009-12-01",{"v":0.019460752337464582,"d":"1.95%"},{"v":0.03298350824587715,"d":"3.30%"},{"v":0.011984021304926706,"d":"1.20%"},{"v":0.12378640776699035,"d":"12.38%"},{"v":0.05170098478066265,"d":"5.17%"}]
["2010-01-04",90.39,53.99,46.64,10.04,42.94,null,"2010-01-04",{"v":-0.036045643596032795,"d":"-3.60%"},{"v":0.11942774206925155,"d":"11.94%"},{"v":0.02280701754385972,"d":"2.28%"},{"v":0.08423326133909281,"d":"8.42%"},{"v":-0.08618855075547993,"d":"-8.62%"}]
["2010-02-01",93.19,56.66,45.02,10.88,46.33,null,"2010-02-01",{"v":0.030976877973227124,"d":"3.10%"},{"v":0.049453602518984896,"d":"4.95%"},{"v":-0.03473413379073753,"d":"-3.47%"},{"v":0.08366533864541847,"d":"8.37%"},{"v":0.07894736842105265,"d":"7.89%"}]
["2010-03-01",98.79,65.13,46.12,11.64,48.56,null,"2010-03-01",{"v":0.060092284579890576,"d":"6.01%"},{"v":0.14948817507942103,"d":"14.95%"},{"v":0.024433585073300623,"d":"2.44%"},{"v":0.06985294117647056,"d":"6.99%"},{"v":0.04813295920569827,"d":"4.81%"}]
["2010-04-01",100.35,64.97,47.43,12.06,47.48,null,"2010-04-01",{"v":0.01579107197084717,"d":"1.58%"},{"v":-2.4566252111162257E-3,"d":"-0.25%"},{"v":0.028404163052905496,"d":"2.84%"},{"v":0.03608247422680422,"d":"3.61%"},{"v":-0.02224052718286662,"d":"-2.22%"}]
["2010-05-03",92.33,57.91,46.45,10.87,42.03,null,"2010-05-03",{"v":-0.07992027902341803,"d":"-7.99%"},{"v":-0.10866553794058798,"d":"-10.87%"},{"v":-0.020662028252161013,"d":"-2.07%"},{"v":-0.09867330016583753,"d":"-9.87%"},{"v":-0.11478517270429645,"d":"-11.48%"}]
["2010-06-01",87.48,56.61,43.73,9.34,39.61,null,"2010-06-01",{"v":-0.05252897216506003,"d":"-5.25%"},{"v":-0.022448627180106984,"d":"-2.24%"},{"v":-0.05855758880516693,"d":"-5.86%"},{"v":-0.14075436982520695,"d":"-14.08%"},{"v":-0.05757792053295274,"d":"-5.76%"}]
["2010-07-01",{"v":93.6,"d":"93.60"},61.48,43.51,11.83,42.13,null,"2010-07-01",{"v":0.06995884773662531,"d":"7.00%"},{"v":0.08602720367426242,"d":"8.60%"},{"v":-5.030871255431002E-3,"d":"-0.50%"},{"v":0.26659528907922914,"d":"26.66%"},{"v":0.06362029790456969,"d":"6.36%"},null,"S"]
["2010-08-02",89.36,55.49,43.54,10.46,35.19,null,"2010-08-02",{"v":-0.04529914529914525,"d":"-4.53%"},{"v":-0.09743005855562781,"d":"-9.74%"},{"v":6.8949666743289839E-4,"d":"0.07%"},{"v":-0.11580726965342347,"d":"-11.58%"},{"v":-0.16472822216947558,"d":"-16.47%"}]
["2010-09-01",97.33,{"v":60.4,"d":"60.40"},44.27,11.34,38.58,null,"2010-09-01",{"v":0.089189794091316,"d":"8.92%"},{"v":0.08848441160569465,"d":"8.85%"},{"v":0.016766192007349634,"d":"1.68%"},{"v":0.08413001912045881,"d":"8.41%"},{"v":0.09633418584825226,"d":"9.63%"}]
["2010-10-01",101.01,64.12,44.05,13.09,38.55,null,"2010-10-01",{"v":0.037809514024452984,"d":"3.78%"},{"v":0.06158940397351009,"d":"6.16%"},{"v":-0.004969505308335398,"d":"-0.50%"},{"v":0.154320987654321,"d":"15.43%"},{"v":-7.7760497667189732E-4,"d":"-0.08%"}]
["2010-11-01",101.01,58.24,{"v":43.5,"d":"43.50"},14.77,38.45,null,"2010-11-01",{"v":0,"d":"0.00%"},{"v":-0.09170305676855894,"d":"-9.17%"},{"v":-0.012485811577752526,"d":"-1.25%"},{"v":0.12834224598930488,"d":"12.83%"},{"v":-2.5940337224382715E-3,"d":"-0.26%"}]
["2010-12-01",107.75,{"v":59.6,"d":"59.60"},45.14,15.55,38.68,null,"2010-12-01",{"v":0.06672606672606674,"d":"6.67%"},{"v":0.02335164835164827,"d":"2.34%"},{"v":0.03770114942528746,"d":"3.77%"},{"v":0.05280974949221395,"d":"5.28%"},{"v":0.00598179453836134,"d":"0.60%"}]
["2011-01-03",110.29,63.45,44.45,14.78,41.98,null,"2011-01-03",{"v":0.023573085846867903,"d":"2.36%"},{"v":0.06459731543624159,"d":"6.46%"},{"v":-0.015285777580859472,"d":"-1.53%"},{"v":-0.04951768488745989,"d":"-4.95%"},{"v":0.08531540847983443,"d":"8.53%"}]
["2011-02-01",114.06,66.14,47.69,13.94,40.09,null,"2011-02-01",{"v":0.034182609484087356,"d":"3.42%"},{"v":0.04239558707643809,"d":"4.24%"},{"v":0.07289088863892013,"d":"7.29%"},{"v":-0.05683355886332886,"d":"-5.68%"},{"v":-0.04502143878037146,"d":"-4.50%"}]
["2011-03-01",114.09,67.91,48.07,13.81,37.71,null,"2011-03-01",{"v":2.6301946344031712E-4,"d":"0.03%"},{"v":0.026761415179921366,"d":"2.68%"},{"v":0.007968127490039834,"d":"0.80%"},{"v":-0.009325681492108995,"d":"-0.93%"},{"v":-0.059366425542529355,"d":"-5.94%"}]
["2011-04-01",117.46,73.28,{"v":51,"d":"51.00"},14.33,37.16,null,"2011-04-01",{"v":0.029538083968796425,"d":"2.95%"},{"v":0.079075246649978,"d":"7.91%"},{"v":0.06095277719991676,"d":"6.10%"},{"v":0.03765387400434461,"d":"3.77%"},{"v":-0.014584990718642388,"d":"-1.46%"}]
["2011-05-02",116.11,72.05,51.11,13.82,34.41,null,"2011-05-02",{"v":-0.011493274306146772,"d":"-1.15%"},{"v":-0.016784934497816595,"d":"-1.68%"},{"v":2.156862745098076E-3,"d":"0.22%"},{"v":-0.03558967201674812,"d":"-3.56%"},{"v":-0.07400430570505923,"d":"-7.40%"}]
["2011-06-01",114.17,68.26,49.61,12.77,33.62,null,"2011-06-01",{"v":-0.016708293859271306,"d":"-1.67%"},{"v":-0.0526023594725884,"d":"-5.26%"},{"v":-0.029348464097045612,"d":"-2.93%"},{"v":-0.07597684515195369,"d":"-7.60%"},{"v":-0.022958442313281036,"d":"-2.30%"}]
["2011-07-01",111.83,65.07,50.03,11.31,32.49,null,"2011-07-01",{"v":-0.02049575194884823,"d":"-2.05%"},{"v":-0.04673307940228555,"d":"-4.67%"},{"v":0.008466035073573908,"d":"0.85%"},{"v":-0.11433046202036012,"d":"-11.43%"},{"v":-0.03361094586555613,"d":"-3.36%"}]
["2011-08-01",105.74,62.15,49.11,{"v":10.3,"d":"10.30"},24.04,null,"2011-08-01",{"v":-0.05445765894661547,"d":"-5.45%"},{"v":-0.044874750268941055,"d":"-4.49%"},{"v":-0.01838896662002798,"d":"-1.84%"},{"v":-0.0893015030946065,"d":"-8.93%"},{"v":-0.260080024622961,"d":"-26.01%"}]
["2011-09-01",98.28,56.25,48.09,8.96,20.85,null,"2011-09-01",{"v":-0.07055040665783996,"d":"-7.06%"},{"v":-0.09493161705551079,"d":"-9.49%"},{"v":-0.020769700671960822,"d":"-2.08%"},{"v":-0.13009708737864079,"d":"-13.01%"},{"v":-0.13269550748752068,"d":"-13.27%"}]
["2011-10-03",{"v":109,"d":"109.00"},61.16,49.01,10.82,24.71,null,"2011-10-03",{"v":0.10907610907610898,"d":"10.91%"},{"v":0.08728888888888875,"d":"8.73%"},{"v":0.019130796423372676,"d":"1.91%"},{"v":0.2075892857142856,"d":"20.76%"},{"v":0.18513189448441247,"d":"18.51%"}]
["2011-11-01",108.75,64.26,44.84,9.82,25.95,null,"2011-11-01",{"v":-0.002293577981651418,"d":"-0.23%"},{"v":0.05068672334859392,"d":"5.07%"},{"v":-0.08508467659661278,"d":"-8.51%"},{"v":-0.09242144177449163,"d":"-9.24%"},{"v":0.05018211250505855,"d":"5.02%"}]
["2011-12-01",109.86,68.62,46.13,9.97,24.02,null,"2011-12-01",{"v":0.010206896551724132,"d":"1.02%"},{"v":0.06784936196700908,"d":"6.78%"},{"v":0.028768956289027647,"d":"2.88%"},{"v":0.015274949083503131,"d":"1.53%"},{"v":-0.07437379576107894,"d":"-7.44%"}]
["2012-01-03",114.76,{"v":69.4,"d":"69.40"},45.17,11.55,26.09,null,"2012-01-03",{"v":0.044602221008556375,"d":"4.46%"},{"v":0.011366948411541733,"d":"1.14%"},{"v":-0.020810752221981366,"d":"-2.08%"},{"v":0.1584754262788366,"d":"15.85%"},{"v":0.08617818484596174,"d":"8.62%"}]
["2012-02-01",119.71,70.53,48.14,11.51,{"v":23.6,"d":"23.60"},null,"2012-02-01",{"v":0.04313349599163452,"d":"4.31%"},{"v":0.016282420749279547,"d":"1.63%"},{"v":0.06575160504759792,"d":"6.58%"},{"v":-3.4632034632035014E-3,"d":"-0.35%"},{"v":-0.09543886546569558,"d":"-9.54%"}]
["2012-03-01",123.64,69.99,49.32,11.61,22.33,null,"2012-03-01",{"v":0.03282933756578399,"d":"3.28%"},{"v":-0.007656316461080448,"d":"-0.77%"},{"v":0.02451184046530952,"d":"2.45%"},{"v":0.008688097306689846,"d":"0.87%"},{"v":-0.05381355932203402,"d":"-5.38%"}]
["2012-04-02",122.85,72.27,{"v":46.5,"d":"46.50"},10.54,23.21,null,"2012-04-02",{"v":-0.006389517955354251,"d":"-0.64%"},{"v":0.032576082297471,"d":"3.26%"},{"v":-0.05717761557177614,"d":"-5.72%"},{"v":-0.09216192937123169,"d":"-9.22%"},{"v":0.039408866995074066,"d":"3.94%"}]
["2012-05-01",115.45,65.89,45.24,9.86,21.26,null,"2012-05-01",{"v":-0.06023606023606021,"d":"-6.02%"},{"v":-0.0882800608828006,"d":"-8.83%"},{"v":-0.02709677419354839,"d":"-2.71%"},{"v":-0.06451612903225801,"d":"-6.45%"},{"v":-0.08401551055579493,"d":"-8.40%"}]
["2012-06-01",{"v":120.2,"d":"120.20"},70.33,45.75,8.96,18.96,null,"2012-06-01",{"v":0.04114335210047648,"d":"4.11%"},{"v":0.06738503566550302,"d":"6.74%"},{"v":0.011273209549071517,"d":"1.13%"},{"v":-0.09127789046653134,"d":"-9.13%"},{"v":-0.10818438381937912,"d":"-10.82%"}]
["2012-07-02",121.85,69.96,44.24,8.63,{"v":17.2,"d":"17.20"},null,"2012-07-02",{"v":0.013727121464226277,"d":"1.37%"},{"v":-0.005260912839471166,"d":"-0.53%"},{"v":-0.03300546448087427,"d":"-3.30%"},{"v":-0.036830357142857095,"d":"-3.68%"},{"v":-0.09282700421940937,"d":"-9.28%"}]
["2012-08-01",124.58,67.99,47.38,8.77,15.91,null,"2012-08-01",{"v":0.02240459581452603,"d":"2.24%"},{"v":-0.028158947970268744,"d":"-2.82%"},{"v":0.07097649186256771,"d":"7.10%"},{"v":0.016222479721900163,"d":"1.62%"},{"v":-0.07499999999999996,"d":"-7.50%"}]
["2012-09-04",127.79,66.28,48.33,9.26,16.21,null,"2012-09-04",{"v":0.02576657569433305,"d":"2.58%"},{"v":-0.02515075746433293,"d":"-2.52%"},{"v":0.02005065428450803,"d":"2.01%"},{"v":0.05587229190421894,"d":"5.59%"},{"v":0.018856065367693242,"d":"1.89%"}]
["2012-10-01",125.41,67.08,48.94,10.53,13.16,null,"2012-10-01",{"v":-0.018624305501212968,"d":"-1.86%"},{"v":0.012070006035002967,"d":"1.21%"},{"v":0.012621560107593632,"d":"1.26%"},{"v":0.13714902807775364,"d":"13.71%"},{"v":-0.18815545959284397,"d":"-18.82%"}]
["2012-11-01",126.11,71.17,52.29,{"v":10.8,"d":"10.80"},12.34,null,"2012-11-01",{"v":0.005581692050075748,"d":"0.56%"},{"v":0.060971973762671494,"d":"6.10%"},{"v":0.06845116469145895,"d":"6.85%"},{"v":0.025641025641025772,"d":"2.56%"},{"v":-0.06231003039513683,"d":"-6.23%"}]
["2012-12-03",127.24,{"v":72.2,"d":"72.20"},52.66,12.22,13.67,null,"2012-12-03",{"v":0.008960431369439359,"d":"0.90%"},{"v":0.014472390051988304,"d":"1.45%"},{"v":0.00707592273857327,"d":"0.71%"},{"v":0.13148148148148153,"d":"13.15%"},{"v":0.10777957860615883,"d":"10.78%"}]
["2013-01-02",133.83,70.78,55.16,12.31,15.83,null,"2013-01-02",{"v":0.05179188934297407,"d":"5.18%"},{"v":-0.0196675900277008,"d":"-1.97%"},{"v":0.047474363843524436,"d":"4.75%"},{"v":7.3649754500817455E-3,"d":"0.74%"},{"v":0.15801024140453546,"d":"15.80%"}]
["2013-02-01",135.62,74.15,57.47,11.99,19.32,null,"2013-02-01",{"v":0.013375177463946786,"d":"1.34%"},{"v":0.047612319864368535,"d":"4.76%"},{"v":0.04187817258883264,"d":"4.19%"},{"v":-0.025995125913891193,"d":"-2.60%"},{"v":0.2204674668351232,"d":"22.05%"}]
["2013-03-01",140.69,82.78,{"v":61.2,"d":"61.20"},{"v":12.5,"d":"12.50"},23.01,null,"2013-03-01",{"v":0.037383866686329315,"d":"3.74%"},{"v":0.11638570465273079,"d":"11.64%"},{"v":0.06490342787541326,"d":"6.49%"},{"v":0.042535446205171024,"d":"4.25%"},{"v":0.19099378881987583,"d":"19.10%"}]
["2013-04-01",143.37,88.14,61.78,13.03,19.88,null,"2013-04-01",{"v":0.01904897291918406,"d":"1.90%"},{"v":0.06474993959893682,"d":"6.47%"},{"v":0.009477124183006502,"d":"0.95%"},{"v":0.04239999999999999,"d":"4.24%"},{"v":-0.13602781399391584,"d":"-13.60%"}]
["2013-05-01",146.71,95.97,59.35,15.01,23.57,null,"2013-05-01",{"v":0.023296366045895356,"d":"2.33%"},{"v":0.0888359428182437,"d":"8.88%"},{"v":-0.03933311751375845,"d":"-3.93%"},{"v":0.15195702225633156,"d":"15.20%"},{"v":0.18561368209255535,"d":"18.56%"}]
["2013-06-03",144.73,99.29,61.43,14.81,24.08,null,"2013-06-03",{"v":-0.013496012541749147,"d":"-1.35%"},{"v":0.03459414400333438,"d":"3.46%"},{"v":0.035046335299073306,"d":"3.50%"},{"v":-0.01332445036642238,"d":"-1.33%"},{"v":0.02163767501060665,"d":"2.16%"}]
["2013-07-01",152.07,101.87,63.36,16.26,24.93,null,"2013-07-01",{"v":0.050715124714986626,"d":"5.07%"},{"v":0.02598448987813473,"d":"2.60%"},{"v":0.03141787400293006,"d":"3.14%"},{"v":0.09790681971640791,"d":"9.79%"},{"v":0.035299003322259104,"d":"3.53%"}]
["2013-08-01",147.64,101.18,58.51,15.59,21.69,null,"2013-08-01",{"v":-0.02913132110212402,"d":"-2.91%"},{"v":-6.7733385687640535E-3,"d":"-0.68%"},{"v":-0.07654671717171724,"d":"-7.65%"},{"v":-0.04120541205412065,"d":"-4.12%"},{"v":-0.12996389891696747,"d":"-13.00%"}]
["2013-09-03",152.24,{"v":114.4,"d":"114.40"},{"v":56.6,"d":"56.60"},16.25,20.51,null,"2013-09-03",{"v":0.031156868057437226,"d":"3.12%"},{"v":0.13065823285234224,"d":"13.07%"},{"v":-0.032643992479917894,"d":"-3.26%"},{"v":0.04233483001924321,"d":"4.23%"},{"v":-0.05440295066851086,"d":"-5.44%"}]
["2013-10-01",159.23,127.06,60.95,16.57,23.81,null,"2013-10-01",{"v":0.045914345769836995,"d":"4.59%"},{"v":0.11066433566433553,"d":"11.07%"},{"v":0.07685512367491176,"d":"7.69%"},{"v":0.019692307692307676,"d":"1.97%"},{"v":0.16089712335446116,"d":"16.09%"}]
["2013-11-01",164.05,131.19,58.88,16.55,26.73,null,"2013-11-01",{"v":0.0302706776361239,"d":"3.03%"},{"v":0.032504328663623516,"d":"3.25%"},{"v":-0.03396226415094339,"d":"-3.40%"},{"v":-0.001207000603500319,"d":"-0.12%"},{"v":0.12263754724905507,"d":"12.26%"}]
["2013-12-02",168.18,133.38,{"v":59.3,"d":"59.30"},14.95,27.48,null,"2013-12-02",{"v":0.025175251447729252,"d":"2.52%"},{"v":0.01669334552938495,"d":"1.67%"},{"v":0.00713315217391286,"d":"0.71%"},{"v":-0.09667673716012093,"d":"-9.67%"},{"v":0.02805836139169471,"d":"2.81%"}]
["2014-01-02",162.34,{"v":122.4,"d":"122.40"},{"v":56.3,"d":"56.30"},14.61,28.49,null,"2014-01-02",{"v":-0.03472469972648351,"d":"-3.47%"},{"v":-0.08232118758434537,"d":"-8.23%"},{"v":-0.050590219224283306,"d":"-5.06%"},{"v":-0.022742474916387923,"d":"-2.27%"},{"v":0.03675400291120812,"d":"3.68%"}]
["2014-02-03",169.75,126.69,58.93,15.03,29.35,null,"2014-02-03",{"v":0.04564494271282493,"d":"4.56%"},{"v":0.03504901960784301,"d":"3.50%"},{"v":0.04671403197158086,"d":"4.67%"},{"v":0.028747433264887157,"d":"2.87%"},{"v":0.030186030186030388,"d":"3.02%"}]
["2014-03-03",171.14,123.32,61.35,15.23,31.94,null,"2014-03-03",{"v":0.008188512518409352,"d":"0.82%"},{"v":-0.02660036309100955,"d":"-2.66%"},{"v":0.041065671135245285,"d":"4.11%"},{"v":0.01330671989354637,"d":"1.33%"},{"v":0.08824531516183987,"d":"8.82%"}]
["2014-04-01",172.38,126.79,65.38,15.89,32.63,null,"2014-04-01",{"v":0.007245529975458798,"d":"0.72%"},{"v":0.028138177100227146,"d":"2.81%"},{"v":0.06568867155664204,"d":"6.57%"},{"v":0.0433355219960605,"d":"4.33%"},{"v":0.02160300563556672,"d":"2.16%"}]
["2014-05-01",176.41,133.66,67.95,16.18,33.07,null,"2014-05-01",{"v":0.02337858220211153,"d":"2.34%"},{"v":0.054184083918290105,"d":"5.42%"},{"v":0.039308657081676524,"d":"3.93%"},{"v":0.018250471994965434,"d":"1.83%"},{"v":0.013484523444682761,"d":"1.35%"}]
["2014-06-02",180.03,125.73,64.72,16.97,{"v":33.4,"d":"33.40"},null,"2014-06-02",{"v":0.020520378663341,"d":"2.05%"},{"v":-0.059329642376178326,"d":"-5.93%"},{"v":-0.047534952170713796,"d":"-4.75%"},{"v":0.048825710754017315,"d":"4.88%"},{"v":0.009978832778953617,"d":"1.00%"}]
["2014-07-01",177.53,119.06,58.93,16.87,35.31,null,"2014-07-01",{"v":-0.013886574459812229,"d":"-1.39%"},{"v":-0.053050186908454644,"d":"-5.31%"},{"v":-0.08946229913473425,"d":"-8.95%"},{"v":-5.8927519151442675E-3,"d":"-0.59%"},{"v":0.05718562874251498,"d":"5.72%"}]
["2014-08-01",184.61,126.06,64.48,17.26,37.69,null,"2014-08-01",{"v":0.039880583563341565,"d":"3.99%"},{"v":0.05879388543591468,"d":"5.88%"},{"v":0.09417953504157484,"d":"9.42%"},{"v":0.023117960877297117,"d":"2.31%"},{"v":0.0674030019824412,"d":"6.74%"}]
["2014-09-02",181.99,126.64,61.14,14.66,35.33,null,"2014-09-02",{"v":-0.014192080602350887,"d":"-1.42%"},{"v":0.004600983658575197,"d":"0.46%"},{"v":-0.051799007444168765,"d":"-5.18%"},{"v":-0.15063731170336048,"d":"-15.06%"},{"v":-0.0626160785354205,"d":"-6.26%"}]
["2014-10-01",{"v":186.4,"d":"186.40"},124.19,63.48,14.09,35.73,null,"2014-10-01",{"v":0.02423210066487158,"d":"2.42%"},{"v":-0.019346178142766957,"d":"-1.93%"},{"v":0.038272816486751626,"d":"3.83%"},{"v":-0.038881309686221055,"d":"-3.89%"},{"v":0.011321822813472826,"d":"1.13%"}]
["2014-11-03",{"v":191.4,"d":"191.40"},134.36,66.25,15.73,{"v":38.9,"d":"38.90"},null,"2014-11-03",{"v":0.02682403433476388,"d":"2.68%"},{"v":0.08189065142120966,"d":"8.19%"},{"v":0.04363579080025204,"d":"4.36%"},{"v":0.11639460610361962,"d":"11.64%"},{"v":0.08872096277637853,"d":"8.87%"}]
["2014-12-01",{"v":190.1,"d":"190.10"},132.39,66.09,15.77,{"v":38.4,"d":"38.40"},null,"2014-12-01",{"v":-0.006792058516196464,"d":"-0.68%"},{"v":-0.014662101816016904,"d":"-1.47%"},{"v":-2.4150943396226143E-3,"d":"-0.24%"},{"v":0.002542911633820699,"d":"0.25%"},{"v":-0.01285347043701801,"d":"-1.29%"}]

{"sheet":"EoC Exercise 1c Template","index":3,"n_rows":83,"n_cols":15,"rows_kept":83,"merged":[[0,0,0,12],[1,7,1,12],[7,7,7,12],[12,7,12,12],[19,0,19,5],[19,7,19,14]]}
["4 STOCKS AND THE SP500"]
[{"$nulls":7},"Regression results:  individual stocks"]
[{"$nulls":8},"SP500","XOM","BP","CVX","COP"]
[{"$nulls":7},"Alpha",null,{"v":0.005853255755563239,"d":"0.0059"},{"v":9.1067012724304047E-4,"d":"0.0009"},{"v":-3.7566251822360435E-3,"d":"-0.0038"},{"v":-0.01700571018236598,"d":"-0.0170"}]
[null,"XOM","BP","CVX","COP",null,null,"Beta",null,{"v":1.0417434963862784,"d":"1.0417"},{"v":0.4970857813724629,"d":"0.4971"},{"v":1.4412202333555308,"d":"1.4412"},{"v":1.5318254774045552,"d":"1.5318"}]
["Market cap",372.24,131.13,205.05,83.05,null,null,"R-squared",null,{"v":0.407712432871932,"d":"0.4077"},{"v":0.18728368335276183,"d":"0.1873"},{"v":0.3651258330408634,"d":"0.3651"},{"v":0.33349506523664096,"d":"0.3335"}]
[]
[{"$nulls":7},"Portfolio and regression"]
[{"$nulls":7},"Alpha"]
[{"$nulls":7},"Beta"]
[{"$nulls":7},"R-squared"]
[]
[{"$nulls":7},"Weighted-average alpha, beta, r-squared"]
[{"$nulls":7},"Alpha"]
[{"$nulls":7},"Beta"]
[{"$nulls":7},"R-squared"]
[]
[{"$nulls":7},"Portfolio"]
[]
["Stock prices",{"$nulls":6},"Stock and portfolio returns"]
["Date","S&P500\nVFINX","Exxon Mobile\nXOM","British Petroleum\nBP","Chevron\nCVX","Conoco\nPhillips\nCOP",null,"Date","S&P500\nVFINX","Exxon Mobile\nXOM","British Petroleum\nBP","Chevron\nCVX","Conoco\nPhillips\nCOP","Portfolio"]
["2009-11-02",91.98,46.69,45.06,8.24,44.68,null,"2009-11-02"]
["2009-12-01",93.77,48.23,{"v":45.6,"d":"45.60"},9.26,46.99,null,"2009-12-01",{"v":0.019460752337464582,"d":"1.95%"},{"v":0.03298350824587715,"d":"3.30%"},{"v":0.011984021304926706,"d":"1.20%"},{"v":0.12378640776699035,"d":"12.38%"},{"v":0.05170098478066265,"d":"5.17%"},{"v":0,"d":"0.00%"},{"$error":"#VALUE!"}]
["2010-01-04",90.39,53.99,46.64,10.04,42.94,null,"2010-01-04",{"v":-0.036045643596032795,"d":"-3.60%"},{"v":0.11942774206925155,"d":"11.94%"},{"v":0.02280701754385972,"d":"2.28%"},{"v":0.08423326133909281,"d":"8.42%"},{"v":-0.08618855075547993,"d":"-8.62%"},{"v":0,"d":"0.00%"},{"$error":"#VALUE!"}]
["2010-02-01",93.19,56.66,45.02,10.88,46.33,null,"2010-02-01",{"v":0.030976877973227124,"d":"3.10%"},{"v":0.049453602518984896,"d":"4.95%"},{"v":-0.03473413379073753,"d":"-3.47%"},{"v":0.08366533864541847,"d":"8.37%"},{"v":0.07894736842105265,"d":"7.89%"},{"v":0,"d":"0.00%"},{"$error":"#VALUE!"}]
["2010-03-01",98.79,65.13,46.12,11.64,48.56,null,"2010-03-01",{"v":0.060092284579890576,"d":"6.01%"},{"v":0.14948817507942103,"d":"14.95%"},{"v":0.024433585073300623,"d":"2.44%"},{"v":0.06985294117647056,"d":"6.99%"},{"v":0.04813295920569827,"d":"4.81%"},{"v":0,"d":"0.00%"},{"$error":"#VALUE!"}]
["2010-04-01",100.35,64.97,47.43,12.06,47.48,null,"2010-04-01",{"v":0.01579107197084717,"d":"1.58%"},{"v":-2.4566252111162257E-3,"d":"-0.25%"},{"v":0.028404163052905496,"d":"2.84%"},{"v":0.03608247422680422,"d":"3.61%"},{"v":-0.02224052718286662,"d":"-2.22%"},{"v":0,"d":"0.00%"},{"$error":"#VALUE!"}]
["2010-05-03",92.33,57.91,46.45,10.87,42.03,null,"2010-05-03",{"v":-0.07992027902341803,"d":"-7.99%"},{"v":-0.10866553794058798,"d":"-10.87%"},{"v":-0.020662028252161013,"d":"-2.07%"},{"v":-0.09867330016583753,"d":"-9.87%"},{"v":-0.11478517270429645,"d":"-11.48%"},{"v":0,"d":"0.00%"}]
["2010-06-01",87.48,56.61,43.73,9.34,39.61,null,"2010-06-01",{"v":-0.05252897216506003,"d":"-5.25%"},{"v":-0.022448627180106984,"d":"-2.24%"},{"v":-0.05855758880516693,"d":"-5.86%"},{"v":-0.14075436982520695,"d":"-14.08%"},{"v":-0.05757792053295274,"d":"-5.76%"},{"v":0,"d":"0.00%"}]
["2010-07-01",{"v":93.6,"d":"93.60"},61.48,43.51,11.83,42.13,null,"2010-07-01",{"v":0.06995884773662531,"d":"7.00%"},{"v":0.08602720367426242,"d":"8.60%"},{"v":-5.030871255431002E-3,"d":"-0.50%"},{"v":0.26659528907922914,"d":"26.66%"},{"v":0.06362029790456969,"d":"6.36%"},{"v":0,"d":"0.00%"}]
["2010-08-02",89.36,55.49,43.54,10.46,35.19,null,"2010-08-02",{"v":-0.04529914529914525,"d":"-4.53%"},{"v":-0.09743005855562781,"d":"-9.74%"},{"v":6.8949666743289839E-4,"d":"0.07%"},{"v":-0.11580726965342347,"d":"-11.58%"},{"v":-0.16472822216947558,"d":"-16.47%"},{"v":0,"d":"0.00%"}]
["2010-09-01",97.33,{"v":60.4,"d":"60.40"},44.27,11.34,38.58,null,"2010-09-01",{"v":0.089189794091316,"d":"8.92%"},{"v":0.08848441160569465,"d":"8.85%"},{"v":0.016766192007349634,"d":"1.68%"},{"v":0.08413001912045881,"d":"8.41%"},{"v":0.09633418584825226,"d":"9.63%"},{"v":0,"d":"0.00%"}]
["2010-10-01",101.01,64.12,44.05,13.09,38.55,null,"2010-10-01",{"v":0.037809514024452984,"d":"3.78%"},{"v":0.06158940397351009,"d":"6.16%"},{"v":-0.004969505308335398,"d":"-0.50%"},{"v":0.154320987654321,"d":"15.43%"},{"v":-7.7760497667189732E-4,"d":"-0.08%"},{"v":0,"d":"0.00%"}]
["2010-11-01",101.01,58.24,{"v":43.5,"d":"43.50"},14.77,38.45,null,"2010-11-01",{"v":0,"d":"0.00%"},{"v":-0.09170305676855894,"d":"-9.17%"},{"v":-0.012485811577752526,"d":"-1.25%"},{"v":0.12834224598930488,"d":"12.83%"},{"v":-2.5940337224382715E-3,"d":"-0.26%"},{"v":0,"d":"0.00%"}]
["2010-12-01",107.75,{"v":59.6,"d":"59.60"},45.14,15.55,38.68,null,"2010-12-01",{"v":0.06672606672606674,"d":"6.67%"},{"v":0.02335164835164827,"d":"2.34%"},{"v":0.03770114942528746,"d":"3.77%"},{"v":0.05280974949221395,"d":"5.28%"},{"v":0.00598179453836134,"d":"0.60%"},{"v":0,"d":"0.00%"}]
["2011-01-03",110.29,63.45,44.45,14.78,41.98,null,"2011-01-03",{"v":0.023573085846867903,"d":"2.36%"},{"v":0.06459731543624159,"d":"6.46%"},{"v":-0.015285777580859472,"d":"-1.53%"},{"v":-0.04951768488745989,"d":"-4.95%"},{"v":0.08531540847983443,"d":"8.53%"},{"v":0,"d":"0.00%"}]
["2011-02-01",114.06,66.14,47.69,13.94,40.09,null,"2011-02-01",{"v":0.034182609484087356,"d":"3.42%"},{"v":0.04239558707643809,"d":"4.24%"},{"v":0.07289088863892013,"d":"7.29%"},{"v":-0.05683355886332886,"d":"-5.68%"},{"v":-0.04502143878037146,"d":"-4.50%"},{"v":0,"d":"0.00%"}]
["2011-03-01",114.09,67.91,48.07,13.81,37.71,null,"2011-03-01",{"v":2.6301946344031712E-4,"d":"0.03%"},{"v":0.026761415179921366,"d":"2.68%"},{"v":0.007968127490039834,"d":"0.80%"},{"v":-0.009325681492108995,"d":"-0.93%"},{"v":-0.059366425542529355,"d":"-5.94%"},{"v":0,"d":"0.00%"}]
["2011-04-01",117.46,73.28,{"v":51,"d":"51.00"},14.33,37.16,null,"2011-04-01",{"v":0.029538083968796425,"d":"2.95%"},{"v":0.079075246649978,"d":"7.91%"},{"v":0.06095277719991676,"d":"6.10%"},{"v":0.03765387400434461,"d":"3.77%"},{"v":-0.014584990718642388,"d":"-1.46%"},{"v":0,"d":"0.00%"}]
["2011-05-02",116.11,72.05,51.11,13.82,34.41,null,"2011-05-02",{"v":-0.011493274306146772,"d":"-1.15%"},{"v":-0.016784934497816595,"d":"-1.68%"},{"v":2.156862745098076E-3,"d":"0.22%"},{"v":-0.03558967201674812,"d":"-3.56%"},{"v":-0.07400430570505923,"d":"-7.40%"},{"v":0,"d":"0.00%"}]
["2011-06-01",114.17,68.26,49.61,12.77,33.62,null,"2011-06-01",{"v":-0.016708293859271306,"d":"-1.67%"},{"v":-0.0526023594725884,"d":"-5.26%"},{"v":-0.029348464097045612,"d":"-2.93%"},{"v":-0.07597684515195369,"d":"-7.60%"},{"v":-0.022958442313281036,"d":"-2.30%"},{"v":0,"d":"0.00%"}]
["2011-07-01",111.83,65.07,50.03,11.31,32.49,null,"2011-07-01",{"v":-0.02049575194884823,"d":"-2.05%"},{"v":-0.04673307940228555,"d":"-4.67%"},{"v":0.008466035073573908,"d":"0.85%"},{"v":-0.11433046202036012,"d":"-11.43%"},{"v":-0.03361094586555613,"d":"-3.36%"},{"v":0,"d":"0.00%"}]
["2011-08-01",105.74,62.15,49.11,{"v":10.3,"d":"10.30"},24.04,null,"2011-08-01",{"v":-0.05445765894661547,"d":"-5.45%"},{"v":-0.044874750268941055,"d":"-4.49%"},{"v":-0.01838896662002798,"d":"-1.84%"},{"v":-0.0893015030946065,"d":"-8.93%"},{"v":-0.260080024622961,"d":"-26.01%"},{"v":0,"d":"0.00%"}]
["2011-09-01",98.28,56.25,48.09,8.96,20.85,null,"2011-09-01",{"v":-0.07055040665783996,"d":"-7.06%"},{"v":-0.09493161705551079,"d":"-9.49%"},{"v":-0.020769700671960822,"d":"-2.08%"},{"v":-0.13009708737864079,"d":"-13.01%"},{"v":-0.13269550748752068,"d":"-13.27%"},{"v":0,"d":"0.00%"}]
["2011-10-03",{"v":109,"d":"109.00"},61.16,49.01,10.82,24.71,null,"2011-10-03",{"v":0.10907610907610898,"d":"10.91%"},{"v":0.08728888888888875,"d":"8.73%"},{"v":0.019130796423372676,"d":"1.91%"},{"v":0.2075892857142856,"d":"20.76%"},{"v":0.18513189448441247,"d":"18.51%"},{"v":0,"d":"0.00%"}]
["2011-11-01",108.75,64.26,44.84,9.82,25.95,null,"2011-11-01",{"v":-0.002293577981651418,"d":"-0.23%"},{"v":0.05068672334859392,"d":"5.07%"},{"v":-0.08508467659661278,"d":"-8.51%"},{"v":-0.09242144177449163,"d":"-9.24%"},{"v":0.05018211250505855,"d":"5.02%"},{"v":0,"d":"0.00%"}]
["2011-12-01",109.86,68.62,46.13,9.97,24.02,null,"2011-12-01",{"v":0.010206896551724132,"d":"1.02%"},{"v":0.06784936196700908,"d":"6.78%"},{"v":0.028768956289027647,"d":"2.88%"},{"v":0.015274949083503131,"d":"1.53%"},{"v":-0.07437379576107894,"d":"-7.44%"},{"v":0,"d":"0.00%"}]
["2012-01-03",114.76,{"v":69.4,"d":"69.40"},45.17,11.55,26.09,null,"2012-01-03",{"v":0.044602221008556375,"d":"4.46%"},{"v":0.011366948411541733,"d":"1.14%"},{"v":-0.020810752221981366,"d":"-2.08%"},{"v":0.1584754262788366,"d":"15.85%"},{"v":0.08617818484596174,"d":"8.62%"},{"v":0,"d":"0.00%"}]
["2012-02-01",119.71,70.53,48.14,11.51,{"v":23.6,"d":"23.60"},null,"2012-02-01",{"v":0.04313349599163452,"d":"4.31%"},{"v":0.016282420749279547,"d":"1.63%"},{"v":0.06575160504759792,"d":"6.58%"},{"v":-3.4632034632035014E-3,"d":"-0.35%"},{"v":-0.09543886546569558,"d":"-9.54%"},{"v":0,"d":"0.00%"}]
["2012-03-01",123.64,69.99,49.32,11.61,22.33,null,"2012-03-01",{"v":0.03282933756578399,"d":"3.28%"},{"v":-0.007656316461080448,"d":"-0.77%"},{"v":0.02451184046530952,"d":"2.45%"},{"v":0.008688097306689846,"d":"0.87%"},{"v":-0.05381355932203402,"d":"-5.38%"},{"v":0,"d":"0.00%"}]
["2012-04-02",122.85,72.27,{"v":46.5,"d":"46.50"},10.54,23.21,null,"2012-04-02",{"v":-0.006389517955354251,"d":"-0.64%"},{"v":0.032576082297471,"d":"3.26%"},{"v":-0.05717761557177614,"d":"-5.72%"},{"v":-0.09216192937123169,"d":"-9.22%"},{"v":0.039408866995074066,"d":"3.94%"},{"v":0,"d":"0.00%"}]
["2012-05-01",115.45,65.89,45.24,9.86,21.26,null,"2012-05-01",{"v":-0.06023606023606021,"d":"-6.02%"},{"v":-0.0882800608828006,"d":"-8.83%"},{"v":-0.02709677419354839,"d":"-2.71%"},{"v":-0.06451612903225801,"d":"-6.45%"},{"v":-0.08401551055579493,"d":"-8.40%"},{"v":0,"d":"0.00%"}]
["2012-06-01",{"v":120.2,"d":"120.20"},70.33,45.75,8.96,18.96,null,"2012-06-01",{"v":0.04114335210047648,"d":"4.11%"},{"v":0.06738503566550302,"d":"6.74%"},{"v":0.011273209549071517,"d":"1.13%"},{"v":-0.09127789046653134,"d":"-9.13%"},{"v":-0.10818438381937912,"d":"-10.82%"},{"v":0,"d":"0.00%"}]
["2012-07-02",121.85,69.96,44.24,8.63,{"v":17.2,"d":"17.20"},null,"2012-07-02",{"v":0.013727121464226277,"d":"1.37%"},{"v":-0.005260912839471166,"d":"-0.53%"},{"v":-0.03300546448087427,"d":"-3.30%"},{"v":-0.036830357142857095,"d":"-3.68%"},{"v":-0.09282700421940937,"d":"-9.28%"},{"v":0,"d":"0.00%"}]
["2012-08-01",124.58,67.99,47.38,8.77,15.91,null,"2012-08-01",{"v":0.02240459581452603,"d":"2.24%"},{"v":-0.028158947970268744,"d":"-2.82%"},{"v":0.07097649186256771,"d":"7.10%"},{"v":0.016222479721900163,"d":"1.62%"},{"v":-0.07499999999999996,"d":"-7.50%"},{"v":0,"d":"0.00%"}]
["2012-09-04",127.79,66.28,48.33,9.26,16.21,null,"2012-09-04",{"v":0.02576657569433305,"d":"2.58%"},{"v":-0.02515075746433293,"d":"-2.52%"},{"v":0.02005065428450803,"d":"2.01%"},{"v":0.05587229190421894,"d":"5.59%"},{"v":0.018856065367693242,"d":"1.89%"},{"v":0,"d":"0.00%"}]
["2012-10-01",125.41,67.08,48.94,10.53,13.16,null,"2012-10-01",{"v":-0.018624305501212968,"d":"-1.86%"},{"v":0.012070006035002967,"d":"1.21%"},{"v":0.012621560107593632,"d":"1.26%"},{"v":0.13714902807775364,"d":"13.71%"},{"v":-0.18815545959284397,"d":"-18.82%"},{"v":0,"d":"0.00%"}]
["2012-11-01",126.11,71.17,52.29,{"v":10.8,"d":"10.80"},12.34,null,"2012-11-01",{"v":0.005581692050075748,"d":"0.56%"},{"v":0.060971973762671494,"d":"6.10%"},{"v":0.06845116469145895,"d":"6.85%"},{"v":0.025641025641025772,"d":"2.56%"},{"v":-0.06231003039513683,"d":"-6.23%"},{"v":0,"d":"0.00%"}]
["2012-12-03",127.24,{"v":72.2,"d":"72.20"},52.66,12.22,13.67,null,"2012-12-03",{"v":0.008960431369439359,"d":"0.90%"},{"v":0.014472390051988304,"d":"1.45%"},{"v":0.00707592273857327,"d":"0.71%"},{"v":0.13148148148148153,"d":"13.15%"},{"v":0.10777957860615883,"d":"10.78%"},{"v":0,"d":"0.00%"}]
["2013-01-02",133.83,70.78,55.16,12.31,15.83,null,"2013-01-02",{"v":0.05179188934297407,"d":"5.18%"},{"v":-0.0196675900277008,"d":"-1.97%"},{"v":0.047474363843524436,"d":"4.75%"},{"v":7.3649754500817455E-3,"d":"0.74%"},{"v":0.15801024140453546,"d":"15.80%"},{"v":0,"d":"0.00%"}]
["2013-02-01",135.62,74.15,57.47,11.99,19.32,null,"2013-02-01",{"v":0.013375177463946786,"d":"1.34%"},{"v":0.047612319864368535,"d":"4.76%"},{"v":0.04187817258883264,"d":"4.19%"},{"v":-0.025995125913891193,"d":"-2.60%"},{"v":0.2204674668351232,"d":"22.05%"},{"v":0,"d":"0.00%"}]
["2013-03-01",140.69,82.78,{"v":61.2,"d":"61.20"},{"v":12.5,"d":"12.50"},23.01,null,"2013-03-01",{"v":0.037383866686329315,"d":"3.74%"},{"v":0.11638570465273079,"d":"11.64%"},{"v":0.06490342787541326,"d":"6.49%"},{"v":0.042535446205171024,"d":"4.25%"},{"v":0.19099378881987583,"d":"19.10%"},{"v":0,"d":"0.00%"}]
["2013-04-01",143.37,88.14,61.78,13.03,19.88,null,"2013-04-01",{"v":0.01904897291918406,"d":"1.90%"},{"v":0.06474993959893682,"d":"6.47%"},{"v":0.009477124183006502,"d":"0.95%"},{"v":0.04239999999999999,"d":"4.24%"},{"v":-0.13602781399391584,"d":"-13.60%"},{"v":0,"d":"0.00%"}]
["2013-05-01",146.71,95.97,59.35,15.01,23.57,null,"2013-05-01",{"v":0.023296366045895356,"d":"2.33%"},{"v":0.0888359428182437,"d":"8.88%"},{"v":-0.03933311751375845,"d":"-3.93%"},{"v":0.15195702225633156,"d":"15.20%"},{"v":0.18561368209255535,"d":"18.56%"},{"v":0,"d":"0.00%"}]
["2013-06-03",144.73,99.29,61.43,14.81,24.08,null,"2013-06-03",{"v":-0.013496012541749147,"d":"-1.35%"},{"v":0.03459414400333438,"d":"3.46%"},{"v":0.035046335299073306,"d":"3.50%"},{"v":-0.01332445036642238,"d":"-1.33%"},{"v":0.02163767501060665,"d":"2.16%"},{"v":0,"d":"0.00%"}]
["2013-07-01",152.07,101.87,63.36,16.26,24.93,null,"2013-07-01",{"v":0.050715124714986626,"d":"5.07%"},{"v":0.02598448987813473,"d":"2.60%"},{"v":0.03141787400293006,"d":"3.14%"},{"v":0.09790681971640791,"d":"9.79%"},{"v":0.035299003322259104,"d":"3.53%"},{"v":0,"d":"0.00%"}]
["2013-08-01",147.64,101.18,58.51,15.59,21.69,null,"2013-08-01",{"v":-0.02913132110212402,"d":"-2.91%"},{"v":-6.7733385687640535E-3,"d":"-0.68%"},{"v":-0.07654671717171724,"d":"-7.65%"},{"v":-0.04120541205412065,"d":"-4.12%"},{"v":-0.12996389891696747,"d":"-13.00%"},{"v":0,"d":"0.00%"}]
["2013-09-03",152.24,{"v":114.4,"d":"114.40"},{"v":56.6,"d":"56.60"},16.25,20.51,null,"2013-09-03",{"v":0.031156868057437226,"d":"3.12%"},{"v":0.13065823285234224,"d":"13.07%"},{"v":-0.032643992479917894,"d":"-3.26%"},{"v":0.04233483001924321,"d":"4.23%"},{"v":-0.05440295066851086,"d":"-5.44%"},{"v":0,"d":"0.00%"}]
["2013-10-01",159.23,127.06,60.95,16.57,23.81,null,"2013-10-01",{"v":0.045914345769836995,"d":"4.59%"},{"v":0.11066433566433553,"d":"11.07%"},{"v":0.07685512367491176,"d":"7.69%"},{"v":0.019692307692307676,"d":"1.97%"},{"v":0.16089712335446116,"d":"16.09%"},{"v":0,"d":"0.00%"}]
["2013-11-01",164.05,131.19,58.88,16.55,26.73,null,"2013-11-01",{"v":0.0302706776361239,"d":"3.03%"},{"v":0.032504328663623516,"d":"3.25%"},{"v":-0.03396226415094339,"d":"-3.40%"},{"v":-0.001207000603500319,"d":"-0.12%"},{"v":0.12263754724905507,"d":"12.26%"},{"v":0,"d":"0.00%"}]
["2013-12-02",168.18,133.38,{"v":59.3,"d":"59.30"},14.95,27.48,null,"2013-12-02",{"v":0.025175251447729252,"d":"2.52%"},{"v":0.01669334552938495,"d":"1.67%"},{"v":0.00713315217391286,"d":"0.71%"},{"v":-0.09667673716012093,"d":"-9.67%"},{"v":0.02805836139169471,"d":"2.81%"},{"v":0,"d":"0.00%"}]
["2014-01-02",162.34,{"v":122.4,"d":"122.40"},{"v":56.3,"d":"56.30"},14.61,28.49,null,"2014-01-02",{"v":-0.03472469972648351,"d":"-3.47%"},{"v":-0.08232118758434537,"d":"-8.23%"},{"v":-0.050590219224283306,"d":"-5.06%"},{"v":-0.022742474916387923,"d":"-2.27%"},{"v":0.03675400291120812,"d":"3.68%"},{"v":0,"d":"0.00%"}]
["2014-02-03",169.75,126.69,58.93,15.03,29.35,null,"2014-02-03",{"v":0.04564494271282493,"d":"4.56%"},{"v":0.03504901960784301,"d":"3.50%"},{"v":0.04671403197158086,"d":"4.67%"},{"v":0.028747433264887157,"d":"2.87%"},{"v":0.030186030186030388,"d":"3.02%"},{"v":0,"d":"0.00%"}]
["2014-03-03",171.14,123.32,61.35,15.23,31.94,null,"2014-03-03",{"v":0.008188512518409352,"d":"0.82%"},{"v":-0.02660036309100955,"d":"-2.66%"},{"v":0.041065671135245285,"d":"4.11%"},{"v":0.01330671989354637,"d":"1.33%"},{"v":0.08824531516183987,"d":"8.82%"},{"v":0,"d":"0.00%"}]
["2014-04-01",172.38,126.79,65.38,15.89,32.63,null,"2014-04-01",{"v":0.007245529975458798,"d":"0.72%"},{"v":0.028138177100227146,"d":"2.81%"},{"v":0.06568867155664204,"d":"6.57%"},{"v":0.0433355219960605,"d":"4.33%"},{"v":0.02160300563556672,"d":"2.16%"},{"v":0,"d":"0.00%"}]
["2014-05-01",176.41,133.66,67.95,16.18,33.07,null,"2014-05-01",{"v":0.02337858220211153,"d":"2.34%"},{"v":0.054184083918290105,"d":"5.42%"},{"v":0.039308657081676524,"d":"3.93%"},{"v":0.018250471994965434,"d":"1.83%"},{"v":0.013484523444682761,"d":"1.35%"},{"v":0,"d":"0.00%"}]
["2014-06-02",180.03,125.73,64.72,16.97,{"v":33.4,"d":"33.40"},null,"2014-06-02",{"v":0.020520378663341,"d":"2.05%"},{"v":-0.059329642376178326,"d":"-5.93%"},{"v":-0.047534952170713796,"d":"-4.75%"},{"v":0.048825710754017315,"d":"4.88%"},{"v":0.009978832778953617,"d":"1.00%"},{"v":0,"d":"0.00%"}]
["2014-07-01",177.53,119.06,58.93,16.87,35.31,null,"2014-07-01",{"v":-0.013886574459812229,"d":"-1.39%"},{"v":-0.053050186908454644,"d":"-5.31%"},{"v":-0.08946229913473425,"d":"-8.95%"},{"v":-5.8927519151442675E-3,"d":"-0.59%"},{"v":0.05718562874251498,"d":"5.72%"},{"v":0,"d":"0.00%"}]
["2014-08-01",184.61,126.06,64.48,17.26,37.69,null,"2014-08-01",{"v":0.039880583563341565,"d":"3.99%"},{"v":0.05879388543591468,"d":"5.88%"},{"v":0.09417953504157484,"d":"9.42%"},{"v":0.023117960877297117,"d":"2.31%"},{"v":0.0674030019824412,"d":"6.74%"},{"v":0,"d":"0.00%"}]
["2014-09-02",181.99,126.64,61.14,14.66,35.33,null,"2014-09-02",{"v":-0.014192080602350887,"d":"-1.42%"},{"v":0.004600983658575197,"d":"0.46%"},{"v":-0.051799007444168765,"d":"-5.18%"},{"v":-0.15063731170336048,"d":"-15.06%"},{"v":-0.0626160785354205,"d":"-6.26%"},{"v":0,"d":"0.00%"}]
["2014-10-01",{"v":186.4,"d":"186.40"},124.19,63.48,14.09,35.73,null,"2014-10-01",{"v":0.02423210066487158,"d":"2.42%"},{"v":-0.019346178142766957,"d":"-1.93%"},{"v":0.038272816486751626,"d":"3.83%"},{"v":-0.038881309686221055,"d":"-3.89%"},{"v":0.011321822813472826,"d":"1.13%"},{"v":0,"d":"0.00%"}]
["2014-11-03",{"v":191.4,"d":"191.40"},134.36,66.25,15.73,{"v":38.9,"d":"38.90"},null,"2014-11-03",{"v":0.02682403433476388,"d":"2.68%"},{"v":0.08189065142120966,"d":"8.19%"},{"v":0.04363579080025204,"d":"4.36%"},{"v":0.11639460610361962,"d":"11.64%"},{"v":0.08872096277637853,"d":"8.87%"},{"v":0,"d":"0.00%"}]
["2014-12-01",{"v":190.1,"d":"190.10"},132.39,66.09,15.77,{"v":38.4,"d":"38.40"},null,"2014-12-01",{"v":-0.006792058516196464,"d":"-0.68%"},{"v":-0.014662101816016904,"d":"-1.47%"},{"v":-2.4150943396226143E-3,"d":"-0.24%"},{"v":0.002542911633820699,"d":"0.25%"},{"v":-0.01285347043701801,"d":"-1.29%"},{"v":0,"d":"0.00%"}]

{"sheet":"EoC Exercise 2 Template","index":4,"n_rows":79,"n_cols":26,"rows_kept":79,"merged":[[15,0,15,11],[15,13,15,25]]}
[]
[null,null,"Hormel Foods\nHRL","J.M. Smucker\nSJM","Cal-Maine foods\nCALM","J&J Snack Foods\nJJSF","Calavo Growers\nCVGW","McCormick\nMKC","Hershey\nHSY","Tyson\nTSN","Pilgrim's Pride\nPPC","Sanderson Farms\nSAFM",null,null,"S&P500\nVFINX","Hormel Foods\nHRL","J.M. Smucker\nSJM","Cal-Maine foods\nCALM","J&J Snack Foods\nJJSF","Calavo Growers\nCVGW","McCormick\nMKC","Hershey\nHSY","Tyson\nTSN","Pilgrim's Pride\nPPC","Sanderson Farms\nSAFM","Portfolio"]
["Market value",null,13.48,10.21,1.62,2.03,0.72743,8.7,16.85,12.13,8.32,1.89,null,"Alpha"]
["Portfolio weights",null,{"v":0.17746782638643777,"d":"17.75%"},{"v":0.13441739669180489,"d":"13.44%"},{"v":0.02132773581201997,"d":"2.13%"},{"v":0.026725496110123786,"d":"2.67%"},{"v":0.009576811643047954,"d":"0.96%"},{"v":0.11453784047195908,"d":"11.45%"},{"v":0.22183478298304724,"d":"22.18%"},{"v":0.15969471320975448,"d":"15.97%"},{"v":0.10953503824444824,"d":"10.95%"},{"v":0.024882358447356628,"d":"2.49%"},null,"Beta"]
[{"$nulls":13},"R-squared"]
[]
[{"$nulls":13},"Average alpha"]
[{"$nulls":13},"Average beta"]
[{"$nulls":13},"Average r-squared"]
[]
[{"$nulls":13},"Regression of value-weighted portfolio"]
[{"$nulls":13},"Portfolio alpha"]
[{"$nulls":13},"Portfolio beta"]
[{"$nulls":13},"Portfolio r-squared"]
[]
["Stock prices",{"$nulls":12},"Stock returns"]
["Date","S&P500\nVFINX","Hormel Foods\nHRL","J.M. Smucker\nSJM","Cal-Maine foods\nCALM","J&J Snack Foods\nJJSF","Calavo Growers\nCVGW","McCormick\nMKC","Hershey\nHSY","Tyson\nTSN","Pilgrim's Pride\nPPC","Sanderson Farms\nSAFM",null,"Date","S&P500\nVFINX","Hormel Foods\nHRL","J.M. Smucker\nSJM","Cal-Maine foods\nCALM","J&J Snack Foods\nJJSF","Calavo Growers\nCVGW","McCormick\nMKC","Hershey\nHSY","Tyson\nTSN","Pilgrim's Pride\nPPC","Sanderson Farms\nSAFM","Portfolio"]
["2009-11-02",91.98,17.1,52.29,11.96,34.12,15.1,31.67,31.44,11.44,5.98,37.44]
["2009-12-01",93.77,17.52,54.65,14.86,37.88,15.2,32.3,31.81,11.68,8.9,39.29,null,"2009-12-01"]
["2010-01-04",90.39,17.73,53.16,14.31,39.64,14.99,32.45,32.38,13.15,8.87,43.57,null,"2010-01-04"]
["2010-02-01",93.19,18.83,53.13,14.05,40.49,15.82,33.17,35.62,16.26,9.02,45.78,null,"2010-02-01"]
["2010-03-01",98.79,19.25,53.64,14.88,41.31,16.31,34.29,38.36,18.27,10.64,50.13,null,"2010-03-01"]
["2010-04-01",100.35,18.77,54.36,14.82,44.28,15.51,35.62,42.12,18.69,11.66,53.13,null,"2010-04-01"]
["2010-05-03",92.33,18.32,49.49,14.37,42.22,14.28,34.72,42.22,16.81,7.98,51.42,null,"2010-05-03"]
["2010-06-01",87.48,18.64,53.98,14.18,40.11,16.06,34.17,43.24,15.67,6.57,47.57,null,"2010-06-01"]
["2010-07-01",93.6,19.86,55.06,14.03,39.73,18.89,35.64,42.4,16.74,6.85,43.97,null,"2010-07-01"]
["2010-08-02",89.36,19.97,52.78,13.3,35.96,17.56,36.13,42.21,15.7,6.26,40.47,null,"2010-08-02"]
["2010-09-01",97.33,20.64,54.63,12.99,40.06,19.39,38.1,43.22,15.36,5.62,40.71,null,"2010-09-01"]
["2010-10-01",101.01,21.35,58.01,13.02,40.95,19.59,40.31,44.95,14.91,6.1,39.64,null,"2010-10-01"]
["2010-11-01",101.01,22.82,57.44,13.78,43.7,21.15,40.13,42.8,15.21,6.64,41.79,null,"2010-11-01"]
["2010-12-01",107.75,23.83,59.62,14.19,46.2,21.12,42.69,43.12,16.55,7.09,36.96,null,"2010-12-01"]
["2011-01-03",110.29,23.08,56.45,12.84,40.67,21.14,40.55,42.7,15.81,6.98,38.81,null,"2011-01-03"]
["2011-02-01",114.06,25.6,62.95,13.07,42.11,21.27,43.72,48.17,17.94,7.71,39.2,null,"2011-02-01"]
["2011-03-01",114.09,26.02,65.28,13.35,45.2,20.02,43.88,50.04,18.48,7.71,43.53,null,"2011-03-01"]
["2011-04-01",117.46,27.61,68.65,13.29,48.8,19.24,45.33,53.14,19.17,5.88,45.12,null,"2011-04-01"]
["2011-05-02",116.11,27.53,72.92,13.71,49.47,20.28,46.32,51.63,18.36,4.97,41.77,null,"2011-05-02"]
["2011-06-01",114.17,27.98,70.31,14.7,47.98,19.29,45.75,52.67,18.74,5.41,45.45,null,"2011-06-01"]
["2011-07-01",111.83,27.31,71.67,15.55,49.76,18.94,45.15,52.29,16.95,4.8,43.97,null,"2011-07-01"]
["2011-08-01",105.74,26.03,66.76,14.98,48.72,18.32,44.35,54.67,16.9,3.48,37.44,null,"2011-08-01"]
["2011-09-01",98.28,25.47,67.5,14.5,46.37,18.8,42.84,55.22,16.79,4.27,45.53,null,"2011-09-01"]
["2011-10-03",109,27.9,71.32,15.4,49.74,20.68,45.34,53.35,18.67,5.04,47.45,null,"2011-10-03"]
["2011-11-01",108.75,28.51,70.79,15.65,50.06,24.87,45.47,54.1,19.52,5.74,49.34,null,"2011-11-01"]
["2011-12-01",109.86,27.73,72.83,16.9,51.54,24.04,47.37,57.94,20.01,5.76,48.05,null,"2011-12-01"]
["2012-01-03",114.76,27.39,73.4,17.68,49.36,25.47,47.48,57.29,18.07,5.38,48.83,null,"2012-01-03"]
["2012-02-01",119.71,27.1,70.6,17.94,48.53,25.75,47.4,57.29,18.37,6.27,47.32,null,"2012-02-01"]
["2012-03-01",123.64,28.1,76.26,17.83,50.88,25.07,51.14,57.88,18.6,7.46,51.01,null,"2012-03-01"]
["2012-04-02",122.85,27.81,74.64,16.97,54.37,26.85,52.83,63.24,17.73,7.14,49.64,null,"2012-04-02"]
["2012-05-01",115.45,28.62,72.22,16.74,53.41,25.64,53.25,63.46,18.85,8.21,53.02,null,"2012-05-01"]
["2012-06-01",120.2,29.11,71.24,18.41,57.45,23.95,57.3,68.37,18.33,7.15,44.22,null,"2012-06-01"]
["2012-07-02",121.85,26.85,72.44,17.77,56.18,25.26,57.81,68.09,14.61,4.65,35.55,null,"2012-07-02"]
["2012-08-01",124.58,27.62,80.7,19.18,55.5,24.76,58.34,68.53,15.28,5.32,42.68,null,"2012-08-01"]
["2012-09-04",127.79,28.12,81.99,21.45,55.86,23.41,58.91,67.64,15.63,5.11,43.18,null,"2012-09-04"]
["2012-10-01",125.41,28.55,81.33,20.64,55.8,22.11,58.8,65.69,16.4,5.63,44.09,null,"2012-10-01"]
["2012-11-01",126.11,29.98,84.52,22.01,61.28,23.14,61.61,70.32,18.86,7.14,46.68,null,"2012-11-01"]
["2012-12-03",127.24,30.17,82.39,19.26,62.39,24.25,60.95,69.31,19.08,7.24,46.28,null,"2012-12-03"]
["2013-01-02",133.83,33.62,84.68,20.05,66.56,23.96,59.82,76.25,21.76,8.45,49.13,null,"2013-01-02"]
["2013-02-01",135.62,36.35,91.57,19.48,67.61,27.07,64.54,80.4,22.35,8.81,49.54,null,"2013-02-01"]
["2013-03-01",140.69,40.14,95.28,20.47,75.27,27.68,70.57,84.44,24.47,9.19,53.34,null,"2013-03-01"]
["2013-04-01",143.37,40.26,99.19,20.74,73.44,27.27,69.35,86.01,24.28,9.79,59.82,null,"2013-04-01"]
["2013-05-01",146.71,38.85,97.5,21.74,74.3,28.57,66.6,86.37,24.7,11.96,67.58,null,"2013-05-01"]
["2013-06-03",144.73,37.64,99.61,22.6,76.32,26.15,67.83,86.54,25.37,14.94,65.04,null,"2013-06-03"]
["2013-07-01",152.07,41.49,108.66,24.62,78.17,26.12,69.37,91.96,27.28,16.62,69.17,null,"2013-07-01"]
["2013-08-01",147.64,40.59,103.03,22.17,75.46,23.81,65.53,89.58,28.65,15.33,64.27,null,"2013-08-01"]
["2013-09-03",152.24,41.26,101.96,23.36,79.35,29.08,62.68,90.12,27.98,16.78,64.23,null,"2013-09-03"]
["2013-10-01",159.23,42.74,107.95,24.68,84.12,28.55,67.34,96.68,27.38,14.17,62.23,null,"2013-10-01"]
["2013-11-01",164.05,44.28,101.73,26.73,84.46,30.35,67.2,94.88,31.43,16.38,67.28,null,"2013-11-01"]
["2013-12-02",168.18,44.42,101.13,29.3,87.41,29.79,67.48,95.21,33.19,16.25,71.21,null,"2013-12-02"]
["2014-01-02",162.34,44.88,94.07,24.68,86.92,29.91,62.84,97.34,37.1,16.73,73.4,null,"2014-01-02"]
["2014-02-03",169.75,46.87,98.21,25.76,91.64,30.66,65.01,104.09,39.2,17.53,75.85,null,"2014-02-03"]
["2014-03-03",171.14,48.67,95.49,30.76,95.01,35.03,70.24,102.7,43.74,20.92,77.48,null,"2014-03-03"]
["2014-04-01",172.38,47.31,94.94,29.5,92.66,30.61,70.08,94.67,41.71,21.86,81.22,null,"2014-04-01"]
["2014-05-01",176.41,48.81,101.34,34.52,92.73,30.78,71.17,96.23,42.27,25.44,91.55,null,"2014-05-01"]
["2014-06-02",180.03,48.95,105.26,36.77,93.5,33.3,70.46,96.26,37.37,27.36,96.19,null,"2014-06-02"]
["2014-07-01",177.53,45.08,98.41,35.23,89.49,33.95,65.08,87.15,37.05,27.96,90.14,null,"2014-07-01"]
["2014-08-01",184.61,50.48,101.97,39.38,94.08,38.34,68.95,90.91,37.97,29.87,92.55,null,"2014-08-01"]
["2014-09-02",181.99,51.19,98.39,44.46,93.25,44.44,66.18,94.89,39.27,30.56,87.95,null,"2014-09-02"]
["2014-10-01",186.4,53.91,103.36,43.9,102.69,47.78,70.35,95.37,40.25,28.41,83.98,null,"2014-10-01"]
["2014-11-03",191.4,53.08,102.57,41.88,104.7,42.94,73.94,100.28,42.34,32.3,86.81,null,"2014-11-03"]
["2014-12-01",190.1,52.84,102.78,41.91,105.34,44.3,73.52,100.2,41.31,32.22,86.33,null,"2014-12-01"]

{"sheet":"EoC Exercise 3 DATA","index":5,"n_rows":63,"n_cols":12,"rows_kept":63}
["Date","VFINX","CALM","RMCF","IBA","HRL","CVGW","JJSF","SJM","MJN","TR","HSY"]
["2009-11-02",91.04482,11.88381,7.021,19.71965,16.93744,15.09583,33.99741,51.99109,40.09307,21.42019,31.27913]
["2009-12-01",92.81683,14.75948,6.60512,20.80513,17.35727,15.20315,37.74267,54.34072,40.1183,23.14179,31.65055]
["2010-01-04",89.47192,14.21129,7.09439,19.44827,17.56502,14.98851,39.49002,52.8623,41.5229,22.00076,32.21653]
["2010-02-01",92.23825,13.95449,7.04489,19.45732,18.65886,15.82021,40.34008,52.82705,43.42324,22.99809,35.44682]
["2010-03-01",97.78734,14.77713,7.58934,20.03625,19.06735,16.31208,41.1585,53.34044,47.97561,22.90933,38.16595]
["2010-04-01",99.33044,14.7227,7.85332,19.90056,18.5931,15.50721,44.11259,54.05743,47.58834,22.54488,41.91033]
["2010-05-03",91.388,14.27722,7.58571,19.26797,18.15519,14.28201,42.06745,49.21466,45.47678,21.2227,42.01142]
["2010-06-01",86.59035,14.08315,7.74409,15.53309,18.46538,16.06167,39.95856,53.67089,46.41166,20.10903,43.02579]
["2010-07-01",92.6483,13.93319,7.87746,17.18967,19.67501,18.88767,39.5884,54.7493,49.20822,21.45246,42.19095]
["2010-08-02",88.45152,13.21469,8.0025,16.77379,19.78045,17.55516,35.82983,52.47803,48.32851,20.07502,41.99669]
["2010-09-01",96.33633,12.90302,7.96942,17.51314,20.44514,19.38848,39.90824,54.31763,52.9121,21.22317,43.00887]
["2010-10-01",99.98586,12.92918,7.9947,19.92523,21.14974,19.58523,40.80292,57.68276,54.68792,22.3918,44.72598]
["2010-11-01",99.98586,13.68342,8.12905,23.19682,22.60517,21.15309,43.54405,57.11288,55.38523,22.72448,42.58787]
["2010-12-01",106.65553,14.09401,8.21417,22.35582,23.60923,21.11645,46.0256,59.28001,58.08784,24.7816,42.90637]
["2011-01-03",109.16951,12.75156,8.69085,23.24302,22.86732,21.14393,40.52046,56.12864,54.09401,23.661,42.48777]
["2011-02-01",112.89904,12.98087,8.85333,24.14872,25.36698,21.27219,41.95161,62.59304,55.8483,24.4651,47.93266]
["2011-03-01",112.93236,13.26414,8.93069,25.8492,25.77433,20.01711,45.02919,64.91164,54.3073,24.32554,49.79243]
["2011-04-01",116.26151,13.20025,9.05962,26.34826,27.3516,19.23841,48.6166,68.25769,62.6976,25.42345,52.87067]
["2011-05-02",114.92985,13.62061,9.0254,24.11463,27.2772,20.28278,49.28625,72.50883,63.5507,25.16612,51.37241]
["2011-06-01",113.00646,14.60297,8.57413,22.49081,27.7236,19.29338,47.80882,69.9114,63.57792,25.16828,52.40484]
["2011-07-01",110.69339,15.44826,7.91458,22.08587,27.0573,18.9361,49.57347,71.26499,67.1733,24.12749,52.0269]
["2011-08-01",104.66451,14.88228,7.7497,20.61473,25.78709,18.3223,48.5377,66.37759,67.06036,21.79645,54.39773]
["2011-09-01",97.27694,14.40561,7.46885,21.18998,25.23605,18.79868,46.19659,67.1142,65.00673,20.81696,54.94496]
["2011-10-03",107.89355,15.29226,7.51273,21.28428,27.64631,20.67671,49.56158,70.91695,67.85898,21.37796,53.08068]
["2011-11-01",107.64144,15.54009,7.68816,18.9267,28.24671,24.86775,49.87885,70.38703,71.17401,20.80834,53.82809]
["2011-12-01",108.74202,16.78385,7.58162,17.98367,27.47746,24.04382,51.35033,72.41582,65.14565,20.4988,57.65429]
["2012-01-03",113.59691,17.5635,7.68816,18.93613,27.13819,25.46697,49.18182,72.98091,70.22611,20.99242,57.00104]
["2012-02-01",118.48936,17.82274,8.42578,19.08702,26.84587,25.74785,48.35297,70.20042,73.69524,20.13506,57.00339]
["2012-03-01",122.3791,17.71164,8.30913,19.8603,27.83597,25.07373,50.68937,75.82988,78.47149,19.90722,57.59502]
["2012-04-02",121.59644,16.85254,8.56037,19.47366,27.54823,26.85267,54.16786,74.21747,81.40179,20.68926,62.92911]
["2012-05-01",114.27897,16.62335,9.466,19.13627,28.35401,25.64486,53.21127,71.80871,76.81605,19.42063,63.14161]
["2012-06-01",118.97882,18.28849,10.42711,20.91838,28.83748,23.95019,57.23786,70.83325,76.86643,20.80656,68.02409]
["2012-07-02",120.6088,17.6477,11.08901,22.1854,26.59658,25.26099,55.96914,72.03382,69.65811,21.34722,67.75021]
["2012-08-01",123.30962,19.04888,11.33047,21.27103,27.36846,24.75539,55.30088,80.24009,70.01137,22.12332,68.18329]
["2012-09-04",126.48666,21.30554,11.57738,23.15751,27.86399,23.40714,55.65034,81.52438,70.24627,23.59759,67.30038]
["2012-10-01",124.13461,20.50489,9.73927,24.30288,28.28343,22.1057,55.59209,80.87279,59.10733,23.30895,65.36368]
["2012-11-01",124.82975,21.86016,9.57574,25.121,29.70095,23.13918,61.05714,84.03782,65.367,23.77252,69.96461]
["2012-12-03",125.94801,19.12585,9.7606,26.87273,29.89251,24.24517,62.16502,81.9288,63.45045,23.16057,68.96199]
["2013-01-02",132.46736,19.91415,11.23024,26.77648,33.31352,23.95665,66.32038,84.19932,73.18613,24.21495,75.86582]
["2013-02-01",134.24101,19.34558,11.45282,28.88433,36.00863,27.07265,67.36166,91.05666,72.1365,25.09061,79.9959]
["2013-03-01",139.25467,20.3346,11.47147,30.91519,39.77216,27.67854,74.9963,94.7448,74.92241,27.60647,84.01778]
["2013-04-01",141.91245,20.5966,11.39686,32.75354,39.8898,27.27461,73.17236,98.63358,78.44362,28.82481,85.58237]
["2013-05-01",145.21544,21.59071,12.28255,33.41108,38.48829,28.57294,74.03069,96.94692,78.42427,29.00018,85.94247]
["2013-06-03",143.256,22.44488,11.69006,33.68288,37.28976,26.14939,76.04256,99.04987,76.96808,29.40658,86.10642]
["2013-07-01",150.52234,24.45725,12.54589,39.28353,41.10344,26.12054,77.8801,108.04742,70.7605,31.33124,91.49773]
["2013-08-01",146.13931,22.02021,11.58635,37.31789,40.21053,23.81239,75.18244,102.44263,72.88798,27.75026,89.13538]
["2013-09-03",150.69609,23.19771,11.48197,38.59898,40.88021,29.08266,79.06012,101.38095,72.46893,28.51827,89.66855]
["2013-10-01",157.60777,24.51298,12.03235,40.08543,42.34726,28.55371,83.81039,107.33602,79.69045,29.68666,96.20223]
["2013-11-01",162.3808,26.5521,12.82185,38.85324,43.86732,30.35008,84.15319,101.15504,82.47171,29.73305,94.40629]
["2013-12-02",166.46735,29.10342,11.10908,40.27,44.01348,29.78895,87.08652,100.5534,82.06808,30.26209,94.73758]
["2014-01-02",160.69238,24.51581,11.14736,42.38,44.46725,29.90708,86.60484,93.53736,75.33685,28.2161,96.85194]
["2014-02-03",168.02101,25.5815,11.46585,41.95,46.43422,30.65525,91.30371,97.65257,79.90272,27.9502,103.57375]
["2014-03-03",169.40305,30.54987,11.34028,43.67,48.21526,35.02614,94.65993,94.94787,81.82796,28.75701,102.18389]
["2014-04-01",170.62968,29.30481,11.54313,44.1,46.86708,30.60603,92.32227,94.40107,86.86716,27.07615,94.1971]
["2014-05-01",174.61378,34.28314,11.26173,51.59,48.36086,30.78323,92.39132,100.76363,88.05806,27.9502,95.75029]
["2014-06-02",178.19807,36.52412,12.8608,53.77,48.49844,33.30338,93.15468,104.66257,92.07546,28.35566,95.77981]
["2014-07-01",175.72461,34.99081,12.48053,53.14,44.66454,33.95311,89.16601,97.85661,90.36579,25.36022,86.71038]
["2014-08-01",182.73111,39.11069,12.74756,56.89,50.01323,38.34368,93.73862,101.39617,94.47691,27.20949,90.45321]
["2014-09-02",180.13966,44.1633,12.33444,59.74,50.71389,44.43732,92.9088,97.82853,95.46082,26.95908,94.42081]
["2014-10-01",184.50481,43.59725,11.89182,61.15,53.41084,47.7844,102.31289,102.77975,98.52644,28.63982,94.89573]
["2014-11-03",189.45398,41.59592,12.55187,56.58,52.58853,42.94,104.31883,101.98985,103.0207,28.14719,99.77972]
["2014-12-01",188.16721,41.62571,12.53203,54.76,52.35075,44.3,104.95438,102.19865,103.10007,27.87673,99.70012]

{"sheet":"EoC Exercise 3 Template","index":6,"n_rows":88,"n_cols":13,"rows_kept":88,"merged":[[0,0,0,11],[2,0,2,11],[8,0,8,11],[20,0,20,4],[25,0,25,11]]}
["PORTFOLIO:  10 PACKAGED FOOD STOCKS"]
[]
["Market cap and value-weighted portfolio"]
[null,null,"Cal-Maine Foods","Rocky Mountain Chocalate","Industrios Bachoco","Hormel Foods","Calavo Growers","J&J Snack Foods","J.M. Smucker","Mead Johnson Nutrition","Tootsie Roll Industries","Hershey Company"]
[null,null,"CALM","RMCF","IBA","HRL","CVGW","JJSF","SJM","MJN","TR","HSY"]
["Market cap ($B)",null,2.21,{"v":0.07848,"d":"0.08"},2.72,14.57,0.87,1.96,13.98,19.49,1.89,20.67]
["Weight in portfolio"]
[]
["Computing the individual asset regressions"]
[null,"SP500","Cal-Maine Foods","Rocky Mountain Chocalate","Industrios Bachoco","Hormel Foods","Calavo Growers","J&J Snack Foods","J.M. Smucker","Mead Johnson Nutrition","Tootsie Roll Industries","Hershey Company"]
[null,"VFINX","CALM","RMCF","IBA","HRL","CVGW","JJSF","SJM","MJN","TR","HSY"]
["Alpha"]
["Beta"]
["R-squared"]
[]
["Average alpha"]
["Average beta"]
["Average r-squared"]
[]
[]
["Regression of value-weighted portfolio"]
["Alpha"]
["Beta"]
["R-squared"]
[]
["Computing the returns"]
["Date","VFINX","CALM","RMCF","IBA","HRL","CVGW","JJSF","SJM","MJN","TR","HSY","Portfolio"]
["2009-12-01"]
["2010-01-04"]
["2010-02-01"]
["2010-03-01"]
["2010-04-01"]
["2010-05-03"]
["2010-06-01"]
["2010-07-01"]
["2010-08-02"]
["2010-09-01"]
["2010-10-01"]
["2010-11-01"]
["2010-12-01"]
["2011-01-03"]
["2011-02-01"]
["2011-03-01"]
["2011-04-01"]
["2011-05-02"]
["2011-06-01"]
["2011-07-01"]
["2011-08-01"]
["2011-09-01"]
["2011-10-03"]
["2011-11-01"]
["2011-12-01"]
["2012-01-03"]
["2012-02-01"]
["2012-03-01"]
["2012-04-02"]
["2012-05-01"]
["2012-06-01"]
["2012-07-02"]
["2012-08-01"]
["2012-09-04"]
["2012-10-01"]
["2012-11-01"]
["2012-12-03"]
["2013-01-02"]
["2013-02-01"]
["2013-03-01"]
["2013-04-01"]
["2013-05-01"]
["2013-06-03"]
["2013-07-01"]
["2013-08-01"]
["2013-09-03"]
["2013-10-01"]
["2013-11-01"]
["2013-12-02"]
["2014-01-02"]
["2014-02-03"]
["2014-03-03"]
["2014-04-01"]
["2014-05-01"]
["2014-06-02"]
["2014-07-01"]
["2014-08-01"]
["2014-09-02"]
["2014-10-01"]
["2014-11-03"]
["2014-12-01"]