Documentation

eqs

Return equity screening data from Bloomberg connection V3

Syntax

  • d = eqs(c,sname) example
  • d = eqs(c,sname,stype) example
  • d = eqs(c,sname,stype,languageid) example
  • d = eqs(c,sname,stype,languageid,group) example
  • d = eqs(c,sname,stype,languageid,group,Name,Value) example

Description

example

d = eqs(c,sname) returns equity screening data given the Bloomberg® V3 session screen name sname.

example

d = eqs(c,sname,stype) returns equity screening data using the screen type stype. stype can be set to 'GLOBAL' for Bloomberg screen names or 'PRIVATE' for customized screen names.

example

d = eqs(c,sname,stype,languageid) returns equity screening data using the language identifier languageid.

example

d = eqs(c,sname,stype,languageid,group) returns equity screening data using the optional group identifier group.

example

d = eqs(c,sname,stype,languageid,group,Name,Value) returns equity screening data additional options specified by the Name,Value pair argument.

Examples

collapse all

Retrieve Equity Screening Data for a Screen

Create the Bloomberg connection.

c = blp;

Alternatively, you can connect to the Bloomberg Server API using blpsrv or Bloomberg B-PIPE® using bpipe.

Retrieve equity screening data for the screen called Frontier Market Stocks with 1 billion USD Market Caps.

d = eqs(c,'Frontier Market Stocks with 1 billion USD Market Caps');

Display the first three rows in the returned data d.

d(1:3,:)
ans = 

  Columns 1 through 4

    'Cntry'           'Name'                   'Ind Group'    'Market Cap'   
    'Bahrain'         'ARAB BANKING COR...'    'Banks'        [1166249984.00]
    'South Africa'    'HARMONY GOLD MIN...'    'Mining'       [1239142656.00]

  Columns 5 through 8

    'Price:D-1'    'P/B'     'P/E'     'EPS - 1 Yr Gr LF'
    [     0.38]    [0.30]    [5.18]    [           24.53]
    [     2.89]    [0.40]    [ NaN]    [          -96.84]

d contains Bloomberg equity screening data for the Frontier Market Stocks with 1 billion USD Market Caps screen. The first row contains column headers. The subsequent rows contain the returned data. The columns in d are:

  • Country name

  • Company name

  • Industry name

  • Market capitalization

  • Price

  • Price-to-book ratio

  • Price-earnings ratio

  • Earnings per share

Close the connection.

close(c)

Retrieve Equity Screening Data for a Screen Type

Create the Bloomberg connection.

c = blp;

Alternatively, you can connect to the Bloomberg Server API using blpsrv or Bloomberg B-PIPE using bpipe.

Retrieve equity screening data for the screen called Vehicle-Engine-Parts and the screen type equal to 'GLOBAL'.

d = eqs(c,'Vehicle-Engine-Parts','GLOBAL');

Display the first three rows in the returned data d.

d(1:3,:)
ans = 

  Columns 1 through 5

    'Ticker'        'Short Name'        'Market Cap'        'Price:D-1'    'P/E'  
    'HON     US'    'HONEYWELL INTL'    [69451382784.00]    [    88.51]    [16.81]
    'CMI     US'    'CUMMINS INC'       [24799526912.00]    [   132.36]    [17.28]

  Columns 6 through 8

    'Total Return YTD'    'Revenue T12M'      'EPS T12M'
    [           42.43]    [38248998912.00]    [    4.11]
    [           24.43]    [17004999936.00]    [    7.57] 

d contains Bloomberg equity screening data for the Vehicle-Engine-Parts screen. The first row contains column headers. The subsequent rows contain the returned data. The columns in d are:

  • Ticker symbol

  • Company name

  • Market capitalization

  • Price

  • Price-earnings ratio

  • Total return year-to-date

  • Revenue

  • Earnings per share

Close the connection.

close(c)

Retrieve Equity Screening Data for a Screen in German

Create the Bloomberg connection.

c = blp;

Alternatively, you can connect to the Bloomberg Server API using blpsrv or Bloomberg B-PIPE using bpipe.

Retrieve equity screening data for the screen called Vehicle-Engine-Parts, the screen type equal to 'GLOBAL', and return data in German.

d = eqs(c,'Vehicle-Engine-Parts','GLOBAL','GERMAN');

Display the first three rows in the returned data d.

d(1:3,:)
  Columns 1 through 5

    'Ticker'        'Kurzname'          'Marktkapitalisie...'    'Preis:D-1'    'KGV'  
    'HON     US'    'HONEYWELL INTL'    [     69451382784.00]    [    88.51]    [16.81]
    'CMI     US'    'CUMMINS INC'       [     24799526912.00]    [   132.36]    [17.28]

  Columns 6 through 8

    'Gesamtertrag YTD'    'Erlös T12M'        'EPS T12M'
    [           42.43]    [38248998912.00]    [    4.11]
    [           24.43]    [17004999936.00]    [    7.57]

d contains Bloomberg equity screening data for the Vehicle-Engine-Parts screen. The first row contains column headers in German. The subsequent rows contain the returned data. The columns in d are:

  • Ticker symbol

  • Company name

  • Market capitalization

  • Price

  • Price-earnings ratio

  • Total return year-to-date

  • Revenue

  • Earnings per share

Close the connection.

close(c)

