Uploaded here is a programmed excel file. It extracts specific data from two files which starts with name - NSEFO-********.csv, kept at one folder.
When clicked on generate, it first selects the oldest file and extracts data, which ends with "[login to view URL]" from column A and time "03.29.59 PM" and pastes in result file. It then selects the newest file and extracts the same names from column A of result file, but with time 09.29.59 AM, 09.59.59 AM, 10:29:59 AM and so on at an interval of half an hour till 03.29.59 PM and pastes in result file.
Here two NSEFO_**** files are uploaded as samples.
1. The program selects data from column A of source whose name ends with : [login to view URL]
It has to be modified so that it selects : -I ,when [login to view URL] is not present.
2. From the newest file it extracts data at an interval of 30 minutes, it has to be modified so that it extracts data at an interval of 15 minutes. i.e.09.29.59 AM, 09.44.59 AM, 09.59.59 AM, 10:14:59 AM 10:29:59 AM and so on till 03.29.59 PM
3. I have uploaded two additional files with format NSESSTOCK-*****.csv, and kept in same folder as the earlier source files.
Now data from the above two files needs to be extracted as well and paste in row starting from 250 as mentioned in "result [login to view URL]" file. The time selection will be same as earlier (column A from oldest and rest columns from newest file). Only different is that, names should be selected from column A of already executed result file and trimming "-I" or "[login to view URL]".
5 freelancers are bidding on average ₹1290 for this job
I have worked for top MNC's and I have hands on experience in Excel and reporting. I can rest assure that I can finish this work by the promised with no errors.