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:
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.
Bookmarks