py-xbrl icon indicating copy to clipboard operation
py-xbrl copied to clipboard

Any way to link different facts together in a coherent way?

Open blakewest opened this issue 5 months ago • 0 comments

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... image

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.

blakewest avatar Aug 28 '24 20:08 blakewest