Page History: RTD
Compare Page Revisions
Page Revision: 2021/11/03 14:50
T4 supports sending data via RTD to Microsoft Excel. RTD is a newer protocol than DDE and offers better performance and reliability. RTD does not require a quote board to be open in T4 in order to stream data. It only requires T4 to be running and the proper data subscriptions to be in place for the T4 user.
To enable RTD, go to the main properties, expand the "General" section, then choose "RTD." On the right side, check the box to "Enable RTD Server." You can change the price format in this section of the menu as well. The default is "Decimal," but hovering over the menu item will provide examples of other price display formats.
Once RTD is enabled, all former "Copy DDE" buttons will show as "Copy RTD." Please note that at this time, charts do not support RTD. Charts will still provide DDE links and DDE and RTD can be used simultaneously in the same Excel sheet. From a Quote Board, click the "Copy RTD" button and then paste into Excel. Once pasted in Excel, RTD formulas can be manipulated to show different markets and data. A list of available fields is outlined at the bottom of this page.
From a Quote Board, you can right click on a market and choose "Copy Market Depth RTD Link" to copy the first 5 levels of depth to Excel. The formulas can be expanded to up to 10 levels of depth after being added to Excel by altering the RTD code in each cell.
At the moment, order entry and revisions are not available via RTD. The following Quote Board columns are not yet supported with RTD:
Account Fields
Change the italic portions of the syntax to the relevant values for your purposes.
| Field | Syntax |
|---|
| AccountID | =RTD("t4", , "Account",ACCOUNT,"AccountID") |
| HIGH | High price |
| LOW | Low price |
| CLOSE | Closing price |
| TYPICAL, TYP | Typical price (OPEN + HIGH + CLOSE) / 3 |
| VOLUME | Volume |
| VOLUMEATBID | Volume that occurred at the bid price. |
| VOLUMEATOFFER | Volume that occurred at the offer price. |
| TRADES | Number of trades that make up the current bar. |
| TRADESATBID | Number of trades that occurred at the bidprice. |
| TRADESATOFFER | Number of trades that occurred at the offer price. |
| INDEX | Index of the current bar being computed. This runs from 0 to COUNT - 1. |
| COUNT | Number of bars on the chart. |
| BARPERCENT | Percentage completion of the current bar. E.g. 15 minutes into a 1 hour bar would give 0.25 |
| NUMERATOR | The numerator of the market. |
| DENOMINATOR | The denominator of the market. |
| TICKVALUE | The tick value of the market. |
| NIL | Special "non-value" field. |
| MARKETID | The text market id. |
| MARKETDESCRIPTION | The text description of the market. |