Error for TR.DivAdjustedGross.

vitali

Hello! I have trouble getting values for "TR.DivAdjustedGross":

I receive an error:

Error code -1 | Output parameter 'date' is unrecognized. This could possibly happen because of mismatch between top level function expression and its usage in output. Make sure that you used exactly 1:1 identical expressions. Requested universes: ['AAPL.O']. Requested fields: ['TR.DIVADJUSTEDGROSS']

Would appreciate any help.

Here is a code:

import refinitiv.data as rd

import pandas as pd

rd.open_session()

COMPANY = ["AAPL.O"]

START_DATE = "2022-11-30"

END_DATE = "2023-12-31"

FIELDS = [

"TR.DivAdjustedGross",

]

df = rd.get_history(universe=COMPANY, fields=FIELDS, interval="1M", start=START_DATE, end=END_DATE)

print(df)

company_df = pd.DataFrame({"Company": [COMPANY]})

rd.close_session()

aramyan.h

Hi @vitali ,

You are getting this error because rd.get_history doesn't support the provided field due to nature of the field. Consider using get_data as below:

COMPANY = ["AAPL.O"]

START_DATE = "2022-11-30"

END_DATE = "2023-12-31"

FIELDS = [

"TR.DivAdjustedGross", "TR.DivAdjustedGross.coraxdividenddate"

]

df = rd.get_data(universe=COMPANY, fields=FIELDS, parameters = {'Sdate':START_DATE, 'Edate':END_DATE})

Hope this helps.

Best regards,

Haykaz

vitali

This helped indeed. Thank you a lot!