User Tools

  • Vistasource Document Library

RMDS (SFC) Engine Operation

This section covers the following topics:

To subscribe and publish data in Microsoft Excel, RTW provides a COM Server (rts) that works in conjunction with Microsoft Excel’s RTD function (available only in Excel 2002 and higher; see the Microsoft Excel Help for more information on RTD and COM automation). The RTW COM Server can also be used with custom stand-alone applications. For more information about the RTW COM Server and the RTW COM Interface, see RTW COM Interface.

Subscribe

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

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:

ProgID The name of the RTW RTD Server: Vistasource.RtdServer
Server This argument remains null.
Command “rt”, to indicate the subscribe command
Engine vsRMDS (RMDS SFC)
Servicename The name of the service to which you are subscribing.
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 RTW RMDS (SFC) engine with the IDN service:

=RTD("Vistasource.RtdServer",,"rt","vsRMDS","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 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. The Quote dialogs will automatically use the PARSE_DATA function when creating array formulas. See RTW Functions for more information about PARSE_DATA and other wrapper functions.

The following formula subscribes to the Microsoft ASK and BID prices in real-time via the RTW RMDS (SFC) engine with the IDN service:

=PARSE_DATA(RTD("vistasource.rtdserver",,"rt","vsRMDS","IDN","MSFT.O","ASK","BID"))

Quote Wizard

The Quote Wizard steps through the process of building an RTD formula and subscribing to data provided by the data distribution system.

Select Vistasource → RMDS (SFC) → Quote Wizard to start the Quote Wizard.

The Quote Wizard consists of a total of five screens. Each screen details the steps of building a formula, displaying the status of the formula as you build it.

By choosing multiple record and field names, the Quote Wizard also allows you to create, format, and determine the layout of a “quote table.”

Quick Quote

This option provides an easy way to automatically build an RTD formula which subscribes to fields of a single record.

Select Vistasource → RMDS (SFC) → Quick Quote to create a subscribe quote. The Quick Quote dialog box provides an easy way to automatically build a RTD formula which subscribes to fields of a single record.

The RTW RMDS (SFC) Quick Quote dialog box contains the following options:

Cell Range Enter a start or cell range for the formula’s output. To select a cell directly in the worksheet without having to type its reference, click on the icon next to the entry field.
Orientation The orientation must be horizontal.
Build As Array Formula A single RTD array formula can be created which returns values for all the fields of the record. Each record will have its own RTD formula. Turn this option off to create individual formulas for each field.
Note: If Build as Array Formula is selected, the wrapper function PARSE_DATA is used. To edit an array formula, select the entire output range, place the cursor in the edit line, edit, and then press Ctrl-Shift-Return. If an attempt is made to edit a single cell in the range, a message box displays indicating that the cell cannot be edited, because it is the output of an array formula. For more information on PARSE_DATA, see RTW Functions.
Engine The engine name is vsRMDS.
Service/Record Type Select the service/record type, e.g. IDN.
Record Enter the record name. Clicking on the control on the right displays a history list with your previous choices. The list is stored in a file called [Engine name]_history.txt. Note: In Windows 7, this history file is located in %USERPROFILE%\AppData\Roaming\Vistasource\RTW. In Windows XP, the file is located in %USERPROFILE%\Application Data\Vistasource\RTW. If the AppData or Application directory does not exist the file is located in C:\.
Fields to Retrieve Enter the names of the fields you want to subscribe to, then press RETURN or click the Add Field button after each field name to add the field to the list box.
Remove Selected Field To remove fields, select a field and then click on the option button.
Up and Down Arrows To rearrange the order of the fields, click on the field name and move it with the arrows.
Field List The RTW RMDS (SFC) Field List dialog box displays all valid fields for the specified record. Select the required field from the Available Fields list box and click Add. The field name is added to the Selected Fields list box. To remove a field name, select the field and click Remove. Once the required fields are selected, click OK to return to the RTW RMDS (SFC) Quick Quote dialog box.
Add to Favorites To add frequently used records to a list of favorites, select a record and click the option button. To check which records have been added in previous and current sessions, click View Favorites to access the RTW RMDS (SFC) Records - Favorites List.

Click OK to insert the formula in your workbook.

Quote Table

This option allows you to create a table of RTD formulas which reference record and field names in a spreadsheet.

Organize your spreadsheet with record names in a column and field names in an adjacent row. Select Vistasource → RMDS (SFC) → Quote Table to display the RTW RMDS (SFC) Quote Table dialog box.

The RTW RMDS (SFC) Quote Table dialog box contains the following options:

Cell Range Enter the cell range for your table. Cells can be selected directly in the worksheet without having to type their reference by clicking on the icon next to the entry field. The desired range can also be selected before launching the dialog box.
Build As Array Formula By default, an individual RTD formula will be created for each chain record. Turn this option on to create a single RTD array formula which returns values for all the records in the chain.
Note: If Build as Array Formula is selected, the wrapper function PARSE_DATA is used. To edit an array formula, select the entire output range, place the cursor in the edit line, edit, and then press Ctrl-Shift-Return. If an attempt is made to edit a single cell in the range, a message box displays indicating that the cell cannot be edited, because it is the output of an array formula. For more information on PARSE_DATA, see RTW Functions.
Engine The engine name is vsRMDS.
Service/Record Type Select the service/record type, e.g. IDN.
Record Name Location The record names can only reside in a column.
Use Cell Addresses for Rows/Columns Check this option to use the cell references in the formula instead of the record and field names. This option is turned on by default, and ensures that the formula stays valid if the record or field names are changed. If this option is turned off, the actual record and field names will become part of the formula.

Click OK to insert the RTD formulas in your workbook.

Chain

The RTW RMDS (SFC) Chain dialog box allows you to subscribe to groups of records of related data. Records linked within the chain are placed in consecutive cells with RTD formulas. By specifying a chain record root, the name of each record in the chain is returned. For a list of valid chains, please refer to the appropriate Reuters Services guide.

To construct a chain of data select Vistasource → RMDS (SFC) → Chain to display the RTW RMDS (SFC) Chain dialog box.

The RTW RMDS (SFC) Chain dialog box contains the following options:

Record Root Enter the name of the record root, e.g. .FTSE, .DJI (both indexes) or .AV.O (active volume list). When using a SASS3 connection, the service name and the sector “LINK” must be specified (e.g. RSF.LINK.^AV.O).
Chain Identifier Enter the type of chain you are building, e.g. Futures, Equity Option, Money 2000. If you know the exact Record Root, you may also specify ‘None.’
Cell Range Enter a start cell or a cell range for your formula’s output. You can select cells directly in the worksheet without having to type their reference by clicking on the icon next to the entry field. In many cases you just need to enter a start cell.
Build As Array Formula By default, an individual RTD formula will be created for each chain record. Turn this option on to create a single RTD array formula which returns values for all the records in the chain.
Note: If Build as Array Formula is selected, the wrapper function PARSE_DATA is used. To edit an array formula, select the entire output range, place the cursor in the edit line, edit, and then press Ctrl-Shift-Return. If an attempt is made to edit a single cell in the range, a message box displays indicating that the cell cannot be edited, because it is the output of an array formula. For more information on PARSE_DATA, see RTW Functions.
Engine The engine name is vsRMDS.
Service Select the service, e.g. IDN, RSF.
Chain Direction The chain can only reside in Columns.
Use Cell Addresses for Rows/Columns This option ensures that the chain setup stays valid if you change the record or field names.
Messages As the chain is being built, any messages or errors will display in this area.

Click OK to initiate the construction of the chain.

Publish

Vistasource RTW offers the ability to publish and contribute market data using the RTW RMDS (SFC) engine.

While the terms “publish” and “contribute” are not synonymous, the term “publish” is used in this document for both concepts (unless otherwise specified).

The Microsoft Excel RTD function is used to publish data. The RTD publish formula will execute when there is any change to the data that it references. If the publish is successful, the cell containing the RTD formula displays OK. If it is unsuccessful, the cell containing the RTD formula displays #VALUE.

The generic syntax for the Microsoft Excel RTD function is as follows:

=RTD(ProgID, server, topic1, [topic2], ...)  

When using RTW to publish, the RTD function takes the following arguments:

=RTD(ProgId, server, command, dataRange, engine, servicename, recordname, fieldname1, […, fieldnameN]) 

The arguments have the following meaning:

ProgIDThe name of the RTW RTD Server: Vistasource.RtdServer
ServerRemains null.
Command”rtinsert”, to indicate the publish command.
Data RangeThe cell or cell range containing the value(s) to publish
EngineThe engine name is vsRMDS.
ServicenameThe name of the data feed/service.
RecordnameThe name of the record to publish.
Fieldname1,…The name of the first field, such as BID or ASK.
FieldnameNThe name of the last field.

RTW offers a publish dialog that facilitates building an RTD publishing formula.

Select Vistasource → RMDS (SFC) → Publish to display the RTW RMDS (SFC) Publish dialog box.

The RTW RMDS (SFC) Publish dialog box contains the following fields:

Cell RangeEnter a start cell for the formula’s output (by default the current cell is selected). To select a cell directly in the worksheet without having to type its reference, click on the icon next to the entry field.
Data RangeEnter the cell reference or range of the data that you want to publish. You can select cells directly in the worksheet without having to type their reference by clicking on the icon next to the entry field.
EngineThe engine name is vsRMDS.
Form Class Number (TIC only)Enter the form class number of the insert service, if using a TIB implementation with QFORM data.
ServiceSelect the service, e.g. RSF, IDN.
Record NameEnter the record name to which you want to publish, e.g. SH.ANY.MYREC.NaE
Note: When publishing market data (as opposed to contributing) the record name must be a four-part subject name.
Fields to PublishEnter the names of the fields you want to publish. Press RETURN or click the Add Field button after each field name to add the field to the list box.
Remove Selected FieldRemove fields by selecting a field and then clicking on the option button.
Up and Down Arrows (Icons)Rearrange the order of the fields by clicking on one and moving it with the arrows.
Field ListThe RTW RMDS (SFC) Field List dialog box displays all valid fields for the specified record. Select the desired field from the Available Fields list box and click Add. The field name is added to the Selected Fields list box. To remove a field name, select the field and click Remove. After selecting all the fields you want to subscribe, click OK to return the list of fields to the RTW RMDS (SFC) Publish dialog box.
Add to FavoritesAdd frequently used records to a list of favorites by selecting a record and clicking on the Add Favorites button. To check what records have been added in past and current sessions, click View Favorites to access the RTW RMDS (SFC) Records - Favorites List. See Favorites for more information on adding, deleting and updating this list.

Click OK in the RTW RMDS (SFC) Publish dialog box to insert the publish formula in your workbook.

Example of an RTD function for contributing with a two-part subject name

The following formula contributes the value in cell C15 as the BID of MyRec.O via the RTW RMDS (SFC) engine to the DTS service.

=RTD("Vistasource.RtdServer",,"rtinsert",C15,"vsRMDS","DTS","MyRec.O"," BID")

Example of an RTD function for publishing with a four-part subject name

The following formula publishes the value in cell C15 as the BID of SH.ANY.MyRec.NaE via the RTW RMDS (SFC) engine to the SH service.

=RTD("Vistasource.RtdServer",,"rtinsert",C15,"vsRMDS","SH","SH.ANY.MyRec.NaE"," BID")

Example of an RTD function for publishing multiple fields
To publish multiple field values with one formula, the RTD function would need to receive an array of data. However, RTD does not support this functionality (see Microsoft KB article 286258). To work around this limitation, the RTW wrapper function PACKAGE_DATA can be used. This function “packages” the range of values to publish as a string. The Publish dialogs will automatically use the PACKAGE_DATA function when publishing a range of fields. See RTW Functions for more information about PACKAGE_DATA and other wrapper functions.

The following formula publishes the values in cells D3 and D4 to the fields BID and ASK in record SH.ANY.MyRec.NaE via the RTW RMDS (SFC) engine using the PACKAGE_DATA function:

=RTD("vistasource.rtdserver",,"rtinsert",PACKAGE_DATA(D3:D4),"vsRMDS","DTS"," SH.ANY.MyRec.NaE","BID","ASK")

where DTS (Data Transformation System) is the name of the service to which you are publishing.

The PACKAGE_DATA function can also be used to package a range of field names. For example,:

=RTD("vistasource.rtdserver",,"rtinsert",PACKAGE_DATA(D3:D4),"vsRMDS","DTS","SH.ANY.MyRec.NaE",PACKAGE_DATA(C3:C4)) 

in which case BID would be in C3 and ASK would be in C4, and DTS (Data Transformation System) is the name of the service to which you are publishing.

RTW Functions

RTW specific functions are added to Microsoft Excel upon installation. They can be accessed by selecting Formulas → Insert Functions → Select a Category → Vistasource RTW.

In versions prior to Microsoft Excel 2007, select Insert → Function in the menu bar to display the “Insert Function” dialog box. Select the Vistasource RTW category to display the RTW functions.

Wrapper Functions

The following functions call the RTD function with the required default arguments, plus the given arguments. In this way, redundant arguments are hidden, exposing only the data that is important to you.

FUNCTIONRTS
ARGUMENTS Engine, service, record, field1, field2, … fieldN
EXAMPLE
=RTS("vsRMDS","IDN", "MSFT.O", "ASK")
DESCRIPTION Subscribe to data using the specified engine
NOTES Engine,Service,Record,Field1 are obligatory. The maximum number of fields is 51 (24 for Excel versions prior to 2007).
FUNCTION RTS_SFC
ARGUMENTS Service, record, field1, field2, … fieldN
EXAMPLE
=RTS_SFC("IDN", "MSFT.O", "ASK")
DESCRIPTION Subscribe to data using the RTW RMDS (SFC) engine
NOTES Service,Record,Field1 are obligatory. The maximum number of fields is 51 (24 for Excel versions prior to 2007).
FUNCTIONRTINSERT
ARGUMENTSValue(s), engine, service, record, field1, field2, … fieldN
EXAMPLE
=RTINSERT(C15,"vsRMDS","DTS", "MYREC", "BID")
DESCRIPTIONPublish data using the specified engine
NOTESThe maximum number of fields is 51 (23 for Excel versions prior to 2007).
FUNCTIONRTINSERT_SFC
ARGUMENTSValue(s), service, record, field1, field2, … fieldN
EXAMPLE
=RTINSERT_SFC(C15, "DTS", "MYREC", "BID")
DESCRIPTIONPublish data using the RTW RMDS (SFC) engine
NOTESThe maximum number of fields is 51 (23 for Excel versions prior to 2007).

PARSE_DATA and PACKAGE_DATA

The functions PARSE_DATA and PACKAGE_DATA work around some of the limitations of RTD when subscribing to and publishing multiple fields in the same RTD formula (see Microsoft KB article 286258).

PARSE_DATA
FUNCTIONPARSE_DATA
ARGUMENTAn Excel-style string
EXAMPLE
{=PARSE_DATA(RTS_SFC("IDN","MSFT.O", "BID", "ASK"))}
DESCRIPTIONEvaluates an Excel-style string
NOTESFor PARSE_DATA to work properly, the “Decimal separator” in Microsoft Excel needs to be set to “.” (period), and the “Thousands separator” needs to be “,” (comma). To verify these settings, please check Excel Options → Advanced → System Separators.

To edit an array formula, select the entire output range, place the cursor in the edit line, edit, and then press Ctrl-Shift-Return. If an attempt is made to edit a single cell in the range, a message box displays indicating the cell cannot be edited because it is the output of an array formula.

PACKAGE_DATA
PACKAGE_DATA must be used when publishing multiple fields with rtinsert. Publishing is only available with the RTW RMDS (RFA) and RTW RMDS (SFC) engines.
FUNCTIONPACKAGE_DATA
ARGUMENTCell range
EXAMPLE
=RTINSERT_SFC(PACKAGE_DATA(D3:D4), "DTS","MYREC","BID","ASK")
DESCRIPTIONConverts a range of values to an Excel-style string

Additionally, PACKAGE_DATA can be used to pass an array of field names to the RTD function.

EXAMPLE
=RTD("vistasource.rtdserver",,"rtinsert",PACKAGE_DATA(D3:D4),"vsRMDS","DTS","SH.ANY.MyRec.NaE",PACKAGE_DATA(C3:C4))
DESCRIPTIONIn this case, BID would be in C3 and ASK would be in C4, and DTS (Data Transformation System) is the name of the service to which you are publishing
PACKAGE_DATA and PARSE_DATA

Both functions can be used together in one formula:

EXAMPLE
=PARSE_DATA(RTS_SFC("IDN", "MSFT.O", PACKAGE_DATA(A1:A2)))
DESCRIPTIONIn this case, A1 contains BID and A2 contains ASK

Favorites

The RTW RMDS (SFC) Records – Favorites List dialog box allows you to manage your favorites list.

This list displays previously added selections of records and fields. To delete a selection, mark the item and click Delete.

To modify an item, click Modify List to access the RTW RMDS (SFC) Favorites List dialog box.

Modify Favorites

The RTW RMDS (SFC) Favorites List dialog box allows you to add, delete, and update your list of favorite records or pages. To access this list, click View Favorites in the Quick Quote or Publish dialog boxes, or select the dialog box launcher in the Vistasource → RMDS (SFC) group.

The RTW RMDS (SFC) Favorites List dialog box contains the following fields:

Favorites List Displays all the records you have previously added. Add or delete records in this list or update them by modifying the associated fields:

  • To add a record, enter the name of the record, select the fields via the entry fields on the right, and click Add.
  • To delete a record, select the record and click Delete.
  • To update a record, select the record in the Favorites List. All relevant entry fields will automatically fill in. Make your modifications and click Update.
Record Enter a name for the record you want to add or choose from the list of favorites to update.
Fields to Retrieve Enter the names of the fields you want to retrieve. Click on the icon next to the entry field to display the list of available fields. Press RETURN or click the Add Field button after each field name to add the field to the list box. To remove a field, select it and click Remove Selected Field.
Up and Down Arrows Rearrange the order of the fields by clicking on one and moving it with the arrows.
Field ListThe RTW RMDS (SFC) Field List dialog box displays all valid fields for the specified record. Select the field you are interested in from the Available Fields list box and click Add. The field name is added to the Selected Fields list box. To remove a field name, select the field and click Remove. After all fields have been created or deleted, click OK to return to the list of fields in the RTW RMDS (SFC) Favorites List dialog box.

Status Window Overview

The RTW Status Window displays messages about the RTW server, RTSHARE and any installed engine(s). The information is divided into the product components (RTW, RTSHARE or engine(s) ) and message types (errors, warnings, etc).

The top buttons of the window represent the components that have messages available. The RTW button represents the RTW server and is always displayed. When an engine is started or RTSHARE is used, a button for that component will be added to the toolbar. To view the messages for a component, click on its button.

For each component, there are tabs categorizing the different types of messages that the server or engine might send to the Status Window. For example, the tabs for the RTW component are: Information, Warnings, and Errors. Each engine and RTSHARE has its own message types. To switch between message types, click on the appropriate tab.

The Status Window will automatically switch to a component when either 1) initialization of the component has occurred or 2) an error occurred for that component.

