T
Tom
Hi,
My namelist.xls contains 10 stock codes for example - ABC, DEF, ....., XYZ
in the first column. How can I match these names against the closing
pricelist, 20060912.csv which contains the date and the closing prices, so
that if there is an exact match (not ABCD) it will record the corresponding
date (or otherwise a blank) in the second column of namelist.xls?
To make it clear, the date field is the second element of the closing
pricelist as shown below:
AAC,20061204,1.85,1.86,1.85,1.86,33383
AAE,20061204,.415,.48,.405,.445,294925
ABC,20061204,43,43,43,43,0
ABCD,20061204,.22,.22,.21,.21,96000
ACG,20061204,10.21,10.52,10.2,10.46,2920359
<snip>........
Much appreciate for any help.
TIA
Tom
PS. For those who enjoy challenges, after that, close 20060912.csv and
incrementally open up the next pricelist, namely 20060913.csv and do the
match again, recording the date along the next, i.e. third column. Do that
for N = 1 to N = 10.
My namelist.xls contains 10 stock codes for example - ABC, DEF, ....., XYZ
in the first column. How can I match these names against the closing
pricelist, 20060912.csv which contains the date and the closing prices, so
that if there is an exact match (not ABCD) it will record the corresponding
date (or otherwise a blank) in the second column of namelist.xls?
To make it clear, the date field is the second element of the closing
pricelist as shown below:
AAC,20061204,1.85,1.86,1.85,1.86,33383
AAE,20061204,.415,.48,.405,.445,294925
ABC,20061204,43,43,43,43,0
ABCD,20061204,.22,.22,.21,.21,96000
ACG,20061204,10.21,10.52,10.2,10.46,2920359
<snip>........
Much appreciate for any help.
TIA
Tom
PS. For those who enjoy challenges, after that, close 20060912.csv and
incrementally open up the next pricelist, namely 20060913.csv and do the
match again, recording the date along the next, i.e. third column. Do that
for N = 1 to N = 10.