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

Find more posts tagged with

rdp-api

refinitiv-data-platform

Accepted answers

nick.zincone

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.

All comments

nick.zincone

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.

oliver.rogers19

Hi @nick.zincone, 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

EXPLORE OUR SITES