If necessary, you can copy lines in any of the tabs to the clipboard. To select lines, either left-click on one or more lines in the tab, or right-click in the tab and choose Select All from the menu (alternatively, Ctrl+A will select all lines and Ctrl+D will unselect all lines). To copy the selected lines, type Ctrl+C or use the right-click menu and choose Copy. Once copied, the lines are ready to be pasted into your favorite editor or email program.

RTW Button

Click on the RTW button to display the following tabs: Information, Warning, Errors.

Information Provides data about RTW , such as version, network status messages, type of engine, directory paths etc.
Warnings Lists warnings about files not found or other problems
Errors Displays error messages

RMDS SFC Button

Click on the RMDS SFC button to display the following tabs: General, Requests, Services, Publish, Logger.

General Provides licensing and connection information
Requests Displays information about record requests
Services Shows status information about services
Publish Shows status information about publishing and contributing

Cell Status Messages

When information about a real-time value is not available, the cell displays #N/A. When an Excel spreadsheet file containing RTD formulas is opened, all real-time values display as #N/A until the data distribution system delivers the initial value and the cells are updated.

Similarly, when editing, copying or cutting/pasting a real-time formula, the cell displays #N/A until the value of the cell changes and the cell is updated. A cell which references a cell with a #N/A status message also displays #N/A.

