## Dataset overview (ch1data)

## Source details

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

## Other formats

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

---

### Dataset structure and worksheets
- Workbook contains multiple worksheets including: "1.12 panel 1", "1.12 panel 2", "1.12 panel 3", "1.14 panel 2", "1.14 panel 3 ", "1.14 panel 4", "1.17 panel 3", "1.17 panel 4", "1.22 panel 2", "1.23 panel 3", "box 1.2 panel 3", and "box 1.2 panel 4".
- Row and column counts vary across worksheets; examples include:
  - "1.12 panel 1": rowCount 46, columnCount 7.
  - "1.12 panel 2": rowCount 52, columnCount 33.
  - "1.14 panel 4": rowCount 15, columnCount 599.
  - "box 1.2 panel 3": rowCount 75, columnCount 3.

### Hedge fund strategy allocations (1.12 panel 1 sample points)
- Columns: Equity; Event driven; Relative value; Macro; Multistrategy; Other.
- Sample quarterly observations (date in ISO format and strategy weights):
  - "2013-03-29T00:00:00.000Z": Equity 0.843; Event driven 0.128; Relative value 0.111; Macro 0.19; Multistrategy 0.473; Other 0.187.
  - "2013-06-28T00:00:00.000Z": Equity 0.867; Event driven 0.136; Relative value 0.169; Macro 0.197; Multistrategy 0.482; Other 0.192.
  - "2013-09-30T00:00:00.000Z": Equity 0.937; Event driven 0.141; Relative value 0.21; Macro 0.197; Multistrategy 0.509; Other 0.2.
  - "2013-12-31T00:00:00.000Z": Equity 1.071; Event driven 0.151; Relative value 0.236; Macro 0.211; Multistrategy 0.538; Other 0.242.
  - "2014-03-31T00:00:00.000Z": Equity 1.089; Event driven 0.154; Relative value 0.217; Macro 0.261; Multistrategy 0.565; Other 0.227.
  - "2014-06-30T00:00:00.000Z": Equity 1.184; Event driven 0.173; Relative value 0.234; Macro 0.264; Multistrategy 0.593; Other 0.245.
  - "2014-09-30T00:00:00.000Z": Equity 1.131; Event driven 0.176; Relative value 0.264; Macro 0.244; Multistrategy 0.637; Other 0.25.
  - "2014-12-31T00:00:00.000Z": Equity 1.167; Event driven 0.175; Relative value 0.237; Macro 0.239; Multistrategy 0.653; Other 0.252.
  - "2015-03-31T00:00:00.000Z": Equity 1.2; Event driven 0.184; Relative value 0.271; Macro 0.307; Multistrategy 0.663; Other 0.271.
  - "2015-06-30T00:00:00.000Z": Equity 1.213; Event driven 0.191; Relative value 0.252; Macro 0.332; Multistrategy 0.652; Other 0.258.

