Differences

This shows you the differences between two versions of the page.

--- desktop:desktop_dde [2021/12/21 19:21] – [DDE Commands] rob
+++ desktop:desktop_dde [2023/09/21 19:58] (current) – external edit 127.0.0.1
@@ Line 90: / Line 90: @@
 <datatables>
 ^ Column A ^ Column B ^
-| Row A1   | Row B1   |
+| Description| The name of the market this position is for.  |
-| Row A2   | Row B2   |
+| Net  | The net position of this account in this market.   |
-| Row A2   | Row B2   |
+| PL   | The total P&L of this position.  |
-| Row A1   | Row B1   |
+| UPL   | The unrealized P&L from the open position.  |
-| Row A2   | Row B2   |
+| RPL   | The realized P&L from the closed position.  |
-| Row A2   | Row B2   |
+| Overnight_UPL | The unrealized P&L due to positions carried over from the previous trading day.  |
-| Row A1   | Row B1   |
+| Margin  | The margin requirement for this position. |
-| Row A2   | Row B2   |
+| Buys   | The total number of contracts bought.  |
-| Row A2   | Row B2   |
+| Sells   | The total number of contracts sold.  |
-| Row A1   | Row B1   |
+| Working_Buys  | The number of buy contracts that are working.   |
-| Row A2   | Row B2   |
+| Working_Sells   | The number of sell contracts that are working.  |
 </datatables>
@@ Line 127: / Line 127: @@
 If the command succeeds then the value '<Command Succeeded>' will be returned to Excel, if the market is not found then '<Market Not Found>' is returned.
 ====== Changing the DDE Advertise Interval ======
+You can change the timer interval that DDE advertisements are sent on. An advertisement is sent when a piece of data you are interested in has changed, e.g. last trade price. This is set at 10ms by default. If you want to slow down the updates then you can change this to be anything up to 60,000ms.
+To change the timer you need to enter the following into a cell:
+=T4Screen|'TMR_<Interval>'!SET
+where <Interval> is the timer interval to set, in milliseconds, between 10 and 60000.
+e.g. =T4Screen|'TMR_500'!SET will set the timer interval to be 500ms.
+If the command succeeds then the value '<Command Succeeded>' will be returned to Excel.
+If you close T4 desktop and reopen it then you would need to execute this command again for it to take effect.
 ====== Breaking DDE Links ======
+Excel will allow a user to manually edit excel links. This provides the opportunity for end user error in the form of a typo as Excel DDE links are case sensitive. If a typo occurs the user will have no choice but to remove the broken link and create it correctly from scratch. This is a limitation in Excel.
+An example would be if the month is changed using lower case charactors. Excel won't allow the correction of the formula and the formula will never again work.
+In Excel 2010 go to the Data tab and click Edit Links.
+A dialog will be displayed.
+Find the broken link and click "Break Link" and close the dialog.
+Use T4 to generate the correct link so that there is no chance of a typo.
+{{:desktop:breaklink.png|}}