"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 -
@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.I just learned from my colleague0
-
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
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 684 Datastream
- 1.4K DSS
- 615 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 249 ETA
- 554 WebSocket API
- 37 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 643 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 26 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 192 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