Q18, run 2026-11-04-1738-sonnet-query

Which issuers were on Rating Watch Negative on 1 October 2026?

Tests: Watch over time: Marlow's Watch ended with its 2026 affirmation.

Expected: issuers = ['E06', 'E1006', 'E1013', 'E1019', 'E1037', 'E1039', 'E1059', 'E1061', 'E1066', 'E1088', 'E1098', 'E1099', 'E1109', 'E1126', 'E1132', 'E1133', 'E1146', 'E1168', 'E1181', 'E1194', 'E1203', 'E1209', 'E1238', 'E1242', 'E1260', 'E1264', 'E1266', 'E1267', 'E1297', 'E1314', 'E1317', 'E1323']

✅ D1 sql run 1 graded by code · query session

The 32 issuers are in the JSON. Each one's latest issuer-rating action by 1 Oct 2026 carries RWN; for E1059, only the local-currency (LC) rating is on watch, which is why it also appears in Q19.

JSON: {"issuers": ["E1317", "E1037", "E1209", "E1242", "E1146", "E1323", "E1203", "E1066", "E1314", "E1109", "E1168", "E1181", "E1019", "E1006", "E1264", "E06", "E1133", "E1266", "E1039", "E1059", "E1260", "E1099", "E1132", "E1267", "E1126", "E1098", "E1088", "E1194", "E1297", "E1061", "E1013", "E1238"]}

✅ D1 sql run 2 graded by code · query session

32 entities were on Rating Watch Negative, listed in the JSON.

JSON: {"issuers": ["E1133", "E06", "E1061", "E1013", "E1238", "E1297", "E1266", "E1039", "E1059", "E1194", "E1088", "E1203", "E1314", "E1146", "E1323", "E1066", "E1098", "E1126", "E1019", "E1264", "E1006", "E1317", "E1037", "E1209", "E1242", "E1168", "E1109", "E1260", "E1132", "E1099", "E1181", "E1267"]}

✅ D1 sql run 3 graded by code · query session

32 issuers, listed in the JSON. Their latest issuer action on or before 2026-10-01 carries a Rating Watch Negative flag.

JSON: {"issuers": ["E1126", "E1242", "E1066", "E1006", "E1099", "E1181", "E1019", "E1037", "E1317", "E1061", "E1238", "E06", "E1059", "E1088", "E1264", "E1210", "E1168", "E1133", "E1132", "E1297", "E1146", "E1266", "E1098", "E1013", "E1039", "E1109", "E1194", "E1203", "E1260", "E1267", "E1314", "E1323"]}

❌ D1 sql run 4 graded by code · query session

The 30 issuers listed in the JSON. This uses the latest foreign-currency rating on 2026-10-01 being on Rating Watch Negative.

JSON: {"issuers": ["E1037", "E1126", "E1132", "E1168", "E1006", "E1133", "E1203", "E1260", "E1317", "E1210", "E1264", "E1267", "E1109", "E1061", "E1323", "E1066", "E1098", "E1266", "E1314", "E06", "E1297", "E1013", "E1146", "E1181", "E1238", "E1099", "E1088", "E1194", "E1039", "E1242"]}

Why: issuers: expected ['E06', 'E1006', 'E1013', 'E1019', 'E1037', 'E1039', 'E1059', 'E1061', 'E1066', 'E1088', 'E1098', 'E1099', 'E1109', 'E1126', 'E1132', 'E1133', 'E1146', 'E1168', 'E1181', 'E1194', 'E1203', 'E1209', 'E1238', 'E1242', 'E1260', 'E1264', 'E1266', 'E1267', 'E1297', 'E1314', 'E1317', 'E1323'], got ['E1037', 'E1126', 'E1132', 'E1168', 'E1006', 'E1133', 'E1203', 'E1260', 'E1317', 'E1210', 'E1264', 'E1267', 'E1109', 'E1061', 'E1323', 'E1066', 'E1098', 'E1266', 'E1314', 'E06', 'E1297', 'E1013', 'E1146', 'E1181', 'E1238', 'E1099', 'E1088', 'E1194', 'E1039', 'E1242']

✅ D1 sql run 5 graded by code · query session

32 issuers were on Rating Watch Negative on 2026-10-01, listed in the JSON. This counts an entity if either its FC or LC rating was on watch.

