在Excel获取实时股票价格

需要获取的股票数量20股票代码股票名称最后更新的价格最后更新时间持股价持股数量收益%收益600104上海汽车25.362015/5/615:0326.33-3.68%0.00601989中国重工14.792015/5/615:0316.14-8.36%0.00600089特变电工16.252015/5/615:0316.97-4.24%0.00002151北斗星通52.32015/5/615:0454.18-3.47%0.00000507珠海港11.272015/5/615:0411.80-4.49%0.00600066宇通客车29.852015/5/615:0332.80-8.99%0.00601866中海集运9.312015/5/615:039.63-3.32%0.00600005武钢股份6.182015/5/615:036.55-5.65%0.00002352鼎泰新材32.792015/5/615:0433.43-1.91%0.00600569安阳钢铁4.272015/5/615:035.00-14.60%0.00600688S上石化8.782015/5/615:039.82-10.59%0.00002209达意隆02015/5/615:040.000.00%0.00603636南威软件65.012015/5/615:0366.88-2.80%0.00601600中国铝业8.752015/5/615:039.03-3.10%0.00601766中国南车29.452015/5/615:0331.52-6.57%0.00601880大连港7.292015/5/615:037.72-5.57%0.00601919中国远洋13.272015/5/615:0313.83-4.05%0.00601998中信银行7.362015/5/615:037.54-2.39%0.00000690宝新能源9.892015/5/615:049.890.00%0.00600019宝钢股份8.662015/5/615:039.00-3.78%0.002020/4/42015/5/60.00获取当前价格说明：只需在A列手动输入股票代码。然后按“获取当前价格”“需要获取的股票数量”是需要更新的股票数量。深发展Ａ000001000001深发展Ａ基金金泰500001万科Ａ000002000002万科Ａ基金泰和500002ST国农000004000004ST国农基金安信500003世纪星源000005000005世纪星源基金汉盛500005深振业Ａ000006000006深振业Ａ基金裕阳500006ST零七000007000007ST零七基金兴华500008ST宝利来000008000008ST宝利基金安顺500009中国宝安000009000009中国宝安基金金鑫500011SST华新000010000010SST华新基金汉兴500015深物业A000011000011深物业A基金兴和500018南玻Ａ000012000012南玻Ａ基金通乾500038沙河股份000014000014沙河股份基金科瑞500056深康佳Ａ000016000016深康佳Ａ基金银丰500058*ST中华A000017000017*ST中华治理ETF510010ST中冠A000018000018ST中冠治理申赎510011深深宝Ａ000019000019深深宝Ａ申赎资金510012深华发Ａ000020000020深华发Ａ超大ETF510020长城开发000021000021长城开发超大申赎510021深赤湾Ａ000022000022深赤湾Ａ申赎资金510022深天地Ａ000023000023深天地Ａ价值ETF510030招商地产000024000024招商地产价值申赎510031特力Ａ000025000025特力Ａ申赎资金510032飞亚达Ａ000026000026飞亚达Ａ50ETF510050深圳能源000027000027深圳能源50申赎510051一致药业000028000028一致药业申赎资金510052深深房Ａ000029000029深深房Ａ央企ETF510060*ST盛润A000030000030*ST盛央企申赎510061中粮地产000031000031中粮地产申赎资金510062深桑达Ａ000032000032深桑达Ａ民企ETF510070新都酒店000033000033新都酒店民企申赎510071ST深泰000034000034ST深泰申赎资金510072*ST科健000035000035*ST科责任ETF510090华联控股000036000036华联控股责任申赎510091深南电Ａ000037000037深南电Ａ申赎资金510092中集集团000039000039中集集团周期ETF510110深鸿基000040000040深鸿周期申赎510111深长城000042000042深长申赎资金510112中航地产000043000043中航地产中盘ETF510130深纺织Ａ000045000045深纺织Ａ中盘申赎510131泛海建设000046000046泛海建设申赎资金510132ST康达尔000048000048ST康达消费ETF510150德赛电池000049000049德赛电池消费申赎510151深天马Ａ000050000050深天马Ａ申赎资金510152方大集团000055000055方大集团小康ETF510160深国商000056000056深国小康申赎510161深赛格000058000058深赛申赎资金510162辽通化工000059000059辽通化工商品ETF510170中金岭南000060000060中金岭南商品申赎510171农产品000061000061农产申赎资金510172深圳华强000062000062深圳华强180ETF510180中兴通讯000063000063中兴通讯180申赎510181北方国际000065000065北方国际申赎资金510182长城电脑000066000066长城电脑龙头ETF510190ST三星000068000068ST三星龙头申赎510191华侨城Ａ000069000069华侨城Ａ申赎资金510192特发信息000070000070特发信息红利ETF510880海王生物000078000078海王生物红利申赎510881盐田港000088000088盐田申赎资金510882深圳机场000089000089深圳机场银华优选519001深天健000090000090深天海富收益519003广聚能源000096000096广聚能源海富股票519005中信海直000099000099中信海直海富回报519007TCL集团000100000100TCL添富优势519008宜华地产000150000150宜华地产海富精选519011中成股份000151000151中成股份海富优势519013丰原药业000153000153丰原药业海富贰号519015川化股份000155000155川化股份大成成长519017中联重科000157000157中联重科添富均衡519018常山股份000158000158常山股份大成景阳519019国际实业000159000159国际实业金鼎价值519021东方市场000301000301东方市场海富债券519023潍柴动力000338000338潍柴动力海富领先519025许继电气000400000400许继电气海富小盘519026冀东水泥000401000401冀东水泥海富周期519027金融街000402000402金融华夏稳增519028华意压缩000404000404华意压缩华夏稳增519029胜利股份000407000407胜利股份海富稳固519030*ST金谷000408000408*ST金富国天博519035ST泰复000409000409ST泰复长盛同德519039沈阳机床000410000410沈阳机床添富蓝筹519066英特集团000411000411英特集团添富焦点519068宝石Ａ000413000413宝石Ａ添富价值519069*ST汇通000415000415*ST汇添富增收519078民生投资000416000416民生投资新华分红519087合肥百货000417000417合肥百货新华成长519089小天鹅Ａ000418000418小天鹅Ａ新华钻石519093通程控股000419000419通程控股新华行业519095吉林化纤000420000420吉林化纤新华市值519097南京中北000421000421南京中北长盛100519100湖北宜化000422000422湖北宜化浦银价值519110东阿阿胶000423000423东阿阿胶浦银收益519111徐工机械000425000425徐工机械浦银生活519113富龙热电000426000426富龙热电浦银红利519115华天酒店000428000428华天酒店浦银300519116粤高速Ａ000429000429粤高速Ａ万家180519180*ST张股000430000430*ST张万家和谐519181晨鸣纸业000488000488晨鸣纸业万家引擎519183鄂武商Ａ000501000501鄂武商Ａ万家精选519185绿景地产000502000502绿景地产万家稳增519186海虹控股000503000503海虹控股大成300A519300*ST传媒000504000504*ST传万家货币519508ST珠江000505000505ST珠江浦银货A519509中润投资000506000506中润投资添富货币519518珠海港000507000507珠海港友邦增利519519S*ST华塑000509000509S*ST银河银信519666金路集团000510000510金路集团银河成长519668银基发展000511000511银基发展银河行业519670丽珠集团000513000513丽珠集团300价值519671渝开发000514000514渝开银河蓝筹519672开元控股000516000516开元控股银河创新519674荣安地产000517000517荣安地产交银增利519680四环生物000518000518四环生物交银精选519688江南红箭000519000519江南红箭交银稳健519690长航凤凰000520000520长航凤凰交银成长519692美菱电器000521000521美菱电器交银先锋519698白云山Ａ000522000522白云山Ａ交银主题519700广州浪奇000523000523广州浪奇交银趋势519702东方宾馆000524000524东方宾馆长信量化519983红太阳000525000525红太CX中短债519985旭飞投资000526000526旭飞投资长信恒利519987美的电器000527000527美的电器长信利丰519989柳工000528000528柳工长信双利519991广弘控股000529000529广弘控股长信增利519993大冷股份000530000530大冷股份长信金利519995穗恒运Ａ000531000531穗恒运Ａ长信银利519997力合股份000532000532力合股份浦银货A521509万家乐000533000533万家银华YXZT522001万泽股份000534000534万泽股份海富SYZT522003华映科技000536000536华映科技海富GPZT522005广宇发展000537000537广宇发展海富QHZT522007云南白药000538000538云南白药添富YSZT522008粤电力Ａ000539000539粤电力Ａ海富JXZT522011中天城投000540000540中天城投海富YSZT522013佛山照明000541000541佛山照明海富EHZT522015皖能电力000543000543皖