I need a bridge between the Java-API of Dukascopy JForex-software on the one side and Excel-Spreadsheets on the other side. In excel the needed functions could be DDE (I know how this works) or another solution (please give good ideas)
How the JForex-API works is described here:
[login to view URL]
The java classes are described here:
[login to view URL]
I need only a few defined functions in excel. These are with the needed parameters like in Java:
Connect (login url, username, password)
newTick(Instrument,Bid,Ask)
submitOrder(Identifier, Instrument, order command, amount, price, slippage, stopLossPrice, takeProfit, goodTillTime)
closeOrders (Identifier)
setOpenPrice (Identifier, Price)
setStoppLossPrice (Identifier, StoppLossPrice)
setTakeProfitPrice (Identifier, TakeProfitPrice)
Only these seven functions must be possible to start from each cell in a spreadsheet like “=closeOrder(8954233)”
I hope for a fast and easy to use solution.
Dear Sir, this is an interesting project because of the mix of technology it encompasses. I am a professional software engineer with a wide experience in financial software. More in PM.