Accessibility of Structures, exporting the structure to manipulate the data in XLS
| Turnover in Forwards on US Dollar Vs Mexican Peso related to FX Swaps (Millions of US Dollar) 1/ |
| Maturity at trading date | Last observation | Previous five banking days | End of previous | Same day of the previous year | |||||
| month | year | ||||||||
| 09/25/2023 | 09/22/2023 | 09/21/2023 | 09/20/2023 | 09/19/2023 | 09/18/2023 | 08/31/2023 | 12/30/2022 | 09/23/2022 | |
| From 1 to 7 days | 2.08 | 0.00 | 0.00 | 141.06 | 0.00 | 400.10 | 950.00 | 0.00 | 6.45 |
| From 8 to 30 days | 472.89 | 113.81 | 638.31 | 145.62 | 528.88 | 415.10 | 750.89 | 0.00 | 747.92 |
| From 31 to 60 days | 776.16 | 180.67 | 572.05 | 510.27 | 407.82 | 648.08 | 134.80 | 104.04 | 148.76 |
| From 61 to 90 days | 237.71 | 353.60 | 410.58 | 2.68 | 11.03 | 151.31 | 217.00 | 1.10 | 332.19 |
| From 91 to 120 days | 475.38 | 435.00 | 365.70 | 45.01 | 486.23 | 182.24 | 235.42 | 0.00 | 113.19 |
| From 121 to 150 days | 0.00 | 108.37 | 0.00 | 0.00 | 234.05 | 0.78 | 0.00 | 0.00 | 30.00 |
| From 151 to 180 days | 25.00 | 185.00 | 100.63 | 0.00 | 0.00 | 0.46 | 0.10 | 0.00 | 0.46 |
| From 181 to 210 days | 325.00 | 167.28 | 50.00 | 139.00 | 50.25 | 20.00 | 105.00 | 0.00 | 40.00 |
| From 211 to 240 days | 0.00 | 0.00 | 0.00 | 0.30 | 0.00 | 75.00 | 25.50 | 0.00 | 0.00 |
| From 241 to 270 days | 0.00 | 0.00 | 0.00 | 0.25 | 0.45 | 100.00 | 0.00 | 0.00 | 0.00 |
| From 271 to 300 days | 10.00 | 196.00 | 40.00 | 30.00 | 0.25 | 0.00 | 56.99 | 0.00 | 0.00 |
| From 301 to 330 days | 0.00 | 0.00 | 100.00 | 0.30 | 0.40 | 0.00 | 0.00 | 0.00 | 0.00 |
| From 331 to 360 days | 0.00 | 0.00 | 100.00 | 0.30 | 0.25 | 12.00 | 0.00 | 0.00 | 1.00 |
| From 361 to 731 days | 97.50 | 213.50 | 25.18 | 105.70 | 114.73 | 108.17 | 65.00 | 0.00 | 15.00 |
| From 732 to 1096 days | 0.00 | 0.00 | 20.00 | 5.00 | 44.50 | 0.00 | 0.00 | 0.00 | 5.00 |
| From 1097 to 1461 days | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| From 1462 to 1827 days | 0.00 | 0.00 | 0.00 | 8.50 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| From 1828 to 2557 days | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| From 2558 to 3653 days | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| From 3654 to 5479 days | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| From 5480 to 7305 days | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Over 7,306 days | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 1/ According to the international convention used by the Bank for International Settlements (BIS), double-counting on turnover is eliminated in Foreign Exchange (FX) Swaps by deducting half of the notional amount reported when both counterparties are domestic banks, brokerage houses and/or regulated multiple-purpose financial institutions (SOFOMES). FX Swaps are single transactions (anyone of the following pair: spot/forward or forward/forward) involving the actual exchange of two currencies on a specific date at a rate agreed at the trade date of the contract and a reverse exchange of the same two currencies at a date further in the future at a rate agreed on such trade date. | |||||||||
| Source: Information requested directly by Banco de Mexico to domestic banking institutions, brokerage houses and regulated multiple-purpose financial institutions (from the last instutions, data is available since 01/08/2017). |