Need help to transform a code from CODEBK into a code using API without Eikon.

augusto_krappa · 2025-02-21T22:47:03+00:00

There was an error rendering this rich post.

I am having problem with the parameter "CH", which is not supporter in the fundamental_and_reference.Definition. And there is nothing about it in the docummentation here https://cdn.refinitiv.com/public/rd-lib-python-doc/1.0.0.0/book/en/sections/content-layer/fundamental-reference/fundamental-and-reference-definition.html

from refinitiv.data.content import fundamental_and_reference
df_earnings_surprise= pd.DataFrame()

definition= fundamental_and_reference.Definition(

    universe= br_instruments,

    fields=['TR.NetProfitPreSurprise.calcdate','TR.NetprofitSmartEst(Period=CY2025)'],

    parameters= {

        'SDate':'1', 

        'EDate':'-24',

        'Frq': 'W',

        'Curn': 'BRL',
        #'CH': 'IN;Fd' #Here is the problem,
        #'RH': 'date' 


        'Scale': 6

    },

    row_headers= 'date'

).get_data()

Find more posts tagged with

python

api

parameters

#technology

lseg-data-library

Accepted answers

All comments

wasin.w

Hello @augusto_krappa

The fundamental_and_reference object of the Data Library - Content Layer is built on top of the RDP APIs DataGrid service.

I did a quick test on the RDP APIs Document, the DataGrid service does not support the "CH" parameters. That is why the fundamental_and_reference object does not support "CH" parameter too.

augusto_krappa

Hi @wasin.w . Yes i know it is not working. But what would be a solution for this?
I must substitute the sintaxe "CH":"IN;Fd" by what?

raksina.samasiri

Hi @augusto_krappa ,

Is this the result in the format you're looking for? If so, you can get the result in dataframe format by adding ".data.df"

augusto_krappa

Hi @raksina.samasiri, thanks for that. It is almost what i want. From codebk, i already have the code that returns it vertically stacked (due to the parameter "CD":"Fd")

I couldnt work around the dataframe to stack it vertically instead of horizontally. Could you help me on that please?

Jirapongse

@augusto_krappa

You may need to use the Python code to reformat the dataframe. For example:

df1 = definition.data.df

new_df = pd.DataFrame()
objective_output_set = {item[0] for item in df1.columns}

for ric in objective_output_set:
    df2 = df1[(ric)]
    df2.insert(loc=0, column='Instrument', value=ric)
    new_df = pd.concat([new_df, df2])

new_df

wasin.w

Hello @augusto_krappa

If you need the DataGrid service to support the "CH" parameter syntax and feature, you can raise an enhancement request to the support team directly via https://myaccount.lseg.com/en/productsupport website.

augusto_krappa

@Jirapongse thank you!

EXPLORE OUR SITES