I have a list of stock prices in excel that looks like this
stock prices needed 10/7/2014
UYM 50.85 51.42 49.88 49.93 6410.93
V 210.81 211.09 207.85 208.05 22375.57
VAC 61.52 61.75 60.48 60.58 1001.44
VAL 77.45 77.68 76.73 76.81 4599.69
VALE 11.34 11.58 11.29 11.39 362664.57
VAR 80.69 82.74 80.69 80.82 31238.55
they are the october 7 2014 open hi low and close and volume for the symbols in column a
the list is much longer than I've pasted
I need to copy the data for each stock and paste it into that stocks price file in the row for that particular date. the price file looks like this
10/03/2014 UYM 51.980 52.190 51.460 51.620 139
10/06/2014 UYM 51.820 52.120 51.400 51.600 185
10/07/2014 UYM 0 0 0 0 0
10/08/2014 UYM 49.66 51.04 48.52 51.01 277
i recorded a little macro which will performs the task for UYM. how to I tweak it so it will go down the list of stocks and copy and save the data for each one until I complete the entire list.
here is what I have so far
thank you!![]()
Please Login or Register to view this content.
Bookmarks