Table of Contents
Misc.
Index
Copyright Notice
Release Notes
Licensing Howto
Software License
Technical Specifications
Contact Information
Demos
Guides
Help
Generic
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
RMDS(RFA) ENGINE
RTW RMDS (RFA) Engine
Subscribe (RMDS RFA)
Chain (RMDS RFA)
Publish (RMDS RFA)
Favorites (RMDS RFA)
Modify Favorites (RMDS RFA)
RMDS (SFC) Engine
RTW RMDS (SFC) Engine
Subscribe (RMDS SFC)
Chain (RMDS SFC)
Publish (RMDS SFC)
Favorites (RMDS SFC)
Modify Favorites (RMDS SFC)
BLOOMBERG Engine
RTW Bloomberg Engine
Subscribe (Bloomberg)
Chain (Bloomberg)
PARSE_BULK Function
Favorites (Bloomberg)
Modify Favorites (Bloomberg)
NETFEED Engine
WEBDATA Engine
PARSE_BULK Function
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:
Engine
The name of the Bloomberg engine, axbloom.
Record Type
The type of record type, e.g. TICKERX.
Record
The name of the record.
Field
The name of the bulk data field.
EXAMPLE
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"))
See Also:
pagequeryNo results for the search query: « functions »
