Quantcast

Documentation Center

  • Trial Software
  • Product Updates

eqs

Return equity screening data from Bloomberg V3

Syntax

Description

example

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

example

d = eqs(...,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(...,languageid) returns equity screening data using the language identifier languageid.

example

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

Examples

expand all

Retrieve Equity Screening Data for a Screen

Create the Bloomberg connection.

c = blp;

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 and the subsequent rows contain the returned data. The columns in d contain the following:

  • 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;

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 and the subsequent rows contain the returned data. The columns in d contain the following:

  • 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;

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 and the subsequent rows contain the returned data. The columns in d contain the following:

  • 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;

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 and the subsequent rows contain the returned data. The columns in d contain the following:

  • 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

expand all

c — Bloomberg connectionconnection object

Bloomberg connection, specified as a connection object created using blp.

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

Output Arguments

expand all

d — Return datacell array

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

See Also

| |

Was this topic helpful?