ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAE
1
2
3
4
5
6
Using the Microsoft Excel® RealTimeData (RTD) function in 3rd Dimension.
7
8
9
RTD provides a real time data access and allows you use them directly in Excel for calculations or visualization as different types of charts. To start using RTD
10
you need to run 3rd Diemsion and activate it via "Enable RTD" option in "General Settings" screen of trading platform. Below are a set of available methods and theirs descriptions.
11
Using this information you can build custom Excel sheet with required data.
12
13
14
15
1. GetSymbolInfo
16
17
Provides an access to information about paricular symbol such as Description, ExchangeName, NettingType and others.
18
You can just copy/paste this formula to use in your Excel files or you can get it directly from the panel Symbol Info for selected symbol.
19
Right click on the panel in click on menu item: "Copy RTD Formula"->"Value".
20
21
Syntax:
22
23
=RTD("TradingPlatform";"";"GetSymbolInfo";"AUD_USD";"SymbolType";"Emulator")"
24
25
Parameters:
26
27
"TradingPlatform"
Name of the 3rd Diemsion RTD server. It is fixed and you can use in all formulas.
28
"GetSymbolInfo"
Name of the method
29
"AUD_USD"
ID of the symbol, that you want to retreive data. You can get it from SymbolInfo panel.
30
"SymbolType"
Specified type of data you want to receive. For example: Name, Description.
31
"Emulator"
Name of the connection, which you want to use to search for required symbol. You can leave this parameter empty if you have only one connection.
32
33
2. GetAccounInfo
34
35
Provides an access to information about paricular account such as Name, Balance, NettingType and others.
36
You can just copy/paste this formula to use in your Excel files or you can get it directly from the panel Account Info for selected account.
37
Right click on the panel in click on menu item: "Copy RTD Formula"->"Value".
38
39
Syntax:
40
41
=RTD("TradingPlatform";"";"GetAccountInfo";"101-004-4871421-001";"Balance";"Emulator")
42
43
Parameters:
44
45
"TradingPlatform"
Name of the 3rd Dimension RTD server. It is fixed and you can use in all formulas.
46
"GetAccountInfo"
Name of the method
47
"101-004-4871421-001"
ID of the symbol, that you want to retreive data. You can get it from SymbolInfo panel.
48
"Balance"
Specified type of data you want to receive. For example: Name, Description.
49
"Emulator"
Name of the connection, which you want to use to search for required symbol. You can leave this parameter empty if you have only one connection.
50
51
3. GetMarketData
52
53
Provides an access to information about all types of market data that is available for particular symbol: Bid, Ask, Last, Open, High, etc.
54
You can just copy/paste this formula to use in your Excel files or you can get it directly from the Watchlist panel for selected symbols.
55
56
57
Syntax:
58
59
=RTD("TradingPlatform";"";"GetMarketData";"AUD_USD";"Bid";"Emulator")
60
61
Parameters:
62
63
"TradingPlatform"
Name of the 3rd Dimesion RTD server. It is fixed and you can use in all formulas.
64
"GetMarketData"
Name of the method
65
"AUD_USD"
ID of the symbol, that you want to retreive data. You can get it from SymbolInfo panel.
66
"Bid"
Specified type of data you want to receive. For example: Bid, Ask, Last
67
"Emulator"
Name of the connection, which you want to use to search for required symbol. You can leave this parameter empty if you have only one connection.
68
69
70
4. GetLevel2Data
71
72
Provides an access to Level2 data for particular symbol.
73
You can just copy/paste this formula to use in your Excel files.
74
75
Syntax:
76
77
=RTD("TradingPlatform";"";"GetLevel2Data";"AUD_USD";"Bid";"0";"Emulator")
78
79
Parameters:
80
81
"TradingPlatform"
Name of the 3rd Dimesion RTD server. It is fixed and you can use in all formulas.
82
"GetMarketData"
Name of the method
83
"AUD_USD"
ID of the symbol, that you want to retreive data. You can get it from SymbolInfo panel.
84
"Bid"
Specified type of data you want to receive. For example: Bid, Ask, BidSize, AskSize.
85
"0"
Order number of level in Market Depth. Starts from 0.
86
"Emulator"
Name of the connection, which you want to use to search for required symbol. You can leave this parameter empty if you have only one connection.
87
88
89
5. GetHistory
90
91
Returns history for specified symbol, aggregation and date range.
92
You can just copy/paste this formula to use in your Excel files.
93
94
Syntax:
95
96
=RTD("tradingplatform";"";"GetHistory";"AUD_USD";"1Day";"Close";"10Day";"0";"Bid";"Emulator")
97
98
Parameters:
99
100
"TradingPlatform"
Name of the 3rd Dimesion RTD server. It is fixed and you can use in all formulas.