First time user here - Translating from Excel to Python

Question

question

juliusz.pres

1 ●0 ●0 ●1

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.

May 20, 2021 at 01:15 PM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Answer 1 · 2021-05-20T14:41:52Z

Gurpreet

13k ●32 ●12 ●18

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'})

1621521787221.png (17.5 KiB)

May 20, 2021 at 02:41 PM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.