{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "6ba03e09",
   "metadata": {},
   "source": [
    "# Monitorare"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "2f135ac6",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import time\n",
    "from datetime import datetime, timedelta, timezone\n",
    "import tpqoa"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f0f41f63",
   "metadata": {},
   "source": [
    "Il codice fino ad ora"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "f83f4f05",
   "metadata": {},
   "outputs": [],
   "source": [
    "class Trader(tpqoa.tpqoa):\n",
    "    \n",
    "    def __init__(self,config_file, instrument, period, window, units):\n",
    "        super().__init__(config_file)\n",
    "        self.instrument = instrument\n",
    "        self.period=period\n",
    "        self.tickData = pd.DataFrame()\n",
    "        self.rawData = None \n",
    "        self.ultimoPeriodo = None \n",
    "        self.data = None\n",
    "        self.units = units\n",
    "        self.posizione = 0\n",
    "        \n",
    "        ########################## STRATEGY SPECIFIC ATTRIBUTES ##############################\n",
    "        self.window = window\n",
    "        \n",
    "    def getMostRecent(self, days=5): \n",
    "        '''questo metodo scarica i dati FINO ad adesso'''\n",
    "        while True:\n",
    "            now = datetime.now(timezone.utc)\n",
    "            now = now - timedelta(microseconds = now.microsecond) # pay attention, microseconds and then microsecond (singular!!!)\n",
    "            yesterday = now - timedelta(days= days) # lo chiamo YESTERDAY, ma è l'inizio del periodo da scaricare\n",
    "            df = self.get_history(instrument = self.instrument, start = str(yesterday)[:-6], end = str(now)[:-6],\n",
    "                        granularity= \"S5\", price=\"M\", localize=False)[\"c\"].to_frame() \n",
    "                        # scarico a 5secondi, il che vuol dire che period non può essere più corto!\n",
    "            df.rename(columns={\"c\":self.instrument},inplace=True)\n",
    "            self.rawData = df.resample(self.period, label=\"right\").last().dropna().iloc[:-1]\n",
    "            self.ultimoPeriodo = self.rawData.index[-1]\n",
    "            if pd.to_datetime(datetime.now(timezone.utc)) - self.ultimoPeriodo < pd.to_timedelta(self.period):\n",
    "                break\n",
    "            else:\n",
    "                time.sleep(2)\n",
    "    \n",
    "    def on_success(self, time, bid, ask):\n",
    "        print(self.ticks, end=\" \")\n",
    "        tickCorrente = pd.to_datetime(time)\n",
    "        df = pd.DataFrame({self.instrument:(ask+bid)/2}, index=[tickCorrente])\n",
    "        self.tickData=pd.concat((self.tickData,df),axis=0)\n",
    "        if tickCorrente - self.ultimoPeriodo > pd.to_timedelta(self.period):\n",
    "            self.resampleJoin()\n",
    "            self.defineStrategy()\n",
    "            self.executeTrade()\n",
    "    \n",
    "    def resampleJoin(self):\n",
    "        self.rawData=pd.concat((self.rawData,self.tickData.resample(self.period,label=\"right\").last().ffill().iloc[:-1] ),axis=0)\n",
    "        self.tickData = self.tickData.iloc[-1:] \n",
    "        self.ultimoPeriodo = self.rawData.index[-1] \n",
    "        \n",
    "    def defineStrategy(self):\n",
    "        df = self.rawData.copy()\n",
    "        df[\"logRet\"]=np.log(df[self.instrument] / df[self.instrument].shift(1))\n",
    "        df[\"posizione\"]= - np.sign(df.logRet.rolling(self.window).mean())\n",
    "        self.data = df.copy()\n",
    "        \n",
    "    def executeTrade(self):\n",
    "        if self.data.posizione.iloc[-1] == 1: # andiamo lunghi\n",
    "            if self.posizione == 0:\n",
    "                order = self.create_order(instrument = self.instrument, units = self.units, suppress=True, ret = True)\n",
    "                print(\"VADO LUNGO\",self.units,order[\"price\"])\n",
    "            elif self.posizione == -1:\n",
    "                order = self.create_order(instrument = self.instrument, units = 2*self.units, suppress=True, ret = True)\n",
    "                print(\"CHIUDO POSIZIONE CORTA E VADO LUNGO\",2*self.units,order[\"price\"])\n",
    "            self.posizione=1\n",
    "        elif self.data.posizione.iloc[-1] == -1: # andiamo corti\n",
    "            if self.posizione == 0:\n",
    "                order = self.create_order(instrument = self.instrument, units = -self.units, suppress=True, ret = True)\n",
    "                print(\"VADO CORTO\",-self.units,order[\"price\"])\n",
    "            elif self.posizione == 1:\n",
    "                order = self.create_order(instrument = self.instrument, units = -2*self.units, suppress=True, ret = True)\n",
    "                print(\"CHIUDO POSIZIONE LUNGA E VADO CORTO\",-2*self.units,order[\"price\"])\n",
    "            self.posizione=-1\n",
    "        elif self.data.posizione.iloc[-1] == 0: # andiamo neutri\n",
    "            if self.posizione == 1:\n",
    "                order = self.create_order(instrument = self.instrument, units = -self.units, suppress=True, ret = True)\n",
    "                print(\"CHIUDO POSIZIONE LUNGA\",-self.units,order[\"price\"])\n",
    "            elif self.posizione == -1:\n",
    "                order = self.create_order(instrument = self.instrument, units = self.units, suppress=True, ret = True)\n",
    "                print(\"CHIUDO POSIZIONE CORTA\",self.units,order[\"price\"])\n",
    "            self.posizione=0\n",
    "        "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d4de5836",
   "metadata": {},
   "source": [
    "Aggiungiamo un metodo report_trade e modifichiamo i print in execute_trade"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "c92f3919",
   "metadata": {},
   "outputs": [],
   "source": [
    "class Trader(tpqoa.tpqoa):\n",
    "    \n",
    "    def __init__(self,config_file, instrument, period, window, units):\n",
    "        super().__init__(config_file)\n",
    "        self.instrument = instrument\n",
    "        self.period=period\n",
    "        self.tickData = pd.DataFrame()\n",
    "        self.rawData = None \n",
    "        self.ultimoPeriodo = None \n",
    "        self.data = None\n",
    "        self.units = units\n",
    "        self.posizione = 0\n",
    "        # NEW\n",
    "        self.profits = [] # lista dei profitti\n",
    "        \n",
    "        ########################## STRATEGY SPECIFIC ATTRIBUTES ##############################\n",
    "        self.window = window\n",
    "        \n",
    "    def getMostRecent(self, days=5): \n",
    "        '''questo metodo scarica i dati FINO ad adesso'''\n",
    "        while True:\n",
    "            now = datetime.now(timezone.utc)\n",
    "            now = now - timedelta(microseconds = now.microsecond) # pay attention, microseconds and then microsecond (singular!!!)\n",
    "            yesterday = now - timedelta(days= days) # lo chiamo YESTERDAY, ma è l'inizio del periodo da scaricare\n",
    "            df = self.get_history(instrument = self.instrument, start = str(yesterday)[:-6], end = str(now)[:-6],\n",
    "                        granularity= \"S5\", price=\"M\", localize=False)[\"c\"].to_frame() \n",
    "                        # scarico a 5secondi, il che vuol dire che period non può essere più corto!\n",
    "            df.rename(columns={\"c\":self.instrument},inplace=True)\n",
    "            self.rawData = df.resample(self.period, label=\"right\").last().dropna().iloc[:-1]\n",
    "            self.ultimoPeriodo = self.rawData.index[-1]\n",
    "            if pd.to_datetime(datetime.now(timezone.utc)) - self.ultimoPeriodo < pd.to_timedelta(self.period):\n",
    "                break\n",
    "            else:\n",
    "                time.sleep(2)\n",
    "    \n",
    "    def on_success(self, time, bid, ask):\n",
    "        print(self.ticks, end=\" \")\n",
    "        tickCorrente = pd.to_datetime(time)\n",
    "        df = pd.DataFrame({self.instrument:(ask+bid)/2}, index=[tickCorrente])\n",
    "        self.tickData=pd.concat((self.tickData,df),axis=0)\n",
    "        if tickCorrente - self.ultimoPeriodo > pd.to_timedelta(self.period):\n",
    "            self.resampleJoin()\n",
    "            self.defineStrategy()\n",
    "            self.executeTrade()\n",
    "    \n",
    "    def resampleJoin(self):\n",
    "        self.rawData=pd.concat((self.rawData,self.tickData.resample(self.period,label=\"right\").last().ffill().iloc[:-1] ),axis=0)\n",
    "        self.tickData = self.tickData.iloc[-1:] \n",
    "        self.ultimoPeriodo = self.rawData.index[-1] \n",
    "        \n",
    "    def defineStrategy(self):\n",
    "        df = self.rawData.copy()\n",
    "        df[\"logRet\"]=np.log(df[self.instrument] / df[self.instrument].shift(1))\n",
    "        df[\"posizione\"]= - np.sign(df.logRet.rolling(self.window).mean())\n",
    "        self.data = df.copy()\n",
    "        \n",
    "    def executeTrade(self):\n",
    "        if self.data.posizione.iloc[-1] == 1: # andiamo lunghi\n",
    "            if self.posizione == 0:\n",
    "                order = self.create_order(instrument = self.instrument, units = self.units, suppress=True, ret = True)\n",
    "                self.report_trade(order,\"VADO LUNGO\") #NEW!\n",
    "            elif self.posizione == -1:\n",
    "                order = self.create_order(instrument = self.instrument, units = 2*self.units, suppress=True, ret = True)\n",
    "                self.report_trade(order,\"CHIUDO POSIZIONE CORTA E VADO LUNGO\") #NEW!\n",
    "            self.posizione=1\n",
    "        elif self.data.posizione.iloc[-1] == -1: # andiamo corti\n",
    "            if self.posizione == 0:\n",
    "                order = self.create_order(instrument = self.instrument, units = -self.units, suppress=True, ret = True)\n",
    "                self.report_trade(order,\"VADO CORTO\") #NEW!\n",
    "            elif self.posizione == 1:\n",
    "                order = self.create_order(instrument = self.instrument, units = -2*self.units, suppress=True, ret = True)\n",
    "                self.report_trade(order,\"CHIUDO POSIZIONE LUNGA E VADO CORTO\") #NEW!\n",
    "            self.posizione=-1\n",
    "        elif self.data.posizione.iloc[-1] == 0: # andiamo neutri\n",
    "            if self.posizione == 1:\n",
    "                order = self.create_order(instrument = self.instrument, units = -self.units, suppress=True, ret = True)\n",
    "                self.report_trade(order,\"CHIUDO POSIZIONE LUNGA\") #NEW!\n",
    "            elif self.posizione == -1:\n",
    "                order = self.create_order(instrument = self.instrument, units = self.units, suppress=True, ret = True)\n",
    "                self.report_trade(order,\"CHIUDO POSIZIONE CORTA\") #NEW!\n",
    "            self.posizione=0\n",
    "            \n",
    "    #NEW!\n",
    "    def report_trade(self,order,message):\n",
    "        time=order[\"time\"]\n",
    "        units=order[\"units\"]\n",
    "        price=order[\"price\"]\n",
    "        pl=float(order[\"pl\"]) # profit/loss\n",
    "        self.profits.append(pl)\n",
    "        cumpl=sum(self.profits)\n",
    "        print(\"\\n-------------------------------------------------\")\n",
    "        print(time,\"|\",message)\n",
    "        print(\"quantita=\",units,\"| prezzo=\",price,\"| profit/loss=\",pl,\"| profitto totale=\",cumpl)\n",
    "        print(\"-------------------------------------------------\")\n",
    "        \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "efe1f5cc",
   "metadata": {},
   "outputs": [],
   "source": [
    "trader = Trader(\"oandaMY.cfg\",\"EUR_USD\",\"1min\", window=1, units=100000)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "c038e645",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2024-11-18 08:47:38.337944+00:00\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\ProgramData\\anaconda3\\Lib\\site-packages\\tpqoa\\tpqoa.py:223: FutureWarning: 'H' is deprecated and will be removed in a future version, please use 'h' instead.\n",
      "  dr = pd.date_range(start, end, freq=freq)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 \n",
      "-------------------------------------------------\n",
      "2024-11-18T08:48:00.669532614Z | VADO CORTO\n",
      "quantita= -100000.0 | prezzo= 1.05479 | profit/loss= 0.0 | profitto totale= 0.0\n",
      "-------------------------------------------------\n",
      "23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 \n",
      "-------------------------------------------------\n",
      "2024-11-18T08:49:00.656553916Z | CHIUDO POSIZIONE CORTA E VADO LUNGO\n",
      "quantita= 200000.0 | prezzo= 1.05482 | profit/loss= -2.8584 | profitto totale= -2.8584\n",
      "-------------------------------------------------\n",
      "86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 "
     ]
    }
   ],
   "source": [
    "print(datetime.now(timezone.utc))\n",
    "trader.getMostRecent()\n",
    "trader.stream_data(trader.instrument,stop=150)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "6e4767ba",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "-------------------------------------------------\n",
      "2024-11-18T08:49:52.929369437Z | CHIUDO TUTTO\n",
      "quantita= -100000.0 | prezzo= 1.05479 | profit/loss= -2.8583 | profitto totale= -5.7166999999999994\n",
      "-------------------------------------------------\n"
     ]
    }
   ],
   "source": [
    "if trader.posizione != 0:\n",
    "    close_all=trader.create_order(trader.instrument, units=-trader.posizione*trader.units,suppress=True,ret=True)\n",
    "    trader.report_trade(close_all,\"CHIUDO TUTTO\")\n",
    "    trader.posizione=0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "47f04aa1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "trader.get_positions()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "7fa0db48",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[0.0, -2.8584, -2.8583]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "trader.profits"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a87c40e0",
   "metadata": {},
   "source": [
    "Inseriamo la chiusura finale in stream_data direttamente"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "b7e2276e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\u001b[1;31mSignature:\u001b[0m \u001b[0mtrader\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mstream_data\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0minstrument\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mstop\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;32mNone\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mret\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;32mFalse\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mcallback\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;32mNone\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
       "\u001b[1;31mSource:\u001b[0m   \n",
       "    \u001b[1;32mdef\u001b[0m \u001b[0mstream_data\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0minstrument\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mstop\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;32mNone\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mret\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;32mFalse\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mcallback\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;32mNone\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\n",
       "\u001b[0m        \u001b[1;34m''' Starts a real-time data stream.\n",
       "\n",
       "        Parameters\n",
       "        ==========\n",
       "        instrument: string\n",
       "            valid instrument name\n",
       "        '''\u001b[0m\u001b[1;33m\n",
       "\u001b[0m        \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mstream_instrument\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0minstrument\u001b[0m\u001b[1;33m\n",
       "\u001b[0m        \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mticks\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;36m0\u001b[0m\u001b[1;33m\n",
       "\u001b[0m        \u001b[0mresponse\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mctx_stream\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mpricing\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mstream\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m\n",
       "\u001b[0m            \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0maccount_id\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0msnapshot\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;32mTrue\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\n",
       "\u001b[0m            \u001b[0minstruments\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0minstrument\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\n",
       "\u001b[0m        \u001b[0mmsgs\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;33m[\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\n",
       "\u001b[0m        \u001b[1;32mfor\u001b[0m \u001b[0mmsg_type\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmsg\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mresponse\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mparts\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\n",
       "\u001b[0m            \u001b[0mmsgs\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmsg\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\n",
       "\u001b[0m            \u001b[1;31m# print(msg_type, msg)\u001b[0m\u001b[1;33m\n",
       "\u001b[0m            \u001b[1;32mif\u001b[0m \u001b[0mmsg_type\u001b[0m \u001b[1;33m==\u001b[0m \u001b[1;34m'pricing.ClientPrice'\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\n",
       "\u001b[0m                \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mticks\u001b[0m \u001b[1;33m+=\u001b[0m \u001b[1;36m1\u001b[0m\u001b[1;33m\n",
       "\u001b[0m                \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtime\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mmsg\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtime\u001b[0m\u001b[1;33m\n",
       "\u001b[0m                \u001b[1;32mif\u001b[0m \u001b[0mcallback\u001b[0m \u001b[1;32mis\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[1;32mNone\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\n",
       "\u001b[0m                    \u001b[0mcallback\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmsg\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0minstrument\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmsg\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtime\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\n",
       "\u001b[0m                             \u001b[0mfloat\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmsg\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mbids\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;36m0\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mdict\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'price'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\n",
       "\u001b[0m                             \u001b[0mfloat\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmsg\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0masks\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;36m0\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mdict\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'price'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\n",
       "\u001b[0m                \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\n",
       "\u001b[0m                    \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mon_success\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmsg\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtime\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\n",
       "\u001b[0m                                    \u001b[0mfloat\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmsg\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mbids\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;36m0\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mdict\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'price'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\n",
       "\u001b[0m                                    \u001b[0mfloat\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmsg\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0masks\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;36m0\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mdict\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'price'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\n",
       "\u001b[0m                \u001b[1;32mif\u001b[0m \u001b[0mstop\u001b[0m \u001b[1;32mis\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[1;32mNone\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\n",
       "\u001b[0m                    \u001b[1;32mif\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mticks\u001b[0m \u001b[1;33m>=\u001b[0m \u001b[0mstop\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\n",
       "\u001b[0m                        \u001b[1;32mif\u001b[0m \u001b[0mret\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\n",
       "\u001b[0m                            \u001b[1;32mreturn\u001b[0m \u001b[0mmsgs\u001b[0m\u001b[1;33m\n",
       "\u001b[0m                        \u001b[1;32mbreak\u001b[0m\u001b[1;33m\n",
       "\u001b[0m            \u001b[1;32mif\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mstop_stream\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\n",
       "\u001b[0m                \u001b[1;32mif\u001b[0m \u001b[0mret\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\n",
       "\u001b[0m                    \u001b[1;32mreturn\u001b[0m \u001b[0mmsgs\u001b[0m\u001b[1;33m\n",
       "\u001b[0m                \u001b[1;32mbreak\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
       "\u001b[1;31mFile:\u001b[0m      c:\\programdata\\anaconda3\\lib\\site-packages\\tpqoa\\tpqoa.py\n",
       "\u001b[1;31mType:\u001b[0m      method"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "trader.stream_data??"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "6b4a7b8d",
   "metadata": {},
   "outputs": [],
   "source": [
    "class Trader(tpqoa.tpqoa):\n",
    "    \n",
    "    def __init__(self,config_file, instrument, period, window, units):\n",
    "        super().__init__(config_file)\n",
    "        self.instrument = instrument\n",
    "        self.period=period\n",
    "        self.tickData = pd.DataFrame()\n",
    "        self.rawData = None \n",
    "        self.ultimoPeriodo = None \n",
    "        self.data = None\n",
    "        self.units = units\n",
    "        self.posizione = 0\n",
    "        self.profits = [] # lista dei profitti\n",
    "        \n",
    "        ########################## STRATEGY SPECIFIC ATTRIBUTES ##############################\n",
    "        self.window = window\n",
    "        \n",
    "    def getMostRecent(self, days=5): \n",
    "        '''questo metodo scarica i dati FINO ad adesso'''\n",
    "        while True:\n",
    "            now = datetime.now(timezone.utc)\n",
    "            now = now - timedelta(microseconds = now.microsecond) # pay attention, microseconds and then microsecond (singular!!!)\n",
    "            yesterday = now - timedelta(days= days) # lo chiamo YESTERDAY, ma è l'inizio del periodo da scaricare\n",
    "            df = self.get_history(instrument = self.instrument, start = str(yesterday)[:-6], end = str(now)[:-6],\n",
    "                        granularity= \"S5\", price=\"M\", localize=False)[\"c\"].to_frame() \n",
    "                        # scarico a 5secondi, il che vuol dire che period non può essere più corto!\n",
    "            df.rename(columns={\"c\":self.instrument},inplace=True)\n",
    "            self.rawData = df.resample(self.period, label=\"right\").last().dropna().iloc[:-1]\n",
    "            self.ultimoPeriodo = self.rawData.index[-1]\n",
    "            if pd.to_datetime(datetime.now(timezone.utc)) - self.ultimoPeriodo < pd.to_timedelta(self.period):\n",
    "                break\n",
    "            else:\n",
    "                time.sleep(2)\n",
    "    \n",
    "    def on_success(self, time, bid, ask):\n",
    "        print(self.ticks, end=\" \")\n",
    "        tickCorrente = pd.to_datetime(time)\n",
    "        df = pd.DataFrame({self.instrument:(ask+bid)/2}, index=[tickCorrente])\n",
    "        self.tickData=pd.concat((self.tickData,df),axis=0)\n",
    "        if tickCorrente - self.ultimoPeriodo > pd.to_timedelta(self.period):\n",
    "            self.resampleJoin()\n",
    "            self.defineStrategy()\n",
    "            self.executeTrade()\n",
    "    \n",
    "    def resampleJoin(self):\n",
    "        self.rawData=pd.concat((self.rawData,self.tickData.resample(self.period,label=\"right\").last().ffill().iloc[:-1] ),axis=0)\n",
    "        self.tickData = self.tickData.iloc[-1:] \n",
    "        self.ultimoPeriodo = self.rawData.index[-1] \n",
    "        \n",
    "    def defineStrategy(self):\n",
    "        df = self.rawData.copy()\n",
    "        df[\"logRet\"]=np.log(df[self.instrument] / df[self.instrument].shift(1))\n",
    "        df[\"posizione\"]= - np.sign(df.logRet.rolling(self.window).mean())\n",
    "        self.data = df.copy()\n",
    "        \n",
    "    def executeTrade(self):\n",
    "        if self.data.posizione.iloc[-1] == 1: # andiamo lunghi\n",
    "            if self.posizione == 0:\n",
    "                order = self.create_order(instrument = self.instrument, units = self.units, suppress=True, ret = True)\n",
    "                self.report_trade(order,\"VADO LUNGO\") #NEW!\n",
    "            elif self.posizione == -1:\n",
    "                order = self.create_order(instrument = self.instrument, units = 2*self.units, suppress=True, ret = True)\n",
    "                self.report_trade(order,\"CHIUDO POSIZIONE CORTA E VADO LUNGO\") #NEW!\n",
    "            self.posizione=1\n",
    "        elif self.data.posizione.iloc[-1] == -1: # andiamo corti\n",
    "            if self.posizione == 0:\n",
    "                order = self.create_order(instrument = self.instrument, units = -self.units, suppress=True, ret = True)\n",
    "                self.report_trade(order,\"VADO CORTO\") #NEW!\n",
    "            elif self.posizione == 1:\n",
    "                order = self.create_order(instrument = self.instrument, units = -2*self.units, suppress=True, ret = True)\n",
    "                self.report_trade(order,\"CHIUDO POSIZIONE LUNGA E VADO CORTO\") #NEW!\n",
    "            self.posizione=-1\n",
    "        elif self.data.posizione.iloc[-1] == 0: # andiamo neutri\n",
    "            if self.posizione == 1:\n",
    "                order = self.create_order(instrument = self.instrument, units = -self.units, suppress=True, ret = True)\n",
    "                self.report_trade(order,\"CHIUDO POSIZIONE LUNGA\") #NEW!\n",
    "            elif self.posizione == -1:\n",
    "                order = self.create_order(instrument = self.instrument, units = self.units, suppress=True, ret = True)\n",
    "                self.report_trade(order,\"CHIUDO POSIZIONE CORTA\") #NEW!\n",
    "            self.posizione=0\n",
    "\n",
    "    def report_trade(self,order,message):\n",
    "        time=order[\"time\"]\n",
    "        units=order[\"units\"]\n",
    "        price=order[\"price\"]\n",
    "        pl=float(order[\"pl\"]) # profit/loss\n",
    "        self.profits.append(pl)\n",
    "        cumpl=sum(self.profits)\n",
    "        print(\"\\n-------------------------------------------------\")\n",
    "        print(time,\"|\",message)\n",
    "        print(\"quantita=\",units,\"| prezzo=\",price,\"| profit/loss=\",pl,\"| profitto totale=\",cumpl)\n",
    "        print(\"-------------------------------------------------\")\n",
    "        \n",
    "    # NEW!\n",
    "    def stream_data(self,instrument=None, stop=None, ret=False, callback=None): # aggiungo un nuovo default per instrument!\n",
    "        if instrument is None:\n",
    "            instrument=self.instrument\n",
    "        super().stream_data(instrument, stop, ret, callback)\n",
    "        if self.posizione != 0:\n",
    "            close_all=self.create_order(self.instrument, units=-self.posizione*self.units,suppress=True,ret=True)\n",
    "            self.report_trade(close_all,\"CHIUDO TUTTO\")\n",
    "            self.posizione=0\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "2c5bc25b",
   "metadata": {},
   "outputs": [],
   "source": [
    "trader = Trader(\"oandaMY.cfg\",\"EUR_USD\",\"1min\", window=1, units=100000)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "a7c8db0b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2024-11-18 08:49:54.435897+00:00\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\ProgramData\\anaconda3\\Lib\\site-packages\\tpqoa\\tpqoa.py:223: FutureWarning: 'H' is deprecated and will be removed in a future version, please use 'h' instead.\n",
      "  dr = pd.date_range(start, end, freq=freq)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1 2 3 \n",
      "-------------------------------------------------\n",
      "2024-11-18T08:50:00.959508938Z | VADO LUNGO\n",
      "quantita= 100000.0 | prezzo= 1.05474 | profit/loss= 0.0 | profitto totale= 0.0\n",
      "-------------------------------------------------\n",
      "4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 \n",
      "-------------------------------------------------\n",
      "2024-11-18T08:52:06.010393486Z | CHIUDO TUTTO\n",
      "quantita= -100000.0 | prezzo= 1.05437 | profit/loss= -35.2662 | profitto totale= -35.2662\n",
      "-------------------------------------------------\n"
     ]
    }
   ],
   "source": [
    "print(datetime.now(timezone.utc))\n",
    "trader.getMostRecent()\n",
    "trader.stream_data(stop=150)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d998e508",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0a388871-840f-4f05-ad09-b3b3c436852c",
   "metadata": {},
   "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.12.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
