Documentation

This is machine translation

Translated by Microsoft
Mouse over text to see original. Click the button below to return to the English verison of the page.

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

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)

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)

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)

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)

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)

Related Examples

Input Arguments

collapse all

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

Screen name, specified as a character vector 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

Screen type, specified as one of the two preceding values 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.

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

Data Types: char

Group identifier, specified as a character vector 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'}

collapse all

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

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

See Also

| | |

Introduced in R2012b

Was this topic helpful?