## gfsr-data-jan-2021

## Source details

**Canonical URL:** [gfsr-data-jan-2021](https://www.imf.org/-/media/files/publications/gfsr/2021/january/english/gfsr-data-jan-2021.xlsx)

## Other formats

- [Markdown version](/-/media/files/publications/gfsr/2021/january/english/gfsr-data-jan-2021.xlsx.md)
- [Structured JSON version](/-/media/files/publications/gfsr/2021/january/english/gfsr-data-jan-2021.xlsx.json)

---

### Dataset contents (worksheets and focus)
- Worksheet: "GFSR Update Jan. 2021" — metadata rows with timestamps: "2021-01-25T00:00:00.000Z".
- Worksheet: "Table of Contents" — title repeated: "Global Financial Stability Report Update: January 2021"; headline: "Vaccines Inoculate Markets, but Policy Support Is Still Needed".
- Worksheet: "Figure 1" — "Figure 1. Equity Market Performance" with note "(Index; November 6, 2020 = 100)".
- Worksheet: "Figure 2." — "Figure 2. US Earnings Revisions and Rate Expectations" with scales "(US dollar a share, left scale; percent, right scale)" and sample rows including:
  - "Jan. 2020", 193.216, 2.3411
  - 193.002, 2.3609
  - 193.107, 2.3463
  - 192.982, 2.3191
  - 192.906, 2.2437
  - "Feb. 20", 192.59, 2.2852
  - 192.504, 2.2861000000000002
- Worksheet: "Figure 3." — "Figure 3. COVID-19 Infections and Vaccine Preorders" with columns including "Country", "Emerging markets", "Advanced economies" and sample country data:
  - "Vietnam", 0.414670607, 0.0015999999999999999
  - "Venezuela", 0.175341211, 0.4143
  - "Uzbekistan", 0.52113345, 0.23240000000000002
  - "USA", null, null, 1.995494004, 6.9723999999999995
  - "UK", null, null, 2.970027189, 4.7447
  - "Taiwan", 0.838950615, 0.0034999999999999996
- Worksheet: "Figure 4." — "Figure 4. Emerging Market Sovereign Bond Issuance" with unit "(Billions of US dollars; share in percent)" and monthly columns "Jan. 2020" through "Jan. 21". Sample sovereign issuance rows (by rating):
  - "A or above", 8.400360000000001, 1.67352, 0, 23.80475, 5.24684, 2.24741, 0, 4.99067, 0, 6.24132, 0, 0, 4.28701
  - "BBB", 15.350200000000001, 0, 2.5, 17.49434, 3.5939, 10.7885, 5.22463, 0, 7.91545, 0, 15.7830255, 5.7439225, 13.95347
  - "BB", 2.99397, 3.95104, 0, 2.1999400000000002, 4.885700000000001, 4.06979, 0, 0, 4.73772, 2.5877600000000003, 3.4255657999999998, 4.1841873, 6.64978
  - "B", 2.5959, 2.97923, 0, 0, 5, 3.7229099999999997, 3, 0, 2.342938, 2.49735, 2.24127, 1.54927, 6.6655500000000005
  - "Share of HY issuance (3 month moving average, right scale)", 37.16689476343866, 32.99617174895148, 30.956561901799557, 16.721132718053756, 18.672154871953808, 23.934212503467624, 43.27864899890497, 31.702292715495954, 35.732558970470386, 38.85187362470175, 37.328256611134876, 37.252057716856854, 38.32886731998945
- Worksheet: "Figure 5." — "Figure 5. Portfolio Flows to Emerging Markets" with unit "(US billions)"; very large rowCount: 1,038,587 (data volume indicated).
- Worksheet: "Figure 6." — "Figure 6. 2021 Gross External Financing Needs" with unit "(Percent of GDP)" and column headers including "Current account deficit", "Short-term debt (by remaining maturity)", "Total". Sample rows (investment grade countries):
  - "Investment grade", "ROU", 4.504545011350097, 21.058069636472133, 25.56261464782223
  - "Investment grade", "COL", 3.9888714145416975, 10.984789665545069, 14.973661080086767
  - "Investment grade", "THA", -2.257470202383868, 15.091824751969392, 12.834354549585525
  - "Investment grade", "IND", 0.7613816478398874, 10.027472244424441, 10.788853892264328
  - "Investment grade", "PHL", 1.1654842926438682, 6.520415625528055, 7.685899918171923
  - "Investment grade", "IDN", 1.45201957549023, 6.137250084128576, 7.589269659618806
- Worksheet: "Figure 7." — "Figure 7. US High-Yield Spreads" with unit "(Percent)".
- Worksheet: "Figure 8." — "Figure 8. Evolution of Potential \"Fallen Angels\"" with unit "(Count, left scale; US billions, right scale)".
- Worksheet: "Figure 9." — "Figure 9. European Bank Performance Metrics" with unit "(Percent)" and sample rows:
  - Header: "Date", "COE (Cost of equity)", "ROE (Return on equity)"
  - "Feb. 2019", 13.008976193573565, 9.26
  - 13.125254301802098, 9.27
  - 12.943308309603935, 9.07
  - 12.75689191085484, 9.06
  - 13.222790802226719, 9.07
  - 13.31540192540712, 9.04
- Worksheet: "Figure 10." — "Figure 10. Bank Lending Standards, Nonfinancial Firms" with note "(Standard deviations from mean; higher is tighter; Q3 2020)" and sample country values:
  - "POL", 3.18044886449543
  - "PHL", 1.9914533798441625
  - "ESP", 1.3384179786513877
  - "USA", 1.312746698276744
  - "CZE", 1.2378178130484365
  - "EA", 0.6435312411185165
  - "DEU", 0.6340862236144204
- Worksheet: "Figure 11." — "Figure 11. Bank Loan Growth" with unit "(Percent)" and detailed corporate and household growth sample values (QoQ, HoH, Q3, H1) including many explicit numeric entries (examples):
  - Corporate QoQ row includes: 0.9071438318372538, -4.615954407340784, -0.32355120122162795, -1.0087452593173452, 0.41279669762641635, 1.8671249951362823, -5.39640484995676, 2.3157544753168224, -3.0737982396750074, 0.8562780187440389, 0.07043619719835359, -3.5479504189408817, -1.693087458212006, -6.447685002449576, 5.277420163858193, 2.045103873991305, -0.28284750004489156, -0.5228886328913274, -0.2887441545467606, -2.3720365120408538, 7.147609134474142, -0.9730001615560036, -5.585412323145567, 6.078139403715643, 13.348375973615912, 1.5399520130396471
  - Household Q3 row includes: 1.2249893135492629, 2.708337383123083, 1.6131036335549576, -1.4722418533852477, 1.0652443654276977, 1.4576118762421375, 1.1032949910636525, 0.4207261844176857, 2.3157517227246016, 0.24188725387495058, 1.3077013956224626, 1.350390747176844, 0.33657239020683516, 0.5300525828922487, 2.0685375859429644, 2.5547868044282662, 1.5043520493074114, 0.6418409340935849, 0.49200955129715673, -0.3631137411603147, 4.062584395170599, 3.265805513292941, 0.1755581427241415, 5.63800924220661, 13.792459244903776, 4.361117055764607
- Worksheet: "Figure 12." — "Figure 12. Flows into Global Investment Funds" with unit "(Billions of US dollars, cumulative since March 2020)" and sample series by fund type with monthly columns "Mar. 2020" through "Nov. 20":
  - "Money market", 583.960040006, 1035.897050745, 1133.148068361, 1033.58349495, 1093.64174294, 1022.783415732, 907.398599959, 924.724794566, 906.954075249
  - "Fixed income", -481.823439007, -453.834329979, -349.350094027, -218.512692629, -73.671881982, 51.175526725, 111.383717992, 200.212259144, 284.407319321
- Worksheet: "Figure 13." — "Figure 13. Global Sustainable Debt Issuance" with unit "(Billions of US dollars)".
- Worksheet: "Figure 14." — "Figure 14. Market-Implied Probability of Inflation Outcomes" with unit "(Percent, over five years)" and sample probabilities for United States and European Union across dates:
  - United States, "Less than 1%", Jan. 2020: 0.08774046296552761; Oct. 20: 0.18184140927159284; Latest: 0.12836002568646535
  - United States, "Between 1% and 2%", Jan. 2020: 0.5135004429004084; Oct. 20: 0.4127481239054194; Latest: 0.32998212412643113
  - United States, "Greater than 2%", Jan. 2020: 0.39875909413406396; Oct. 20: 0.40541046682298776; Latest: 0.5416578501871034
  - European Union, "Less than 1%", Jan. 2020: 0.46533054531044254; Oct. 20: 0.7161010140538089; Latest: 0.5263334672400446
  - European Union, "Between 1% and 2%", Jan. 2020: 0.48267267215903503; Oct. 20: 0.2545148102369171; Latest: 0.42226671243601493
  - European Union, "Greater than 2%", Jan. 2020: 0.051996782530522354; Oct. 20: 0.02938417570927401; Latest: 0.051399820323940484
- Worksheet: "Figure 15." — "Figure 15. Investor Positioning in Emerging Market Assets" with note "(Reported investment position in excess of average in units of standaed deviation)".
- Worksheet: "Figure 16." — "Figure 16. Financial Conditions Indices" with note "(Standard deviation from mean)" and sample indexed components for United States by quarter:
  - "United States", "Dec", -0.23959035665529405, 0.0192827161861057, -0.5282297251890578, null, -0.748537365658246
  - "United States", "Mar", 0.15816904305908966, 0.008161107396864188, 2.030121468350511, null, 2.196451618806465
  - "United States", "Jun", -0.3296726104763861, -0.08021642458279556, 0.2981168488574927, null, -0.1117721862016889
  - "United States", "Sep", -0.35252825709603636, -0.08086005637868957, 0.030572403650463587, null, -0.4028159098242623
  - "United States", "Dec", -0.32086179319106906, -0.08097656154285537, -0.35379075865721016, null, -0.7556291133911345

### Key sample statistics and data volume notes
- Largest worksheet rowCount observed in sample: "Figure 5." rowCount = 1,038,587 (columnCount = 21) indicating high-frequency or large-panel portfolio flows data.
- Time-stamped metadata example: "2021-01-25T00:00:00.000Z".
- Explicit numeric precision maintained across series (examples include many entries with extended floating-point precision such as 2.2861000000000002 and 37.16689476343866).

### Observations for users (data extraction and interpretation)
- The workbook includes many figure-specific tables (Equity markets, Earnings revisions, COVID-19 infections and vaccine preorders, Sovereign bond issuance by rating, Portfolio flows to emerging markets, Gross external financing needs, Bank metrics, Lending standards, Loan growth, Flows into investment funds, Sustainable debt issuance, Inflation outcome probabilities, Investor positioning, Financial conditions indices).
- Several tables use mixed units and multiple scales (for example, left/right scales, percent of GDP, billions of US dollars, standard deviations from mean). Users should consult corresponding figure captions for correct axis interpretation.
- Nulls appear in place of missing series values (examples: null in country vaccine coverage columns, null in some index component cells).
- Numeric precision and formatting in the dataset are explicit; preserve values exactly when ingesting (examples: negative values like -2.257470202383868; long decimals like 0.5416578501871034).

*International Monetary Fund — dataset file: gfsr-data-jan-2021 (workbook sample rows and structure as provided)*

---


_Source: https://www.imf.org/-/media/files/publications/gfsr/2021/january/english/gfsr-data-jan-2021.xlsx_
