Posted: Sep 25, 2008 @ 11:53 PM             Msg. 1 of 7

Is there any known issues with OEC Excel DDE addin and enabling iterative calculations?

Freezes up frequently. Excel 2007. Can't tell much more other than a iterative counter gets pegged constantly preventing worksheet switching.

Using Excel calculations with circular references to trigger orders through DDE. Worksheet works reliably using RTD feeds.

Is there any specific calculation setup other than calculate workbook?

Can DDE updates be throttled?

Posted: Sep 26, 2008 @ 08:18 AM             Msg. 2 of 7

Could you send me please a sample that can reproduce this issue?

Posted: Sep 29, 2008 @ 01:20 PM             Msg. 3 of 7

Thank you for details about this issue. Excel has a pool of DDE links and new DDE links with different case of letters are replaced by the first appeared link by Excel, not the add-in. So, modification of account # to correct one doesn't modify corresponding formulas and it leads to infinite loop of calculations in the case of enabled iterative calculations. This infinite loop will be fixed in the next build of Trader. As a part of bugfix, we will support case-insensitive account also. Additionally, I recommend to use unique comments for orders to force updating of corresponding order DDE links.

Posted: Sep 30, 2008 @ 09:35 PM             Msg. 4 of 7

Victor.

Excel dde add-in relies on OEC running, logged in and connected without disruption. If OEC disconnects for any reason.. Excel soft crashes even if autoreconnects if enabled.

Problem is Excel remains connected but dde links become jumbled.. ie ES is updated with 6E quotes etc. just a mess.
I don't believe any orders can be procesed in this soft crash state.

Unless we are monitoring the system directly we would have no clue. Solution so far is to disable autoreconnect and manually restart.. ie. Exit Excel... Exit OEC... Restart OEC... Restart excel and reload the workbook.

Can you think of any better way to error trap and recover from this soft crash? Ideally we would like to reenable autoreconnect and write a function that can poll OEC and refresh/reload excel. Is this possible?

Tried using the exchange time field from quotes to error trap... not reliable. Are there any other time fields or anything else we can use as a heartbeat to poll and verify connectivity inside of Excel?

Posted: Oct 01, 2008 @ 04:29 PM             Msg. 5 of 7

We found out a potential reason of this issue with reconnection and will fix it in the next build.

Posted: Oct 06, 2008 @ 11:08 AM             Msg. 6 of 7

Fixed. Please download the latest version of Trader and Excel Add-in.

Posted: Oct 07, 2008 @ 02:26 PM             Msg. 7 of 7

Works like a charm so far...
Thank you very much for expediting this fix.