Q25, run 2026-11-04-2024-sonnet-query
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 = 72
sql run 1
72. This counts instruments whose latest INST rating on 2026-10-01 was investment grade and not an expiry (EX).
JSON: {"count": 72}
sql run 2
72 instruments.
JSON: {"count": 72}
sql run 3
72 instruments were rated investment grade on 1 Oct 2026, excluding expired ratings.
JSON: {"count": 72}
sql+markdown run 1
52. This counts instruments whose latest non-EX rating on 2026-10-01 is BBB- or better.
JSON: {"count": 52}
Why: count: expected 72, got 52
sql+markdown run 2
72 of the 113 instruments rated on 1 Oct 2026 were investment grade.
JSON: {"count": 72}
sql+markdown run 3
72.
JSON: {"count": 72}
sparql run 1
75. This sums the latest instrument ratings of BBB- or better on 1 Oct 2026.
JSON: {"count": 75}
Why: count: expected 72, got 75
sparql run 2
72 of the 113 instruments with a current rating.
JSON: {"count": 72}
sparql run 3
75 instruments held an investment-grade rating on 1 October 2026.
JSON: {"count": 75}
Why: count: expected 72, got 75
sparql+ontology run 1
72. I counted instruments whose latest rating, ignoring withdrawn or expected-only ones, is BBB- or better. Of 113 rated instruments, 72 qualify.
JSON: {"count": 72}
sparql+ontology run 2
72. This counts instruments whose latest non-Expected rating on 1 Oct 2026 is BBB- or better; 113 instruments held a rating at all.
JSON: {"count": 72}
sparql+ontology run 3
72 instruments, counting the latest non-EX action on or before 1 Oct 2026 and excluding withdrawn ones.
JSON: {"count": 72}
sql+executed run 1
72 instruments held an investment-grade rating on 1 October 2026.
JSON: {"count": 72}
sql+executed run 2
72 instruments.
JSON: {"count": 72}
sql+executed run 3
72. This is the number of instruments with a non-WD rating of BBB- or higher in force on 1 October 2026.
JSON: {"count": 72}
sparql+axioms run 1
72 of the 113 instrument ratings in force are investment grade.
JSON: {"count": 72}
sparql+axioms run 2
72, summing the investment-grade (BBB- and above) counts in the in-force instrument ratings.
JSON: {"count": 72}
sparql+axioms run 3
At least 5 (I01, I03, I05, I06, I07). I did not count the many other instruments, so the true figure is likely higher.
JSON: {"count": 5}
Why: count: expected 72, got 5