PROGRAM TO EXTRACT DATA FROM SAMCO NEST TRADER TERMINAL

Program required to copy 15 stocks and one Index data from SAMCO NEST Trading Terminal, minute-wise and feed in excel file. The features of program required are : 1. There would be 15 stocks/scrips present in market watch section of SAMCO. Data of each stock can be generated by using shortcut key “Ctrl+Shift+H”, which opens a pop-up called vwap statistics, in which minute-wise data of that stock is updated. Data of one Index can be generated by right clicking on index name (in index dialog box) and selecting vwap statistics. While default interval in ‘stock vwap statistics’ can always set to one minute, but the default interval in ‘index vwap statistics’ pop-up is 5 mins, which needs to be changed to 1 min, each time data is extracted from index. 2. Data of all stocks (exactly in the sequence present in market watch) and one index, needs to be assembled in EXCEL to generate two result files, one in .csv and other in .xlsx format. The sample format of result file is uploaded. 3. Before generating the result file, data of each scrip and index needs to be checked for start time. Data of all stocks generally starts from 9.16.00 but incase of index, data may be present before 9.16.00, which needs to be deleted. If initial minute e.g. 9.16.00 is missing then entire data of that stock needs to be shifted by one row, similarly if initial two minutes missing then shifting by two rows and so on. 4. The program should automatically start extracting data from 9.16.05 of the system time and automatic stop time is 15.33.00. However manual stop/start button has to be present. The data to be automatically extracted at specific second (to be entered by user) of every minute i.e. [login to view URL], [login to view URL], [login to view URL] and so on, where xx is the value entered by user. 5. There will be multiple instances of SAMCO terminal running in one system. So program has to be made so that it can be run with multiple instances. (In that case process id of specific instance of SAMCO may be linked to specific instance of program)