Retrieve Equity Screening Data for a Screen with a Specified Screen Folder Name

Create the Bloomberg connection.

c = blp;

Alternatively, you can connect to the Bloomberg Server API using blpsrv or Bloomberg B-PIPE using bpipe.

Retrieve equity screening data for the Bloomberg screen called Vehicle-Engine-Parts, using the Bloomberg screen type 'GLOBAL' and the language 'ENGLISH', and the Bloomberg screen folder name 'GENERAL'.

d = eqs(c,'Vehicle-Engine-Parts','GLOBAL','ENGLISH','GENERAL');

Display the first three rows in the returned data d.

d(1:3,:)
ans = 

  Columns 1 through 5

    'Ticker'        'Short Name'        'Market Cap'        'Price:D-1'    'P/E'  
    'HON     US'    'HONEYWELL INTL'    [69451382784.00]    [    88.51]    [16.81]
    'CMI     US'    'CUMMINS INC'       [24799526912.00]    [   132.36]    [17.28]

  Columns 6 through 8

    'Total Return YTD'    'Revenue T12M'      'EPS T12M'
    [           42.43]    [38248998912.00]    [    4.11]
    [           24.43]    [17004999936.00]    [    7.57]

d contains Bloomberg equity screening data for the Vehicle-Engine-Parts screen. The first row contains column headers. The subsequent rows contain the returned data. The columns in d are:

  • Ticker symbol

  • Company name

  • Market capitalization

  • Price

  • Price-earnings ratio

  • Total return year-to-date

  • Revenue

  • Earnings per share

Close the connection.

close(c)

Retrieve Equity Screening Data Using Override Fields

Create the Bloomberg connection.

c = blp;

Alternatively, you can connect to the Bloomberg Server API using blpsrv or Bloomberg B-PIPE using bpipe.

Retrieve equity screening data as of a specified date using these input arguments. The override field PiTDate is equivalent to the flag AsOf in the Bloomberg Excel Add-In.

  • Bloomberg connection c

  • Bloomberg screen is Vehicle-Engine-Parts

  • Bloomberg screen type is 'GLOBAL'

  • Language is 'ENGLISH'

  • Bloomberg screen folder name is 'GENERAL'

  • Override field PiTDate is September 9, 2014

d = eqs(c,'Vehicle-Engine-Parts','GLOBAL','ENGLISH','GENERAL',...
        'overrideFields',{'PiTDate','20140909'});

Display the first three rows in the returned data d.

d(1:3,:)
ans = 

  Columns 1 through 5

    'Ticker'        'Short Name'        'Market Cap'    'Price:D-1'       'P/E'
    'HON US'     'HONEYWELL INTL'      [7.3919e+10]    [  94.4600]    [17.8087]
    'TSLA US'    'TESLA MOTORS'        [3.4707e+10]    [ 278.4800]    [    NaN]

  Columns 6 through 8

    'Total Return YTD'    'Revenue T12M'    'EPS T12M'
    [          4.8907]    [  3.9966e+10]    [  5.1600]
    [         85.1239]    [  2.4365e+09]    [ -1.3500]

d contains Bloomberg equity screening data for the Vehicle-Engine-Parts screen as of September 9, 2014. The first row contains column headers. The subsequent rows contain the returned data. The columns in d are:

  • Ticker symbol

  • Company name

  • Market capitalization

  • Price

  • Price-earnings ratio

  • Total return year-to-date

  • Revenue

  • Earnings per share

Close the connection.

close(c)

Input Arguments

collapse all

c — Bloomberg connectionconnection object

Bloomberg connection, specified as a connection object created using blp, blpsrv, or bpipe.

sname — Screen namestring

Screen name, specified as a string to denote the Bloomberg V3 session screen name to execute. The screen can be a customized equity screen or one of the Bloomberg example screens accessed by using the EQS <GO> option from the Bloomberg terminal.

Data Types: char

stype — Screen type'GLOBAL' | 'PRIVATE'

Screen type, specified as one of the two enumerated strings above to denote the Bloomberg screen type. 'GLOBAL' denotes a Bloomberg screen name and 'PRIVATE' denotes a customized screen name. When using the optional group input argument, stype cannot be set to 'PRIVATE' for customized screen names.

Data Types: char

languageid — Language identifierstring

Language identifier, specified as a string to denote the language for the returned data. This argument is optional.

Data Types: char

group — Group identifierstring

Group identifier, specified as a string to denote the Bloomberg screen folder name accessed by using the EQS <GO> option from the Bloomberg terminal. This argument is optional. When using this argument, stype cannot be set to 'PRIVATE' for customized screen names.

Data Types: char

Name-Value Pair Arguments

Specify optional comma-separated pairs of Name,Value arguments. Name is the argument name and Value is the corresponding value. Name must appear inside single quotes (' '). You can specify several name and value pair arguments in any order as Name1,Value1,...,NameN,ValueN.

Example: 'overrideFields',{'PiTDate','20140909'}

'overrideFields' — Override fieldscell array

Override fields, specified as the comma-separated pair consisting of 'overrideFields' and an n-by-2 cell array. The first column of the cell array is the override field. The second column is the override value.

Data Types: cell

Output Arguments

collapse all

d — Return datacell array

Return data, returned as a cell array containing Bloomberg equity screening data.

See Also

| | |

Was this topic helpful?