This is an old revision of the document!
DDE
T4 supports sending data via DDE to other application providers, such as Microsoft Excel and Open Office.
On the Main tab of the Main Properties you will find the DDE Format option. This allows you to change between Excel and OpenOffice Calc DDE syntax. They are not the same.
To recieve quote data from a particular DDE link MUST have a Quote Board window open and containing the desired market. Then click the ‘DDE’ button on the Quote Board. Right click on a cell in your spreadsheet and choose the ‘Paste’ menu item. This will paste a table of links to T4 that contain the same markets and columns as your Quote Board. Alternatively, you can right click on a single value in the Quote Board and select the ‘Copy DDE Link’ menu item, then paste into your spreadsheet. Only the specific value will be linked.
Again, the market must be displayed in the Quote Board window BEFORE it is linked to your spreadsheet. This also applies if you are loading a saved spreadsheet.
Getting Data Into Excel
IMPORTANT: In order to pull data via DDE from T4, you first need to have T4 open and subscribed to the desired markets. A subscription can be made by adding the desired markets to a quote board. It is good practice to open T4 first, then open Excel; and to close Excel first, then close T4.
The DDE link format for market data in Excel is:
=T4Screen|'MKT_<marketid>'!<value>
Where:
<marketid> is the unique identifier for the market in T4. This does not match any exchange published symbol. You can only obtain these by using the above method of copying the link for a value from T4 and pasting it into Excel or some other application.
<value> is the data value of the market that you want, for example last trade price. The valid values are shown below:
| Value | Meaning |
|---|---|
| Description | Row B1 |
| Numerator | Row B2 |
| Denominator | Row B2 |
| Settlement_Price,Settlement_Ticks | Row B1 |
| Open_Price,Open_Ticks | Row B2 |
| High_Price,High_Ticks | Row B2 |
| Low_Price,Low_Ticks | Row B1 |
| Mode | Row B2 |
| Total_Traded_Volume | Row B2 |
| Last_Trade_Volume | Row B1 |
| Last_Trade_Price,Last_Trade_Ticks | Row B2 |
| Bid_Volume | Row B2 |
| Bid_Price,Bid_Ticks | Row B1 |
| Offer_Volume | Row B2 |
| Offer_Price,Offer_Ticks | Row B2 |
| Net_Change_Price,Net_Change_Ticks | Row B1 |
The last trade information will include trades in outrights due to spreads trading if the frontend is configured to show that information itself.
The Bid and Offer information will include implied prices if the frontend is configured to show it.
The difference between the ‘_TICKS’ and ‘_PRICE’ values is that the ‘_PRICE’ values are display prices (what you see on the frontend, e.g. 30yr bond = 11215) and the ‘_TICKS’ values are the decimal equivalent that can have math done on it (e.g. 30yr bond = 11215 = 112 points + 15/32 = expressed as a decimal is (112 + (15/32) = 112.46875). Please note that the decimal point is not present for all markets and must be added in programmatically if desired.
To send account and position data you can use the same method as above, except using the Account window instead of the Quote Board. Note that if you trade in a new market then Excel will not automatically detect that position, you must place links in Excel for each specific position that you want.
The DDE link format for account data in Excel is:
=T4Screen|'ACT_<accountid>'!<value>
Where:
<accountid> is the unique identifier for the account in T4. This does not match the account number or name. You can only obtain these by using the above method of copying the link for a value from T4 and pasting it into Excel or some other application.
<value> is the data value of the account that you want, for example P&L. The valid values are shown below: