notebook.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import re\n",
    "import pandas as pd\n",
    "from datetime import datetime\n",
    "import MetaTrader5 as mt5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date_time</th>\n",
       "      <th>news</th>\n",
       "      <th>impact</th>\n",
       "      <th>actual</th>\n",
       "      <th>forecast</th>\n",
       "      <th>previous</th>\n",
       "      <th>country</th>\n",
       "      <th>symbol</th>\n",
       "      <th>timeframe</th>\n",
       "      <th>action</th>\n",
       "      <th>...</th>\n",
       "      <th>sl</th>\n",
       "      <th>tp</th>\n",
       "      <th>profit</th>\n",
       "      <th>ticket</th>\n",
       "      <th>close_time</th>\n",
       "      <th>risk-free_price</th>\n",
       "      <th>risk-free_sl</th>\n",
       "      <th>risk-free_tp</th>\n",
       "      <th>risk-free_profit</th>\n",
       "      <th>risk-free_close_time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2024-01-16 02:55:05</td>\n",
       "      <td>Westpac Consumer Sentiment</td>\n",
       "      <td>low</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>2.7</td>\n",
       "      <td>Australia</td>\n",
       "      <td>NZDCAD</td>\n",
       "      <td>1</td>\n",
       "      <td>Cancel</td>\n",
       "      <td>...</td>\n",
       "      <td>0.83131</td>\n",
       "      <td>0.83155</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2024-01-16 02:55:05</td>\n",
       "      <td>Westpac Consumer Sentiment</td>\n",
       "      <td>low</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>2.7</td>\n",
       "      <td>Australia</td>\n",
       "      <td>GBPAUD</td>\n",
       "      <td>0.5</td>\n",
       "      <td>Buy</td>\n",
       "      <td>...</td>\n",
       "      <td>1.91105</td>\n",
       "      <td>1.91183</td>\n",
       "      <td>None</td>\n",
       "      <td>195473142</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2024-01-16 02:55:05</td>\n",
       "      <td>Westpac Consumer Sentiment</td>\n",
       "      <td>low</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>2.7</td>\n",
       "      <td>Australia</td>\n",
       "      <td>EURNZD</td>\n",
       "      <td>0.5</td>\n",
       "      <td>Sell</td>\n",
       "      <td>...</td>\n",
       "      <td>1.77042</td>\n",
       "      <td>1.76792</td>\n",
       "      <td>33.53</td>\n",
       "      <td>195473129</td>\n",
       "      <td>2024-01-16 03:25:51</td>\n",
       "      <td>1.76806</td>\n",
       "      <td>1.7689</td>\n",
       "      <td>1.76792</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2024-01-16 03:15:05</td>\n",
       "      <td>PPI (MoM)</td>\n",
       "      <td>low</td>\n",
       "      <td>nan</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>Japan</td>\n",
       "      <td>CADJPY</td>\n",
       "      <td>0.5</td>\n",
       "      <td>Buy</td>\n",
       "      <td>...</td>\n",
       "      <td>108.427</td>\n",
       "      <td>108.559</td>\n",
       "      <td>None</td>\n",
       "      <td>195474086</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2024-01-16 03:15:05</td>\n",
       "      <td>PPI (MoM)</td>\n",
       "      <td>low</td>\n",
       "      <td>nan</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>Japan</td>\n",
       "      <td>GBPJPY</td>\n",
       "      <td>0.5</td>\n",
       "      <td>Buy</td>\n",
       "      <td>...</td>\n",
       "      <td>185.268</td>\n",
       "      <td>185.422</td>\n",
       "      <td>None</td>\n",
       "      <td>195474184</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>2024-01-16 16:55:02</td>\n",
       "      <td>Median CPI (YoY)</td>\n",
       "      <td>low</td>\n",
       "      <td>nan</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.4</td>\n",
       "      <td>Canada</td>\n",
       "      <td>CADCHF</td>\n",
       "      <td>2</td>\n",
       "      <td>Sell</td>\n",
       "      <td>...</td>\n",
       "      <td>0.64027</td>\n",
       "      <td>0.63869</td>\n",
       "      <td>None</td>\n",
       "      <td>195612513</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>2024-01-16 16:55:02</td>\n",
       "      <td>Median CPI (YoY)</td>\n",
       "      <td>low</td>\n",
       "      <td>nan</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.4</td>\n",
       "      <td>Canada</td>\n",
       "      <td>NZDCAD</td>\n",
       "      <td>2</td>\n",
       "      <td>Buy</td>\n",
       "      <td>...</td>\n",
       "      <td>0.82753</td>\n",
       "      <td>0.82921</td>\n",
       "      <td>None</td>\n",
       "      <td>195611759</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>2024-01-16 16:40:05</td>\n",
       "      <td>Housing Starts</td>\n",
       "      <td>medium</td>\n",
       "      <td>nan</td>\n",
       "      <td>243.0</td>\n",
       "      <td>212.6</td>\n",
       "      <td>Canada</td>\n",
       "      <td>CADJPY</td>\n",
       "      <td>2.5</td>\n",
       "      <td>Buy</td>\n",
       "      <td>...</td>\n",
       "      <td>108.725</td>\n",
       "      <td>108.883</td>\n",
       "      <td>None</td>\n",
       "      <td>195616874</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>2024-01-16 16:55:02</td>\n",
       "      <td>Median CPI (YoY)</td>\n",
       "      <td>low</td>\n",
       "      <td>nan</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.4</td>\n",
       "      <td>Canada</td>\n",
       "      <td>AUDCAD</td>\n",
       "      <td>2.5</td>\n",
       "      <td>Buy</td>\n",
       "      <td>...</td>\n",
       "      <td>0.88856</td>\n",
       "      <td>0.88944</td>\n",
       "      <td>None</td>\n",
       "      <td>195614752</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>2024-01-16 16:55:02</td>\n",
       "      <td>Median CPI (YoY)</td>\n",
       "      <td>low</td>\n",
       "      <td>nan</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.4</td>\n",
       "      <td>Canada</td>\n",
       "      <td>CADJPY</td>\n",
       "      <td>2.5</td>\n",
       "      <td>Buy</td>\n",
       "      <td>...</td>\n",
       "      <td>108.716</td>\n",
       "      <td>108.88</td>\n",
       "      <td>None</td>\n",
       "      <td>195617745</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>182 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               date_time                        news  impact actual forecast  \\\n",
       "0    2024-01-16 02:55:05  Westpac Consumer Sentiment     low    nan      nan   \n",
       "1    2024-01-16 02:55:05  Westpac Consumer Sentiment     low    nan      nan   \n",
       "2    2024-01-16 02:55:05  Westpac Consumer Sentiment     low    nan      nan   \n",
       "3    2024-01-16 03:15:05                   PPI (MoM)     low    nan      0.0   \n",
       "4    2024-01-16 03:15:05                   PPI (MoM)     low    nan      0.0   \n",
       "..                   ...                         ...     ...    ...      ...   \n",
       "177  2024-01-16 16:55:02            Median CPI (YoY)     low    nan      3.4   \n",
       "178  2024-01-16 16:55:02            Median CPI (YoY)     low    nan      3.4   \n",
       "179  2024-01-16 16:40:05              Housing Starts  medium    nan    243.0   \n",
       "180  2024-01-16 16:55:02            Median CPI (YoY)     low    nan      3.4   \n",
       "181  2024-01-16 16:55:02            Median CPI (YoY)     low    nan      3.4   \n",
       "\n",
       "    previous    country  symbol timeframe  action  ...       sl       tp  \\\n",
       "0        2.7  Australia  NZDCAD         1  Cancel  ...  0.83131  0.83155   \n",
       "1        2.7  Australia  GBPAUD       0.5     Buy  ...  1.91105  1.91183   \n",
       "2        2.7  Australia  EURNZD       0.5    Sell  ...  1.77042  1.76792   \n",
       "3        0.2      Japan  CADJPY       0.5     Buy  ...  108.427  108.559   \n",
       "4        0.2      Japan  GBPJPY       0.5     Buy  ...  185.268  185.422   \n",
       "..       ...        ...     ...       ...     ...  ...      ...      ...   \n",
       "177      3.4     Canada  CADCHF         2    Sell  ...  0.64027  0.63869   \n",
       "178      3.4     Canada  NZDCAD         2     Buy  ...  0.82753  0.82921   \n",
       "179    212.6     Canada  CADJPY       2.5     Buy  ...  108.725  108.883   \n",
       "180      3.4     Canada  AUDCAD       2.5     Buy  ...  0.88856  0.88944   \n",
       "181      3.4     Canada  CADJPY       2.5     Buy  ...  108.716   108.88   \n",
       "\n",
       "    profit     ticket           close_time risk-free_price risk-free_sl  \\\n",
       "0     None       None                 None            None         None   \n",
       "1     None  195473142                 None            None         None   \n",
       "2    33.53  195473129  2024-01-16 03:25:51         1.76806       1.7689   \n",
       "3     None  195474086                 None            None         None   \n",
       "4     None  195474184                 None            None         None   \n",
       "..     ...        ...                  ...             ...          ...   \n",
       "177   None  195612513                 None            None         None   \n",
       "178   None  195611759                 None            None         None   \n",
       "179   None  195616874                 None            None         None   \n",
       "180   None  195614752                 None            None         None   \n",
       "181   None  195617745                 None            None         None   \n",
       "\n",
       "    risk-free_tp risk-free_profit risk-free_close_time  \n",
       "0           None             None                 None  \n",
       "1           None             None                 None  \n",
       "2        1.76792             None                 None  \n",
       "3           None             None                 None  \n",
       "4           None             None                 None  \n",
       "..           ...              ...                  ...  \n",
       "177         None             None                 None  \n",
       "178         None             None                 None  \n",
       "179         None             None                 None  \n",
       "180         None             None                 None  \n",
       "181         None             None                 None  \n",
       "\n",
       "[182 rows x 25 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "with open('static/report_2024-01-16.txt', 'r') as f:\n",
    "    lines = f.readlines()\n",
    "dicts = [{key_value.split(':')[0].strip():\":\".join(key_value.split(':')[1:]).strip() for key_value in re.sub('[\\'\"{}\\n]', '', line).split(',')} for line in lines]\n",
    "df = pd.DataFrame(dicts)\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## gives every change in position risk free position is one order, first order is another, has close_time, risk-free_close_time"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ticket</th>\n",
       "      <th>time_setup</th>\n",
       "      <th>time_done</th>\n",
       "      <th>position_id</th>\n",
       "      <th>volume_initial</th>\n",
       "      <th>volume_current</th>\n",
       "      <th>price_open</th>\n",
       "      <th>sl</th>\n",
       "      <th>tp</th>\n",
       "      <th>price_current</th>\n",
       "      <th>price_stoplimit</th>\n",
       "      <th>symbol</th>\n",
       "      <th>comment</th>\n",
       "      <th>external_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>194848597</td>\n",
       "      <td>2024-01-10 21:31:09</td>\n",
       "      <td>2024-01-10 21:31:09</td>\n",
       "      <td>194848597</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.09691</td>\n",
       "      <td>0.0</td>\n",
       "      <td>EURUSD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>194848603</td>\n",
       "      <td>2024-01-10 21:31:15</td>\n",
       "      <td>2024-01-10 21:31:15</td>\n",
       "      <td>194848603</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.09690</td>\n",
       "      <td>0.0</td>\n",
       "      <td>EURUSD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>194855360</td>\n",
       "      <td>2024-01-10 22:27:28</td>\n",
       "      <td>2024-01-10 22:27:28</td>\n",
       "      <td>194848603</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.09645</td>\n",
       "      <td>0.0</td>\n",
       "      <td>EURUSD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>194855363</td>\n",
       "      <td>2024-01-10 22:27:29</td>\n",
       "      <td>2024-01-10 22:27:29</td>\n",
       "      <td>194848597</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.09648</td>\n",
       "      <td>0.0</td>\n",
       "      <td>EURUSD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>194858563</td>\n",
       "      <td>2024-01-10 23:05:26</td>\n",
       "      <td>2024-01-10 23:05:27</td>\n",
       "      <td>194858563</td>\n",
       "      <td>1.61</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>2024.28</td>\n",
       "      <td>2023.04</td>\n",
       "      <td>2023.54000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>XAUUSD</td>\n",
       "      <td>Bui,1,80.5</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>863</th>\n",
       "      <td>195086450</td>\n",
       "      <td>2024-01-12 01:58:33</td>\n",
       "      <td>2024-01-12 01:58:33</td>\n",
       "      <td>195080711</td>\n",
       "      <td>1.09</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.66996</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.66996</td>\n",
       "      <td>0.0</td>\n",
       "      <td>AUDUSD</td>\n",
       "      <td>[sl 0.66996]</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>864</th>\n",
       "      <td>195090017</td>\n",
       "      <td>2024-01-12 02:55:08</td>\n",
       "      <td>2024-01-12 02:55:08</td>\n",
       "      <td>195079846</td>\n",
       "      <td>1.06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.67013</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.67013</td>\n",
       "      <td>0.0</td>\n",
       "      <td>AUDUSD</td>\n",
       "      <td>[sl 0.67013]</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>865</th>\n",
       "      <td>195091356</td>\n",
       "      <td>2024-01-12 03:36:27</td>\n",
       "      <td>2024-01-12 03:36:27</td>\n",
       "      <td>195080445</td>\n",
       "      <td>0.84</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.67020</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.67020</td>\n",
       "      <td>0.0</td>\n",
       "      <td>AUDUSD</td>\n",
       "      <td>[sl 0.67020]</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>866</th>\n",
       "      <td>195091366</td>\n",
       "      <td>2024-01-12 03:36:28</td>\n",
       "      <td>2024-01-12 03:36:28</td>\n",
       "      <td>195080215</td>\n",
       "      <td>0.88</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.67028</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.67028</td>\n",
       "      <td>0.0</td>\n",
       "      <td>AUDUSD</td>\n",
       "      <td>[sl 0.67028]</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>867</th>\n",
       "      <td>195113547</td>\n",
       "      <td>2024-01-12 09:46:02</td>\n",
       "      <td>2024-01-12 09:46:02</td>\n",
       "      <td>195081136</td>\n",
       "      <td>0.64</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.85346</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.85346</td>\n",
       "      <td>0.0</td>\n",
       "      <td>USDCHF</td>\n",
       "      <td>[tp 0.85346]</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>868 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        ticket          time_setup           time_done  position_id  \\\n",
       "0    194848597 2024-01-10 21:31:09 2024-01-10 21:31:09    194848597   \n",
       "1    194848603 2024-01-10 21:31:15 2024-01-10 21:31:15    194848603   \n",
       "2    194855360 2024-01-10 22:27:28 2024-01-10 22:27:28    194848603   \n",
       "3    194855363 2024-01-10 22:27:29 2024-01-10 22:27:29    194848597   \n",
       "4    194858563 2024-01-10 23:05:26 2024-01-10 23:05:27    194858563   \n",
       "..         ...                 ...                 ...          ...   \n",
       "863  195086450 2024-01-12 01:58:33 2024-01-12 01:58:33    195080711   \n",
       "864  195090017 2024-01-12 02:55:08 2024-01-12 02:55:08    195079846   \n",
       "865  195091356 2024-01-12 03:36:27 2024-01-12 03:36:27    195080445   \n",
       "866  195091366 2024-01-12 03:36:28 2024-01-12 03:36:28    195080215   \n",
       "867  195113547 2024-01-12 09:46:02 2024-01-12 09:46:02    195081136   \n",
       "\n",
       "     volume_initial  volume_current  price_open       sl       tp  \\\n",
       "0              0.01             0.0     0.00000     0.00     0.00   \n",
       "1              0.01             0.0     0.00000     0.00     0.00   \n",
       "2              0.01             0.0     0.00000     0.00     0.00   \n",
       "3              0.01             0.0     0.00000     0.00     0.00   \n",
       "4              1.61             0.0     0.00000  2024.28  2023.04   \n",
       "..              ...             ...         ...      ...      ...   \n",
       "863            1.09             0.0     0.66996     0.00     0.00   \n",
       "864            1.06             0.0     0.67013     0.00     0.00   \n",
       "865            0.84             0.0     0.67020     0.00     0.00   \n",
       "866            0.88             0.0     0.67028     0.00     0.00   \n",
       "867            0.64             0.0     0.85346     0.00     0.00   \n",
       "\n",
       "     price_current  price_stoplimit  symbol       comment external_id  \n",
       "0          1.09691              0.0  EURUSD                            \n",
       "1          1.09690              0.0  EURUSD                            \n",
       "2          1.09645              0.0  EURUSD                            \n",
       "3          1.09648              0.0  EURUSD                            \n",
       "4       2023.54000              0.0  XAUUSD    Bui,1,80.5              \n",
       "..             ...              ...     ...           ...         ...  \n",
       "863        0.66996              0.0  AUDUSD  [sl 0.66996]              \n",
       "864        0.67013              0.0  AUDUSD  [sl 0.67013]              \n",
       "865        0.67020              0.0  AUDUSD  [sl 0.67020]              \n",
       "866        0.67028              0.0  AUDUSD  [sl 0.67028]              \n",
       "867        0.85346              0.0  USDCHF  [tp 0.85346]              \n",
       "\n",
       "[868 rows x 14 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# establish connection to the MetaTrader 5 terminal\n",
    "initialize= [\"51949125\", \"qtrvkk7i\", \"Alpari-MT5-Demo\"]\n",
    "mt5.initialize()\n",
    "mt5.login(login=initialize[0], password=initialize[1], server=initialize[2])\n",
    "\n",
    "# get the number of orders in history\n",
    "from_date=datetime(2020,1,1)\n",
    "to_date=datetime.now()\n",
    "history_orders=mt5.history_orders_get(from_date, to_date)\n",
    "\n",
    "# display these orders as a table using pandas.DataFrame\n",
    "tf=pd.DataFrame(list(history_orders),columns=history_orders[0]._asdict().keys())\n",
    "tf.drop(['time_expiration','type_time','state','position_by_id','reason','time_setup_msc', 'time_done_msc', 'type', 'type_filling', 'magic'], axis=1, inplace=True)\n",
    "tf['time_setup'] = pd.to_datetime(tf['time_setup'], unit='s')\n",
    "tf['time_done'] = pd.to_datetime(tf['time_done'], unit='s')\n",
    "tf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(TradeOrder(ticket=195081136, time_setup=1705017183, time_setup_msc=1705017183615, time_done=1705017183, time_done_msc=1705017183644, time_expiration=0, type=0, type_time=0, type_filling=0, state=4, magic=0, position_id=195081136, position_by_id=0, reason=3, volume_initial=0.64, volume_current=0.0, price_open=0.0, sl=0.8508, tp=0.85346, price_current=0.85222, price_stoplimit=0.0, symbol='USDCHF', comment='Fed,4,60.0', external_id=''),\n",
       " TradeOrder(ticket=195113547, time_setup=1705052762, time_setup_msc=1705052762444, time_done=1705052762, time_done_msc=1705052762475, time_expiration=0, type=1, type_time=0, type_filling=1, state=4, magic=0, position_id=195081136, position_by_id=0, reason=5, volume_initial=0.64, volume_current=0.0, price_open=0.85346, sl=0.0, tp=0.0, price_current=0.85346, price_stoplimit=0.0, symbol='USDCHF', comment='[tp 0.85346]', external_id=''))"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mt5.history_orders_get(position=195081136)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## gives profit, commission, swap"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ticket</th>\n",
       "      <th>order</th>\n",
       "      <th>time</th>\n",
       "      <th>position_id</th>\n",
       "      <th>volume</th>\n",
       "      <th>price</th>\n",
       "      <th>commission</th>\n",
       "      <th>swap</th>\n",
       "      <th>profit</th>\n",
       "      <th>fee</th>\n",
       "      <th>symbol</th>\n",
       "      <th>comment</th>\n",
       "      <th>external_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>161165043</td>\n",
       "      <td>0</td>\n",
       "      <td>2024-01-09 05:45:19</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100000.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>161500016</td>\n",
       "      <td>194848597</td>\n",
       "      <td>2024-01-10 21:31:09</td>\n",
       "      <td>194848597</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1.09691</td>\n",
       "      <td>-0.02</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>EURUSD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>161500020</td>\n",
       "      <td>194848603</td>\n",
       "      <td>2024-01-10 21:31:15</td>\n",
       "      <td>194848603</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1.09690</td>\n",
       "      <td>-0.02</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>EURUSD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>161506542</td>\n",
       "      <td>194855360</td>\n",
       "      <td>2024-01-10 22:27:28</td>\n",
       "      <td>194848603</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1.09645</td>\n",
       "      <td>-0.02</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.45</td>\n",
       "      <td>0.0</td>\n",
       "      <td>EURUSD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>161506544</td>\n",
       "      <td>194855363</td>\n",
       "      <td>2024-01-10 22:27:29</td>\n",
       "      <td>194848597</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1.09648</td>\n",
       "      <td>-0.02</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.43</td>\n",
       "      <td>0.0</td>\n",
       "      <td>EURUSD</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>864</th>\n",
       "      <td>161726298</td>\n",
       "      <td>195086450</td>\n",
       "      <td>2024-01-12 01:58:33</td>\n",
       "      <td>195080711</td>\n",
       "      <td>1.09</td>\n",
       "      <td>0.66996</td>\n",
       "      <td>-1.17</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-110.09</td>\n",
       "      <td>0.0</td>\n",
       "      <td>AUDUSD</td>\n",
       "      <td>[sl 0.66996]</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>865</th>\n",
       "      <td>161728855</td>\n",
       "      <td>195090017</td>\n",
       "      <td>2024-01-12 02:55:08</td>\n",
       "      <td>195079846</td>\n",
       "      <td>1.06</td>\n",
       "      <td>0.67013</td>\n",
       "      <td>-1.14</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-107.06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>AUDUSD</td>\n",
       "      <td>[sl 0.67013]</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>866</th>\n",
       "      <td>161730009</td>\n",
       "      <td>195091356</td>\n",
       "      <td>2024-01-12 03:36:27</td>\n",
       "      <td>195080445</td>\n",
       "      <td>0.84</td>\n",
       "      <td>0.67023</td>\n",
       "      <td>-0.90</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-110.88</td>\n",
       "      <td>0.0</td>\n",
       "      <td>AUDUSD</td>\n",
       "      <td>[sl 0.67020]</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>867</th>\n",
       "      <td>161730018</td>\n",
       "      <td>195091366</td>\n",
       "      <td>2024-01-12 03:36:28</td>\n",
       "      <td>195080215</td>\n",
       "      <td>0.88</td>\n",
       "      <td>0.67029</td>\n",
       "      <td>-0.94</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-110.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>AUDUSD</td>\n",
       "      <td>[sl 0.67028]</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>868</th>\n",
       "      <td>161750565</td>\n",
       "      <td>195113547</td>\n",
       "      <td>2024-01-12 09:46:02</td>\n",
       "      <td>195081136</td>\n",
       "      <td>0.64</td>\n",
       "      <td>0.85349</td>\n",
       "      <td>-1.02</td>\n",
       "      <td>0.0</td>\n",
       "      <td>95.23</td>\n",
       "      <td>0.0</td>\n",
       "      <td>USDCHF</td>\n",
       "      <td>[tp 0.85346]</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>869 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        ticket      order                time  position_id  volume    price  \\\n",
       "0    161165043          0 2024-01-09 05:45:19            0    0.00  0.00000   \n",
       "1    161500016  194848597 2024-01-10 21:31:09    194848597    0.01  1.09691   \n",
       "2    161500020  194848603 2024-01-10 21:31:15    194848603    0.01  1.09690   \n",
       "3    161506542  194855360 2024-01-10 22:27:28    194848603    0.01  1.09645   \n",
       "4    161506544  194855363 2024-01-10 22:27:29    194848597    0.01  1.09648   \n",
       "..         ...        ...                 ...          ...     ...      ...   \n",
       "864  161726298  195086450 2024-01-12 01:58:33    195080711    1.09  0.66996   \n",
       "865  161728855  195090017 2024-01-12 02:55:08    195079846    1.06  0.67013   \n",
       "866  161730009  195091356 2024-01-12 03:36:27    195080445    0.84  0.67023   \n",
       "867  161730018  195091366 2024-01-12 03:36:28    195080215    0.88  0.67029   \n",
       "868  161750565  195113547 2024-01-12 09:46:02    195081136    0.64  0.85349   \n",
       "\n",
       "     commission  swap     profit  fee  symbol       comment external_id  \n",
       "0          0.00   0.0  100000.00  0.0                                    \n",
       "1         -0.02   0.0       0.00  0.0  EURUSD                            \n",
       "2         -0.02   0.0       0.00  0.0  EURUSD                            \n",
       "3         -0.02   0.0      -0.45  0.0  EURUSD                            \n",
       "4         -0.02   0.0      -0.43  0.0  EURUSD                            \n",
       "..          ...   ...        ...  ...     ...           ...         ...  \n",
       "864       -1.17   0.0    -110.09  0.0  AUDUSD  [sl 0.66996]              \n",
       "865       -1.14   0.0    -107.06  0.0  AUDUSD  [sl 0.67013]              \n",
       "866       -0.90   0.0    -110.88  0.0  AUDUSD  [sl 0.67020]              \n",
       "867       -0.94   0.0    -110.00  0.0  AUDUSD  [sl 0.67028]              \n",
       "868       -1.02   0.0      95.23  0.0  USDCHF  [tp 0.85346]              \n",
       "\n",
       "[869 rows x 13 columns]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# establish connection to the MetaTrader 5 terminal\n",
    "initialize= [\"51949125\", \"qtrvkk7i\", \"Alpari-MT5-Demo\"]\n",
    "mt5.initialize()\n",
    "mt5.login(login=initialize[0], password=initialize[1], server=initialize[2])\n",
    "\n",
    "# get the number of orders in history\n",
    "from_date=datetime(2020,1,1)\n",
    "to_date=datetime.now()\n",
    "history_orders=mt5.history_deals_get(from_date, to_date)\n",
    "\n",
    "# display these orders as a table using pandas.DataFrame\n",
    "tf=pd.DataFrame(list(history_orders),columns=history_orders[0]._asdict().keys())\n",
    "tf.drop(['time_msc','reason', 'type', 'entry', 'magic'], axis=1, inplace=True)\n",
    "tf['time'] = pd.to_datetime(tf['time'], unit='s')\n",
    "tf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Add High Impact"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import pytz\n",
    "import pandas as pd\n",
    "from datetime import datetime, timedelta\n",
    "import investpy\n",
    "from get_data import convert_to_gmt, fix_dataframe\n",
    "\n",
    "def get_calendar(from_date, timezone):\n",
    "    \n",
    "    now = datetime.now(timezone)\n",
    "    gmt_format = convert_to_gmt(now)\n",
    "\n",
    "    countries = [\"United States\", \"Australia\",\"Japan\", \"Euro Zone\", \"Germany\", \n",
    "        \"United Kingdom\", \"New Zealand\", \"Canada\", \"Switzerland\"]\n",
    "\n",
    "    df = investpy.news.economic_calendar(time_zone=gmt_format, countries=countries,\n",
    "                                        importances=[\"high\", \"medium\", \"low\"],\n",
    "                                        from_date=(from_date - timedelta(days=1)).strftime(\"%d/%m/%Y\"),\n",
    "                                        to_date=(now + timedelta(days=1)).strftime(\"%d/%m/%Y\"),\n",
    "                                        )\n",
    "    \n",
    "    df = fix_dataframe(tf=df)\n",
    "    # print(df)\n",
    "    # df.to_excel(f'static/{now.strftime(\"%Y-%m-%d_%H\")}.xlsx',index=False)\n",
    "    return df\n",
    "\n",
    "timezone = pytz.timezone('Asia/Tehran')\n",
    "df = pd.read_excel('./static/Report_mt5.xlsx')\n",
    "earliest_time = datetime.strptime(min(df['date_time']), \"%Y-%m-%d %H:%M:%S\")\n",
    "cal = get_calendar(earliest_time, timezone)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "# df = pd.read_excel('./static/Report_mt5.xlsx')\n",
    "# cal = pd.read_excel('./static/calendar.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date_Time</th>\n",
       "      <th>News</th>\n",
       "      <th>Country</th>\n",
       "      <th>Impact</th>\n",
       "      <th>Actual</th>\n",
       "      <th>Forecast</th>\n",
       "      <th>Previous</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2024-01-11 12:30:00</td>\n",
       "      <td>ECB Economic Bulletin</td>\n",
       "      <td>Euro Zone</td>\n",
       "      <td>medium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>2024-01-12 16:00:00</td>\n",
       "      <td>ECB's Lane Speaks</td>\n",
       "      <td>Euro Zone</td>\n",
       "      <td>medium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>2024-01-17 18:45:00</td>\n",
       "      <td>ECB President Lagarde Speaks</td>\n",
       "      <td>Euro Zone</td>\n",
       "      <td>medium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>2024-01-18 16:00:00</td>\n",
       "      <td>ECB Publishes Account of Monetary Policy Meeting</td>\n",
       "      <td>Euro Zone</td>\n",
       "      <td>medium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262</th>\n",
       "      <td>2024-01-18 18:45:00</td>\n",
       "      <td>ECB President Lagarde Speaks</td>\n",
       "      <td>Euro Zone</td>\n",
       "      <td>medium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299</th>\n",
       "      <td>2024-01-19 13:00:00</td>\n",
       "      <td>ECB McCaul Speaks</td>\n",
       "      <td>Euro Zone</td>\n",
       "      <td>medium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300</th>\n",
       "      <td>2024-01-19 13:30:00</td>\n",
       "      <td>ECB President Lagarde Speaks</td>\n",
       "      <td>Euro Zone</td>\n",
       "      <td>medium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>338</th>\n",
       "      <td>2024-01-22 17:30:00</td>\n",
       "      <td>ECB President Lagarde Speaks</td>\n",
       "      <td>Euro Zone</td>\n",
       "      <td>medium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>351</th>\n",
       "      <td>2024-01-23 12:30:00</td>\n",
       "      <td>ECB Bank Lending Survey</td>\n",
       "      <td>Euro Zone</td>\n",
       "      <td>low</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419</th>\n",
       "      <td>2024-01-25 16:45:00</td>\n",
       "      <td>ECB Marginal Lending Facility</td>\n",
       "      <td>Euro Zone</td>\n",
       "      <td>medium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>420</th>\n",
       "      <td>2024-01-25 16:45:00</td>\n",
       "      <td>ECB Monetary Policy Statement</td>\n",
       "      <td>Euro Zone</td>\n",
       "      <td>medium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421</th>\n",
       "      <td>2024-01-25 16:45:00</td>\n",
       "      <td>ECB Interest Rate Decision</td>\n",
       "      <td>Euro Zone</td>\n",
       "      <td>high</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>443</th>\n",
       "      <td>2024-01-25 17:15:00</td>\n",
       "      <td>ECB Press Conference</td>\n",
       "      <td>Euro Zone</td>\n",
       "      <td>high</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>446</th>\n",
       "      <td>2024-01-25 18:45:00</td>\n",
       "      <td>ECB President Lagarde Speaks</td>\n",
       "      <td>Euro Zone</td>\n",
       "      <td>medium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>2024-01-25 19:30:00</td>\n",
       "      <td>ECB President Lagarde Speaks</td>\n",
       "      <td>Euro Zone</td>\n",
       "      <td>medium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Date_Time                                              News  \\\n",
       "8   2024-01-11 12:30:00                             ECB Economic Bulletin   \n",
       "59  2024-01-12 16:00:00                                 ECB's Lane Speaks   \n",
       "214 2024-01-17 18:45:00                      ECB President Lagarde Speaks   \n",
       "248 2024-01-18 16:00:00  ECB Publishes Account of Monetary Policy Meeting   \n",
       "262 2024-01-18 18:45:00                      ECB President Lagarde Speaks   \n",
       "299 2024-01-19 13:00:00                                 ECB McCaul Speaks   \n",
       "300 2024-01-19 13:30:00                      ECB President Lagarde Speaks   \n",
       "338 2024-01-22 17:30:00                      ECB President Lagarde Speaks   \n",
       "351 2024-01-23 12:30:00                           ECB Bank Lending Survey   \n",
       "419 2024-01-25 16:45:00                     ECB Marginal Lending Facility   \n",
       "420 2024-01-25 16:45:00                     ECB Monetary Policy Statement   \n",
       "421 2024-01-25 16:45:00                        ECB Interest Rate Decision   \n",
       "443 2024-01-25 17:15:00                              ECB Press Conference   \n",
       "446 2024-01-25 18:45:00                      ECB President Lagarde Speaks   \n",
       "450 2024-01-25 19:30:00                      ECB President Lagarde Speaks   \n",
       "\n",
       "       Country  Impact  Actual  Forecast  Previous  \n",
       "8    Euro Zone  medium     NaN       NaN       NaN  \n",
       "59   Euro Zone  medium     NaN       NaN       NaN  \n",
       "214  Euro Zone  medium     NaN       NaN       NaN  \n",
       "248  Euro Zone  medium     NaN       NaN       NaN  \n",
       "262  Euro Zone  medium     NaN       NaN       NaN  \n",
       "299  Euro Zone  medium     NaN       NaN       NaN  \n",
       "300  Euro Zone  medium     NaN       NaN       NaN  \n",
       "338  Euro Zone  medium     NaN       NaN       NaN  \n",
       "351  Euro Zone     low     NaN       NaN       NaN  \n",
       "419  Euro Zone  medium     NaN       NaN      4.75  \n",
       "420  Euro Zone  medium     NaN       NaN       NaN  \n",
       "421  Euro Zone    high     NaN       4.5      4.50  \n",
       "443  Euro Zone    high     NaN       NaN       NaN  \n",
       "446  Euro Zone  medium     NaN       NaN       NaN  \n",
       "450  Euro Zone  medium     NaN       NaN       NaN  "
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cal[cal['News'].str.contains('ECB')]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date_Time</th>\n",
       "      <th>News</th>\n",
       "      <th>Country</th>\n",
       "      <th>Impact</th>\n",
       "      <th>Actual</th>\n",
       "      <th>Forecast</th>\n",
       "      <th>Previous</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>2024-01-12 16:00:00</td>\n",
       "      <td>ECB's Lane Speaks</td>\n",
       "      <td>Euro Zone</td>\n",
       "      <td>medium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Date_Time               News    Country  Impact  Actual  \\\n",
       "59 2024-01-12 16:00:00  ECB's Lane Speaks  Euro Zone  medium     NaN   \n",
       "\n",
       "    Forecast  Previous  \n",
       "59       NaN       NaN  "
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date_Time</th>\n",
       "      <th>News</th>\n",
       "      <th>Country</th>\n",
       "      <th>Impact</th>\n",
       "      <th>Actual</th>\n",
       "      <th>Forecast</th>\n",
       "      <th>Previous</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Date_Time, News, Country, Impact, Actual, Forecast, Previous]\n",
       "Index: []"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cal[cal['Date_Time']==df['date_time'].iloc[0]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "NIESR Monthly GDP Tracker\n",
      "NIESR Monthly GDP Tracker\n",
      "NIESR Monthly GDP Tracker\n",
      "NIESR Monthly GDP Tracker\n",
      "NIESR Monthly GDP Tracker\n",
      "NIESR Monthly GDP Tracker\n",
      "NIESR Monthly GDP Tracker\n",
      "NIESR Monthly GDP Tracker\n",
      "NIESR Monthly GDP Tracker\n",
      "NIESR Monthly GDP Tracker\n",
      "NIESR Monthly GDP Tracker\n",
      "NIESR Monthly GDP Tracker\n",
      "NIESR Monthly GDP Tracker\n",
      "NIESR Monthly GDP Tracker\n",
      "NIESR Monthly GDP Tracker\n",
      "MI Inflation Gauge (MoM)\n",
      "MI Inflation Gauge (MoM)\n",
      "MI Inflation Gauge (MoM)\n",
      "MI Inflation Gauge (MoM)\n",
      "MI Inflation Gauge (MoM)\n",
      "MI Inflation Gauge (MoM)\n",
      "MI Inflation Gauge (MoM)\n",
      "MI Inflation Gauge (MoM)\n",
      "MI Inflation Gauge (MoM)\n",
      "MI Inflation Gauge (MoM)\n",
      "MI Inflation Gauge (MoM)\n",
      "MI Inflation Gauge (MoM)\n",
      "MI Inflation Gauge (MoM)\n",
      "MI Inflation Gauge (MoM)\n",
      "10-Year Treasury Gilt Auction\n",
      "10-Year Treasury Gilt Auction\n",
      "10-Year Treasury Gilt Auction\n",
      "10-Year Treasury Gilt Auction\n",
      "10-Year Treasury Gilt Auction\n",
      "10-Year Treasury Gilt Auction\n",
      "10-Year Treasury Gilt Auction\n",
      "10-Year Treasury Gilt Auction\n",
      "10-Year Treasury Gilt Auction\n",
      "10-Year Treasury Gilt Auction\n",
      "10-Year Treasury Gilt Auction\n",
      "10-Year Treasury Gilt Auction\n",
      "10-Year Treasury Gilt Auction\n",
      "10-Year Treasury Gilt Auction\n",
      "10-Year Treasury Gilt Auction\n",
      "10-Year Treasury Gilt Auction\n",
      "10-Year Treasury Gilt Auction\n",
      "10-Year Treasury Gilt Auction\n",
      "10-Year Treasury Gilt Auction\n",
      "10-Year Treasury Gilt Auction\n",
      "10-Year Treasury Gilt Auction\n",
      "10-Year Treasury Gilt Auction\n",
      "Fed Vice Chair for Supervision Barr Speaks\n",
      "Fed Vice Chair for Supervision Barr Speaks\n",
      "10-Year Treasury Gilt Auction\n",
      "Fed Vice Chair for Supervision Barr Speaks\n",
      "Fed Vice Chair for Supervision Barr Speaks\n",
      "Fed Vice Chair for Supervision Barr Speaks\n",
      "Fed Vice Chair for Supervision Barr Speaks\n",
      "Fed Vice Chair for Supervision Barr Speaks\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date_time</th>\n",
       "      <th>news</th>\n",
       "      <th>impact</th>\n",
       "      <th>high impact</th>\n",
       "      <th>actual</th>\n",
       "      <th>forecast</th>\n",
       "      <th>previous</th>\n",
       "      <th>country</th>\n",
       "      <th>symbol</th>\n",
       "      <th>timeframe</th>\n",
       "      <th>...</th>\n",
       "      <th>comment</th>\n",
       "      <th>time2</th>\n",
       "      <th>volume2</th>\n",
       "      <th>price2</th>\n",
       "      <th>commission2</th>\n",
       "      <th>swap2</th>\n",
       "      <th>profit2</th>\n",
       "      <th>fee2</th>\n",
       "      <th>symbol2</th>\n",
       "      <th>comment2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2024-01-12 15:55:17</td>\n",
       "      <td>ECBs Lane Speaks</td>\n",
       "      <td>medium</td>\n",
       "      <td>medium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Euro Zone</td>\n",
       "      <td>EURNZD</td>\n",
       "      <td>0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>[tp 1.75538]</td>\n",
       "      <td>2024-01-12 15:04:40</td>\n",
       "      <td>1.57</td>\n",
       "      <td>1.75539</td>\n",
       "      <td>-2.75</td>\n",
       "      <td>0.0</td>\n",
       "      <td>84.14</td>\n",
       "      <td>0</td>\n",
       "      <td>EURNZD</td>\n",
       "      <td>[tp 1.75538]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2024-01-12 15:55:17</td>\n",
       "      <td>ECBs Lane Speaks</td>\n",
       "      <td>medium</td>\n",
       "      <td>medium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Euro Zone</td>\n",
       "      <td>GBPNZD</td>\n",
       "      <td>0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>[tp 2.04097]</td>\n",
       "      <td>2024-01-12 14:48:02</td>\n",
       "      <td>2.43</td>\n",
       "      <td>2.04099</td>\n",
       "      <td>-4.95</td>\n",
       "      <td>0.0</td>\n",
       "      <td>42.42</td>\n",
       "      <td>0</td>\n",
       "      <td>GBPNZD</td>\n",
       "      <td>[tp 2.04097]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2024-01-12 15:55:17</td>\n",
       "      <td>ECBs Lane Speaks</td>\n",
       "      <td>medium</td>\n",
       "      <td>medium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Euro Zone</td>\n",
       "      <td>GBPUSD</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>[tp 1.27289]</td>\n",
       "      <td>2024-01-12 14:48:51</td>\n",
       "      <td>4.35</td>\n",
       "      <td>1.27294</td>\n",
       "      <td>-8.86</td>\n",
       "      <td>0.0</td>\n",
       "      <td>78.30</td>\n",
       "      <td>0</td>\n",
       "      <td>GBPUSD</td>\n",
       "      <td>[tp 1.27289]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2024-01-12 15:55:17</td>\n",
       "      <td>ECBs Lane Speaks</td>\n",
       "      <td>medium</td>\n",
       "      <td>medium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Euro Zone</td>\n",
       "      <td>EURGBP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>[sl 0.85938]</td>\n",
       "      <td>2024-01-12 14:56:28</td>\n",
       "      <td>2.53</td>\n",
       "      <td>0.85938</td>\n",
       "      <td>-4.43</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-109.49</td>\n",
       "      <td>0</td>\n",
       "      <td>EURGBP</td>\n",
       "      <td>[sl 0.85938]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2024-01-12 15:55:17</td>\n",
       "      <td>ECBs Lane Speaks</td>\n",
       "      <td>medium</td>\n",
       "      <td>medium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Euro Zone</td>\n",
       "      <td>GBPJPY</td>\n",
       "      <td>1.5</td>\n",
       "      <td>...</td>\n",
       "      <td>[sl 185.228]</td>\n",
       "      <td>2024-01-12 15:05:45</td>\n",
       "      <td>1.50</td>\n",
       "      <td>185.22900</td>\n",
       "      <td>-3.06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-119.60</td>\n",
       "      <td>0</td>\n",
       "      <td>GBPJPY</td>\n",
       "      <td>[sl 185.228]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>666</th>\n",
       "      <td>2024-01-19 10:55:25</td>\n",
       "      <td>PPI (YoY)</td>\n",
       "      <td>low</td>\n",
       "      <td>medium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.3</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>GBPUSD</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>[sl 1.26756]</td>\n",
       "      <td>2024-01-19 10:19:26</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1.26751</td>\n",
       "      <td>-4.06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-128.00</td>\n",
       "      <td>0</td>\n",
       "      <td>GBPUSD</td>\n",
       "      <td>[sl 1.26756]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>667</th>\n",
       "      <td>2024-01-19 10:55:25</td>\n",
       "      <td>PPI (YoY)</td>\n",
       "      <td>low</td>\n",
       "      <td>medium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.3</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>NZDCHF</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>[sl 0.53088]</td>\n",
       "      <td>2024-01-19 11:35:25</td>\n",
       "      <td>1.42</td>\n",
       "      <td>0.53088</td>\n",
       "      <td>-1.39</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-138.92</td>\n",
       "      <td>0</td>\n",
       "      <td>NZDCHF</td>\n",
       "      <td>[sl 0.53088]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>668</th>\n",
       "      <td>2024-01-19 10:55:25</td>\n",
       "      <td>PPI (YoY)</td>\n",
       "      <td>low</td>\n",
       "      <td>medium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.3</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>EURNZD</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>[sl 1.78145]</td>\n",
       "      <td>2024-01-19 10:04:25</td>\n",
       "      <td>1.80</td>\n",
       "      <td>1.78144</td>\n",
       "      <td>-3.13</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-142.90</td>\n",
       "      <td>0</td>\n",
       "      <td>EURNZD</td>\n",
       "      <td>[sl 1.78145]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>669</th>\n",
       "      <td>2024-01-19 10:55:25</td>\n",
       "      <td>PPI (YoY)</td>\n",
       "      <td>low</td>\n",
       "      <td>medium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.3</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>EURGBP</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>[tp 0.85752]</td>\n",
       "      <td>2024-01-19 11:05:08</td>\n",
       "      <td>1.16</td>\n",
       "      <td>0.85752</td>\n",
       "      <td>-2.02</td>\n",
       "      <td>0.0</td>\n",
       "      <td>88.25</td>\n",
       "      <td>0</td>\n",
       "      <td>EURGBP</td>\n",
       "      <td>[tp 0.85752]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>670</th>\n",
       "      <td>2024-01-19 10:55:25</td>\n",
       "      <td>PPI (YoY)</td>\n",
       "      <td>low</td>\n",
       "      <td>medium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.3</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>EURNZD</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>[sl 1.78145]</td>\n",
       "      <td>2024-01-19 10:04:25</td>\n",
       "      <td>1.80</td>\n",
       "      <td>1.78144</td>\n",
       "      <td>-3.13</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-142.90</td>\n",
       "      <td>0</td>\n",
       "      <td>EURNZD</td>\n",
       "      <td>[sl 1.78145]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>671 rows × 43 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               date_time              news  impact high impact  actual  \\\n",
       "0    2024-01-12 15:55:17  ECBs Lane Speaks  medium      medium     NaN   \n",
       "1    2024-01-12 15:55:17  ECBs Lane Speaks  medium      medium     NaN   \n",
       "2    2024-01-12 15:55:17  ECBs Lane Speaks  medium      medium     NaN   \n",
       "3    2024-01-12 15:55:17  ECBs Lane Speaks  medium      medium     NaN   \n",
       "4    2024-01-12 15:55:17  ECBs Lane Speaks  medium      medium     NaN   \n",
       "..                   ...               ...     ...         ...     ...   \n",
       "666  2024-01-19 10:55:25         PPI (YoY)     low      medium     NaN   \n",
       "667  2024-01-19 10:55:25         PPI (YoY)     low      medium     NaN   \n",
       "668  2024-01-19 10:55:25         PPI (YoY)     low      medium     NaN   \n",
       "669  2024-01-19 10:55:25         PPI (YoY)     low      medium     NaN   \n",
       "670  2024-01-19 10:55:25         PPI (YoY)     low      medium     NaN   \n",
       "\n",
       "     forecast  previous      country  symbol  timeframe  ...       comment  \\\n",
       "0         NaN       NaN    Euro Zone  EURNZD        0.5  ...  [tp 1.75538]   \n",
       "1         NaN       NaN    Euro Zone  GBPNZD        0.5  ...  [tp 2.04097]   \n",
       "2         NaN       NaN    Euro Zone  GBPUSD        1.0  ...  [tp 1.27289]   \n",
       "3         NaN       NaN    Euro Zone  EURGBP        1.0  ...  [sl 0.85938]   \n",
       "4         NaN       NaN    Euro Zone  GBPJPY        1.5  ...  [sl 185.228]   \n",
       "..        ...       ...          ...     ...        ...  ...           ...   \n",
       "666       NaN      -1.3  Switzerland  GBPUSD        2.0  ...  [sl 1.26756]   \n",
       "667       NaN      -1.3  Switzerland  NZDCHF        2.0  ...  [sl 0.53088]   \n",
       "668       NaN      -1.3  Switzerland  EURNZD        2.0  ...  [sl 1.78145]   \n",
       "669       NaN      -1.3  Switzerland  EURGBP        2.0  ...  [tp 0.85752]   \n",
       "670       NaN      -1.3  Switzerland  EURNZD        2.0  ...  [sl 1.78145]   \n",
       "\n",
       "                  time2 volume2     price2  commission2  swap2  profit2  fee2  \\\n",
       "0   2024-01-12 15:04:40    1.57    1.75539        -2.75    0.0    84.14     0   \n",
       "1   2024-01-12 14:48:02    2.43    2.04099        -4.95    0.0    42.42     0   \n",
       "2   2024-01-12 14:48:51    4.35    1.27294        -8.86    0.0    78.30     0   \n",
       "3   2024-01-12 14:56:28    2.53    0.85938        -4.43    0.0  -109.49     0   \n",
       "4   2024-01-12 15:05:45    1.50  185.22900        -3.06    0.0  -119.60     0   \n",
       "..                  ...     ...        ...          ...    ...      ...   ...   \n",
       "666 2024-01-19 10:19:26    2.00    1.26751        -4.06    0.0  -128.00     0   \n",
       "667 2024-01-19 11:35:25    1.42    0.53088        -1.39    0.0  -138.92     0   \n",
       "668 2024-01-19 10:04:25    1.80    1.78144        -3.13    0.0  -142.90     0   \n",
       "669 2024-01-19 11:05:08    1.16    0.85752        -2.02    0.0    88.25     0   \n",
       "670 2024-01-19 10:04:25    1.80    1.78144        -3.13    0.0  -142.90     0   \n",
       "\n",
       "     symbol2      comment2  \n",
       "0     EURNZD  [tp 1.75538]  \n",
       "1     GBPNZD  [tp 2.04097]  \n",
       "2     GBPUSD  [tp 1.27289]  \n",
       "3     EURGBP  [sl 0.85938]  \n",
       "4     GBPJPY  [sl 185.228]  \n",
       "..       ...           ...  \n",
       "666   GBPUSD  [sl 1.26756]  \n",
       "667   NZDCHF  [sl 0.53088]  \n",
       "668   EURNZD  [sl 1.78145]  \n",
       "669   EURGBP  [tp 0.85752]  \n",
       "670   EURNZD  [sl 1.78145]  \n",
       "\n",
       "[671 rows x 43 columns]"
      ]
     },
     "execution_count": 102,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def max_impact(array):\n",
    "    if 'high' in array.unique():\n",
    "        return 'high'\n",
    "    elif 'medium' in array.unique():\n",
    "        return 'medium'\n",
    "    else:\n",
    "        return 'low'\n",
    "\n",
    "new_row = []\n",
    "for i, row in df.iterrows():\n",
    "    news = row['news']\n",
    "    country = row['country']\n",
    "    news_time = (datetime.strptime(row['date_time'], \"%Y-%m-%d %H:%M:%S\")+timedelta(minutes=5)).strftime(\"%Y-%m-%d %H:%M:00\")\n",
    "    news_on_that_time = cal[cal['Date_Time']==news_time]\n",
    "    if news_on_that_time.empty:\n",
    "        print(news)\n",
    "        new_row.append(None)\n",
    "    else:\n",
    "\n",
    "        new_row.append(max_impact(news_on_that_time['Impact']))\n",
    "\n",
    "df['high impact']=new_row\n",
    "\n",
    "df[['date_time', 'news', 'impact', 'high impact', 'actual', 'forecast', 'previous',\n",
    "       'country', 'symbol', 'timeframe', 'action', 'volume', 'open_time',\n",
    "       'price', 'rr', 'risk', 'sl', 'tp', 'profit', 'ticket', 'close_time',\n",
    "       'risk-free_price', 'risk-free_sl', 'risk-free_tp', 'risk-free_profit',\n",
    "       'risk-free_close_time', 'n.s.a (MoM)', 'time_open_history',\n",
    "       'price_current_history_open', 'sl_history', 'tp_history',\n",
    "       'price_current_history_close', 'time_close_history', 'comment', 'time2',\n",
    "       'volume2', 'price2', 'commission2', 'swap2', 'profit2', 'fee2',\n",
    "       'symbol2', 'comment2']\n",
    "]\n",
    "df\n",
    "    \n",
    "    # news_and_time = cal[cal['News']==news]\n",
    "    # if news_and_time.empty:\n",
    "    #     if news == 'ECBs Lane Speaks':\n",
    "    #         news = \"ECB's Lane Speaks\"\n",
    "    #         news_and_time = cal[cal['News']==news]\n",
    "    #         print(news_and_time)\n",
    "    #         break\n",
    "    #     elif news == 'Feds Balance Sheet':\n",
    "    #         news = \"Fed's Balance Sheet\"\n",
    "    #         news_and_time = cal[cal['News']==news]\n",
    "    #     else:\n",
    "    #         print(news)\n",
    "\n",
    "    # news_and_time_and_country= news_and_time[news_and_time['Country'] == country]\n",
    "    # # fix calendar\n",
    "    # if news_and_time_and_country.empty:\n",
    "    #     print(row)\n",
    "    # news_time = news_and_time_and_country['Date_Time'].iloc[0]\n",
    "    # news_on_that_time = cal[cal['Date_Time'] == news_time]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 100,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'low' in df['impact'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0      False\n",
       "1      False\n",
       "2      False\n",
       "3      False\n",
       "4      False\n",
       "       ...  \n",
       "464    False\n",
       "465    False\n",
       "466    False\n",
       "467    False\n",
       "468    False\n",
       "Name: Date_Time, Length: 469, dtype: bool"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cal[cal['Date_Time'] == news_time.iloc[0]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "ename": "ValueError",
     "evalue": "Can only compare identically-labeled Series objects",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mValueError\u001b[0m                                Traceback (most recent call last)",
      "Cell \u001b[1;32mIn[14], line 1\u001b[0m\n\u001b[1;32m----> 1\u001b[0m cal[\u001b[43mcal\u001b[49m\u001b[43m[\u001b[49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[38;5;124;43mDate_Time\u001b[39;49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[43m]\u001b[49m\u001b[43m \u001b[49m\u001b[38;5;241;43m==\u001b[39;49m\u001b[43m \u001b[49m\u001b[43mnews_time\u001b[49m]\n",
      "File \u001b[1;32mc:\\Users\\m3maf\\anaconda3\\envs\\forex\\lib\\site-packages\\pandas\\core\\ops\\common.py:76\u001b[0m, in \u001b[0;36m_unpack_zerodim_and_defer.<locals>.new_method\u001b[1;34m(self, other)\u001b[0m\n\u001b[0;32m     72\u001b[0m             \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28mNotImplemented\u001b[39m\n\u001b[0;32m     74\u001b[0m other \u001b[38;5;241m=\u001b[39m item_from_zerodim(other)\n\u001b[1;32m---> 76\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[43mmethod\u001b[49m\u001b[43m(\u001b[49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mother\u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[1;32mc:\\Users\\m3maf\\anaconda3\\envs\\forex\\lib\\site-packages\\pandas\\core\\arraylike.py:40\u001b[0m, in \u001b[0;36mOpsMixin.__eq__\u001b[1;34m(self, other)\u001b[0m\n\u001b[0;32m     38\u001b[0m \u001b[38;5;129m@unpack_zerodim_and_defer\u001b[39m(\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124m__eq__\u001b[39m\u001b[38;5;124m\"\u001b[39m)\n\u001b[0;32m     39\u001b[0m \u001b[38;5;28;01mdef\u001b[39;00m \u001b[38;5;21m__eq__\u001b[39m(\u001b[38;5;28mself\u001b[39m, other):\n\u001b[1;32m---> 40\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_cmp_method\u001b[49m\u001b[43m(\u001b[49m\u001b[43mother\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43moperator\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43meq\u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[1;32mc:\\Users\\m3maf\\anaconda3\\envs\\forex\\lib\\site-packages\\pandas\\core\\series.py:5794\u001b[0m, in \u001b[0;36mSeries._cmp_method\u001b[1;34m(self, other, op)\u001b[0m\n\u001b[0;32m   5791\u001b[0m res_name \u001b[38;5;241m=\u001b[39m ops\u001b[38;5;241m.\u001b[39mget_op_result_name(\u001b[38;5;28mself\u001b[39m, other)\n\u001b[0;32m   5793\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;28misinstance\u001b[39m(other, Series) \u001b[38;5;129;01mand\u001b[39;00m \u001b[38;5;129;01mnot\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_indexed_same(other):\n\u001b[1;32m-> 5794\u001b[0m     \u001b[38;5;28;01mraise\u001b[39;00m \u001b[38;5;167;01mValueError\u001b[39;00m(\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mCan only compare identically-labeled Series objects\u001b[39m\u001b[38;5;124m\"\u001b[39m)\n\u001b[0;32m   5796\u001b[0m lvalues \u001b[38;5;241m=\u001b[39m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_values\n\u001b[0;32m   5797\u001b[0m rvalues \u001b[38;5;241m=\u001b[39m extract_array(other, extract_numpy\u001b[38;5;241m=\u001b[39m\u001b[38;5;28;01mTrue\u001b[39;00m, extract_range\u001b[38;5;241m=\u001b[39m\u001b[38;5;28;01mTrue\u001b[39;00m)\n",
      "\u001b[1;31mValueError\u001b[0m: Can only compare identically-labeled Series objects"
     ]
    }
   ],
   "source": [
    "cal[cal['Date_Time'] == news_time]"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "forex",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.18"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}