JSON: {"issuers": ["E1133", "E06", "E1260", "E1099", "E1132", "E1181", "E1013", "E1238", "E1061", "E1297", "E1109", "E1168", "E1317", "E1242", "E1037", "E1209", "E1203", "E1146", "E1323", "E1066", "E1314", "E1266", "E1039", "E1059", "E1267", "E1088", "E1194", "E1006", "E1264", "E1019", "E1098", "E1126"]}

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

32 issuers, listed in the JSON, with the latest LTIDR on RWN as of 2026-10-01.

JSON: {"issuers": ["E1013", "E1297", "E1238", "E1061", "E1146", "E1203", "E1066", "E1314", "E1323", "E1133", "E06", "E1181", "E1194", "E1088", "E1019", "E1006", "E1264", "E1098", "E1126", "E1059", "E1266", "E1039", "E1267", "E1099", "E1132", "E1260", "E1317", "E1242", "E1037", "E1209", "E1168", "E1109"]}

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

32 issuers were on RWN on 2026-10-01, listed in the JSON below. This includes E1059 and E1019, whose RWN is on the local-currency rating.

JSON: {"issuers": ["E1194", "E1314", "E1264", "E1146", "E1317", "E1238", "E1297", "E1059", "E1039", "E1061", "E1019", "E1099", "E1203", "E1242", "E1066", "E1126", "E1088", "E1098", "E1132", "E1168", "E1006", "E1260", "E1109", "E1323", "E1266", "E1037", "E06", "E1013", "E1267", "E1181", "E1209", "E1133"]}

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

32 issuers were on Rating Watch Negative on 1 October 2026 (E06 among them), listed in the JSON.

JSON: {"issuers": ["E1194", "E1088", "E1266", "E1059", "E1039", "E1126", "E1098", "E1238", "E1297", "E1013", "E1061", "E1242", "E1317", "E1037", "E1066", "E1314", "E1323", "E1146", "E1203", "E1006", "E1264", "E1019", "E1181", "E1209", "E1168", "E1109", "E06", "E1133", "E1260", "E1132", "E1099", "E1267"]}

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

Thirty-two issuers were on Rating Watch Negative on 1 October 2026 (listed in the JSON).

JSON: {"issuers": ["E1037", "E1317", "E1242", "E1209", "E1238", "E1297", "E1061", "E1013", "E1266", "E1039", "E1059", "E1194", "E1088", "E1314", "E1066", "E1146", "E1323", "E1203", "E1132", "E1260", "E1099", "E1133", "E06", "E1181", "E1109", "E1168", "E1264", "E1006", "E1019", "E1267", "E1126", "E1098"]}

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

The list is in the JSON.

JSON: {"issuers": ["E1039", "E1059", "E1266", "E1317", "E1209", "E1242", "E1037", "E1006", "E1264", "E1019", "E1323", "E1066", "E1314", "E1146", "E1203", "E1181", "E1133", "E06", "E1126", "E1098", "E1132", "E1099", "E1260", "E1267", "E1088", "E1194", "E1061", "E1297", "E1238", "E1013", "E1109", "E1168"]}

✅ D4 sparql run 1 graded by code · query session

32 issuers (IDs in the JSON).

JSON: {"issuers": ["E1006", "E1013", "E1019", "E1037", "E1039", "E1059", "E1061", "E1066", "E1088", "E1098", "E1099", "E1109", "E1126", "E1132", "E1133", "E1146", "E1168", "E1181", "E1194", "E1203", "E1210", "E1238", "E1242", "E1260", "E1264", "E1266", "E1267", "E1297", "E1314", "E1317", "E1323", "E06"]}

✅ D4 sparql run 2 graded by code · query session

32 issuers are on Rating Watch Negative, listed in the JSON. This includes watches on local-currency (LC) ratings only (E1019, E1059).

JSON: {"issuers": ["E06", "E1006", "E1013", "E1019", "E1037", "E1039", "E1059", "E1061", "E1066", "E1088", "E1098", "E1099", "E1109", "E1126", "E1132", "E1133", "E1146", "E1168", "E1181", "E1194", "E1203", "E1210", "E1238", "E1242", "E1260", "E1264", "E1266", "E1267", "E1297", "E1314", "E1317", "E1323"]}

