Q25, run 2026-11-04-1738-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 = 66

✅ D1 sql run 1 graded by code · query session

66. This counts instruments with BBB- or better in their latest INST action, excluding expired ones.

JSON: {"count": 66}

✅ D1 sql run 2 graded by code · query session

66. Of the 106 instruments rated on 2026-10-01 (latest action not EX), 66 were investment grade.

JSON: {"count": 66}

✅ D1 sql run 3 graded by code · query session

66. These are instruments whose latest action on or before 2026-10-01 is not an expiry (EX) and whose rating is BBB- or better.

JSON: {"count": 66}

✅ D1 sql run 4 graded by code · query session

66. These are instruments whose latest rating on 2026-10-01 was BBB- or better and had not expired.

JSON: {"count": 66}

✅ D1 sql run 5 graded by code · query session

66 instruments. This counts those whose latest INST rating is BBB- or better and is not an expiry (EX).

JSON: {"count": 66}

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

66. Of the 106 instruments with a rating, 66 are BBB- or better.

JSON: {"count": 66}

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

66. Of the 106 instruments with a live rating (EX actions are ignored), 66 are rated BBB- or higher.

JSON: {"count": 66}

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

66. This counts instruments whose latest rating on 1 October 2026 is BBB- or better. The expected rating (EX) on I08 is excluded.

JSON: {"count": 66}

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

66. These are instruments whose latest non-EX action by 1 October 2026 is investment grade.

JSON: {"count": 66}

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

66 instruments, excluding EX-only instruments and those of QA issuers.

JSON: {"count": 66}

✅ D4 sparql run 1 graded by code · query session

66 instruments, counting those whose latest rating on 2026-10-01 is BBB- or better.

JSON: {"count": 66}

❌ D4 sparql run 2 graded by code · query session

69 instruments held an investment-grade rating on 2026-10-01, out of 112 rated. This counts I08's A (A47, action EX), whose meaning isn't defined in the data.

JSON: {"count": 69}

Why: count: expected 66, got 69

✅ D4 sparql run 3 graded by code · query session

66.

JSON: {"count": 66}

❌ D4 sparql run 4 graded by code · query session

69. Of 112 instruments carrying a rating on 1 Oct 2026, 69 were BBB- or better.

JSON: {"count": 69}

Why: count: expected 66, got 69

✅ D4 sparql run 5 graded by code · query session

66. This counts instruments whose latest rating is investment grade, excluding expired or withdrawn ratings.

JSON: {"count": 66}

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

66 instruments held an investment-grade rating on 2026-10-01, with expected-rating (EX) actions ignored.

JSON: {"count": 66}

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

66. Of the 106 instruments rated on 2026-10-01, 66 were BBB- or higher. The expected-rating action EX on I08 does not count.

JSON: {"count": 66}

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

66. This counts instruments whose latest non-Expected rating on 2026-10-01 is investment grade.

JSON: {"count": 66}

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

66 instruments held an investment-grade rating. The unconfirmed expected rating on I08 is not counted.

JSON: {"count": 66}

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

66, counting the latest INST rating per instrument and ignoring EX actions.

JSON: {"count": 66}