question

Upvotes
Accepted
18 0 1 3

How can I get the country of domicle from this page

a490d0dfd42eb719119708d3b3aa337.png

I search the company name Attis Industries Inc in the top left window and it returns me this results.

How can I get the country of domicile using CODEBOOK. Is this what I can get by using the function like this?

response=search.Definition(

query = f"ATTIS INDUSTRIES INC",

).get_data()


refinitiv-dataplatform-eikon
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.

Upvote
Accepted
25.3k 87 12 25

Hi @sihan4

As explained in this article -Searching for KungFu Bonds (Chinese-issued U.S. dollars bonds) with RDP Libraries - Search function | Refinitiv Developers - you can export the query from the Eikon/Workspace Search tool into Codebook format.

1652694432371.png

1652694442616.png

The format of the above Codebook output is currently using the older RDP Library.
However, if you note from the Search Example Notebooks in Codebook, they are now using the newer RD Library - which requires some changes to the above query e.g.

response = search.Definition(
    view = search.SearchViews.ORGANISATIONS,
    query = "ATTIS INDUSTRIES INC",
    filter = "( SearchAllCategoryv2 eq 'Companies/Issuers')",
    top = 10,
    select = "CommonName,Gics,RCSOriginalAccountsCurrencyLeaf,PrimaryRIC,Orgid,BondsCount,CdsCount,EquitiesCount,FundsCount,FuturesCount,LoanCount,MortgagesCount,OptionsCount,WarrantsCount,OAPermID,OwnershipExists,OrganisationStatus,MktCapCompanyUsd,RCSFilingCountryLeaf,RCSTRBC2012Leaf,UltimateParentOrganisationOrgid,UltimateParentCompanyOAPermID,RatingX1XRatingRank,BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,DTSubjectName,UltimateParentOrganisationName,DTSimpleType,RCSOrganisationSubTypeLeaf,RCSCountryHeadquartersLeaf"
).get_data()
response.data.df

I can see from the output that the RCSCountryHeadquartersLeaf value contains the country of domicile value.



1652694432371.png (91.8 KiB)
1652694442616.png (53.4 KiB)
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.

Thanks very much for your help, Umer! That is exactly what I want.

Another trivial question is whether the country of domicile information is static and is there a way of obtaining dynamic country information just like time-series stock price. Thanks in advance!

Upvote
18 0 1 3

Thanks very much for your help! That is exactly what I want.

Another trivial question is whether the country of domicile information is static and is there a way of obtaining dynamic country information just like time-series stock price. Thanks in advance!

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.

Upvotes
25.3k 87 12 25

Hi @sihan4

I am not sure what you mean by time-series stock price data - time-series for me means historical data for an instrument going back days or years etc.

In terms of your country information - are you looking for historical country of domicile data or do you mean getting live updates when the domicile data changes?

Live updating data makes sense for market price data which changes frequently and is delivered by a live streaming feed - which required the consuming application to maintain a constant live connection in order to receive update events as and when there is market movement. This would not be appropriate for something like country of domicile data which does not change that often.


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.

Thanks very much for your explanation. That basically answers my questions. 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.