If a cell displays #VALUE!, the formula is incorrect. For instance, if an invalid field name is entered, the cell displays #VALUE! and the status window displays information from the data distribution system about the incorrect field name. A cell also displays #VALUE! if it references another cell which contains #VALUE! or #N/A or no data.

Show/Hide Status Window

You can show or hide the RTW Status Window by selecting Vistasource → Info → Show/Hide Status Window.

By default, the status window first appears when a real-time RTW request is made. Real-time requests are made with the “rt” and “rtinsert” commands in the RTD function or in the RTW COM server.

The status window will automatically close when no engines are running. An engine will shutdown if it is not handling any more real-time requests.

The debug level and display rules for the RTW Status Window can be changed in the Status Window section of the Generic tab of the Rtconfig Editor. See section Generic Configuration Options for detailed information about the different methods of editing the RTW configuration options.

Interface Preferences

The Interface Preferences are used to customize the behavior of the RTW user interface as well as setting default values for the RTW RMDS (RFA) engine dialog boxes.

Select Vistasource → Settings → Interface Preferences to display the RTW Preferences dialog box.

This dialog box contains a generic preference and a RMDS (SFC) tab. On these tabs, defaults can be selected for the user interface dialogs such as Quick Quote.

The preferences are stored in a file which RTW will read when it starts.
In Windows 7, the preferences file is in %USERPROFILE%\AppData\Roaming\Vistasource\RTW\preferences.
In Windows XP, the preferences file is in %USERPROFILE%\Application Data\Vistasource\RTW\preferences. In both operation systems, this file can be read in any text editor, such as Notepad or Wordpad.

