link a stock quote to excel 2000?
100785
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.\n\nPossibly creating a link in your excell to get a spreadsheet of data for a stock would help you???\n\nhere is how to do it:\nPut each of these items into cells A6 through A20\nThis will allow you to change each item which are the stock symbol (lrw in this case) start and end dates.\nhttp:/ /ichart.finance. yahoo.com /table.csv?s=   (remove the spaces I did them so it could be read)\nlrw\n&a=\n0\n&b=\n1\n&c=\n1982\n&d=\n1\n&e=\n21\n&f=\n2006\n&g=d&ignore=.csv\n\nin cell A4 put:\n=CONCATENATE(A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20)\n\nand in cell A3 put"\n=hyperlink(A4,"Get Spreadsheet of historical data") \n\nnow click on the link and watch the chart load into a new spreadsheet.\n\nI know its not quite what you asked for but now you can graph and analyze the data for your favorite stocks.\n\nhttp://ichart.finance.yahoo.com/table.csv?s=bzh&a=0&b=1&c=1982&d=1&e=21&f=2006&g=d&ignore=.csv
444591
Yahoo Finance can pull that information.  Just click the Finance tab on Yahoo's main page, enter the stock, then click on historical quotes.
306389
Try http://www.optionsxpress.com
282596
http://finance.yahoo.com/
688072
have your data in columns in Excel\nclick the graph icon in the upper tool bar\nselect the chart type\nclick next\ndrop and drag (with control key pressed)\nAfter that, email me
588009
National Association of Securities Dealer Automated Quotation.
353682
Go to Options in your right hand corner and then click on Accout information on your left.  This is in Yahoo format.
415775
Yahoo! Finance, of course.\nhttp://finance.yahoo.com/q/hp?s=%5EDJI\nYou can set the date range or download it to Excel.
166795
try my portfolio in Yahoo! Finance
1170457
yahoo might have a database going that far back,  http://finance.yahoo.com/\n\nit depends on what stock you want to look up though.
70218
The easiest and least inexpensive way is to use one of the various financial sites that monitor the market.  They all offer some form of portfolio tracker.  All you have to do is enter the ticker symbol and they will virtually do the rest.  If you check it on a daily basis, as long as you've calculated the mean purchase price, the portfolio tracker will give you your daily value.\n\nExcel is even a greater tool if you want to do graphical functions because it gives you a greater control of formulas and numerical values.
117999
try http://finance.yahoo.com/q?s=RSH
797774
To find a symbol, go to Yahoo finance and click on symbol lookup to the right of get quotes.
526031
finance.yahoo.com  \n\nGet a quote for the Dow and then click on historical prices.
860377
You can download monthly historical quotes back to 1950 for the S&P 500 index from Yahoo Finance and calculate them from that data:\n\nhttp://ichart.finance.yahoo.com/table.csv?s=%5EGSPC&a=0&b=3&c=1950&d=10&e=28&f=2006&g=m&ignore=.csv
448867
Yahoo! finance.  Click http://finance.yahoo.com/q/hp?s=%5EDJI on the link:
703208
I have the software for it\n\nmail me your e-mail address to send it over\n\nEnjoy my profile, I am the VBAXLMan