Write some Software

The requirements are as given below: First the excel will capture realtime data from NEST TRADER or NOW and will get updated as per the terminal. The excel should contain 3 tabs. 1) 1st tab will contain Name, CMP, 1ST 15-high, 1st 15 -Low, 2ND 30-high, 2nd 30-low, Name: Stock Name CMP: Current Market Price(will get updated in realtime as per the trading terminal). 1st 15-high:It will capture the 1st 15 min high price(9-15AM to 9-30AM) 1st 15-Low:It will capture the 1st 15 min low price(9-15AM to 9-30AM) 2nd 30min-high:It will capture the 2nd 30 min high price(9-30AM to 10-00AM) 2nd 30min-low:It will capture the 2nd 30 min low price(9-30AM to 10-00AM) After 10AM every column value will be freezed except CMP. 2) 2nd tab will contain (will be updated in runtime if 2-3 simple conditions met). Name, Lot, signal, confirmed, max loss possible, profit/loss, profit/loss, total, Name: Will come from the first tab Lot: Corresponding LOT quantity will come from 3rd tab The other fields require very simple arithmatic calculations 3) 3rd tab will contain Name, Lot Qty, These two fields need to be filled up manually before using this software.