Excel VBA for DATA IMPORT FROM .TXR FILES to excel file
Budget: ₹600 – ₹1,500 INR
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.
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.