## Dataset overview

## Source details

**Canonical URL:** [Dataset overview](https://www.imf.org/-/media/files/publications/gfsr/2024/april/data/ch1data.xlsx)

## Other formats

- [Markdown version](/-/media/files/publications/gfsr/2024/april/data/ch1data.xlsx.md)
- [Structured JSON version](/-/media/files/publications/gfsr/2024/april/data/ch1data.xlsx.json)

---

### Coverage and structure
- File contains multiple worksheets (examples shown below) with time series and panel data used in Chapter 1 charts and tables.
- Worksheets include dated observations (ISO timestamps like "2021-01-31T00:00:00.000Z", "2024-01-31T00:00:00.000Z", "2011-01-04T00:00:00.000Z", etc.), categorical labels (e.g., "Small", "Medium", "Large nonGSIB", "GSIB"), and numeric series with preserved decimals and signs.
- Numeric fidelity preserved exactly as in source (examples: 4.656506805397176, -73.8, 0.47485588347417096, 968.98, 9.69565).

### Key worksheets (name, variables, and sample values)
- Worksheet "1.6 P3" — Return decomposition variables:
  - Column headers: "Return", "Risk-free rate", "Earnings (current and projected)", "Equity risk premiums" (also short names "return", "Con(r)", "Con(E)", "Con(ERP)").
  - Sample dated rows:
    - "2021-01-31T00:00:00.000Z": 2021, 0, 0, 0, 0
    - "2021-02-28T00:00:00.000Z": return 4.656506805397176, Con(r) -5.316910563441102, Con(E) 8.931268643740452, Con(ERP) 1.0421487250978245
    - "2021-07-31T00:00:00.000Z": "Jul.", return 17.326135172669723, Con(r) -2.3014318803094236, Con(E) 31.545091066839383, Con(ERP) -11.917524013860238

- Worksheet "1.12 P2" — Lending Standards series by CRE segment:
  - Column labels include "Date", "US CRE C&D", "US CRE NonFarm NonResidential", "US CRE Multifamily", "Euro area CRE".
  - Sample rows:
    - "2024-01-31T00:00:00.000Z": -39.7, -42.4, -40.7, -30
    - "2023-10-31T00:00:00.000Z": -64.9, -67.2, -65.5, -30
    - "2022-04-30T00:00:00.000Z": -4.7, 0, 9.2, -13

- Worksheet "1.12 P3" — NPL (rhs) and bank size:
  - Headers include "NPL (rhs)", "Small", "Medium", "Large nonGSIB", "GSIB".
  - Sample rows:
    - "Dec. 2021": 0.47485588347417096, 78.38167136686963
    - "Dec. 2023": 0.46508915970383596, 178.22219450724032
    - Other rows show 0.3200246245645612, 294.03243165512885 and 0.397271448914434, 269.9493640319333

- Worksheet "1.12 P4" — CRE breakdown by borrower size and CRE type:
  - CRE breakdown categories include "Owner Occupied NonFarm Nonresidential", "Other NonFarm Nonresidential", "Construction and Development 1-4 Family Residential", "Construction and Development Other", "Multifamily", "Unsecured CRE".
  - Sample dated rows for "Small":
    - "2022-09-30T00:00:00.000Z": 73.9555649108531, 113.49712821288722, 15.097618898467227, 34.16339335161671, 42.57599418728466, 2.6255503434359775
    - "2023-12-31T00:00:00.000Z": 74.32035796230205, 117.90274302870303, 13.819469544662361, 38.40578642083312, 46.36889576572637, 2.5758349795361575
  - Sample "Medium" row with count and breakdown:
    - "Medium", 44834, 57.11787131192452, 116.05819900185253, 10.387583226619952, 36.10866323039548, 59.22131695151987, 7.0625233524436695

- Worksheet "1.13 P1" — Cross-country house price change metrics:
  - Columns: "Reference area", "Since pre-Pandemic", "Latest (y-o-y)".
  - Sample entries:
    - "United States": 19.61953317562819, 1.0204598367618667
    - "United Arab Emirates": 16.212809106611758, 16.771305315619635
    - "Japan": 14.669998317855093, -1.0238899463688278

- Worksheet "1.13 P2" — Change in reference mortgage rate and real house prices:
  - Columns include "Change in reference mortgage rate - Latest (y-o-y)" and "Change in real house prices - Latest (y-o-y)" and "Bubble size".
  - Sample rows:
    - "Australia": 1.25, 3.6574999999999998, -3.051551090071414, 10.153789464674556, 8.77
    - "Canada": 0.5666666666666664, 1.9575000000000005, -3.5861918391674963, 6.883607238587919, 6.426666666666667

- Worksheet "1.13 P3" — Estimated country-level series (quarter example 2023Q3):
  - Countries include "Australia", "Belgium", "Canada", "Denmark", "Finland", "France", "Germany", "Italy", "Japan", "Netherlands", "Norway", "Portugal", "Spain", "Sweden", "United Kingdom", "United States".
  - "2023Q3" row sample: 19.3, 6.499999999999999, 14.500000000000002, 12.199999999999998, 8.1, 6.2, 5.799999999999999, 4.6, 7.499999999999999, 12.300000000000002, 19.5, 7.200000000000001, 5.6, 13, 8.7, 7.599999999999999

- Worksheet "1.13 P4" — Mortgage origination volume by credit score and house prices (quarterly):
  - Risk-score buckets: "<620", "620-659", "660-719", "720-759", "760+", "Total".
  - Sample quarterly rows:
    - "03:Q1": 72.19, 68.12, 188.33, 336.1, 304.24, 968.98, House prices 9.69565
    - "04:Q2": 87.96, 69.76, 169.62, 216.33, 167.23, 710.9000000000001, House prices 12.48776

- Worksheet "1.14 P3" — Positive/Negative metrics (period comparisons):
  - Sample values:
    - "Latest": Positive 0.58, Negative -1.23
    - Row with formula result: "Latest" formula "0.0002092*100" yields 0.020919999999999998, paired value 0.0189

- Worksheet "1.15 P3" — Daily dates and two numeric series:
  - Large rowCount (3,470) of daily observations beginning "2011-01-04T00:00:00.000Z".
  - Sample rows:
    - "2011-01-04T00:00:00.000Z": 0.5587956049815843, 0.4096506249903701
    - "2011-01-07T00:00:00.000Z": 0.5561331504407554, 0.4064294387250567

- Worksheet "1.15 P4" — Futures and cash securities turnover (quarterly):
  - Sample dated rows:
    - "2014-12-31T00:00:00.000Z": Futures Turnover 3.3371546149323925, Cash Securities Turnover 1.1631393298059964
    - "2015-06-30T00:00:00.000Z": 3.406015037593985, 1.366193260930103

- Worksheet "1.16 P4" — Asset returns for EM and China (monthly):
  - Columns include "Equities, EM ex. China", "Equities, China", "Local currency bonds, EM. ex. China", "Local currency bonds, China".
  - Sample monthly rows:
    - "2023-01-31T00:00:00.000Z": -1.8853989999999992, 20.87552794340181, 15.660385020411148, -13.055440506478872
    - "2023-08-31T00:00:00.000Z": -6.37553, -12.333412762747011, -0.803653751022935, -5.958697135536318

- Worksheet "1.17 P1" — Asset distribution summary (weekly dates, nominal and real stats):
  - Columns include "median", "75th", "25th", "IQR" and corresponding real metrics with preserved decimals.
  - Sample weekly rows with date and nominal median:
    - "2013-01-27T00:00:00.000Z": 5.200375, 5.993375, 4.4319999999999995, 1.5613750000000008
    - "2013-02-10T00:00:00.000Z": nominal median 5.16155 and real median 0.9437529371361846

- Worksheet "1.17 P3" — Changes in risk-neutral expected short term rates and term premiums since COVID-19 for EM countries:
  - Sample row "Change in risk-neutral expected short term rates since COVID-19":
    - COL 174.18796684377415, BRA 422.4226159809487, POL 111.35313485234857, PER 32.35020204374823, ZAF 97.12743178889589, CHL 70.90653933821241
  - Sample row "Total":
    - COL 346.76012675540915, BRA 315.39900391993433, POL 296.7642934857902, PER 253.45843846274806, ZAF 261.1151689631626

- Worksheet "1.17 P5" — Monthly fund flow components (averages):
  - Columns include "Total net" and "Other (residual)" with exact decimals.
  - Sample rows:
    - "2013-01-31T00:00:00.000Z": 0.001056698847460533, 0.02657972091801672, 0.006482519103143826, 0.027681760051752307, -0.006349120579580397
    - "2013-08-31T00:00:00.000Z": 0.002687534614546737, 0.014665733836570405, 0.006909907853871022, 0.02398704882627313, -0.0002761274787150345

- Worksheet "1.19 P1" and "1.19 P2" — Quarterly issuance and regional breakdown:
  - "1.19 P1" issuance samples:
    - "2019Q1": 10.86097329, "2019Q2": 7.4129647, "2020Q4": 2.6302841139999997
    - "2021Q1": 7.311054449999999
  - "1.19 P2" regional flags/numeric indicators by quarter:
    - "2019Q2": LatAm 0.0887153, Africa 0.75, Asia 1.5, Europe 0
    - "2020Q1": LatAm 0.32463, Asia 0.745451, Europe 0.0666667

- Worksheet "1.19 P3" — Model parameter arrays and year/age axes:
  - Numeric arrays with high precision (examples include 0.08367963742198231, 0.32653, 0.027323912007399885) and year vector 2011–2022.

- Worksheet "1.20 P1" to "1.20 P4" — Housing series, financing flows, presale revenues, and scenario projections:
  - "1.20 P1" example series for China/new home and 70-city averages with quarterly timestamps (e.g., "2001-03-31T00:00:00.000Z": 73.58294847855042, 80.81218834619021).
  - "1.20 P2" financing component examples:
    - "Change in bank lending": 1149, 1878, 1030, 690, 100, 680, 190 (multiple columns)
    - "Presale revenues" right-scale examples: 9115.12608, 11105.17043, 12529.58395, 13971.334420000001
  - "1.20 P3" scenario projection table by year for H/M/L risk:
    - 2024: H 152.65897589626363, M 858.0601551824017, L 1933.5411877079982
    - "2030+": H 15.219880219942, M 73.49791432180011, L 187.8026354582578
  - "1.20 P4" leverage buckets with bracket labels and precise percentages (examples include 30.953831740185038, 33.02177849044264, 7.5463314785793285)

- Worksheet "1.22 P1" and "1.22 P2" — Asset manager allocations and short-term rates:
  - "1.22 P1" asset mix examples:
    - "Total assets" values: 29, 25.56, 22.19, 22.64, 6.49
    - Fixed income shares and credit bond share: 47.7, 59.83083959184817, "Credit bond share in fixed income" 91.88679245283018
  - "1.22 P2" short-term rates table samples:
    - Example 2-year swap rate 3.31, 2-year corporate bond yield 3.6083 with a "Share of fixed income funds with NAV < 1 (right)" entry sometimes "#N/A" and some numeric 7.060185185185184 for "Dec-16"

- Worksheet "1.24 P1" — Share statistics by size and region (AE/EM), sampled points:
  - "Small" 1Q21 AE 0.21791735291481018, EM 0.5313657522201538
  - "Small" 3Q23 AE 0.3388451039791107, EM 0.5656180381774902

- Worksheet "1.26 P1" — Holdings by sector (quarterly, USD or units preserved as integers/negatives):
  - Sample quarter rows:
    - "2022-Q3": Federal Reserve -116890, Banks -38510, MMF & Other Asset Managers -179943, Insurance 19578, Foreigners 418056
    - "2023-Q4": Federal Reserve -172625, Banks 57161, MMF & Other Asset Managers 517185, Foreigners -27439

- Worksheet "1.29. P2" — Bank count and cross-region metrics (quarterly):
  - Sample dated row "2018-03-31T00:00:00.000Z": China 1.0239085688835161, Euro area 5.752054161082681, Emerging markets 0.2701048550000533, Other advanced economies 7.060516381382972, United States 1.5913103485, Total number of banks 41
  - Later rows include larger samples (e.g., "2020-03-31T00:00:00.000Z": China 1.7856730390827966, Euro area 10.067805607991641, Total number of banks 169)

- Worksheet "1.30 P2" to "1.30 P4" — Exchange rate indices, aggregated series, and CDS aggregation steps:
  - "1.30 P2" AE and EM (excl. China) quarterly series with many quarters (examples: "2004Q1" AE 0.2935888279837574, "2021Q4" AE 0.15892874059492879).
  - "1.30 P3" and "1.30 P4" show "Step" sequences with "avgcCDSm : avgcCDSm" and values across episodes:
    - Step 0 pre-GFC 10.010820373988196, Step 8 pre-GFC 11.989670716131329
    - "1.30 P4" includes an additional column with values like 1.691102 at step 0

- Worksheet "1.1.1 P3" and "1.2.1 P1/P2" — Asset weight tables and tightening episode statistics:
  - "1.1.1 P3" asset weight samples across years 2011–2023 for instruments like "Bitcoin", "Gold", "SPX", "IG", "Treasury", "HY" (e.g., "Bitcoin" 2011 0.23018, 2012 0.05375, 2013 0.59375).
  - "1.2.1 P1" / "1.2.1 P2" tightening episode average quarterly growth and durations:
    - Example "1965Q3" to "1966Q4": Household credit 1.8765255120256024, Corporate credit 2.5198427425336316
    - "1965Q3" row in P2: Household credit -0.10505085601517639, Corporate credit 1.6362315629461222, Duration between cycles 4

### Data characteristics and notable numeric details
- Time-stamped series use ISO 8601 format (e.g., "2023-12-31T00:00:00.000Z").
- Negative and positive values retained exactly (examples: -73.8, -11.917524013860238, -13.055440506478872).
- High precision decimals preserved (examples: 0.5561331504407554, 0.020919999999999998).
- Some cells contain formulas or formula results preserved (example: formula "0.0002092*100" with result 0.020919999999999998; formula "C2+1" with result 2012).
- Occasional non-numeric entries and errors present in samples (examples: "<-- Interest rate increase (constant credit)", "<-- Interest rate increase (lower credit)", { "error": "#N/A" }).

_This overview reflects the worksheet names, column labels, timestamps, and numeric samples exactly as presented in the dataset._

---


_Source: https://www.imf.org/-/media/files/publications/gfsr/2024/april/data/ch1data.xlsx_