There will be six .txt files in a specified folder namely :
NIFTY, BANKNIFTY, CNX-IT, CNXFMCG, NIFTYAUTO, CNXENERGY
Each file contains 1 minute intraday historical data for one month.
Task of VBA ------
There should be option to enter a specific date in the format YYYYMMDD.
When a specific is entered the vba should extract data of same day from 9.16 to 3.30 and data of previous day from 2.01 to 3.30 and finally feed the data in output excel file/sheet. One by one data from all six files of folder needs to be extracted in the same manner.
The format of output excel sheet is uploaded.
Suppose I have entered date : 20201202, then output data should be as per the format in uploaded sample output file.
26 freelancer chào giá trung bình₹1496 cho công việc này
Hello I am New Here but I have over 5+ experience in Data Entry and Research plus Content Writing. I am sincere and Hardworking. Please give me a chance to work with you. Best Regards Sheetal
I'm an accountant having 4 years of work experience in accounting, data entry operating, excel, word, English typing speed 30,40. I will do complete your work as soon as possible and carefully.
I am a data entry operator and I have experience to do this job. I also have experience of working excel, ws word, pdf etc. for last 2 years. And I hope that you will understand my responsibility.
I have best knowledge and experience regarding these types of work. I will follow rules and regulation accordingly during the job and I will trying to my best as per me.