User Tools

  • Vistasource Document Library

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

rtw_4.5:parse_bulk_function [2018/08/04 20:08]
rtw_4.5:parse_bulk_function [2018/08/04 20:08] (current)
Line 1: Line 1:
 +====== 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.
 + 
 +<note important>​To edit an array formula, you need to select the entire output range, place the cursor in the edit line, make your edits and then press Ctrl-Shift-Return. If you attempt to edit a single cell in the range, a message box displays telling you that you cannot edit the cell because it is the output of an array formula.</​note>​
 + 
 +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.
 + 
 +<​code>​=PARSE_BULK(RTD("​vistasource.rtdserver",,"​rt","​axbloom","​TICKERX","​UKX Index","​INDX_MEMBERS"​))</​code>​
 + 
 + 
 +== See Also: ==
 +{{pagequery>​@rtw_4.4 functions;​title}} ​