I have a working excel workbook connected to Interactive brokers DDE API. I am struggling to upgrade to a more robust environment like Java. I tried to change it to ActiveX for Excel but the refreshing rate is limited and IB does not support microsoft RTD server. Can anybody suggest the easiest way to migrate my DDE workbook to Java. Since IB provides a java sample which provide the basic connection between TWS. Is it possible to feed the quote from Java API into the excel for calculation?
You rewrite your XL functions as unique, massive function, which receives all the input your Excel needs and outputs the valu(es) you are interested in. Transform this unique function into an executable. You access this executable as a Java function.
The only java code you have to write will be a call of this function, representing the executable and in my opinion You may use any editor. The function itself, internally, continues to be VBA code. I do hope that I have correctly understood your issue :(