User Tools

  • Vistasource Document Library

Quick Quote

The Quick Quote dialog box provides an easy way to automatically build a RTD formula which subscribes to fields of a single record.

Select Vistasource → [Engine name] → Quick Quote to display the dialog box RTW [Engine name] Quick Quote.

Cell Range

Enter a start cell 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.

If Build as Array Formula is selected, a wrapper function PARSE_DATA is used. For more information on PARSE_DATA, see RTW Functions. 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.

Engine

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

Service/Record Type

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

Session (RMDS RFA engine only)

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

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, located in the user’s Application Data directory, %USERPROFILE%\Application Data\Vistasource\RTW or C:\ if the application directory does not exist.

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 [Engine name] 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 [Engine name] 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 [Engine name] Records - Favorites List.

Click OK to insert the formula in your workbook.

See Also: