For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvote
Accepted
30 0 0 1

.BVSP chain rics in python

I am trying to get the .BVSP (Ibovespa) index chain of rics in python using the screener from code book.


screen = SCREEN.express.universe('0#BVSP.SA').conditions(FORMULA('TR.CompanyMarketCap','>200000000')).currency('BRL').query


dframe, err = ek.get_data(screen, ['TR.F.EBIT', 'TR.F.RevGoodsSrvc',
                                   'TR.F.EBIT.periodenddate',
                                   'TR.F.EBIT.calcdate'],
                          parameters=
                          {
                              'SDate': '-20Y',
                              'EDate': '0D',
                              'Period': 'LTM',
                              'Frq': 'FQ'
                          }
                          )


however it gives me the following error:


[{'code': 412, 'col': 1, 'message': 'Unable to resolve all requested identifiers.', 'row': 0}, {'code': 412, 'col': 2, 'message': 'Unable to resolve all requested identifiers.', 'row': 0}, {'code': 412, 'col': 3, 'message': 'Unable to resolve all requested identifiers.', 'row': 0}, {'code': 412, 'col': 4, 'message': 'Unable to resolve all requested identifiers.', 'row': 0}]


Someone could help me?


Thanks in advance



pythonchain-ricscreener
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Upvotes
Accepted
52.5k 134 44 63

@rafael01

Really sorry for the issue you are facing, let me see if I can help you in resolving this.

You may try '0#.BVSP' which represents Sao Paulo SE Bovespa Index.

screen = SCREEN.express.universe('0#.BVSP').conditions(FORMULA('TR.CompanyMarketCap','>200000000')).currency('BRL').query

The output is:

1663039894601.png

I hope this will help.


1663039894601.png (35.8 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks a lot @Jirapongse .