Accessibility of Structures, exporting the structure to manipulate the data in XLS
| Average Exchange Rates from Foreign Exchange Swaps on US Dollar Vs Mexican Peso 1/ |
| Maturity at trading date | Last observation | Previous five banking days | End of previous | Same day of the previous year | |||||
| month | year | ||||||||
| 04/18/2024 | 04/17/2024 | 04/16/2024 | 04/15/2024 | 04/12/2024 | 04/11/2024 | 03/27/2024 | 12/29/2023 | 04/18/2023 | |
| From 1 to 7 days | 0.00 | 16.92 | 17.05 | 16.70 | 16.65 | 16.45 | 0.00 | 0.00 | 0.00 |
| From 8 to 30 days | 17.16 | 16.99 | 17.08 | 16.73 | 16.65 | 16.47 | 16.59 | 16.98 | 18.12 |
| From 31 to 60 days | 13.28 | 17.09 | 17.11 | 16.80 | 16.72 | 16.54 | 16.64 | 17.00 | 18.17 |
| From 61 to 90 days | 17.26 | 17.15 | 17.20 | 16.85 | 16.87 | 16.60 | 16.70 | 17.09 | 18.30 |
| From 91 to 120 days | 17.35 | 17.22 | 17.27 | 16.90 | 16.92 | 16.73 | 16.78 | 17.19 | 18.38 |
| From 121 to 150 days | 17.47 | 0.00 | 17.35 | 17.05 | 17.01 | 0.00 | 16.89 | 17.24 | 0.00 |
| From 151 to 180 days | 17.50 | 17.38 | 0.00 | 17.06 | 17.11 | 16.87 | 17.01 | 17.44 | 18.63 |
| From 181 to 210 days | 17.58 | 17.46 | 17.52 | 0.00 | 17.14 | 16.93 | 17.03 | 17.44 | 18.74 |
| From 211 to 240 days | 17.65 | 0.00 | 17.65 | 0.00 | 0.00 | 17.03 | 17.10 | 0.00 | 0.00 |
| From 241 to 270 days | 17.70 | 17.61 | 0.00 | 0.00 | 0.00 | 17.09 | 17.24 | 0.00 | 0.00 |
| From 271 to 300 days | 17.88 | 17.72 | 17.79 | 17.46 | 17.37 | 17.18 | 17.26 | 0.00 | 0.00 |
| From 301 to 330 days | 0.00 | 0.00 | 17.85 | 0.00 | 17.47 | 17.27 | 17.36 | 0.00 | 0.00 |
| From 331 to 360 days | 0.00 | 0.00 | 17.97 | 17.57 | 0.00 | 0.00 | 0.00 | 18.24 | 0.00 |
| From 361 to 731 days | 18.15 | 17.98 | 18.11 | 17.70 | 17.76 | 17.40 | 17.53 | 17.96 | 19.38 |
| From 732 to 1096 days | 0.00 | 18.91 | 18.97 | 0.00 | 18.56 | 0.00 | 0.00 | 18.91 | 20.47 |
| 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 | 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/ The exchange rates are calculated as the average of the contractual rates (weighted by the corresponding notional amount) traded through forward transactions on currencies known as Foreign Exchange Swaps (FX Swaps). 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. According to the international convention used by the Bank for International Settlements (BIS), double-counting on aggregated notional amount is eliminated in OTC transactions by deducting half of the amount reported when both counterparties are domestic banks, brokerage houses and/or regulated multiple-purpose financial institutions (SOFOMES). | |||||||||
| 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). |