Quote Table

Select Vistasource → [Engine name] → Quote Table to create RTD formulas that reference record and field names in your spreadsheet. Accordingly, this option relies on a spreadsheet which includes record names in a column and field names in a row.

Organize your spreadsheet with record names in a column and field names in an adjacent row. Select Vistasource → [Engine name] → Quote Table to display the dialog box RTW [Engine name] Quote Table.

This dialog box contains the following options:

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.

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.

Select the engine, e.g. vsRMDS (RMDS SFC), vsRMDS2 (RMDS RFA), axbloom (Bloomberg), vsnf (Netfeed), rthttp (WebData).

Select the service/record type, e.g. IDN (RMDS SFC and RMDS RFA), TICKERX (Bloomberg), MARKETFEED (Netfeed), or Yahoo (WebData).

When not using the default session, select a session name from the list (see RTW RMDS (RFA) Engine for more information).

The record names can only reside in a column.

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.