Index
Copyright Notice
Release Notes
Licensing Howto
Software License
Technical Specifications
Contact Information
About RTW
System Requirements
Licensing
Rtconfig Editor
Interface Preferences
Subscribe
Quote Wizard
Quick Quote
Quote Table
Publish
RTW Functions
Status Window
Show/Hide Status Window
Status Messages
Cell Status Messages
Stop/Restart Engines
Pause/Resume Data
Refresh Data Now
Updates
Rate
Manual Updates Only
Update Rate (n Second Interval)
Update Rate (Custom Interval)
Monitor Watch List
Record Info
RTW RMDS (RFA) Engine
Subscribe (RMDS RFA)
Chain (RMDS RFA)
Publish (RMDS RFA)
Favorites (RMDS RFA)
Modify Favorites (RMDS RFA)
RTW RMDS (SFC) Engine
Subscribe (RMDS SFC)
Chain (RMDS SFC)
Publish (RMDS SFC)
Favorites (RMDS SFC)
Modify Favorites (RMDS SFC)
RTW Bloomberg Engine
Subscribe (Bloomberg)
Chain (Bloomberg)
PARSE_BULK Function
Favorites (Bloomberg)
Modify Favorites (Bloomberg)
The PARSE_BULK function allows you to parse bulk data from the Bloomberg data distribution system that is retrieved via an RTD function. In Bloomberg, the bulk format data type is used to return multi-element or multi-dimensional data. The function PARSE_BULK in conjunction with an RTD array formula will display the bulk data in a user-friendly format instead of presenting the data as one string in a cell.
The formula has the following syntax:
=PARSE_BULK(RTD( “Vistasource.RTDServer”,,“rt”,Engine,Record Type,Record,Field))
where the individual arguments have the following meaning:
The name of the Bloomberg engine, axbloom.
The type of record type, e.g. TICKERX.
The name of the record.
The name of the bulk data field.
The following formula returns the bulk data for the index members of the FTSE-100 index from the Bloomberg engine with the record type TICKERX and updates the values as they change.
=PARSE_BULK(RTD("vistasource.rtdserver",,"rt","axbloom","TICKERX","UKX Index","INDX_MEMBERS"))
pagequeryNo results for the search query: « functions »