[Order2Go] FXCMRTD

runawaycat · #1 (**permalink**) 01-09-2006, 10:20 AM

FXCMRTD

Language
Visual Basic 6

API Version
Order2Go v01.02.052307

Description
This is an ActiveX DLL that can be used with the Excel RTD function. It used the Order2Go COM API to log into an account and makes various topics in the dealing rates window available through RTD.

Usage
The DLL should be saved locally, such as to C:\WINDOWS\System32. It should then be registered. To do this:

Click Start > Run...
Type in "regsvr32 "
Type in the exact location of the DLL. So you will have something like : regsvr32 C:\WINDOWS\system32\FXCMRTD.dll
Click enter and you should get a message that the DLL was registered successfully.

You can then open Excel and use the RTD function, which is used in the form:
=RTD("FXCMRTD.RTDFunctions",,Currency, Topic, Username, Password, Connection)
*Please note the second parameter is intentionally left blank.

The connection would be "Demo" or "Real", depending on the type of account you would like to get the information from.

Topics can be any of:
- Bid
- Ask
- High
- Low
- IntrS
- IntrB
- ContractSize
- Digits
- Time

Updated
Jul, 23 2007

rojakian · #2 (**permalink**) 03-14-2006, 02:26 PM

ActiveX DLL registered using regsvr32
Excel cell:
=RTD("FXCMRTD.RTDFunctions",,"EUR/USD","Bid","accountno","password","Real")
gives result #N/A

rojakian · #3 (**permalink**) 03-14-2006, 02:43 PM

Demo account gives same result:

=RTD("FXCMRTD.RTDFunctions",,"EUR/USD","Bid","accountno","password","Demo")

#N/A

FXCM Help · #4 (**permalink**) 03-14-2006, 02:57 PM

Could you please let us know what version of Excel you are using, and what version of Windows.

rojakian · #5 (**permalink**) 03-14-2006, 05:09 PM

Excel 2002
About Microsoft Excel
Excel 2002 (10.6501.6735) SP3

Microsoft Windows XP Home Ed Version 2002 Service Pack 2

Dell 4700 Intel Pentium 4 3.0 GHz 2.00 GB RAM

Comcast Cable 6M Internet Service

DDE Demo working fine and updating quotes continuously
for 10 currency pairs. Could this be interferring with RTD?

FXCM Help · #6 (**permalink**) 03-20-2006, 04:57 AM

We have tried to duplicate the message but not have been sucessful in doing so.

Have you tried it while the DDE was closed?
While the Trading Station was open?
When this is the only FXCM product open at the time?
Do you have the latest version of Order2Go installed on the computer?

Try those things and let us know how it pans out.

rojakian · #7 (**permalink**) 08-12-2006, 10:47 PM

Have installed and tried Excel 2003 with same results.
Something must be missing.
Have Order2Go installed. (Can't find version, but is from June 2006.)
RTD calls all give #N/A.
How could this be further tested/corrected?

imported_oldman · #8 (**permalink**) 01-02-2007, 12:59 PM

Quote:

Originally Posted by rojakian

Have installed and tried Excel 2003 with same results.
Something must be missing.
Have Order2Go installed. (Can't find version, but is from June 2006.)
RTD calls all give #N/A.
How could this be further tested/corrected?

Same problem here! I'm suprised by lack of response .

Excell always gives #NA

rouvenkutter · #9 (**permalink**) 02-15-2007, 03:43 AM

Hi fellows,

i do have the same problem as all of you. I'm just wondering what happens after RTDFunctions",

,"EUR/USD" is there any replacement for the icon? don't we have to give any servers or so?

thanks and regards

camiloz · #10 (**permalink**) 03-07-2007, 03:05 PM

=RDTR("fxcmrtd.rtdfunctions";"http://www.fxcorporate.com";"EUR/USD";"Bid";"Username";"password";"Demo")

it works perfect to me in office 2003 and in office 2007

rojakian · #11 (**permalink**) 03-19-2007, 11:35 AM

RTDR is being used, not RTD
What is difference?

rojakian · #12 (**permalink**) 03-19-2007, 11:43 AM

This gives #Name? instead.
Why are semicolons used instead of commas?
This gives an error in Excel.

Need to know exact conditions for which it works for you.

Order2Go installed.
FXTradingStation running or not?
Anything else?

If RTD (RTDR?) doesn't work, can Order2Go order programs still work?

dealer4fx · #13 (**permalink**) 04-03-2007, 04:03 AM

I found these vb sources and they used FXCM.CORE even at this time.
So I hope FXCM admin will upload the latest sources and binaries for every users that have no vb build environment.

Thanks!

FXCM Help · #14 (**permalink**) 07-23-2007, 06:36 PM

FXCMRTD has now been updated to use Order2Go.CORE.

duketoga · #15 (**permalink**) 08-07-2007, 07:52 AM

Hi all,

Can this dll be controlled with other applications than excel? Can I call it from C++ or whatever?

This is easier for me to do than COMS, so I would like to see if I should go this route.

Thanks,
-Duke