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?
6
-
$\begingroup$ this statement ". Can anybody suggest the easiest way to migrate my DDE workbook to Java" Doesn't really make alot of sense to me. What does it mean to migrate a spreadsheet to Java? $\endgroup$– chollidaCommented Jul 9, 2014 at 21:14
-
$\begingroup$ Hi Chris, What I want to do is Export my EXCEL worksheet to a plaform (SQL server? ) and then utilize the connectivity of JAVA based sample program provided by the Broker in order to increase the robustness and stability of the program $\endgroup$– MarcusCommented Jul 13, 2014 at 15:22
-
5$\begingroup$ you're going to be disappointed. There really isn't any way to do that short of opening Eclipse and coding this yourself. Stick with excel for now as it will let you concentrate on your strategy. If you have to code a trading environment first you'll get bogged down in all the gory details that excel currently hides for you. $\endgroup$– chollidaCommented Jul 14, 2014 at 13:40
-
$\begingroup$ For IB you may also try this specialized group: linkedin.com/groups/… $\endgroup$– PamCommented Jul 16, 2014 at 17:05
-
1$\begingroup$ This question appears to be off-topic because it isn't about quantitative finance $\endgroup$– chollidaCommented Dec 29, 2014 at 17:19
|
Show 1 more comment
1 Answer
$\begingroup$
$\endgroup$
2
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 :(
-
$\begingroup$ This doesn't really answer the OP's question in anything but a very superficial way. How do you get market data if it was originally from an excel RTD? How do you handle the updates that excel used manage? Just reimplementing the excel function in java does nothing. You are missing the entire piece that calls one function when its dependencies change, etc. $\endgroup$– chollidaCommented Jul 16, 2014 at 17:42
-
$\begingroup$ The implementation of the function is something like $\endgroup$– user7056Commented Jul 17, 2014 at 18:41