I was finally able to figure out how to connect the DDE sheet with OEC Trader to populate real time data.
It is very useful to manipulate DOM data and create variety of excel formulas and send them instantly for execution.
The super useful DESIRED POSITION function of the DDE provided by OEC Trader is a life saver as its able to generate the Buy/Sell the Desired Position Size & Direction and the spreadsheet is able to distinguish the potential discrepancy in DIRECTION and SIZE and it immediately generates a specific order to correct and achieve the Desired Position on the trading server.
I attached a quick visual guide of how I manipulate the DOM in real time and all positions match.
Very useful and I love the excel interface because there is so much one can do with the raw real time data.
I hope its helpful to other excel trading fans.