.BVSP chain rics in python

rafael01

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

Jirapongse

@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:

I hope this will help.