gridbot2024.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.1, price=157.7065, stoplimit=0.0, sl=158.1065, tp=157.3065, deviation=10, type=5, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.1, price=157.6065, stoplimit=0.0, sl=158.00650000000002, tp=157.2065, deviation=10, type=5, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.1, price=157.5065, stoplimit=0.0, sl=157.9065, tp=157.10649999999998, deviation=10, type=5, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.1, price=157.10649999999998, stoplimit=0.0, sl=156.70649999999998, tp=157.5065, deviation=10, type=2, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.1, price=157.9065, stoplimit=0.0, sl=157.5065, tp=158.3065, deviation=10, type=4, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.1, price=158.0065, stoplimit=0.0, sl=157.60649999999998, tp=158.4065, deviation=10, type=4, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.1, price=158.1065, stoplimit=0.0, sl=157.7065, tp=158.50650000000002, deviation=10, type=4, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.1, price=158.50650000000002, stoplimit=0.0, sl=158.90650000000002, tp=158.1065, deviation=10, type=3, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## Stable Release, Version 1.0 Grid HFT System, DEVELOPED BY FEJIRO E. JUN 2024 ##\n",
    "\n",
    "import MetaTrader5 as mt5\n",
    "import time\n",
    "\n",
    "# Symbol to trade\n",
    "symbol = \"USDJPYm\"\n",
    "\n",
    "# Connect to MetaTrader 5\n",
    "if not mt5.initialize():\n",
    "    print(\"Failed to initialize, error code =\", mt5.last_error())\n",
    "    quit()\n",
    "\n",
    "# Get the current price\n",
    "def get_current_price(symbol):\n",
    "    ticker = mt5.symbol_info_tick(symbol)\n",
    "    if ticker is None:\n",
    "        raise Exception(f\"Failed to get ticker for {symbol}\")\n",
    "    return ticker.bid, ticker.ask\n",
    "\n",
    "# Place an order\n",
    "def place_order(symbol, order_type, volume, price, sl, tp):\n",
    "    request = {\n",
    "        \"action\": mt5.TRADE_ACTION_PENDING,\n",
    "        \"symbol\": symbol,\n",
    "        \"volume\": volume,\n",
    "        \"type\": order_type,\n",
    "        \"price\": price,\n",
    "        \"sl\": sl,\n",
    "        \"tp\": tp,\n",
    "        \"deviation\": 10,\n",
    "        \"magic\": 234000,\n",
    "        \"comment\": \"Grid strategy\",\n",
    "        \"type_time\": mt5.ORDER_TIME_GTC,\n",
    "        \"type_filling\": mt5.ORDER_FILLING_RETURN,\n",
    "    }\n",
    "    \n",
    "    result = mt5.order_send(request)\n",
    "    if result.retcode != mt5.TRADE_RETCODE_DONE:\n",
    "        print(\"Failed to send order:\", result)\n",
    "        return None\n",
    "    return result\n",
    "\n",
    "# Grid strategy\n",
    "def grid_strategy(symbol):\n",
    "    volume = 0.1  # Define your volume\n",
    "    pips = 0.1  # 10 pips for JPY pairs, adjust as necessary\n",
    "    sl_tp_multiplier = 4  # Multiplier for SL and TP levels\n",
    "\n",
    "    bid, ask = get_current_price(symbol)\n",
    "    current_price = (bid + ask) / 2\n",
    "\n",
    "    # Define sell stops\n",
    "    last_sell_tp = None\n",
    "    for i in range(1, 4):\n",
    "        price = current_price - i * pips\n",
    "        sl = price + sl_tp_multiplier * pips\n",
    "        tp = price - sl_tp_multiplier * pips\n",
    "        last_sell_tp = tp  # Save the TP level of the last sell stop\n",
    "        place_order(symbol, mt5.ORDER_TYPE_SELL_STOP, volume, price, sl, tp)\n",
    "\n",
    "    # Place buy limit at the position of the last sell stop's TP level\n",
    "    buy_limit_price = last_sell_tp\n",
    "    buy_limit_sl = buy_limit_price - sl_tp_multiplier * pips\n",
    "    buy_limit_tp = buy_limit_price + sl_tp_multiplier * pips\n",
    "    place_order(symbol, mt5.ORDER_TYPE_BUY_LIMIT, volume, buy_limit_price, buy_limit_sl, buy_limit_tp)\n",
    "\n",
    "    # Define buy stops\n",
    "    last_buy_tp = None\n",
    "    for i in range(1, 4):\n",
    "        price = current_price + i * pips\n",
    "        sl = price - sl_tp_multiplier * pips\n",
    "        tp = price + sl_tp_multiplier * pips\n",
    "        last_buy_tp = tp  # Save the TP level of the last buy stop\n",
    "        place_order(symbol, mt5.ORDER_TYPE_BUY_STOP, volume, price, sl, tp)\n",
    "\n",
    "    # Place sell limit at the position of the last buy stop's TP level\n",
    "    sell_limit_price = last_buy_tp\n",
    "    sell_limit_sl = sell_limit_price + sl_tp_multiplier * pips\n",
    "    sell_limit_tp = sell_limit_price - sl_tp_multiplier * pips\n",
    "    place_order(symbol, mt5.ORDER_TYPE_SELL_LIMIT, volume, sell_limit_price, sell_limit_sl, sell_limit_tp)\n",
    "\n",
    "# Run the grid strategy\n",
    "grid_strategy(symbol)\n",
    "\n",
    "# Disconnect from MetaTrader 5\n",
    "mt5.shutdown()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.1, price=157.7055, stoplimit=0.0, sl=157.9055, tp=157.3055, deviation=10, type=5, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.1, price=157.6055, stoplimit=0.0, sl=157.8055, tp=157.2055, deviation=10, type=5, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.1, price=157.50549999999998, stoplimit=0.0, sl=157.70549999999997, tp=157.10549999999998, deviation=10, type=5, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.1, price=157.10549999999998, stoplimit=0.0, sl=156.9055, tp=157.50549999999998, deviation=10, type=2, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.1, price=157.9055, stoplimit=0.0, sl=157.7055, tp=158.3055, deviation=10, type=4, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.1, price=158.00549999999998, stoplimit=0.0, sl=157.8055, tp=158.4055, deviation=10, type=4, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.1, price=158.1055, stoplimit=0.0, sl=157.90550000000002, tp=158.5055, deviation=10, type=4, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.1, price=158.5055, stoplimit=0.0, sl=158.7055, tp=158.1055, deviation=10, type=3, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n"
     ]
    }
   ],
   "source": [
    "## Stable Release, Version 2.0 Grid HFT System, DEVELOPED BY FEJIRO E. JUN 2024 ##\n",
    "## Update: added tighter stoploss and timechecker if all trades are closed after 5 mins, create new grid##\n",
    "\n",
    "import MetaTrader5 as mt5\n",
    "import time\n",
    "\n",
    "# Symbol to trade\n",
    "symbol = \"USDJPYm\"\n",
    "\n",
    "# Connect to MetaTrader 5\n",
    "if not mt5.initialize():\n",
    "    print(\"Failed to initialize, error code =\", mt5.last_error())\n",
    "    quit()\n",
    "\n",
    "# Get the current price\n",
    "def get_current_price(symbol):\n",
    "    ticker = mt5.symbol_info_tick(symbol)\n",
    "    if ticker is None:\n",
    "        raise Exception(f\"Failed to get ticker for {symbol}\")\n",
    "    return ticker.bid, ticker.ask\n",
    "\n",
    "# Place an order\n",
    "def place_order(symbol, order_type, volume, price, sl, tp):\n",
    "    request = {\n",
    "        \"action\": mt5.TRADE_ACTION_PENDING,\n",
    "        \"symbol\": symbol,\n",
    "        \"volume\": volume,\n",
    "        \"type\": order_type,\n",
    "        \"price\": price,\n",
    "        \"sl\": sl,\n",
    "        \"tp\": tp,\n",
    "        \"deviation\": 10,\n",
    "        \"magic\": 234000,\n",
    "        \"comment\": \"Grid strategy\",\n",
    "        \"type_time\": mt5.ORDER_TIME_GTC,\n",
    "        \"type_filling\": mt5.ORDER_FILLING_RETURN,\n",
    "    }\n",
    "    \n",
    "    result = mt5.order_send(request)\n",
    "    if result.retcode != mt5.TRADE_RETCODE_DONE:\n",
    "        print(\"Failed to send order:\", result)\n",
    "        return None\n",
    "    return result\n",
    "\n",
    "# Grid strategy\n",
    "def grid_strategy(symbol):\n",
    "    volume = 0.1  # Define your volume\n",
    "    pips = 0.1  # 10 pips for JPY pairs, adjust as necessary\n",
    "\n",
    "    bid, ask = get_current_price(symbol)\n",
    "    current_price = (bid + ask) / 2\n",
    "\n",
    "    # Define sell stops\n",
    "    last_sell_tp = None\n",
    "    for i in range(1, 4):\n",
    "        price = current_price - i * pips\n",
    "        tp = price - 4 * pips  # Take profit 4 levels away\n",
    "        sl = price + 2 * pips  # Stop loss half of take profit\n",
    "        last_sell_tp = tp  # Save the TP level of the last sell stop\n",
    "        place_order(symbol, mt5.ORDER_TYPE_SELL_STOP, volume, price, sl, tp)\n",
    "\n",
    "    # Place buy limit at the position of the last sell stop's TP level\n",
    "    buy_limit_price = last_sell_tp\n",
    "    buy_limit_tp = buy_limit_price + 4 * pips\n",
    "    buy_limit_sl = buy_limit_price - 2 * pips\n",
    "    place_order(symbol, mt5.ORDER_TYPE_BUY_LIMIT, volume, buy_limit_price, buy_limit_sl, buy_limit_tp)\n",
    "\n",
    "    # Define buy stops\n",
    "    last_buy_tp = None\n",
    "    for i in range(1, 4):\n",
    "        price = current_price + i * pips\n",
    "        tp = price + 4 * pips  # Take profit 4 levels away\n",
    "        sl = price - 2 * pips  # Stop loss half of take profit\n",
    "        last_buy_tp = tp  # Save the TP level of the last buy stop\n",
    "        place_order(symbol, mt5.ORDER_TYPE_BUY_STOP, volume, price, sl, tp)\n",
    "\n",
    "    # Place sell limit at the position of the last buy stop's TP level\n",
    "    sell_limit_price = last_buy_tp\n",
    "    sell_limit_tp = sell_limit_price - 4 * pips\n",
    "    sell_limit_sl = sell_limit_price + 2 * pips\n",
    "    place_order(symbol, mt5.ORDER_TYPE_SELL_LIMIT, volume, sell_limit_price, sell_limit_sl, sell_limit_tp)\n",
    "\n",
    "# Check if all pending orders have been executed\n",
    "def all_orders_executed():\n",
    "    orders = mt5.orders_get(symbol=symbol)\n",
    "    return orders is None or len(orders) == 0\n",
    "\n",
    "# Main loop\n",
    "while True:\n",
    "    # Run the grid strategy\n",
    "    grid_strategy(symbol)\n",
    "    \n",
    "    # Wait for 5 minutes and check if all orders have been executed\n",
    "    time.sleep(300)\n",
    "    \n",
    "    # If all orders are executed, create a new grid\n",
    "    if all_orders_executed():\n",
    "        print(\"All orders executed. Creating a new grid.\")\n",
    "        grid_strategy(symbol)\n",
    "    else:\n",
    "        print(\"Orders still pending. Checking again in 5 minutes.\")\n",
    "\n",
    "# Disconnect from MetaTrader 5\n",
    "mt5.shutdown()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.05, price=160.393, stoplimit=0.0, sl=160.493, tp=160.194, deviation=10, type=5, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Logging trade: 5, 0.05, 160.393, 160.493, 160.194, 10027\n",
      "New trade DataFrame:\n",
      "                   timestamp  order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.403066           5    0.05  160.393  160.493  160.194   \n",
      "\n",
      "   result  \n",
      "0   10027  \n",
      "Updated trade_log_df:\n",
      "                   timestamp order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.403066          5    0.05  160.393  160.493  160.194   \n",
      "\n",
      "  result  \n",
      "0  10027  \n",
      "Invalid price for sell stop at 160.3935. Retrying with adjusted price.\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.05, price=160.393, stoplimit=0.0, sl=160.493, tp=160.194, deviation=10, type=5, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Logging trade: 5, 0.05, 160.393, 160.493, 160.194, 10027\n",
      "New trade DataFrame:\n",
      "                   timestamp  order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.443170           5    0.05  160.393  160.493  160.194   \n",
      "\n",
      "   result  \n",
      "0   10027  \n",
      "Updated trade_log_df:\n",
      "                   timestamp order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.403066          5    0.05  160.393  160.493  160.194   \n",
      "1 2024-06-28 11:11:37.443170          5    0.05  160.393  160.493  160.194   \n",
      "\n",
      "  result  \n",
      "0  10027  \n",
      "1  10027  \n",
      "Failed to place adjusted sell stop order at 160.393\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.05, price=160.344, stoplimit=0.0, sl=160.444, tp=160.144, deviation=10, type=5, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Logging trade: 5, 0.05, 160.344, 160.444, 160.144, 10027\n",
      "New trade DataFrame:\n",
      "                   timestamp  order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.456325           5    0.05  160.344  160.444  160.144   \n",
      "\n",
      "   result  \n",
      "0   10027  \n",
      "Updated trade_log_df:\n",
      "                   timestamp order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.403066          5    0.05  160.393  160.493  160.194   \n",
      "1 2024-06-28 11:11:37.443170          5    0.05  160.393  160.493  160.194   \n",
      "2 2024-06-28 11:11:37.456325          5    0.05  160.344  160.444  160.144   \n",
      "\n",
      "  result  \n",
      "0  10027  \n",
      "1  10027  \n",
      "2  10027  \n",
      "Invalid price for sell stop at 160.3435. Retrying with adjusted price.\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.05, price=160.343, stoplimit=0.0, sl=160.444, tp=160.144, deviation=10, type=5, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Logging trade: 5, 0.05, 160.343, 160.444, 160.144, 10027\n",
      "New trade DataFrame:\n",
      "                   timestamp  order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.465292           5    0.05  160.343  160.444  160.144   \n",
      "\n",
      "   result  \n",
      "0   10027  \n",
      "Updated trade_log_df:\n",
      "                   timestamp order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.403066          5    0.05  160.393  160.493  160.194   \n",
      "1 2024-06-28 11:11:37.443170          5    0.05  160.393  160.493  160.194   \n",
      "2 2024-06-28 11:11:37.456325          5    0.05  160.344  160.444  160.144   \n",
      "3 2024-06-28 11:11:37.465292          5    0.05  160.343  160.444  160.144   \n",
      "\n",
      "  result  \n",
      "0  10027  \n",
      "1  10027  \n",
      "2  10027  \n",
      "3  10027  \n",
      "Failed to place adjusted sell stop order at 160.343\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.05, price=160.293, stoplimit=0.0, sl=160.393, tp=160.094, deviation=10, type=5, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Logging trade: 5, 0.05, 160.293, 160.393, 160.094, 10027\n",
      "New trade DataFrame:\n",
      "                   timestamp  order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.476005           5    0.05  160.293  160.393  160.094   \n",
      "\n",
      "   result  \n",
      "0   10027  \n",
      "Updated trade_log_df:\n",
      "                   timestamp order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.403066          5    0.05  160.393  160.493  160.194   \n",
      "1 2024-06-28 11:11:37.443170          5    0.05  160.393  160.493  160.194   \n",
      "2 2024-06-28 11:11:37.456325          5    0.05  160.344  160.444  160.144   \n",
      "3 2024-06-28 11:11:37.465292          5    0.05  160.343  160.444  160.144   \n",
      "4 2024-06-28 11:11:37.476005          5    0.05  160.293  160.393  160.094   \n",
      "\n",
      "  result  \n",
      "0  10027  \n",
      "1  10027  \n",
      "2  10027  \n",
      "3  10027  \n",
      "4  10027  \n",
      "Invalid price for sell stop at 160.2935. Retrying with adjusted price.\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.05, price=160.292, stoplimit=0.0, sl=160.393, tp=160.094, deviation=10, type=5, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Logging trade: 5, 0.05, 160.292, 160.393, 160.094, 10027\n",
      "New trade DataFrame:\n",
      "                   timestamp  order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.488013           5    0.05  160.292  160.393  160.094   \n",
      "\n",
      "   result  \n",
      "0   10027  \n",
      "Updated trade_log_df:\n",
      "                   timestamp order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.403066          5    0.05  160.393  160.493  160.194   \n",
      "1 2024-06-28 11:11:37.443170          5    0.05  160.393  160.493  160.194   \n",
      "2 2024-06-28 11:11:37.456325          5    0.05  160.344  160.444  160.144   \n",
      "3 2024-06-28 11:11:37.465292          5    0.05  160.343  160.444  160.144   \n",
      "4 2024-06-28 11:11:37.476005          5    0.05  160.293  160.393  160.094   \n",
      "5 2024-06-28 11:11:37.488013          5    0.05  160.292  160.393  160.094   \n",
      "\n",
      "  result  \n",
      "0  10027  \n",
      "1  10027  \n",
      "2  10027  \n",
      "3  10027  \n",
      "4  10027  \n",
      "5  10027  \n",
      "Failed to place adjusted sell stop order at 160.292\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.05, price=160.094, stoplimit=0.0, sl=159.994, tp=160.293, deviation=10, type=2, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Logging trade: 2, 0.05, 160.094, 159.994, 160.293, 10027\n",
      "New trade DataFrame:\n",
      "                   timestamp  order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.509325           2    0.05  160.094  159.994  160.293   \n",
      "\n",
      "   result  \n",
      "0   10027  \n",
      "Updated trade_log_df:\n",
      "                   timestamp order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.403066          5    0.05  160.393  160.493  160.194   \n",
      "1 2024-06-28 11:11:37.443170          5    0.05  160.393  160.493  160.194   \n",
      "2 2024-06-28 11:11:37.456325          5    0.05  160.344  160.444  160.144   \n",
      "3 2024-06-28 11:11:37.465292          5    0.05  160.343  160.444  160.144   \n",
      "4 2024-06-28 11:11:37.476005          5    0.05  160.293  160.393  160.094   \n",
      "5 2024-06-28 11:11:37.488013          5    0.05  160.292  160.393  160.094   \n",
      "6 2024-06-28 11:11:37.509325          2    0.05  160.094  159.994  160.293   \n",
      "\n",
      "  result  \n",
      "0  10027  \n",
      "1  10027  \n",
      "2  10027  \n",
      "3  10027  \n",
      "4  10027  \n",
      "5  10027  \n",
      "6  10027  \n",
      "Invalid price for buy limit at 160.0935. Retrying with adjusted price.\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.05, price=161.694, stoplimit=0.0, sl=159.994, tp=160.293, deviation=10, type=2, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Logging trade: 2, 0.05, 161.694, 159.994, 160.293, 10027\n",
      "New trade DataFrame:\n",
      "                   timestamp  order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.515862           2    0.05  161.694  159.994  160.293   \n",
      "\n",
      "   result  \n",
      "0   10027  \n",
      "Updated trade_log_df:\n",
      "                   timestamp order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.403066          5    0.05  160.393  160.493  160.194   \n",
      "1 2024-06-28 11:11:37.443170          5    0.05  160.393  160.493  160.194   \n",
      "2 2024-06-28 11:11:37.456325          5    0.05  160.344  160.444  160.144   \n",
      "3 2024-06-28 11:11:37.465292          5    0.05  160.343  160.444  160.144   \n",
      "4 2024-06-28 11:11:37.476005          5    0.05  160.293  160.393  160.094   \n",
      "5 2024-06-28 11:11:37.488013          5    0.05  160.292  160.393  160.094   \n",
      "6 2024-06-28 11:11:37.509325          2    0.05  160.094  159.994  160.293   \n",
      "7 2024-06-28 11:11:37.515862          2    0.05  161.694  159.994  160.293   \n",
      "\n",
      "  result  \n",
      "0  10027  \n",
      "1  10027  \n",
      "2  10027  \n",
      "3  10027  \n",
      "4  10027  \n",
      "5  10027  \n",
      "6  10027  \n",
      "7  10027  \n",
      "Failed to place adjusted buy limit order at 161.694\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.05, price=160.494, stoplimit=0.0, sl=160.394, tp=160.694, deviation=10, type=4, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Logging trade: 4, 0.05, 160.494, 160.394, 160.694, 10027\n",
      "New trade DataFrame:\n",
      "                   timestamp  order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.533212           4    0.05  160.494  160.394  160.694   \n",
      "\n",
      "   result  \n",
      "0   10027  \n",
      "Updated trade_log_df:\n",
      "                   timestamp order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.403066          5    0.05  160.393  160.493  160.194   \n",
      "1 2024-06-28 11:11:37.443170          5    0.05  160.393  160.493  160.194   \n",
      "2 2024-06-28 11:11:37.456325          5    0.05  160.344  160.444  160.144   \n",
      "3 2024-06-28 11:11:37.465292          5    0.05  160.343  160.444  160.144   \n",
      "4 2024-06-28 11:11:37.476005          5    0.05  160.293  160.393  160.094   \n",
      "5 2024-06-28 11:11:37.488013          5    0.05  160.292  160.393  160.094   \n",
      "6 2024-06-28 11:11:37.509325          2    0.05  160.094  159.994  160.293   \n",
      "7 2024-06-28 11:11:37.515862          2    0.05  161.694  159.994  160.293   \n",
      "8 2024-06-28 11:11:37.533212          4    0.05  160.494  160.394  160.694   \n",
      "\n",
      "  result  \n",
      "0  10027  \n",
      "1  10027  \n",
      "2  10027  \n",
      "3  10027  \n",
      "4  10027  \n",
      "5  10027  \n",
      "6  10027  \n",
      "7  10027  \n",
      "8  10027  \n",
      "Invalid price for buy stop at 160.4935. Retrying with adjusted price.\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.05, price=160.494, stoplimit=0.0, sl=160.394, tp=160.694, deviation=10, type=4, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Logging trade: 4, 0.05, 160.494, 160.394, 160.694, 10027\n",
      "New trade DataFrame:\n",
      "                   timestamp  order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.545460           4    0.05  160.494  160.394  160.694   \n",
      "\n",
      "   result  \n",
      "0   10027  \n",
      "Updated trade_log_df:\n",
      "                   timestamp order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.403066          5    0.05  160.393  160.493  160.194   \n",
      "1 2024-06-28 11:11:37.443170          5    0.05  160.393  160.493  160.194   \n",
      "2 2024-06-28 11:11:37.456325          5    0.05  160.344  160.444  160.144   \n",
      "3 2024-06-28 11:11:37.465292          5    0.05  160.343  160.444  160.144   \n",
      "4 2024-06-28 11:11:37.476005          5    0.05  160.293  160.393  160.094   \n",
      "5 2024-06-28 11:11:37.488013          5    0.05  160.292  160.393  160.094   \n",
      "6 2024-06-28 11:11:37.509325          2    0.05  160.094  159.994  160.293   \n",
      "7 2024-06-28 11:11:37.515862          2    0.05  161.694  159.994  160.293   \n",
      "8 2024-06-28 11:11:37.533212          4    0.05  160.494  160.394  160.694   \n",
      "9 2024-06-28 11:11:37.545460          4    0.05  160.494  160.394  160.694   \n",
      "\n",
      "  result  \n",
      "0  10027  \n",
      "1  10027  \n",
      "2  10027  \n",
      "3  10027  \n",
      "4  10027  \n",
      "5  10027  \n",
      "6  10027  \n",
      "7  10027  \n",
      "8  10027  \n",
      "9  10027  \n",
      "Failed to place adjusted buy stop order at 160.494\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.05, price=160.543, stoplimit=0.0, sl=160.444, tp=160.743, deviation=10, type=4, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Logging trade: 4, 0.05, 160.543, 160.444, 160.743, 10027\n",
      "New trade DataFrame:\n",
      "                   timestamp  order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.556029           4    0.05  160.543  160.444  160.743   \n",
      "\n",
      "   result  \n",
      "0   10027  \n",
      "Updated trade_log_df:\n",
      "                    timestamp order_type  volume    price       sl       tp  \\\n",
      "0  2024-06-28 11:11:37.403066          5    0.05  160.393  160.493  160.194   \n",
      "1  2024-06-28 11:11:37.443170          5    0.05  160.393  160.493  160.194   \n",
      "2  2024-06-28 11:11:37.456325          5    0.05  160.344  160.444  160.144   \n",
      "3  2024-06-28 11:11:37.465292          5    0.05  160.343  160.444  160.144   \n",
      "4  2024-06-28 11:11:37.476005          5    0.05  160.293  160.393  160.094   \n",
      "5  2024-06-28 11:11:37.488013          5    0.05  160.292  160.393  160.094   \n",
      "6  2024-06-28 11:11:37.509325          2    0.05  160.094  159.994  160.293   \n",
      "7  2024-06-28 11:11:37.515862          2    0.05  161.694  159.994  160.293   \n",
      "8  2024-06-28 11:11:37.533212          4    0.05  160.494  160.394  160.694   \n",
      "9  2024-06-28 11:11:37.545460          4    0.05  160.494  160.394  160.694   \n",
      "10 2024-06-28 11:11:37.556029          4    0.05  160.543  160.444  160.743   \n",
      "\n",
      "   result  \n",
      "0   10027  \n",
      "1   10027  \n",
      "2   10027  \n",
      "3   10027  \n",
      "4   10027  \n",
      "5   10027  \n",
      "6   10027  \n",
      "7   10027  \n",
      "8   10027  \n",
      "9   10027  \n",
      "10  10027  \n",
      "Invalid price for buy stop at 160.5435. Retrying with adjusted price.\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.05, price=160.544, stoplimit=0.0, sl=160.444, tp=160.743, deviation=10, type=4, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Logging trade: 4, 0.05, 160.544, 160.444, 160.743, 10027\n",
      "New trade DataFrame:\n",
      "                   timestamp  order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.565843           4    0.05  160.544  160.444  160.743   \n",
      "\n",
      "   result  \n",
      "0   10027  \n",
      "Updated trade_log_df:\n",
      "                    timestamp order_type  volume    price       sl       tp  \\\n",
      "0  2024-06-28 11:11:37.403066          5    0.05  160.393  160.493  160.194   \n",
      "1  2024-06-28 11:11:37.443170          5    0.05  160.393  160.493  160.194   \n",
      "2  2024-06-28 11:11:37.456325          5    0.05  160.344  160.444  160.144   \n",
      "3  2024-06-28 11:11:37.465292          5    0.05  160.343  160.444  160.144   \n",
      "4  2024-06-28 11:11:37.476005          5    0.05  160.293  160.393  160.094   \n",
      "5  2024-06-28 11:11:37.488013          5    0.05  160.292  160.393  160.094   \n",
      "6  2024-06-28 11:11:37.509325          2    0.05  160.094  159.994  160.293   \n",
      "7  2024-06-28 11:11:37.515862          2    0.05  161.694  159.994  160.293   \n",
      "8  2024-06-28 11:11:37.533212          4    0.05  160.494  160.394  160.694   \n",
      "9  2024-06-28 11:11:37.545460          4    0.05  160.494  160.394  160.694   \n",
      "10 2024-06-28 11:11:37.556029          4    0.05  160.543  160.444  160.743   \n",
      "11 2024-06-28 11:11:37.565843          4    0.05  160.544  160.444  160.743   \n",
      "\n",
      "   result  \n",
      "0   10027  \n",
      "1   10027  \n",
      "2   10027  \n",
      "3   10027  \n",
      "4   10027  \n",
      "5   10027  \n",
      "6   10027  \n",
      "7   10027  \n",
      "8   10027  \n",
      "9   10027  \n",
      "10  10027  \n",
      "11  10027  \n",
      "Failed to place adjusted buy stop order at 160.544\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.05, price=160.594, stoplimit=0.0, sl=160.494, tp=160.793, deviation=10, type=4, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Logging trade: 4, 0.05, 160.594, 160.494, 160.793, 10027\n",
      "New trade DataFrame:\n",
      "                   timestamp  order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.575860           4    0.05  160.594  160.494  160.793   \n",
      "\n",
      "   result  \n",
      "0   10027  \n",
      "Updated trade_log_df:\n",
      "                    timestamp order_type  volume    price       sl       tp  \\\n",
      "0  2024-06-28 11:11:37.403066          5    0.05  160.393  160.493  160.194   \n",
      "1  2024-06-28 11:11:37.443170          5    0.05  160.393  160.493  160.194   \n",
      "2  2024-06-28 11:11:37.456325          5    0.05  160.344  160.444  160.144   \n",
      "3  2024-06-28 11:11:37.465292          5    0.05  160.343  160.444  160.144   \n",
      "4  2024-06-28 11:11:37.476005          5    0.05  160.293  160.393  160.094   \n",
      "5  2024-06-28 11:11:37.488013          5    0.05  160.292  160.393  160.094   \n",
      "6  2024-06-28 11:11:37.509325          2    0.05  160.094  159.994  160.293   \n",
      "7  2024-06-28 11:11:37.515862          2    0.05  161.694  159.994  160.293   \n",
      "8  2024-06-28 11:11:37.533212          4    0.05  160.494  160.394  160.694   \n",
      "9  2024-06-28 11:11:37.545460          4    0.05  160.494  160.394  160.694   \n",
      "10 2024-06-28 11:11:37.556029          4    0.05  160.543  160.444  160.743   \n",
      "11 2024-06-28 11:11:37.565843          4    0.05  160.544  160.444  160.743   \n",
      "12 2024-06-28 11:11:37.575860          4    0.05  160.594  160.494  160.793   \n",
      "\n",
      "   result  \n",
      "0   10027  \n",
      "1   10027  \n",
      "2   10027  \n",
      "3   10027  \n",
      "4   10027  \n",
      "5   10027  \n",
      "6   10027  \n",
      "7   10027  \n",
      "8   10027  \n",
      "9   10027  \n",
      "10  10027  \n",
      "11  10027  \n",
      "12  10027  \n",
      "Invalid price for buy stop at 160.5935. Retrying with adjusted price.\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.05, price=160.595, stoplimit=0.0, sl=160.494, tp=160.793, deviation=10, type=4, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Logging trade: 4, 0.05, 160.595, 160.494, 160.793, 10027\n",
      "New trade DataFrame:\n",
      "                   timestamp  order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.583677           4    0.05  160.595  160.494  160.793   \n",
      "\n",
      "   result  \n",
      "0   10027  \n",
      "Updated trade_log_df:\n",
      "                    timestamp order_type  volume    price       sl       tp  \\\n",
      "0  2024-06-28 11:11:37.403066          5    0.05  160.393  160.493  160.194   \n",
      "1  2024-06-28 11:11:37.443170          5    0.05  160.393  160.493  160.194   \n",
      "2  2024-06-28 11:11:37.456325          5    0.05  160.344  160.444  160.144   \n",
      "3  2024-06-28 11:11:37.465292          5    0.05  160.343  160.444  160.144   \n",
      "4  2024-06-28 11:11:37.476005          5    0.05  160.293  160.393  160.094   \n",
      "5  2024-06-28 11:11:37.488013          5    0.05  160.292  160.393  160.094   \n",
      "6  2024-06-28 11:11:37.509325          2    0.05  160.094  159.994  160.293   \n",
      "7  2024-06-28 11:11:37.515862          2    0.05  161.694  159.994  160.293   \n",
      "8  2024-06-28 11:11:37.533212          4    0.05  160.494  160.394  160.694   \n",
      "9  2024-06-28 11:11:37.545460          4    0.05  160.494  160.394  160.694   \n",
      "10 2024-06-28 11:11:37.556029          4    0.05  160.543  160.444  160.743   \n",
      "11 2024-06-28 11:11:37.565843          4    0.05  160.544  160.444  160.743   \n",
      "12 2024-06-28 11:11:37.575860          4    0.05  160.594  160.494  160.793   \n",
      "13 2024-06-28 11:11:37.583677          4    0.05  160.595  160.494  160.793   \n",
      "\n",
      "   result  \n",
      "0   10027  \n",
      "1   10027  \n",
      "2   10027  \n",
      "3   10027  \n",
      "4   10027  \n",
      "5   10027  \n",
      "6   10027  \n",
      "7   10027  \n",
      "8   10027  \n",
      "9   10027  \n",
      "10  10027  \n",
      "11  10027  \n",
      "12  10027  \n",
      "13  10027  \n",
      "Failed to place adjusted buy stop order at 160.595\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.05, price=160.793, stoplimit=0.0, sl=160.893, tp=160.594, deviation=10, type=3, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Logging trade: 3, 0.05, 160.793, 160.893, 160.594, 10027\n",
      "New trade DataFrame:\n",
      "                   timestamp  order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.587722           3    0.05  160.793  160.893  160.594   \n",
      "\n",
      "   result  \n",
      "0   10027  \n",
      "Updated trade_log_df:\n",
      "                    timestamp order_type  volume    price       sl       tp  \\\n",
      "0  2024-06-28 11:11:37.403066          5    0.05  160.393  160.493  160.194   \n",
      "1  2024-06-28 11:11:37.443170          5    0.05  160.393  160.493  160.194   \n",
      "2  2024-06-28 11:11:37.456325          5    0.05  160.344  160.444  160.144   \n",
      "3  2024-06-28 11:11:37.465292          5    0.05  160.343  160.444  160.144   \n",
      "4  2024-06-28 11:11:37.476005          5    0.05  160.293  160.393  160.094   \n",
      "5  2024-06-28 11:11:37.488013          5    0.05  160.292  160.393  160.094   \n",
      "6  2024-06-28 11:11:37.509325          2    0.05  160.094  159.994  160.293   \n",
      "7  2024-06-28 11:11:37.515862          2    0.05  161.694  159.994  160.293   \n",
      "8  2024-06-28 11:11:37.533212          4    0.05  160.494  160.394  160.694   \n",
      "9  2024-06-28 11:11:37.545460          4    0.05  160.494  160.394  160.694   \n",
      "10 2024-06-28 11:11:37.556029          4    0.05  160.543  160.444  160.743   \n",
      "11 2024-06-28 11:11:37.565843          4    0.05  160.544  160.444  160.743   \n",
      "12 2024-06-28 11:11:37.575860          4    0.05  160.594  160.494  160.793   \n",
      "13 2024-06-28 11:11:37.583677          4    0.05  160.595  160.494  160.793   \n",
      "14 2024-06-28 11:11:37.587722          3    0.05  160.793  160.893  160.594   \n",
      "\n",
      "   result  \n",
      "0   10027  \n",
      "1   10027  \n",
      "2   10027  \n",
      "3   10027  \n",
      "4   10027  \n",
      "5   10027  \n",
      "6   10027  \n",
      "7   10027  \n",
      "8   10027  \n",
      "9   10027  \n",
      "10  10027  \n",
      "11  10027  \n",
      "12  10027  \n",
      "13  10027  \n",
      "14  10027  \n",
      "Invalid price for sell limit at 160.7935. Retrying with adjusted price.\n",
      "Failed to send order: OrderSendResult(retcode=10027, deal=0, order=0, volume=0.0, price=0.0, bid=0.0, ask=0.0, comment='AutoTrading disabled by client', request_id=0, retcode_external=0, request=TradeRequest(action=5, magic=234000, order=0, symbol='USDJPYm', volume=0.05, price=162.401, stoplimit=0.0, sl=160.893, tp=160.594, deviation=10, type=3, type_filling=2, type_time=0, expiration=0, comment='Grid strategy', position=0, position_by=0))\n",
      "Logging trade: 3, 0.05, 162.401, 160.893, 160.594, 10027\n",
      "New trade DataFrame:\n",
      "                   timestamp  order_type  volume    price       sl       tp  \\\n",
      "0 2024-06-28 11:11:37.596243           3    0.05  162.401  160.893  160.594   \n",
      "\n",
      "   result  \n",
      "0   10027  \n",
      "Updated trade_log_df:\n",
      "                    timestamp order_type  volume    price       sl       tp  \\\n",
      "0  2024-06-28 11:11:37.403066          5    0.05  160.393  160.493  160.194   \n",
      "1  2024-06-28 11:11:37.443170          5    0.05  160.393  160.493  160.194   \n",
      "2  2024-06-28 11:11:37.456325          5    0.05  160.344  160.444  160.144   \n",
      "3  2024-06-28 11:11:37.465292          5    0.05  160.343  160.444  160.144   \n",
      "4  2024-06-28 11:11:37.476005          5    0.05  160.293  160.393  160.094   \n",
      "5  2024-06-28 11:11:37.488013          5    0.05  160.292  160.393  160.094   \n",
      "6  2024-06-28 11:11:37.509325          2    0.05  160.094  159.994  160.293   \n",
      "7  2024-06-28 11:11:37.515862          2    0.05  161.694  159.994  160.293   \n",
      "8  2024-06-28 11:11:37.533212          4    0.05  160.494  160.394  160.694   \n",
      "9  2024-06-28 11:11:37.545460          4    0.05  160.494  160.394  160.694   \n",
      "10 2024-06-28 11:11:37.556029          4    0.05  160.543  160.444  160.743   \n",
      "11 2024-06-28 11:11:37.565843          4    0.05  160.544  160.444  160.743   \n",
      "12 2024-06-28 11:11:37.575860          4    0.05  160.594  160.494  160.793   \n",
      "13 2024-06-28 11:11:37.583677          4    0.05  160.595  160.494  160.793   \n",
      "14 2024-06-28 11:11:37.587722          3    0.05  160.793  160.893  160.594   \n",
      "15 2024-06-28 11:11:37.596243          3    0.05  162.401  160.893  160.594   \n",
      "\n",
      "   result  \n",
      "0   10027  \n",
      "1   10027  \n",
      "2   10027  \n",
      "3   10027  \n",
      "4   10027  \n",
      "5   10027  \n",
      "6   10027  \n",
      "7   10027  \n",
      "8   10027  \n",
      "9   10027  \n",
      "10  10027  \n",
      "11  10027  \n",
      "12  10027  \n",
      "13  10027  \n",
      "14  10027  \n",
      "15  10027  \n",
      "Failed to place adjusted sell limit order at 162.401\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Owner\\AppData\\Local\\Temp\\ipykernel_17308\\738732804.py:43: FutureWarning: The behavior of DataFrame concatenation with empty or all-NA entries is deprecated. In a future version, this will no longer exclude empty or all-NA columns when determining the result dtypes. To retain the old behavior, exclude the relevant entries before the concat operation.\n",
      "  trade_log_df = pd.concat([trade_log_df, new_trade], ignore_index=True)\n"
     ]
    }
   ],
   "source": [
    "import MetaTrader5 as mt5\n",
    "import time\n",
    "import pandas as pd\n",
    "import os\n",
    "\n",
    "# Symbol to trade\n",
    "symbol = \"USDJPYm\"\n",
    "\n",
    "# Initialize the DataFrame for logging\n",
    "columns = ['timestamp', 'order_type', 'volume', 'price', 'sl', 'tp', 'result']\n",
    "trade_log_df = pd.DataFrame(columns=columns)\n",
    "\n",
    "# Connect to MetaTrader 5\n",
    "if not mt5.initialize():\n",
    "    print(\"Failed to initialize, error code =\", mt5.last_error())\n",
    "    quit()\n",
    "\n",
    "# Get the current price\n",
    "def get_current_price(symbol):\n",
    "    ticker = mt5.symbol_info_tick(symbol)\n",
    "    if ticker is None:\n",
    "        raise Exception(f\"Failed to get ticker for {symbol}\")\n",
    "    return ticker.bid, ticker.ask\n",
    "\n",
    "# Function to log buy/sell order details\n",
    "def log_trade(order_type, volume, price, sl, tp, result):\n",
    "    global trade_log_df\n",
    "    print(f\"Logging trade: {order_type}, {volume}, {price}, {sl}, {tp}, {result.retcode if result else 'failed'}\")\n",
    "    \n",
    "    new_trade = pd.DataFrame([{\n",
    "        'timestamp': pd.Timestamp.now(),\n",
    "        'order_type': order_type,\n",
    "        'volume': volume,\n",
    "        'price': price,\n",
    "        'sl': sl,\n",
    "        'tp': tp,\n",
    "        'result': result.retcode if result else 'failed'\n",
    "    }])\n",
    "    \n",
    "    print(f\"New trade DataFrame:\\n{new_trade}\")\n",
    "    \n",
    "    if not new_trade.isna().all().all():\n",
    "        trade_log_df = pd.concat([trade_log_df, new_trade], ignore_index=True)\n",
    "        print(f\"Updated trade_log_df:\\n{trade_log_df}\")\n",
    "\n",
    "# Function to save DataFrame into CSV file locally\n",
    "def save_log_to_csv():\n",
    "    desktop = os.path.join(os.path.join(os.environ['USERPROFILE']), 'Desktop')\n",
    "    filepath = os.path.join(desktop, 'gridbotlog.csv')\n",
    "    trade_log_df.to_csv(filepath, index=False)\n",
    "\n",
    "# Place an order with correct price precision\n",
    "def place_order(symbol, order_type, volume, price, sl, tp):\n",
    "    # Ensure the price has the correct precision\n",
    "    price = round(price, 3)  # For JPY pairs, using 3 decimal places\n",
    "    sl = round(sl, 3)\n",
    "    tp = round(tp, 3)\n",
    "\n",
    "    request = {\n",
    "        \"action\": mt5.TRADE_ACTION_PENDING,\n",
    "        \"symbol\": symbol,\n",
    "        \"volume\": volume,\n",
    "        \"type\": order_type,\n",
    "        \"price\": price,\n",
    "        \"sl\": sl,\n",
    "        \"tp\": tp,\n",
    "        \"deviation\": 10,\n",
    "        \"magic\": 234000,\n",
    "        \"comment\": \"Grid strategy\",\n",
    "        \"type_time\": mt5.ORDER_TIME_GTC,\n",
    "        \"type_filling\": mt5.ORDER_FILLING_RETURN,\n",
    "    }\n",
    "    \n",
    "    result = mt5.order_send(request)\n",
    "    \n",
    "    if result.retcode != mt5.TRADE_RETCODE_DONE:\n",
    "        print(f\"Failed to send order: {result}\")\n",
    "        log_trade(order_type, volume, price, sl, tp, result)\n",
    "        return None\n",
    "    else:\n",
    "        print(f\"Order sent successfully: {result}\")\n",
    "        log_trade(order_type, volume, price, sl, tp, result)\n",
    "    \n",
    "    return result\n",
    "\n",
    "# Update trailing stop loss for open positions\n",
    "def update_trailing_stop(symbol, trailing_stop_distance):\n",
    "    positions = mt5.positions_get(symbol=symbol)\n",
    "    if positions is None:\n",
    "        print(f\"No positions found for {symbol}, error code:\", mt5.last_error())\n",
    "        return\n",
    "    \n",
    "    for position in positions:\n",
    "        if position.type == mt5.ORDER_TYPE_BUY:\n",
    "            new_sl = mt5.symbol_info_tick(symbol).bid - trailing_stop_distance\n",
    "            if new_sl > position.sl:\n",
    "                modify_order(position.ticket, new_sl, position.tp)\n",
    "        elif position.type == mt5.ORDER_TYPE_SELL:\n",
    "            new_sl = mt5.symbol_info_tick(symbol).ask + trailing_stop_distance\n",
    "            if new_sl < position.sl:\n",
    "                modify_order(position.ticket, new_sl, position.tp)\n",
    "\n",
    "# Modify an existing order's stop loss and take profit\n",
    "def modify_order(position_ticket, new_sl, new_tp):\n",
    "    request = {\n",
    "        \"action\": mt5.TRADE_ACTION_SLTP,\n",
    "        \"position\": position_ticket,\n",
    "        \"sl\": new_sl,\n",
    "        \"tp\": new_tp,\n",
    "        \"deviation\": 10,\n",
    "    }\n",
    "    result = mt5.order_send(request)\n",
    "    if result.retcode != mt5.TRADE_RETCODE_DONE:\n",
    "        print(f\"Failed to modify order: {result}\")\n",
    "        return None\n",
    "    return result\n",
    "\n",
    "# Grid strategy\n",
    "def grid_strategy(symbol):\n",
    "    volume = 0.05  # Define your volume/lotsize, adjust as necessary\n",
    "    pips = 0.05  # pip distance, adjust as necessary\n",
    "\n",
    "    bid, ask = get_current_price(symbol)\n",
    "    current_price = (bid + ask) / 2\n",
    "\n",
    "    # Define sell stops\n",
    "    last_sell_tp = None\n",
    "    for i in range(1, 4):\n",
    "        price = current_price - i * pips\n",
    "        tp = price - 4 * pips  # Take profit 4 levels away\n",
    "        sl = price + 2 * pips  # Stop loss half of take profit\n",
    "        last_sell_tp = tp  # Save the TP level of the last sell stop\n",
    "        result = place_order(symbol, mt5.ORDER_TYPE_SELL_STOP, volume, price, sl, tp)\n",
    "        if result is None:\n",
    "            print(f\"Invalid price for sell stop at {price}. Retrying with adjusted price.\")\n",
    "            # Adjust the price slightly and retry\n",
    "            price = round(current_price - (i * pips * 1.01), 3)\n",
    "            result = place_order(symbol, mt5.ORDER_TYPE_SELL_STOP, volume, price, sl, tp)\n",
    "            if result is None:\n",
    "                print(f\"Failed to place adjusted sell stop order at {price}\")\n",
    "                continue\n",
    "\n",
    "    # Place buy limit at the position of the last sell stop's TP level\n",
    "    if last_sell_tp is not None:\n",
    "        buy_limit_price = last_sell_tp\n",
    "        buy_limit_tp = buy_limit_price + 4 * pips\n",
    "        buy_limit_sl = buy_limit_price - 2 * pips\n",
    "        result = place_order(symbol, mt5.ORDER_TYPE_BUY_LIMIT, volume, buy_limit_price, buy_limit_sl, buy_limit_tp)\n",
    "        if result is None:\n",
    "            print(f\"Invalid price for buy limit at {buy_limit_price}. Retrying with adjusted price.\")\n",
    "            # Adjust the price slightly and retry\n",
    "            buy_limit_price = round(last_sell_tp * 1.01, 3)\n",
    "            result = place_order(symbol, mt5.ORDER_TYPE_BUY_LIMIT, volume, buy_limit_price, buy_limit_sl, buy_limit_tp)\n",
    "            if result is None:\n",
    "                print(f\"Failed to place adjusted buy limit order at {buy_limit_price}\")\n",
    "\n",
    "    # Define buy stops\n",
    "    last_buy_tp = None\n",
    "    for i in range(1, 4):\n",
    "        price = current_price + i * pips\n",
    "        tp = price + 4 * pips  # Take profit 4 levels away\n",
    "        sl = price - 2 * pips  # Stop loss half of take profit\n",
    "        last_buy_tp = tp  # Save the TP level of the last buy stop\n",
    "        result = place_order(symbol, mt5.ORDER_TYPE_BUY_STOP, volume, price, sl, tp)\n",
    "        if result is None:\n",
    "            print(f\"Invalid price for buy stop at {price}. Retrying with adjusted price.\")\n",
    "            # Adjust the price slightly and retry\n",
    "            price = round(current_price + (i * pips * 1.01), 3)\n",
    "            result = place_order(symbol, mt5.ORDER_TYPE_BUY_STOP, volume, price, sl, tp)\n",
    "            if result is None:\n",
    "                print(f\"Failed to place adjusted buy stop order at {price}\")\n",
    "                continue\n",
    "\n",
    "    # Place sell limit at the position of the last buy stop's TP level\n",
    "    if last_buy_tp is not None:\n",
    "        sell_limit_price = last_buy_tp\n",
    "        sell_limit_tp = sell_limit_price - 4 * pips\n",
    "        sell_limit_sl = sell_limit_price + 2 * pips\n",
    "        result = place_order(symbol, mt5.ORDER_TYPE_SELL_LIMIT, volume, sell_limit_price, sell_limit_sl, sell_limit_tp)\n",
    "        if result is None:\n",
    "            print(f\"Invalid price for sell limit at {sell_limit_price}. Retrying with adjusted price.\")\n",
    "            # Adjust the price slightly and retry\n",
    "            sell_limit_price = round(last_buy_tp * 1.01, 3)\n",
    "            result = place_order(symbol, mt5.ORDER_TYPE_SELL_LIMIT, volume, sell_limit_price, sell_limit_sl, sell_limit_tp)\n",
    "            if result is None:\n",
    "                print(f\"Failed to place adjusted sell limit order at {sell_limit_price}\")\n",
    "\n",
    "# Check if all pending orders have been executed\n",
    "def all_orders_executed():\n",
    "    orders = mt5.orders_get(symbol=symbol)\n",
    "    return orders is None or len(orders) == 0\n",
    "\n",
    "# Main loop\n",
    "while True:\n",
    "    # Run the grid strategy\n",
    "    grid_strategy(symbol)\n",
    "    \n",
    "    # Wait for 1 hour and check if all orders have been executed before placing new ones\n",
    "    time.sleep(3600)\n",
    "    \n",
    "    # If there are still pending orders, wait until the next iteration\n",
    "    if not all_orders_executed():\n",
    "        continue\n",
    "\n",
    "    # Update trailing stop loss for open positions\n",
    "    trailing_stop_distance = 2 * 0.1  # Example trailing stop distance, adjust as needed\n",
    "    update_trailing_stop(symbol, trailing_stop_distance)\n",
    "\n",
    "    # Save to CSV file function call\n",
    "    save_log_to_csv()\n",
    "\n",
    "# Disconnect from MetaTrader 5\n",
    "mt5.shutdown()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}