User Tools

  • Vistasource Document Library

Differences

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

Link to this comparison view

rtw_4.4:subscribe [2011/09/23 15:56]
cjaeger
rtw_4.4:subscribe [2018/08/04 20:08]
Line 1: Line 1:
-====== Subscribe ====== 
-  
-You can subscribe to data with RTW using the RTW COM Server (rts.exe) and the RTD function. The RTD function is an Excel function available in Microsoft® Excel 2002 or higher. The RTD function retrieves real-time data from a program that supports COM automation. Please see the Microsoft® Excel Help for more information on COM automation. ​ 
-  
-RTW offers three menu options that facilitate building an RTD formula for subscribing to data. 
-  
-These options are: 
-  
-  *Quote Wizard – Steps through the process of building an RTD formula 
-  *Quote Table  –  Creates a table of RTD formulas referencing record and field names in a spreadsheet 
-  *Quick Quote – Provides an easy way to automatically build a RTD formula 
-  
-For more details regarding these options, see [[Quote Wizard]], [[Quote Table]] and [[Quick Quote]]. 
-  
-The generic syntax for Microsoft® Excel RTD is as follows: 
-  
-=RTD(ProgID,​ server, topic1, [topic2], …) 
-  
-When using RTW to subscribe to data, the RTD function uses the following arguments: 
-  
-=RTD(ProgId,​ server, command, engine, servicename,​ recordname, fieldname1, […, fieldnameN]) 
-  
-The arguments have the following meaning: 
  
-^Argument^Explanation^ ​ 
-|ProgID|The name of the RTW RTD Server, Vistasource.RtdServer.| 
-|Server |Remains null.| ​ 
-|Command|“rt”,​ to indicate the subscribe command.| ​ 
-|Data Range|The cell or cell range containing the value(s) to publish.| ​ 
-|Engine|The RTW engine that will do the subscribing,​ \\ e.g. vsRMDS (RMDS SFC), vsRMDS2 (RMDS RFA), axbloom (Bloomberg),​ vsnf (Netfeed), rthttp (WebData).| 
-|Servicename|The name of the service to which you are subscribing.\\ For Bloomberg, this references the Record Type.| ​ 
-|Recordname|The name of the record to subscribe to.|  
-|Fieldname1|The name of the first field, such as BID or ASK.|  
-|FieldnameN|The name of the last field.| 
-  
-Example of an RTD function for subscribing:​ 
-The following formula subscribes to the Microsoft ASK price via the RMDS (RFA) engine with the IDN service: 
- 
-  =RTD("​Vistasource.RtdServer",,"​rt","​vsRMDS2","​IDN","​MSFT.O",​ "​ASK"​) 
-  
-Example of an RTD function for subscribing to multiple fields: 
- 
-To retrieve multiple field values with one formula, the RTD function would need to return an array of data. However, RTD does not support this functionality (see [[http://​support.microsoft.com/​kb/​286258|Microsoft KB article 286258]]). To work around this limitation, the RTW wrapper function PARSE_DATA can be used. This function "​parses"​ the string array of incoming data. See [[RTW Functions]] for more information. The Quote dialogs will automatically use the PARSE_DATA function when creating array formulas. 
-  
-The following formula subscribes to the Microsoft ASK and BID prices in real-time via the RMDS (RFA) engine with the IDN service: 
-  
-<​file>​{=PARSE_DATA(RTD("​vistasource.rtdserver",,"​rt","​vsRMDS2","​IDN","​MSFT.O","​ASK","​BID"​))}</​file>​ 
-  
-<note important>​For PARSE_DATA to work properly, the "​Decimal separator"​ in Microsoft® Excel needs to be set to "​."​ (period), and the "​Thousands separator"​ needs to be set to ","​ (comma). To verify this setting, please check **Excel Options -> Advanced -> System Separators**.</​note>​ 
-  
-  
-== See Also: ==  
-{{pagequery>​@rtw_4.4 quote|functions|subscribe;​title}} 
-{{pagequery>​@rtw_4.4 subscribe;​title}}