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
Best Answer
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.
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