The original call (search.Views.GOV:CORP_INSTRUMENTS ….) calls the Ticker. How can I change it to download the RIC? When I writeresponse = search.Definition(view = search.Views.GOV_CORP_INSTRUMENTS,
filter = f"(DbType eq 'CORP' and RCSAssetCategory eq 'A:J' and ((ParentOAPermID eq '{org_id}') and IssueDate le 2024-12-31 and MaturityDate ge 2013-10-01 and (ISIN eq 'CH*' or ISIN eq 'XS*') and RCSDomicileGenealogy in ('G:30')))",
top = 10000,
select = RIC,ParentIssuerName,DTSubjectName,IssueDate,MaturityDate,Currency,FaceIssuedTotal, ISIN',
navigators = "Currency").get_data()
it returns a weird scramble that looks like half an lei but with special symbols in it.Also, I tried to apply your below logic but using the ISIN instead. However, not every ISIN seems to have a corresponding LEI. So I’d really rather get the LEI based on the RIC.
ticker ric parent
ROG CH121171322= Roche Hldg
ROG CH116615189= Roche HldgFor example like this. But this is not a RIC obviously.
This is with this call:response = search.Definition(view = search.Views.GOV_CORP_INSTRUMENTS,
filter = f"(DbType eq 'CORP' and RCSAssetCategory eq 'A:J' and ((ParentOAPermID eq '{org_id}') and IssueDate le 2024-12-31 and MaturityDate ge 2013-10-01 and (ISIN eq 'CH*' or ISIN eq 'XS*') and RCSDomicileGenealogy in ('G:30')))",
top = 10000,
select = 'Ticker,RIC,ParentIssuerName,DTSubjectName,IssueDate,MaturityDate,Currency,FaceIssuedTotal, ISIN',
navigators = "Currency").get_data()