❌ D4 sparql run 3 graded by code · query session

The list in the JSON is incomplete, because part of the result set was not shown to me. E06 is certain (A17).

JSON: {"issuers": ["E06", "E1006", "E1013", "E1037", "E1039", "E1061", "E1066", "E1088", "E1098", "E1099", "E1109", "E1126", "E1132", "E1133", "E1146"]}

Why: issuers: expected ['E06', 'E1006', 'E1013', 'E1019', 'E1037', 'E1039', 'E1059', 'E1061', 'E1066', 'E1088', 'E1098', 'E1099', 'E1109', 'E1126', 'E1132', 'E1133', 'E1146', 'E1168', 'E1181', 'E1194', 'E1203', 'E1209', 'E1238', 'E1242', 'E1260', 'E1264', 'E1266', 'E1267', 'E1297', 'E1314', 'E1317', 'E1323'], got ['E06', 'E1006', 'E1013', 'E1037', 'E1039', 'E1061', 'E1066', 'E1088', 'E1098', 'E1099', 'E1109', 'E1126', 'E1132', 'E1133', 'E1146']

❌ D4 sparql run 4 graded by code · query session

30 issuers, listed in the JSON, were on Rating Watch Negative on 1 October 2026. This uses the latest foreign-currency action, and includes E06.

JSON: {"issuers": ["E1006", "E1013", "E1037", "E1039", "E1061", "E1066", "E1088", "E1098", "E1099", "E1109", "E1126", "E1132", "E1133", "E1146", "E1168", "E1181", "E1194", "E1203", "E1210", "E1238", "E1242", "E1260", "E1264", "E1266", "E1267", "E1297", "E1314", "E1317", "E1323", "E06"]}

Why: issuers: expected ['E06', 'E1006', 'E1013', 'E1019', 'E1037', 'E1039', 'E1059', 'E1061', 'E1066', 'E1088', 'E1098', 'E1099', 'E1109', 'E1126', 'E1132', 'E1133', 'E1146', 'E1168', 'E1181', 'E1194', 'E1203', 'E1209', 'E1238', 'E1242', 'E1260', 'E1264', 'E1266', 'E1267', 'E1297', 'E1314', 'E1317', 'E1323'], got ['E1006', 'E1013', 'E1037', 'E1039', 'E1061', 'E1066', 'E1088', 'E1098', 'E1099', 'E1109', 'E1126', 'E1132', 'E1133', 'E1146', 'E1168', 'E1181', 'E1194', 'E1203', 'E1210', 'E1238', 'E1242', 'E1260', 'E1264', 'E1266', 'E1267', 'E1297', 'E1314', 'E1317', 'E1323', 'E06']

✅ D4 sparql run 5 graded by code · query session

32 issuers, listed in the JSON, including E06.

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

The 32 issuers are in the JSON. They are the entities whose latest long-term action on 2026-10-01 carried Rating Watch Negative.

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

The 34 issuers are in the JSON. Each has a Rating Watch Negative as its latest action on 2026-10-01. E1019 and E1059 are on Watch only on their local-currency ratings.

JSON: {"issuers": ["E1126", "E1242", "E1066", "E1006", "E1099", "E1181", "E1019", "E1037", "E1317", "E1061", "E1238", "E06", "E1059", "E1088", "E1264", "E1210", "E1168", "E1133", "E1132", "E1297", "E1146", "E1266", "E1098", "E1203", "E1109", "E1267", "E1194", "E1314", "E1323", "E1260", "E1039", "E1013"]}

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

32 issuers were on Rating Watch Negative, listed in the JSON.

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

32 issuers were on Rating Watch Negative on 1 Oct 2026, listed in the JSON.

JSON: {"issuers": ["E1006", "E1013", "E1019", "E1037", "E1039", "E1059", "E1061", "E1066", "E1088", "E1098", "E1099", "E1109", "E1126", "E1132", "E1133", "E1146", "E1168", "E1181", "E1194", "E1203", "E1209", "E1238", "E1242", "E1260", "E1264", "E1266", "E1267", "E06", "E1297", "E1314", "E1317", "E1323"]}

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

32 issuers, listed in the JSON. Each has a latest action that is a Rating Watch Negative; a Watch holds until the next action.