How to retrieve the yahoo symbols into excel?
in [General]
|
From: Eric on 18 Apr 2010 01:22 There is a list of stock constituents from yahoo, I would like to retrieve each stock symbol into excel, but I need to manual do it one at a time by copying its link into excel. http://in.finance.yahoo.com/q/cp?s=%5EAORD Does anyone have any suggestions on how to retrieve the yahoo symbols into excel? Thanks in advance of any suggestions Eric
From: Gary Keramidas on 18 Apr 2010 01:30 the download data link doesn't help? -- Gary Keramidas Excel 2003 "Eric" <Eric(a)discussions.microsoft.com> wrote in message news:0273A971-EBDA-463A-B457-D6E56C5CCCE0(a)microsoft.com... > There is a list of stock constituents from yahoo, I would like to retrieve > each stock symbol into excel, but I need to manual do it one at a time by > copying its link into excel. > http://in.finance.yahoo.com/q/cp?s=%5EAORD > Does anyone have any suggestions on how to retrieve the yahoo symbols into > excel? > Thanks in advance of any suggestions > Eric
|
Pages: 1 Prev: Sorting by Content Next: How to sort names in alphabetical ascending order? |