Q25, run 2026-11-06-0935-sonnet-query

← back to the run

How many instruments held an investment-grade rating on 1 October 2026?

Tests: Instrument ratings: counted on the instrument's own rating, not its issuer's.

Expected: count = 5

❌ D1 sql run 1 graded by code · query session

6. By my reading, I01 (BBB), I03 (A), I05 (BBB+), I06 (A-), I07 (BBB-) and I08 (A) are investment grade. I08's action code "EX" is undefined in the data. If it does not count as a held rating, the answer is 5.

JSON: {"count": 6}

Why: count: expected 5, got 6

✅ D1 sql run 2 graded by code · query session

5. These are I01 (BBB), I03 (A), I05 (BBB+), I06 (A-) and I07 (BBB-). I08's only record is action type EX (A47), which the data does not define; I treated it as an expected rating, not a held one.

JSON: {"count": 5}

✅ D1 sql run 3 graded by code · query session

5. Of the instruments, I01, I03, I05, I06 and I07 were investment grade on that date. I02 and I04 were not. I08's A47 has action code "EX", which the data doesn't define, so I haven't counted it. If it is a final rating, the count would be 6.

JSON: {"count": 5}

✅ D1 sql run 4 graded by code · query session

5. These are I01 (BBB), I03 (A), I05 (BBB+), I06 (A-) and I07 (BBB-). I08's rating ended with A47 (EX). The data does not define EX, so I read it as ending the rating.

JSON: {"count": 5}

✅ D1 sql run 5 graded by code · query session

5. These are I01 (BBB), I03 (A), I05 (BBB+), I06 (A-) and I07 (BBB-). I02 and I04 are below investment grade, and I08 is excluded, as explained under Q47.

JSON: {"count": 5}

✅ D2 sql+markdown run 1 graded by code · query session

5. These are I01 (BBB), I03 (A), I05 (BBB+), I06 (A-) and I07 (BBB-).

JSON: {"count": 5}

✅ D2 sql+markdown run 2 graded by code · query session

5. I01 is BBB, I03 is A, I05 is BBB+, I06 is A- and I07 is BBB-. I02 (BB+) and I04 (BB) are speculative, and I08 has only an expected rating (EX).

JSON: {"count": 5}

✅ D2 sql+markdown run 3 graded by code · query session

5. These are I01 (BBB), I03 (A), I05 (BBB+), I06 (A-) and I07 (BBB-).

JSON: {"count": 5}

✅ D2 sql+markdown run 4 graded by code · query session

5. I01 (BBB), I03 (A), I05 (BBB+), I06 (A-) and I07 (BBB-) are investment grade. I02 (BB+) and I04 (BB) are not, and I08 has only an expected rating.

JSON: {"count": 5}

✅ D2 sql+markdown run 5 graded by code · query session

5. These are I01 (BBB), I03 (A), I05 (BBB+), I06 (A-) and I07 (BBB-). I02 and I04 are speculative grade, and I08 has only an expected rating (A47).

JSON: {"count": 5}

✅ D4 sparql run 1 graded by code · query session

5: I01, I03, I05, I06 and I07. I08's only record, A47, has the action code "EX", which the data doesn't define, so I excluded it as not a settled rating. If it counts, the answer is 6.

JSON: {"count": 5}

✅ D4 sparql run 2 graded by code · query session

5. I01 (BBB), I03 (A), I05 (BBB+), I06 (A-) and I07 (BBB-) are investment grade. I08's only record is an "EX" action (A47), whose meaning isn't defined in the data, so I did not count it.

JSON: {"count": 5}

✅ D4 sparql run 3 graded by code · query session

5: I01 (BBB), I03 (A), I05 (BBB+), I06 (A-) and I07 (BBB-). I08's A rating ended with action EX (A47). I'm assuming EX means the rating ended, since the data does not define it.

JSON: {"count": 5}

❌ D4 sparql run 4 graded by code · query session

6: I01, I03, I05, I06, I07 and I08.

JSON: {"count": 6}

Why: count: expected 5, got 6

❌ D4 sparql run 5 graded by code · query session

6. These are I01 (BBB), I03 (A), I05 (BBB+), I06 (A-), I07 (BBB-) and I08 (A). I02 (BB+) and I04 (BB) are below investment grade.

JSON: {"count": 6}

Why: count: expected 5, got 6

✅ D5 sparql+ontology run 1 graded by code · query session

5. These are I01 (BBB), I03 (A), I05 (BBB+), I06 (A-) and I07 (BBB-).

JSON: {"count": 5}

✅ D5 sparql+ontology run 2 graded by code · query session

5. These are I01 (BBB), I03 (A), I05 (BBB+), I06 (A-) and I07 (BBB-).

JSON: {"count": 5}

✅ D5 sparql+ontology run 3 graded by code · query session

5. These are I01 (BBB), I03 (A), I05 (BBB+), I06 (A-) and I07 (BBB-). I08 has only an Expected rating, so it is unrated.

JSON: {"count": 5}

✅ D5 sparql+ontology run 4 graded by code · query session

5. I01 (BBB), I03 (A), I05 (BBB+), I06 (A-) and I07 (BBB-) qualify. I02 and I04 are speculative grade, and I08 has only an Expected rating.

JSON: {"count": 5}

✅ D5 sparql+ontology run 5 graded by code · query session

5. I01 (BBB), I03 (A), I05 (BBB+), I06 (A-) and I07 (BBB-) are investment grade. I02 and I04 are speculative grade, and I08 has only an expected rating.

JSON: {"count": 5}

✅ D3 sql+executed run 1 graded by code · query session

5. The instruments rated investment grade are I01, I03, I05, I06 and I07.

JSON: {"count": 5}

✅ D3 sql+executed run 2 graded by code · query session

5. The investment-grade instruments are I01 (BBB), I03 (A), I05 (BBB+), I06 (A-) and I07 (BBB-).

JSON: {"count": 5}

✅ D3 sql+executed run 3 graded by code · query session

5. The investment-grade instruments are I01 (BBB), I03 (A), I05 (BBB+), I06 (A-) and I07 (BBB-).

JSON: {"count": 5}

✅ D3 sql+executed run 4 graded by code · query session

5. I01 (BBB), I03 (A), I05 (BBB+), I06 (A-) and I07 (BBB-) were investment grade. I02 and I04 were not, and I08 has no rating.

JSON: {"count": 5}

✅ D3 sql+executed run 5 graded by code · query session

5. The investment-grade instruments are I01 (BBB), I03 (A), I05 (BBB+), I06 (A-) and I07 (BBB-).

JSON: {"count": 5}

✅ D6 sparql+axioms run 1 graded by code · query session

5. The investment-grade instruments are I01, I03, I05, I06 and I07.

JSON: {"count": 5}

✅ D6 sparql+axioms run 2 graded by code · query session

5. The investment-grade instruments are I01, I03, I05, I06 and I07.

JSON: {"count": 5}

✅ D6 sparql+axioms run 3 graded by code · query session

5. These are I01, I03, I05, I06 and I07.

JSON: {"count": 5}

✅ D6 sparql+axioms run 4 graded by code · query session

5: I01, I03, I05, I06 and I07.

JSON: {"count": 5}

✅ D6 sparql+axioms run 5 graded by code · query session

5. The investment-grade instruments are I01, I03, I05, I06 and I07. I08's rating (A47) ended in an exchange and is not in force.

JSON: {"count": 5}