lookup

Find information about securities forBloombergconnection V3

Syntax

l = lookup(c,q,reqtype,Name,Value)

Description

l= lookup(c,q,reqtype,Name,Value)retrieves data based on criteria in the queryqfor a specific request typereqtypeusing the Bloomberg^®connectionc. For additional information about the query criteria and the possible name-value pair combinations, see theBloomberg API Developer’s Guideusing theWAPI option from the Bloomberg terminal.

Examples

collapse all

Look Up Security

Open Script

Create a Bloomberg® connection, and then use the Security Lookup to retrieve information about the IBM® corporate bond. For details about Bloomberg and the parameter values you can set, see theBloomberg API Developer's Guideusing theWAPIoption from the Bloomberg terminal.

Create the Bloomberg connection.

c = blp;

Alternatively, you can connect to the Bloomberg Server usingblpsrvor Bloomberg B-PIPE® usingbpipe.

Return data as a table by setting theDataReturnFormatproperty of the connection object. If you do not set this property, thelookupfunction returns data as a structure.

c.DataReturnFormat ='table';

Retrieve the instrument data for an IBM corporate bond with a maximum of 20 rows of data. The Security Lookup returns the security names and descriptions.

insts = lookup(c,'IBM','instrumentListRequest','maxResults',20,...'yellowKeyFilter','YK_FILTER_CORP',...'languageOverride','LANG_OVERRIDE_NONE');

Display the first three rows in the table. The first column contains the IBM corporate bond names, and the second column contains the bond descriptions.

insts(1:3,:)

ans = 3×2 table security description _________________ ______________________________________ 'DD103619 ' 'International Business Machines Corp' '459200AG ' 'International Business Machines Corp' 'EC767659 ' 'International Business Machines Corp'

Close the Bloomberg connection.

close(c)

Look Up Curve

Use the Curve Lookup to retrieve information about the'GOLD'related curve'CD1016'. For details about Bloomberg and the parameter values you can set, see theBloomberg API Developer’s Guideusing theWAPI option from the Bloomberg terminal.

Connect to Bloomberg.

c = blp;

Alternatively, you can connect to the Bloomberg Server usingblpsrvor Bloomberg B-PIPE^®usingbpipe.

Retrieve the curve data for the credit default swap subtype of corporate bonds for a'GOLD'related curve'CD1016'. Return a maximum of10rows of data for the U.S. with'USD'currency.

curves = lookup(c,'GOLD','curveListRequest','maxResults',10,...'countryCode','US','currencyCode','USD',...'curveid','CD1016','type','CORP','subtype','CDS')

curves = curve: {'YCCD1016 Index'} description: {'Goldman Sachs Group Inc/The'} country: {'US'} currency: {'USD'} curveid: {'CD1016'} type: {'CORP'} subtype: {'CDS'} publisher: {'Bloomberg'} bbgid: {''}

One row of data displays as Bloomberg curve name'YCCD1016 Index'with Bloomberg description'Goldman Sachs Group Inc/The'in the U.S. with'USD'currency. The Bloomberg short-form identifier for the curve is'CD1016'. Bloomberg is the publisher and thebbgidis blank.

Close the Bloomberg connection.

close(c)

Look Up Government Security

Use the Government Security Lookup to retrieve information for United States Treasury bonds. For details about Bloomberg and the parameter values you can set, see theBloomberg API Developer’s Guideusing theWAPI option from the Bloomberg terminal.

Connect to Bloomberg.

c = blp;

Alternatively, you can connect to the Bloomberg Server usingblpsrvor Bloomberg B-PIPE usingbpipe.

Filter government security data with ticker filter of'T'for a maximum of10rows of data.

govts = lookup(c,'T','govtListRequest','maxResults',10,...'partialMatch',false)

govts = parseky: {10x1 cell} name: {10x1 cell} ticker: {10x1 cell}

The Government Security Lookup returnsparsekydata, the name, and ticker of the United States Treasury bonds.

Display theparsekydata.

govts.parseky

ans = '912828VS Govt' '912828RE Govt' '912810RC Govt' '912810RB Govt' '912828VU Govt' '912828VV Govt' '912828VB Govt' '912828VR Govt' '912828VW Govt' '912828VQ Govt'

Display the names of the United States Treasury bonds.

govts.name

ans = 'United States Treasury Note/Bond' 'United States Treasury Note/Bond' 'United States Treasury Note/Bond' 'United States Treasury Note/Bond' 'United States Treasury Note/Bond' 'United States Treasury Note/Bond' 'United States Treasury Note/Bond' 'United States Treasury Note/Bond' 'United States Treasury Note/Bond' 'United States Treasury Note/Bond'

Display the tickers of the United States Treasury bonds.

govts.ticker

ans = 'T' 'T' 'T' 'T' 'T' 'T' 'T' 'T' 'T' 'T'

Close the Bloomberg connection.

close(c)

Input Arguments

collapse all

`c`—Bloomberg connection
connection object

Bloomberg connection, specified as a connection object created usingblp,blpsrv, orbpipe.

`q`—Keyword query
character vector|string scalar|cell array of character vectors|string array

Keyword query, specified as a character vector, string scalar, cell array of character vectors, or string array. Each character vector or string denotes an item for which information is requested. For example, the keyword query can be a security, a curve type, or a filter ticker.

Data Types:char|cell|string

`reqtype`—Request type
`'instrumentListRequest'`|`'curveListRequest'`|`'govtListRequest'`

Request type, specified as the preceding values to denote the type of information request.'instrumentListRequest'denotes a security or instrument lookup request.'curveListRequest'denotes a curve lookup request.'govtListRequest'denotes a government lookup request for government securities.

Name-Value Arguments

Specify optional pairs of arguments asName1=Value1,...,NameN=ValueN, whereNameis the argument name andValueis the corresponding value. Name-value arguments must appear after other arguments, but the order of the pairs does not matter.

Before R2021a, use commas to separate each name and value, and encloseNamein quotes.

Example:'maxResults',20,'yellowKeyFilter','YK_FILTER_CORP','languageOverride','LANG_OVERRIDE_NONE','countryCode','US','currencyCode','USD','curveid','CD1016','type','CORP','subtype','CDS','partialMatch',false

`maxResults`—Number of rows in result data
numeric scalar

结果数据的行数,指定为the comma-separated pair consisting of'maxResults'and a numeric scalar to denote the total maximum number of rows of information to return. Result data can be one or more rows of data no greater than the number specified.

Data Types:double

`yellowKeyFilter`—Bloomberg yellow key filter
character vector|string scalar

Bloomberg yellow key filter, specified as the comma-separated pair consisting of'yellowKeyFilter'and a unique character vector or string scalar to denote the particular yellow key for government securities, corporate bonds, equities, and commodities, for example.