|
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 Dealing Desk 2000 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 Dealing Desk or to create customer's own trading strategies.
|