Contents • Mini forex trading from $100 • TradingDesk Pro 5 - best forex software
Exporting through DDE into Microsoft Excel

 

For exporting data into Microsoft Excel it is necessary:

- to adjust DealingDesk 2000 as shown in the corresponding help topic "Adjusting TradingDesk Pro 5 for exporting data via DDE on-line."

- to fill in the desired cell of Microsoft Excel by one of the following DDE queries depending on what instrument you want to receive and press Enter.

 

Instrument

       DDE query

Usd/Chf

='DD2000'|'USD /CHF'!BID or  ='DD2000'|'USD /CHF'!ASK

Eur/Usd

='DD2000'|'EUR /USD'!BID or  ='DD2000'|'EUR /USD'!ASK

Usd/Jpy

='DD2000'|'USD /JPY'!BID or  ='DD2000'|'USD /JPY'!ASK

Gbp/Usd

='DD2000'|'GBP /USD'!BID or  ='DD2000'|'GBP /USD'!ASK

Gbp/Chf

='DD2000'|'GBP /CHF'!BID or  ='DD2000'|'GBP /CHF'!ASK

Gbp/Jpy

='DD2000'|'GBP /JPY'!BID or  ='DD2000'|'GBP /JPY'!ASK

Eur/Jpy

='DD2000'|'EUR /JPY'!BID or  ='DD2000'|'EUR /JPY'!ASK

Eur/Chf

='DD2000'|'EUR /CHF'!BID or  ='DD2000'|'EUR /CHF'!ASK

Eur/Gbp

='DD2000'|'EUR /GBP'!BID or  ='DD2000'|'EUR /GBP'!ASK

Aud/Usd

='DD2000'|'AUD /USD'!BID or  ='DD2000'|'AUD /USD'!ASK

Usd/Cad

='DD2000'|'USD /CAD'!BID or  ='DD2000'|'USD /CAD'!ASK

INDU (Dow Jones Industrial Average)

='DD2000'|'INDU'!ASK or  ='DD2000'|'INDU'!BID

NASDC (NASDAQ)

='DD2000'|'NASDC'!ASK or  ='DD2000'|'NASDC'!BID

S&P500 (index Standard&Poor's 500)

='DD2000'|'S&P500'!BID or ='DD2000'|'S&P500'!ASK

 

Receiving and processing the data in Microsoft Excel is used, for example, when you want to create and to monitor custom parameters which do not present in the Opened trades table of TradingDesk Pro 5 or to create customer's own trading strategies.