### Hedge fund strategy risk measures (1.12 panel 2 sample points)
- Columns include: Dates; Relative value ; Macro; CTA; Multistrategy; Equity ; Event-driven ; All five hedge fund strategies (asset-weighted).
- Sample rows:
  - "2014-12-31T00:00:00.000Z": Relative value 15.9; Macro 15.9; CTA 8.6; Multistrategy 5.5; Equity 2.9; Event-driven 2.2; All five hedge fund strategies (asset-weighted) 6.816696349065005.
  - "2015-03-31T00:00:00.000Z": Relative value 15.7; Macro 15.7; CTA 7.8; Multistrategy 5.6; Equity 3.2; Event-driven 2.2; All five hedge fund strategies (asset-weighted) 6.913846838824576.
  - "2015-06-30T00:00:00.000Z": Relative value 13.4; Macro 15.8; CTA 10.2; Multistrategy 7.7; Equity 3.2; Event-driven 2.3; All five hedge fund strategies (asset-weighted) 7.391651825467497.
  - "2015-09-30T00:00:00.000Z": Relative value 15.3; Macro 17.3; CTA 13.5; Multistrategy 7.3; Equity 3.1; Event-driven 2.2; All five hedge fund strategies (asset-weighted) 7.615894924309885.
  - "2015-12-31T00:00:00.000Z": Relative value 15; Macro 13.5; CTA 10.9; Multistrategy 6.1; Equity 3.2; Event-driven 2.1; All five hedge fund strategies (asset-weighted) 6.694657168299198.
  - "2016-03-31T00:00:00.000Z": Relative value 16.1; Macro 14.7; CTA 9.8; Multistrategy 7; Equity 3.4; Event-driven 2.1; All five hedge fund strategies (asset-weighted) 7.340783615316117.
  - "2016-06-30T00:00:00.000Z": Relative value 16.9; Macro 14.6; CTA 7.3; Multistrategy 7.1; Equity 3.2; Event-driven 2.1; All five hedge fund strategies (asset-weighted) 7.364292074799644.
  - "2016-09-30T00:00:00.000Z": Relative value 16.9; Macro 11.2; CTA 8.2; Multistrategy 11; Equity 3.1; Event-driven 2; All five hedge fund strategies (asset-weighted) 8.12172751558326.
  - "2016-12-30T00:00:00.000Z": Relative value 16.4; Macro 13.3; CTA 7.3; Multistrategy 10.1; Equity 3.1; Event-driven 2; All five hedge fund strategies (asset-weighted) 8.070770258236866.
  - "2017-03-31T00:00:00.000Z": Relative value 19.1; Macro 16.4; CTA 8; Multistrategy 8; Equity 3.2; Event-driven 2.2; All five hedge fund strategies (asset-weighted) 8.134750667853963.

### Composition of exposures (1.12 panel 3 sample)
- Percent shares by instrument type (sample):
  - Interest rate derivatives: 42.21655122129056 (Percent).
  - Other derivatives: 42.346752773293055 (Percent).
  - Repurchase agreements: 15.436696005416383 (Percent).

### Public debt or liabilities as Percent of GDP (1.14 panel 2 sample)
- Country-level Percent of GDP values (sample rows):
  - THA: 172.2 (Percent of GDP).
  - MYS: 155.6 (Percent of GDP).
  - CHL: 138.7 (Percent of GDP).
  - IND: 93.6 (Percent of GDP).
  - BRA: 89.7 (Percent of GDP).
  - HUN: 87.6 (Percent of GDP).
  - ZAF: 66.2 (Percent of GDP).
  - POL: 58.5 (Percent of GDP).
  - COL: 55.5 (Percent of GDP).
  - IDN: 39.3 (Percent of GDP).

### Statistical filters and averages for selected countries (1.14 panel 3 sample)
- Columns: Moving Average; HP Filter; Christiano-Fitzgerald Filter ; Average.
- Sample country results (numbers preserved exactly):
  - THA: Moving Average -4.900006103515636; HP Filter -0.3339703698363792; Christiano-Fitzgerald Filter 9.89549593973974; Average 1.5538398221292418.
  - MYS: Moving Average -10.400000000000006; HP Filter -7.759658715223736; Christiano-Fitzgerald Filter -0.274522420110544; Average -6.144727045111428.
  - CHL: Moving Average -10.014996337890636; HP Filter -16.24651150135105; Christiano-Fitzgerald Filter -2.1913250889912383; Average -9.484277642744308.
  - IND: Moving Average 3.0100036621093693; HP Filter -3.0755372704317807; Christiano-Fitzgerald Filter -3.1823143899380217; Average -1.0826159994201443.
  - BRA: Moving Average 4.850001525878909; HP Filter 1.421391995907186; Christiano-Fitzgerald Filter 1.4310351520793558; Average 2.567476224621817.
  - HUN: Moving Average -6.705000305175787; HP Filter -10.745374973604612; Christiano-Fitzgerald Filter -1.117658751704854; Average -6.189344676828418.
  - ZAF: Moving Average -2.639996337890622; HP Filter -5.665818152399311; Christiano-Fitzgerald Filter -2.838507737714587; Average -3.714774076001506.
  - POL: Moving Average -11.269996643066406; HP Filter -20.370659900102027; Christiano-Fitzgerald Filter -9.425686172187714; Average -13.688780905118714.
  - COL: Moving Average -6.845001220703125; HP Filter -9.193049984195156; Christiano-Fitzgerald Filter -2.3166760753756286; Average -6.11824242675797.
  - IDN: Moving Average -2.3450004577636747; HP Filter -1.7486116266424858; Christiano-Fitzgerald Filter -0.036750735441817506; Average -1.3767876066159925.

