{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Header Info","Direct","Admin"],"not_rendered":{"images":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Header Info","index":0,"n_rows":27,"n_cols":10,"rows_kept":27,"merged":[[28,1,88,10]]}
[]
[]
[]
[]
[]
[null,1,"Name of the template",{"$nulls":6},"Standard IDL - Direct Participants"]
[]
[null,2,"PRA template version control",{"$nulls":6},{"$f":"Version","v":"v1.02"}]
[]
[null,3,"Basis of reporting (select from list)"]
[]
[null,4,"Submission number (increase by 1 if resubmission)"]
[]
[null,5,"Firm reference number (FRN)"]
[]
[null,6,"Name of the firm"]
[]
[null,7,"Group reference number (where applicable)"]
[]
[null,8,"Reporting period start date",{"$nulls":6},{"$f":"IF(J22<>\"\",EOMONTH(J22,-1)+1,\"\")","v":""}]
[]
[null,9,"Reporting period end date"]
[]
[null,10,"Reporting currency for this report (select from list, all figures in thousands)"]
[]
[]
[null,"Notes from Firm, if any"]

{"sheet":"Direct","index":1,"n_rows":130,"n_cols":13,"rows_kept":130,"merged":[[13,2,13,7],[13,8,13,10]]}
[]
[null,"STANDARD INTRADAY LIQUIDITY TEMPLATE - DIRECT PARTICIPANTS"]
[]
[{"$nulls":3},"010","020","030","040","050","060","070","080"]
[null,"Currency",null,"GBP","USD","EUR","JPY","HKD","CHF","AUD","Others"]
["010","Name of large value payment system:"]
[]
[null,"A(i) Daily maximum intraday liquidity usage"]
[null,"1. Largest positive net cumulative position"]
["020","Max in period"]
["030","2nd max in period"]
["040","3rd max in period"]
["050","Average over period"]
[null,"2. Largest negative net cumulative position"]
["060","Max in period"]
["070","2nd max in period"]
["080","3rd max in period"]
["090","Average over period"]
[]
[null,"A(ii) Available intraday liquidity at start of day",null," ",{"$nulls":7}," "]
["100","Min in period"]
["110","2nd Min in period"]
["120","3rd min in period"]
["130","Average over period"]
[null,"Of which:",null," "]
["140","Total credit lines (secured & unsecured)"]
["150","Known credit facility received"]
[null,"Central Bank reserves"]
["160","Max in period"]
["170","2nd max in period"]
["180","3rd max in period"]
["190","Average over period"]
[null,"Collateral pledged at the Central Bank"]
["200","Max in period"]
["210","2nd max in period"]
["220","3rd max in period"]
["230","Average over period"]
[]
[null,"    A(iii) Total Payments"]
[null,"    1. Total gross payments sent (value)",{"$nulls":3}," "]
["240","Max in period"]
["250","2nd max in period"]
["260","3rd max in period"]
["270","Average over period"]
[{"$nulls":3}," "]
[null,"    2. Total gross payments received (value)"]
["280","Max in period"]
["290","2nd max in period"]
["300","3rd max in period"]
["310","Average over period"]
[]
[null,"   3. Total gross payments sent (volume)",{"$nulls":3}," "]
["320","Max in period"]
["330","2nd max in period"]
["340","3rd max in period"]
["350","Average over period"]
[]
[null,"   4. Total gross payments received (volume)",{"$nulls":3}," "]
["360","Max in period"]
["370","2nd max in period"]
["380","3rd max in period"]
["390","Average over period"]
[]
[null,"   A(iv) Total value of timed obligations"]
["400","Max in period"]
["410","2nd max in period"]
["420","3rd max in period"]
["430","Average over period"]
[null,"Of which (where applicable):"]
[null,"CLS Pay-ins"]
["440","Max in period"]
["450","2nd max in period"]
["460","3rd max in period"]
["470","Average over period"]
[]
[null,"CLS Pay-outs"]
["480","Max in period"]
["490","2nd max in period"]
["500","3rd max in period"]
["510","Average over period"]
[{"$nulls":3}," "]
[null,"Margin calls"]
["520","Max in period"]
["530","2nd max in period"]
["540","3rd max in period"]
["550","Average over period"]
[]
[null,"Other timed payments"]
["560","Max in period"]
["570","2nd max in period"]
["580","3rd max in period"]
["590","Average over period"]
[]
[]
[null,"Securities Settlement "]
[{"$nulls":3},"US Triparty","Clearstream","EuroClear Bank","CREST","Fedwire Securities","Spain","Italy","Germany"]
["600","Direct connectivity"]
["610","Average daily value processed"]
["620","Peak daily value processed"]
["630","Average daily volume processed"]
["640","Peak daily volume processed",{"$nulls":10}," "]
["650","Credit facilities received - secured"]
["660","Peak credit facilities used - unsecured"]
[]
[null,"FOR BANKS THAT PROVIDE CORRESPONDENT BANKING SERVICES:"]
[]
[null,"  A(v) Total gross value of payments made on behalf of correspondent banking customers"]
[{"$nulls":3},"GBP"]
["670","Max in period"]
["680","2nd max in period",{"$nulls":5}," "]
["690","3rd max in period",{"$nulls":3}," "]
["700","Average over period"]
[{"$nulls":5}," "]
[null," A(vi) Total value of intraday credit lines extended to customers"]
["710","Max in period"]
["720","2nd max in period"]
["730","3rd max in period"]
[null,"Of which:"]
[null,"Secured"]
["740","Max in period"]
["750","2nd max in period"]
["760","3rd max in period"]
[null,"Committed"]
["770","Max in period"]
["780","2nd max in period"]
["790","3rd max in period"]
[null,"Peak usage"]
["800","Max in period"]
["810","2nd max in period"]
["820","3rd max in period"]

{"sheet":"Admin","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"hidden":true}
["Version:","v1.02",null,"Rep Currency:","GBP (Pounds Sterling)"]
["Rep Basis:","unconsolidated",null,null,"USD (US Dollars)"]
[null,"liquidity consolidation",null,null,"EUR (Euros)"]
[null,"domestic liquidity sub group",null,null,"CAD (Canadian Dollars)"]
[null,"non domestic liquidity sub group",null,null,"CHF (Swiss Francs)"]
[null,"Prudential Sub-consolidation group",null,null,"JPY (Japanese Yen)"]
[{"$nulls":4},"SEK (Swedish Kroner)"]
[]
["monetary unit:","thousands"]
["handbook reference number:","IDY001"]