Stocks

I want to take a column of stock symbols and return in an adjacent column stock quote values (these need not be real time).

Any help is appreciated.

You will need to write a program that acts as a screen scraper to pull the data you want. This will be hard if you are not a programmer.

Possibly creating a link in your excell to get a spreadsheet of data for a stock would help you???

here is how to do it:
Put each of these items into cells A6 through A20
This will allow you to change each item which are the stock symbol (lrw in this case) start and end dates.
http:/ /ichart.finance. yahoo.com /table.csv?s= (remove the spaces I did them so it could be read)
lrw
&a=
0
&b=
1
&c=
1982
&d=
1
&e=
21
&f=
2006
&g=d&ignore=.csv

in cell A4 put:
=CONCATENATE(A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20)

and in cell A3 put"
=hyperlink(A4,"Get Spreadsheet of historical data")

now click on the link and watch the chart load into a new spreadsheet.

I know its not quite what you asked for but now you can graph and analyze the data for your favorite stocks.

http://ichart.finance.yahoo.com/table.csv?s=bzh&a=0&b=1&c=1982&d=1&e=21&f=2006&g=d&ignore=.csv

2 Responses

1. trade_info Says:
   February 25th, 2010 at 10:01 am

   the following applies to 2002: not sure if it will work in 2000:

   http://www.findarticles.com/p/articles/mi_zdpcm/is_200302/ai_ziff35240

   you can also use finance.yahoo.com portfolio feature and set up your portfolio. then choose spreadsheet option at the bottom of the page. this will download the portfolio to an excel file.
   References :

2. brian-the-brain Says:
   February 25th, 2010 at 10:45 am

   You will need to write a program that acts as a screen scraper to pull the data you want. This will be hard if you are not a programmer.

   Possibly creating a link in your excell to get a spreadsheet of data for a stock would help you???

   here is how to do it:
   Put each of these items into cells A6 through A20
   This will allow you to change each item which are the stock symbol (lrw in this case) start and end dates.
   http:/ /ichart.finance. yahoo.com /table.csv?s= (remove the spaces I did them so it could be read)
   lrw
   &a=
   0
   &b=
   1
   &c=
   1982
   &d=
   1
   &e=
   21
   &f=
   2006
   &g=d&ignore=.csv

   in cell A4 put:
   =CONCATENATE(A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20)

   and in cell A3 put"
   =hyperlink(A4,"Get Spreadsheet of historical data")

   now click on the link and watch the chart load into a new spreadsheet.

   I know its not quite what you asked for but now you can graph and analyze the data for your favorite stocks.

   http://ichart.finance.yahoo.com/table.csv?s=bzh&a=0&b=1&c=1982&d=1&e=21&f=2006&g=d&ignore=.csv
   References :

Leave a Comment