question

sihan4 avatar image
18 0 0 2

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
10 |1500

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

umer.nalla avatar image
23.5k 84 10 22

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)
1 comment
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!

sihan4 avatar image
18 0 0 2

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!

10 |1500

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

umer.nalla avatar image
23.5k 84 10 22

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.


1 comment
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.