_CHOCH_Strategy_EURUSD_H1.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/kaung-khant/CppBooks/blob/master/_CHOCH_Strategy_EURUSD_H1.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Q8Esk3XipkhX"
      },
      "source": [
        "# Change of Chararacter CHOCH"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "9cKbEBsSpkhc"
      },
      "source": [
        "### Load the data"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "ptXnbz0ypkhd"
      },
      "outputs": [],
      "source": [
        "import pandas as pd\n",
        "import pandas_ta as ta\n",
        "import pandas as pd\n",
        "import numpy as np\n",
        "import plotly.graph_objects as go\n",
        "from scipy import stats\n",
        "\n",
        "df = pd.read_csv(\"EURUSD_Candlestick_1_Hour_BID_04.05.2003-15.04.2023.csv\")\n",
        "df=df[df['volume']!=0]\n",
        "df.reset_index(drop=True, inplace=True)\n",
        "\n",
        "df['RSI'] = ta.rsi(df.close, length=12)\n",
        "df['EMA'] = ta.ema(df.close, length=150)\n",
        "df.tail()\n",
        "\n",
        "df=df[0:5000]"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "6CzPeXuDpkhf"
      },
      "source": [
        "### Trend detection"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "v9iRgTXRpkhg"
      },
      "outputs": [],
      "source": [
        "EMAsignal = [0]*len(df)\n",
        "backcandles = 15\n",
        "\n",
        "for row in range(backcandles, len(df)):\n",
        "    upt = 1\n",
        "    dnt = 1\n",
        "    for i in range(row-backcandles, row+1):\n",
        "        if max(df.open[i], df.close[i])>=df.EMA[i]:\n",
        "            dnt=0\n",
        "        if min(df.open[i], df.close[i])<=df.EMA[i]:\n",
        "            upt=0\n",
        "    if upt==1 and dnt==1:\n",
        "        EMAsignal[row]=3\n",
        "    elif upt==1:\n",
        "        EMAsignal[row]=2\n",
        "    elif dnt==1:\n",
        "        EMAsignal[row]=1\n",
        "\n",
        "df['EMASignal'] = EMAsignal"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "k9TMGYJypkhg"
      },
      "outputs": [],
      "source": [
        "def isPivot(candle, window):\n",
        "    \"\"\"\n",
        "    function that detects if a candle is a pivot/fractal point\n",
        "    args: candle index, window before and after candle to test if pivot\n",
        "    returns: 1 if pivot high, 2 if pivot low, 3 if both and 0 default\n",
        "    \"\"\"\n",
        "    if candle-window < 0 or candle+window >= len(df):\n",
        "        return 0\n",
        "\n",
        "    pivotHigh = 1\n",
        "    pivotLow = 2\n",
        "    for i in range(candle-window, candle+window+1):\n",
        "        if df.iloc[candle].low > df.iloc[i].low:\n",
        "            pivotLow=0\n",
        "        if df.iloc[candle].high < df.iloc[i].high:\n",
        "            pivotHigh=0\n",
        "    if (pivotHigh and pivotLow):\n",
        "        return 3\n",
        "    elif pivotHigh:\n",
        "        return pivotHigh\n",
        "    elif pivotLow:\n",
        "        return pivotLow\n",
        "    else:\n",
        "        return 0"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "kQ3NIP4lpkhh"
      },
      "outputs": [],
      "source": [
        "window=5\n",
        "df['isPivot'] = df.apply(lambda x: isPivot(x.name,window), axis=1)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "_7dX3iOepkhj"
      },
      "outputs": [],
      "source": [
        "def pointpos(x):\n",
        "    if x['isPivot']==2:\n",
        "        return x['low']-1e-3\n",
        "    elif x['isPivot']==1:\n",
        "        return x['high']+1e-3\n",
        "    else:\n",
        "        return np.nan\n",
        "df['pointpos'] = df.apply(lambda row: pointpos(row), axis=1)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "TTHK05nepkhk",
        "outputId": "cfa2d26a-6462-4e6d-db85-feb02f47ebd4"
      },
      "outputs": [
        {
          "data": {
            "application/vnd.plotly.v1+json": {
              "config": {
                "plotlyServerURL": "https://plot.ly"
              },
              "data": [
                {
                  "close": [
                    1.17131,
                    1.17105,
                    1.17065,
                    1.16839,
                    1.1675,
                    1.17281,
                    1.16957,
                    1.17043,
                    1.16992,
                    1.16949,
                    1.16696,
                    1.16716,
                    1.1635,
                    1.1638,
                    1.16404,
                    1.16525,
                    1.16429,
                    1.16269,
                    1.16328,
                    1.16422,
                    1.16454,
                    1.16386,
                    1.16325,
                    1.16438,
                    1.16691,
                    1.16754,
                    1.16933,
                    1.17147,
                    1.1712,
                    1.16877,
                    1.16799,
                    1.16966,
                    1.16875,
                    1.16988,
                    1.16962,
                    1.16908,
                    1.16991,
                    1.16901,
                    1.16908,
                    1.16786,
                    1.16696,
                    1.1682,
                    1.16804,
                    1.16768,
                    1.16737,
                    1.16766,
                    1.1685,
                    1.17111,
                    1.17845,
                    1.17928,
                    1.17878,
                    1.17885,
                    1.17782,
                    1.17813,
                    1.17818,
                    1.17803,
                    1.17985,
                    1.1827,
                    1.18304,
                    1.18236,
                    1.18243,
                    1.18268,
                    1.18177,
                    1.18123,
                    1.18102,
                    1.18128,
                    1.18118,
                    1.18174,
                    1.18201,
                    1.18192,
                    1.18085,
                    1.18053,
                    1.18075,
                    1.18135,
                    1.18099,
                    1.1809,
                    1.18126,
                    1.18419,
                    1.18617,
                    1.18598,
                    1.18681,
                    1.18667,
                    1.18711,
                    1.1866,
                    1.18692,
                    1.18574,
                    1.18567,
                    1.18604,
                    1.18878,
                    1.18795,
                    1.18841,
                    1.18867,
                    1.18441,
                    1.18331,
                    1.18657,
                    1.18787,
                    1.18977,
                    1.19023,
                    1.19074,
                    1.1895,
                    1.19006,
                    1.19057,
                    1.18706,
                    1.1852,
                    1.1866,
                    1.18666,
                    1.18565,
                    1.18258,
                    1.18076,
                    1.18119,
                    1.18102,
                    1.181,
                    1.18166,
                    1.18258,
                    1.18266,
                    1.18318,
                    1.18405,
                    1.18396,
                    1.18202,
                    1.17675,
                    1.17858,
                    1.17776,
                    1.17297,
                    1.1718,
                    1.17506,
                    1.17471,
                    1.17414,
                    1.17413,
                    1.17618,
                    1.17587,
                    1.17597,
                    1.17619,
                    1.17629,
                    1.1751,
                    1.17516,
                    1.17524,
                    1.17634,
                    1.17406,
                    1.17354,
                    1.17419,
                    1.17463,
                    1.1759,
                    1.1743,
                    1.1702,
                    1.17058,
                    1.17074,
                    1.17408,
                    1.17586,
                    1.17577,
                    1.17659
                  ],
                  "high": [
                    1.17229,
                    1.17191,
                    1.17183,
                    1.17095,
                    1.16898,
                    1.17395,
                    1.17311,
                    1.17086,
                    1.17174,
                    1.17029,
                    1.16973,
                    1.16824,
                    1.16803,
                    1.1652,
                    1.16478,
                    1.16561,
                    1.16575,
                    1.16447,
                    1.16391,
                    1.16478,
                    1.16525,
                    1.16529,
                    1.16456,
                    1.16538,
                    1.16781,
                    1.16794,
                    1.17128,
                    1.17166,
                    1.17266,
                    1.17184,
                    1.17089,
                    1.17074,
                    1.17133,
                    1.17223,
                    1.17046,
                    1.16978,
                    1.17038,
                    1.17004,
                    1.16992,
                    1.16979,
                    1.168,
                    1.16895,
                    1.16921,
                    1.16812,
                    1.16801,
                    1.16801,
                    1.16902,
                    1.17164,
                    1.17869,
                    1.18079,
                    1.18063,
                    1.18056,
                    1.17977,
                    1.17889,
                    1.17938,
                    1.1788,
                    1.18165,
                    1.18314,
                    1.18363,
                    1.18347,
                    1.18296,
                    1.18332,
                    1.18282,
                    1.18211,
                    1.18165,
                    1.18162,
                    1.18206,
                    1.18193,
                    1.1827,
                    1.18272,
                    1.18207,
                    1.1812,
                    1.18211,
                    1.18223,
                    1.18188,
                    1.18155,
                    1.18151,
                    1.18491,
                    1.18656,
                    1.18677,
                    1.18722,
                    1.18701,
                    1.18721,
                    1.18744,
                    1.18705,
                    1.18742,
                    1.18607,
                    1.18631,
                    1.18962,
                    1.18979,
                    1.18882,
                    1.18933,
                    1.19067,
                    1.18535,
                    1.18703,
                    1.18985,
                    1.19031,
                    1.19113,
                    1.19223,
                    1.19127,
                    1.19025,
                    1.19168,
                    1.19286,
                    1.18735,
                    1.18716,
                    1.1875,
                    1.18708,
                    1.18572,
                    1.18266,
                    1.1818,
                    1.18138,
                    1.1825,
                    1.18189,
                    1.18289,
                    1.18324,
                    1.18412,
                    1.18439,
                    1.18423,
                    1.18397,
                    1.18353,
                    1.17925,
                    1.17967,
                    1.17778,
                    1.17346,
                    1.17599,
                    1.17576,
                    1.17749,
                    1.17574,
                    1.17654,
                    1.1779,
                    1.17691,
                    1.17627,
                    1.17693,
                    1.17661,
                    1.17545,
                    1.17591,
                    1.17689,
                    1.17667,
                    1.1746,
                    1.1752,
                    1.17557,
                    1.17682,
                    1.17623,
                    1.17516,
                    1.17267,
                    1.17181,
                    1.17583,
                    1.17768,
                    1.1769,
                    1.1789
                  ],
                  "low": [
                    1.17012,
                    1.17039,
                    1.16971,
                    1.16738,
                    1.1661,
                    1.16673,
                    1.1676,
                    1.16829,
                    1.1696,
                    1.16874,
                    1.16651,
                    1.16658,
                    1.16349,
                    1.16226,
                    1.16275,
                    1.16417,
                    1.16372,
                    1.16226,
                    1.16227,
                    1.16316,
                    1.16397,
                    1.16327,
                    1.16181,
                    1.16308,
                    1.16482,
                    1.16626,
                    1.16739,
                    1.16863,
                    1.1705,
                    1.16779,
                    1.16705,
                    1.16738,
                    1.16835,
                    1.1683,
                    1.16904,
                    1.16847,
                    1.16789,
                    1.16866,
                    1.16894,
                    1.16731,
                    1.16638,
                    1.16684,
                    1.16746,
                    1.16735,
                    1.16682,
                    1.16635,
                    1.16658,
                    1.1681,
                    1.17134,
                    1.17835,
                    1.17806,
                    1.17792,
                    1.17743,
                    1.177,
                    1.17682,
                    1.17675,
                    1.17831,
                    1.17969,
                    1.18211,
                    1.18209,
                    1.18168,
                    1.18224,
                    1.18144,
                    1.18082,
                    1.18035,
                    1.18047,
                    1.18067,
                    1.18083,
                    1.18147,
                    1.18109,
                    1.18054,
                    1.17955,
                    1.18041,
                    1.18074,
                    1.1805,
                    1.18043,
                    1.18052,
                    1.18059,
                    1.18287,
                    1.18478,
                    1.18557,
                    1.18612,
                    1.18646,
                    1.18646,
                    1.186,
                    1.18565,
                    1.18507,
                    1.1844,
                    1.18613,
                    1.18785,
                    1.18763,
                    1.18798,
                    1.18416,
                    1.18166,
                    1.18217,
                    1.18524,
                    1.18776,
                    1.18819,
                    1.18896,
                    1.18922,
                    1.18894,
                    1.18951,
                    1.18605,
                    1.18484,
                    1.18478,
                    1.18575,
                    1.18528,
                    1.18239,
                    1.1807,
                    1.18073,
                    1.1807,
                    1.181,
                    1.18102,
                    1.18119,
                    1.18209,
                    1.18263,
                    1.18295,
                    1.18293,
                    1.18155,
                    1.17599,
                    1.17651,
                    1.1773,
                    1.17213,
                    1.17037,
                    1.17095,
                    1.17295,
                    1.17364,
                    1.17204,
                    1.17193,
                    1.17465,
                    1.17538,
                    1.17524,
                    1.17551,
                    1.17437,
                    1.17396,
                    1.17439,
                    1.17483,
                    1.17317,
                    1.17307,
                    1.17334,
                    1.17372,
                    1.17462,
                    1.17333,
                    1.17004,
                    1.16933,
                    1.16909,
                    1.17014,
                    1.17366,
                    1.17397,
                    1.17536
                  ],
                  "open": [
                    1.1712,
                    1.17133,
                    1.17096,
                    1.17056,
                    1.16815,
                    1.16731,
                    1.17271,
                    1.1694,
                    1.1705,
                    1.16989,
                    1.16906,
                    1.167,
                    1.16654,
                    1.16354,
                    1.16383,
                    1.16424,
                    1.16521,
                    1.16396,
                    1.16288,
                    1.16326,
                    1.16429,
                    1.16436,
                    1.16384,
                    1.16343,
                    1.16507,
                    1.16686,
                    1.16739,
                    1.16944,
                    1.17152,
                    1.17138,
                    1.16826,
                    1.16757,
                    1.16955,
                    1.16847,
                    1.1699,
                    1.16931,
                    1.16877,
                    1.16968,
                    1.16899,
                    1.16892,
                    1.16774,
                    1.16719,
                    1.16825,
                    1.16803,
                    1.16732,
                    1.16711,
                    1.16778,
                    1.16826,
                    1.17179,
                    1.17872,
                    1.17937,
                    1.17895,
                    1.17884,
                    1.1773,
                    1.17834,
                    1.17802,
                    1.17838,
                    1.17996,
                    1.18259,
                    1.18306,
                    1.182,
                    1.18261,
                    1.18255,
                    1.18158,
                    1.18113,
                    1.181,
                    1.18082,
                    1.1813,
                    1.18172,
                    1.18208,
                    1.18201,
                    1.18069,
                    1.1808,
                    1.18089,
                    1.1816,
                    1.1809,
                    1.18084,
                    1.18106,
                    1.18447,
                    1.18625,
                    1.18563,
                    1.18637,
                    1.18675,
                    1.18703,
                    1.186,
                    1.18659,
                    1.1856,
                    1.18548,
                    1.18636,
                    1.18869,
                    1.18795,
                    1.18836,
                    1.1887,
                    1.18401,
                    1.18342,
                    1.18677,
                    1.18821,
                    1.18965,
                    1.1899,
                    1.19081,
                    1.18924,
                    1.19008,
                    1.19028,
                    1.18657,
                    1.18507,
                    1.18658,
                    1.18661,
                    1.18542,
                    1.18191,
                    1.18073,
                    1.1811,
                    1.18107,
                    1.18145,
                    1.18146,
                    1.18236,
                    1.18285,
                    1.1834,
                    1.18379,
                    1.18388,
                    1.18199,
                    1.17692,
                    1.17837,
                    1.17759,
                    1.17258,
                    1.17187,
                    1.1751,
                    1.17509,
                    1.17367,
                    1.17384,
                    1.17651,
                    1.17625,
                    1.17601,
                    1.17587,
                    1.17634,
                    1.17497,
                    1.17522,
                    1.17538,
                    1.17659,
                    1.1736,
                    1.17334,
                    1.17414,
                    1.17487,
                    1.17565,
                    1.1743,
                    1.17057,
                    1.17034,
                    1.17108,
                    1.1742,
                    1.17614,
                    1.17592
                  ],
                  "type": "candlestick",
                  "x": [
                    300,
                    301,
                    302,
                    303,
                    304,
                    305,
                    306,
                    307,
                    308,
                    309,
                    310,
                    311,
                    312,
                    313,
                    314,
                    315,
                    316,
                    317,
                    318,
                    319,
                    320,
                    321,
                    322,
                    323,
                    324,
                    325,
                    326,
                    327,
                    328,
                    329,
                    330,
                    331,
                    332,
                    333,
                    334,
                    335,
                    336,
                    337,
                    338,
                    339,
                    340,
                    341,
                    342,
                    343,
                    344,
                    345,
                    346,
                    347,
                    348,
                    349,
                    350,
                    351,
                    352,
                    353,
                    354,
                    355,
                    356,
                    357,
                    358,
                    359,
                    360,
                    361,
                    362,
                    363,
                    364,
                    365,
                    366,
                    367,
                    368,
                    369,
                    370,
                    371,
                    372,
                    373,
                    374,
                    375,
                    376,
                    377,
                    378,
                    379,
                    380,
                    381,
                    382,
                    383,
                    384,
                    385,
                    386,
                    387,
                    388,
                    389,
                    390,
                    391,
                    392,
                    393,
                    394,
                    395,
                    396,
                    397,
                    398,
                    399,
                    400,
                    401,
                    402,
                    403,
                    404,
                    405,
                    406,
                    407,
                    408,
                    409,
                    410,
                    411,
                    412,
                    413,
                    414,
                    415,
                    416,
                    417,
                    418,
                    419,
                    420,
                    421,
                    422,
                    423,
                    424,
                    425,
                    426,
                    427,
                    428,
                    429,
                    430,
                    431,
                    432,
                    433,
                    434,
                    435,
                    436,
                    437,
                    438,
                    439,
                    440,
                    441,
                    442,
                    443,
                    444,
                    445,
                    446,
                    447,
                    448,
                    449
                  ]
                },
                {
                  "marker": {
                    "color": "MediumPurple",
                    "size": 5
                  },
                  "mode": "markers",
                  "name": "pivot",
                  "type": "scatter",
                  "x": [
                    300,
                    301,
                    302,
                    303,
                    304,
                    305,
                    306,
                    307,
                    308,
                    309,
                    310,
                    311,
                    312,
                    313,
                    314,
                    315,
                    316,
                    317,
                    318,
                    319,
                    320,
                    321,
                    322,
                    323,
                    324,
                    325,
                    326,
                    327,
                    328,
                    329,
                    330,
                    331,
                    332,
                    333,
                    334,
                    335,
                    336,
                    337,
                    338,
                    339,
                    340,
                    341,
                    342,
                    343,
                    344,
                    345,
                    346,
                    347,
                    348,
                    349,
                    350,
                    351,
                    352,
                    353,
                    354,
                    355,
                    356,
                    357,
                    358,
                    359,
                    360,
                    361,
                    362,
                    363,
                    364,
                    365,
                    366,
                    367,
                    368,
                    369,
                    370,
                    371,
                    372,
                    373,
                    374,
                    375,
                    376,
                    377,
                    378,
                    379,
                    380,
                    381,
                    382,
                    383,
                    384,
                    385,
                    386,
                    387,
                    388,
                    389,
                    390,
                    391,
                    392,
                    393,
                    394,
                    395,
                    396,
                    397,
                    398,
                    399,
                    400,
                    401,
                    402,
                    403,
                    404,
                    405,
                    406,
                    407,
                    408,
                    409,
                    410,
                    411,
                    412,
                    413,
                    414,
                    415,
                    416,
                    417,
                    418,
                    419,
                    420,
                    421,
                    422,
                    423,
                    424,
                    425,
                    426,
                    427,
                    428,
                    429,
                    430,
                    431,
                    432,
                    433,
                    434,
                    435,
                    436,
                    437,
                    438,
                    439,
                    440,
                    441,
                    442,
                    443,
                    444,
                    445,
                    446,
                    447,
                    448,
                    449
                  ],
                  "y": [
                    null,
                    null,
                    null,
                    null,
                    1.1651,
                    1.17495,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    1.1612600000000002,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    1.1608100000000001,
                    null,
                    null,
                    null,
                    null,
                    null,
                    1.17366,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    1.16535,
                    null,
                    null,
                    null,
                    1.18179,
                    null,
                    null,
                    null,
                    null,
                    null,
                    1.17575,
                    null,
                    null,
                    1.1846299999999998,
                    null,
                    null,
                    null,
                    null,
                    null,
                    1.1793500000000001,
                    null,
                    null,
                    null,
                    null,
                    1.1837199999999999,
                    null,
                    1.1785500000000002,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    1.18066,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    1.19386,
                    null,
                    null,
                    null,
                    null,
                    null,
                    1.1797000000000002,
                    null,
                    1.1797000000000002,
                    null,
                    null,
                    null,
                    null,
                    null,
                    1.18539,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    1.16937,
                    null,
                    null,
                    null,
                    null,
                    null,
                    1.1788999999999998,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    null,
                    1.16809,
                    null,
                    null,
                    null,
                    null
                  ]
                }
              ],
              "layout": {
                "template": {
                  "data": {
                    "bar": [
                      {
                        "error_x": {
                          "color": "#2a3f5f"
                        },
                        "error_y": {
                          "color": "#2a3f5f"
                        },
                        "marker": {
                          "line": {
                            "color": "#E5ECF6",
                            "width": 0.5
                          },
                          "pattern": {
                            "fillmode": "overlay",
                            "size": 10,
                            "solidity": 0.2
                          }
                        },
                        "type": "bar"
                      }
                    ],
                    "barpolar": [
                      {
                        "marker": {
                          "line": {
                            "color": "#E5ECF6",
                            "width": 0.5
                          },
                          "pattern": {
                            "fillmode": "overlay",
                            "size": 10,
                            "solidity": 0.2
                          }
                        },
                        "type": "barpolar"
                      }
                    ],
                    "carpet": [
                      {
                        "aaxis": {
                          "endlinecolor": "#2a3f5f",
                          "gridcolor": "white",
                          "linecolor": "white",
                          "minorgridcolor": "white",
                          "startlinecolor": "#2a3f5f"
                        },
                        "baxis": {
                          "endlinecolor": "#2a3f5f",
                          "gridcolor": "white",
                          "linecolor": "white",
                          "minorgridcolor": "white",
                          "startlinecolor": "#2a3f5f"
                        },
                        "type": "carpet"
                      }
                    ],
                    "choropleth": [
                      {
                        "colorbar": {
                          "outlinewidth": 0,
                          "ticks": ""
                        },
                        "type": "choropleth"
                      }
                    ],
                    "contour": [
                      {
                        "colorbar": {
                          "outlinewidth": 0,
                          "ticks": ""
                        },
                        "colorscale": [
                          [
                            0,
                            "#0d0887"
                          ],
                          [
                            0.1111111111111111,
                            "#46039f"
                          ],
                          [
                            0.2222222222222222,
                            "#7201a8"
                          ],
                          [
                            0.3333333333333333,
                            "#9c179e"
                          ],
                          [
                            0.4444444444444444,
                            "#bd3786"
                          ],
                          [
                            0.5555555555555556,
                            "#d8576b"
                          ],
                          [
                            0.6666666666666666,
                            "#ed7953"
                          ],
                          [
                            0.7777777777777778,
                            "#fb9f3a"
                          ],
                          [
                            0.8888888888888888,
                            "#fdca26"
                          ],
                          [
                            1,
                            "#f0f921"
                          ]
                        ],
                        "type": "contour"
                      }
                    ],
                    "contourcarpet": [
                      {
                        "colorbar": {
                          "outlinewidth": 0,
                          "ticks": ""
                        },
                        "type": "contourcarpet"
                      }
                    ],
                    "heatmap": [
                      {
                        "colorbar": {
                          "outlinewidth": 0,
                          "ticks": ""
                        },
                        "colorscale": [
                          [
                            0,
                            "#0d0887"
                          ],
                          [
                            0.1111111111111111,
                            "#46039f"
                          ],
                          [
                            0.2222222222222222,
                            "#7201a8"
                          ],
                          [
                            0.3333333333333333,
                            "#9c179e"
                          ],
                          [
                            0.4444444444444444,
                            "#bd3786"
                          ],
                          [
                            0.5555555555555556,
                            "#d8576b"
                          ],
                          [
                            0.6666666666666666,
                            "#ed7953"
                          ],
                          [
                            0.7777777777777778,
                            "#fb9f3a"
                          ],
                          [
                            0.8888888888888888,
                            "#fdca26"
                          ],
                          [
                            1,
                            "#f0f921"
                          ]
                        ],
                        "type": "heatmap"
                      }
                    ],
                    "heatmapgl": [
                      {
                        "colorbar": {
                          "outlinewidth": 0,
                          "ticks": ""
                        },
                        "colorscale": [
                          [
                            0,
                            "#0d0887"
                          ],
                          [
                            0.1111111111111111,
                            "#46039f"
                          ],
                          [
                            0.2222222222222222,
                            "#7201a8"
                          ],
                          [
                            0.3333333333333333,
                            "#9c179e"
                          ],
                          [
                            0.4444444444444444,
                            "#bd3786"
                          ],
                          [
                            0.5555555555555556,
                            "#d8576b"
                          ],
                          [
                            0.6666666666666666,
                            "#ed7953"
                          ],
                          [
                            0.7777777777777778,
                            "#fb9f3a"
                          ],
                          [
                            0.8888888888888888,
                            "#fdca26"
                          ],
                          [
                            1,
                            "#f0f921"
                          ]
                        ],
                        "type": "heatmapgl"
                      }
                    ],
                    "histogram": [
                      {
                        "marker": {
                          "pattern": {
                            "fillmode": "overlay",
                            "size": 10,
                            "solidity": 0.2
                          }
                        },
                        "type": "histogram"
                      }
                    ],
                    "histogram2d": [
                      {
                        "colorbar": {
                          "outlinewidth": 0,
                          "ticks": ""
                        },
                        "colorscale": [
                          [
                            0,
                            "#0d0887"
                          ],
                          [
                            0.1111111111111111,
                            "#46039f"
                          ],
                          [
                            0.2222222222222222,
                            "#7201a8"
                          ],
                          [
                            0.3333333333333333,
                            "#9c179e"
                          ],
                          [
                            0.4444444444444444,
                            "#bd3786"
                          ],
                          [
                            0.5555555555555556,
                            "#d8576b"
                          ],
                          [
                            0.6666666666666666,
                            "#ed7953"
                          ],
                          [
                            0.7777777777777778,
                            "#fb9f3a"
                          ],
                          [
                            0.8888888888888888,
                            "#fdca26"
                          ],
                          [
                            1,
                            "#f0f921"
                          ]
                        ],
                        "type": "histogram2d"
                      }
                    ],
                    "histogram2dcontour": [
                      {
                        "colorbar": {
                          "outlinewidth": 0,
                          "ticks": ""
                        },
                        "colorscale": [
                          [
                            0,
                            "#0d0887"
                          ],
                          [
                            0.1111111111111111,
                            "#46039f"
                          ],
                          [
                            0.2222222222222222,
                            "#7201a8"
                          ],
                          [
                            0.3333333333333333,
                            "#9c179e"
                          ],
                          [
                            0.4444444444444444,
                            "#bd3786"
                          ],
                          [
                            0.5555555555555556,
                            "#d8576b"
                          ],
                          [
                            0.6666666666666666,
                            "#ed7953"
                          ],
                          [
                            0.7777777777777778,
                            "#fb9f3a"
                          ],
                          [
                            0.8888888888888888,
                            "#fdca26"
                          ],
                          [
                            1,
                            "#f0f921"
                          ]
                        ],
                        "type": "histogram2dcontour"
                      }
                    ],
                    "mesh3d": [
                      {
                        "colorbar": {
                          "outlinewidth": 0,
                          "ticks": ""
                        },
                        "type": "mesh3d"
                      }
                    ],
                    "parcoords": [
                      {
                        "line": {
                          "colorbar": {
                            "outlinewidth": 0,
                            "ticks": ""
                          }
                        },
                        "type": "parcoords"
                      }
                    ],
                    "pie": [
                      {
                        "automargin": true,
                        "type": "pie"
                      }
                    ],
                    "scatter": [
                      {
                        "fillpattern": {
                          "fillmode": "overlay",
                          "size": 10,
                          "solidity": 0.2
                        },
                        "type": "scatter"
                      }
                    ],
                    "scatter3d": [
                      {
                        "line": {
                          "colorbar": {
                            "outlinewidth": 0,
                            "ticks": ""
                          }
                        },
                        "marker": {
                          "colorbar": {
                            "outlinewidth": 0,
                            "ticks": ""
                          }
                        },
                        "type": "scatter3d"
                      }
                    ],
                    "scattercarpet": [
                      {
                        "marker": {
                          "colorbar": {
                            "outlinewidth": 0,
                            "ticks": ""
                          }
                        },
                        "type": "scattercarpet"
                      }
                    ],
                    "scattergeo": [
                      {
                        "marker": {
                          "colorbar": {
                            "outlinewidth": 0,
                            "ticks": ""
                          }
                        },
                        "type": "scattergeo"
                      }
                    ],
                    "scattergl": [
                      {
                        "marker": {
                          "colorbar": {
                            "outlinewidth": 0,
                            "ticks": ""
                          }
                        },
                        "type": "scattergl"
                      }
                    ],
                    "scattermapbox": [
                      {
                        "marker": {
                          "colorbar": {
                            "outlinewidth": 0,
                            "ticks": ""
                          }
                        },
                        "type": "scattermapbox"
                      }
                    ],
                    "scatterpolar": [
                      {
                        "marker": {
                          "colorbar": {
                            "outlinewidth": 0,
                            "ticks": ""
                          }
                        },
                        "type": "scatterpolar"
                      }
                    ],
                    "scatterpolargl": [
                      {
                        "marker": {
                          "colorbar": {
                            "outlinewidth": 0,
                            "ticks": ""
                          }
                        },
                        "type": "scatterpolargl"
                      }
                    ],
                    "scatterternary": [
                      {
                        "marker": {
                          "colorbar": {
                            "outlinewidth": 0,
                            "ticks": ""
                          }
                        },
                        "type": "scatterternary"
                      }
                    ],
                    "surface": [
                      {
                        "colorbar": {
                          "outlinewidth": 0,
                          "ticks": ""
                        },
                        "colorscale": [
                          [
                            0,
                            "#0d0887"
                          ],
                          [
                            0.1111111111111111,
                            "#46039f"
                          ],
                          [
                            0.2222222222222222,
                            "#7201a8"
                          ],
                          [
                            0.3333333333333333,
                            "#9c179e"
                          ],
                          [
                            0.4444444444444444,
                            "#bd3786"
                          ],
                          [
                            0.5555555555555556,
                            "#d8576b"
                          ],
                          [
                            0.6666666666666666,
                            "#ed7953"
                          ],
                          [
                            0.7777777777777778,
                            "#fb9f3a"
                          ],
                          [
                            0.8888888888888888,
                            "#fdca26"
                          ],
                          [
                            1,
                            "#f0f921"
                          ]
                        ],
                        "type": "surface"
                      }
                    ],
                    "table": [
                      {
                        "cells": {
                          "fill": {
                            "color": "#EBF0F8"
                          },
                          "line": {
                            "color": "white"
                          }
                        },
                        "header": {
                          "fill": {
                            "color": "#C8D4E3"
                          },
                          "line": {
                            "color": "white"
                          }
                        },
                        "type": "table"
                      }
                    ]
                  },
                  "layout": {
                    "annotationdefaults": {
                      "arrowcolor": "#2a3f5f",
                      "arrowhead": 0,
                      "arrowwidth": 1
                    },
                    "autotypenumbers": "strict",
                    "coloraxis": {
                      "colorbar": {
                        "outlinewidth": 0,
                        "ticks": ""
                      }
                    },
                    "colorscale": {
                      "diverging": [
                        [
                          0,
                          "#8e0152"
                        ],
                        [
                          0.1,
                          "#c51b7d"
                        ],
                        [
                          0.2,
                          "#de77ae"
                        ],
                        [
                          0.3,
                          "#f1b6da"
                        ],
                        [
                          0.4,
                          "#fde0ef"
                        ],
                        [
                          0.5,
                          "#f7f7f7"
                        ],
                        [
                          0.6,
                          "#e6f5d0"
                        ],
                        [
                          0.7,
                          "#b8e186"
                        ],
                        [
                          0.8,
                          "#7fbc41"
                        ],
                        [
                          0.9,
                          "#4d9221"
                        ],
                        [
                          1,
                          "#276419"
                        ]
                      ],
                      "sequential": [
                        [
                          0,
                          "#0d0887"
                        ],
                        [
                          0.1111111111111111,
                          "#46039f"
                        ],
                        [
                          0.2222222222222222,
                          "#7201a8"
                        ],
                        [
                          0.3333333333333333,
                          "#9c179e"
                        ],
                        [
                          0.4444444444444444,
                          "#bd3786"
                        ],
                        [
                          0.5555555555555556,
                          "#d8576b"
                        ],
                        [
                          0.6666666666666666,
                          "#ed7953"
                        ],
                        [
                          0.7777777777777778,
                          "#fb9f3a"
                        ],
                        [
                          0.8888888888888888,
                          "#fdca26"
                        ],
                        [
                          1,
                          "#f0f921"
                        ]
                      ],
                      "sequentialminus": [
                        [
                          0,
                          "#0d0887"
                        ],
                        [
                          0.1111111111111111,
                          "#46039f"
                        ],
                        [
                          0.2222222222222222,
                          "#7201a8"
                        ],
                        [
                          0.3333333333333333,
                          "#9c179e"
                        ],
                        [
                          0.4444444444444444,
                          "#bd3786"
                        ],
                        [
                          0.5555555555555556,
                          "#d8576b"
                        ],
                        [
                          0.6666666666666666,
                          "#ed7953"
                        ],
                        [
                          0.7777777777777778,
                          "#fb9f3a"
                        ],
                        [
                          0.8888888888888888,
                          "#fdca26"
                        ],
                        [
                          1,
                          "#f0f921"
                        ]
                      ]
                    },
                    "colorway": [
                      "#636efa",
                      "#EF553B",
                      "#00cc96",
                      "#ab63fa",
                      "#FFA15A",
                      "#19d3f3",
                      "#FF6692",
                      "#B6E880",
                      "#FF97FF",
                      "#FECB52"
                    ],
                    "font": {
                      "color": "#2a3f5f"
                    },
                    "geo": {
                      "bgcolor": "white",
                      "lakecolor": "white",
                      "landcolor": "#E5ECF6",
                      "showlakes": true,
                      "showland": true,
                      "subunitcolor": "white"
                    },
                    "hoverlabel": {
                      "align": "left"
                    },
                    "hovermode": "closest",
                    "mapbox": {
                      "style": "light"
                    },
                    "paper_bgcolor": "white",
                    "plot_bgcolor": "#E5ECF6",
                    "polar": {
                      "angularaxis": {
                        "gridcolor": "white",
                        "linecolor": "white",
                        "ticks": ""
                      },
                      "bgcolor": "#E5ECF6",
                      "radialaxis": {
                        "gridcolor": "white",
                        "linecolor": "white",
                        "ticks": ""
                      }
                    },
                    "scene": {
                      "xaxis": {
                        "backgroundcolor": "#E5ECF6",
                        "gridcolor": "white",
                        "gridwidth": 2,
                        "linecolor": "white",
                        "showbackground": true,
                        "ticks": "",
                        "zerolinecolor": "white"
                      },
                      "yaxis": {
                        "backgroundcolor": "#E5ECF6",
                        "gridcolor": "white",
                        "gridwidth": 2,
                        "linecolor": "white",
                        "showbackground": true,
                        "ticks": "",
                        "zerolinecolor": "white"
                      },
                      "zaxis": {
                        "backgroundcolor": "#E5ECF6",
                        "gridcolor": "white",
                        "gridwidth": 2,
                        "linecolor": "white",
                        "showbackground": true,
                        "ticks": "",
                        "zerolinecolor": "white"
                      }
                    },
                    "shapedefaults": {
                      "line": {
                        "color": "#2a3f5f"
                      }
                    },
                    "ternary": {
                      "aaxis": {
                        "gridcolor": "white",
                        "linecolor": "white",
                        "ticks": ""
                      },
                      "baxis": {
                        "gridcolor": "white",
                        "linecolor": "white",
                        "ticks": ""
                      },
                      "bgcolor": "#E5ECF6",
                      "caxis": {
                        "gridcolor": "white",
                        "linecolor": "white",
                        "ticks": ""
                      }
                    },
                    "title": {
                      "x": 0.05
                    },
                    "xaxis": {
                      "automargin": true,
                      "gridcolor": "white",
                      "linecolor": "white",
                      "ticks": "",
                      "title": {
                        "standoff": 15
                      },
                      "zerolinecolor": "white",
                      "zerolinewidth": 2
                    },
                    "yaxis": {
                      "automargin": true,
                      "gridcolor": "white",
                      "linecolor": "white",
                      "ticks": "",
                      "title": {
                        "standoff": 15
                      },
                      "zerolinecolor": "white",
                      "zerolinewidth": 2
                    }
                  }
                },
                "xaxis": {
                  "rangeslider": {
                    "visible": false
                  }
                }
              }
            }
          },
          "metadata": {},
          "output_type": "display_data"
        }
      ],
      "source": [
        "dfpl = df[300:450]\n",
        "fig = go.Figure(data=[go.Candlestick(x=dfpl.index,\n",
        "                open=dfpl['open'],\n",
        "                high=dfpl['high'],\n",
        "                low=dfpl['low'],\n",
        "                close=dfpl['close'])])\n",
        "\n",
        "fig.add_scatter(x=dfpl.index, y=dfpl['pointpos'], mode=\"markers\",\n",
        "                marker=dict(size=5, color=\"MediumPurple\"),\n",
        "                name=\"pivot\")\n",
        "fig.update_layout(xaxis_rangeslider_visible=False)\n",
        "fig.show()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "mbCQWE81pkhm"
      },
      "outputs": [],
      "source": [
        "def detect_structure(candle, backcandles, window):\n",
        "    \"\"\"\n",
        "    Attention! window should always be greater than the pivot window! to avoid look ahead bias\n",
        "    \"\"\"\n",
        "    localdf = df[candle-backcandles-window:candle-window]\n",
        "    highs = localdf[localdf['isPivot'] == 1].high.tail(3).values\n",
        "    idxhighs = localdf[localdf['isPivot'] == 1].high.tail(3).index\n",
        "    lows = localdf[localdf['isPivot'] == 2].low.tail(3).values\n",
        "    idxlows = localdf[localdf['isPivot'] == 2].low.tail(3).index\n",
        "\n",
        "    pattern_detected = False\n",
        "\n",
        "    lim1 = 0.005\n",
        "    lim2 = lim1/3\n",
        "    if len(highs) == 3 and len(lows) == 3:\n",
        "        order_condition = (idxlows[0] < idxhighs[0]\n",
        "                           < idxlows[1] < idxhighs[1]\n",
        "                           < idxlows[2] < idxhighs[2])\n",
        "        diff_condition = (\n",
        "                            abs(lows[0]-highs[0])>lim1 and\n",
        "                            abs(highs[0]-lows[1])>lim2 and\n",
        "                            abs(highs[1]-lows[1])>lim1 and\n",
        "                            abs(highs[1]-lows[2])>lim2\n",
        "                            )\n",
        "        pattern_1 = (lows[0] < highs[0] and\n",
        "            lows[1] > lows[0] and lows[1] < highs[0] and\n",
        "            highs[1] > highs[0] and\n",
        "            lows[2] > lows[1] and lows[2] < highs[1] and\n",
        "            highs[2] < highs[1] and highs[2] > lows[2]\n",
        "            )\n",
        "\n",
        "        pattern_2 = (lows[0] < highs[0] and\n",
        "            lows[1] > lows[0] and lows[1] < highs[0] and\n",
        "            highs[1] > highs[0] and\n",
        "            lows[2] < lows[1] and\n",
        "            highs[2] < highs[1]\n",
        "            )\n",
        "\n",
        "        if (order_condition and\n",
        "            diff_condition and\n",
        "            (pattern_1 or pattern_2)\n",
        "        ):\n",
        "            pattern_detected = True\n",
        "\n",
        "    if pattern_detected:\n",
        "        return 1\n",
        "    else:\n",
        "        return 0"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "2BUVRUshpkho"
      },
      "outputs": [],
      "source": [
        "df['pattern_detected'] = df.index.map(lambda x: detect_structure(x, backcandles=40, window=6))"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "LWYdF7rYpkho",
        "outputId": "c873e362-f93c-468a-d94b-88c5af3d8d88"
      },
      "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>Gmt time</th>\n",
              "      <th>open</th>\n",
              "      <th>high</th>\n",
              "      <th>low</th>\n",
              "      <th>close</th>\n",
              "      <th>volume</th>\n",
              "      <th>RSI</th>\n",
              "      <th>EMA</th>\n",
              "      <th>EMASignal</th>\n",
              "      <th>isPivot</th>\n",
              "      <th>pointpos</th>\n",
              "      <th>pattern_detected</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>376</th>\n",
              "      <td>26.05.2003 13:00:00.000</td>\n",
              "      <td>1.18084</td>\n",
              "      <td>1.18151</td>\n",
              "      <td>1.18052</td>\n",
              "      <td>1.18126</td>\n",
              "      <td>2.681580e+07</td>\n",
              "      <td>60.322705</td>\n",
              "      <td>1.168325</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>377</th>\n",
              "      <td>26.05.2003 14:00:00.000</td>\n",
              "      <td>1.18106</td>\n",
              "      <td>1.18491</td>\n",
              "      <td>1.18059</td>\n",
              "      <td>1.18419</td>\n",
              "      <td>2.690430e+07</td>\n",
              "      <td>73.569795</td>\n",
              "      <td>1.168536</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>532</th>\n",
              "      <td>04.06.2003 02:00:00.000</td>\n",
              "      <td>1.17193</td>\n",
              "      <td>1.17320</td>\n",
              "      <td>1.17182</td>\n",
              "      <td>1.17226</td>\n",
              "      <td>2.971090e+07</td>\n",
              "      <td>46.771502</td>\n",
              "      <td>1.175323</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>533</th>\n",
              "      <td>04.06.2003 03:00:00.000</td>\n",
              "      <td>1.17243</td>\n",
              "      <td>1.17290</td>\n",
              "      <td>1.17160</td>\n",
              "      <td>1.17221</td>\n",
              "      <td>2.704670e+07</td>\n",
              "      <td>46.578694</td>\n",
              "      <td>1.175282</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>534</th>\n",
              "      <td>04.06.2003 04:00:00.000</td>\n",
              "      <td>1.17205</td>\n",
              "      <td>1.17296</td>\n",
              "      <td>1.17107</td>\n",
              "      <td>1.17243</td>\n",
              "      <td>2.887820e+07</td>\n",
              "      <td>47.615243</td>\n",
              "      <td>1.175244</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>535</th>\n",
              "      <td>04.06.2003 05:00:00.000</td>\n",
              "      <td>1.17274</td>\n",
              "      <td>1.17283</td>\n",
              "      <td>1.17101</td>\n",
              "      <td>1.17139</td>\n",
              "      <td>2.654940e+07</td>\n",
              "      <td>43.284098</td>\n",
              "      <td>1.175193</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>536</th>\n",
              "      <td>04.06.2003 06:00:00.000</td>\n",
              "      <td>1.17094</td>\n",
              "      <td>1.17212</td>\n",
              "      <td>1.17082</td>\n",
              "      <td>1.17097</td>\n",
              "      <td>3.082760e+07</td>\n",
              "      <td>41.616369</td>\n",
              "      <td>1.175137</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>537</th>\n",
              "      <td>04.06.2003 07:00:00.000</td>\n",
              "      <td>1.17087</td>\n",
              "      <td>1.17258</td>\n",
              "      <td>1.17066</td>\n",
              "      <td>1.17226</td>\n",
              "      <td>2.712590e+07</td>\n",
              "      <td>48.291884</td>\n",
              "      <td>1.175099</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>538</th>\n",
              "      <td>04.06.2003 08:00:00.000</td>\n",
              "      <td>1.17251</td>\n",
              "      <td>1.17463</td>\n",
              "      <td>1.17079</td>\n",
              "      <td>1.17353</td>\n",
              "      <td>2.831090e+07</td>\n",
              "      <td>53.947146</td>\n",
              "      <td>1.175078</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1.17563</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>539</th>\n",
              "      <td>04.06.2003 09:00:00.000</td>\n",
              "      <td>1.17333</td>\n",
              "      <td>1.17406</td>\n",
              "      <td>1.17236</td>\n",
              "      <td>1.17250</td>\n",
              "      <td>2.698430e+07</td>\n",
              "      <td>49.187538</td>\n",
              "      <td>1.175044</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>540</th>\n",
              "      <td>04.06.2003 10:00:00.000</td>\n",
              "      <td>1.17234</td>\n",
              "      <td>1.17234</td>\n",
              "      <td>1.16951</td>\n",
              "      <td>1.17123</td>\n",
              "      <td>2.683330e+07</td>\n",
              "      <td>43.969478</td>\n",
              "      <td>1.174994</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>541</th>\n",
              "      <td>04.06.2003 11:00:00.000</td>\n",
              "      <td>1.17107</td>\n",
              "      <td>1.17157</td>\n",
              "      <td>1.16889</td>\n",
              "      <td>1.17033</td>\n",
              "      <td>2.740940e+07</td>\n",
              "      <td>40.636746</td>\n",
              "      <td>1.174932</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>542</th>\n",
              "      <td>04.06.2003 12:00:00.000</td>\n",
              "      <td>1.17033</td>\n",
              "      <td>1.17120</td>\n",
              "      <td>1.16931</td>\n",
              "      <td>1.17019</td>\n",
              "      <td>2.826260e+07</td>\n",
              "      <td>40.120697</td>\n",
              "      <td>1.174869</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>543</th>\n",
              "      <td>04.06.2003 13:00:00.000</td>\n",
              "      <td>1.17012</td>\n",
              "      <td>1.17038</td>\n",
              "      <td>1.16834</td>\n",
              "      <td>1.17013</td>\n",
              "      <td>2.567930e+07</td>\n",
              "      <td>39.883897</td>\n",
              "      <td>1.174806</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>544</th>\n",
              "      <td>04.06.2003 14:00:00.000</td>\n",
              "      <td>1.17009</td>\n",
              "      <td>1.17248</td>\n",
              "      <td>1.16981</td>\n",
              "      <td>1.17032</td>\n",
              "      <td>2.861110e+07</td>\n",
              "      <td>41.085135</td>\n",
              "      <td>1.174747</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>698</th>\n",
              "      <td>13.06.2003 00:00:00.000</td>\n",
              "      <td>1.17674</td>\n",
              "      <td>1.17734</td>\n",
              "      <td>1.17616</td>\n",
              "      <td>1.17700</td>\n",
              "      <td>2.738540e+07</td>\n",
              "      <td>58.199547</td>\n",
              "      <td>1.173610</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>1.17834</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1333</th>\n",
              "      <td>21.07.2003 11:00:00.000</td>\n",
              "      <td>1.12954</td>\n",
              "      <td>1.12966</td>\n",
              "      <td>1.12778</td>\n",
              "      <td>1.12909</td>\n",
              "      <td>2.745350e+07</td>\n",
              "      <td>61.721455</td>\n",
              "      <td>1.125539</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1334</th>\n",
              "      <td>21.07.2003 12:00:00.000</td>\n",
              "      <td>1.12900</td>\n",
              "      <td>1.12984</td>\n",
              "      <td>1.12692</td>\n",
              "      <td>1.12709</td>\n",
              "      <td>2.883590e+07</td>\n",
              "      <td>52.328930</td>\n",
              "      <td>1.125560</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1335</th>\n",
              "      <td>21.07.2003 13:00:00.000</td>\n",
              "      <td>1.12674</td>\n",
              "      <td>1.12859</td>\n",
              "      <td>1.12664</td>\n",
              "      <td>1.12705</td>\n",
              "      <td>2.663010e+07</td>\n",
              "      <td>52.155762</td>\n",
              "      <td>1.125580</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1953</th>\n",
              "      <td>26.08.2003 12:00:00.000</td>\n",
              "      <td>1.08202</td>\n",
              "      <td>1.08292</td>\n",
              "      <td>1.08075</td>\n",
              "      <td>1.08111</td>\n",
              "      <td>3.371940e+07</td>\n",
              "      <td>34.099698</td>\n",
              "      <td>1.098672</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2255</th>\n",
              "      <td>12.09.2003 02:00:00.000</td>\n",
              "      <td>1.11885</td>\n",
              "      <td>1.11949</td>\n",
              "      <td>1.11835</td>\n",
              "      <td>1.11872</td>\n",
              "      <td>3.311950e+07</td>\n",
              "      <td>45.359911</td>\n",
              "      <td>1.110786</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2256</th>\n",
              "      <td>12.09.2003 03:00:00.000</td>\n",
              "      <td>1.11875</td>\n",
              "      <td>1.11932</td>\n",
              "      <td>1.11826</td>\n",
              "      <td>1.11872</td>\n",
              "      <td>3.049090e+07</td>\n",
              "      <td>45.359911</td>\n",
              "      <td>1.110891</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2257</th>\n",
              "      <td>12.09.2003 04:00:00.000</td>\n",
              "      <td>1.11862</td>\n",
              "      <td>1.11877</td>\n",
              "      <td>1.11772</td>\n",
              "      <td>1.11838</td>\n",
              "      <td>3.060530e+07</td>\n",
              "      <td>43.487603</td>\n",
              "      <td>1.110991</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2258</th>\n",
              "      <td>12.09.2003 05:00:00.000</td>\n",
              "      <td>1.11852</td>\n",
              "      <td>1.11883</td>\n",
              "      <td>1.11707</td>\n",
              "      <td>1.11814</td>\n",
              "      <td>3.146900e+07</td>\n",
              "      <td>42.147920</td>\n",
              "      <td>1.111085</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3418</th>\n",
              "      <td>19.11.2003 14:00:00.000</td>\n",
              "      <td>1.19149</td>\n",
              "      <td>1.19482</td>\n",
              "      <td>1.19145</td>\n",
              "      <td>1.19307</td>\n",
              "      <td>3.241720e+07</td>\n",
              "      <td>56.072430</td>\n",
              "      <td>1.175584</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>1.19582</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3419</th>\n",
              "      <td>19.11.2003 15:00:00.000</td>\n",
              "      <td>1.19298</td>\n",
              "      <td>1.19299</td>\n",
              "      <td>1.18972</td>\n",
              "      <td>1.19206</td>\n",
              "      <td>3.369760e+07</td>\n",
              "      <td>52.149349</td>\n",
              "      <td>1.175802</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3674</th>\n",
              "      <td>04.12.2003 06:00:00.000</td>\n",
              "      <td>1.20570</td>\n",
              "      <td>1.20653</td>\n",
              "      <td>1.20462</td>\n",
              "      <td>1.20567</td>\n",
              "      <td>3.250270e+07</td>\n",
              "      <td>39.442064</td>\n",
              "      <td>1.199104</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3675</th>\n",
              "      <td>04.12.2003 07:00:00.000</td>\n",
              "      <td>1.20553</td>\n",
              "      <td>1.20890</td>\n",
              "      <td>1.20472</td>\n",
              "      <td>1.20851</td>\n",
              "      <td>3.025600e+07</td>\n",
              "      <td>50.979888</td>\n",
              "      <td>1.199229</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3676</th>\n",
              "      <td>04.12.2003 08:00:00.000</td>\n",
              "      <td>1.20862</td>\n",
              "      <td>1.20886</td>\n",
              "      <td>1.20615</td>\n",
              "      <td>1.20628</td>\n",
              "      <td>3.133190e+07</td>\n",
              "      <td>43.827166</td>\n",
              "      <td>1.199322</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3677</th>\n",
              "      <td>04.12.2003 09:00:00.000</td>\n",
              "      <td>1.20652</td>\n",
              "      <td>1.20819</td>\n",
              "      <td>1.20623</td>\n",
              "      <td>1.20678</td>\n",
              "      <td>3.150580e+07</td>\n",
              "      <td>45.690962</td>\n",
              "      <td>1.199421</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4457</th>\n",
              "      <td>19.01.2004 21:00:00.000</td>\n",
              "      <td>1.23440</td>\n",
              "      <td>1.23632</td>\n",
              "      <td>1.23440</td>\n",
              "      <td>1.23468</td>\n",
              "      <td>3.121710e+07</td>\n",
              "      <td>35.686183</td>\n",
              "      <td>1.256299</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4458</th>\n",
              "      <td>19.01.2004 22:00:00.000</td>\n",
              "      <td>1.23480</td>\n",
              "      <td>1.23562</td>\n",
              "      <td>1.23462</td>\n",
              "      <td>1.23520</td>\n",
              "      <td>2.816240e+07</td>\n",
              "      <td>38.599041</td>\n",
              "      <td>1.256020</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4459</th>\n",
              "      <td>19.01.2004 23:00:00.000</td>\n",
              "      <td>1.23526</td>\n",
              "      <td>1.23569</td>\n",
              "      <td>1.23470</td>\n",
              "      <td>1.23493</td>\n",
              "      <td>3.279120e+07</td>\n",
              "      <td>37.633569</td>\n",
              "      <td>1.255741</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4460</th>\n",
              "      <td>20.01.2004 00:00:00.000</td>\n",
              "      <td>1.23490</td>\n",
              "      <td>1.23650</td>\n",
              "      <td>1.23411</td>\n",
              "      <td>1.23626</td>\n",
              "      <td>3.167560e+07</td>\n",
              "      <td>45.023142</td>\n",
              "      <td>1.255483</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4461</th>\n",
              "      <td>20.01.2004 01:00:00.000</td>\n",
              "      <td>1.23633</td>\n",
              "      <td>1.23760</td>\n",
              "      <td>1.23554</td>\n",
              "      <td>1.23712</td>\n",
              "      <td>3.622670e+07</td>\n",
              "      <td>49.263696</td>\n",
              "      <td>1.255239</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4779</th>\n",
              "      <td>06.02.2004 07:00:00.000</td>\n",
              "      <td>1.25420</td>\n",
              "      <td>1.25631</td>\n",
              "      <td>1.25385</td>\n",
              "      <td>1.25538</td>\n",
              "      <td>3.242360e+07</td>\n",
              "      <td>50.153622</td>\n",
              "      <td>1.252532</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>1.25731</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4780</th>\n",
              "      <td>06.02.2004 08:00:00.000</td>\n",
              "      <td>1.25506</td>\n",
              "      <td>1.25547</td>\n",
              "      <td>1.25363</td>\n",
              "      <td>1.25440</td>\n",
              "      <td>3.099260e+07</td>\n",
              "      <td>45.758914</td>\n",
              "      <td>1.252557</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4781</th>\n",
              "      <td>06.02.2004 09:00:00.000</td>\n",
              "      <td>1.25466</td>\n",
              "      <td>1.25492</td>\n",
              "      <td>1.25120</td>\n",
              "      <td>1.25123</td>\n",
              "      <td>3.078080e+07</td>\n",
              "      <td>34.951622</td>\n",
              "      <td>1.252539</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4782</th>\n",
              "      <td>06.02.2004 10:00:00.000</td>\n",
              "      <td>1.25115</td>\n",
              "      <td>1.25294</td>\n",
              "      <td>1.25113</td>\n",
              "      <td>1.25283</td>\n",
              "      <td>3.223150e+07</td>\n",
              "      <td>42.437307</td>\n",
              "      <td>1.252543</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4783</th>\n",
              "      <td>06.02.2004 11:00:00.000</td>\n",
              "      <td>1.25254</td>\n",
              "      <td>1.25287</td>\n",
              "      <td>1.25153</td>\n",
              "      <td>1.25177</td>\n",
              "      <td>3.270460e+07</td>\n",
              "      <td>39.178786</td>\n",
              "      <td>1.252533</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4784</th>\n",
              "      <td>06.02.2004 12:00:00.000</td>\n",
              "      <td>1.25175</td>\n",
              "      <td>1.25399</td>\n",
              "      <td>1.25100</td>\n",
              "      <td>1.25335</td>\n",
              "      <td>3.263820e+07</td>\n",
              "      <td>45.929820</td>\n",
              "      <td>1.252544</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>1.25000</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4785</th>\n",
              "      <td>06.02.2004 13:00:00.000</td>\n",
              "      <td>1.25365</td>\n",
              "      <td>1.26783</td>\n",
              "      <td>1.25241</td>\n",
              "      <td>1.26594</td>\n",
              "      <td>3.135630e+07</td>\n",
              "      <td>72.481660</td>\n",
              "      <td>1.252721</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                     Gmt time     open     high      low    close  \\\n",
              "376   26.05.2003 13:00:00.000  1.18084  1.18151  1.18052  1.18126   \n",
              "377   26.05.2003 14:00:00.000  1.18106  1.18491  1.18059  1.18419   \n",
              "532   04.06.2003 02:00:00.000  1.17193  1.17320  1.17182  1.17226   \n",
              "533   04.06.2003 03:00:00.000  1.17243  1.17290  1.17160  1.17221   \n",
              "534   04.06.2003 04:00:00.000  1.17205  1.17296  1.17107  1.17243   \n",
              "535   04.06.2003 05:00:00.000  1.17274  1.17283  1.17101  1.17139   \n",
              "536   04.06.2003 06:00:00.000  1.17094  1.17212  1.17082  1.17097   \n",
              "537   04.06.2003 07:00:00.000  1.17087  1.17258  1.17066  1.17226   \n",
              "538   04.06.2003 08:00:00.000  1.17251  1.17463  1.17079  1.17353   \n",
              "539   04.06.2003 09:00:00.000  1.17333  1.17406  1.17236  1.17250   \n",
              "540   04.06.2003 10:00:00.000  1.17234  1.17234  1.16951  1.17123   \n",
              "541   04.06.2003 11:00:00.000  1.17107  1.17157  1.16889  1.17033   \n",
              "542   04.06.2003 12:00:00.000  1.17033  1.17120  1.16931  1.17019   \n",
              "543   04.06.2003 13:00:00.000  1.17012  1.17038  1.16834  1.17013   \n",
              "544   04.06.2003 14:00:00.000  1.17009  1.17248  1.16981  1.17032   \n",
              "698   13.06.2003 00:00:00.000  1.17674  1.17734  1.17616  1.17700   \n",
              "1333  21.07.2003 11:00:00.000  1.12954  1.12966  1.12778  1.12909   \n",
              "1334  21.07.2003 12:00:00.000  1.12900  1.12984  1.12692  1.12709   \n",
              "1335  21.07.2003 13:00:00.000  1.12674  1.12859  1.12664  1.12705   \n",
              "1953  26.08.2003 12:00:00.000  1.08202  1.08292  1.08075  1.08111   \n",
              "2255  12.09.2003 02:00:00.000  1.11885  1.11949  1.11835  1.11872   \n",
              "2256  12.09.2003 03:00:00.000  1.11875  1.11932  1.11826  1.11872   \n",
              "2257  12.09.2003 04:00:00.000  1.11862  1.11877  1.11772  1.11838   \n",
              "2258  12.09.2003 05:00:00.000  1.11852  1.11883  1.11707  1.11814   \n",
              "3418  19.11.2003 14:00:00.000  1.19149  1.19482  1.19145  1.19307   \n",
              "3419  19.11.2003 15:00:00.000  1.19298  1.19299  1.18972  1.19206   \n",
              "3674  04.12.2003 06:00:00.000  1.20570  1.20653  1.20462  1.20567   \n",
              "3675  04.12.2003 07:00:00.000  1.20553  1.20890  1.20472  1.20851   \n",
              "3676  04.12.2003 08:00:00.000  1.20862  1.20886  1.20615  1.20628   \n",
              "3677  04.12.2003 09:00:00.000  1.20652  1.20819  1.20623  1.20678   \n",
              "4457  19.01.2004 21:00:00.000  1.23440  1.23632  1.23440  1.23468   \n",
              "4458  19.01.2004 22:00:00.000  1.23480  1.23562  1.23462  1.23520   \n",
              "4459  19.01.2004 23:00:00.000  1.23526  1.23569  1.23470  1.23493   \n",
              "4460  20.01.2004 00:00:00.000  1.23490  1.23650  1.23411  1.23626   \n",
              "4461  20.01.2004 01:00:00.000  1.23633  1.23760  1.23554  1.23712   \n",
              "4779  06.02.2004 07:00:00.000  1.25420  1.25631  1.25385  1.25538   \n",
              "4780  06.02.2004 08:00:00.000  1.25506  1.25547  1.25363  1.25440   \n",
              "4781  06.02.2004 09:00:00.000  1.25466  1.25492  1.25120  1.25123   \n",
              "4782  06.02.2004 10:00:00.000  1.25115  1.25294  1.25113  1.25283   \n",
              "4783  06.02.2004 11:00:00.000  1.25254  1.25287  1.25153  1.25177   \n",
              "4784  06.02.2004 12:00:00.000  1.25175  1.25399  1.25100  1.25335   \n",
              "4785  06.02.2004 13:00:00.000  1.25365  1.26783  1.25241  1.26594   \n",
              "\n",
              "            volume        RSI       EMA  EMASignal  isPivot  pointpos  \\\n",
              "376   2.681580e+07  60.322705  1.168325          2        0       NaN   \n",
              "377   2.690430e+07  73.569795  1.168536          2        0       NaN   \n",
              "532   2.971090e+07  46.771502  1.175323          1        0       NaN   \n",
              "533   2.704670e+07  46.578694  1.175282          1        0       NaN   \n",
              "534   2.887820e+07  47.615243  1.175244          1        0       NaN   \n",
              "535   2.654940e+07  43.284098  1.175193          1        0       NaN   \n",
              "536   3.082760e+07  41.616369  1.175137          1        0       NaN   \n",
              "537   2.712590e+07  48.291884  1.175099          1        0       NaN   \n",
              "538   2.831090e+07  53.947146  1.175078          1        1   1.17563   \n",
              "539   2.698430e+07  49.187538  1.175044          1        0       NaN   \n",
              "540   2.683330e+07  43.969478  1.174994          1        0       NaN   \n",
              "541   2.740940e+07  40.636746  1.174932          1        0       NaN   \n",
              "542   2.826260e+07  40.120697  1.174869          1        0       NaN   \n",
              "543   2.567930e+07  39.883897  1.174806          1        0       NaN   \n",
              "544   2.861110e+07  41.085135  1.174747          1        0       NaN   \n",
              "698   2.738540e+07  58.199547  1.173610          0        1   1.17834   \n",
              "1333  2.745350e+07  61.721455  1.125539          0        0       NaN   \n",
              "1334  2.883590e+07  52.328930  1.125560          0        0       NaN   \n",
              "1335  2.663010e+07  52.155762  1.125580          0        0       NaN   \n",
              "1953  3.371940e+07  34.099698  1.098672          1        0       NaN   \n",
              "2255  3.311950e+07  45.359911  1.110786          2        0       NaN   \n",
              "2256  3.049090e+07  45.359911  1.110891          2        0       NaN   \n",
              "2257  3.060530e+07  43.487603  1.110991          2        0       NaN   \n",
              "2258  3.146900e+07  42.147920  1.111085          2        0       NaN   \n",
              "3418  3.241720e+07  56.072430  1.175584          2        1   1.19582   \n",
              "3419  3.369760e+07  52.149349  1.175802          2        0       NaN   \n",
              "3674  3.250270e+07  39.442064  1.199104          2        0       NaN   \n",
              "3675  3.025600e+07  50.979888  1.199229          2        0       NaN   \n",
              "3676  3.133190e+07  43.827166  1.199322          2        0       NaN   \n",
              "3677  3.150580e+07  45.690962  1.199421          2        0       NaN   \n",
              "4457  3.121710e+07  35.686183  1.256299          1        0       NaN   \n",
              "4458  2.816240e+07  38.599041  1.256020          1        0       NaN   \n",
              "4459  3.279120e+07  37.633569  1.255741          1        0       NaN   \n",
              "4460  3.167560e+07  45.023142  1.255483          1        0       NaN   \n",
              "4461  3.622670e+07  49.263696  1.255239          1        0       NaN   \n",
              "4779  3.242360e+07  50.153622  1.252532          2        1   1.25731   \n",
              "4780  3.099260e+07  45.758914  1.252557          2        0       NaN   \n",
              "4781  3.078080e+07  34.951622  1.252539          0        0       NaN   \n",
              "4782  3.223150e+07  42.437307  1.252543          0        0       NaN   \n",
              "4783  3.270460e+07  39.178786  1.252533          0        0       NaN   \n",
              "4784  3.263820e+07  45.929820  1.252544          0        2   1.25000   \n",
              "4785  3.135630e+07  72.481660  1.252721          0        0       NaN   \n",
              "\n",
              "      pattern_detected  \n",
              "376                  1  \n",
              "377                  1  \n",
              "532                  1  \n",
              "533                  1  \n",
              "534                  1  \n",
              "535                  1  \n",
              "536                  1  \n",
              "537                  1  \n",
              "538                  1  \n",
              "539                  1  \n",
              "540                  1  \n",
              "541                  1  \n",
              "542                  1  \n",
              "543                  1  \n",
              "544                  1  \n",
              "698                  1  \n",
              "1333                 1  \n",
              "1334                 1  \n",
              "1335                 1  \n",
              "1953                 1  \n",
              "2255                 1  \n",
              "2256                 1  \n",
              "2257                 1  \n",
              "2258                 1  \n",
              "3418                 1  \n",
              "3419                 1  \n",
              "3674                 1  \n",
              "3675                 1  \n",
              "3676                 1  \n",
              "3677                 1  \n",
              "4457                 1  \n",
              "4458                 1  \n",
              "4459                 1  \n",
              "4460                 1  \n",
              "4461                 1  \n",
              "4779                 1  \n",
              "4780                 1  \n",
              "4781                 1  \n",
              "4782                 1  \n",
              "4783                 1  \n",
              "4784                 1  \n",
              "4785                 1  "
            ]
          },
          "execution_count": 9,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df[df['pattern_detected']!=0]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "l8Lx7GKupkhq"
      },
      "outputs": [],
      "source": []
    }
  ],
  "metadata": {
    "kernelspec": {
      "display_name": "Python 3 (ipykernel)",
      "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.10.8"
    },
    "colab": {
      "provenance": [],
      "include_colab_link": true
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}