Differences

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

--- desktop:desktop_dde [2021/12/21 19:22] – [Changing the DDE Advertise Interval] 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 144: / Line 144: @@
 ====== 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|}}