desktop:desktop_rtd

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
desktop:desktop_rtd [2021/12/08 17:35] – [Account Fields] robdesktop:desktop_rtd [2023/09/21 19:58] (current) – external edit 127.0.0.1
Line 4: Line 4:
 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. 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.
  
-Image+{{:desktop:enable_rtd.png|}}
  
 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. 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.
Line 28: Line 28:
 | FilledDelta  | =RTD("t4", , "Account",//ACCOUNT//,"FilledDelta")  |  | FilledDelta  | =RTD("t4", , "Account",//ACCOUNT//,"FilledDelta")  | 
 | PL  | =RTD("t4", , "Account",//ACCOUNT//,"PL")   |  | PL  | =RTD("t4", , "Account",//ACCOUNT//,"PL")   | 
-| OvernightUPL  | =RTD("t4", , "Account",ACCOUNT,"OvernightUPL")   |  +| OvernightUPL  | =RTD("t4", , "Account",//ACCOUNT//,"OvernightUPL")   |  
-| RPL  | =RTD("t4", , "Account",ACCOUNT,"RPL")  |  +| RPL  | =RTD("t4", , "Account",//ACCOUNT//,"RPL")  |  
-| UPL  | =RTD("t4", , "Account",ACCOUNT,"UPL")   |  +| UPL  | =RTD("t4", , "Account",//ACCOUNT//,"UPL")   |  
-| Status  | =RTD("t4", , "Account",ACCOUNT,"Status")  |  +| Status  | =RTD("t4", , "Account",//ACCOUNT//,"Status")  |  
-| Cash   | =RTD("t4", , "Account",ACCOUNT,"Cash")  |  +| Cash   | =RTD("t4", , "Account",//ACCOUNT//,"Cash")  |  
-| NetEquity  |  =RTD("t4", , "Account",ACCOUNT,"NetEquity")  |  +| NetEquity  | =RTD("t4", , "Account",//ACCOUNT//,"NetEquity")  |  
-| MinBalance  | =RTD("t4", , "Account",ACCOUNT,"MinBalance")   |  +| MinBalance  | =RTD("t4", , "Account",//ACCOUNT//,"MinBalance")   |  
-| LossLimitPercent  | =RTD("t4", , "Account",ACCOUNT,"LossLimitPercent")  |  +| LossLimitPercent  | =RTD("t4", , "Account",//ACCOUNT//,"LossLimitPercent")  |  
-| LossLimit  | =RTD("t4", , "Account",ACCOUNT,"LossLimit")  |  +| LossLimit  | =RTD("t4", , "Account",//ACCOUNT//,"LossLimit")  |  
-| WarningMargin   | =RTD("t4", , "Account",ACCOUNT,"WarningMargin")  |  +| WarningMargin   | =RTD("t4", , "Account",//ACCOUNT//,"WarningMargin")  |  
-| WarningPL  | =RTD("t4", , "Account",ACCOUNT,"WarningPL")   |  +| WarningPL  | =RTD("t4", , "Account",//ACCOUNT//,"WarningPL")   |  
-| WarningLL  | =RTD("t4", , "Account",ACCOUNT,"WarningLL")  |  +| WarningLL  | =RTD("t4", , "Account",//ACCOUNT//,"WarningLL")  |  
-| WarningWorst  | =RTD("t4", , "Account",ACCOUNT,"WarningWorst")  |  +| WarningWorst  | =RTD("t4", , "Account",//ACCOUNT//,"WarningWorst")  |  
-| WarningThresholdMargin | =RTD("t4", , "Account",ACCOUNT,"WarningThresholdMargin")  |  +| WarningThresholdMargin | =RTD("t4", , "Account",//ACCOUNT//,"WarningThresholdMargin")  |  
-| WarningThresholdPL  | =RTD("t4", , "Account",ACCOUNT,"WarningThresholdPL")  |  +| WarningThresholdPL  | =RTD("t4", , "Account",//ACCOUNT//,"WarningThresholdPL")  |  
-| WarningThresholdLL  | =RTD("t4", , "Account",ACCOUNT,"WarningThresholdLL")  |  +| WarningThresholdLL  | =RTD("t4", , "Account",//ACCOUNT//,"WarningThresholdLL")  |  
-| WarningThresholdWorst  | =RTD("t4", , "Account",ACCOUNT,"WarningThresholdWorst")   |  +| WarningThresholdWorst  | =RTD("t4", , "Account",//ACCOUNT//,"WarningThresholdWorst")   |  
-| TotalWorkingOrders   | =RTD("t4", , "Account",ACCOUNT,"TotalWorkingOrders")  |  +| TotalWorkingOrders   | =RTD("t4", , "Account",//ACCOUNT//,"TotalWorkingOrders")  |  
-| TotalWorkingQuantity  | =RTD("t4", , "Account",ACCOUNT,"TotalWorkingQuantity")  |  +| TotalWorkingQuantity  | =RTD("t4", , "Account",//ACCOUNT//,"TotalWorkingQuantity")  |  
-| TotalDayBuys  | =RTD("t4", , "Account",ACCOUNT,"TotalDayBuys")  |  +| TotalDayBuys  | =RTD("t4", , "Account",//ACCOUNT//,"TotalDayBuys")  |  
-| TotalDaySells  | =RTD("t4", , "Account",ACCOUNT,"TotalDaySells")   |  +| TotalDaySells  | =RTD("t4", , "Account",//ACCOUNT//,"TotalDaySells")   |  
-| Mode  | =RTD("t4", , "Account",ACCOUNT,"Mode")  |  +| Mode  | =RTD("t4", , "Account",//ACCOUNT//,"Mode")  |  
-| MaxPosition  | =RTD("t4", , "Account",ACCOUNT,"MaxPosition")  |  +| MaxPosition  | =RTD("t4", , "Account",//ACCOUNT//,"MaxPosition")  |  
-| Premium  | =RTD("t4", , "Account",ACCOUNT,"Premium")  |  +| Premium  | =RTD("t4", , "Account",//ACCOUNT//,"Premium")  |  
-| SettlementPL  | =RTD("t4", , "Account",ACCOUNT,"SettlementPL")  |  +| SettlementPL  | =RTD("t4", , "Account",//ACCOUNT//,"SettlementPL")  |  
-| PLPercent  | =RTD("t4", , "Account",ACCOUNT,"PLPercent")   |  +| PLPercent  | =RTD("t4", , "Account",//ACCOUNT//,"PLPercent")   |  
-| FeesAndCommissions   | =RTD("t4", , "Account",ACCOUNT,"FeesAndCommissions")  |  +| FeesAndCommissions   | =RTD("t4", , "Account",//ACCOUNT//,"FeesAndCommissions")  |  
-| NetSettlementPL| =RTD("t4", , "Account",ACCOUNT,"NetSettlementPL")  |  +| NetSettlementPL| =RTD("t4", , "Account",//ACCOUNT//,"NetSettlementPL")  |  
-| NetPL  | =RTD("t4", , "Account",ACCOUNT,"NetPL")  |  +| NetPL  | =RTD("t4", , "Account",//ACCOUNT//,"NetPL")  |  
-| DayPL  | =RTD("t4", , "Account",ACCOUNT,"DayPL")   |  +| DayPL  | =RTD("t4", , "Account",//ACCOUNT//,"DayPL")   |  
-| NetLiq  | =RTD("t4", , "Account",ACCOUNT,"NetLiq")   |  +| NetLiq  | =RTD("t4", , "Account",//ACCOUNT//,"NetLiq")   |  
-| ImportedNetLiq  | =RTD("t4", , "Account",ACCOUNT,"ImportedNetLiq")   |  +| ImportedNetLiq  | =RTD("t4", , "Account",//ACCOUNT//,"ImportedNetLiq")   |  
-| ImportedNetLiqDate | =RTD("t4", , "Account",ACCOUNT,"ImportedNetLiqDate")  |  +| ImportedNetLiqDate | =RTD("t4", , "Account",//ACCOUNT//,"ImportedNetLiqDate")  |  
-| PrevImportedNetLiq  | =RTD("t4", , "Account",ACCOUNT,"PrevImportedNetLiq")  |  +| PrevImportedNetLiq  | =RTD("t4", , "Account",//ACCOUNT//,"PrevImportedNetLiq")  |  
-| PrevimportedNetLiqDate  | =RTD("t4", , "Account",ACCOUNT,"PrevImportedNetLiqDate")  |  +| PrevimportedNetLiqDate  | =RTD("t4", , "Account",//ACCOUNT//,"PrevImportedNetLiqDate")  |  
-| Favorite  | =RTD("t4", , "Account",ACCOUNT,"Favorite")  |  +| Favorite  | =RTD("t4", , "Account",//ACCOUNT//,"Favorite")  |  
-| NetEquitySettle   |  =RTD("t4", , "Account",ACCOUNT,"NetEquitySettle")   |  +| NetEquitySettle   | =RTD("t4", , "Account",//ACCOUNT//,"NetEquitySettle")   |  
-| NetEquityMidPoint   | =RTD("t4", , "Account",ACCOUNT,"NetEquityMidPoint")  |  +| NetEquityMidPoint   | =RTD("t4", , "Account",//ACCOUNT//,"NetEquityMidPoint")  |  
-| NetEquityTheo  | =RTD("t4", , "Account",ACCOUNT,"NetEquityTheo")  |  +| NetEquityTheo  |=RTD("t4", , "Account",//ACCOUNT//,"NetEquityTheo")  |  
-| UPLPrevDayHeldSettleSettle | =RTD("t4", , "Account",ACCOUNT,"UPLPrevDayHeldSettleSettle")  |  +| UPLPrevDayHeldSettleSettle | =RTD("t4", , "Account",//ACCOUNT//,"UPLPrevDayHeldSettleSettle")  |  
-| UPLCurDayHeldSettle  | =RTD("t4", , "Account",ACCOUNT,"UPLCurDayHeldSettle")  |  +| UPLCurDayHeldSettle  | =RTD("t4", , "Account",//ACCOUNT//,"UPLCurDayHeldSettle")  |  
-| UPLTotalSettle  | =RTD("t4", , "Account",ACCOUNT,"UPLTotalSettle")  |  +| UPLTotalSettle  | =RTD("t4", , "Account",//ACCOUNT//,"UPLTotalSettle")  |  
-| UPLPrevDayMidPrice  | =RTD("t4", , "Account",ACCOUNT,"UPLPrevDayMidPrice")   |  +| UPLPrevDayMidPrice  | =RTD("t4", , "Account",//ACCOUNT//,"UPLPrevDayMidPrice")   |  
-| UPLCurDayMidPrice  | =RTD("t4", , "Account",ACCOUNT,"UPLCurDayMidPrice") |  +| UPLCurDayMidPrice  | =RTD("t4", , "Account",//ACCOUNT//,"UPLCurDayMidPrice") |  
-| UPLTotalMidPrice   | =RTD("t4", , "Account",ACCOUNT,"UPLTotalMidPrice") |  +| UPLTotalMidPrice   | =RTD("t4", , "Account",//ACCOUNT//,"UPLTotalMidPrice") |  
-| UPLPrevDayTheo  | =RTD("t4", , "Account",ACCOUNT,"UPLPrevDayTheo")  |  +| UPLPrevDayTheo  | =RTD("t4", , "Account",//ACCOUNT//,"UPLPrevDayTheo")  |  
-| UPLCurDayTheo  | =RTD("t4", , "Account",ACCOUNT,"UPLCurDayTheo")  |  +| UPLCurDayTheo  | =RTD("t4", , "Account",//ACCOUNT//,"UPLCurDayTheo")  |  
-| UPLTotalTheo   | =RTD("t4", , "Account",ACCOUNT,"UPLTotalTheo")  |  +| UPLTotalTheo   | =RTD("t4", , "Account",//ACCOUNT//,"UPLTotalTheo")  |  
-| Notifications  | =RTD("t4", , "Account",ACCOUNT,"Notifications")  | +| Notifications  | =RTD("t4", , "Account",//ACCOUNT//,"Notifications")  | 
  
 </datatables> </datatables>
Line 88: Line 88:
 <datatables> <datatables>
 ^ Field ^ Syntax ^  ^ Field ^ Syntax ^ 
-| AverageOpenPrice  | =RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"AverageOpenPrice")   | +| AverageOpenPrice  | =RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"AverageOpenPrice")   | 
-| Buys   | =RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"Buys")   | +| Buys   | =RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"Buys")   | 
-| Sells  | =RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"Sells")   | +| Sells  | =RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"Sells")   | 
-| DayBuys| =RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"DayBuys")   | +| DayBuys| =RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"DayBuys")   | 
-| DaySells |=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"DaySells")   | +| DaySells |=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"DaySells")   | 
-|WorkingBuys |=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"WorkingBuys")   | +|WorkingBuys |=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"WorkingBuys")   | 
-|WorkingSells|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"WorkingSells")   | +|WorkingSells|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"WorkingSells")   | 
-|UPL |=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"UPL")   | +|UPL |=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"UPL")   | 
-|RPL |=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"RPL")   | +|RPL |=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"RPL")   | 
-|UPLTrade|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"UPLTrade")   | +|UPLTrade|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"UPLTrade")   | 
-|OvernightUPL|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"OvernightUPL")   | +|OvernightUPL|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"OvernightUPL")   | 
-|TotalBuyFillPrice|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"TotalBuyFillPrice")   | +|TotalBuyFillPrice|=RTD("t4", , "//Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"TotalBuyFillPrice")   | 
-|TotalSellFillPrice|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"TotalSellFillPrice")   | +|TotalSellFillPrice|=RTD("t4", , "//Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"TotalSellFillPrice")   | 
-|DayTotalBuyFillPrice|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"DayTotalBuyFillPrice")   | +|DayTotalBuyFillPrice|=RTD("t4", , "//Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"DayTotalBuyFillPrice")   | 
-|DayTotalSellFillPrice|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"DayTotalSellFillPrice")   | +|DayTotalSellFillPrice|=RTD("t4", , "//Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"DayTotalSellFillPrice")   | 
-|TotalOpenPrice|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"TotalOpenPrice")   | +|TotalOpenPrice|=RTD("t4", , "//Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"TotalOpenPrice")   | 
-|TotalOpenVolume|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"TotalOpenVolume")   | +|TotalOpenVolume|=RTD("t4", , "//Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"TotalOpenVolume")   | 
-|TotalOvernightPrice|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"TotalOvernightPrice")   | +|TotalOvernightPrice|=RTD("t4", , "//Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"TotalOvernightPrice")   | 
-|OvernightPosition|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"OvernightPosition")   | +|OvernightPosition|=RTD("t4", , "//Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"OvernightPosition")   | 
-|Margin|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"Margin")   | +|Margin|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"Margin")   | 
-|PrevMargin|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"PrevMargin")   | +|PrevMargin|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"PrevMargin")   | 
-|MP|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"MP")   | +|MP|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"MP")   | 
-|Premium|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"Premium")   | +|Premium|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"Premium")   | 
-|Net|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"Net")   | +|Net|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"Net")   | 
-|DayNet|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"DayNet")   | +|DayNet|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"DayNet")   | 
-|PrevNet|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"PrevNet")   | +|PrevNet|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"PrevNet")   | 
-|Worst|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"Worst")   | +|Worst|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"Worst")   | 
-|PL|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"PL")   | +|PL|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"PL")   | 
-|PLTrade|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"PLTrade")   | +|PLTrade|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"PLTrade")   | 
-|DayPL|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"DayPL")   | +|DayPL|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"DayPL")   | 
-|DayPLTrade|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"DayPLTrade")   | +|DayPLTrade|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"DayPLTrade")   | 
-|UPLUSD|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"UPLUSD")   | +|UPLUSD|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"UPLUSD")   | 
-|UPLTUSD|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"UPLTUSD")   | +|UPLTUSD|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"UPLTUSD")   | 
-|DayRPL|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"DayRPL")   | +|DayRPL|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"DayRPL")   | 
-|DayRPLUSD|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"DayRPLUSD")   | +|DayRPLUSD|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"DayRPLUSD")   | 
-|DayUPL|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"DayUPL")   | +|DayUPL|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"DayUPL")   | 
-|DayUPLUSD|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"DayUPLUSD")   | +|DayUPLUSD|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"DayUPLUSD")   | 
-|DayUPLTrade|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"DayUPLTrade")   | +|DayUPLTrade|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"DayUPLTrade")   | 
-|DayUPLTUSD|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"DayUPLTUSD")   | +|DayUPLTUSD|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"DayUPLTUSD")   | 
-|UPLPrevDayHeldSettleSettle|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"UPLPrevDayHeldSettleSettle")   | +|UPLPrevDayHeldSettleSettle|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"UPLPrevDayHeldSettleSettle")   | 
-|UPLCurDayHeldSettle|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"UPLCurDayHeldSettle")   | +|UPLCurDayHeldSettle|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"UPLCurDayHeldSettle")   | 
-|UPLTotalSettle|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"UPLTotalSettle")   | +|UPLTotalSettle|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"UPLTotalSettle")   | 
-|UPLPrevDayMidPrice|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"UPLPrevDayMidPrice")   | +|UPLPrevDayMidPrice|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"UPLPrevDayMidPrice")   | 
-|UPLCurDayMidPrice|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"UPLCurDayMidPrice")   | +|UPLCurDayMidPrice|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"UPLCurDayMidPrice")   | 
-|UPLTotalMidPrice|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"UPLTotalMidPrice")   | +|UPLTotalMidPrice|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"UPLTotalMidPrice")   | 
-|UPLPrevDayTheo|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"UPLPrevDayTheo")   | +|UPLPrevDayTheo|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"UPLPrevDayTheo")   | 
-|UPLCurDayTheo|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"UPLCurDayTheo")   | +|UPLCurDayTheo|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"UPLCurDayTheo")   | 
-|UPLTotalTheo|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"UPLTotalTheo")   | +|UPLTotalTheo|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"UPLTotalTheo")   | 
-|FeesAndCommissions|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"FeesAndCommissions")   | +|FeesAndCommissions|=RTD("t4", , "//Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"FeesAndCommissions")   | 
-|TradeDate|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"TradeDate")   | +|TradeDate|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"TradeDate")   | 
-|AverageLongPrice|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"AverageLongPrice")   | +|AverageLongPrice|=RTD("t4", , "//Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"AverageLongPrice")   | 
-|AverageShortPrice|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"AverageShortPrice")   | +|AverageShortPrice|=RTD("t4", , "//Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"AverageShortPrice")   | 
-|DayAverageLongPrice|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"DayAverageLongPrice")   | +|DayAverageLongPrice|=RTD("t4", , "//Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"DayAverageLongPrice")   | 
-|DayAverageShortPrice|=RTD("t4", , "Position",ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID,"DayAverageShortPrice")   |+|DayAverageShortPrice|=RTD("t4", , "Position",//ACCOUNT,EXCHANGEID,CONTRACTID,MARKETID//,"DayAverageShortPrice")   |
 </datatables> </datatables>
  
Line 150: Line 150:
 <datatables> <datatables>
 ^ Field ^ Syntax ^  ^ Field ^ Syntax ^ 
-| Row A1   | Row B1   |  +| High   | =RTD("t4", , "Market",//EXCHANGEID,CONTRACTID,MARKETID//,"High","Decimal")  |  
-| Row A2   | Row B2   |  +| Low   | =RTD("t4", , "Market",//EXCHANGEID,CONTRACTID,MARKETID//,"Low","Decimal")   |  
-| Row A3   | Row B2   |  +| Best Bid Price   | =RTD("t4", , "Market",//EXCHANGEID,CONTRACTID,MARKETID//,"BestBid","Decimal")  |  
-| Row A4   | Row B1   |  +| Best Bid Volume  | =RTD("t4", , "Market",//EXCHANGEID,CONTRACTID,MARKETID//,"BestBid","Volume") |  
-| Row A5   | Row B2   |  +| Best Bid Display  | =RTD("t4", , "Market",//EXCHANGEID,CONTRACTID,MARKETID//,"BestBidDisplay","Volume") |  
-| Row A6   | Row B2   |  +| Best Offer Price   | =RTD("t4", , "Market",//EXCHANGEID,CONTRACTID,MARKETID//,"BestOffer","Decimal")   |  
-| Row A1   | Row B1   |  +| Best Offer Volume   | =RTD("t4", , "Market",//EXCHANGEID,CONTRACTID,MARKETID//,"BestOffer","Volume")  |  
-| Row A2   | Row B2   |  +| Best Offer Display  | =RTD("t4", , "Market",//EXCHANGEID,CONTRACTID,MARKETID//,"BestOfferDisplay","Volume")  |  
-| Row A3   | Row B2   |  +| Settlement  | =RTD("t4", , "Market",//EXCHANGEID,CONTRACTID,MARKETID//,"Settlement","Decimal")  |  
-| Row A4   | Row B1   |  +| Held Settlement  | =RTD("t4", , "Market",//EXCHANGEID,CONTRACTID,MARKETID//,"SettlementHeld","Decimal")  |  
-| Row A5   | Row B2   |  +| Last Trade Price  | =RTD("t4", , "Market",//EXCHANGEID,CONTRACTID,MARKETID//,"LastTrade","Decimal")  |  
-| Row A6   | Row B2   |  +| Last Trade Volume  | =RTD("t4", , "Market",//EXCHANGEID,CONTRACTID,MARKETID//,"LastTrade","Volume")   |  
-| Row A1   | Row B1   |  +| Bid Price Depth   | =RTD("t4", , "Market",//EXCHANGEID,CONTRACTID,MARKETID//,"Bid","Decimal","0")   |  
-| Row A2   | Row B2   |  +| Bid Volume Depth   | =RTD("t4", , "Market",//EXCHANGEID,CONTRACTID,MARKETID//,"Bid","Volume","0")   |  
-| Row A3   | Row B2   |  +| Bid Display Depth  | =RTD("t4", , "Market",//EXCHANGEID,CONTRACTID,MARKETID//,"BidDisplay","Volume","0")  |  
-| Row A4   | Row B1   |  +| Offer Price Depth   |=RTD("t4", , "Market",//EXCHANGEID,CONTRACTID,MARKETID//,"Offer","Decimal","0")  |  
-| Row A5   | Row B2   |  +| Offer Volume Depth   |=RTD("t4", , "Market",//EXCHANGEID,CONTRACTID,MARKETID//,"Offer","Volume","0")  |  
-| Row A6   | Row B2   |  +| Offer Display Depth  |=RTD("t4", , "Market",EXCHANGEID,CONTRACTID,MARKETID,"OfferDisplay","Volume","0")   |  
-| Row A1   | Row B1   |  +| Market Description  |=RTD("t4", , "Market",EXCHANGEID,CONTRACTID,MARKETID,"Description")  |  
-| Row A2   | Row B2   |  +| Expiry Month   |=RTD("t4", , "Market",//EXCHANGEID,CONTRACTID,MARKETID//,"ExpiryMonth")  |  
-| Row A3   | Row B2   |  +| Expiry Year  | =RTD("t4", , "Market",//EXCHANGEID,CONTRACTID,MARKETID//,"ExpiryYear")   |  
-| Row A4   | Row B1   |  +| Total Traded Volume  |=RTD("t4", , "Market",//EXCHANGEID,CONTRACTID,MARKETID//,"TTV")  | 
-| Row A5   | Row B2   |  +
-| Row A6   | Row B2   |  +
-| Row A1   | Row B1   |  +
-| Row A2   | Row B2   |  +
-| Row A3   | Row B2   |  +
-| Row A4   | Row B1   |  +
-| Row A5   | Row B2   |  +
-| Row A6   | Row B2   |  +
-| Row A1   | Row B1   |  +
-| Row A2   | Row B2   |  +
-| Row A3   | Row B2   |  +
-| Row A4   | Row B1   |  +
-| Row A5   | Row B2   |  +
-| Row A6   | Row B2   |  +
-| Row A1   | Row B1   |  +
-| Row A2   | Row B2   |  +
-| Row A3   | Row B2   |  +
-| Row A4   | Row B1   |  +
-| Row A5   | Row B2   |  +
-| Row A6   | Row B2   |  +
-| Row A1   | Row B1   |  +
-| Row A2   | Row B2   |  +
-| Row A3   | Row B2   |  +
-| Row A4   | Row B1   |  +
-| Row A5   | Row B2   |  +
-| Row A6   | Row B2   |  +
-| Row A1   | Row B1   |  +
-| Row A2   | Row B2   |  +
-| Row A3   | Row B2   |  +
-| Row A4   | Row B1   |  +
-| Row A5   | Row B2   |  +
-| Row A6   | Row B2   |  +
-| Row A1   | Row B1   |  +
-| Row A2   | Row B2   |  +
-| Row A3   | Row B2   |  +
-| Row A4   | Row B1   |  +
-| Row A5   | Row B2   |  +
-| Row A6   | Row B2   |  +
-| Row A1   | Row B1   |  +
-| Row A2   | Row B2   |  +
-| Row A3   | Row B2   |  +
-| Row A4   | Row B1   |  +
-| Row A5   | Row B2   |  +
-| Row A6   | Row B2   | +
  
 </datatables> </datatables>
  • desktop/desktop_rtd.1638984942.txt.gz
  • Last modified: 2023/09/21 19:55
  • (external edit)