### Large "1.14 panel 4" table (sample highlights)
- Worksheet has a wide column set (columnCount 599) with mixed country rows and numerous mostly-null cells in the sample.
- Sample rows include per-country metrics; examples:
  - BRA: Change Int Exp/Revenue 0.6603144541907504; Change GFN 1.6868300526628026; GFN to GDP 15.867731883149103; additional many sparse numeric entries including 0.036500223433084025, 0.03919150521241176, 0.04592164361329872, 0.033689042391024396, 0.0378093726657375, 0.04264644180506026, 0.03271586805065952, 0.03705758655046821, 0.03177847524165485, 0.04066732463191099, 0.034472405253327204, 0.028593626703636334, 0.039925268694659684, 0.03182097641967544, 0.031143934368192985, 0.03249801847115897, 0.03276883529175002, 0.03276883529175125, 0.032768835291752035.
  - CHL: Change Int Exp/Revenue 0.9773714099663087; Change GFN -0.13970563385012014; GFN to GDP 4.4765430952752965; additional sparse numeric entries including 0.02727887562453102, 0.04268645598253127, 0.058099033792576193, 0.051274183528150455, 0.07385574710967491, 0.07461463310755158, 0.03547945241796618, 0.013134213898486182, 0.047362399057347675, 0.08020911638804012, 0.042520731143093814, 0.04975383462483526, 0.051509027872409005, 0.032202235701114294, 0.021382501879965203, 0.019491754782302532, 0.030570184335557474, 0.039148926382761705, 0.04030855719581891, 0.03976275754297831, 0.038674426498691995, 0.0386744156044872.
  - COL: Change Int Exp/Revenue 4.006633014169971; Change GFN -0.8077331044231428; GFN to GDP 5.762019256855863.
  - MEX: Change Int Exp/Revenue 2.2783096270107848; Change GFN 2.0677790044084077; GFN to GDP 10.433587101185179.
  - PER: Change Int Exp/Revenue 0.46266608569500356; Change GFN -1.2340257100203238; GFN to GDP 3.266744917335054.
  - THA: Change Int Exp/Revenue 1.5441706043539511; Change GFN 3.8966447848964965; GFN to GDP 8.55305366646167.
  - IND: Change Int Exp/Revenue 1.9230955342773974; Change GFN 7.90786768248385; GFN to GDP 14.6735756402358.
  - IDN: Change Int Exp/Revenue 3.889128986553235; Change GFN 1.4332519505950865; GFN to GDP 5.541726954492193.
  - MYS: Change Int Exp/Revenue 3.5684671945300295; Change GFN 1.3186541326090637; GFN to GDP 8.263562904415847.
  - PHL: Change Int Exp/Revenue 4.641285682064137; Change GFN 3.7542711823036825; GFN to GDP 8.8390915636605.

