Ok basically I have a list of 5300 stock codes.

What I need to do is grab certain data (market cap, average vol) from Yahoo Finance, for each one of them...

I've managed to record a macro that get's this info for me....I then cut and paste the parts I need where they need to go, and discard the rest.

Here is the code:

Please Login or Register  to view this content.
I have a couple of problems.

(1) As you can see I have attempted to copy the code then paste in the query field in yahoo finance....but the code is lost from copy when I go to import data from web. Obviously the data I am looking to grab is relative to the cell that is currently active so I need to get around that someway. I think we need to somehow reference the active cell in this line

.Name = "q?s=GS"

instead of GS we need to reference the active cell.

(2) It is pasting the data in an absolute cell....rather it needs to be 6 columns right of the active cell

(3) I then need this macro to run down the next 5200 lines of data and repeat the process

if anyone can help I would GREATLY appreciate it....I understand my code is a little messy with the recorder but it's 2am in Oz right now and things a getting a little fuzzy lol.