The work belongs to processing of data of stocks in stock exchange.
I have attached here excel files as samples, which have been exported from wvap statistics of nest trading software for the purpose of technical analysis.
The image of vwap statistics of nest trading terminal is attached here.
The vwap statistics is the data of a specific stock or scrip in a specific time interval, and inclused open, high, low, close etc. It is updated every minute in the terminal, and fed in the format as mentioned in the above image.
I want an software or programme to automatically transfer the same vwap data in the nest software/terminal to excel in a realtime basis i.e. updated everyminute in excel as it is updated in terminal.
The work belongs to extraction of data of stocks in stock exchange.
The one minute (interval) data of multiple stocks (at least 10 scrips/stocks including futures and options contracts) has to be extracted from the MARKETWATCH of nest trading terminal simultaneously and updated in excel in real time basis as per the format in the excel file I have uploaded here.
The one minute data of a specific stock/scrip includes open, high, low, close, volume, open interest etc in a specific interval. The data is fed to the nest terminal through a server. The data should be updated in excel automatically.
For information/clarity of project
I have uploaded the image of market watch. Here each row represents a single scrip/stock. The ten stocks which need to be extracted changes everyday. There are option contracts/scrip which expire every month and fresh contracts are introduced every month in the market watch section, which also needs extraction included in the 10 stock list.
I have uploaded an excel file and includes data of ten stocks/scrips, which represents the format in which the data needs to be updated. Each represent a specific time. The column in color, represents a specific scrip/stock.
Doubts and reasons about this project are welcome.