py-xbrl
py-xbrl copied to clipboard
Any way to link different facts together in a coherent way?
XBRL document Please provide a link to the XBRL document(s) with which you have encountered the issue https://www.sec.gov/Archives/edgar/data/1918712/000191871224000099/asif-20240630.htm
Describe the bug
Hi, I'm trying to parse this document, and get key information about all the underlying loans of this BDC. If you look at the document, you can see a table with hundreds of loans, and lots of information about each one in a table format (eg. name, interest rate, reference rate, spread, etc.). When I use py-xbrl
to parse the document, I indeed get back JSON, however, it's just thousands of facts and seemingly no way to relate these facts to one another.
For example... Here's some parsed JSON from the library
"f784": {
"dimensions": {
"unit": "iso4217:USD",
"concept": "InvestmentOwnedAtFairValue",
"entity": "0001918712",
"period": "2024-06-30",
"InvestmentIssuerNameAxis": "NomiHealthInc.Member"
},
"decimals": -2,
"value": 18325500
},
"f785": {
"dimensions": {
"unit": "xbrli:pure",
"concept": "InvestmentInterestRate",
"entity": "0001918712",
"period": "2024-06-30"
},
"decimals": null,
"value": 0.0771
},
"f786": {
"dimensions": {
"unit": "xbrli:pure",
"concept": "InvestmentBasisSpreadVariableRate",
"entity": "0001918712",
"period": "2024-06-30"
},
"decimals": null,
"value": 0.0225
},
I thought, "hmm.. maybe these facts are in order of how they appear in the document". So maybe Nomi has a 7.71% interest rate. (from f785). But if you look up Nomi Health Inc, you see...
And you can see the actual interest rate for Nomi is 13.64%. You can see that there is a 7.71% interest rate for the loan below Nomi (Option Care). However, how would I know exactly that? Is there some clean way to organize the thousands of facts into coherent groupings? Note, I also thought maybe the entity would be it, but the entity number 0001918712
is the same for all of the facts. It seems it represents Ares itself, and not the company the loan is being made to.