First time user here - Translating from Excel to Python

juliusz.pres

Hi,

I am trying to translate the following function:
=@TR( 'BNPP.PA' ,"TR.ROATotalAssetsPercent","SDate=#1 CH=Fd",,2021-04-21)

My implementation doesnt work:

fields = ['TR.ROATotalAssetsPercent', 'TR.ROAActValue']

parameters = { 'SDate' : '#1', 'EDate' : '2021-04-21', 'CH' : 'Fd' }

ticker = 'BNPP.PA'

data_grid, err = ek.get_data(ticker, fields = fields, parameters = parameters)

Could anyone provide insights? Thank you.

Gurpreet

Try something like this -

df, err = ek.get_data( 'BNPP.PA', ['TR.ROATotalAssetsPercent', 'TR.ROAActValue'], {'SDate': '2021-04-21', 'EDate':'2021-04-30', 'FRQ': 'D'})