I need to retrieve the financial period end dates from the income statement using Python.

mahesh_m · April 16

My current code

workspace_df = ld.get_history(
universe=str(org_id),
fields=['TR.Revenue', 'TR.F.Source', 'TR.F.PeriodEndDate'],
start="2000-01-01",
end="2050-01-01"
)

However, this only returns annual period data. How can I modify the parameters to include quarterly period as well?"

mahesh_m · April 17

https://community.developers.refinitiv.com/discussion/comment/125261#Comment_125261

Thanks @Jirapongse this is really helpful,

here

    parameters={'Period':'FQ0','FRQ':'FQ'}

I was able get the values from the DIB and update, but how did you come to know the key params like 'Period' and 'FRQ' from the DIB

Jirapongse · April 17

https://community.developers.refinitiv.com/discussion/comment/125282#Comment_125282

You can see them at the bottom right corner.

Jirapongse · April 17

@mahesh_m

Thank you for reaching out to us.

Is it this one?

 ld.get_history(
    universe="IBM.N",
    fields=['TR.Revenue', 'TR.F.Source', 'TR.F.PeriodEndDate'],
    start="2000-01-01",
    end="2050-01-01",
    parameters={'Period':'FQ0','FRQ':'FQ'}
    )

You use the Data Item Browser tool to list all available parameters.

mahesh_m · April 27

https://community.developers.refinitiv.com/discussion/comment/125283#Comment_125283

Thanks @Jirapongse , is there way to fetch all the period data through single API call . Period data - FQ0, FQ1, FQ2, FQ3

I need the entire period end dates for the unvierse

could you please guide me here

Jirapongse · April 28

https://community.developers.refinitiv.com/discussion/comment/125442#Comment_125442

@mahesh_m

It should support one period at a time.

You need to contact the Workspace Excel support team directly via MyAccount to confirm this.

This function is similar to the =@RDP.Data function in Excel.

I need to retrieve the financial period end dates from the income statement using Python.

Best Answers

Answers

Categories

EXPLORE OUR SITES

I need to retrieve the financial period end dates from the income statement using Python.

Best Answers

Answers

Categories