Re: Locate Word In Column & Copy Adjacent Range
HI, Jindon
My ASX folder (Libraries->Documents->My Documents->EODData->DataClient->ASCII->ASX) has the following csv files:
ASX_20120508.csv (Tuesday)
ASX_20120509.csv (Wednesday)
ASX_20120510.csv (Thursday)
ASX_20120511.csv (Friday)
ASX_20120514.csv (Monday)
ASX_20120515.csv (Tuesday)
ASX_20120516.csv (Wednesday)
ASX_20120517.csv (Thursday)
ASX_20120518.csv (Friday)
ASX_20120521.csv (Monday)
ASX_20120522.csv (Tuesday)
ASX_20120523.csv (Wednesday)
ASX_20120524.csv (Thursday)
ASX_20120525.csv (Friday)
Next Monday (2012.05.28) I will have ASX_20120528.csv file downloaded into this ASX folder. Your code takes the most current csv file which is now ASX_20120525.csv in my ASX folder. Next Monday afternoon (End Of Day - EOD) the most current file will be ASX_20120528.csv file. Tuesday it will have another csv file with the file name ASX_20120529. I hope you are now clear with the file structure. I have run out of ways of explaining this to you further.
The column A has the stock symbols (about 4200 of them) in alphabetical order. That is why the sample csv file had only the first few stocks strating with AAA.AX and the column B in all these csv files has only the same date which is the date given in the file name (e.g. ASX_2012 05 25 without spaces). Column C/D/E/F/G has corresponding data for the stock symbol which are Open price/Highest price/Lowest price/Closing price/Volume traded. I only trade in a few stock symbols and wish to update my Master Workbook with corresponding data from daily csv file at the End Of Day.
Kind regards - wkurukul