The rule in plain words
In Market risk: standardised approach for position risks in traded debt instruments (MKR SA TDI) (OF18.00.01.01): the cells it covers on sheet "Total" (sheet 0001) must equal the sum of the cells it covers on 23 sheets.
What to do if your return fails it
- 01Open the table below and find the cells the rule reads.
- 02Add up the parts in your return and compare the result with the total.
- 03If they differ, a part is missing, a value sits in the wrong cell, or the total is out of date.
- 04The Bank of England allows a small rounding difference, worked out from the decimals each value is reported with.
- 05It runs only when your filing indicators mark OF18.00.01 as reported.
- 06This is a warning. It does not stop the return on its own, but your supervisor may ask you to explain it.
The cells it reads
Market risk: standardised approach for position risks in traded debt instruments (MKR SA TDI) (OF18.00.01.01)
Rows
- R0012Derivatives
- R0013Other assets and liabilities
- R0020Maturity-based approach
- R0030Zone 1
- R0080Zone 2
- R0120Zone 3
- R0210Duration-based approach
- R0220Zone 1
- R0230Zone 2
- R0240Zone 3
- R0251Own funds requirement for non-securitisation debt instruments
- R0260Debt securities under the first category in Table 1
- R0270Debt securities under the second category in Table 1
- R0280With residual term <= 6 months
- R0290With a residual term > 6 months and <= 24 months
- R0300With a residual term > 24 months
- R0310Debt securities under the third category in Table 1
- R0320Debt securities under the fourth category in Table 1
- R0321Rated nth-to default credit derivatives
Columns
- C0010Long
- C0020Short
Sheets
- S0001Total
- S0002Euro
- S0003Lek
- S0004Bulgarian Lev
- S0005Czech Koruna
- S0006Danish Krone
- S0007Pound Sterling
- S0008Forint
- S0009Yen
- S0012Denar
- S0013Zloty
- S0014Romanian Leu
- S0015Russian Ruble
- S0016Serbian Dinar
- S0017Swedish Krona
- S0018Swiss Franc
- S0019Turkish Lira
- S0020Hryvnia
- S0021US Dollar
- S0022Iceland Krona
- S0023Norwegian Krone
- S0024Egyptian Pound
- S0025Other
- S0026Croatian Kuna
Which returns it applies to
Line4 Check runs it on the own funds (PRA001) return on Bank of England banking taxonomy 4.1.1. The Bank of England applies it to own funds (PRA001) returns, as a warning.
The Bank’s own words and formula
The plain words above spell out the Bank’s formula, with each cell named from its templates. In the Bank of England’s list of validations, word for word:
[v6268_m];[scope({t: OF18.00.01.01, r:0012;0013;0020;0030;0080;0120;0210;0220;0230;0240;0251;0260;0270;0280;0290;0300;0310;0320;0321,c:0010;0020})];[{t: OF18.00.01.01, z: 0001} = sum({t: OF18.00.01.01, z: 0002; 0003; 0004; 0005; 0006; 0007; 0008; 0009; 0012; 0013; 0014; 0015; 0016; 0017; 0018; 0019; 0020; 0021; 0022; 0023; 0024; 0025; 0026})]
Show the formulaShowHide
The Bank of England's formula. Cells are written as {t: table, r: row, c: column}.
{t: OF18.00.01.01, z: 0001} = sum({t: OF18.00.01.01, z: 0002; 0003; 0004; 0005; 0006; 0007; 0008; 0009; 0012; 0013; 0014; 0015; 0016; 0017; 0018; 0019; 0020; 0021; 0022; 0023; 0024; 0025; 0026})Where it applies, in the Bank's words (its scope):
scope({t: OF18.00.01.01, r:0012;0013;0020;0030;0080;0120;0210;0220;0230;0240;0251;0260;0270;0280;0290;0300;0310;0320;0321,c:0010;0020, f: banking, fv: banking_reporting})Other rules on Market risk: standardised approach for position risks in traded debt instruments (MKR SA TDI) (OF18.00.01.01)
- The cells it covers on sheet "Total" must equal the sum of the cells it covers on 23 sheets (v6269_m)
- The cells it covers on sheet "Total" must equal the sum of the cells it covers on 23 sheets (v6270_m)
- Market risk: standardised approach for position risks in traded debt instruments (MKR SA TDI): a total must equal the sum of its parts (v6019_m)Blocking
- "Own funds requirement for securitisation instruments" in column "Own funds requirements" on 23 sheets must be left empty (v7321_n)
- "Own funds requirement for the correlation trading portfolio" in column "Own funds requirements" on 23 sheets must be left empty (v7322_n)
- "Duration-based approach" must equal the sum of "Zone 1", "Zone 2" and "Zone 3" (v4852_m)Blocking
- Market risk: standardised approach for position risks in traded debt instruments (MKR SA TDI): "Zone 3" must equal the sum of 8 cells (v4851_m)Blocking
- Market risk: standardised approach for position risks in traded debt instruments (MKR SA TDI): a total must equal the sum of its parts (v4850_m)Blocking
Every PRA banking rule on OF18.00.01.01
Checks like this one, run at the point of submission, are the first step to real-time supervision. Line4 builds SupTech software for financial regulators that runs checks like these as each return arrives.
