{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["controlrm","l_finance"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"controlrm","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Share Price Trend Web Scraper"]

{"sheet":"l_finance","index":1,"n_rows":100,"n_cols":6,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["symbol","name","last_trade","change","volume","segment"]
["BARC.L","Barclays PLC","226.00 13:12","Down 4.15 (1.80%)",14024746,"Banking"]
["HSBA.L","HSBC Holdings PLC","592.00 13:12","Down 11.50 (1.91%)",5447797,"Banking"]
["LLOY.L","Lloyds Banking Group PLC","76.37 13:13","Down 0.49 (0.64%)",33216060,"Banking"]
["RBS.L","Royal Bank of Scotland Group PLC","364.90 13:13","Down 7.10 (1.91%)",2365734,"Banking"]
["STAN.L","Standard Chartered PLC","889.80 13:13","Down 8.30 (0.92%)",2093098,"Banking"]
["DGE.L","Diageo PLC","1,784.50 13:13","Down 42.50 (2.33%)",1373560,"Beverages"]
["SAB.L","SABMiller PLC","3,193.00 13:13","Down 42.50 (1.31%)",900169,"Beverages"]
["CRH.L","CRH PLC","1,462.00 13:11","Down 13.00 (0.88%)",591745,"Building materials"]
["WOS.L","Wolseley PLC","3,566.00 13:11","Down 40.00 (1.11%)",292974,"Building materials"]
["JMAT.L","Johnson Matthey PLC","3,255.00 13:11","Down 44.00 (1.33%)",133893,"Chemicals"]
["BAB.L","Babcock International Group PLC","1,043.00 13:11","Down 18.00 (1.70%)",515249,"Consulting"]
["CCH.L","COCA-COLA HBC N","1,229.00 13:11","Up 8.00 (0.66%)",340456,"Consumer"]
["RB.L","Reckitt Benckiser Group PLC","5,050.00 13:12","Up 10.00 (0.20%)",342749,"Consumer goods"]
["ULVR.L","Unilever PLC","2,555.00 13:11","Down 18.00 (0.70%)",1336605,"Consumer goods"]
["CNA.L","Centrica PLC","267.10 13:11","Down 2.90 (1.07%)",2699091,"Energy"]
["NG.L","National Grid PLC","885.50 13:13","Up 8.50 (0.97%)",4179960,"Energy"]
["SSE.L","SSE PLC","1,602.00 13:13","Down 22.00 (1.35%)",552407,"Energy"]
["ARM.L","ARM Holdings PLC","920.50 13:12","Down 14.50 (1.55%)",912610,"Engineering"]
["IMI.L","IMI PLC","1,166.00 13:08","Down 19.00 (1.60%)",275916,"Engineering"]
["MGGT.L","Meggitt PLC","484.80 13:13","Down 2.50 (0.51%)",732007,"Engineering"]
["SMIN.L","Smiths Group PLC","1,035.00 13:09","Down 11.00 (1.05%)",362744,"Engineering"]
["WEIR.L","Weir Group PLC","1,781.00 13:11","Down 1.00 (0.06%)",705176,"Engineering"]
["BRBY.L","Burberry Group PLC","1,585.00 13:10","Down 5.00 (0.31%)",455614,"Fashion"]
["HL.L","Hargreaves Lansdown PLC","955.00 13:08","Up 15.00 (1.60%)",404074,"Finance"]
["PRU.L","Prudential PLC","1,460.50 13:13","Down 5.00 (0.34%)",1026994,"Finance"]
["ABF.L","Associated British Foods PLC","3,028.00 13:11","Down 32.00 (1.05%)",174928,"Food"]
["CPG.L","Compass Group PLC","1,056.00 13:12","Up 3.00 (0.28%)",1057431,"Food"]
["ADN.L","Aberdeen Asset Management PLC","409.90 13:12","Up 5.90 (1.46%)",2443373,"Fund management"]
["SDR.L","Schroders PLC","2,548.00 13:08","Down 38.00 (1.47%)",79066,"Fund management"]
["SL.L","Standard Life PLC","390.93 13:12","Down 5.07 (1.28%)",1557044,"Fund management"]
["AGK.L","Aggreko PLC","1,429.00 13:12","Down 27.00 (1.85%)",238577,"Generator hire"]
["IHG.L","InterContinental Hotels Group PLC","2,463.00 13:11","Up 2.00 (0.08%)",205739,"Hotels"]
["BNZL.L","Bunzl PLC","1,710.00 13:11","Down 6.00 (0.35%)",202425,"Industrial products"]
["EXPN.L","Experian PLC","1,046.00 13:12","Up 3.00 (0.29%)",596145,"Information"]
["ADM.L","Admiral Group PLC","1,263.00 13:12","Down 7.00 (0.55%)",203323,"Insurance"]
["AV.L","Aviva PLC","466.30 13:11","Down 3.80 (0.81%)",2307776,"Insurance"]
["LGEN.L","Legal & General Group PLC","234.30 13:10","Down 1.80 (0.76%)",3600109,"Insurance"]
["OML.L","Old Mutual PLC","178.10 13:12","Down 2.00 (1.11%)",3270466,"Insurance"]
["RSA.L","RSA Insurance Group PLC","432.20 13:09","Down 1.50 (0.35%)",685020,"Insurance"]
["FLG.L","Friends Life Group Limited","350.00 13:13","Down 1.90 (0.54%)",1716312,"Investment"]
["SGE.L","Sage Group (The) PLC","436.30 13:09","Down 1.90 (0.43%)",554320,"IT"]
["GKN.L","GKN PLC","326.82 13:12","Down 5.18 (1.56%)",895930,"Manufacturing"]
["RR.L","Rolls-Royce Group PLC","826.00 13:13","Down 6.00 (0.72%)",1101039,"Manufacturing"]
["ITV.L","ITV PLC","205.60 13:12","Up 0.20 (0.10%)",3540125,"Media"]
["WPP.L","WPP PLC","1,292.90 13:10","Down 20.10 (1.53%)",1074267,"Media"]
["AAL.L","Anglo American PLC","1,128.00 13:12","Down 10.00 (0.88%)",2229333,"Mining"]
["ANTO.L","Antofagasta PLC","704.00 13:10","Up 4.00 (0.57%)",997522,"Mining"]
["BLT.L","BHP Billiton PLC","1,302.50 13:10","Down 15.50 (1.18%)",4633419,"Mining"]
["FRES.L","Fresnillo PLC","694.00 13:12","Down 10.50 (1.49%)",341870,"Mining"]
["GLEN.L","Glencore PLC","285.95 13:12","Down 0.50 (0.17%)",8546578,"Mining"]
["RIO.L","Rio Tinto PLC","2,767.05 13:11","Up 40.05 (1.47%)",3608374,"Mining"]
["RRS.L","Randgold Resources Ltd","4,024.00 13:13","Down 16.00 (0.40%)",246905,"Mining"]
["BG.L","BG Group PLC","810.00 13:12","Down 17.20 (2.08%)",3134989,"Oil and gas"]
["BP.L","BP PLC","379.80 13:12","Down 4.15 (1.08%)",15488336,"Oil and gas"]
["PFC.L","Petrofac Ltd","668.00 13:12","Down 20.00 (2.91%)",842432,"Oil and gas"]
["RDSA.L","Royal Dutch Shell PLC","2,045.50 13:13","Up 9.00 (0.44%)",3116011,"Oil and gas"]
["TLW.L","Tullow Oil PLC","376.82 13:12","Down 4.58 (1.20%)",2605505,"Oil and gas"]
["AZN.L","AstraZeneca PLC","4,448.00 13:11","Down 42.50 (0.95%)",795894,"Pharmaceuticals"]
["GSK.L","GlaxoSmithKline PLC","1,335.50 13:12","Down 12.50 (0.93%)",3382837,"Pharmaceuticals"]
["ITRK.L","Intertek Group PLC","2,244.00 13:12","Down 26.00 (1.15%)",214016,"Product testing"]
["BLND.L","British Land Co PLC","739.56 13:11","Up 0.56 (0.08%)",1181858,"Property"]
["HMSO.L","Hammerson PLC","593.95 13:04","Down 1.55 (0.26%)",549520,"Property"]
["LAND.L","Land Securities Group PLC","1,144.00 13:12","Down 3.00 (0.26%)",739193,"Property"]
["REL.L","Reed Elsevier PLC","1,054.00 13:12","Down 14.00 (1.31%)",548750,"Publishing"]
["NXT.L","Next PLC","6,430.00 13:09","Down 50.00 (0.77%)",138855,"Retail clothing"]
["KGF.L","Kingfisher PLC","315.80 13:13","Down 6.40 (1.99%)",1104332,"Retail homeware"]
["WTB.L","Whitbread PLC","4,449.00 13:13","Down 25.00 (0.56%)",213439,"Retail hospitality"]
["MKS.L","Marks & Spencer Group PLC","457.90 13:09","Down 3.40 (0.74%)",1249481,"Retailer"]
["GFS.L","G4S PLC","267.60 13:12","Down 4.60 (1.69%)",1306320,"Security"]
["MRW.L","Morrison (Wm) Supermarkets PLC","165.40 13:13","Down 4.50 (2.65%)",4454887,"Supermarket"]
["SBRY.L","Sainsbury (J) PLC","226.70 13:12","Down 2.70 (1.18%)",3636157,"Supermarket"]
["TSCO.L","Tesco PLC","166.10 13:13","Down 1.35 (0.81%)",5932729,"Supermarket"]
["CPI.L","Capita PLC","1,045.00 13:07","Down 20.00 (1.88%)",591328,"Support Services"]
["VOD.L","Vodafone Group PLC","218.30 13:12","Down 1.15 (0.52%)",19678480,"Telecomms"]
["IAG.L","International Consolidated Airlines Group SA","445.70 13:12","Down 16.50 (3.57%)",3359465,"Transport air"]
["SVT.L","Severn Trent PLC","1,953.00 13:08","Down 15.00 (0.76%)",264876,"Water"]
["UU.L","United Utilities Group PLC","917.50 13:08","0.00 (0.00%)",988263,"Water"]
["AHT.L","Ashtead Group PLC","1,129.00 13:09","Down 10.00 (0.88%)",594433]
["BA.L","BAE Systems PLC","450.00 13:11","Up 0.20 (0.04%)",2196157,"Aviation"]
["BATS.L","British American Tobacco PLC","3,353.50 13:12","Down 64.00 (1.87%)",877157,"Tobacco"]
["BT-A.L","BT Group PLC","403.82 13:12","Down 1.58 (0.39%)",4621726,"Telecomms"]
["CCL.L","Carnival PLC","2,758.00 13:11","Down 12.00 (0.43%)",232084]
["DC.L","DIXONS CARPHONE","443.60 13:11","Up 16.90 (3.96%)",2326931,"Retail Electronics"]
["DLG.L","Direct Line Insurance Group PLC","280.70 13:12","Down 1.70 (0.60%)",818651,"Insurance"]
["EZJ.L","easyJet PLC","1,618.00 13:12","Down 13.00 (0.80%)",540422,"Transport air"]
["III.L","3i Group PLC","421.80 13:12","Down 0.20 (0.05%)",404521]
["IMT.L","Imperial Tobacco Group PLC","2,725.00 13:08","Down 15.00 (0.55%)",360389,"Tobacco"]
["INTU.L","intu properties plc","325.30 13:09","Down 3.90 (1.18%)",1049266,"Property"]
["LSE.L","London Stock Exchange Group PLC","2,119.00 13:13","Down 9.00 (0.42%)",196259]
["MNDI.L","Mondi PLC","996.00 13:13","Down 41.00 (3.95%)",1197291]
["PSN.L","Persimmon PLC","1,518.00 13:10","Down 9.00 (0.59%)",261804]
["PSON.L","Pearson PLC","1,144.00 13:09","Down 4.00 (0.35%)",605634,"Publishing"]
["RDSB.L","Royal Dutch Shell PLC","2,104.19 13:13","Up 10.19 (0.49%)",2769909,"Oil and gas"]
["RMG.L","Royal Mail PLC","392.60 13:11","Down 4.60 (1.16%)",631890,"Logistics"]
["SHP.L","Shire PLC","4,415.00 13:12","Down 75.00 (1.67%)",628200]
["SN.L","Smith & Nephew PLC","1,038.00 13:09","Down 12.00 (1.14%)",644552]
["SPD.L","Sports Direct International PLC","666.00 13:13","0.00 (0.00%)",491889,"Retail Sports"]
["STJ.L","St James's Place PLC","771.50 13:08","Up 0.50 (0.06%)",351218]
["TPK.L","Travis Perkins PLC","1,770.00 13:11","Down 4.00 (0.23%)",155953]