User Tools

  • Vistasource Document Library


Download RTW 4.4







RMDS (SFC) Engine




Chain [Bloomberg]

The RTW Bloomberg 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. In the RTW Bloomberg engine, Chain refers to the subset of the Bloomberg bulk data that deals with Futures and Options Chains.

To construct a chain of data, select Vistasource → Bloomberg → Chain to display the RTW Bloomberg Chain dialog box.

Record Name

Enter the name of the record root, e.g. MSFT US.

Market Sector

Select the appropriate Market Sector for the record. For instance, for MSFT US, you would choose Equity.

Chain Field

The following choices are available:

  • Futures Chain [FUT_CHAIN]
  • Option Chain by Unique Bloomberg Identifier [OPT_CHAIN_ID_BB_UNIQUE]
  • Option Chain [OPT_CHAIN]
  • Warrant Chain [WARRANT_CHAIN]

Cell Range

Enter a start cell or a cell range for the formula 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.

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


The engine name is axbloom.

Record Type

Select the record type, e.g. TICKERX.

Chain Direction

The chain can only reside in columns.

Use Cell Addresses for Rows/Columns/Bulk Formula This option ensures that the chain setup stays valid if you change the record or field names.

Click OK to initiate the construction of the chain.

See Also:

pagequeryNo results for the search query: « subscribe|functions »