{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Yahoo Share Data","Yahoo Tags"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":209,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Yahoo Share Data","index":0,"n_rows":36,"n_cols":20,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["URL =",null,"http://download.finance.yahoo.com/d/quotes.csv?s=wmt+gs+vrsn+nov+meg+ups+lee+^NDX+AAPL+HPQ+IBM+INTC+nab.ax+MCD+V+DIS+MSFT+^FTSE+VOD.L+TSCO.L+SBRY.L&f=nd1t1l1ohgc1p2wj1ryr5m3m8m4m6"]
["Yahoo tags =",null,"nd1t1l1ohgc1p2wj1ryr5m3m8m4m6"]
[]
["DETAILS",null,null,"DATA",null,null,null,null,null,null,null,null,"VALUATION","FUNDAMENTALS",null,null,"TECHNICAL"]
["Code",null,"Company","Date","Time","Last","Open","High","Low","Change","% Chg","52w Range","Market Cap.","PE","Div Yield","PEG","50day MA","% Diff","200day MA","% Diff"]
[]
["wmt",null,"Wal-Mart Stores","2016-11-30","10:49am",71.155000000000001,70.92,71.155000000000001,70.55,-0.215,-3.0100000000000001E-3,"58.320 - 75.190","219.80B",15.435,2.81,8.9700000000000006,69.575000000000003,2.2700000000000001E-2,71.284000000000006,-1.81E-3]
["gs",null,"Goldman Sachs Group","2016-11-30","10:49am",218.86,215.2,220.2,214.97,7.11,3.3599999999999998E-2,"138.20 - 220.20","91.66B",17.559999999999999,1.23,0.82,186.97,0.1706,166.34,0.31569999999999998]
["vrsn",null,"VeriSign","2016-11-30","10:49am",78.790000000000006,79.12,79.19,78.540000000000006,-0.33,-4.1999999999999997E-3,"70.26 - 93.94","8.24B",23.6,0,0,79.59,-0.01,81.05,-2.7900000000000001E-2]
["nov",null,"National Oilwell Varco","2016-11-30","10:49am",36.619999999999997,36.14,36.799999999999997,35.85,2.0699999999999998,5.9900000000000002E-2,"25.74 - 38.55","13.83B","N/A",0.56000000000000005,5.65,34.979999999999997,4.7E-2,34.020000000000003,7.6300000000000007E-2]
["meg",null,"Media General","2016-11-30","10:49am",18.440000000000001,18.32,18.48,18.32,0.11,6.0000000000000001E-3,"14.00 - 18.70","2.38B","N/A",0,0,17.66,4.4200000000000003E-2,17.68,4.2799999999999998E-2]
["ups",null,"United Parcel Servicem","2016-11-30","10:49am",116.56,116.46,116.96,116.15,0.28000000000000003,2.3999999999999998E-3,"87.30 - 116.96","101.72B",20.77,2.68,2.16,110.4,5.5800000000000002E-2,108.14,7.7799999999999994E-2]
["lee",null,"Lee Enterprises","2016-11-30","10:47am",3.15,3.3,3.3,3.1,-0.1,-3.0800000000000001E-2,"1.15 - 3.92","175.68M",3.84,0,0,2.84,0.1089,2.5299999999999998,0.24460000000000001]
["^NDX",null,"NASDAQ-100","2016-11-30","11:04am",4844.7700000000004,4876.3,4880.76,4839.82,-28.44,-5.7999999999999996E-3,"3888.78 - 4911.76","N/A","N/A","N/A",0,"N/A","N/A","N/A","N/A"]
["AAPL",null,"Apple Inc.","2016-11-30","10:49am",110.78,111.6,112.2,110.54,-0.68,-6.1000000000000004E-3,"89.47 - 119.86","590.71B",13.33,2.04,1.41,112.99,-1.95E-2,105.64,4.8599999999999997E-2]
["HPQ",null,"HP Inc. Common Stock","2016-11-30","10:49am",15.24,15.17,15.27,15.1,0.09,5.8999999999999999E-3,"8.91 - 16.19","26.09B",10.64,3.5,2.4300000000000002,14.93,2.0500000000000001E-2,14.09,8.1799999999999998E-2]
["IBM",null,"International Business Machines","2016-11-30","10:49am",163.03110000000001,163.35,163.80000000000001,162.6,-0.49890000000000001,-3.0509999999999999E-3,"116.9000 - 165.0000","155.02B",13.2837,3.43,0,155.80699999999999,4.6365999999999997E-2,155.93600000000001,4.5499999999999999E-2]
["INTC",null,"Intel Corporation","2016-11-30","10:49am",35.130000000000003,35.200000000000003,35.299999999999997,35.03,-0.18,-5.1000000000000004E-3,"27.68 - 38.36","166.48B",16.489999999999998,2.93,1.33,35.380000000000003,-7.1999999999999998E-3,34.520000000000003,1.78E-2]
["nab.ax",null,"NAT. BANK FPO","2016-11-30","4:10pm",28.93,28.87,28.99,28.66,0.17,5.8999999999999999E-3,"23.82 - 29.49","76.59B",186.65,"N/A",5.84,27.8,4.0800000000000003E-2,26.96,7.3200000000000001E-2]
["MCD",null,"McDonald's Corporation Common S","2016-11-30","10:49am",120.1,120.22,120.49,119.7,-0.57999999999999996,-4.7999999999999996E-3,"110.33 - 131.96","99.74B",22.56,3.12,2.16,114.91,4.5199999999999997E-2,118.44,1.4E-2]
["V",null,"Visa Inc.","2016-11-30","10:49am",78.13,79.45,79.45,77.8,-1.02,-1.29E-2,"66.12 - 83.96","182.82B",30.87,0.82,0,81.48,-4.1099999999999998E-2,80.040000000000006,-2.3800000000000002E-2]
["DIS",null,"Walt Disney Company (The) Commo","2016-11-30","10:49am",99.95,99.35,99.98,99,0.28000000000000003,2.8E-3,"86.25 - 115.47","159.07B",17.440000000000001,1.44,1.6,94.49,5.7700000000000001E-2,96.01,4.1000000000000002E-2]
["MSFT",null,"Microsoft Corporation","2016-11-30","10:49am",60.86,60.86,61.18,60.64,-0.23,-3.8E-3,"48.03 - 61.37","473.21B",29.15,2.58,2.12,59.3,2.63E-2,55.89,8.8999999999999996E-2]
["^FTSE",null,"FTSE 100","2016-11-30","4:04pm",6805.96,6772,6845.74,6765.23,33.96,5.0000000000000001E-3,"6676.60 - 6997.30","N/A","N/A","N/A",0,"N/A","N/A","N/A","N/A"]
["VOD.L",null,"VODAFONE GROUP PLC ORD USD0.20 ","2016-11-30","3:49pm",195.55,192.75,197.75,192.5,1.3,6.7000000000000002E-3,"192.50 - 240.10","54.58B","N/A","N/A",1.6,215.34,-9.1899999999999996E-2,223.52,-0.12509999999999999]
["TSCO.L",null,"TESCO PLC ORD 5P","2016-11-30","3:49pm",210.15,208.25,212.65,207.3,1.3,6.1999999999999998E-3,"137.00 - 219.00","17.11B",41.21,"N/A",0.8,208.37,8.5000000000000006E-3,176.49,0.19070000000000001]
["SBRY.L",null,"SAINSBURY (J) PLC ORD 28 4/7P","2016-11-30","3:49pm",232.8,232.5,234.78,229.91,-0.4,-1.6999999999999999E-3,"211.50 - 294.40","4.55B",9.99,"N/A",-5.2,240.66,-3.2599999999999997E-2,240.24,-3.1E-2]
[null,null," "]
[]
[]
[]
[]
[null,null,"Advanced"]
[null,null,"Select the data fields you wish to pull from Yahoo"]
[null,null,"Enter the Yahoo tags in C1 "]
[null,null,"You will need to change the headers in Row 5"]

{"sheet":"Yahoo Tags","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}