Downloading data into Excel

I have a simple query about downloading tabular data into Excel. Specifically, Id like to download streaming stock data into an excel worksheet from my trading software. Is there a way of doing it, if the trading software doesnt allow a DDE connection?

thanks

Hi,

What is your trading software ...?
Does it have an export capability ...?

HTH
Carim

As an alternative, should you need to download stock prices from yahoo finance, below is my daily routine ...
make sure to enter all your stock symbols in column A ...

Please Login or Register  to view this content.

HTH
Carim

Good afternoon Carim,

I ran into a problem with your code and I was wondering if you had any ideas on how I could modify it. I currently have a watchlist of about 75 stocks but it may still be added to. The code you provided works great as long as I am only doing it for a few stocks but if I want to run it for the whole 75, it creates an error. Works fine for up to 25 but somewhere between 25 and 30 stocks, it creates an error.

Anyway, I want to do it in batches of say 20 stocks at a time to be safe. Any ideas on how I should modify the code?

Oh and just for information purposes, the error is happens at Workbook.Open sURL
Run-time roor '1004': Method 'Open' of object 'Workbooks' failed.

Thanks in advance for any help!
dw

I have 200+ stocks on my list and part of my daily routine it to get the Open, High, Low, Close and Volume from Yahoo Finance by using web query. Sometimes it will give problem and very time consuming. Now I just download the End of Day data from web (csv format) and then merge it with my data, more consistent and save lots of time.

cheers,
William
http://excelstock.googlepages.com