Perhaps I should have explained my intention in detail. There are two parts to it; receiving data from NSE/NEST into my XL for processing and (b) placing orders to NEST from XL for execution. I need REAL time STREAMING data and preferably at least 1 sec.. The ultimate objective is auto trading from a dealer terminal without using ANY charting software (through formulae/functions/logic only).
I am told no vendor sells this data in XL readable (unencrypted)format. I am even open to purchasing translator APIs for the incoming and outgoing data.
While your intentions are clear, your stumbling block is not. Sticking to (a) getting data from Nest to Excel for the time being. Yes, of course, whether you prefer the data in Ami, or Excel, or ASCII, or SQL DB, or MatLab is a choice.
Getting the data into Excel from Nest or Odin or NOW, etc., cannot be your problem (or is it?) In fact that is only data access most terminals/vendors intrinsically provide and is the starting point of many AmiBroker/MetaStock feed utilities. You could very well use this data for your Excel computation and skip the step of sending it elsewhere. The reason most folks want it out from Excel is the historical data need.
Getting 1 second data is a problem. Afaik, the RTD polling default is 2 seconds. In any case, most terminals do not update as fast as it appears. For example, my Odin Diet typically gives under 10,000 quote refreshes per trading day of 22K seconds (6.25 x 60 x 60 ) for Reliance. I have not counted for Nest or NOW, and it varies with market. For example, MCX is quicker than NSE.
If it is not terminal based feed, then you have the GDFL or eSignal options and you would be aware of the issues there.
So, what is your stumbling block? You will have to compromise somewhere.