Excel versions compatible with GAIN OEC Trader / DDE

Futures Trading Platforms Excel Based Trading
1

I would like to find out from GAIN trading desk / excel product specialist,
which versions of EXCEL are fully compatible with their DDE to bring in live data and send/receive orders to take full advantage of this excel add-in function.

I am currently using microsoft’s 365 version but as I will most likely eventually switch to a VPN and
a dedicated server I will probably end up getting a standalone lifetime license of just EXCEL.

As I was trying to modify GAIN’s “DDE sample add-in sheet” I was getting ERRORS suggesting that
there may be compatibility issues and warnings regarding “Excel 97-2013 and 2007” versions.

So, I would like to fully clarify with GAIN / Excel specialist which version is the best and most compatible for the DDE bridge to work most efficiently with their servers?

Thanks very much.

Regards,

  • P11

OEC%20DDE%20EXCEL%20COMPATIBILTY%20WARNING%20-%20WHEN%20SAVING%20SAMPLE%20SHEET%20IN%20DIFFERENT%20LOCATION
OEC DDE EXCEL COMPATIBILTY WARNING - WHEN SAVING SAMPLE SHEET IN DIFFERENT LOCATION.png1122×537 20 KB

1 Like
2

@Project11

We’ve reached out to Gain regarding this topic. As soon as we receive a response, we will update this thread.

Thanks for your patience,
Jake
Optimus Futures Support

1 Like
3

@Project11

Gain would like to know if you are using a sample sheet or a blank spreadsheet, and what version of Excel are you using?

2 Likes
4

I am using the “sample add-in sheet” with Office 365, but trying to buy the standalone version of excel (office) and wanted to know which one is the most compatible?
Thanks

  • P11
2 Likes
5

Hi @Project11,

According to the Gain Support team, the standalone version or using a blank template and not the add-in sheet would be the most compatible.

My best bet would be to get the latest version of Excel, this should be compatible and work without any issues.

Hope this clears things up,
Jake
Optimus Futures Support

1 Like
6

Thanks @Mod-JakeM ,
I will try to get the latest standalone version.
Regards,

  • P11
1 Like
7

Do you have more exact informations about this now?
Where to get GAIN’s “DDE sample add-in sheet”? I have not found this. I can use a blank sheet, but for understanding the syntax, the sample is nessesary.

2 Likes
8

@Jumi,
When I get back to my trading desk, I will try to send you the detailed excel spreadsheet for OEC / DDE sample worksheet that works at least on my end.
Regards,

  • P11
9

Here is the Excel Add-in approved and working I was able to get from Gain capital group.
I have tweaked it to my needs but its beautiful simple.
It has many useful features including the very useful “check for live positions” with the positions on your side.
This is able to catch errors and in case you get overfilled or any other issues it basically self-corrects.

It takes a minutes to get a handle of it but basically study the read it files and the PDF from the GAIN about DDE and also be sure to input your account and userful correct to be able to start receiving the live data.
Also make sure you follow the instructions posted by @Mod-JakeM above.

Here is the link for all the info on the spreadsheet:

It’s available for download from this link.

I hope this helps @Jumi.

Happy Trading,
Regards,

  • P11
1 Like
10

I tried to upload directly from my station but the forum won’t allow me to upload anything but pics etc.

  • P11

P.S. I posted the link where to get the GAIN EXCEL DDE add-in file on this thread:

1 Like
11

Ok, I will check into that.

Matt Z
Optimus Futures

1 Like
12

I can’t post an attachment. Only pics files.
I already answered to this in this post where GAIN Excel DDE sample add-in file can be downloaded.
Regards,

  • P11
1 Like