SONJOE JOSEPH
Member
Dear All Expert Excel Ninjas,
1. I'm having a file which is downloaded from my trading terminal. This file gets downloaded once i select a script the trading terminal has a facility to download Intraday EOD Data. For this i have selected the "NIFTY19JANFUT" once the download is complete it will be a csv file in the name "NIFTY19JANFUT.csv". Since this file is very large i have just uploaded a small part of the data as attachment ok.
2. From this master file "NIFTY19JANFUT.csv" i need to make another new csv file in the name "NTY19JANFUT.csv". This file has to look same exactly like the file which is attached just open the NTY19JANFUT.csv. The file has been worked manually were i had to add the "Trading Symbol" column. Then i need to type "NTY19JANFUT" and copied pasted down till the end of the data. Once this is done i had to rename the headings as "Time", "Open","High", "Low", "Close/Price", "Volume".
So all this process has to be automatized. Looking forward for all ur help from expert Excel users to help me in this regard.
Thanking You,
With Regards,
Sonjoe Joseph.
1. I'm having a file which is downloaded from my trading terminal. This file gets downloaded once i select a script the trading terminal has a facility to download Intraday EOD Data. For this i have selected the "NIFTY19JANFUT" once the download is complete it will be a csv file in the name "NIFTY19JANFUT.csv". Since this file is very large i have just uploaded a small part of the data as attachment ok.
2. From this master file "NIFTY19JANFUT.csv" i need to make another new csv file in the name "NTY19JANFUT.csv". This file has to look same exactly like the file which is attached just open the NTY19JANFUT.csv. The file has been worked manually were i had to add the "Trading Symbol" column. Then i need to type "NTY19JANFUT" and copied pasted down till the end of the data. Once this is done i had to rename the headings as "Time", "Open","High", "Low", "Close/Price", "Volume".
So all this process has to be automatized. Looking forward for all ur help from expert Excel users to help me in this regard.
Thanking You,
With Regards,
Sonjoe Joseph.