TriangularArbitrageHistoricalExchange.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Triangular Arbitrage Calculation Based on Historical Exchange Rates\n",
    "\n",
    "### Overview:\n",
    "\n",
    "Triangular arbitrage involves exploiting discrepancies between three related currency pairs. In this case, we focus on the pairs **EUR/USD**, **USD/JPY**, and **EUR/JPY**. The goal is to identify situations where the calculated cross rate for **EUR/JPY** (derived from **EUR/USD** and **USD/JPY**) differs from the actual **EUR/JPY** market rate, potentially indicating an arbitrage opportunity.\n",
    "\n",
    "### Formula for Calculating Cross Rate:\n",
    "\n",
    "To calculate the cross rate for **EUR/JPY**, we multiply the exchange rates of **EUR/USD** and **USD/JPY**:\n",
    "\n",
    "$$\n",
    "\\text{Calculated\\_EURJPY} = \\text{EUR/USD} \\times \\text{USD/JPY}\n",
    "$$\n",
    "\n",
    "Where:\n",
    "- **EUR/USD** is the exchange rate for euros to US dollars.\n",
    "- **USD/JPY** is the exchange rate for US dollars to Japanese yen.\n",
    "- **Calculated\\_EURJPY** represents the theoretical cross rate for **EUR/JPY** based on the two other rates.\n",
    "\n",
    "### Arbitrage Detection:\n",
    "\n",
    "Once we have the **calculated EUR/JPY** value, we compare it to the actual **EUR/JPY** exchange rate:\n",
    "\n",
    "$$\n",
    "\\text{Arbitrage\\_Opportunity} = \\text{YES} \\quad \\text{if} \\quad \\left| \\text{Calculated\\_EURJPY} - \\text{Actual\\_EURJPY} \\right| > 0.01\n",
    "$$\n",
    "\n",
    "Where:\n",
    "- **Calculated\\_EURJPY** is the cross rate derived from **EUR/USD** and **USD/JPY**.\n",
    "- **Actual\\_EURJPY** is the observed market exchange rate for **EUR/JPY**.\n",
    "- If the absolute difference between the **calculated** and **actual** EUR/JPY rates is greater than 0.01, it is flagged as an arbitrage opportunity.\n",
    "\n",
    "### Data Collection:\n",
    "\n",
    "We fetch historical exchange rates for the following currency pairs:\n",
    "1. **EUR/USD**\n",
    "2. **USD/JPY**\n",
    "3. **EUR/JPY**\n",
    "\n",
    "These rates are collected over a period of one year. The historical data is used to identify potential arbitrage opportunities for each day in the past year.\n",
    "\n",
    "### Example:\n",
    "\n",
    "Let’s assume we have the following rates for a specific date:\n",
    "- **EUR/USD = 1.12**\n",
    "- **USD/JPY = 110.50**\n",
    "- **Actual EUR/JPY = 123.62**\n",
    "\n",
    "We calculate the **EUR/JPY cross rate** as follows:\n",
    "\n",
    "$$\n",
    "\\text{Calculated\\_EURJPY} = 1.12 \\times 110.50 = 123.76\n",
    "$$\n",
    "\n",
    "The actual EUR/JPY rate is **123.62**, so we compute the difference:\n",
    "\n",
    "$$\n",
    "\\left| 123.76 - 123.62 \\right| = 0.14\n",
    "$$\n",
    "\n",
    "Since the difference is greater than **0.01**, this would be flagged as an **arbitrage opportunity**.\n",
    "\n",
    "                    ---------------------------------------------------------\n",
    "\n",
    "\n",
    "### Okay!! Lets analyse the historical exchange rates to find arbitrage opportunites appeared in the past.\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Fetching historical data...\n",
      "Joining historical data...\n",
      "Joined Data (first few rows):\n",
      "                           EURUSD=X    USDJPY=X    EURJPY=X\n",
      "Date                                                       \n",
      "2023-10-10 00:00:00+01:00  1.057888  148.326996  156.909149\n",
      "2023-10-11 00:00:00+01:00  1.060479  148.628006  157.598999\n",
      "2023-10-12 00:00:00+01:00  1.062428  149.035995  158.328995\n",
      "2023-10-13 00:00:00+01:00  1.053674  149.789993  157.811996\n",
      "2023-10-16 00:00:00+01:00  1.052155  149.565994  157.354996\n",
      "Detecting arbitrage opportunities...\n",
      "Saving opportunities as a DataFrame...\n",
      "Detected Arbitrage Opportunities:\n",
      "           Date  Calculated_EURJPY  Actual_EURJPY Opportunity\n",
      "0    2023-10-10         156.913283     156.909149          NO\n",
      "1    2023-10-11         157.616904     157.598999         YES\n",
      "2    2023-10-12         158.340050     158.328995         YES\n",
      "3    2023-10-13         157.829837     157.811996         YES\n",
      "4    2023-10-16         157.366665     157.354996         YES\n",
      "5    2023-10-17         157.869298     157.863007          NO\n",
      "6    2023-10-18         158.341082     158.309998         YES\n",
      "7    2023-10-19         157.805887     157.789001         YES\n",
      "8    2023-10-20         158.587767     158.548004         YES\n",
      "9    2023-10-23         158.722427     158.712006         YES\n",
      "10   2023-10-24         159.801329     159.789993         YES\n",
      "11   2023-10-25         158.775602     158.764008         YES\n",
      "12   2023-10-26         158.612320     158.598999         YES\n",
      "13   2023-10-27         158.853550     158.841995         YES\n",
      "14   2023-10-30         158.154748     158.145996          NO\n",
      "15   2023-10-31         158.281845     158.261993         YES\n",
      "16   2023-11-01         160.055437     160.057999          NO\n",
      "17   2023-11-02         159.414534     159.410004          NO\n",
      "18   2023-11-03         159.814160     159.753998         YES\n",
      "19   2023-11-06         160.390880     160.382004          NO\n",
      "20   2023-11-07         160.811615     160.755005         YES\n",
      "21   2023-11-08         160.865097     160.852005         YES\n",
      "22   2023-11-09         161.581724     161.567993         YES\n",
      "23   2023-11-10         161.452707     161.432007         YES\n",
      "24   2023-11-13         161.922721     161.910995         YES\n",
      "25   2023-11-14         162.288901     162.270004         YES\n",
      "26   2023-11-15         163.702324     163.688995         YES\n",
      "27   2023-11-16         164.137552     164.130005          NO\n",
      "28   2023-11-17         163.571542     163.556000         YES\n",
      "29   2023-11-20         163.542157     163.533997          NO\n",
      "30   2023-11-21         162.396279     162.378998         YES\n",
      "31   2023-11-22         161.755645     161.735992         YES\n",
      "32   2023-11-23         162.775005     162.729996         YES\n",
      "33   2023-11-24         163.196636     163.160004         YES\n",
      "34   2023-11-27         163.637250     163.628006          NO\n",
      "35   2023-11-28         162.679986     162.639999         YES\n",
      "36   2023-11-29         161.856718     161.815994         YES\n",
      "37   2023-11-30         161.356123     161.343002         YES\n",
      "38   2023-12-01         161.201388     161.192993          NO\n",
      "39   2023-12-04         159.394844     159.386993          NO\n",
      "40   2023-12-05         159.669444     159.662994          NO\n",
      "41   2023-12-06         158.866442     158.854996         YES\n",
      "42   2023-12-07         158.468558     158.451004         YES\n",
      "43   2023-12-08         155.706886     155.669006         YES\n",
      "44   2023-12-11         156.085358     156.076004          NO\n",
      "45   2023-12-12         157.283593     157.257004         YES\n",
      "46   2023-12-13         156.883077     156.867996         YES\n",
      "47   2023-12-14         155.424543     155.380005         YES\n",
      "48   2023-12-15         156.415881     156.408005          NO\n",
      "49   2023-12-18         155.053777     155.050995          NO\n",
      "50   2023-12-19         155.907056     155.893005         YES\n",
      "51   2023-12-20         158.005181     157.996994          NO\n",
      "52   2023-12-21         157.096090     157.016998         YES\n",
      "53   2023-12-22         156.364893     156.307007         YES\n",
      "54   2023-12-25         156.954460     156.789993         YES\n",
      "55   2023-12-26         156.741083     156.712006         YES\n",
      "56   2023-12-27         157.319854     157.294998         YES\n",
      "57   2023-12-28         157.075101     157.063004         YES\n",
      "58   2023-12-29         156.537425     156.526993         YES\n",
      "59   2024-01-01         155.834157     155.899338         YES\n",
      "60   2024-01-02         155.785410     155.764999         YES\n",
      "61   2024-01-03         155.542545     155.535995          NO\n",
      "62   2024-01-04         156.265978     156.227997         YES\n",
      "63   2024-01-05         158.479850     158.468002         YES\n",
      "64   2024-01-08         158.351669     158.339996         YES\n",
      "65   2024-01-09         157.956402     157.934006         YES\n",
      "66   2024-01-10         157.894842     157.886002          NO\n",
      "67   2024-01-11         159.945120     159.938995          NO\n",
      "68   2024-01-12         159.284434     159.268005         YES\n",
      "69   2024-01-15         158.875870     158.863998         YES\n",
      "70   2024-01-16         159.581873     159.563004         YES\n",
      "71   2024-01-17         160.185825     160.179993          NO\n",
      "72   2024-01-18         161.237919     161.223007         YES\n",
      "73   2024-01-19         161.150583     161.126999         YES\n",
      "74   2024-01-22         161.337795     161.339996          NO\n",
      "75   2024-01-23         161.181593     161.136993         YES\n",
      "76   2024-01-24         160.969184     160.949005         YES\n",
      "77   2024-01-25         160.604814     160.589996         YES\n",
      "78   2024-01-26         160.235831     160.218994         YES\n",
      "79   2024-01-29         160.635872     160.617004         YES\n",
      "80   2024-01-30         159.773779     159.755997         YES\n",
      "81   2024-01-31         159.798102     159.781006         YES\n",
      "82   2024-02-01         158.813305     158.783005         YES\n",
      "83   2024-02-02         159.260313     159.248993         YES\n",
      "84   2024-02-05         160.084733     160.080994          NO\n",
      "85   2024-02-06         159.666576     159.651993         YES\n",
      "86   2024-02-07         159.010765     158.990997         YES\n",
      "87   2024-02-08         159.573712     159.572433          NO\n",
      "88   2024-02-09         160.860238     160.845993         YES\n",
      "89   2024-02-12         161.073559     161.067993          NO\n",
      "90   2024-02-13         160.943009     160.910004         YES\n",
      "91   2024-02-14         161.409301     161.389999         YES\n",
      "92   2024-02-15         161.566051     161.559967          NO\n",
      "93   2024-02-16         161.550135     161.533997         YES\n",
      "94   2024-02-19         161.872061     161.867004          NO\n",
      "95   2024-02-20         161.921893     161.893005         YES\n",
      "96   2024-02-21         162.131273     162.110992         YES\n",
      "97   2024-02-22         162.690166     162.684006          NO\n",
      "98   2024-02-23         162.908000     162.897995         YES\n",
      "99   2024-02-26         162.839611     162.830994          NO\n",
      "100  2024-02-27         163.378110     163.350998         YES\n",
      "101  2024-02-28         163.208981     163.147003         YES\n",
      "102  2024-02-29         163.293275     163.246002         YES\n",
      "103  2024-03-01         162.177203     162.167007         YES\n",
      "104  2024-03-04         162.754254     162.746994          NO\n",
      "105  2024-03-05         163.333412     163.319000         YES\n",
      "106  2024-03-06         162.893121     162.871994         YES\n",
      "107  2024-03-07         162.696326     162.684006         YES\n",
      "108  2024-03-08         161.917593     161.908005          NO\n",
      "109  2024-03-11         160.614130     160.608994          NO\n",
      "110  2024-03-12         160.397896     160.389008          NO\n",
      "111  2024-03-13         161.314618     161.291000         YES\n",
      "112  2024-03-14         161.723277     161.686996         YES\n",
      "113  2024-03-15         161.396569     161.376999         YES\n",
      "114  2024-03-18         162.101423     162.097000          NO\n",
      "115  2024-03-19         162.178270     162.173004          NO\n",
      "116  2024-03-20         164.073954     164.054993         YES\n",
      "117  2024-03-21         164.889377     164.878998         YES\n",
      "118  2024-03-22         164.709255     164.703003          NO\n",
      "119  2024-03-25         163.523464     163.520996          NO\n",
      "120  2024-03-26         164.061517     164.048004         YES\n",
      "121  2024-03-27         164.142729     164.039993         YES\n",
      "122  2024-03-28         163.592428     163.529007         YES\n",
      "123  2024-03-29         163.471497     163.410004         YES\n",
      "124  2024-04-01         163.399712     163.393997          NO\n",
      "125  2024-04-02         162.755812     162.751007          NO\n",
      "126  2024-04-03         163.186627     163.179001          NO\n",
      "127  2024-04-04         164.288733     164.276993         YES\n",
      "128  2024-04-05         163.955969     163.945007         YES\n",
      "129  2024-04-08         164.287570     164.283005          NO\n",
      "130  2024-04-09         164.957102     164.921997         YES\n",
      "131  2024-04-10         164.819134     164.802002         YES\n",
      "132  2024-04-11         164.309581     164.292007         YES\n",
      "133  2024-04-12         164.326781     164.317001          NO\n",
      "134  2024-04-15         163.240689     163.210007         YES\n",
      "135  2024-04-16         163.855431     163.830002         YES\n",
      "136  2024-04-17         164.311889     164.296005         YES\n",
      "137  2024-04-18         164.673622     164.662003         YES\n",
      "138  2024-04-19         164.569753     164.559006         YES\n",
      "139  2024-04-22         164.819230     164.809998          NO\n",
      "140  2024-04-23         164.938587     164.925003         YES\n",
      "141  2024-04-24         165.643331     165.613007         YES\n",
      "142  2024-04-25         166.125253     166.115997          NO\n",
      "143  2024-04-26         166.949583     166.908005         YES\n",
      "144  2024-04-29         169.408331     169.399994          NO\n",
      "145  2024-04-30         167.501413     167.395996         YES\n",
      "146  2024-05-01         168.235004     168.214996         YES\n",
      "147  2024-05-02         166.938983     166.880005         YES\n",
      "148  2024-05-03         164.264255     164.216003         YES\n",
      "149  2024-05-06         165.208210     165.201004          NO\n",
      "150  2024-05-07         166.074806     166.078003          NO\n",
      "151  2024-05-08         166.361709     166.356995          NO\n",
      "152  2024-05-09         167.027416     166.998993         YES\n",
      "153  2024-05-10         167.589513     167.533997         YES\n",
      "154  2024-05-13         167.822316     167.817001          NO\n",
      "155  2024-05-14         168.630741     168.589996         YES\n",
      "156  2024-05-15         169.245582     169.240997          NO\n",
      "157  2024-05-16         168.010096     168.001999          NO\n",
      "158  2024-05-17         168.862687     168.854004          NO\n",
      "159  2024-05-20         169.389877     169.345001         YES\n",
      "160  2024-05-21         169.830783     169.822006          NO\n",
      "161  2024-05-22         169.613132     169.606995          NO\n",
      "162  2024-05-23         169.635284     169.632004          NO\n",
      "163  2024-05-24         169.729920     169.714005         YES\n",
      "164  2024-05-27         170.166830     170.160995          NO\n",
      "165  2024-05-28         170.363339     170.347000         YES\n",
      "166  2024-05-29         170.658702     170.654007          NO\n",
      "167  2024-05-30         170.245320     170.216003         YES\n",
      "168  2024-05-31         170.065019     169.996002         YES\n",
      "169  2024-06-03         170.588228     170.580002          NO\n",
      "170  2024-06-04         170.238112     170.227997         YES\n",
      "171  2024-06-05         168.803854     168.796005          NO\n",
      "172  2024-06-06         169.565461     169.556000          NO\n",
      "173  2024-06-07         169.623046     169.574997         YES\n",
      "174  2024-06-10         169.048440     169.039993          NO\n",
      "175  2024-06-11         169.041974     169.020004         YES\n",
      "176  2024-06-12         168.735953     168.720993         YES\n",
      "177  2024-06-13         169.550183     169.520004         YES\n",
      "178  2024-06-14         168.737122     168.725998         YES\n",
      "179  2024-06-17         168.608396     168.604004          NO\n",
      "180  2024-06-18         169.380475     169.369003         YES\n",
      "181  2024-06-19         169.589647     169.494003         YES\n",
      "182  2024-06-20         169.829046     169.763000         YES\n",
      "183  2024-06-21         170.158032     170.151001          NO\n",
      "184  2024-06-24         170.855556     170.850006          NO\n",
      "185  2024-06-25         171.386573     171.375000         YES\n",
      "186  2024-06-26         171.017635     171.009995          NO\n",
      "187  2024-06-27         171.544985     171.535004          NO\n",
      "188  2024-06-28         172.071232     172.065002          NO\n",
      "189  2024-07-01         172.737811     172.729996          NO\n",
      "190  2024-07-02         173.417075     173.399002         YES\n",
      "191  2024-07-03         173.591161     173.585007          NO\n",
      "192  2024-07-04         174.442526     174.393997         YES\n",
      "193  2024-07-05         174.439190     174.429001         YES\n",
      "194  2024-07-08         173.907120     173.903000          NO\n",
      "195  2024-07-09         174.223418     174.212997         YES\n",
      "196  2024-07-10         174.476016     174.440002         YES\n",
      "197  2024-07-11         175.073653     175.070999          NO\n",
      "198  2024-07-12         172.008095     172.007004          NO\n",
      "199  2024-07-15         172.332238     172.326996          NO\n",
      "200  2024-07-16         172.398361     172.335999         YES\n",
      "201  2024-07-17         172.641248     172.617996         YES\n",
      "202  2024-07-18         170.323623     170.296005         YES\n",
      "203  2024-07-19         171.318002     171.317001          NO\n",
      "204  2024-07-22         171.577108     171.300003         YES\n",
      "205  2024-07-23         170.851255     170.843002          NO\n",
      "206  2024-07-24         169.019099     168.988007         YES\n",
      "207  2024-07-25         166.810475     166.794006         YES\n",
      "208  2024-07-26         166.780972     166.761002         YES\n",
      "209  2024-07-29         167.298728     167.289001          NO\n",
      "210  2024-07-30         166.439085     166.410004         YES\n",
      "211  2024-07-31         165.128973     165.112000         YES\n",
      "212  2024-08-01         162.081654     162.072998          NO\n",
      "213  2024-08-02         160.952115     160.945999          NO\n",
      "214  2024-08-05         158.844321     159.850006         YES\n",
      "215  2024-08-06         159.654368     157.889999         YES\n",
      "216  2024-08-07         158.137298     158.132996          NO\n",
      "217  2024-08-08         159.686132     159.695999          NO\n",
      "218  2024-08-09         161.191359     161.190994          NO\n",
      "219  2024-08-12         160.478899     160.472000          NO\n",
      "220  2024-08-13         160.743211     160.714996         YES\n",
      "221  2024-08-14         161.623805     161.613007         YES\n",
      "222  2024-08-15         162.172913     162.141998         YES\n",
      "223  2024-08-16         163.737306     163.725998         YES\n",
      "224  2024-08-19         163.121389     163.117004          NO\n",
      "225  2024-08-20         162.637480     162.619995         YES\n",
      "226  2024-08-21         161.741085     161.733002          NO\n",
      "227  2024-08-22         161.884363     161.880005          NO\n",
      "228  2024-08-23         162.535155     162.524002         YES\n",
      "229  2024-08-26         161.106262     161.098007          NO\n",
      "230  2024-08-27         161.347800     161.320007         YES\n",
      "231  2024-08-28         160.934266     160.929001          NO\n",
      "232  2024-08-29         160.681067     160.660995         YES\n",
      "233  2024-08-30         160.544706     160.537003          NO\n",
      "234  2024-09-02         161.675498     161.671997          NO\n",
      "235  2024-09-03         162.383928     162.373993          NO\n",
      "236  2024-09-04         160.598621     160.572998         YES\n",
      "237  2024-09-05         158.809513     158.783005         YES\n",
      "238  2024-09-06         159.325569     159.320007          NO\n",
      "239  2024-09-09         157.977249     157.973007          NO\n",
      "240  2024-09-10         158.032007     157.981003         YES\n",
      "241  2024-09-11         156.755849     156.733002         YES\n",
      "242  2024-09-12         157.004583     157.013000          NO\n",
      "243  2024-09-13         156.750848     156.750000          NO\n",
      "244  2024-09-16         156.114162     156.115005          NO\n",
      "245  2024-09-17         156.692739     156.686996          NO\n",
      "246  2024-09-18         157.964694     157.962006          NO\n",
      "247  2024-09-19         158.619556     158.584000         YES\n",
      "248  2024-09-20         159.457535     159.414001         YES\n",
      "249  2024-09-23         160.720538     160.710999          NO\n",
      "250  2024-09-24         159.606639     159.589005         YES\n",
      "251  2024-09-25         159.992614     159.987000          NO\n",
      "252  2024-09-26         161.046981     161.039993          NO\n",
      "253  2024-09-27         162.154058     162.126007         YES\n",
      "254  2024-09-30         159.485976     159.479996          NO\n",
      "255  2024-10-01         160.044117     160.031998         YES\n",
      "256  2024-10-02         159.028133     159.024002          NO\n",
      "257  2024-10-03         161.951166     161.917999         YES\n",
      "258  2024-10-04         162.046427     162.041000          NO\n",
      "259  2024-10-08         162.601246     162.574005         YES\n",
      "Error saving to CSV: [Errno 30] Read-only file system: 'arbitrage_opportunities.csv'\n"
     ]
    }
   ],
   "source": [
    "import yfinance as yf\n",
    "import pandas as pd\n",
    "from datetime import datetime, timedelta\n",
    "\n",
    "def fetch_historical_data(currency_pair, start_date, end_date):\n",
    "    \"\"\"\n",
    "    Fetch historical exchange rate data using Yahoo Finance for the given currency pair.\n",
    "    \n",
    "    Parameters:\n",
    "    currency_pair (str): The currency pair symbol (e.g., 'EURUSD=X', 'GBPUSD=X').\n",
    "    start_date (str): Start date for fetching historical data (format: 'YYYY-MM-DD').\n",
    "    end_date (str): End date for fetching historical data (format: 'YYYY-MM-DD').\n",
    "    \n",
    "    Returns:\n",
    "    pd.DataFrame: DataFrame containing historical exchange rates.\n",
    "    \"\"\"\n",
    "    currency_pair = currency_pair + \"=X\" if not currency_pair.endswith(\"=X\") else currency_pair\n",
    "    ticker = yf.Ticker(currency_pair)\n",
    "    data = ticker.history(start=start_date, end=end_date)\n",
    "    \n",
    "    if data.empty or 'Close' not in data.columns:\n",
    "        print(f\"Error fetching data for {currency_pair}\")\n",
    "        return pd.DataFrame()  # Return an empty DataFrame if data is not available\n",
    "    \n",
    "    return data[['Close']].rename(columns={'Close': currency_pair})  # Rename the 'Close' column to the currency pair name\n",
    "\n",
    "def calculate_triangular_arbitrage(date, eur_usd, usd_jpy, eur_jpy):\n",
    "    \"\"\"\n",
    "    Calculate whether there is an arbitrage opportunity on a given day.\n",
    "    \n",
    "    Parameters:\n",
    "    date (str): The date of the exchange rates.\n",
    "    eur_usd (float): EUR/USD exchange rate.\n",
    "    usd_jpy (float): USD/JPY exchange rate.\n",
    "    eur_jpy (float): EUR/JPY exchange rate.\n",
    "    \n",
    "    Returns:\n",
    "    dict: A dictionary containing the date and whether an arbitrage opportunity exists.\n",
    "    \"\"\"\n",
    "    # Calculate the EUR/JPY cross rate from EUR/USD and USD/JPY\n",
    "    calculated_eur_jpy = eur_usd * usd_jpy\n",
    "    \n",
    "    # Check for arbitrage opportunity (if actual EUR/JPY is different from calculated)\n",
    "    arbitrage_opportunity = \"YES\" if abs(calculated_eur_jpy - eur_jpy) > 0.01 else \"NO\"\n",
    "    \n",
    "    return {\n",
    "        \"Date\": date,\n",
    "        \"Calculated_EURJPY\": calculated_eur_jpy,\n",
    "        \"Actual_EURJPY\": eur_jpy,\n",
    "        \"Opportunity\": arbitrage_opportunity\n",
    "    }\n",
    "\n",
    "def list_past_arbitrage_opportunities():\n",
    "    \"\"\"\n",
    "    List arbitrage opportunities for the past year based on historical exchange rates.\n",
    "    \"\"\"\n",
    "    # Define the currency pairs involved in the triangular arbitrage\n",
    "    pairs = ['EURUSD', 'USDJPY', 'EURJPY']\n",
    "    \n",
    "    # Set the start and end dates for the past year\n",
    "    end_date = datetime.today().strftime('%Y-%m-%d')\n",
    "    start_date = (datetime.today() - timedelta(days=365)).strftime('%Y-%m-%d')\n",
    "    \n",
    "    # Fetch historical data for each currency pair\n",
    "    print(\"Fetching historical data...\")\n",
    "    eur_usd_data = fetch_historical_data('EURUSD', start_date, end_date)\n",
    "    usd_jpy_data = fetch_historical_data('USDJPY', start_date, end_date)\n",
    "    eur_jpy_data = fetch_historical_data('EURJPY', start_date, end_date)\n",
    "    \n",
    "    # Ensure that the data is available for all currency pairs\n",
    "    if eur_usd_data.empty or usd_jpy_data.empty or eur_jpy_data.empty:\n",
    "        print(\"Failed to fetch data for one or more pairs. Exiting.\")\n",
    "        return\n",
    "    \n",
    "    # Join the data on the date index to align exchange rates\n",
    "    print(\"Joining historical data...\")\n",
    "    data = eur_usd_data.join([usd_jpy_data, eur_jpy_data], how='inner')\n",
    "\n",
    "    print(f\"Joined Data (first few rows):\")\n",
    "    print(data.head())  # Print the first few rows of the joined data to check\n",
    "\n",
    "    # Iterate over each row to calculate arbitrage opportunities\n",
    "    print(\"Detecting arbitrage opportunities...\")\n",
    "    opportunities = []\n",
    "    \n",
    "    for index, row in data.iterrows():\n",
    "        arbitrage_opportunity = calculate_triangular_arbitrage(\n",
    "            date=index.strftime('%Y-%m-%d'),\n",
    "            eur_usd=row['EURUSD=X'],\n",
    "            usd_jpy=row['USDJPY=X'],\n",
    "            eur_jpy=row['EURJPY=X']\n",
    "        )\n",
    "        opportunities.append(arbitrage_opportunity)\n",
    "    \n",
    "    # Convert opportunities to a DataFrame\n",
    "    opportunities_df = pd.DataFrame(opportunities)\n",
    "\n",
    "    # Save the DataFrame in-memory\n",
    "    print(\"Saving opportunities as a DataFrame...\")\n",
    "    global stored_opportunities_df\n",
    "    stored_opportunities_df = opportunities_df  # Save it as a global variable to be accessed later\n",
    "\n",
    "    # Optionally print the DataFrame\n",
    "    pd.set_option('display.max_rows', None)  # To display all rows\n",
    "    print(\"Detected Arbitrage Opportunities:\")\n",
    "    print(opportunities_df)\n",
    "\n",
    "    # Optionally save to a CSV file\n",
    "    try:\n",
    "        opportunities_df.to_csv('arbitrage_opportunities.csv', index=False)\n",
    "        print(\"Opportunities saved to 'arbitrage_opportunities.csv'.\")\n",
    "    except Exception as e:\n",
    "        print(f\"Error saving to CSV: {e}\")\n",
    "\n",
    "if __name__ == '__main__':\n",
    "    list_past_arbitrage_opportunities()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Calculated_EURJPY</th>\n",
       "      <th>Actual_EURJPY</th>\n",
       "      <th>Opportunity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2023-10-10</td>\n",
       "      <td>156.913283</td>\n",
       "      <td>156.909149</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2023-10-11</td>\n",
       "      <td>157.616904</td>\n",
       "      <td>157.598999</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2023-10-12</td>\n",
       "      <td>158.340050</td>\n",
       "      <td>158.328995</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2023-10-13</td>\n",
       "      <td>157.829837</td>\n",
       "      <td>157.811996</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2023-10-16</td>\n",
       "      <td>157.366665</td>\n",
       "      <td>157.354996</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2023-10-17</td>\n",
       "      <td>157.869298</td>\n",
       "      <td>157.863007</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2023-10-18</td>\n",
       "      <td>158.341082</td>\n",
       "      <td>158.309998</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2023-10-19</td>\n",
       "      <td>157.805887</td>\n",
       "      <td>157.789001</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2023-10-20</td>\n",
       "      <td>158.587767</td>\n",
       "      <td>158.548004</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2023-10-23</td>\n",
       "      <td>158.722427</td>\n",
       "      <td>158.712006</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2023-10-24</td>\n",
       "      <td>159.801329</td>\n",
       "      <td>159.789993</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2023-10-25</td>\n",
       "      <td>158.775602</td>\n",
       "      <td>158.764008</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2023-10-26</td>\n",
       "      <td>158.612320</td>\n",
       "      <td>158.598999</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2023-10-27</td>\n",
       "      <td>158.853550</td>\n",
       "      <td>158.841995</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2023-10-30</td>\n",
       "      <td>158.154748</td>\n",
       "      <td>158.145996</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2023-10-31</td>\n",
       "      <td>158.281845</td>\n",
       "      <td>158.261993</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2023-11-01</td>\n",
       "      <td>160.055437</td>\n",
       "      <td>160.057999</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2023-11-02</td>\n",
       "      <td>159.414534</td>\n",
       "      <td>159.410004</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2023-11-03</td>\n",
       "      <td>159.814160</td>\n",
       "      <td>159.753998</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2023-11-06</td>\n",
       "      <td>160.390880</td>\n",
       "      <td>160.382004</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2023-11-07</td>\n",
       "      <td>160.811615</td>\n",
       "      <td>160.755005</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2023-11-08</td>\n",
       "      <td>160.865097</td>\n",
       "      <td>160.852005</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2023-11-09</td>\n",
       "      <td>161.581724</td>\n",
       "      <td>161.567993</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2023-11-10</td>\n",
       "      <td>161.452707</td>\n",
       "      <td>161.432007</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2023-11-13</td>\n",
       "      <td>161.922721</td>\n",
       "      <td>161.910995</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2023-11-14</td>\n",
       "      <td>162.288901</td>\n",
       "      <td>162.270004</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2023-11-15</td>\n",
       "      <td>163.702324</td>\n",
       "      <td>163.688995</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2023-11-16</td>\n",
       "      <td>164.137552</td>\n",
       "      <td>164.130005</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2023-11-17</td>\n",
       "      <td>163.571542</td>\n",
       "      <td>163.556000</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2023-11-20</td>\n",
       "      <td>163.542157</td>\n",
       "      <td>163.533997</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2023-11-21</td>\n",
       "      <td>162.396279</td>\n",
       "      <td>162.378998</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2023-11-22</td>\n",
       "      <td>161.755645</td>\n",
       "      <td>161.735992</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2023-11-23</td>\n",
       "      <td>162.775005</td>\n",
       "      <td>162.729996</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2023-11-24</td>\n",
       "      <td>163.196636</td>\n",
       "      <td>163.160004</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2023-11-27</td>\n",
       "      <td>163.637250</td>\n",
       "      <td>163.628006</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2023-11-28</td>\n",
       "      <td>162.679986</td>\n",
       "      <td>162.639999</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2023-11-29</td>\n",
       "      <td>161.856718</td>\n",
       "      <td>161.815994</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2023-11-30</td>\n",
       "      <td>161.356123</td>\n",
       "      <td>161.343002</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>2023-12-01</td>\n",
       "      <td>161.201388</td>\n",
       "      <td>161.192993</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>2023-12-04</td>\n",
       "      <td>159.394844</td>\n",
       "      <td>159.386993</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>2023-12-05</td>\n",
       "      <td>159.669444</td>\n",
       "      <td>159.662994</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>2023-12-06</td>\n",
       "      <td>158.866442</td>\n",
       "      <td>158.854996</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>2023-12-07</td>\n",
       "      <td>158.468558</td>\n",
       "      <td>158.451004</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>2023-12-08</td>\n",
       "      <td>155.706886</td>\n",
       "      <td>155.669006</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>2023-12-11</td>\n",
       "      <td>156.085358</td>\n",
       "      <td>156.076004</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>2023-12-12</td>\n",
       "      <td>157.283593</td>\n",
       "      <td>157.257004</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>2023-12-13</td>\n",
       "      <td>156.883077</td>\n",
       "      <td>156.867996</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>2023-12-14</td>\n",
       "      <td>155.424543</td>\n",
       "      <td>155.380005</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>2023-12-15</td>\n",
       "      <td>156.415881</td>\n",
       "      <td>156.408005</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>2023-12-18</td>\n",
       "      <td>155.053777</td>\n",
       "      <td>155.050995</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>2023-12-19</td>\n",
       "      <td>155.907056</td>\n",
       "      <td>155.893005</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>2023-12-20</td>\n",
       "      <td>158.005181</td>\n",
       "      <td>157.996994</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>2023-12-21</td>\n",
       "      <td>157.096090</td>\n",
       "      <td>157.016998</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>2023-12-22</td>\n",
       "      <td>156.364893</td>\n",
       "      <td>156.307007</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>2023-12-25</td>\n",
       "      <td>156.954460</td>\n",
       "      <td>156.789993</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>2023-12-26</td>\n",
       "      <td>156.741083</td>\n",
       "      <td>156.712006</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>2023-12-27</td>\n",
       "      <td>157.319854</td>\n",
       "      <td>157.294998</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>2023-12-28</td>\n",
       "      <td>157.075101</td>\n",
       "      <td>157.063004</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>2023-12-29</td>\n",
       "      <td>156.537425</td>\n",
       "      <td>156.526993</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>2024-01-01</td>\n",
       "      <td>155.834157</td>\n",
       "      <td>155.899338</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>2024-01-02</td>\n",
       "      <td>155.785410</td>\n",
       "      <td>155.764999</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>2024-01-03</td>\n",
       "      <td>155.542545</td>\n",
       "      <td>155.535995</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>2024-01-04</td>\n",
       "      <td>156.265978</td>\n",
       "      <td>156.227997</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>2024-01-05</td>\n",
       "      <td>158.479850</td>\n",
       "      <td>158.468002</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>2024-01-08</td>\n",
       "      <td>158.351669</td>\n",
       "      <td>158.339996</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>2024-01-09</td>\n",
       "      <td>157.956402</td>\n",
       "      <td>157.934006</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>2024-01-10</td>\n",
       "      <td>157.894842</td>\n",
       "      <td>157.886002</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>2024-01-11</td>\n",
       "      <td>159.945120</td>\n",
       "      <td>159.938995</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>2024-01-12</td>\n",
       "      <td>159.284434</td>\n",
       "      <td>159.268005</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>2024-01-15</td>\n",
       "      <td>158.875870</td>\n",
       "      <td>158.863998</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>2024-01-16</td>\n",
       "      <td>159.581873</td>\n",
       "      <td>159.563004</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>2024-01-17</td>\n",
       "      <td>160.185825</td>\n",
       "      <td>160.179993</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>2024-01-18</td>\n",
       "      <td>161.237919</td>\n",
       "      <td>161.223007</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>2024-01-19</td>\n",
       "      <td>161.150583</td>\n",
       "      <td>161.126999</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>2024-01-22</td>\n",
       "      <td>161.337795</td>\n",
       "      <td>161.339996</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>2024-01-23</td>\n",
       "      <td>161.181593</td>\n",
       "      <td>161.136993</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>2024-01-24</td>\n",
       "      <td>160.969184</td>\n",
       "      <td>160.949005</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>2024-01-25</td>\n",
       "      <td>160.604814</td>\n",
       "      <td>160.589996</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>2024-01-26</td>\n",
       "      <td>160.235831</td>\n",
       "      <td>160.218994</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>2024-01-29</td>\n",
       "      <td>160.635872</td>\n",
       "      <td>160.617004</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>2024-01-30</td>\n",
       "      <td>159.773779</td>\n",
       "      <td>159.755997</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>2024-01-31</td>\n",
       "      <td>159.798102</td>\n",
       "      <td>159.781006</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>2024-02-01</td>\n",
       "      <td>158.813305</td>\n",
       "      <td>158.783005</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>2024-02-02</td>\n",
       "      <td>159.260313</td>\n",
       "      <td>159.248993</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>2024-02-05</td>\n",
       "      <td>160.084733</td>\n",
       "      <td>160.080994</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>2024-02-06</td>\n",
       "      <td>159.666576</td>\n",
       "      <td>159.651993</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>2024-02-07</td>\n",
       "      <td>159.010765</td>\n",
       "      <td>158.990997</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>2024-02-08</td>\n",
       "      <td>159.573712</td>\n",
       "      <td>159.572433</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>2024-02-09</td>\n",
       "      <td>160.860238</td>\n",
       "      <td>160.845993</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>2024-02-12</td>\n",
       "      <td>161.073559</td>\n",
       "      <td>161.067993</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>2024-02-13</td>\n",
       "      <td>160.943009</td>\n",
       "      <td>160.910004</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>2024-02-14</td>\n",
       "      <td>161.409301</td>\n",
       "      <td>161.389999</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>2024-02-15</td>\n",
       "      <td>161.566051</td>\n",
       "      <td>161.559967</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>2024-02-16</td>\n",
       "      <td>161.550135</td>\n",
       "      <td>161.533997</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>2024-02-19</td>\n",
       "      <td>161.872061</td>\n",
       "      <td>161.867004</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>2024-02-20</td>\n",
       "      <td>161.921893</td>\n",
       "      <td>161.893005</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>2024-02-21</td>\n",
       "      <td>162.131273</td>\n",
       "      <td>162.110992</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>2024-02-22</td>\n",
       "      <td>162.690166</td>\n",
       "      <td>162.684006</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>2024-02-23</td>\n",
       "      <td>162.908000</td>\n",
       "      <td>162.897995</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>2024-02-26</td>\n",
       "      <td>162.839611</td>\n",
       "      <td>162.830994</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>2024-02-27</td>\n",
       "      <td>163.378110</td>\n",
       "      <td>163.350998</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>2024-02-28</td>\n",
       "      <td>163.208981</td>\n",
       "      <td>163.147003</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>2024-02-29</td>\n",
       "      <td>163.293275</td>\n",
       "      <td>163.246002</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>2024-03-01</td>\n",
       "      <td>162.177203</td>\n",
       "      <td>162.167007</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>2024-03-04</td>\n",
       "      <td>162.754254</td>\n",
       "      <td>162.746994</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>2024-03-05</td>\n",
       "      <td>163.333412</td>\n",
       "      <td>163.319000</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>2024-03-06</td>\n",
       "      <td>162.893121</td>\n",
       "      <td>162.871994</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>2024-03-07</td>\n",
       "      <td>162.696326</td>\n",
       "      <td>162.684006</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>2024-03-08</td>\n",
       "      <td>161.917593</td>\n",
       "      <td>161.908005</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>2024-03-11</td>\n",
       "      <td>160.614130</td>\n",
       "      <td>160.608994</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>2024-03-12</td>\n",
       "      <td>160.397896</td>\n",
       "      <td>160.389008</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>2024-03-13</td>\n",
       "      <td>161.314618</td>\n",
       "      <td>161.291000</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>2024-03-14</td>\n",
       "      <td>161.723277</td>\n",
       "      <td>161.686996</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>2024-03-15</td>\n",
       "      <td>161.396569</td>\n",
       "      <td>161.376999</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>2024-03-18</td>\n",
       "      <td>162.101423</td>\n",
       "      <td>162.097000</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>2024-03-19</td>\n",
       "      <td>162.178270</td>\n",
       "      <td>162.173004</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>2024-03-20</td>\n",
       "      <td>164.073954</td>\n",
       "      <td>164.054993</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>2024-03-21</td>\n",
       "      <td>164.889377</td>\n",
       "      <td>164.878998</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>2024-03-22</td>\n",
       "      <td>164.709255</td>\n",
       "      <td>164.703003</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>2024-03-25</td>\n",
       "      <td>163.523464</td>\n",
       "      <td>163.520996</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>2024-03-26</td>\n",
       "      <td>164.061517</td>\n",
       "      <td>164.048004</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>2024-03-27</td>\n",
       "      <td>164.142729</td>\n",
       "      <td>164.039993</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>2024-03-28</td>\n",
       "      <td>163.592428</td>\n",
       "      <td>163.529007</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>2024-03-29</td>\n",
       "      <td>163.471497</td>\n",
       "      <td>163.410004</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>2024-04-01</td>\n",
       "      <td>163.399712</td>\n",
       "      <td>163.393997</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>2024-04-02</td>\n",
       "      <td>162.755812</td>\n",
       "      <td>162.751007</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>2024-04-03</td>\n",
       "      <td>163.186627</td>\n",
       "      <td>163.179001</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>2024-04-04</td>\n",
       "      <td>164.288733</td>\n",
       "      <td>164.276993</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>2024-04-05</td>\n",
       "      <td>163.955969</td>\n",
       "      <td>163.945007</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>2024-04-08</td>\n",
       "      <td>164.287570</td>\n",
       "      <td>164.283005</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>2024-04-09</td>\n",
       "      <td>164.957102</td>\n",
       "      <td>164.921997</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>2024-04-10</td>\n",
       "      <td>164.819134</td>\n",
       "      <td>164.802002</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>2024-04-11</td>\n",
       "      <td>164.309581</td>\n",
       "      <td>164.292007</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>2024-04-12</td>\n",
       "      <td>164.326781</td>\n",
       "      <td>164.317001</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>2024-04-15</td>\n",
       "      <td>163.240689</td>\n",
       "      <td>163.210007</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>2024-04-16</td>\n",
       "      <td>163.855431</td>\n",
       "      <td>163.830002</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>2024-04-17</td>\n",
       "      <td>164.311889</td>\n",
       "      <td>164.296005</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>2024-04-18</td>\n",
       "      <td>164.673622</td>\n",
       "      <td>164.662003</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>2024-04-19</td>\n",
       "      <td>164.569753</td>\n",
       "      <td>164.559006</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>2024-04-22</td>\n",
       "      <td>164.819230</td>\n",
       "      <td>164.809998</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>2024-04-23</td>\n",
       "      <td>164.938587</td>\n",
       "      <td>164.925003</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>2024-04-24</td>\n",
       "      <td>165.643331</td>\n",
       "      <td>165.613007</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>2024-04-25</td>\n",
       "      <td>166.125253</td>\n",
       "      <td>166.115997</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>2024-04-26</td>\n",
       "      <td>166.949583</td>\n",
       "      <td>166.908005</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>2024-04-29</td>\n",
       "      <td>169.408331</td>\n",
       "      <td>169.399994</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>2024-04-30</td>\n",
       "      <td>167.501413</td>\n",
       "      <td>167.395996</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>2024-05-01</td>\n",
       "      <td>168.235004</td>\n",
       "      <td>168.214996</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>2024-05-02</td>\n",
       "      <td>166.938983</td>\n",
       "      <td>166.880005</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>2024-05-03</td>\n",
       "      <td>164.264255</td>\n",
       "      <td>164.216003</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>2024-05-06</td>\n",
       "      <td>165.208210</td>\n",
       "      <td>165.201004</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>2024-05-07</td>\n",
       "      <td>166.074806</td>\n",
       "      <td>166.078003</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>2024-05-08</td>\n",
       "      <td>166.361709</td>\n",
       "      <td>166.356995</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>2024-05-09</td>\n",
       "      <td>167.027416</td>\n",
       "      <td>166.998993</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>2024-05-10</td>\n",
       "      <td>167.589513</td>\n",
       "      <td>167.533997</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>2024-05-13</td>\n",
       "      <td>167.822316</td>\n",
       "      <td>167.817001</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>2024-05-14</td>\n",
       "      <td>168.630741</td>\n",
       "      <td>168.589996</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>2024-05-15</td>\n",
       "      <td>169.245582</td>\n",
       "      <td>169.240997</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>2024-05-16</td>\n",
       "      <td>168.010096</td>\n",
       "      <td>168.001999</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>2024-05-17</td>\n",
       "      <td>168.862687</td>\n",
       "      <td>168.854004</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>2024-05-20</td>\n",
       "      <td>169.389877</td>\n",
       "      <td>169.345001</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>2024-05-21</td>\n",
       "      <td>169.830783</td>\n",
       "      <td>169.822006</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>2024-05-22</td>\n",
       "      <td>169.613132</td>\n",
       "      <td>169.606995</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>2024-05-23</td>\n",
       "      <td>169.635284</td>\n",
       "      <td>169.632004</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>2024-05-24</td>\n",
       "      <td>169.729920</td>\n",
       "      <td>169.714005</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>2024-05-27</td>\n",
       "      <td>170.166830</td>\n",
       "      <td>170.160995</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>2024-05-28</td>\n",
       "      <td>170.363339</td>\n",
       "      <td>170.347000</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>2024-05-29</td>\n",
       "      <td>170.658702</td>\n",
       "      <td>170.654007</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>2024-05-30</td>\n",
       "      <td>170.245320</td>\n",
       "      <td>170.216003</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>2024-05-31</td>\n",
       "      <td>170.065019</td>\n",
       "      <td>169.996002</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>2024-06-03</td>\n",
       "      <td>170.588228</td>\n",
       "      <td>170.580002</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>2024-06-04</td>\n",
       "      <td>170.238112</td>\n",
       "      <td>170.227997</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>2024-06-05</td>\n",
       "      <td>168.803854</td>\n",
       "      <td>168.796005</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>2024-06-06</td>\n",
       "      <td>169.565461</td>\n",
       "      <td>169.556000</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>2024-06-07</td>\n",
       "      <td>169.623046</td>\n",
       "      <td>169.574997</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>2024-06-10</td>\n",
       "      <td>169.048440</td>\n",
       "      <td>169.039993</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>2024-06-11</td>\n",
       "      <td>169.041974</td>\n",
       "      <td>169.020004</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>2024-06-12</td>\n",
       "      <td>168.735953</td>\n",
       "      <td>168.720993</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>2024-06-13</td>\n",
       "      <td>169.550183</td>\n",
       "      <td>169.520004</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>2024-06-14</td>\n",
       "      <td>168.737122</td>\n",
       "      <td>168.725998</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>2024-06-17</td>\n",
       "      <td>168.608396</td>\n",
       "      <td>168.604004</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>2024-06-18</td>\n",
       "      <td>169.380475</td>\n",
       "      <td>169.369003</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>2024-06-19</td>\n",
       "      <td>169.589647</td>\n",
       "      <td>169.494003</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>2024-06-20</td>\n",
       "      <td>169.829046</td>\n",
       "      <td>169.763000</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>2024-06-21</td>\n",
       "      <td>170.158032</td>\n",
       "      <td>170.151001</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>2024-06-24</td>\n",
       "      <td>170.855556</td>\n",
       "      <td>170.850006</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>2024-06-25</td>\n",
       "      <td>171.386573</td>\n",
       "      <td>171.375000</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>2024-06-26</td>\n",
       "      <td>171.017635</td>\n",
       "      <td>171.009995</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>2024-06-27</td>\n",
       "      <td>171.544985</td>\n",
       "      <td>171.535004</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>2024-06-28</td>\n",
       "      <td>172.071232</td>\n",
       "      <td>172.065002</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>2024-07-01</td>\n",
       "      <td>172.737811</td>\n",
       "      <td>172.729996</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>2024-07-02</td>\n",
       "      <td>173.417075</td>\n",
       "      <td>173.399002</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>2024-07-03</td>\n",
       "      <td>173.591161</td>\n",
       "      <td>173.585007</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>2024-07-04</td>\n",
       "      <td>174.442526</td>\n",
       "      <td>174.393997</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>2024-07-05</td>\n",
       "      <td>174.439190</td>\n",
       "      <td>174.429001</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>2024-07-08</td>\n",
       "      <td>173.907120</td>\n",
       "      <td>173.903000</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>2024-07-09</td>\n",
       "      <td>174.223418</td>\n",
       "      <td>174.212997</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>2024-07-10</td>\n",
       "      <td>174.476016</td>\n",
       "      <td>174.440002</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>2024-07-11</td>\n",
       "      <td>175.073653</td>\n",
       "      <td>175.070999</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>2024-07-12</td>\n",
       "      <td>172.008095</td>\n",
       "      <td>172.007004</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>2024-07-15</td>\n",
       "      <td>172.332238</td>\n",
       "      <td>172.326996</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200</th>\n",
       "      <td>2024-07-16</td>\n",
       "      <td>172.398361</td>\n",
       "      <td>172.335999</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201</th>\n",
       "      <td>2024-07-17</td>\n",
       "      <td>172.641248</td>\n",
       "      <td>172.617996</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>2024-07-18</td>\n",
       "      <td>170.323623</td>\n",
       "      <td>170.296005</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>2024-07-19</td>\n",
       "      <td>171.318002</td>\n",
       "      <td>171.317001</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204</th>\n",
       "      <td>2024-07-22</td>\n",
       "      <td>171.577108</td>\n",
       "      <td>171.300003</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>205</th>\n",
       "      <td>2024-07-23</td>\n",
       "      <td>170.851255</td>\n",
       "      <td>170.843002</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>2024-07-24</td>\n",
       "      <td>169.019099</td>\n",
       "      <td>168.988007</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>2024-07-25</td>\n",
       "      <td>166.810475</td>\n",
       "      <td>166.794006</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>2024-07-26</td>\n",
       "      <td>166.780972</td>\n",
       "      <td>166.761002</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>2024-07-29</td>\n",
       "      <td>167.298728</td>\n",
       "      <td>167.289001</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>2024-07-30</td>\n",
       "      <td>166.439085</td>\n",
       "      <td>166.410004</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>2024-07-31</td>\n",
       "      <td>165.128973</td>\n",
       "      <td>165.112000</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>2024-08-01</td>\n",
       "      <td>162.081654</td>\n",
       "      <td>162.072998</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>2024-08-02</td>\n",
       "      <td>160.952115</td>\n",
       "      <td>160.945999</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>2024-08-05</td>\n",
       "      <td>158.844321</td>\n",
       "      <td>159.850006</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>2024-08-06</td>\n",
       "      <td>159.654368</td>\n",
       "      <td>157.889999</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>2024-08-07</td>\n",
       "      <td>158.137298</td>\n",
       "      <td>158.132996</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>2024-08-08</td>\n",
       "      <td>159.686132</td>\n",
       "      <td>159.695999</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218</th>\n",
       "      <td>2024-08-09</td>\n",
       "      <td>161.191359</td>\n",
       "      <td>161.190994</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>2024-08-12</td>\n",
       "      <td>160.478899</td>\n",
       "      <td>160.472000</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>2024-08-13</td>\n",
       "      <td>160.743211</td>\n",
       "      <td>160.714996</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>2024-08-14</td>\n",
       "      <td>161.623805</td>\n",
       "      <td>161.613007</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>2024-08-15</td>\n",
       "      <td>162.172913</td>\n",
       "      <td>162.141998</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>2024-08-16</td>\n",
       "      <td>163.737306</td>\n",
       "      <td>163.725998</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>2024-08-19</td>\n",
       "      <td>163.121389</td>\n",
       "      <td>163.117004</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>2024-08-20</td>\n",
       "      <td>162.637480</td>\n",
       "      <td>162.619995</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>2024-08-21</td>\n",
       "      <td>161.741085</td>\n",
       "      <td>161.733002</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>2024-08-22</td>\n",
       "      <td>161.884363</td>\n",
       "      <td>161.880005</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>2024-08-23</td>\n",
       "      <td>162.535155</td>\n",
       "      <td>162.524002</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>2024-08-26</td>\n",
       "      <td>161.106262</td>\n",
       "      <td>161.098007</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>2024-08-27</td>\n",
       "      <td>161.347800</td>\n",
       "      <td>161.320007</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>2024-08-28</td>\n",
       "      <td>160.934266</td>\n",
       "      <td>160.929001</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>2024-08-29</td>\n",
       "      <td>160.681067</td>\n",
       "      <td>160.660995</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>2024-08-30</td>\n",
       "      <td>160.544706</td>\n",
       "      <td>160.537003</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>2024-09-02</td>\n",
       "      <td>161.675498</td>\n",
       "      <td>161.671997</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>2024-09-03</td>\n",
       "      <td>162.383928</td>\n",
       "      <td>162.373993</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>2024-09-04</td>\n",
       "      <td>160.598621</td>\n",
       "      <td>160.572998</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>2024-09-05</td>\n",
       "      <td>158.809513</td>\n",
       "      <td>158.783005</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>2024-09-06</td>\n",
       "      <td>159.325569</td>\n",
       "      <td>159.320007</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>2024-09-09</td>\n",
       "      <td>157.977249</td>\n",
       "      <td>157.973007</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>2024-09-10</td>\n",
       "      <td>158.032007</td>\n",
       "      <td>157.981003</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>2024-09-11</td>\n",
       "      <td>156.755849</td>\n",
       "      <td>156.733002</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>2024-09-12</td>\n",
       "      <td>157.004583</td>\n",
       "      <td>157.013000</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>2024-09-13</td>\n",
       "      <td>156.750848</td>\n",
       "      <td>156.750000</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>2024-09-16</td>\n",
       "      <td>156.114162</td>\n",
       "      <td>156.115005</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>2024-09-17</td>\n",
       "      <td>156.692739</td>\n",
       "      <td>156.686996</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>2024-09-18</td>\n",
       "      <td>157.964694</td>\n",
       "      <td>157.962006</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>2024-09-19</td>\n",
       "      <td>158.619556</td>\n",
       "      <td>158.584000</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>2024-09-20</td>\n",
       "      <td>159.457535</td>\n",
       "      <td>159.414001</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>2024-09-23</td>\n",
       "      <td>160.720538</td>\n",
       "      <td>160.710999</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>2024-09-24</td>\n",
       "      <td>159.606639</td>\n",
       "      <td>159.589005</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>2024-09-25</td>\n",
       "      <td>159.992614</td>\n",
       "      <td>159.987000</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>2024-09-26</td>\n",
       "      <td>161.046981</td>\n",
       "      <td>161.039993</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>2024-09-27</td>\n",
       "      <td>162.154058</td>\n",
       "      <td>162.126007</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>2024-09-30</td>\n",
       "      <td>159.485976</td>\n",
       "      <td>159.479996</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>160.044117</td>\n",
       "      <td>160.031998</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>2024-10-02</td>\n",
       "      <td>159.028133</td>\n",
       "      <td>159.024002</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>2024-10-03</td>\n",
       "      <td>161.951166</td>\n",
       "      <td>161.917999</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>2024-10-04</td>\n",
       "      <td>162.046427</td>\n",
       "      <td>162.041000</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>2024-10-08</td>\n",
       "      <td>162.601246</td>\n",
       "      <td>162.574005</td>\n",
       "      <td>YES</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Date  Calculated_EURJPY  Actual_EURJPY Opportunity\n",
       "0    2023-10-10         156.913283     156.909149          NO\n",
       "1    2023-10-11         157.616904     157.598999         YES\n",
       "2    2023-10-12         158.340050     158.328995         YES\n",
       "3    2023-10-13         157.829837     157.811996         YES\n",
       "4    2023-10-16         157.366665     157.354996         YES\n",
       "5    2023-10-17         157.869298     157.863007          NO\n",
       "6    2023-10-18         158.341082     158.309998         YES\n",
       "7    2023-10-19         157.805887     157.789001         YES\n",
       "8    2023-10-20         158.587767     158.548004         YES\n",
       "9    2023-10-23         158.722427     158.712006         YES\n",
       "10   2023-10-24         159.801329     159.789993         YES\n",
       "11   2023-10-25         158.775602     158.764008         YES\n",
       "12   2023-10-26         158.612320     158.598999         YES\n",
       "13   2023-10-27         158.853550     158.841995         YES\n",
       "14   2023-10-30         158.154748     158.145996          NO\n",
       "15   2023-10-31         158.281845     158.261993         YES\n",
       "16   2023-11-01         160.055437     160.057999          NO\n",
       "17   2023-11-02         159.414534     159.410004          NO\n",
       "18   2023-11-03         159.814160     159.753998         YES\n",
       "19   2023-11-06         160.390880     160.382004          NO\n",
       "20   2023-11-07         160.811615     160.755005         YES\n",
       "21   2023-11-08         160.865097     160.852005         YES\n",
       "22   2023-11-09         161.581724     161.567993         YES\n",
       "23   2023-11-10         161.452707     161.432007         YES\n",
       "24   2023-11-13         161.922721     161.910995         YES\n",
       "25   2023-11-14         162.288901     162.270004         YES\n",
       "26   2023-11-15         163.702324     163.688995         YES\n",
       "27   2023-11-16         164.137552     164.130005          NO\n",
       "28   2023-11-17         163.571542     163.556000         YES\n",
       "29   2023-11-20         163.542157     163.533997          NO\n",
       "30   2023-11-21         162.396279     162.378998         YES\n",
       "31   2023-11-22         161.755645     161.735992         YES\n",
       "32   2023-11-23         162.775005     162.729996         YES\n",
       "33   2023-11-24         163.196636     163.160004         YES\n",
       "34   2023-11-27         163.637250     163.628006          NO\n",
       "35   2023-11-28         162.679986     162.639999         YES\n",
       "36   2023-11-29         161.856718     161.815994         YES\n",
       "37   2023-11-30         161.356123     161.343002         YES\n",
       "38   2023-12-01         161.201388     161.192993          NO\n",
       "39   2023-12-04         159.394844     159.386993          NO\n",
       "40   2023-12-05         159.669444     159.662994          NO\n",
       "41   2023-12-06         158.866442     158.854996         YES\n",
       "42   2023-12-07         158.468558     158.451004         YES\n",
       "43   2023-12-08         155.706886     155.669006         YES\n",
       "44   2023-12-11         156.085358     156.076004          NO\n",
       "45   2023-12-12         157.283593     157.257004         YES\n",
       "46   2023-12-13         156.883077     156.867996         YES\n",
       "47   2023-12-14         155.424543     155.380005         YES\n",
       "48   2023-12-15         156.415881     156.408005          NO\n",
       "49   2023-12-18         155.053777     155.050995          NO\n",
       "50   2023-12-19         155.907056     155.893005         YES\n",
       "51   2023-12-20         158.005181     157.996994          NO\n",
       "52   2023-12-21         157.096090     157.016998         YES\n",
       "53   2023-12-22         156.364893     156.307007         YES\n",
       "54   2023-12-25         156.954460     156.789993         YES\n",
       "55   2023-12-26         156.741083     156.712006         YES\n",
       "56   2023-12-27         157.319854     157.294998         YES\n",
       "57   2023-12-28         157.075101     157.063004         YES\n",
       "58   2023-12-29         156.537425     156.526993         YES\n",
       "59   2024-01-01         155.834157     155.899338         YES\n",
       "60   2024-01-02         155.785410     155.764999         YES\n",
       "61   2024-01-03         155.542545     155.535995          NO\n",
       "62   2024-01-04         156.265978     156.227997         YES\n",
       "63   2024-01-05         158.479850     158.468002         YES\n",
       "64   2024-01-08         158.351669     158.339996         YES\n",
       "65   2024-01-09         157.956402     157.934006         YES\n",
       "66   2024-01-10         157.894842     157.886002          NO\n",
       "67   2024-01-11         159.945120     159.938995          NO\n",
       "68   2024-01-12         159.284434     159.268005         YES\n",
       "69   2024-01-15         158.875870     158.863998         YES\n",
       "70   2024-01-16         159.581873     159.563004         YES\n",
       "71   2024-01-17         160.185825     160.179993          NO\n",
       "72   2024-01-18         161.237919     161.223007         YES\n",
       "73   2024-01-19         161.150583     161.126999         YES\n",
       "74   2024-01-22         161.337795     161.339996          NO\n",
       "75   2024-01-23         161.181593     161.136993         YES\n",
       "76   2024-01-24         160.969184     160.949005         YES\n",
       "77   2024-01-25         160.604814     160.589996         YES\n",
       "78   2024-01-26         160.235831     160.218994         YES\n",
       "79   2024-01-29         160.635872     160.617004         YES\n",
       "80   2024-01-30         159.773779     159.755997         YES\n",
       "81   2024-01-31         159.798102     159.781006         YES\n",
       "82   2024-02-01         158.813305     158.783005         YES\n",
       "83   2024-02-02         159.260313     159.248993         YES\n",
       "84   2024-02-05         160.084733     160.080994          NO\n",
       "85   2024-02-06         159.666576     159.651993         YES\n",
       "86   2024-02-07         159.010765     158.990997         YES\n",
       "87   2024-02-08         159.573712     159.572433          NO\n",
       "88   2024-02-09         160.860238     160.845993         YES\n",
       "89   2024-02-12         161.073559     161.067993          NO\n",
       "90   2024-02-13         160.943009     160.910004         YES\n",
       "91   2024-02-14         161.409301     161.389999         YES\n",
       "92   2024-02-15         161.566051     161.559967          NO\n",
       "93   2024-02-16         161.550135     161.533997         YES\n",
       "94   2024-02-19         161.872061     161.867004          NO\n",
       "95   2024-02-20         161.921893     161.893005         YES\n",
       "96   2024-02-21         162.131273     162.110992         YES\n",
       "97   2024-02-22         162.690166     162.684006          NO\n",
       "98   2024-02-23         162.908000     162.897995         YES\n",
       "99   2024-02-26         162.839611     162.830994          NO\n",
       "100  2024-02-27         163.378110     163.350998         YES\n",
       "101  2024-02-28         163.208981     163.147003         YES\n",
       "102  2024-02-29         163.293275     163.246002         YES\n",
       "103  2024-03-01         162.177203     162.167007         YES\n",
       "104  2024-03-04         162.754254     162.746994          NO\n",
       "105  2024-03-05         163.333412     163.319000         YES\n",
       "106  2024-03-06         162.893121     162.871994         YES\n",
       "107  2024-03-07         162.696326     162.684006         YES\n",
       "108  2024-03-08         161.917593     161.908005          NO\n",
       "109  2024-03-11         160.614130     160.608994          NO\n",
       "110  2024-03-12         160.397896     160.389008          NO\n",
       "111  2024-03-13         161.314618     161.291000         YES\n",
       "112  2024-03-14         161.723277     161.686996         YES\n",
       "113  2024-03-15         161.396569     161.376999         YES\n",
       "114  2024-03-18         162.101423     162.097000          NO\n",
       "115  2024-03-19         162.178270     162.173004          NO\n",
       "116  2024-03-20         164.073954     164.054993         YES\n",
       "117  2024-03-21         164.889377     164.878998         YES\n",
       "118  2024-03-22         164.709255     164.703003          NO\n",
       "119  2024-03-25         163.523464     163.520996          NO\n",
       "120  2024-03-26         164.061517     164.048004         YES\n",
       "121  2024-03-27         164.142729     164.039993         YES\n",
       "122  2024-03-28         163.592428     163.529007         YES\n",
       "123  2024-03-29         163.471497     163.410004         YES\n",
       "124  2024-04-01         163.399712     163.393997          NO\n",
       "125  2024-04-02         162.755812     162.751007          NO\n",
       "126  2024-04-03         163.186627     163.179001          NO\n",
       "127  2024-04-04         164.288733     164.276993         YES\n",
       "128  2024-04-05         163.955969     163.945007         YES\n",
       "129  2024-04-08         164.287570     164.283005          NO\n",
       "130  2024-04-09         164.957102     164.921997         YES\n",
       "131  2024-04-10         164.819134     164.802002         YES\n",
       "132  2024-04-11         164.309581     164.292007         YES\n",
       "133  2024-04-12         164.326781     164.317001          NO\n",
       "134  2024-04-15         163.240689     163.210007         YES\n",
       "135  2024-04-16         163.855431     163.830002         YES\n",
       "136  2024-04-17         164.311889     164.296005         YES\n",
       "137  2024-04-18         164.673622     164.662003         YES\n",
       "138  2024-04-19         164.569753     164.559006         YES\n",
       "139  2024-04-22         164.819230     164.809998          NO\n",
       "140  2024-04-23         164.938587     164.925003         YES\n",
       "141  2024-04-24         165.643331     165.613007         YES\n",
       "142  2024-04-25         166.125253     166.115997          NO\n",
       "143  2024-04-26         166.949583     166.908005         YES\n",
       "144  2024-04-29         169.408331     169.399994          NO\n",
       "145  2024-04-30         167.501413     167.395996         YES\n",
       "146  2024-05-01         168.235004     168.214996         YES\n",
       "147  2024-05-02         166.938983     166.880005         YES\n",
       "148  2024-05-03         164.264255     164.216003         YES\n",
       "149  2024-05-06         165.208210     165.201004          NO\n",
       "150  2024-05-07         166.074806     166.078003          NO\n",
       "151  2024-05-08         166.361709     166.356995          NO\n",
       "152  2024-05-09         167.027416     166.998993         YES\n",
       "153  2024-05-10         167.589513     167.533997         YES\n",
       "154  2024-05-13         167.822316     167.817001          NO\n",
       "155  2024-05-14         168.630741     168.589996         YES\n",
       "156  2024-05-15         169.245582     169.240997          NO\n",
       "157  2024-05-16         168.010096     168.001999          NO\n",
       "158  2024-05-17         168.862687     168.854004          NO\n",
       "159  2024-05-20         169.389877     169.345001         YES\n",
       "160  2024-05-21         169.830783     169.822006          NO\n",
       "161  2024-05-22         169.613132     169.606995          NO\n",
       "162  2024-05-23         169.635284     169.632004          NO\n",
       "163  2024-05-24         169.729920     169.714005         YES\n",
       "164  2024-05-27         170.166830     170.160995          NO\n",
       "165  2024-05-28         170.363339     170.347000         YES\n",
       "166  2024-05-29         170.658702     170.654007          NO\n",
       "167  2024-05-30         170.245320     170.216003         YES\n",
       "168  2024-05-31         170.065019     169.996002         YES\n",
       "169  2024-06-03         170.588228     170.580002          NO\n",
       "170  2024-06-04         170.238112     170.227997         YES\n",
       "171  2024-06-05         168.803854     168.796005          NO\n",
       "172  2024-06-06         169.565461     169.556000          NO\n",
       "173  2024-06-07         169.623046     169.574997         YES\n",
       "174  2024-06-10         169.048440     169.039993          NO\n",
       "175  2024-06-11         169.041974     169.020004         YES\n",
       "176  2024-06-12         168.735953     168.720993         YES\n",
       "177  2024-06-13         169.550183     169.520004         YES\n",
       "178  2024-06-14         168.737122     168.725998         YES\n",
       "179  2024-06-17         168.608396     168.604004          NO\n",
       "180  2024-06-18         169.380475     169.369003         YES\n",
       "181  2024-06-19         169.589647     169.494003         YES\n",
       "182  2024-06-20         169.829046     169.763000         YES\n",
       "183  2024-06-21         170.158032     170.151001          NO\n",
       "184  2024-06-24         170.855556     170.850006          NO\n",
       "185  2024-06-25         171.386573     171.375000         YES\n",
       "186  2024-06-26         171.017635     171.009995          NO\n",
       "187  2024-06-27         171.544985     171.535004          NO\n",
       "188  2024-06-28         172.071232     172.065002          NO\n",
       "189  2024-07-01         172.737811     172.729996          NO\n",
       "190  2024-07-02         173.417075     173.399002         YES\n",
       "191  2024-07-03         173.591161     173.585007          NO\n",
       "192  2024-07-04         174.442526     174.393997         YES\n",
       "193  2024-07-05         174.439190     174.429001         YES\n",
       "194  2024-07-08         173.907120     173.903000          NO\n",
       "195  2024-07-09         174.223418     174.212997         YES\n",
       "196  2024-07-10         174.476016     174.440002         YES\n",
       "197  2024-07-11         175.073653     175.070999          NO\n",
       "198  2024-07-12         172.008095     172.007004          NO\n",
       "199  2024-07-15         172.332238     172.326996          NO\n",
       "200  2024-07-16         172.398361     172.335999         YES\n",
       "201  2024-07-17         172.641248     172.617996         YES\n",
       "202  2024-07-18         170.323623     170.296005         YES\n",
       "203  2024-07-19         171.318002     171.317001          NO\n",
       "204  2024-07-22         171.577108     171.300003         YES\n",
       "205  2024-07-23         170.851255     170.843002          NO\n",
       "206  2024-07-24         169.019099     168.988007         YES\n",
       "207  2024-07-25         166.810475     166.794006         YES\n",
       "208  2024-07-26         166.780972     166.761002         YES\n",
       "209  2024-07-29         167.298728     167.289001          NO\n",
       "210  2024-07-30         166.439085     166.410004         YES\n",
       "211  2024-07-31         165.128973     165.112000         YES\n",
       "212  2024-08-01         162.081654     162.072998          NO\n",
       "213  2024-08-02         160.952115     160.945999          NO\n",
       "214  2024-08-05         158.844321     159.850006         YES\n",
       "215  2024-08-06         159.654368     157.889999         YES\n",
       "216  2024-08-07         158.137298     158.132996          NO\n",
       "217  2024-08-08         159.686132     159.695999          NO\n",
       "218  2024-08-09         161.191359     161.190994          NO\n",
       "219  2024-08-12         160.478899     160.472000          NO\n",
       "220  2024-08-13         160.743211     160.714996         YES\n",
       "221  2024-08-14         161.623805     161.613007         YES\n",
       "222  2024-08-15         162.172913     162.141998         YES\n",
       "223  2024-08-16         163.737306     163.725998         YES\n",
       "224  2024-08-19         163.121389     163.117004          NO\n",
       "225  2024-08-20         162.637480     162.619995         YES\n",
       "226  2024-08-21         161.741085     161.733002          NO\n",
       "227  2024-08-22         161.884363     161.880005          NO\n",
       "228  2024-08-23         162.535155     162.524002         YES\n",
       "229  2024-08-26         161.106262     161.098007          NO\n",
       "230  2024-08-27         161.347800     161.320007         YES\n",
       "231  2024-08-28         160.934266     160.929001          NO\n",
       "232  2024-08-29         160.681067     160.660995         YES\n",
       "233  2024-08-30         160.544706     160.537003          NO\n",
       "234  2024-09-02         161.675498     161.671997          NO\n",
       "235  2024-09-03         162.383928     162.373993          NO\n",
       "236  2024-09-04         160.598621     160.572998         YES\n",
       "237  2024-09-05         158.809513     158.783005         YES\n",
       "238  2024-09-06         159.325569     159.320007          NO\n",
       "239  2024-09-09         157.977249     157.973007          NO\n",
       "240  2024-09-10         158.032007     157.981003         YES\n",
       "241  2024-09-11         156.755849     156.733002         YES\n",
       "242  2024-09-12         157.004583     157.013000          NO\n",
       "243  2024-09-13         156.750848     156.750000          NO\n",
       "244  2024-09-16         156.114162     156.115005          NO\n",
       "245  2024-09-17         156.692739     156.686996          NO\n",
       "246  2024-09-18         157.964694     157.962006          NO\n",
       "247  2024-09-19         158.619556     158.584000         YES\n",
       "248  2024-09-20         159.457535     159.414001         YES\n",
       "249  2024-09-23         160.720538     160.710999          NO\n",
       "250  2024-09-24         159.606639     159.589005         YES\n",
       "251  2024-09-25         159.992614     159.987000          NO\n",
       "252  2024-09-26         161.046981     161.039993          NO\n",
       "253  2024-09-27         162.154058     162.126007         YES\n",
       "254  2024-09-30         159.485976     159.479996          NO\n",
       "255  2024-10-01         160.044117     160.031998         YES\n",
       "256  2024-10-02         159.028133     159.024002          NO\n",
       "257  2024-10-03         161.951166     161.917999         YES\n",
       "258  2024-10-04         162.046427     162.041000          NO\n",
       "259  2024-10-08         162.601246     162.574005         YES"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stored_opportunities_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Output:\n",
    "\n",
    "For each day in the past year, we generate a table containing:\n",
    "- The date\n",
    "- The calculated EUR/JPY rate\n",
    "- The actual EUR/JPY rate\n",
    "- Whether or not an arbitrage opportunity exists\n",
    "\n",
    "### Example Output Table:\n",
    "\n",
    "| Date       | Calculated_EURJPY | Actual_EURJPY | Opportunity |\n",
    "|------------|-------------------|---------------|-------------|\n",
    "| 2023-10-11 | 157.61            | 157.59        | YES         |\n",
    "| 2023-10-12 | 158.34            | 158.32        | YES         |\n",
    "| 2023-10-13 | 157.82            | 157.81        | YES         |\n",
    "| 2023-10-16 | 157.37            | 157.35        | YES         |\n",
    "| 2023-10-18 | 158.34            | 158.31        | YES         |\n",
    "\n",
    "### Conclusion:\n",
    "\n",
    "By comparing the **calculated** cross rate of **EUR/JPY** to the **actual market rate**, we can identify days where arbitrage opportunities may have existed in the past year. This strategy allows traders to detect potential inefficiencies in the market and capitalize on them."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Short Summary :\n",
    "Analyzing **triangular arbitrage** opportunities can provide valuable insights for both **traders** and **bankers**, particularly in **foreign exchange markets** (Forex). Here's how this type of analysis can benefit them:\n",
    "\n",
    "### 1. **Exploiting Price Inefficiencies**\n",
    "Triangular arbitrage takes advantage of **inefficiencies** in the currency market. When the exchange rates between three related currency pairs are misaligned, a trader can exploit this by executing a series of trades to profit from the price difference.\n",
    "\n",
    "- **Traders**: By detecting these arbitrage opportunities, traders can quickly execute buy and sell orders on different currency pairs to lock in risk-free profits. These opportunities are rare and usually exist for only a short period, but they offer **risk-free profit potential** when properly executed.\n",
    "  \n",
    "- **Bankers**: In banking, especially for **Forex desks** or **market makers**, detecting arbitrage opportunities is essential to ensure that pricing on their currency pairs is **efficient and competitive**. They can adjust their pricing algorithms to avoid offering opportunities for arbitrage to external traders, which would otherwise lead to financial losses.\n",
    "\n",
    "### 2. **Improved Algorithmic Trading**\n",
    "For **high-frequency traders** (HFTs) and algorithmic trading systems, triangular arbitrage strategies can be automated. These systems constantly scan the market for inefficiencies in currency pricing and execute trades in milliseconds. \n",
    "\n",
    "- **Traders**: With the use of automated scripts like the one you've developed, traders can incorporate **triangular arbitrage strategies** into their trading bots, allowing them to capture profits from price discrepancies without manual intervention.\n",
    "  \n",
    "- **Bankers**: Large banks and financial institutions use algorithms that look for arbitrage opportunities. By integrating this analysis into their **trading algorithms**, banks can enhance the efficiency of their trading operations, avoid offering arbitrage opportunities to competitors, and even capitalize on such opportunities when possible.\n",
    "\n",
    "### 3. **Hedging Against Market Risk**\n",
    "Arbitrage opportunities can indicate **imbalances** in the market that, if persistent, could signal upcoming volatility or market inefficiencies. Banks and traders can use this information to **hedge** their positions against unforeseen market movements.\n",
    "\n",
    "- **Traders**: They can combine arbitrage detection with other trading strategies to **minimize risk**. For instance, if a trader holds a position in a volatile market, they can use arbitrage opportunities to hedge their exposure by offsetting losses with gains from arbitrage trades.\n",
    "  \n",
    "- **Bankers**: For banks, triangular arbitrage analysis can help them maintain **market-neutral positions**, ensuring that they don’t take on unwanted risk. It can also act as a safeguard to ensure that they aren't losing money through inefficiencies in their own pricing.\n",
    "\n",
    "### 4. **Liquidity and Market Efficiency**\n",
    "Triangular arbitrage plays an important role in ensuring that the **foreign exchange market remains efficient**. When arbitrage opportunities arise, traders rush to take advantage of them, which, in turn, drives prices back into balance.\n",
    "\n",
    "- **Traders**: They benefit from a more **liquid** and **efficient market**. While they can exploit short-lived opportunities, the constant trading activity helps stabilize the currency market over time.\n",
    "  \n",
    "- **Bankers**: Banks benefit from **market efficiency** because it reduces volatility and unpredictability in the exchange rates. Fewer arbitrage opportunities mean more stable markets, allowing banks to focus on larger profit margins from regular trading activity and currency hedging strategies.\n",
    "\n",
    "### 5. **Enhancing Profitability for Currency Dealers**\n",
    "For currency dealers or market makers, detecting and avoiding arbitrage opportunities can directly impact profitability. If a bank's trading desk unknowingly allows arbitrage opportunities, they might incur losses when other market participants (such as algorithmic traders) capitalize on the mispricing.\n",
    "\n",
    "- **Traders**: Triangular arbitrage allows traders to earn a **small but consistent profit** with minimal risk by identifying and acting on price discrepancies.\n",
    "  \n",
    "- **Bankers**: For banks and financial institutions, preventing arbitrage ensures that they aren't leaking profits by offering **unintentionally favorable exchange rates** to savvy traders. It also helps them optimize their **currency spread** (the difference between bid and ask prices), which is a primary revenue stream for banks involved in Forex trading.\n",
    "\n",
    "### 6. **Competitive Edge in Forex Markets**\n",
    "For both traders and bankers, staying ahead of arbitrage opportunities provides a **competitive edge** in the highly competitive and fast-moving foreign exchange market.\n",
    "\n",
    "- **Traders**: They can achieve **better trade execution** and profitability by being the first to detect and exploit arbitrage opportunities, even before competitors spot them.\n",
    "  \n",
    "- **Bankers**: Banks can use sophisticated tools to **optimize pricing models** and provide **better liquidity** to their clients while avoiding costly arbitrage situations.\n",
    "\n",
    "### 7. **Market Insight and Data Analytics**\n",
    "Analyzing triangular arbitrage not only helps in identifying trading opportunities but also provides insights into how different currencies interact with one another. Banks and traders can derive useful metrics and **correlations between currency pairs**.\n",
    "\n",
    "- **Traders**: They can use this information to refine their strategies, build better **forecasting models**, and increase profitability in their currency trading.\n",
    "  \n",
    "- **Bankers**: For banks, **data analytics** of arbitrage opportunities can improve **risk management** practices and allow them to understand the deeper mechanics of global currency markets.\n",
    "\n",
    "### Conclusion:\n",
    "By analyzing triangular arbitrage opportunities, both **traders** and **bankers** can:\n",
    "- Capitalize on short-lived, low-risk profit opportunities.\n",
    "- Improve their **algorithmic trading systems**.\n",
    "- Ensure market prices remain **efficient** and **competitive**.\n",
    "- Avoid **unintentional financial losses** due to mispricing.\n",
    "- Gain **market insights** to better manage risks and enhance trading strategies.\n",
    "\n",
    "Ultimately, the ability to detect and analyze arbitrage opportunities can offer a clear **competitive advantage** in the Forex market."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Triangular arbitrage exists only when **pricing discrepancies** occur between the exchange rates of three currencies, creating an opportunity to profit by exchanging one currency for another in a loop and returning to the original currency with a profit. These opportunities can appear and disappear quickly due to several factors. Let’s explore why triangular arbitrage sometimes exists and why it doesn’t at other times.\n",
    "\n",
    "### Reasons Why Triangular Arbitrage Exists:\n",
    "\n",
    "1. **Market Inefficiencies**:\n",
    "   - Triangular arbitrage arises due to **inefficiencies in pricing** between currency pairs. These inefficiencies are often the result of differences in supply and demand across different currency markets. For example, if a currency is in high demand in one market but not another, its exchange rate might differ slightly, creating a window for arbitrage.\n",
    "   - **Latency in updating exchange rates** between different currency pairs also contributes to this. As financial markets update prices continuously, there can be brief moments where related exchange rates aren’t perfectly aligned.\n",
    "\n",
    "2. **Differences in Liquidity**:\n",
    "   - Not all currency pairs have the same **liquidity** (the ease with which an asset can be bought or sold). Major currency pairs (like EUR/USD or USD/JPY) tend to have high liquidity, and their prices adjust rapidly to market conditions. However, less liquid currency pairs might experience temporary imbalances in pricing, creating arbitrage opportunities.\n",
    "   - **Liquidity mismatches** between pairs can lead to triangular arbitrage, especially if one currency is more actively traded than another at a given time.\n",
    "\n",
    "3. **Exchange Rate Fluctuations**:\n",
    "   - Exchange rates fluctuate constantly due to various factors such as changes in interest rates, inflation, political events, and economic data releases. These fluctuations can sometimes create brief periods where **cross-rates** (calculated exchange rates between two currencies) deviate from what they should be, based on the individual exchange rates.\n",
    "   - During high volatility or **market shocks**, pricing inefficiencies may emerge as market participants respond differently across various currency pairs, causing temporary misalignment.\n",
    "\n",
    "4. **Latency in Data Feeds**:\n",
    "   - The existence of triangular arbitrage opportunities can be due to **data latency**—the delay in the time it takes for exchange rates to be updated across different platforms or trading venues. Even if the currency prices are correct at any given moment, differences in the speed at which the prices are updated can cause arbitrage opportunities.\n",
    "   - **High-frequency traders** and **algorithmic trading systems** can capitalize on these short-lived discrepancies before the markets adjust and the arbitrage opportunity disappears.\n",
    "\n",
    "5. **Differences in Market Participants**:\n",
    "   - **Market participants** include banks, institutional investors, retail traders, and hedge funds. These participants may have different trading strategies, information, and access to market data. When they act on their respective views of the market, the pressure they exert on buying and selling different currency pairs can lead to small imbalances in pricing.\n",
    "   - For example, if many traders start buying EUR/USD while others sell USD/JPY, the rates between these pairs may not stay aligned with EUR/JPY, causing a triangular arbitrage opportunity.\n",
    "\n",
    "### Reasons Why Triangular Arbitrage Disappears:\n",
    "\n",
    "1. **Market Efficiency**:\n",
    "   - In highly efficient markets, any **arbitrage opportunities** that appear are quickly exploited by traders. When many traders engage in triangular arbitrage, they cause the currency prices to move back into balance almost instantly.\n",
    "   - This process is called **price convergence**. As traders buy and sell the currencies involved in the arbitrage, the exchange rates will adjust, eliminating the opportunity.\n",
    "   \n",
    "2. **High Liquidity**:\n",
    "   - In the case of **highly liquid currency pairs**, there are large volumes of trading happening across various market participants (banks, traders, institutions), and the exchange rates update very quickly. This makes it less likely that arbitrage opportunities will exist for more than a fraction of a second.\n",
    "   - For pairs like EUR/USD, USD/JPY, and EUR/JPY, which are all very liquid, arbitrage opportunities are usually detected and closed extremely quickly, especially by **high-frequency trading (HFT) algorithms**.\n",
    "\n",
    "3. **Algorithmic and High-Frequency Trading**:\n",
    "   - **Algorithmic trading systems** and **high-frequency traders** are designed to detect and exploit arbitrage opportunities within milliseconds. These traders are constantly scanning the market for price discrepancies, and they execute trades almost immediately once an arbitrage opportunity arises.\n",
    "   - As these automated systems act on arbitrage, they effectively close the gap in pricing, causing the arbitrage opportunity to disappear before human traders can act.\n",
    "\n",
    "4. **Tight Spreads and Transaction Costs**:\n",
    "   - **Spreads** (the difference between the bid and ask prices) play a critical role in arbitrage. Even if there is a pricing discrepancy, if the spread is too wide or the **transaction costs** (such as fees or slippage) are too high, the arbitrage opportunity might not be profitable. In such cases, even if triangular arbitrage \"exists\" on paper, it doesn't present a real profit opportunity.\n",
    "   - In well-functioning markets, spreads tend to be narrow for major currency pairs, making it difficult for significant arbitrage opportunities to appear without being immediately closed by other traders.\n",
    "\n",
    "5. **Market Stabilization**:\n",
    "   - In the long run, currency markets tend to stabilize, especially for major currencies. Any brief moments of mispricing are quickly corrected as market participants adjust their positions based on new information. This market stabilization can occur due to large institutional traders who trade based on fundamentals, closing out any existing arbitrage.\n",
    "   - Additionally, central banks and major financial institutions that operate in the Forex market often intervene to stabilize their currencies, making arbitrage opportunities less frequent and harder to exploit.\n",
    "\n",
    "### Summary of Why Triangular Arbitrage Exists or Disappears:\n",
    "\n",
    "| **Exists** | **Disappears** |\n",
    "|------------|----------------|\n",
    "| Pricing inefficiencies due to differences in supply/demand or market shocks | Price efficiency is restored due to algorithmic and high-frequency trading |\n",
    "| Differences in liquidity between currency pairs | Arbitrage is quickly exploited and removed by active traders |\n",
    "| Exchange rate fluctuations or temporary market imbalance | Market liquidity and tight spreads reduce potential arbitrage profits |\n",
    "| Latency in data feeds across exchanges or trading platforms | Prices converge rapidly due to the high-speed execution of trades |\n",
    "| Different market participants (retail vs. institutional) acting in different currencies | Market stabilization and efficient pricing prevent arbitrage opportunities |\n",
    "\n",
    "### Conclusion:\n",
    "Triangular arbitrage is a rare and temporary phenomenon in the Forex market. It arises due to **market inefficiencies**, **latency**, and **price misalignments** between related currency pairs. However, these opportunities disappear almost as quickly as they appear due to the **efficient nature of currency markets**, **high-frequency trading**, and **price convergence** mechanisms. \n",
    "\n",
    "For traders, knowing when these opportunities arise can be valuable, but the ability to act quickly and efficiently is crucial to capturing profits before the opportunity vanishes."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}