Generic Tab - Interface Preferences

On the Generic tab, you can select the options Build Formulas as Arrays and Don’t show splash screen on startup.

Build Formulas as Arrays

When this option is on, all Quote dialog boxes will create array formulas by default.

The wrapper function PARSE_DATA is used to work around RTD’s array formula limitation. See RTW Functions for more information.

Don't show splash screen on startup

Turn this option on to suppress the Vistasource RTW splash screen when you launch Microsoft Excel. The option is off by default.

RMDS (SFC) Tab – Interface Preferences

The RMDS (SFC) tab contains the option Default Service.

Default Service

Set the default subscribe and publish services for the RTW RMDS (SFC) engine. The selected subscribe service will automatically be the default service in the Quote dialog boxes. The selected publish service will automatically be the default service in the Publish dialog box.

Stop/Restart Engines

Select Vistasource → Stop/Restart Engines to close the connection to the data distribution system without exiting your spreadsheet. If you choose to stop an engine while the spreadsheet contains active real-time cells, the engine will restart automatically. You can choose to stop and restart a specific engine or all real-time engines.

Pause/Resume Data

Select the RTW Pause Data button to pause the flow of real-time data. You cannot manually update real-time values in this mode. This option lets you work in your spreadsheet without interruption from data updates. When Pause Data is selected, the menu option Refresh Data Now, which initiates a manual update, is not available and the Updates submenu is disabled (grayed out).

