"TR.PPBankruptcyFilingDate" data field.
Greetings,
I am currently involved in a project that necessitates the retrieval of data pertinent to delistings. For this purpose, I am utilizing the 'TR.MnAHasBankruptcy' and 'TR.PPBankruptcyFilingDate' fields to ascertain whether a company has filed for bankruptcy. However, I have encountered an issue wherein the 'TR.PPBankruptcyFilingDate' field fails to return any data. I have been advised to re-submit my inquiry here for further assistance. I hope you can provide the necessary support. Thank you.
df = rd.get_data(
universe = rics,
fields = [
'TR.IsDelistedQuote',
'DELIST_DAT',
'TR.RetireDate',
'TR.MnAHasBankruptcy',
"TR.MnAAcquisitionTechnique(Concat='|')",
'TR.PPBankruptcyFilingDate',
],
parameters={
'SDate': "2022-11-30",
'EDate': "2024-12-31",
'Frq': 'D'
}
)
print(df)
Best Answer
-
Hi @vitali ,
As the ticket that you have opened to helpdesk via MyRefinitiv was closed. Ticket number 13446169 was raised on your behalf and the helpdesk is going to contact the content team to confirm if this data is available.
Thank you and we're apologize for any inconvenient you have faced.
0
Answers
-
Hi @vitali ,
Would you mind providing a couple of RICs which fail and also sharing the error code if any? That would help us to debug the the issue and see if that is related to the API or the actual content (in which case the Helpdesk would be a better place to get an assistance).
Best regards,
Haykaz
0 -
Hi, @aramyan.h! Sure, here is a full code (The first part of the code retrieves all RICs that match specific PermID. In this case it's 4295899979 (TROIKA MEDIA GROUP INC) current RIC is TRKAQ.PK) :
import refinitiv.data as rd
rd.open_session()
results = rd.discovery.search(
view=rd.discovery.Views.EQUITY_QUOTES,
top=500,
filter="(IssuerOAPermID eq '4295899979' and RCSAssetCategoryLeaf eq 'Ordinary Share')",
select="RIC, DTSubjectName, RCSAssetCategoryLeaf, ExchangeName, ExchangeCountry"
)
df = results
substrings = ['.OQ', '.O', '.N', '.A', '.PK', '.PQ']
def is_valid_ric(ric):
for ending in substrings:
if ending in ric:
pos = ric.find(ending)
if len(ric) == pos + len(ending) or (len(ric) > pos + len(ending) and ric[pos + len(ending)] == '^'):
return True
return False
filtered_df = df[df['RIC'].apply(is_valid_ric)]
rics = filtered_df['RIC'].tolist()
df = rd.get_data(
universe = rics,
fields = [
'TR.IsDelistedQuote',
'DELIST_DAT',
'TR.RetireDate',
'TR.MnAHasBankruptcy',
"TR.MnAAcquisitionTechnique(Concat='|')",
'TR.PPBankruptcyFilingDate',
],
parameters={
}
)
print(df)
Output:0 -
Hi @vitali ,
Thank you for sharing the details. I can verify that your code is correct and it seems that 'TR.PPBankruptcyFilingDate' field is not available for the instruments. You can verify this by asking in the Content case you were referring in your question. Please mention that we verify your code and your question is related to the content. That way they will not refer to us as there is no issue with your code or the API.
In the meantime, I have tried calling .date on 'TR.MnAHasBankruptcy' and it seems to work for me (you can further confirm with the content team if this is the actual bankruptcy filing date). You can check it below:
df = rd.get_data(
universe = rics,
fields = [
'TR.IsDelistedQuote',
'DELIST_DAT',
'TR.RetireDate',
'TR.MnAHasBankruptcy',
"TR.MnAAcquisitionTechnique(Concat='|')",
'TR.PPBankruptcyFilingDate',
'TR.MnAHasBankruptcy.date'
],
parameters={
}
)
dfHope this helps.
Best regards,
Haykaz
0 -
I just learned from my colleague @raksina.samasiri , that she will ask the support team to re-open your case and explain that this is not related to API but rather related to the content. So you get a better understanding of the situation.0
-
Thank you for delivering the solution. However, I've encountered an issue with the 'TR.MnAHasBankruptcy.date' field, as it fails to accurately display the "Bankruptcy Date" for certain companies, including HTZ.OQ. Notably, HTZ.OQ (it was HTZ.N that time, I believe) filed for bankruptcy on May 5, 2020, yet the 'TR.MnAHasBankruptcy.date' does not reflect this event.
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