- Source workbook: EBA Interactive Dashboard - Q4 2023.xlsm
- List row (Kri Code 25): (12, 12, 1, 25, 'Return on assets', 'PFT_24', 'YES', 'Return on assets', 'Profit or loss for the year', 'Total assets', 0, 0, 'Profitability')
- RI database row (PFT_24): (None, 12, 'PFT_24', 'Return on assets (numerator annualised, denominator as average)(2)', 'Profit or loss for the year (A) / Total assets (B)', 'F 02.00', '0670', '0010', 'F 01.01', '0380', '0010', None, None, None, None, None, None)
- Data headers columns 1-17: ['NRI_FORMATPERIOD', 'PERIOD', 'NRI_CODE', 'NRI_FORMAT', 'p5', 'p25', 'median', 'Average', 'waver', 'p75', 'p95', 'num', 'den', 'waverS', 'waverM', 'waverL', 'Nbanks']
- Charts note size class (row11): [None, '( * ) Not reported. Weighted Averages by country.', None, None, None, None, None, None, None, 'Weighted average. Banks are classified in the size class according to the their average total assets between 2014Q4 and 2023Q4. ', None, None, None, None, None, None, None, None, None, None]
- Series NRI_CODE=25 (Return on assets), medium banks = waverM (column 15), PERIOD and decimal value:
- 201503,0.0018196508064014204
- 201506,-0.0005350220572034896
- 201509,0.0013206296794658905
- 201512,7.271309886680311e-05
- 201603,0.002797542952062069
- 201606,0.0008694203120025138
- 201609,0.0017637744897734749
- 201612,0.0013739005475656581
- 201703,0.00419011062283082
- 201706,0.004721914552329483
- 201709,0.004870908748922609
- 201712,0.004198462032935452
- 201803,0.005028215839099516
- 201806,0.004923152211766777
- 201809,0.005163748350153658
- 201812,0.004624422400817601
- 201903,0.005213283959272843
- 201906,0.005325253484263464
- 201909,0.005419678604438839
- 201912,0.0046659274697860124
- 202003,0.0008410320039418914
- 202006,5.173551095901615e-06
- 202009,0.0014943945628840974
- 202012,0.0014097741844520226
- 202103,0.005582425646350535
- 202106,0.003947033159024708
- 202109,0.004922697886077765
- 202112,0.0052434475132022
- 202203,0.005669534033498438
- 202206,0.007022839608328346
- 202209,0.006807678870644159
- 202212,0.007144812877070134
- 202303,0.009408314723442333
- 202306,0.01025263737255466
- 202309,0.010251408821215918
- 202312,0.009928420224534122