{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Notes","InputPriceData","CorrelationCandidates","RawCorrelations","SortedFilteredCorrelations","S&P 500 Constituent Symbols"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":32,"comments":2,"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":"Notes","index":0,"n_rows":40,"n_cols":3,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["CorrelationPairGenerator.xlsm"]
["Coded beginning 2015-Feb-04 by Ronald McAllister (rpmac_xltt@sprynet.com)"]
[]
["This Workbook demonstrates an EXCEL version of one of the ideas presented"]
["by Mr. Dave Cline in an article titled \"Basket Trading Using A Directed Acyclic Graph\""]
["which appears in the April 2015 issue of"]
["\"Technical Analysis of Stocks and Commodities\" magazine."]
[]
[null,"Specifically, this workbook performs the initial creation of correlation pairs for a user supplied list of stock symbols."]
[null,"It then refines this list by allowing the user to set an acceptable correlation threshold which is used to remove lesser examples."]
[null,"Task bar messages reflect progress in the data acquisition phase and again in the pair generation phase."]
[]
[null,"Depending on the date range you specify for the data acquisition, some symbols may not have many or any bars in their history. "]
[null,"The companies may simply be too new. "]
[]
[null,"This happened in the S&P 500 list I used as my example. I asked for correlation data from three years ago."]
[null,"In some cases I got as few as 30 bars. In others I got no bars."]
[]
[null,"The correlation generation phase will skip any symbols in the candidate list with less than the number of bars you specified for the correlation computation."]
[]
[null,"The end result is suitable for sumission to the DAG phase."]
[]
["To run the workbook:"]
[null,"Load a list of symbols into column A of the CorrelationCandidates tab starting in row 8,"]
[null,"Set the dates and the number of bars to use in the correlation computation."]
[null,"Make sure you have an internet connection and click the button to begin the data acquisition phase."]
[null,"The pair generation phase will automatically begin when the data acquisition is complete."]
[null,"When the raw pairs list is complete, go to the SortedFilteredCorrelations tab to complete the processing."]
[null,"Set the correlation threshold and optionally set a non zero max entries value."]
[null,"Click a button and you have a list of correlation pairs suitable for submission to the Directed Acyclic Graph (DAG) process described in the article."]
[]
[]
["Data for this EXCEL example:"]
[null,"Automatically downloaded from the YahooFinance web site as part of the processing."]
[]
["Development Notes:"]
[1,null,"This workbook contains and uses VBA macros."]
[2,null,"Input Data"]
[null,null,"The data in this workbook is sorted date descending (most recent date at the top). All formulas and "]
[null,null,"VBA routines are built accordingly."]

{"sheet":"InputPriceData","index":1,"n_rows":354,"n_cols":32,"rows_kept":354,"cut":false,"hidden":false,"merged":[[4,31,8,31],[13,1,13,6],[13,10,13,14],[13,17,13,18],[11,22,14,22],[11,24,14,24],[11,25,14,25],[11,26,14,26],[11,27,14,27],[11,28,14,28],[11,29,14,29],[11,23,14,23],[10,22,10,29]]}
["Chipotle Mexican  (CMG) -NYSE (Daily)"]
["Last Trade:","2015-02-11",666.36,676.75,664,669.91,462291,"3:43pm",4.8799000000000001]
["Request Online Yahoo History for:"]
["Symbol","CMG",null,"Valid"]
["From","2010-08-30",null,"Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trailing 12 Div return (Cur Close)"]
["To","2012-01-01",null,"Types",{"$f":"VLOOKUP(B7,D7:E10,2,FALSE)","v":"d"}]
["Data Type","Daily",null,"Daily","d"]
[null,null,null,"Weekly","w"]
["Available Data",null,null,"Monthly","m"]
["Bar Count: ",{"$f":"COUNTA(B15:B70000)-1","v":339},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OFFSET(AC15,1,0,1,1)/OFFSET(N15,1,0,1,1)","v":0}]
["From: ",{"$f":"IF(B10<=0,\"\",OFFSET(B15,B10,IF(HistReqDataType=\"v\",1,0),1,1))","v":"2010-08-30"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trailing 12 Month Dividend Returns"]
["To: ",{"$f":"IF(B10<=0,\"\",IF(HistReqDataType=\"v\",OFFSET(B15,2,1,1,1),OFFSET(B15,1,0,1,1)))","v":"2011-12-30"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Raw Close price on Dividend date","Div Year and Month","Looking for year ago Div Year and Month","Year ago Div Date we found","row offset to year ago div Date","Same month flag","Trailing 12 Div Total","Trailing 12 Div return"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Split History",null,{"$f":"COUNT(Q16:Q20000)","v":0},"Running","Dividend History"]
[null,"Raw Data Values",null,null,null,null,null,"Adjusted","Price Adjust","Vol Adjust","Adjusted Values",null,null,null,null,"Last","Effective","Shares",null,"Vol Adjust ",null,{"$f":"COUNT(U16:U20000)","v":0}]
["RelRow","Date","Open","High","Low","Close","Volume","Close","Factor","Factor","Open","High","Low","Close","Volume","Trade",42047,"New","Old",1,"Date","$ / Share"]
[1,"2011-12-30",340.98,341.81,337.74,337.74,223200,337.74,{"$f":"H16/F16","v":1},{"$f":"INDEX(OFFSET($T$15,0,0,$S$13+1,1),MATCH(B16,OFFSET($Q$15,0,0,$S$13+1,1),-1))","v":1},{"$f":"ROUND($I16*C16,2)","v":340.98},{"$f":"ROUND($I16*D16,2)","v":341.81},337.74,337.74,{"$f":"G16*J16","v":223200}]
[2,"2011-12-29",340,342,338.66,340.77,292700,340.77,{"$f":"H17/F17","v":1},{"$f":"INDEX(OFFSET($T$15,0,0,$S$13+1,1),MATCH(B17,OFFSET($Q$15,0,0,$S$13+1,1),-1))","v":1},{"$f":"ROUND($I17*C17,2)","v":340},{"$f":"ROUND($I17*D17,2)","v":342},{"$f":"ROUND($I17*E17,2)","v":338.66},{"$f":"ROUND($I17*F17,2)","v":340.77},{"$f":"G17*J17","v":292700}]
[3,"2011-12-28",338.64,340.5,336.67,340.14,396600,340.14,1,1,338.64,340.5,336.67,340.14,396600]
[4,"2011-12-27",335,339.94,333.12,339,272600,339,1,1,335,339.94,333.12,339,272600]
[5,"2011-12-23",332.68,335.32,331.4,335.32,200600,335.32,1,1,332.68,335.32,331.4,335.32,200600]
[6,"2011-12-22",334.98,336.15,329.8,331.25,245400,331.25,1,1,334.98,336.15,329.8,331.25,245400]
[7,"2011-12-21",331.6,334.6,330.09,334.06,335000,334.06,1,1,331.6,334.6,330.09,334.06,335000]
[8,"2011-12-20",322.2,332,321.47000000000003,331.72,513900,331.72,1,1,322.2,332,321.47000000000003,331.72,513900]
[9,"2011-12-19",320.68,321.51,317.19,317.77,363300,317.77,1,1,320.68,321.51,317.19,317.77,363300]
[10,"2011-12-16",319.7,321.94,316.8,318.39999999999998,554000,318.39999999999998,1,1,319.7,321.94,316.8,318.39999999999998,554000]
[11,"2011-12-15",324.48,324.5,316.74,318.52,505500,318.52,1,1,324.48,324.5,316.74,318.52,505500]
[12,"2011-12-14",327.7,329.93,319.20999999999998,321.11,599700,321.11,1,1,327.7,329.93,319.20999999999998,321.11,599700]
[13,"2011-12-13",340,340.11,328.5,329.51,678700,329.51,1,1,340,340.11,328.5,329.51,678700]
[14,"2011-12-12",335.38,341.28,334.35,340.22,529700,340.22,1,1,335.38,341.28,334.35,340.22,529700]
[15,"2011-12-09",335.68,339.98,332.91,338.6,478300,338.6,1,1,335.68,339.98,332.91,338.6,478300]
[16,"2011-12-08",334.91,339.23,333.54,334.74,587500,334.74,1,1,334.91,339.23,333.54,334.74,587500]
[17,"2011-12-07",330.15,338.1,328.15,336.75,597400,336.75,1,1,330.15,338.1,328.15,336.75,597400]
[18,"2011-12-06",334,334.83,329.26,331.43,455300,331.43,1,1,334,334.83,329.26,331.43,455300]
[19,"2011-12-05",334.15,338.68,333.03,336.21,817700,336.21,1,1,334.15,338.68,333.03,336.21,817700]
[20,"2011-12-02",324.98,333.33,323.81,330.49,786700,330.49,1,1,324.98,333.33,323.81,330.49,786700]
[21,"2011-12-01",318.5,324.08999999999997,315.93,323.04000000000002,581600,323.04000000000002,1,1,318.5,324.08999999999997,315.93,323.04000000000002,581600]
[22,"2011-11-30",320.20999999999998,321.7,316.27,321.56,709200,321.56,1,1,320.20999999999998,321.7,316.27,321.56,709200]
[23,"2011-11-29",310.02,313.82,309.31,312.97000000000003,395100,312.97000000000003,1,1,310.02,313.82,309.31,312.97000000000003,395100]
[24,"2011-11-28",309.5,313.38,307.25,309.55,474200,309.55,1,1,309.5,313.38,307.25,309.55,474200]
[25,"2011-11-25",300,304.89,300,300.75,219900,300.75,1,1,300,304.89,300,300.75,219900]
[26,"2011-11-23",306.67,308.75,300.45,300.45,459500,300.45,1,1,306.67,308.75,300.45,300.45,459500]
[27,"2011-11-22",304.19,312.22000000000003,304.19,308.38,525400,308.38,1,1,304.19,312.22000000000003,304.19,308.38,525400]
[28,"2011-11-21",306.43,308.48,302.68,305.58,498000,305.58,1,1,306.43,308.48,302.68,305.58,498000]
[29,"2011-11-18",314.3,315.89999999999998,308.26,311.06,506100,311.06,1,1,314.3,315.89999999999998,308.26,311.06,506100]
[30,"2011-11-17",316.70999999999998,319.64,310,313.61,710200,313.61,1,1,316.70999999999998,319.64,310,313.61,710200]
[31,"2011-11-16",325.02999999999997,326.95,315.01,316.67,791900,316.67,1,1,325.02999999999997,326.95,315.01,316.67,791900]
[32,"2011-11-15",326,329.11,322.51,327.45999999999998,496600,327.45999999999998,1,1,326,329.11,322.51,327.45999999999998,496600]
[33,"2011-11-14",330.75,334.34,326.33,327.02999999999997,464600,327.02999999999997,1,1,330.75,334.34,326.33,327.02999999999997,464600]
[34,"2011-11-11",329.82,333.16,325.27999999999997,332.02,507800,332.02,1,1,329.82,333.16,325.27999999999997,332.02,507800]
[35,"2011-11-10",336.92,336.95,324.52999999999997,325.88,751100,325.88,1,1,336.92,336.95,324.52999999999997,325.88,751100]
[36,"2011-11-09",333.01,338.07,331.68,332.84,474900,332.84,1,1,333.01,338.07,331.68,332.84,474900]
[37,"2011-11-08",341,342.74,335,339.87,443800,339.87,1,1,341,342.74,335,339.87,443800]
[38,"2011-11-07",338.87,341.61,336.09,339.16,419800,339.16,1,1,338.87,341.61,336.09,339.16,419800]
[39,"2011-11-04",334.31,339.94,334.31,338.97,491800,338.97,1,1,334.31,339.94,334.31,338.97,491800]
[40,"2011-11-03",333.63,338.66,329.06,337.5,869200,337.5,1,1,333.63,338.66,329.06,337.5,869200]
[41,"2011-11-02",332.99,332.99,324.93,329.62,562300,329.62,1,1,332.99,332.99,324.93,329.62,562300]
[42,"2011-11-01",326.64,334.27,324,328.18,882600,328.18,1,1,326.64,334.27,324,328.18,882600]
[43,"2011-10-31",338.98,347.94,336.05,336.12,1015000,336.12,1,1,338.98,347.94,336.05,336.12,1015000]
[44,"2011-10-28",341.32,344.98,338.33,341.4,496900,341.4,1,1,341.32,344.98,338.33,341.4,496900]
[45,"2011-10-27",341.25,345.92,335.02,343.52,747600,343.52,1,1,341.25,345.92,335.02,343.52,747600]
[46,"2011-10-26",338.96,339.5,330.02,332.85,747000,332.85,1,1,338.96,339.5,330.02,332.85,747000]
[47,"2011-10-25",339.59,343,334.03,334.18,878800,334.18,1,1,339.59,343,334.03,334.18,878800]
[48,"2011-10-24",334,342.98,332.4,342.49,1117300,342.49,1,1,334,342.98,332.4,342.49,1117300]
[49,"2011-10-21",320.07,333.5,318.41000000000003,333.49,2661100,333.49,1,1,320.07,333.5,318.41000000000003,333.49,2661100]
[50,"2011-10-20",308.97000000000003,312.29000000000002,306.06,307.91000000000003,1232800,307.91000000000003,1,1,308.97000000000003,312.29000000000002,306.06,307.91000000000003,1232800]
[51,"2011-10-19",319.47000000000003,319.99,309.17,310.27,758300,310.27,1,1,319.47000000000003,319.99,309.17,310.27,758300]
[52,"2011-10-18",320.5,321.06,310.27999999999997,319.85000000000002,584800,319.85000000000002,1,1,320.5,321.06,310.27999999999997,319.85000000000002,584800]
[53,"2011-10-17",319.60000000000002,324.33,317.08999999999997,319.79000000000002,613900,319.79000000000002,1,1,319.60000000000002,324.33,317.08999999999997,319.79000000000002,613900]
[54,"2011-10-14",320,321.66000000000003,314.72000000000003,320.8,699000,320.8,1,1,320,321.66000000000003,314.72000000000003,320.8,699000]
[55,"2011-10-13",311.36,318.98,311.36,317.31,688400,317.31,1,1,311.36,318.98,311.36,317.31,688400]
[56,"2011-10-12",313.47000000000003,318.05,311,314,828600,314,1,1,313.47000000000003,318.05,311,314,828600]
[57,"2011-10-11",305.02,315,305.01,309.95,682700,309.95,1,1,305.02,315,305.01,309.95,682700]
[58,"2011-10-10",298.77,311.83999999999997,298.5,307.85000000000002,741600,307.85000000000002,1,1,298.77,311.83999999999997,298.5,307.85000000000002,741600]
[59,"2011-10-07",296.98,298.56,290.54000000000002,294.58999999999997,995000,294.58999999999997,1,1,296.98,298.56,290.54000000000002,294.58999999999997,995000]
[60,"2011-10-06",292.75,301.22000000000003,289.08,298.99,1549800,298.99,1,1,292.75,301.22000000000003,289.08,298.99,1549800]
[61,"2011-10-05",300.92,302.36,292,300.79000000000002,1039000,300.79000000000002,1,1,300.92,302.36,292,300.79000000000002,1039000]
[62,"2011-10-04",290,302.95999999999998,285.39,301.08999999999997,1400000,301.08999999999997,1,1,290,302.95999999999998,285.39,301.08999999999997,1400000]
[63,"2011-10-03",300.81,306.60000000000002,291.48,292.7,969500,292.7,1,1,300.81,306.60000000000002,291.48,292.7,969500]
[64,"2011-09-30",308.08999999999997,312.94,301.8,302.95,858200,302.95,1,1,308.08999999999997,312.94,301.8,302.95,858200]
[65,"2011-09-29",323.82,324.64999999999998,303.33999999999997,313.14,1190800,313.14,1,1,323.82,324.64999999999998,303.33999999999997,313.14,1190800]
[66,"2011-09-28",322.47000000000003,328.35,318,319.06,782900,319.06,{"$f":"H81/F81","v":1},{"$f":"INDEX(OFFSET($T$15,0,0,$S$13+1,1),MATCH(B81,OFFSET($Q$15,0,0,$S$13+1,1),-1))","v":1},{"$f":"ROUND($I81*C81,2)","v":322.47000000000003},{"$f":"ROUND($I81*D81,2)","v":328.35},{"$f":"ROUND($I81*E81,2)","v":318},{"$f":"ROUND($I81*F81,2)","v":319.06},{"$f":"G81*J81","v":782900}]
[67,"2011-09-27",334.48,334.48,319.52999999999997,320.61,941500,320.61,1,1,334.48,334.48,319.52999999999997,320.61,941500]
[68,"2011-09-26",324.74,329.97,310,329.44,1047300,329.44,1,1,324.74,329.97,310,329.44,1047300]
[69,"2011-09-23",322.79000000000002,323.83,313.58,320.5,1244500,320.5,1,1,322.79000000000002,323.83,313.58,320.5,1244500]
[70,"2011-09-22",325.02999999999997,334.74,320.75,325.94,1762400,325.94,1,1,325.02999999999997,334.74,320.75,325.94,1762400]
[71,"2011-09-21",331.03,343.48,329.34,333.25,2014000,333.25,1,1,331.03,343.48,329.34,333.25,2014000]
[72,"2011-09-20",337.03,346.78,332,333.19,2035500,333.19,1,1,337.03,346.78,332,333.19,2035500]
[73,"2011-09-19",315.5,338.32,314.2,336.14,1572400,336.14,1,1,315.5,338.32,314.2,336.14,1572400]
[74,"2011-09-16",316.57,318.19,314.02,318.06,567100,318.06,1,1,316.57,318.19,314.02,318.06,567100]
[75,"2011-09-15",318,319,312.25,316.14999999999998,667800,316.14999999999998,1,1,318,319,312.25,316.14999999999998,667800]
[76,"2011-09-14",312.98,319.66000000000003,308.89999999999998,315.91000000000003,956000,315.91000000000003,1,1,312.98,319.66000000000003,308.89999999999998,315.91000000000003,956000]
[77,"2011-09-13",306.31,312.18,306.31,311.41000000000003,592300,311.41000000000003,1,1,306.31,312.18,306.31,311.41000000000003,592300]
[78,"2011-09-12",301.81,309.44,300.82,307.75,697200,307.75,1,1,301.81,309.44,300.82,307.75,697200]
[79,"2011-09-09",308.05,309.60000000000002,300.52999999999997,305.17,923600,305.17,1,1,308.05,309.60000000000002,300.52999999999997,305.17,923600]
[80,"2011-09-08",307.38,315.85000000000002,306.33999999999997,311.33999999999997,761600,311.33999999999997,1,1,307.38,315.85000000000002,306.33999999999997,311.33999999999997,761600]
[81,"2011-09-07",313.89999999999998,313.89999999999998,307.10000000000002,308.69,774800,308.69,1,1,313.89999999999998,313.89999999999998,307.10000000000002,308.69,774800]
[82,"2011-09-06",298.97000000000003,310.98,297.7,310.43,850800,310.43,1,1,298.97000000000003,310.98,297.7,310.43,850800]
[83,"2011-09-02",302.43,309.93,300.57,305.5,625000,305.5,1,1,302.43,309.93,300.57,305.5,625000]
[84,"2011-09-01",314.02999999999997,316,308.05,309.17,538800,309.17,1,1,314.02999999999997,316,308.05,309.17,538800]
[85,"2011-08-31",313.66000000000003,318,310.23,313.37,892500,313.37,1,1,313.66000000000003,318,310.23,313.37,892500]
[86,"2011-08-30",304.7,313.17,302.64999999999998,311.20999999999998,746700,311.20999999999998,1,1,304.7,313.17,302.64999999999998,311.20999999999998,746700]
[87,"2011-08-29",300.75,307.57,300.75,305.25,731400,305.25,1,1,300.75,307.57,300.75,305.25,731400]
[88,"2011-08-26",288.95999999999998,300.79000000000002,285,298.88,894300,298.88,1,1,288.95999999999998,300.79000000000002,285,298.88,894300]
[89,"2011-08-25",298.36,299.99,288.2,289.24,686200,289.24,1,1,298.36,299.99,288.2,289.24,686200]
[90,"2011-08-24",294.95,299.98,290.02,296.45999999999998,1166400,296.45999999999998,1,1,294.95,299.98,290.02,296.45999999999998,1166400]
[91,"2011-08-23",275.49,295.60000000000002,275.49,294.56,1476200,294.56,1,1,275.49,295.60000000000002,275.49,294.56,1476200]
[92,"2011-08-22",283.13,286.60000000000002,271.52999999999997,273.2,1563900,273.2,1,1,283.13,286.60000000000002,271.52999999999997,273.2,1563900]
[93,"2011-08-19",281.60000000000002,292.43,277,279.37,1762100,279.37,1,1,281.60000000000002,292.43,277,279.37,1762100]
[94,"2011-08-18",301.55,301.94,279,284.5,1890800,284.5,1,1,301.55,301.94,279,284.5,1890800]
[95,"2011-08-17",317.05,317.87,305.51,309.44,698900,309.44,1,1,317.05,317.87,305.51,309.44,698900]
[96,"2011-08-16",317.62,318.83,312.27,315.89,531800,315.89,1,1,317.62,318.83,312.27,315.89,531800]
[97,"2011-08-15",319.5,321.58,314.02,319.68,521600,319.68,1,1,319.5,321.58,314.02,319.68,521600]
[98,"2011-08-12",319.04000000000002,320.97000000000003,314.63,317.7,643800,317.7,1,1,319.04000000000002,320.97000000000003,314.63,317.7,643800]
[99,"2011-08-11",303.36,318.66000000000003,303.25,316.27999999999997,1199300,316.27999999999997,1,1,303.36,318.66000000000003,303.25,316.27999999999997,1199300]
[100,"2011-08-10",298.61,309.2,295,299.76,1401500,299.76,1,1,298.61,309.2,295,299.76,1401500]
[101,"2011-08-09",294.02,304,287.52,302.56,1451300,302.56,1,1,294.02,304,287.52,302.56,1451300]
[102,"2011-08-08",303.2,305.20999999999998,291.2,291.7,1410600,291.7,1,1,303.2,305.20999999999998,291.2,291.7,1410600]
[103,"2011-08-05",314.33999999999997,317.81,301.11,311.52,1240800,311.52,1,1,314.33999999999997,317.81,301.11,311.52,1240800]
[104,"2011-08-04",322.5,325.88,311.39999999999998,311.39999999999998,1263900,311.39999999999998,1,1,322.5,325.88,311.39999999999998,311.39999999999998,1263900]
[105,"2011-08-03",321.01,327,313.08,325.58,1070500,325.58,1,1,321.01,327,313.08,325.58,1070500]
[106,"2011-08-02",325.62,330.59,320.29000000000002,320.64999999999998,607300,320.64999999999998,1,1,325.62,330.59,320.29000000000002,320.64999999999998,607300]
[107,"2011-08-01",328.97,329.99,323.08999999999997,327.55,511700,327.55,1,1,328.97,329.99,323.08999999999997,327.55,511700]
[108,"2011-07-29",320.89,327.57,317.85000000000002,324.58,784300,324.58,1,1,320.89,327.57,317.85000000000002,324.58,784300]
[109,"2011-07-28",323,329,323,324.16000000000003,525500,324.16000000000003,1,1,323,329,323,324.16000000000003,525500]
[110,"2011-07-27",329.18,329.79,321.8,322.74,828100,322.74,1,1,329.18,329.79,321.8,322.74,828100]
[111,"2011-07-26",333.44,336.88,330.75,331.4,466200,331.4,1,1,333.44,336.88,330.75,331.4,466200]
[112,"2011-07-25",332.79,337.32,332,334.46,540800,334.46,1,1,332.79,337.32,332,334.46,540800]
[113,"2011-07-22",329.66,336.71,328.09,335.52,1019800,335.52,1,1,329.66,336.71,328.09,335.52,1019800]
[114,"2011-07-21",330.5,332.43,325.76,328.22,821500,328.22,1,1,330.5,332.43,325.76,328.22,821500]
[115,"2011-07-20",324.75,332,323.67,330.02,1872700,330.02,1,1,324.75,332,323.67,330.02,1872700]
[116,"2011-07-19",330.2,333.71,325.3,333.71,1473500,333.71,1,1,330.2,333.71,325.3,333.71,1473500]
[117,"2011-07-18",324.77999999999997,328.36,322.62,327.99,764200,327.99,1,1,324.77999999999997,328.36,322.62,327.99,764200]
[118,"2011-07-15",325.06,326.18,320.12,324.60000000000002,834300,324.60000000000002,1,1,325.06,326.18,320.12,324.60000000000002,834300]
[119,"2011-07-14",327.44,329.69,320.31,324.63,830400,324.63,1,1,327.44,329.69,320.31,324.63,830400]
[120,"2011-07-13",322.31,328.28,321.33,325.18,931800,325.18,1,1,322.31,328.28,321.33,325.18,931800]
[121,"2011-07-12",320.45999999999998,323.5,318.54000000000002,319.70999999999998,644200,319.70999999999998,1,1,320.45999999999998,323.5,318.54000000000002,319.70999999999998,644200]
[122,"2011-07-11",321.7,326.45999999999998,318.38,320.69,789000,320.69,1,1,321.7,326.45999999999998,318.38,320.69,789000]
[123,"2011-07-08",324.75,328.17,321.7,325.3,1025100,325.3,1,1,324.75,328.17,321.7,325.3,1025100]
[124,"2011-07-07",326.66000000000003,329.8,323.94,328.49,913100,328.49,1,1,326.66000000000003,329.8,323.94,328.49,913100]
[125,"2011-07-06",320.88,325.76,319.56,324.94,865800,324.94,1,1,320.88,325.76,319.56,324.94,865800]
[126,"2011-07-05",315.98,322.63,314.29000000000002,321.45,881900,321.45,1,1,315.98,322.63,314.29000000000002,321.45,881900]
[127,"2011-07-01",307.24,316.85000000000002,305.88,315.72000000000003,827000,315.72000000000003,1,1,307.24,316.85000000000002,305.88,315.72000000000003,827000]
[128,"2011-06-30",305.24,308.55,304.25,308.19,606200,308.19,1,1,305.24,308.55,304.25,308.19,606200]
[129,"2011-06-29",306.5,308.93,303.19,304.45999999999998,661400,304.45999999999998,1,1,306.5,308.93,303.19,304.45999999999998,661400]
[130,"2011-06-28",302.5,305.3,300.33,304.72000000000003,825800,304.72000000000003,{"$f":"H145/F145","v":1},{"$f":"INDEX(OFFSET($T$15,0,0,$S$13+1,1),MATCH(B145,OFFSET($Q$15,0,0,$S$13+1,1),-1))","v":1},{"$f":"ROUND($I145*C145,2)","v":302.5},{"$f":"ROUND($I145*D145,2)","v":305.3},{"$f":"ROUND($I145*E145,2)","v":300.33},{"$f":"ROUND($I145*F145,2)","v":304.72000000000003},{"$f":"G145*J145","v":825800}]
[131,"2011-06-27",293.26,302.72000000000003,291.08,301.45999999999998,1177300,301.45999999999998,1,1,293.26,302.72000000000003,291.08,301.45999999999998,1177300]
[132,"2011-06-24",292.38,297,290.51,293.25,1088100,293.25,1,1,292.38,297,290.51,293.25,1088100]
[133,"2011-06-23",281.64999999999998,291.55,280.8,290.77999999999997,1016400,290.77999999999997,1,1,281.64999999999998,291.55,280.8,290.77999999999997,1016400]
[134,"2011-06-22",285.12,289.82,284.42,284.45999999999998,546000,284.45999999999998,1,1,285.12,289.82,284.42,284.45999999999998,546000]
[135,"2011-06-21",277.16000000000003,285.89999999999998,277.04000000000002,285.25,838700,285.25,1,1,277.16000000000003,285.89999999999998,277.04000000000002,285.25,838700]
[136,"2011-06-20",268,277.25,267.43,276.05,629200,276.05,1,1,268,277.25,267.43,276.05,629200]
[137,"2011-06-17",274,275.44,268.87,268.97000000000003,940300,268.97000000000003,1,1,274,275.44,268.87,268.97000000000003,940300]
[138,"2011-06-16",277.3,277.3,269.42,271.81,789100,271.81,1,1,277.3,277.3,269.42,271.81,789100]
[139,"2011-06-15",274.75,278.77999999999997,273.07,277.3,669100,277.3,1,1,274.75,278.77999999999997,273.07,277.3,669100]
[140,"2011-06-14",273.81,277.94,272.45,276.77,530800,276.77,1,1,273.81,277.94,272.45,276.77,530800]
[141,"2011-06-13",271.99,275.64,268.08999999999997,270.89999999999998,627100,270.89999999999998,1,1,271.99,275.64,268.08999999999997,270.89999999999998,627100]
[142,"2011-06-10",277.31,279.02,271.3,271.87,766800,271.87,1,1,277.31,279.02,271.3,271.87,766800]
[143,"2011-06-09",276.89999999999998,279.06,273.62,277.87,446500,277.87,1,1,276.89999999999998,279.06,273.62,277.87,446500]
[144,"2011-06-08",279.82,283.92,276.12,277.11,655300,277.11,1,1,279.82,283.92,276.12,277.11,655300]
[145,"2011-06-07",281.99,284.87,280.24,281.3,406000,281.3,1,1,281.99,284.87,280.24,281.3,406000]
[146,"2011-06-06",285.01,290.19,280.26,280.74,673900,280.74,1,1,285.01,290.19,280.26,280.74,673900]
[147,"2011-06-03",281.95,291.89,281.02,286.51,1024800,286.51,1,1,281.95,291.89,281.02,286.51,1024800]
[148,"2011-06-02",287.13,288.69,282.08,285.79000000000002,826100,285.79000000000002,1,1,287.13,288.69,282.08,285.79000000000002,826100]
[149,"2011-06-01",288.5,291.39999999999998,285,285.56,591600,285.56,1,1,288.5,291.39999999999998,285,285.56,591600]
[150,"2011-05-31",294.52999999999997,295.99,287.23,289.07,775300,289.07,1,1,294.52999999999997,295.99,287.23,289.07,775300]
[151,"2011-05-27",291.02,293.99,288.25,292.94,765100,292.94,1,1,291.02,293.99,288.25,292.94,765100]
[152,"2011-05-26",284.8,291.20999999999998,282.22000000000003,290.88,1034800,290.88,1,1,284.8,291.20999999999998,282.22000000000003,290.88,1034800]
[153,"2011-05-25",280.3,285.98,278.99,284.11,574900,284.11,1,1,280.3,285.98,278.99,284.11,574900]
[154,"2011-05-24",284.24,284.43,279.32,280.57,545500,280.57,1,1,284.24,284.43,279.32,280.57,545500]
[155,"2011-05-23",277.52,285.25,275.51,283.33,916400,283.33,1,1,277.52,285.25,275.51,283.33,916400]
[156,"2011-05-20",279.99,281.17,276.04000000000002,279.89,677500,279.89,1,1,279.99,281.17,276.04000000000002,279.89,677500]
[157,"2011-05-19",280.8,282.61,277.54000000000002,281.12,538700,281.12,1,1,280.8,282.61,277.54000000000002,281.12,538700]
[158,"2011-05-18",275.17,280.02999999999997,274.38,278.75,513800,278.75,1,1,275.17,280.02999999999997,274.38,278.75,513800]
[159,"2011-05-17",271,275.11,268.25,274.51,790800,274.51,1,1,271,275.11,268.25,274.51,790800]
[160,"2011-05-16",278.7,279.88,272.12,272.69,806900,272.69,1,1,278.7,279.88,272.12,272.69,806900]
[161,"2011-05-13",276.16000000000003,281.98,275.89999999999998,280.39999999999998,1024800,280.39999999999998,1,1,276.16000000000003,281.98,275.89999999999998,280.39999999999998,1024800]
[162,"2011-05-12",272.07,278.91000000000003,271.33,275.88,922000,275.88,1,1,272.07,278.91000000000003,271.33,275.88,922000]
[163,"2011-05-11",270,275.89999999999998,269,274.3,1163300,274.3,1,1,270,275.89999999999998,269,274.3,1163300]
[164,"2011-05-10",266.35000000000002,269.98,266.27999999999997,269.85000000000002,504500,269.85000000000002,1,1,266.35000000000002,269.98,266.27999999999997,269.85000000000002,504500]
[165,"2011-05-09",268.10000000000002,268.82,264.04000000000002,266.41000000000003,651000,266.41000000000003,1,1,268.10000000000002,268.82,264.04000000000002,266.41000000000003,651000]
[166,"2011-05-06",270.11,272.45999999999998,266.51,268.10000000000002,850800,268.10000000000002,1,1,270.11,272.45999999999998,266.51,268.10000000000002,850800]
[167,"2011-05-05",258.39999999999998,269.08,257.39,265.77,1076400,265.77,1,1,258.39999999999998,269.08,257.39,265.77,1076400]
[168,"2011-05-04",257.10000000000002,261.39999999999998,249.58,260.52999999999997,1393000,260.52999999999997,1,1,257.10000000000002,261.39999999999998,249.58,260.52999999999997,1393000]
[169,"2011-05-03",266.14,267.76,257.79000000000002,260.41000000000003,914100,260.41000000000003,1,1,266.14,267.76,257.79000000000002,260.41000000000003,914100]
[170,"2011-05-02",268.8,270,264.05,267.08,761800,267.08,1,1,268.8,270,264.05,267.08,761800]
[171,"2011-04-29",265.66000000000003,268,264.29000000000002,266.79000000000002,664000,266.79000000000002,1,1,265.66000000000003,268,264.29000000000002,266.79000000000002,664000]
[172,"2011-04-28",261.89999999999998,267.87,260.12,265.64,1111000,265.64,1,1,261.89999999999998,267.87,260.12,265.64,1111000]
[173,"2011-04-27",265.60000000000002,268.89999999999998,263,263,8272000,263,1,1,265.60000000000002,268.89999999999998,263,263,8272000]
[174,"2011-04-26",273,273.88,264.01,264.94,1200000,264.94,1,1,273,273.88,264.01,264.94,1200000]
[175,"2011-04-25",275.54000000000002,276.91000000000003,271.39,272.64999999999998,934700,272.64999999999998,1,1,275.54000000000002,276.91000000000003,271.39,272.64999999999998,934700]
[176,"2011-04-21",282.48,283,270.81,277.3,3514000,277.3,1,1,282.48,283,270.81,277.3,3514000]
[177,"2011-04-20",283.49,289.35000000000002,280.45,288.10000000000002,2219000,288.10000000000002,1,1,283.49,289.35000000000002,280.45,288.10000000000002,2219000]
[178,"2011-04-19",283.31,285.95,279.27,279.85000000000002,861800,279.85000000000002,1,1,283.31,285.95,279.27,279.85000000000002,861800]
[179,"2011-04-18",282.06,285.08,279,283.37,787100,283.37,1,1,282.06,285.08,279,283.37,787100]
[180,"2011-04-15",283.99,285.45,280.5,285.13,910700,285.13,1,1,283.99,285.45,280.5,285.13,910700]
[181,"2011-04-14",280.11,285.97000000000003,278.55,282.91000000000003,935800,282.91000000000003,1,1,280.11,285.97000000000003,278.55,282.91000000000003,935800]
[182,"2011-04-13",277.72000000000003,282.76,275.12,281.31,1113400,281.31,1,1,277.72000000000003,282.76,275.12,281.31,1113400]
[183,"2011-04-12",265.88,277.14999999999998,265.07,274.3,1151200,274.3,1,1,265.88,277.14999999999998,265.07,274.3,1151200]
[184,"2011-04-11",268.60000000000002,271.58999999999997,265,268.41000000000003,475000,268.41000000000003,1,1,268.60000000000002,271.58999999999997,265,268.41000000000003,475000]
[185,"2011-04-08",275.97000000000003,277.18,267.31,269.24,880100,269.24,1,1,275.97000000000003,277.18,267.31,269.24,880100]
[186,"2011-04-07",273,277.88,272.16000000000003,274.7,566000,274.7,1,1,273,277.88,272.16000000000003,274.7,566000]
[187,"2011-04-06",280.05,282,272.07,275.76,846100,275.76,1,1,280.05,282,272.07,275.76,846100]
[188,"2011-04-05",272.14,280.58,271.02999999999997,278.02,918700,278.02,1,1,272.14,280.58,271.02999999999997,278.02,918700]
[189,"2011-04-04",276,277.77,270.20999999999998,273.91000000000003,662600,273.91000000000003,1,1,276,277.77,270.20999999999998,273.91000000000003,662600]
[190,"2011-04-01",273.26,278,271,274,1073900,274,1,1,273.26,278,271,274,1073900]
[191,"2011-03-31",270.3,273.92,268.32,272.37,642200,272.37,1,1,270.3,273.92,268.32,272.37,642200]
[192,"2011-03-30",271.52,272.95,266.55,272.2,1198800,272.2,1,1,271.52,272.95,266.55,272.2,1198800]
[193,"2011-03-29",256.99,266.54000000000002,256.20999999999998,266.12,1166500,266.12,1,1,256.99,266.54000000000002,256.20999999999998,266.12,1166500]
[194,"2011-03-28",258.27,263.52999999999997,254.05,257.95999999999998,1012400,257.95999999999998,{"$f":"H209/F209","v":1},{"$f":"INDEX(OFFSET($T$15,0,0,$S$13+1,1),MATCH(B209,OFFSET($Q$15,0,0,$S$13+1,1),-1))","v":1},{"$f":"ROUND($I209*C209,2)","v":258.27},{"$f":"ROUND($I209*D209,2)","v":263.52999999999997},{"$f":"ROUND($I209*E209,2)","v":254.05},{"$f":"ROUND($I209*F209,2)","v":257.95999999999998},{"$f":"G209*J209","v":1012400}]
[195,"2011-03-25",251.82,259,250.01,256.74,882600,256.74,1,1,251.82,259,250.01,256.74,882600]
[196,"2011-03-24",249.21,251,245.45,250.98,791300,250.98,1,1,249.21,251,245.45,250.98,791300]
[197,"2011-03-23",244.32,247.46,240.09,246.98,713400,246.98,1,1,244.32,247.46,240.09,246.98,713400]
[198,"2011-03-22",248.5,250,243.09,243.89,932600,243.89,1,1,248.5,250,243.09,243.89,932600]
[199,"2011-03-21",250,250.78,245.04,247.5,667800,247.5,1,1,250,250.78,245.04,247.5,667800]
[200,"2011-03-18",256,256.02,243.71,246.81,1065300,246.81,1,1,256,256.02,243.71,246.81,1065300]
[201,"2011-03-17",263,263,251.02,251.66,1003300,251.66,1,1,263,263,251.02,251.66,1003300]
[202,"2011-03-16",258.83999999999997,264.10000000000002,255.4,258.22000000000003,1284000,258.22000000000003,1,1,258.83999999999997,264.10000000000002,255.4,258.22000000000003,1284000]
[203,"2011-03-15",249.85,259.99,249,258,1123400,258,1,1,249.85,259.99,249,258,1123400]
[204,"2011-03-14",251.06,256.85000000000002,248.6,255.25,759700,255.25,1,1,251.06,256.85000000000002,248.6,255.25,759700]
[205,"2011-03-11",251.55,255.66,248.33,252.76,687300,252.76,1,1,251.55,255.66,248.33,252.76,687300]
[206,"2011-03-10",247.35,256.27,244,253.22,1232600,253.22,1,1,247.35,256.27,244,253.22,1232600]
[207,"2011-03-09",248.7,253.09,245.1,251.41,686500,251.41,1,1,248.7,253.09,245.1,251.41,686500]
[208,"2011-03-08",245.42,252.55,242.19,249.67,1014400,249.67,1,1,245.42,252.55,242.19,249.67,1014400]
[209,"2011-03-07",255.48,258.64,246.66,252.56,1080500,252.56,1,1,255.48,258.64,246.66,252.56,1080500]
[210,"2011-03-04",247.6,255.94,247,255,1192000,255,1,1,247.6,255.94,247,255,1192000]
[211,"2011-03-03",246.11,250.95,246,246.85,774400,246.85,1,1,246.11,250.95,246,246.85,774400]
[212,"2011-03-02",242.16,243.38,234.48,242.82,1008300,242.82,1,1,242.16,243.38,234.48,242.82,1008300]
[213,"2011-03-01",243,244.44,238.67,241.15,673500,241.15,1,1,243,244.44,238.67,241.15,673500]
[214,"2011-02-28",250.85,252.73,243.64,245,710600,245,1,1,250.85,252.73,243.64,245,710600]
[215,"2011-02-25",247,255,246.29,248.36,836100,248.36,1,1,247,255,246.29,248.36,836100]
[216,"2011-02-24",242.5,246.98,238.14,245.3,1014800,245.3,1,1,242.5,246.98,238.14,245.3,1014800]
[217,"2011-02-23",251.06,251.88,235,244.19,1648700,244.19,1,1,251.06,251.88,235,244.19,1648700]
[218,"2011-02-22",256.27,259.55,251.17,251.9,893200,251.9,1,1,256.27,259.55,251.17,251.9,893200]
[219,"2011-02-18",265.73,266.81,258.77999999999997,260.14999999999998,1234400,260.14999999999998,1,1,265.73,266.81,258.77999999999997,260.14999999999998,1234400]
[220,"2011-02-17",264.43,268,262.83999999999997,265.54000000000002,789700,265.54000000000002,1,1,264.43,268,262.83999999999997,265.54000000000002,789700]
[221,"2011-02-16",267.51,270.51,262.45,264.01,1333700,264.01,1,1,267.51,270.51,262.45,264.01,1333700]
[222,"2011-02-15",270.8,273.27,264.39999999999998,265.58,1228400,265.58,1,1,270.8,273.27,264.39999999999998,265.58,1228400]
[223,"2011-02-14",269.42,275,265.89999999999998,272.95,1430200,272.95,1,1,269.42,275,265.89999999999998,272.95,1430200]
[224,"2011-02-11",248.91,274.85000000000002,243.36,268.73,7349100,268.73,1,1,248.91,274.85000000000002,243.36,268.73,7349100]
[225,"2011-02-10",253.45,258.42,252.28,256.63,2081100,256.63,1,1,253.45,258.42,252.28,256.63,2081100]
[226,"2011-02-09",247.6,256.89999999999998,247.02,252.51,1153000,252.51,1,1,247.6,256.89999999999998,247.02,252.51,1153000]
[227,"2011-02-08",244.5,248.69,243.3,247.26,886600,247.26,1,1,244.5,248.69,243.3,247.26,886600]
[228,"2011-02-07",248.27,251.75,245.11,247.55,912800,247.55,1,1,248.27,251.75,245.11,247.55,912800]
[229,"2011-02-04",240.41,251.69,239.55,246.31,1711900,246.31,1,1,240.41,251.69,239.55,246.31,1711900]
[230,"2011-02-03",228.35,240,228.35,239.22,1119900,239.22,1,1,228.35,240,228.35,239.22,1119900]
[231,"2011-02-02",221.62,229.25,220.1,228.9,689500,228.9,1,1,221.62,229.25,220.1,228.9,689500]
[232,"2011-02-01",219.94,223.81,217.2,221.9,602600,221.9,1,1,219.94,223.81,217.2,221.9,602600]
[233,"2011-01-31",221.14,224.45,218.09,218.92,482000,218.92,1,1,221.14,224.45,218.09,218.92,482000]
[234,"2011-01-28",226.91,227.98,217,219.43,620400,219.43,1,1,226.91,227.98,217,219.43,620400]
[235,"2011-01-27",218.08,227.49,216.06,225.52,797400,225.52,1,1,218.08,227.49,216.06,225.52,797400]
[236,"2011-01-26",217.53,219.28,213.06,217.74,834000,217.74,1,1,217.53,219.28,213.06,217.74,834000]
[237,"2011-01-25",220,222,217.81,221.99,380100,221.99,1,1,220,222,217.81,221.99,380100]
[238,"2011-01-24",224.83,224.85,217.36,220.46,515200,220.46,1,1,224.83,224.85,217.36,220.46,515200]
[239,"2011-01-21",225.51,225.99,221.7,223.63,543700,223.63,1,1,225.51,225.99,221.7,223.63,543700]
[240,"2011-01-20",227.34,227.63,222.01,223.04,657700,223.04,1,1,227.34,227.63,222.01,223.04,657700]
[241,"2011-01-19",232.45,233.3,228,229.33,632900,229.33,1,1,232.45,233.3,228,229.33,632900]
[242,"2011-01-18",235.96,237.12,230.11,232.7,581900,232.7,1,1,235.96,237.12,230.11,232.7,581900]
[243,"2011-01-14",229.35,234.91,228.22,234.89,1218000,234.89,1,1,229.35,234.91,228.22,234.89,1218000]
[244,"2011-01-13",220.01,229.74,219.05,229.64,1421800,229.64,1,1,220.01,229.74,219.05,229.64,1421800]
[245,"2011-01-12",222.83,223.3,217,217.67,772600,217.67,1,1,222.83,223.3,217,217.67,772600]
[246,"2011-01-11",226.15,227.36,218.56,220.79,1039700,220.79,1,1,226.15,227.36,218.56,220.79,1039700]
[247,"2011-01-10",223.4,224.94,219.04,223.67,490700,223.67,1,1,223.4,224.94,219.04,223.67,490700]
[248,"2011-01-07",227.98,227.98,220,224.26,593200,224.26,1,1,227.98,227.98,220,224.26,593200]
[249,"2011-01-06",227.21,229.8,225.43,226.5,1047500,226.5,1,1,227.21,229.8,225.43,226.5,1047500]
[250,"2011-01-05",221.47,224.17,220.03,221,530600,221,1,1,221.47,224.17,220.03,221,530600]
[251,"2011-01-04",222.61,228.47,216.96,222.37,1324800,222.37,1,1,222.61,228.47,216.96,222.37,1324800]
[252,"2011-01-03",215.26,224.84,214.16,223.63,1217000,223.63,1,1,215.26,224.84,214.16,223.63,1217000]
[253,"2010-12-31",217.41,217.91,212.58,212.66,653400,212.66,1,1,217.41,217.91,212.58,212.66,653400]
[254,"2010-12-30",220.14,221.98,217.05,217.77,521000,217.77,1,1,220.14,221.98,217.05,217.77,521000]
[255,"2010-12-29",220.7,223.52,219.41,221.06,554400,221.06,1,1,220.7,223.52,219.41,221.06,554400]
[256,"2010-12-28",222.72,224.99,219.03,220.04,921400,220.04,1,1,222.72,224.99,219.03,220.04,921400]
[257,"2010-12-27",223.5,225.46,219.37,222.73,1154800,222.73,1,1,223.5,225.46,219.37,222.73,1154800]
[258,"2010-12-23",231.7,233.96,227.36,228.29,520700,228.29,{"$f":"H273/F273","v":1},{"$f":"INDEX(OFFSET($T$15,0,0,$S$13+1,1),MATCH(B273,OFFSET($Q$15,0,0,$S$13+1,1),-1))","v":1},{"$f":"ROUND($I273*C273,2)","v":231.7},{"$f":"ROUND($I273*D273,2)","v":233.96},{"$f":"ROUND($I273*E273,2)","v":227.36},{"$f":"ROUND($I273*F273,2)","v":228.29},{"$f":"G273*J273","v":520700}]
[259,"2010-12-22",234.17,234.61,231.3,231.78,541300,231.78,1,1,234.17,234.61,231.3,231.78,541300]
[260,"2010-12-21",236.77,237.7,232.68,234.36,645800,234.36,1,1,236.77,237.7,232.68,234.36,645800]
[261,"2010-12-20",239.85,240.4,233.5,236.1,685100,236.1,1,1,239.85,240.4,233.5,236.1,685100]
[262,"2010-12-17",236.18,239.95,233.23,238.02,1099600,238.02,1,1,236.18,239.95,233.23,238.02,1099600]
[263,"2010-12-16",229.57,235.64,229.23,234.77,1029900,234.77,1,1,229.57,235.64,229.23,234.77,1029900]
[264,"2010-12-15",227.32,234.85,225.5,226.79,1096400,226.79,1,1,227.32,234.85,225.5,226.79,1096400]
[265,"2010-12-14",225.56,230.6,221.41,227.9,1316800,227.9,1,1,225.56,230.6,221.41,227.9,1316800]
[266,"2010-12-13",239.67,239.74,225.73,226.11,1209000,226.11,1,1,239.67,239.74,225.73,226.11,1209000]
[267,"2010-12-10",236.21,239,234.39,238.22,494200,238.22,1,1,236.21,239,234.39,238.22,494200]
[268,"2010-12-09",238.75,238.89,232.02,235.63,818400,235.63,1,1,238.75,238.89,232.02,235.63,818400]
[269,"2010-12-08",242.39,242.79,234.25,236.17,828600,236.17,1,1,242.39,242.79,234.25,236.17,828600]
[270,"2010-12-07",245.97,245.97,239.04,241.54,1014300,241.54,1,1,245.97,245.97,239.04,241.54,1014300]
[271,"2010-12-06",235.28,242.22,233.42,241.06,1457700,241.06,1,1,235.28,242.22,233.42,241.06,1457700]
[272,"2010-12-03",244.14,247.38,231,235.95,4049700,235.95,1,1,244.14,247.38,231,235.95,4049700]
[273,"2010-12-02",258.33,258.75,249.18,250.96,1657000,250.96,1,1,258.33,258.75,249.18,250.96,1657000]
[274,"2010-12-01",261.54000000000002,262,255,258.82,1266800,258.82,1,1,261.54000000000002,262,255,258.82,1266800]
[275,"2010-11-30",256.14,262.77,255.36,258.49,2382400,258.49,1,1,256.14,262.77,255.36,258.49,2382400]
[276,"2010-11-29",254.74,257.79000000000002,250.13,257.01,970700,257.01,1,1,254.74,257.79000000000002,250.13,257.01,970700]
[277,"2010-11-26",249,256.49,248.41,255.65,784500,255.65,1,1,249,256.49,248.41,255.65,784500]
[278,"2010-11-24",248.02,250.51,247.22,250.19,957200,250.19,1,1,248.02,250.51,247.22,250.19,957200]
[279,"2010-11-23",240.74,244.1,238.66,243.9,892000,243.9,1,1,240.74,244.1,238.66,243.9,892000]
[280,"2010-11-22",232.04,243.98,231.09,242.92,1331900,242.92,1,1,232.04,243.98,231.09,242.92,1331900]
[281,"2010-11-19",229.94,232.96,228.01,232.27,748000,232.27,1,1,229.94,232.96,228.01,232.27,748000]
[282,"2010-11-18",230.69,231.99,226.8,227.64,1097800,227.64,1,1,230.69,231.99,226.8,227.64,1097800]
[283,"2010-11-17",225,231.8,224.5,230.96,650500,230.96,1,1,225,231.8,224.5,230.96,650500]
[284,"2010-11-16",229.58,232.95,223.01,225.09,935000,225.09,1,1,229.58,232.95,223.01,225.09,935000]
[285,"2010-11-15",236.14,236.65,230.02,230.37,705000,230.37,1,1,236.14,236.65,230.02,230.37,705000]
[286,"2010-11-12",236.51,239.88,230.7,234.02,1082400,234.02,1,1,236.51,239.88,230.7,234.02,1082400]
[287,"2010-11-11",234.97,240.78,234.36,237.76,1132400,237.76,1,1,234.97,240.78,234.36,237.76,1132400]
[288,"2010-11-10",227.31,236.55,225.35,236.55,1154700,236.55,1,1,227.31,236.55,225.35,236.55,1154700]
[289,"2010-11-09",231.44,231.5,225.2,227.34,874600,227.34,1,1,231.44,231.5,225.2,227.34,874600]
[290,"2010-11-08",228.98,232,227.43,229.9,707800,229.9,1,1,228.98,232,227.43,229.9,707800]
[291,"2010-11-05",223,232.33,222.5,230.56,1382000,230.56,1,1,223,232.33,222.5,230.56,1382000]
[292,"2010-11-04",221.24,223.32,220.03,222.86,843500,222.86,1,1,221.24,223.32,220.03,222.86,843500]
[293,"2010-11-03",215.68,219.32,215.09,219.32,815900,219.32,1,1,215.68,219.32,215.09,219.32,815900]
[294,"2010-11-02",212.5,215.21,211.13,215.21,576700,215.21,1,1,212.5,215.21,211.13,215.21,576700]
[295,"2010-11-01",211.89,213.25,209,211.08,444800,211.08,1,1,211.89,213.25,209,211.08,444800]
[296,"2010-10-29",209.82,211.98,208.75,210.21,380700,210.21,1,1,209.82,211.98,208.75,210.21,380700]
[297,"2010-10-28",213.78,213.8,207.55,210.42,633000,210.42,1,1,213.78,213.8,207.55,210.42,633000]
[298,"2010-10-27",210.7,212.35,209.11,212.3,814800,212.3,1,1,210.7,212.35,209.11,212.3,814800]
[299,"2010-10-26",205,215.38,204.6,212.86,1652400,212.86,1,1,205,215.38,204.6,212.86,1652400]
[300,"2010-10-25",207,208.37,203.52,205.65,1442700,205.65,1,1,207,208.37,203.52,205.65,1442700]
[301,"2010-10-22",188.98,207.94,188.5,205.77,4101200,205.77,1,1,188.98,207.94,188.5,205.77,4101200]
[302,"2010-10-21",181.72,182.99,178.09,179.25,1230100,179.25,1,1,181.72,182.99,178.09,179.25,1230100]
[303,"2010-10-20",182.76,182.99,180.46,180.75,738700,180.75,1,1,182.76,182.99,180.46,180.75,738700]
[304,"2010-10-19",181.56,183.98,180.18,181.86,690300,181.86,1,1,181.56,183.98,180.18,181.86,690300]
[305,"2010-10-18",182.96,184.47,182.18,183.69,585300,183.69,1,1,182.96,184.47,182.18,183.69,585300]
[306,"2010-10-15",182.47,182.67,179.21,181.87,625600,181.87,1,1,182.47,182.67,179.21,181.87,625600]
[307,"2010-10-14",180.65,181.33,179.41,181.27,374700,181.27,1,1,180.65,181.33,179.41,181.27,374700]
[308,"2010-10-13",181.91,182.96,180.05,180.98,737500,180.98,1,1,181.91,182.96,180.05,180.98,737500]
[309,"2010-10-12",178.36,181.4,176.5,180.91,586000,180.91,1,1,178.36,181.4,176.5,180.91,586000]
[310,"2010-10-11",176.56,180.55,176.29,178.6,544600,178.6,1,1,176.56,180.55,176.29,178.6,544600]
[311,"2010-10-08",177,177.79,174.84,176.56,523900,176.56,1,1,177,177.79,174.84,176.56,523900]
[312,"2010-10-07",176.01,177.5,174.38,177.01,641800,177.01,1,1,176.01,177.5,174.38,177.01,641800]
[313,"2010-10-06",177.2,178.24,173.55,174.82,984700,174.82,1,1,177.2,178.24,173.55,174.82,984700]
[314,"2010-10-05",174.37,179.5,174.37,178.98,734500,178.98,1,1,174.37,179.5,174.37,178.98,734500]
[315,"2010-10-04",173.77,174.72,171.24,172.96,565300,172.96,1,1,173.77,174.72,171.24,172.96,565300]
[316,"2010-10-01",173.8,175,172.26,174.5,689900,174.5,1,1,173.8,175,172.26,174.5,689900]
[317,"2010-09-30",177.11,177.69,172,172,695800,172,1,1,177.11,177.69,172,172,695800]
[318,"2010-09-29",175.94,177.18,175.2,176.03,677200,176.03,1,1,175.94,177.18,175.2,176.03,677200]
[319,"2010-09-28",176.4,176.99,172.06,176.67,787500,176.67,1,1,176.4,176.99,172.06,176.67,787500]
[320,"2010-09-27",173.58,176.41,172.83,175.83,662600,175.83,1,1,173.58,176.41,172.83,175.83,662600]
[321,"2010-09-24",168.5,173.19,168.5,173.19,871300,173.19,1,1,168.5,173.19,168.5,173.19,871300]
[322,"2010-09-23",164.66,168.25,164.26,166.66,484300,166.66,{"$f":"H337/F337","v":1},{"$f":"INDEX(OFFSET($T$15,0,0,$S$13+1,1),MATCH(B337,OFFSET($Q$15,0,0,$S$13+1,1),-1))","v":1},{"$f":"ROUND($I337*C337,2)","v":164.66},{"$f":"ROUND($I337*D337,2)","v":168.25},{"$f":"ROUND($I337*E337,2)","v":164.26},{"$f":"ROUND($I337*F337,2)","v":166.66},{"$f":"G337*J337","v":484300}]
[323,"2010-09-22",167.59,169.17,165.18,165.74,461600,165.74,1,1,167.59,169.17,165.18,165.74,461600]
[324,"2010-09-21",170.54,171.46,167.85,168.31,457700,168.31,1,1,170.54,171.46,167.85,168.31,457700]
[325,"2010-09-20",168.66,170.95,167.04,170.13,507400,170.13,1,1,168.66,170.95,167.04,170.13,507400]
[326,"2010-09-17",167.54,168.72,165.5,168.31,514200,168.31,1,1,167.54,168.72,165.5,168.31,514200]
[327,"2010-09-16",168.53,169.61,165.01,167.03,828300,167.03,1,1,168.53,169.61,165.01,167.03,828300]
[328,"2010-09-15",167.71,169.8,167.17,169.66,477300,169.66,1,1,167.71,169.8,167.17,169.66,477300]
[329,"2010-09-14",167.69,170,166.45,168.52,785200,168.52,1,1,167.69,170,166.45,168.52,785200]
[330,"2010-09-13",167.5,169.18,167,168.37,689400,168.37,1,1,167.5,169.18,167,168.37,689400]
[331,"2010-09-10",163.4,167.28,162.24,166.01,596700,166.01,1,1,163.4,167.28,162.24,166.01,596700]
[332,"2010-09-09",165.05,166.29,162.09,162.82,625300,162.82,1,1,165.05,166.29,162.09,162.82,625300]
[333,"2010-09-08",165.67,167.04,164.41,166.05,538600,166.05,1,1,165.67,167.04,164.41,166.05,538600]
[334,"2010-09-07",163.21,164.99,161.13,164.78,608700,164.78,1,1,163.21,164.99,161.13,164.78,608700]
[335,"2010-09-03",165.88,166.52,162.29,163.51,726000,163.51,1,1,165.88,166.52,162.29,163.51,726000]
[336,"2010-09-02",161.49,164.19,159.97999999999999,164.19,1117500,164.19,1,1,161.49,164.19,159.97999999999999,164.19,1117500]
[337,"2010-09-01",152.88,159.54,151.63,159.41,1573000,159.41,1,1,152.88,159.54,151.63,159.41,1573000]
[338,"2010-08-31",148.38999999999999,151.85,148.19999999999999,150.83000000000001,445200,150.83000000000001,1,1,148.38999999999999,151.85,148.19999999999999,150.83000000000001,445200]
[339,"2010-08-30",153.68,153.87,148.84,148.84,532300,148.84,1,1,153.68,153.87,148.84,148.84,532300]

{"sheet":"CorrelationCandidates","index":2,"n_rows":511,"n_cols":15,"rows_kept":511,"cut":false,"hidden":false,"merged":[[7,10,8,10]]}
["Stocks and Indexes for which I want pair-wise correlation values",null,null,null,"Correlation Period  rough in: ","2011-01-01","to","2012-01-01"," <= hard end date",null,null,"Symbol Retrieval Stats"]
["Only need list of valid symbols in column A starting in row 10.",null,null,null,null,250,"Number of bars I want to use as the correlation window.",null,null,null,null,{"$f":"COUNTA(OFFSET($A$9,1,0,40000,1))","v":502}," Candidate Symbols"]
["All of the other fields will be filled in as the data for each symbol is retrieved.",null,null,null,null,{"$f":"WORKDAY(H1,-(250+100))","v":"2010-08-30"},"Earliest date to retrieve (with 100 days of padding).",null,null,null,{"$f":"L3/L2","v":0.19721115537848605},99," Completed",{"$f":"IFERROR(J5/L3,0)","v":"00:00:04.778"}," Average Elapsed / symbol"]
[null,null,null,null,null,null,null,"Data Retrieval Start: ","2015-02-11T14:50:32","Elapsed",null,{"$f":"L2-L3","v":403}," Remaining",{"$f":"N3*L4","v":"00:32:05.444"}," Est. Time Remaining"]
[{"$f":"COUNTIF(OFFSET(K9,1,0,L2,1),\">=\"&F2)","v":0},{"$f":"\"Symbols with at least the required \" & F2 & \" bars.\"","v":"Symbols with at least the required 250 bars."},null,null,null,null,null,"Data Retrieval End: ","2015-02-11T14:58:25",{"$f":"I5-I4","v":"00:07:53"},null,"Correlation Stats",null,"2015-02-11T15:30:30"," ETA"]
[null,null,null,null,null,null,null,"Correlation End: ","2015-02-11T14:58:25",{"$f":"I6-I5","v":"00:00:00"},null,{"$f":"A5*(A5-1)/2","v":0},{"$f":"\" Possible pairings when using \" & A5 & \" symbols.\"","v":" Possible pairings when using 0 symbols."}]
["Symbol",null,null,null,null,null,null,"Total Elapsed: ",{"$f":"J5+J6","v":"00:07:53"},null,{"$f":"L7/L6","v":{"$error":"#DIV/0!"}},{"$f":"RawCorrelations!A4","v":0}," Completed",{"$f":"IFERROR(J6/L7,0)","v":"00:00:00"}," Average Elapsed per Pairing"]
["To","Description","Last Trade as of most recent check",null,null,null,null,null,null,null,"Bars Available",{"$f":"L6-L7","v":0}," Remaining",{"$f":"N7*L8","v":"00:00:00"}," Est time remaining"]
["Correlate",null,"Date","Time","Open","High","Low","Close","Volume","Change",null,null,null,"2015-02-11T14:56:36"," ETA"]
["MMM"]
["ABT"]
["ABBV"]
["ACE"]
["ACN"]
["ACT"]
["ADBE"]
["ADT"]
["AES"]
["AET"]
["AFL"]
["AMG"]
["A"]
["GAS"]
["APD"]
["ARG"]
["AKAM"]
["AA"]
["ALXN"]
["ATI"]
["ALLE"]
["AGN"]
["ADS"]
["ALL"]
["ALTR"]
["MO"]
["AMZN"]
["AEE"]
["AEP"]
["AXP"]
["AIG"]
["AMT"]
["AMP"]
["ABC"]
["AME"]
["AMGN"]
["APH"]
["APC"]
["ADI"]
["AON"]
["APA"]
["AIV"]
["AAPL"]
["AMAT"]
["ADM"]
["AIZ"]
["T"]
["ADSK"]
["ADP"]
["AN"]
["AZO"]
["AVGO"]
["AVB"]
["AVY"]
["AVP"]
["BHI"]
["BLL"]
["BAC"]
["BK"]
["BCR"]
["BAX"]
["BBT"]
["BDX"]
["BBBY"]
["BRK-B"]
["BBY"]
["BIIB"]
["BLK"]
["HRB"]
["BA"]
["BWA"]
["BXP"]
["BSX"]
["BMY"]
["BRCM"]
["BF-B"]
["CHRW"]
["CA"]
["CVC"]
["COG"]
["CAM"]
["CPB"]
["COF"]
["CAH"]
["CFN"]
["KMX"]
["CCL"]
["CAT"]
["CBG"]
["CBS"]
["CELG"]
["CNP"]
["CTL"]
["CERN"]
["CF"]
["SCHW"]
["CHK"]
["CVX"]
["CMG"]
["CB"]
["CI"]
["XEC"]
["CINF"]
["CTAS"]
["CSCO"]
["C"]
["CTXS"]
["CLX"]
["CME"]
["CMS"]
["COH"]
["KO"]
["CCE"]
["CTSH"]
["CL"]
["CMCSA"]
["CMA"]
["CSC"]
["CAG"]
["COP"]
["CNX"]
["ED"]
["STZ"]
["GLW"]
["COST"]
["CCI"]
["CSX"]
["CMI"]
["CVS"]
["DHI"]
["DHR"]
["DRI"]
["DVA"]
["DE"]
["DLPH"]
["DAL"]
["DNR"]
["XRAY"]
["DVN"]
["DO"]
["DTV"]
["DFS"]
["DISCA"]
["DISCK"]
["DG"]
["DLTR"]
["D"]
["DOV"]
["DOW"]
["DPS"]
["DTE"]
["DD"]
["DUK"]
["DNB"]
["ETFC"]
["EMN"]
["ETN"]
["EBAY"]
["ECL"]
["EIX"]
["EW"]
["EA"]
["EMC"]
["EMR"]
["ENDP"]
["ESV"]
["ETR"]
["EOG"]
["EQT"]
["EFX"]
["EQR"]
["ESS"]
["EL"]
["EXC"]
["EXPE"]
["EXPD"]
["ESRX"]
["XOM"]
["FFIV"]
["FB"]
["FDO"]
["FAST"]
["FDX"]
["FIS"]
["FITB"]
["FSLR"]
["FE"]
["FISV"]
["FLIR"]
["FLS"]
["FLR"]
["FMC"]
["FTI"]
["F"]
["FOSL"]
["BEN"]
["FCX"]
["FTR"]
["GME"]
["GCI"]
["GPS"]
["GRMN"]
["GD"]
["GE"]
["GGP"]
["GIS"]
["GM"]
["GPC"]
["GNW"]
["GILD"]
["GS"]
["GT"]
["GOOGL"]
["GOOG"]
["GWW"]
["HAL"]
["HOG"]
["HAR"]
["HRS"]
["HIG"]
["HAS"]
["HCA"]
["HCP"]
["HCN"]
["HP"]
["HES"]
["HPQ"]
["HD"]
["HON"]
["HRL"]
["HSP"]
["HST"]
["HCBK"]
["HUM"]
["HBAN"]
["ITW"]
["IR"]
["TEG"]
["INTC"]
["ICE"]
["IBM"]
["IP"]
["IPG"]
["IFF"]
["INTU"]
["ISRG"]
["IVZ"]
["IRM"]
["JEC"]
["JNJ"]
["JCI"]
["JOY"]
["JPM"]
["JNPR"]
["KSU"]
["K"]
["KEY"]
["GMCR"]
["KMB"]
["KIM"]
["KMI"]
["KLAC"]
["KSS"]
["KRFT"]
["KR"]
["LB"]
["LLL"]
["LH"]
["LRCX"]
["LM"]
["LEG"]
["LEN"]
["LVLT"]
["LUK"]
["LLY"]
["LNC"]
["LLTC"]
["LMT"]
["L"]
["LO"]
["LOW"]
["LYB"]
["MTB"]
["MAC"]
["M"]
["MNK"]
["MRO"]
["MPC"]
["MAR"]
["MMC"]
["MAS"]
["MA"]
["MAT"]
["MKC"]
["MCD"]
["MHFI"]
["MCK"]
["MJN"]
["MWV"]
["MDT"]
["MRK"]
["MET"]
["KORS"]
["MCHP"]
["MU"]
["MSFT"]
["MHK"]
["TAP"]
["MDLZ"]
["MON"]
["MNST"]
["MCO"]
["MS"]
["MOS"]
["MSI"]
["MUR"]
["MYL"]
["NBR"]
["NDAQ"]
["NOV"]
["NAVI"]
["NTAP"]
["NFLX"]
["NWL"]
["NFX"]
["NEM"]
["NWSA"]
["NEE"]
["NLSN"]
["NKE"]
["NI"]
["NE"]
["NBL"]
["JWN"]
["NSC"]
["NTRS"]
["NOC"]
["NU"]
["NRG"]
["NUE"]
["NVDA"]
["ORLY"]
["OXY"]
["OMC"]
["OKE"]
["ORCL"]
["OI"]
["PCG"]
["PCAR"]
["PLL"]
["PH"]
["PDCO"]
["PAYX"]
["PNR"]
["PBCT"]
["POM"]
["PEP"]
["PKI"]
["PRGO"]
["PETM"]
["PFE"]
["PM"]
["PSX"]
["PNW"]
["PXD"]
["PBI"]
["PCL"]
["PNC"]
["RL"]
["PPG"]
["PPL"]
["PX"]
["PCP"]
["PCLN"]
["PFG"]
["PG"]
["PGR"]
["PLD"]
["PRU"]
["PEG"]
["PSA"]
["PHM"]
["PVH"]
["QEP"]
["PWR"]
["QCOM"]
["DGX"]
["RRC"]
["RTN"]
["RHT"]
["REGN"]
["RF"]
["RSG"]
["RAI"]
["RHI"]
["ROK"]
["COL"]
["ROP"]
["ROST"]
["RCL"]
["R"]
["CRM"]
["SNDK"]
["SCG"]
["SLB"]
["SNI"]
["STX"]
["SEE"]
["SRE"]
["SHW"]
["SIAL"]
["SPG"]
["SJM"]
["SNA"]
["SO"]
["LUV"]
["SWN"]
["SE"]
["STJ"]
["SWK"]
["SPLS"]
["SBUX"]
["HOT"]
["STT"]
["SRCL"]
["SYK"]
["STI"]
["SYMC"]
["SYY"]
["TROW"]
["TGT"]
["TEL"]
["TE"]
["THC"]
["TDC"]
["TSO"]
["TXN"]
["TXT"]
["HSY"]
["TRV"]
["TMO"]
["TIF"]
["TWX"]
["TWC"]
["TJX"]
["TMK"]
["TSS"]
["TSCO"]
["RIG"]
["TRIP"]
["FOXA"]
["TSN"]
["TYC"]
["USB"]
["UA"]
["UNP"]
["UNH"]
["UPS"]
["MLM"]
["URI"]
["UTX"]
["UHS"]
["UNM"]
["URBN"]
["VFC"]
["VLO"]
["VAR"]
["VTR"]
["VRSN"]
["VZ"]
["VRTX"]
["VIAB"]
["V"]
["VNO"]
["VMC"]
["WMT"]
["WBA"]
["DIS"]
["WM"]
["WAT"]
["ANTM"]
["WFC"]
["WDC"]
["WU"]
["WY"]
["WHR"]
["WFM"]
["WMB"]
["WIN"]
["WEC"]
["WYN"]
["WYNN"]
["XEL"]
["XRX"]
["XLNX"]
["XL"]
["XYL"]
["YHOO"]
["YUM"]
["ZMH"]
["ZION"]
["ZTS"]

{"sheet":"RawCorrelations","index":3,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Raw Symbol Correlation Pairs",null,null,null,null,null,null,null,null,"Outer Skips",1]
[{"$f":"COUNTA(OFFSET(CorrelationCandidates!A9,0,0,40000,1)) -1","v":502},"Symbols in Candidate pool",null,null,{"$f":"A2*(A2-1)/2","v":125751}," Potential unique pairings",null,null,null,"Inner Skips",71]
[{"$f":"CorrelationCandidates!A5","v":0},{"$f":"CorrelationCandidates!B5","v":"Symbols with at least the required 250 bars."},null,null,{"$f":"A3*(A3-1)/2","v":0}," Pairings can be generated with current data"]
[0,"Symbol Pair Combinations Correlated on this page"]
[{"$f":"A4/E3","v":{"$error":"#DIV/0!"}},"Complete",null,null,{"$f":"E2-E3","v":125751}," Potential pairings will not be generated due to insufficient bars for some symbols"]
["Pairs Correlation Log"]
["First Symbol","Second Symbol","Pair\nCorrelation Value"]

{"sheet":"SortedFilteredCorrelations","index":4,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Sort and Filter by Threshold and Max Entries"]
[null,null,0.72,"Absolute Correlation Threshold. Can specify out to 15 digits if you so choose"]
[null,null,500,"Max entries. A non-zero value is an absolute cut off for the number of result entries"]
[null,null,null,27131,"Raw Entries Satisfied the Correlation Threshold"]
[null,{"$f":"TEXT(COUNTA(A:A)-COUNTA(A1:A7),\"#,##0\")&\" Pairs in this\"","v":"0 Pairs in this"}]
[null,"Filtered Correlation List"]
["First Symbol","Second Symbol","Pair\nCorrelation Value"]

{"sheet":"S&P 500 Constituent Symbols","index":5,"n_rows":502,"n_cols":5,"rows_kept":502,"cut":false,"hidden":false,"merged":[]}
["MMM"]
["ABT"]
["ABBV",null,"Notes for this tab:"]
["ACE",null,null,"This S&P 500 constituents list was manually downloaded from a web resource.  "]
["ACN",null,null,"I manually cleaned it up by deleting extraneous stuff including hyperlinks that came along for the ride. "]
["ACT",null,null,"It may not be completely up to date, but should be good enough for demonstration purposes."]
["ADBE"]
["ADT"]
["AES",null,null,{"$f":"COUNTA(A1:A3000)","v":502},"  Total symbols. Thought that this was supposed to be just 500 long. Oh well, go with it."]
["AET",null,null,{"$f":"D9*(D9-1)/2","v":125751},"  Potential unique pairings (combinations taken 2 at a time with no duplicates)"]
["AFL"]
["AMG",null,null,"Several symbols in this list contain period (.) separators."]
["A",null,null,"When used with the Yahoo Finance price history downloading mechanism employed by this spreadsheet, "]
["GAS",null,null,"the period (.) must be replaced with a hyphen (-) or the symbol will not be found on the Yahoo server."]
["APD"]
["ARG",null,null,"This symbol list was copied to the CorrelationCandidates tab for price history retrieval and subsequent correlation processing."]
["AKAM",null,null,"  The period to hyphen substitution was manually performed as necessary on that tab."]
["AA"]
["ALXN"]
["ATI"]
["ALLE"]
["AGN"]
["ADS"]
["ALL"]
["ALTR"]
["MO"]
["AMZN"]
["AEE"]
["AEP"]
["AXP"]
["AIG"]
["AMT"]
["AMP"]
["ABC"]
["AME"]
["AMGN"]
["APH"]
["APC"]
["ADI"]
["AON"]
["APA"]
["AIV"]
["AAPL"]
["AMAT"]
["ADM"]
["AIZ"]
["T"]
["ADSK"]
["ADP"]
["AN"]
["AZO"]
["AVGO"]
["AVB"]
["AVY"]
["AVP"]
["BHI"]
["BLL"]
["BAC"]
["BK"]
["BCR"]
["BAX"]
["BBT"]
["BDX"]
["BBBY"]
["BRK.B"]
["BBY"]
["BIIB"]
["BLK"]
["HRB"]
["BA"]
["BWA"]
["BXP"]
["BSX"]
["BMY"]
["BRCM"]
["BF.B"]
["CHRW"]
["CA"]
["CVC"]
["COG"]
["CAM"]
["CPB"]
["COF"]
["CAH"]
["CFN"]
["KMX"]
["CCL"]
["CAT"]
["CBG"]
["CBS"]
["CELG"]
["CNP"]
["CTL"]
["CERN"]
["CF"]
["SCHW"]
["CHK"]
["CVX"]
["CMG"]
["CB"]
["CI"]
["XEC"]
["CINF"]
["CTAS"]
["CSCO"]
["C"]
["CTXS"]
["CLX"]
["CME"]
["CMS"]
["COH"]
["KO"]
["CCE"]
["CTSH"]
["CL"]
["CMCSA"]
["CMA"]
["CSC"]
["CAG"]
["COP"]
["CNX"]
["ED"]
["STZ"]
["GLW"]
["COST"]
["CCI"]
["CSX"]
["CMI"]
["CVS"]
["DHI"]
["DHR"]
["DRI"]
["DVA"]
["DE"]
["DLPH"]
["DAL"]
["DNR"]
["XRAY"]
["DVN"]
["DO"]
["DTV"]
["DFS"]
["DISCA"]
["DISCK"]
["DG"]
["DLTR"]
["D"]
["DOV"]
["DOW"]
["DPS"]
["DTE"]
["DD"]
["DUK"]
["DNB"]
["ETFC"]
["EMN"]
["ETN"]
["EBAY"]
["ECL"]
["EIX"]
["EW"]
["EA"]
["EMC"]
["EMR"]
["ENDP"]
["ESV"]
["ETR"]
["EOG"]
["EQT"]
["EFX"]
["EQR"]
["ESS"]
["EL"]
["EXC"]
["EXPE"]
["EXPD"]
["ESRX"]
["XOM"]
["FFIV"]
["FB"]
["FDO"]
["FAST"]
["FDX"]
["FIS"]
["FITB"]
["FSLR"]
["FE"]
["FISV"]
["FLIR"]
["FLS"]
["FLR"]
["FMC"]
["FTI"]
["F"]
["FOSL"]
["BEN"]
["FCX"]
["FTR"]
["GME"]
["GCI"]
["GPS"]
["GRMN"]
["GD"]
["GE"]
["GGP"]
["GIS"]
["GM"]
["GPC"]
["GNW"]
["GILD"]
["GS"]
["GT"]
["GOOGL"]
["GOOG"]
["GWW"]
["HAL"]
["HOG"]
["HAR"]
["HRS"]
["HIG"]
["HAS"]
["HCA"]
["HCP"]
["HCN"]
["HP"]
["HES"]
["HPQ"]
["HD"]
["HON"]
["HRL"]
["HSP"]
["HST"]
["HCBK"]
["HUM"]
["HBAN"]
["ITW"]
["IR"]
["TEG"]
["INTC"]
["ICE"]
["IBM"]
["IP"]
["IPG"]
["IFF"]
["INTU"]
["ISRG"]
["IVZ"]
["IRM"]
["JEC"]
["JNJ"]
["JCI"]
["JOY"]
["JPM"]
["JNPR"]
["KSU"]
["K"]
["KEY"]
["GMCR"]
["KMB"]
["KIM"]
["KMI"]
["KLAC"]
["KSS"]
["KRFT"]
["KR"]
["LB"]
["LLL"]
["LH"]
["LRCX"]
["LM"]
["LEG"]
["LEN"]
["LVLT"]
["LUK"]
["LLY"]
["LNC"]
["LLTC"]
["LMT"]
["L"]
["LO"]
["LOW"]
["LYB"]
["MTB"]
["MAC"]
["M"]
["MNK"]
["MRO"]
["MPC"]
["MAR"]
["MMC"]
["MAS"]
["MA"]
["MAT"]
["MKC"]
["MCD"]
["MHFI"]
["MCK"]
["MJN"]
["MWV"]
["MDT"]
["MRK"]
["MET"]
["KORS"]
["MCHP"]
["MU"]
["MSFT"]
["MHK"]
["TAP"]
["MDLZ"]
["MON"]
["MNST"]
["MCO"]
["MS"]
["MOS"]
["MSI"]
["MUR"]
["MYL"]
["NBR"]
["NDAQ"]
["NOV"]
["NAVI"]
["NTAP"]
["NFLX"]
["NWL"]
["NFX"]
["NEM"]
["NWSA"]
["NEE"]
["NLSN"]
["NKE"]
["NI"]
["NE"]
["NBL"]
["JWN"]
["NSC"]
["NTRS"]
["NOC"]
["NU"]
["NRG"]
["NUE"]
["NVDA"]
["ORLY"]
["OXY"]
["OMC"]
["OKE"]
["ORCL"]
["OI"]
["PCG"]
["PCAR"]
["PLL"]
["PH"]
["PDCO"]
["PAYX"]
["PNR"]
["PBCT"]
["POM"]
["PEP"]
["PKI"]
["PRGO"]
["PETM"]
["PFE"]
["PM"]
["PSX"]
["PNW"]
["PXD"]
["PBI"]
["PCL"]
["PNC"]
["RL"]
["PPG"]
["PPL"]
["PX"]
["PCP"]
["PCLN"]
["PFG"]
["PG"]
["PGR"]
["PLD"]
["PRU"]
["PEG"]
["PSA"]
["PHM"]
["PVH"]
["QEP"]
["PWR"]
["QCOM"]
["DGX"]
["RRC"]
["RTN"]
["RHT"]
["REGN"]
["RF"]
["RSG"]
["RAI"]
["RHI"]
["ROK"]
["COL"]
["ROP"]
["ROST"]
["RCL"]
["R"]
["CRM"]
["SNDK"]
["SCG"]
["SLB"]
["SNI"]
["STX"]
["SEE"]
["SRE"]
["SHW"]
["SIAL"]
["SPG"]
["SJM"]
["SNA"]
["SO"]
["LUV"]
["SWN"]
["SE"]
["STJ"]
["SWK"]
["SPLS"]
["SBUX"]
["HOT"]
["STT"]
["SRCL"]
["SYK"]
["STI"]
["SYMC"]
["SYY"]
["TROW"]
["TGT"]
["TEL"]
["TE"]
["THC"]
["TDC"]
["TSO"]
["TXN"]
["TXT"]
["HSY"]
["TRV"]
["TMO"]
["TIF"]
["TWX"]
["TWC"]
["TJX"]
["TMK"]
["TSS"]
["TSCO"]
["RIG"]
["TRIP"]
["FOXA"]
["TSN"]
["TYC"]
["USB"]
["UA"]
["UNP"]
["UNH"]
["UPS"]
["MLM"]
["URI"]
["UTX"]
["UHS"]
["UNM"]
["URBN"]
["VFC"]
["VLO"]
["VAR"]
["VTR"]
["VRSN"]
["VZ"]
["VRTX"]
["VIAB"]
["V"]
["VNO"]
["VMC"]
["WMT"]
["WBA"]
["DIS"]
["WM"]
["WAT"]
["ANTM"]
["WFC"]
["WDC"]
["WU"]
["WY"]
["WHR"]
["WFM"]
["WMB"]
["WIN"]
["WEC"]
["WYN"]
["WYNN"]
["XEL"]
["XRX"]
["XLNX"]
["XL"]
["XYL"]
["YHOO"]
["YUM"]
["ZMH"]
["ZION"]
["ZTS"]