stock prices; EOD data from internet

Created a macro to update end of day (EOD) info for stock prices. I'm able to manually change the stock symbol within the URL line found in the macro to retrieve another stocks data but i want to be able to reference a cell in my spreadsheet instead of having to manually enter within the macro.

This is a line from the macro that actually retrieves the info from the web:

"URL;http://ichart.finance.yahoo.com/table.csv?s=GM&a=00&b=2&c=2005&d=06&e=29&f=2020&g=d&ignore=.csv", Destination:=Range("a1"))

To get data for another stock, i would manually change the "GM" (General Motors Corp) in this line to another stock symbol of interest. How do i automate the process so that it will reference a cell instead?

Thanks for any help,
Impala

Hi Impala. I'm not going to spend time modifying your example file when I already have my own. Maybe you can adapt to your needs using the attached example...

Awesome Tom,

That spreadsheet looks great. I am also interested in being able to grab intraday data for stocks. Have you been able to find a way to be able to do this within excel? I have freeware software that downloads up to 30 days of historical intraday data but i have no idea what feeds the data gets the data from.

Let me know if you have run across this yourself.

Thanks,
Impala

Are you speaking of realtime data? Please explain to me what intra-day means exactly and tell me of some potential sources.

Have either of you found a stock site that you could grab the information for the net worth of a company along with what percentage of a company a stock currently represents (or enough information where I could calculate both)?

Hi Yawn. If it is a publicly traded company, I think that the information you are looking, by law, must be made public.

See the U.S. Securities and Exchange Commission (Home Page)