question

Upvotes
Accepted
oliver.rogers19 avatar image
2 ●2 ●0 ●3

Trying to get a list of RICs for all companies within a TRBC Industry Group for a specific year?

The closest I have got is:

RIC = rdp.search(
        view = rdp.SearchViews.Organisations,
        filter = f"RCSTRBC2012Name eq 'Basic materials\\Mineral resources' and Revenue ge 10000000 and FinancialYear eq 2009",
        select = "PrimaryRIC2012", top = 10000)

How do I get this search to work and only pull RICs from 2009? Thanks

rdp-apirefinitiv-data-platform
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
nick.zincone avatar image
9.7k ●49 ●38 ●60

Hi @oliver.rogers19

I could not find the FinancialYear property but only the 'DocDateTime' property which may not apply here. Can you tell us what the year represents?

Alternatively, I would suggest opening a ticket within Refinitiv Support (https://my.refinitiv.com/content/mytr/en/helpandsupport.html) asking whether the search service has this content available.

icon clock
10 |1500

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

oliver.rogers19 avatar image oliver.rogers19
Hi @nick.zincone.1, by specifying a given year what I am hoping to achieve is to get a list of RICs active in a specific TRBC Industry Group in the given year. The assumption that underpins this request is that the RICs in a given TRBC category will change over time as companies merge/liquidate/change focus. I am interested in historical industry players in a given segment so being able to inspect historical TRBC category members would be very helpful for this. Thanks
Click below to post an Idea Post Idea