How to get a custom field with matched dates

Hello,

I'm trying to reproduce the following Excel call in python:

=TR(RIC_Vec,"TR.NetIncomeCFStmt()/TR.CompanyMarketCap()","SDate=#1 EDate=#2 Frq=#3 CH=IN RH=calcdate NULL=#4 Period=LTM",,Start_Date,End_Date,"M",NullH)

I get a neat wide output:

I'm wondering how the get_data command would be and if it's even possible to get (even in long format) an output in a way that all dates (in this case months) are filled and that outright calculates the ratio I'm providing.

Thank you.

EDIT: I'm fine with it retrieving NaN/NULL/NA if there's no available prior value. If there is I'd like it to present the previous available.

Find more posts tagged with

python

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

chavalit-jintamalit

Hi @gonzalofernandezs

You can do custom operations in Python on the dataframe.

Here is an example:

All comments

chavalit-jintamalit

Hi @gonzalofernandezs

You can do custom operations in Python on the dataframe.

Here is an example:

gonzalofernandezs

Alright, so as long as I choose the highest frequency field as the date one all rows will be filled? How is this setting that if there's a value missing grab the previous available? Or is that the default?

Thank you.

EXPLORE OUR SITES