Select the RTW Resume Data button to resume the flow of real-time data.

The location of the Pause Data and Resume Data buttons depends on your version of Microsoft Excel. In Microsoft Excel 2007 they are located on the left side of the Vistasource tab of the Excel Ribbon. In versions prior to Microsoft Excel 2007, the buttons are located on a separate command bar under the menu bar.

Updates

Select Vistasource → Updates to display the various update options which let you alter the flow of real-time data without closing the engine. You can pause and resume your data flow, and set the update rate according to your needs. You can choose to have the data updated as it changes, manually update your data, or select various intervals including custom intervals for automatic updates. Internally, this sets the Excel application option RTD.ThrottleInterval.

Manual Updates Only

Select Vistasource → Updates → Manual Updates Only to suspend automatic updates of data. Any cells containing real-time formulas display the value that was current when you chose this option, but the values no longer continue to update automatically. If you want to restart automatic updates, choose one of the other update rate options such as As Data Changes.

By selecting Vistasource → Refresh Data Now you initiate a manual update of the real-time cells.

Refresh Data Now

Select Vistasource → Refresh Data Now to force a manual update when Vistasource → Updates → Manual Updates Only is selected, or when the Update Rate is 5 seconds or more. Otherwise, the option is unavailable (grayed out).

When data is paused by selecting Vistasource → Pause Data, the option Refresh Data Now is not available. Select Vistasource → Resume Data to resume the flow of real-time data once paused.

