I have on.csv file in which I have to change data programmatically. Please help me out with VBA.
Here are the steps.
In attached .csv file Find "NIFTY" in column B with criteria "XX" in column E. there are 3 matches with this criteria.
Now we have 3 dates in column C as per above criteria i.e. "29-Jan-15" "26-Feb-15" "26-Mar-15
". Put text values to this dates "I" "II" "III" in Oldest to newest. So 29-Jan-15 = I , 26-Feb-15 = II & 26-Mar-15 = III. apply this values to respective dates in all column C.
Delete all rows which doesn't match values "I" "II" "III" in column C
Need to execute this from other WB & above file location is "D:\AmiBroker Data\NSE\FO\". there are numbers of files.
Need to Execute for all files but not now as this is part of process there are follow up questions.