question

Upvotes
Accepted
2 5 5 8

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 512.0 KiB each and 1.0 MiB total.

@oliver.rogers19

Hi,

Thank you for your participation in the forum.

Is the reply below satisfactory in answering your question?

If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

Hello @oliver.rogers19 ,

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

-AHS

1 Answer

· Write an Answer
Upvotes
Accepted
17.3k 82 39 63

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 512.0 KiB each and 1.0 MiB total.

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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