There are numerous utilities... I am also doing same with support upto 200 symbols at a time.
Dear Ajeet,
I am in need of someone expert in this excel to ami to guide me in this.
My requirement is not to get market data like ltp, vol, numbers to amibroker.
will try to give you a example :
step 1) Importing data from trading terminal to excel ( link to excel option). This data has OHLC values
step2) Adding a new column to excel - named as pivot. formula for this would be open+high+low+ltp/4
** As the importing values from trading terminal to excel keeps changing on live, our Pivot value also changes accordingly.
Step 3) We need to import this pivot value to Amibroker.
If it is just market data, I could subscribe to any data provider. But I need my own calculated values into Amibroker. ( like the above said pivot value)
Kindly suggest. Requesting your email/mobile to contact you personally.