SONJOE JOSEPH
Member
Hi All,
Please help me in atomizing a task which i do frequently which is just killing my time. I have a system generated file NIFTY21SEPFUT (CSV file). When u open the file u will see data starting with the date which includes the time, then NIFTY21SEPFUT O (Open), NIFTY21SEPFUT H (High), NIFTY21SEPFUT L (Low), NIFTY21SEPFUT C (Close) & NIFTY21SEPFUT V (Volume). I use this file for backfilling my data in my charting software so that my data is updated.
In order to backfill the data, its contents and the headers should be arranged in the below order.
In the BFU file which I'm attaching along with this message when the user types the format of the trading symbol mentioned in the yellow area and as soon the user clicks the "Insert file" Button. A new csv file has to be created with the name of the file being mentioned in the yellow area. In this eg; NIFTY21SEPFUT (CSV File). As soon as the file is opened the data format should be formatted as above. Note: There should be no alterations done in the system generated file NIFTY21SEPFUT (CSV). file). Hope u all got the idea.
Along with this message I'm attaching two files s NIFTY21SEPFUT (CSV file) which is a system generated file and BFU were the vba has to be coded so that i get the desired result.
In case of any queries do message me ok
Thanks & Regards
Please help me in atomizing a task which i do frequently which is just killing my time. I have a system generated file NIFTY21SEPFUT (CSV file). When u open the file u will see data starting with the date which includes the time, then NIFTY21SEPFUT O (Open), NIFTY21SEPFUT H (High), NIFTY21SEPFUT L (Low), NIFTY21SEPFUT C (Close) & NIFTY21SEPFUT V (Volume). I use this file for backfilling my data in my charting software so that my data is updated.
In order to backfill the data, its contents and the headers should be arranged in the below order.
Trading Symbol | Date | Time | Open | High | Low | Close/Price | Volume |
NIFTY21SEPFUT | 17-09-2021 | 13:48:00 | 17645.25 | 17645.25 | 17645.25 | 17645.25 | 0 |
NIFTY21SEPFUT | 17-09-2021 | 13:47:00 | 17645.95 | 17647.8 | 17641.25 | 17642.9 | 7900 |
NIFTY21SEPFUT | 17-09-2021 | 13:46:00 | 17650.15 | 17655.7 | 17644 | 17645.95 | 14300 |
NIFTY21SEPFUT | 17-09-2021 | 13:45:00 | 17641.5 | 17651.9 | 17638.55 | 17650.05 | 12000 |
In the BFU file which I'm attaching along with this message when the user types the format of the trading symbol mentioned in the yellow area and as soon the user clicks the "Insert file" Button. A new csv file has to be created with the name of the file being mentioned in the yellow area. In this eg; NIFTY21SEPFUT (CSV File). As soon as the file is opened the data format should be formatted as above. Note: There should be no alterations done in the system generated file NIFTY21SEPFUT (CSV). file). Hope u all got the idea.
Along with this message I'm attaching two files s NIFTY21SEPFUT (CSV file) which is a system generated file and BFU were the vba has to be coded so that i get the desired result.
In case of any queries do message me ok
Thanks & Regards