Rate

This option allows the setting of the rate in which data gets updated. It contains the following settings:

As Data Changes (Default Setting)

Select Vistasource → Updates → Rate → As Data Changes to have the engine update your data as the values change.

Update Rate (n Second Interval)

Select Vistasource → Updates → Rate → n Second Interval to update real-time values at preset intervals. n represents the number of seconds between updates. Available settings are 1, 5, 10, 30, 60 seconds.

Update Rate (Custom Interval)

Select Vistasource → Updates → Rate → Custom Interval to define a custom interval between updates. Custom intervals are measured in seconds.

Monitor Watch List

Select Vistasource → Info → Monitor Watch List to display the RTW Monitor Watch List dialog box. This dialog shows the records and fields you are currently subscribed to.

The RTW Monitor Watch List dialog box contains the following fields:

EngineThe engine is vsRMDS.
ServiceSelect a service from the Service pull-down menu.
Number of Live RecordsThe number of live records is displayed.
Record NameThe list of records appears in the list box.
Field Name/Field IDThe list of the active fields and their field ID.

Select Close to return to the work sheet.

Items from the Watch List will automatically unsubscribe when you remove the RTD formula. To flush all records, select Vistasource → Stop/Restart Engines.

Record Info

Select Vistasource → Info → Record Info to view the current values of all valid fields (FIDs) for a given record (RIC) from any available DDS (Data Distribution Server) such as RMDS. In case several engines are installed, you can access all available engines from a single Record Information dialog box.

The RTW Record Information dialog box contains the following fields:

EngineThe engine is vsRMDS.
ServiceSelect a service from the Service drop-down menu.
RecordType the name of the record (RIC) for which you want to retrieve values in the Record (RIC) entry field.
Get RecordThis button is available when engine, service and record have been specified. Click this button to get the record information.

Select Close to return to the work sheet.