Excel to Java for Interactive brokers
Excel to Java for Interactive brokers
Loading saved threads...
Marcus · External communityPost link
External question — Quantitative Finance Stack Exchange
Author: Marcus
Original post: https://quant.stackexchange.com/questions/12994
License: CC BY-SA 3.0 — https://creativecommons.org/licenses/by-sa/3.0/
Adaptation: HTML converted to plain text; contact email addresses removed.
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?
Quote
Report
user7056 · External communityPost link
External answer — Quantitative Finance Stack Exchange
Author: user7056
Original post: https://quant.stackexchange.com/a/14057
License: CC BY-SA 3.0 — https://creativecommons.org/licenses/by-sa/3.0/
Adaptation: HTML converted to plain text; contact email addresses removed.
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 :(
Quote
Report
Post Reply
Quoted from Forex.com.bd-Editorial External answer — Quantitative Finance Stack Exchange Author: user7056 Source score (net votes, not local likes): 1 Original post: https://quant.stackexchange.com/a/14057 License: CC BY-SA 3.0 — https://creativecommons.org/licenses/by-sa/3.0/ Adaptation: HTML converted to plain text; contact email addresses removed. 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 :(
Checking account access…