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