### Misalignment per risk unit and percentiles (1.22 panel 2 sample)
- Columns include: Misalignment per risk unit; Percentile (right scale).
- Sample rows:
  - US IG, "24Q4": Misalignment per risk unit -5.039399688404444; Percentile (right scale) 5.7.
  - US IG, "25Q1": Misalignment per risk unit -5.120532351383331; Percentile (right scale) 5.4.
  - US IG, "Apr. 25": Misalignment per risk unit -3.9549012426662715; Percentile (right scale) 9.1.
  - US HY, "24Q4": Misalignment per risk unit -5.266465897416572; Percentile (right scale) 4.3.
  - US HY, "25Q1": Misalignment per risk unit -5.391484567817819; Percentile (right scale) 3.9.
  - US HY, "Apr. 25": Misalignment per risk unit -2.524573520936531; Percentile (right scale) 17.5.
  - Euro IG, "24Q4": Misalignment per risk unit -2.9063705933949744; Percentile (right scale) 6.2.
  - Euro IG, "25Q1": Misalignment per risk unit -3.7276055884608854; Percentile (right scale) 2.1999999999999997.
  - Euro IG, "Apr. 25": Misalignment per risk unit -2.1202317615520836; Percentile (right scale) 12.4.
  - Euro HY, "24Q4": Misalignment per risk unit -3.2470637972339222; Percentile (right scale) 3.1.

### Time series of market concentration or share measures (1.23 panel 3 sample)
- Columns: year; Advanced economies; Emerging markets.
- Sample rows (year and values):
  - 2010: Advanced economies 0.24662524761526355; Emerging markets 0.43825664166512207.
  - 2011: Advanced economies 0.2695569929361471; Emerging markets 0.4668832627713186.
  - 2012: Advanced economies 0.25522333939807545; Emerging markets 0.47994306298122313.
  - 2013: Advanced economies 0.24936840045043063; Emerging markets 0.48136579034349053.
  - 2014: Advanced economies 0.23734341053994162; Emerging markets 0.49745936575090843.
  - 2015: Advanced economies 0.2393041353345261; Emerging markets 0.508089405346272.
  - 2016: Advanced economies 0.24082494896679513; Emerging markets 0.47424770572593566.
  - 2017: Advanced economies 0.22541038558227622; Emerging markets 0.46120921518233754.
  - 2018: Advanced economies 0.24001711834929712; Emerging markets 0.45580414558435683.
  - 2019: Advanced economies 0.2343963069888657; Emerging markets 0.4584393866212546.

### Bank solvency and asset composition (box 1.2 samples)
- "box 1.2 panel 3" (Comprehensive solvency ratio; Core solvency ratio) sample quarterly values:
  - "2020-06-30T00:00:00.000Z": Comprehensive solvency ratio 242.6; Core solvency ratio 230.4.
  - "2020-09-30T00:00:00.000Z": Comprehensive solvency ratio 242.5; Core solvency ratio 230.5.
  - "2020-12-31T00:00:00.000Z": Comprehensive solvency ratio 246.3; Core solvency ratio 234.3.
  - "2021-03-31T00:00:00.000Z": Comprehensive solvency ratio 246.3; Core solvency ratio 234.2.
  - "2021-06-30T00:00:00.000Z": Comprehensive solvency ratio 243.7; Core solvency ratio 231.
  - "2021-09-30T00:00:00.000Z": Comprehensive solvency ratio 240; Core solvency ratio 227.3.
  - "2021-12-31T00:00:00.000Z": Comprehensive solvency ratio 232.1; Core solvency ratio 219.7.
  - "2022-03-31T00:00:00.000Z": Comprehensive solvency ratio 224.2; Core solvency ratio 150.
  - "2022-06-30T00:00:00.000Z": Comprehensive solvency ratio 220.8; Core solvency ratio 148.1.
  - "2022-09-30T00:00:00.000Z": Comprehensive solvency ratio 212; Core solvency ratio 139.7.
- "box 1.2 panel 4" (Share of level 3 assets; Share of alternative assets) sample annual values:
  - 2020: Share of level 3 assets 19.44901691826974; Share of alternative assets 21.
  - 2021: Share of level 3 assets 15.3444754159134; Share of alternative assets 20.2.
  - 2022: Share of level 3 assets 10.978000974773124; Share of alternative assets 18.
  - 2023: Share of level 3 assets 11.097931536608542; Share of alternative assets 12.5.

*Dataset: ch1data — canonical URL: https://www.imf.org/-/media/files/publications/gfsr/2025/april/data/ch1data.xlsx*

---


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