Accessibility of Structures, exporting the structure to manipulate the data in XLS
| Turnover in Forwards on US Dollar Vs Mexican Peso different from 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 | ||||||||
| 04/23/2024 | 04/22/2024 | 04/19/2024 | 04/18/2024 | 04/17/2024 | 04/16/2024 | 03/27/2024 | 12/29/2023 | 04/21/2023 | |
| From 1 to 7 days | 15.67 | 2.00 | 7.50 | 12.14 | 1.09 | 4.23 | 0.00 | 0.63 | 201.37 |
| From 8 to 30 days | 154.23 | 1,324.01 | 114.15 | 89.07 | 53.41 | 1,218.17 | 253.88 | 61.87 | 17.28 |
| From 31 to 60 days | 77.35 | 64.96 | 108.49 | 80.43 | 79.62 | 79.87 | 354.60 | 80.47 | 474.40 |
| From 61 to 90 days | 17.21 | 14.98 | 77.41 | 52.27 | 60.63 | 486.02 | 144.20 | 73.81 | 19.42 |
| From 91 to 120 days | 14.95 | 4.65 | 34.13 | 41.15 | 93.87 | 24.16 | 369.60 | 8.55 | 21.37 |
| From 121 to 150 days | 2.14 | 1.61 | 16.70 | 12.66 | 7.79 | 43.52 | 25.88 | 11.89 | 5.73 |
| From 151 to 180 days | 5.83 | 46.41 | 35.49 | 259.75 | 32.73 | 9.83 | 19.75 | 47.32 | 2.24 |
| From 181 to 210 days | 5.21 | 2.83 | 25.10 | 10.39 | 318.65 | 21.65 | 25.71 | 11.38 | 15.26 |
| From 211 to 240 days | 0.20 | 0.10 | 26.82 | 9.94 | 9.77 | 19.00 | 28.82 | 6.91 | 84.10 |
| From 241 to 270 days | 2.53 | 0.14 | 11.10 | 259.01 | 4.10 | 65.09 | 32.74 | 14.17 | 25.50 |
| From 271 to 300 days | 7.89 | 0.14 | 7.85 | 1.46 | 0.78 | 2.68 | 24.58 | 7.28 | 33.60 |
| From 301 to 330 days | 0.56 | 0.60 | 9.75 | 17.82 | 18.94 | 1.97 | 16.13 | 4.37 | 24.83 |
| From 331 to 360 days | 0.00 | 0.00 | 3.76 | 19.87 | 0.89 | 7.61 | 47.78 | 13.15 | 13.13 |
| From 361 to 731 days | 1.30 | 0.00 | 19.21 | 31.25 | 10.47 | 9.90 | 32.13 | 12.30 | 1.05 |
| From 732 to 1096 days | 4.00 | 0.00 | 2.13 | 12.00 | 1.19 | 0.00 | 0.00 | 0.00 | 0.00 |
| From 1097 to 1461 days | 0.00 | 0.00 | 0.33 | 0.00 | 99.49 | 0.00 | 0.00 | 0.00 | 0.00 |
| From 1462 to 1827 days | 0.00 | 0.00 | 0.00 | 0.00 | 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 forward transactions (different from 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). Foreign Exchange (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). |