trader3_analysis2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_trader = pd.read_excel(\"../pandas-trader/stock_trader.xlsx\", sheet_name='TRADES')\n",
    "df_prices = pd.read_excel(\"../pandas-trader/stock_trader.xlsx\", sheet_name='PRICES')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>broker</th>\n",
       "      <th>txn_date</th>\n",
       "      <th>exchange</th>\n",
       "      <th>scrip</th>\n",
       "      <th>order_type</th>\n",
       "      <th>quantity</th>\n",
       "      <th>price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5Paisa</td>\n",
       "      <td>2019-07-11</td>\n",
       "      <td>NSE</td>\n",
       "      <td>INDIGO</td>\n",
       "      <td>buy</td>\n",
       "      <td>10</td>\n",
       "      <td>1360.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5Paisa</td>\n",
       "      <td>2019-08-19</td>\n",
       "      <td>NSE</td>\n",
       "      <td>BAJAJ-AUTO</td>\n",
       "      <td>buy</td>\n",
       "      <td>7</td>\n",
       "      <td>2750.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5Paisa</td>\n",
       "      <td>2019-08-19</td>\n",
       "      <td>NSE</td>\n",
       "      <td>RELIANCE</td>\n",
       "      <td>buy</td>\n",
       "      <td>10</td>\n",
       "      <td>1232.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5Paisa</td>\n",
       "      <td>2019-08-19</td>\n",
       "      <td>NSE</td>\n",
       "      <td>JIOFIN</td>\n",
       "      <td>buy-demerger</td>\n",
       "      <td>10</td>\n",
       "      <td>60.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5Paisa</td>\n",
       "      <td>2019-08-19</td>\n",
       "      <td>NSE</td>\n",
       "      <td>M&amp;M</td>\n",
       "      <td>buy</td>\n",
       "      <td>1</td>\n",
       "      <td>533.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-10 00:00:00</td>\n",
       "      <td>NSE</td>\n",
       "      <td>IOB</td>\n",
       "      <td>BUY</td>\n",
       "      <td>150</td>\n",
       "      <td>54.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-10 00:00:00</td>\n",
       "      <td>NSE</td>\n",
       "      <td>GMDCLTD</td>\n",
       "      <td>BUY</td>\n",
       "      <td>25</td>\n",
       "      <td>326.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-10 00:00:00</td>\n",
       "      <td>NSE</td>\n",
       "      <td>FLUOROCHEM</td>\n",
       "      <td>SELL</td>\n",
       "      <td>2</td>\n",
       "      <td>4585.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-15 00:00:00</td>\n",
       "      <td>NSE</td>\n",
       "      <td>BAJAJHFL</td>\n",
       "      <td>BUY</td>\n",
       "      <td>13</td>\n",
       "      <td>138.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-22 00:00:00</td>\n",
       "      <td>NSE</td>\n",
       "      <td>J&amp;KBANK</td>\n",
       "      <td>SELL</td>\n",
       "      <td>35</td>\n",
       "      <td>93.55</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>256 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      broker             txn_date exchange       scrip    order_type  \\\n",
       "0     5Paisa           2019-07-11      NSE      INDIGO           buy   \n",
       "1     5Paisa           2019-08-19      NSE  BAJAJ-AUTO           buy   \n",
       "2     5Paisa           2019-08-19      NSE    RELIANCE           buy   \n",
       "3     5Paisa           2019-08-19      NSE      JIOFIN  buy-demerger   \n",
       "4     5Paisa           2019-08-19      NSE         M&M           buy   \n",
       "..       ...                  ...      ...         ...           ...   \n",
       "251  Zerodha  2024-10-10 00:00:00      NSE         IOB           BUY   \n",
       "252  Zerodha  2024-10-10 00:00:00      NSE     GMDCLTD           BUY   \n",
       "253  Zerodha  2024-10-10 00:00:00      NSE  FLUOROCHEM          SELL   \n",
       "254  Zerodha  2024-10-15 00:00:00      NSE    BAJAJHFL           BUY   \n",
       "255  Zerodha  2024-10-22 00:00:00      NSE     J&KBANK          SELL   \n",
       "\n",
       "     quantity    price  \n",
       "0          10  1360.10  \n",
       "1           7  2750.95  \n",
       "2          10  1232.49  \n",
       "3          10    60.51  \n",
       "4           1   533.85  \n",
       "..        ...      ...  \n",
       "251       150    54.55  \n",
       "252        25   326.40  \n",
       "253         2  4585.00  \n",
       "254        13   138.47  \n",
       "255        35    93.55  \n",
       "\n",
       "[256 rows x 7 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_trader = df_trader.loc[:, 'Broker':'Share Price (₹)']\n",
    "df_trader.rename({'Broker': 'broker', 'Transaction Date': 'txn_date', 'Exchange': 'exchange', 'Scrip': 'scrip', 'Order Direction': 'order_type', 'Quantity': 'quantity', 'Share Price (₹)': 'price',}, axis=1, inplace=True)\n",
    "\n",
    "df_trader"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>symbol</th>\n",
       "      <th>company</th>\n",
       "      <th>price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>360ONE</td>\n",
       "      <td>360 One Wam Limited</td>\n",
       "      <td>1035.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AARTIIND</td>\n",
       "      <td>Aarti Industries Ltd</td>\n",
       "      <td>504.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ABBOTINDIA</td>\n",
       "      <td>Abbott India Limited</td>\n",
       "      <td>28625.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ACC</td>\n",
       "      <td>Acc Limited</td>\n",
       "      <td>2270.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ADANIPORTS</td>\n",
       "      <td>Adani Ports And Special Economic Zone Limited</td>\n",
       "      <td>1354.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>WELCORP</td>\n",
       "      <td>Welspun Corp Limited</td>\n",
       "      <td>719.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>WESTLIFE</td>\n",
       "      <td>Westlife Foodworld Limited</td>\n",
       "      <td>802.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>ZEEL</td>\n",
       "      <td>Zee Entertainment Enterprises Limited</td>\n",
       "      <td>124.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>ZFCVINDIA</td>\n",
       "      <td>Zf Commercial Vehicle Control Systems India Li...</td>\n",
       "      <td>13971.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>ZYDUSWELL</td>\n",
       "      <td>Zydus Wellness Limited</td>\n",
       "      <td>1837.25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>171 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         symbol                                            company     price\n",
       "0        360ONE                                360 One Wam Limited   1035.85\n",
       "1      AARTIIND                               Aarti Industries Ltd    504.85\n",
       "2    ABBOTINDIA                               Abbott India Limited  28625.85\n",
       "3           ACC                                        Acc Limited   2270.20\n",
       "4    ADANIPORTS      Adani Ports And Special Economic Zone Limited   1354.40\n",
       "..          ...                                                ...       ...\n",
       "166     WELCORP                               Welspun Corp Limited    719.15\n",
       "167    WESTLIFE                         Westlife Foodworld Limited    802.40\n",
       "168        ZEEL              Zee Entertainment Enterprises Limited    124.24\n",
       "169   ZFCVINDIA  Zf Commercial Vehicle Control Systems India Li...  13971.90\n",
       "170   ZYDUSWELL                             Zydus Wellness Limited   1837.25\n",
       "\n",
       "[171 rows x 3 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_prices = df_prices.loc[:, ['Symbol', 'Company.1', 'Price']]\n",
    "df_prices.rename({'Symbol': 'symbol', 'Company.1':'company', 'Price': 'price'}, axis=1, inplace=True)\n",
    "\n",
    "df_prices"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['broker', 'txn_date', 'exchange', 'scrip', 'order_type', 'quantity', 'price']"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fields = list(df_trader.keys())\n",
    "\n",
    "fields"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>broker</th>\n",
       "      <th>txn_date</th>\n",
       "      <th>exchange</th>\n",
       "      <th>scrip</th>\n",
       "      <th>order_type</th>\n",
       "      <th>quantity</th>\n",
       "      <th>price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>HYUNDAI</td>\n",
       "      <td>BUY</td>\n",
       "      <td>21</td>\n",
       "      <td>1970.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>FACT</td>\n",
       "      <td>BUY</td>\n",
       "      <td>10</td>\n",
       "      <td>986.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>FACT</td>\n",
       "      <td>BUY</td>\n",
       "      <td>10</td>\n",
       "      <td>986.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>FACT</td>\n",
       "      <td>BUY</td>\n",
       "      <td>10</td>\n",
       "      <td>986.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>OLAELEC</td>\n",
       "      <td>BUY</td>\n",
       "      <td>195</td>\n",
       "      <td>89.01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      broker    txn_date exchange    scrip order_type quantity    price\n",
       "0  Alphanity  2024-10-25      NSE  HYUNDAI        BUY       21  1970.00\n",
       "1  Alphanity  2024-10-25      NSE     FACT        BUY       10   986.21\n",
       "2  Alphanity  2024-10-25      NSE     FACT        BUY       10   986.21\n",
       "3  Alphanity  2024-10-25      NSE     FACT        BUY       10   986.21\n",
       "4  Alphanity  2024-10-25      NSE  OLAELEC        BUY      195    89.01"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "row_values = [['Alphanity', '2024-10-25', 'NSE', 'HYUNDAI', 'BUY', 21, 1970.00],\n",
    "              ['Alphanity', '2024-10-25', 'NSE', 'FACT', 'BUY', '10', 986.21],\n",
    "              ['Alphanity', '2024-10-25', 'NSE', 'FACT', 'BUY', '10', 986.21],\n",
    "              ['Alphanity', '2024-10-25', 'NSE', 'FACT', 'BUY', '10', 986.21],\n",
    "              ['Alphanity', '2024-10-25', 'NSE', 'OLAELEC', 'BUY', '195', 89.01]]\n",
    "\n",
    "new_rows = pd.DataFrame(row_values, columns=fields)\n",
    "new_rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>broker</th>\n",
       "      <th>txn_date</th>\n",
       "      <th>exchange</th>\n",
       "      <th>scrip</th>\n",
       "      <th>order_type</th>\n",
       "      <th>quantity</th>\n",
       "      <th>price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-10 00:00:00</td>\n",
       "      <td>NSE</td>\n",
       "      <td>IOB</td>\n",
       "      <td>BUY</td>\n",
       "      <td>150</td>\n",
       "      <td>54.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-10 00:00:00</td>\n",
       "      <td>NSE</td>\n",
       "      <td>GMDCLTD</td>\n",
       "      <td>BUY</td>\n",
       "      <td>25</td>\n",
       "      <td>326.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-10 00:00:00</td>\n",
       "      <td>NSE</td>\n",
       "      <td>FLUOROCHEM</td>\n",
       "      <td>SELL</td>\n",
       "      <td>2</td>\n",
       "      <td>4585.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-15 00:00:00</td>\n",
       "      <td>NSE</td>\n",
       "      <td>BAJAJHFL</td>\n",
       "      <td>BUY</td>\n",
       "      <td>13</td>\n",
       "      <td>138.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-22 00:00:00</td>\n",
       "      <td>NSE</td>\n",
       "      <td>J&amp;KBANK</td>\n",
       "      <td>SELL</td>\n",
       "      <td>35</td>\n",
       "      <td>93.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>HYUNDAI</td>\n",
       "      <td>BUY</td>\n",
       "      <td>21</td>\n",
       "      <td>1970.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>FACT</td>\n",
       "      <td>BUY</td>\n",
       "      <td>10</td>\n",
       "      <td>986.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>FACT</td>\n",
       "      <td>BUY</td>\n",
       "      <td>10</td>\n",
       "      <td>986.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>FACT</td>\n",
       "      <td>BUY</td>\n",
       "      <td>10</td>\n",
       "      <td>986.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>OLAELEC</td>\n",
       "      <td>BUY</td>\n",
       "      <td>195</td>\n",
       "      <td>89.01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        broker             txn_date exchange       scrip order_type quantity  \\\n",
       "251    Zerodha  2024-10-10 00:00:00      NSE         IOB        BUY      150   \n",
       "252    Zerodha  2024-10-10 00:00:00      NSE     GMDCLTD        BUY       25   \n",
       "253    Zerodha  2024-10-10 00:00:00      NSE  FLUOROCHEM       SELL        2   \n",
       "254    Zerodha  2024-10-15 00:00:00      NSE    BAJAJHFL        BUY       13   \n",
       "255    Zerodha  2024-10-22 00:00:00      NSE     J&KBANK       SELL       35   \n",
       "256  Alphanity           2024-10-25      NSE     HYUNDAI        BUY       21   \n",
       "257  Alphanity           2024-10-25      NSE        FACT        BUY       10   \n",
       "258  Alphanity           2024-10-25      NSE        FACT        BUY       10   \n",
       "259  Alphanity           2024-10-25      NSE        FACT        BUY       10   \n",
       "260  Alphanity           2024-10-25      NSE     OLAELEC        BUY      195   \n",
       "\n",
       "       price  \n",
       "251    54.55  \n",
       "252   326.40  \n",
       "253  4585.00  \n",
       "254   138.47  \n",
       "255    93.55  \n",
       "256  1970.00  \n",
       "257   986.21  \n",
       "258   986.21  \n",
       "259   986.21  \n",
       "260    89.01  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_trader = pd.concat([df_trader, new_rows], ignore_index=True)\n",
    "df_trader.tail(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>broker</th>\n",
       "      <th>txn_date</th>\n",
       "      <th>exchange</th>\n",
       "      <th>scrip</th>\n",
       "      <th>order_type</th>\n",
       "      <th>quantity</th>\n",
       "      <th>price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-15 00:00:00</td>\n",
       "      <td>NSE</td>\n",
       "      <td>BAJAJHFL</td>\n",
       "      <td>BUY</td>\n",
       "      <td>13</td>\n",
       "      <td>138.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-22 00:00:00</td>\n",
       "      <td>NSE</td>\n",
       "      <td>J&amp;KBANK</td>\n",
       "      <td>SELL</td>\n",
       "      <td>35</td>\n",
       "      <td>93.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>HYUNDAI</td>\n",
       "      <td>BUY</td>\n",
       "      <td>21</td>\n",
       "      <td>1970.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>FACT</td>\n",
       "      <td>BUY</td>\n",
       "      <td>10</td>\n",
       "      <td>986.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>OLAELEC</td>\n",
       "      <td>BUY</td>\n",
       "      <td>195</td>\n",
       "      <td>89.01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        broker             txn_date exchange     scrip order_type quantity  \\\n",
       "254    Zerodha  2024-10-15 00:00:00      NSE  BAJAJHFL        BUY       13   \n",
       "255    Zerodha  2024-10-22 00:00:00      NSE   J&KBANK       SELL       35   \n",
       "256  Alphanity           2024-10-25      NSE   HYUNDAI        BUY       21   \n",
       "257  Alphanity           2024-10-25      NSE      FACT        BUY       10   \n",
       "260  Alphanity           2024-10-25      NSE   OLAELEC        BUY      195   \n",
       "\n",
       "       price  \n",
       "254   138.47  \n",
       "255    93.55  \n",
       "256  1970.00  \n",
       "257   986.21  \n",
       "260    89.01  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_trader.drop([258, 259], inplace=True)\n",
    "df_trader.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>broker</th>\n",
       "      <th>txn_date</th>\n",
       "      <th>exchange</th>\n",
       "      <th>scrip</th>\n",
       "      <th>order_type</th>\n",
       "      <th>quantity</th>\n",
       "      <th>price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-15 00:00:00</td>\n",
       "      <td>NSE</td>\n",
       "      <td>BAJAJHFL</td>\n",
       "      <td>BUY</td>\n",
       "      <td>13</td>\n",
       "      <td>138.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-22 00:00:00</td>\n",
       "      <td>NSE</td>\n",
       "      <td>J&amp;KBANK</td>\n",
       "      <td>SELL</td>\n",
       "      <td>35</td>\n",
       "      <td>93.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>HYUNDAI</td>\n",
       "      <td>BUY</td>\n",
       "      <td>21</td>\n",
       "      <td>1970.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>FACT</td>\n",
       "      <td>BUY</td>\n",
       "      <td>10</td>\n",
       "      <td>986.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>OLAELEC</td>\n",
       "      <td>BUY</td>\n",
       "      <td>195</td>\n",
       "      <td>89.01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        broker             txn_date exchange     scrip order_type quantity  \\\n",
       "254    Zerodha  2024-10-15 00:00:00      NSE  BAJAJHFL        BUY       13   \n",
       "255    Zerodha  2024-10-22 00:00:00      NSE   J&KBANK       SELL       35   \n",
       "256  Alphanity           2024-10-25      NSE   HYUNDAI        BUY       21   \n",
       "257  Alphanity           2024-10-25      NSE      FACT        BUY       10   \n",
       "258  Alphanity           2024-10-25      NSE   OLAELEC        BUY      195   \n",
       "\n",
       "       price  \n",
       "254   138.47  \n",
       "255    93.55  \n",
       "256  1970.00  \n",
       "257   986.21  \n",
       "258    89.01  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_trader.reset_index(drop=True, inplace=True)\n",
    "df_trader.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>broker</th>\n",
       "      <th>txn_date</th>\n",
       "      <th>exchange</th>\n",
       "      <th>scrip</th>\n",
       "      <th>order_type</th>\n",
       "      <th>quantity</th>\n",
       "      <th>price</th>\n",
       "      <th>trade_value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-15 00:00:00</td>\n",
       "      <td>NSE</td>\n",
       "      <td>BAJAJHFL</td>\n",
       "      <td>BUY</td>\n",
       "      <td>13</td>\n",
       "      <td>138.47</td>\n",
       "      <td>1800.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-22 00:00:00</td>\n",
       "      <td>NSE</td>\n",
       "      <td>J&amp;KBANK</td>\n",
       "      <td>SELL</td>\n",
       "      <td>35</td>\n",
       "      <td>93.55</td>\n",
       "      <td>3274.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>HYUNDAI</td>\n",
       "      <td>BUY</td>\n",
       "      <td>21</td>\n",
       "      <td>1970.00</td>\n",
       "      <td>41370.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>FACT</td>\n",
       "      <td>BUY</td>\n",
       "      <td>10</td>\n",
       "      <td>986.21</td>\n",
       "      <td>9862.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>OLAELEC</td>\n",
       "      <td>BUY</td>\n",
       "      <td>195</td>\n",
       "      <td>89.01</td>\n",
       "      <td>17356.95</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        broker             txn_date exchange     scrip order_type  quantity  \\\n",
       "254    Zerodha  2024-10-15 00:00:00      NSE  BAJAJHFL        BUY        13   \n",
       "255    Zerodha  2024-10-22 00:00:00      NSE   J&KBANK       SELL        35   \n",
       "256  Alphanity           2024-10-25      NSE   HYUNDAI        BUY        21   \n",
       "257  Alphanity           2024-10-25      NSE      FACT        BUY        10   \n",
       "258  Alphanity           2024-10-25      NSE   OLAELEC        BUY       195   \n",
       "\n",
       "       price  trade_value  \n",
       "254   138.47      1800.11  \n",
       "255    93.55      3274.25  \n",
       "256  1970.00     41370.00  \n",
       "257   986.21      9862.10  \n",
       "258    89.01     17356.95  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_trader['quantity'] = pd.to_numeric(df_trader['quantity'])\n",
    "df_trader.loc[:, 'trade_value'] = df_trader['quantity'] * df_trader['price']\n",
    "df_trader.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>broker</th>\n",
       "      <th>txn_date</th>\n",
       "      <th>exchange</th>\n",
       "      <th>scrip</th>\n",
       "      <th>order_type</th>\n",
       "      <th>quantity</th>\n",
       "      <th>price</th>\n",
       "      <th>trade_value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>AngelOne</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>NSE</td>\n",
       "      <td>POWERGRID</td>\n",
       "      <td>BUY</td>\n",
       "      <td>20</td>\n",
       "      <td>350.40</td>\n",
       "      <td>7008.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>AngelOne</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>NSE</td>\n",
       "      <td>RENUKA</td>\n",
       "      <td>BUY</td>\n",
       "      <td>100</td>\n",
       "      <td>54.56</td>\n",
       "      <td>5456.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>AngelOne</td>\n",
       "      <td>2024-10-04</td>\n",
       "      <td>NSE</td>\n",
       "      <td>AARTIIND</td>\n",
       "      <td>SELL</td>\n",
       "      <td>8</td>\n",
       "      <td>552.00</td>\n",
       "      <td>4416.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>Upstox</td>\n",
       "      <td>2024-10-07</td>\n",
       "      <td>unlisted</td>\n",
       "      <td>HEROFINCORP</td>\n",
       "      <td>buy</td>\n",
       "      <td>5</td>\n",
       "      <td>2123.00</td>\n",
       "      <td>10615.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>Upstox</td>\n",
       "      <td>2024-10-07</td>\n",
       "      <td>unlisted</td>\n",
       "      <td>COCHINAIRPORT</td>\n",
       "      <td>buy</td>\n",
       "      <td>20</td>\n",
       "      <td>464.00</td>\n",
       "      <td>9280.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-08</td>\n",
       "      <td>NSE</td>\n",
       "      <td>DATAPATTNS</td>\n",
       "      <td>SELL</td>\n",
       "      <td>2</td>\n",
       "      <td>2380.80</td>\n",
       "      <td>4761.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-09</td>\n",
       "      <td>NSE</td>\n",
       "      <td>CONCOR</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>896.30</td>\n",
       "      <td>4481.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-10</td>\n",
       "      <td>NSE</td>\n",
       "      <td>TITAGARH</td>\n",
       "      <td>BUY</td>\n",
       "      <td>9</td>\n",
       "      <td>1080.00</td>\n",
       "      <td>9720.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-10</td>\n",
       "      <td>NSE</td>\n",
       "      <td>RCF</td>\n",
       "      <td>BUY</td>\n",
       "      <td>50</td>\n",
       "      <td>183.75</td>\n",
       "      <td>9187.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-10</td>\n",
       "      <td>NSE</td>\n",
       "      <td>ENGINERSIN</td>\n",
       "      <td>BUY</td>\n",
       "      <td>30</td>\n",
       "      <td>200.30</td>\n",
       "      <td>6009.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-10</td>\n",
       "      <td>NSE</td>\n",
       "      <td>RVNL</td>\n",
       "      <td>BUY</td>\n",
       "      <td>20</td>\n",
       "      <td>481.40</td>\n",
       "      <td>9628.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-10</td>\n",
       "      <td>NSE</td>\n",
       "      <td>AARTIIND</td>\n",
       "      <td>BUY</td>\n",
       "      <td>12</td>\n",
       "      <td>527.90</td>\n",
       "      <td>6334.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-10</td>\n",
       "      <td>NSE</td>\n",
       "      <td>IOB</td>\n",
       "      <td>BUY</td>\n",
       "      <td>150</td>\n",
       "      <td>54.55</td>\n",
       "      <td>8182.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-10</td>\n",
       "      <td>NSE</td>\n",
       "      <td>GMDCLTD</td>\n",
       "      <td>BUY</td>\n",
       "      <td>25</td>\n",
       "      <td>326.40</td>\n",
       "      <td>8160.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-10</td>\n",
       "      <td>NSE</td>\n",
       "      <td>FLUOROCHEM</td>\n",
       "      <td>SELL</td>\n",
       "      <td>2</td>\n",
       "      <td>4585.00</td>\n",
       "      <td>9170.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-15</td>\n",
       "      <td>NSE</td>\n",
       "      <td>BAJAJHFL</td>\n",
       "      <td>BUY</td>\n",
       "      <td>13</td>\n",
       "      <td>138.47</td>\n",
       "      <td>1800.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-22</td>\n",
       "      <td>NSE</td>\n",
       "      <td>J&amp;KBANK</td>\n",
       "      <td>SELL</td>\n",
       "      <td>35</td>\n",
       "      <td>93.55</td>\n",
       "      <td>3274.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>HYUNDAI</td>\n",
       "      <td>BUY</td>\n",
       "      <td>21</td>\n",
       "      <td>1970.00</td>\n",
       "      <td>41370.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>FACT</td>\n",
       "      <td>BUY</td>\n",
       "      <td>10</td>\n",
       "      <td>986.21</td>\n",
       "      <td>9862.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>OLAELEC</td>\n",
       "      <td>BUY</td>\n",
       "      <td>195</td>\n",
       "      <td>89.01</td>\n",
       "      <td>17356.95</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        broker   txn_date  exchange          scrip order_type  quantity  \\\n",
       "239   AngelOne 2024-10-01       NSE      POWERGRID        BUY        20   \n",
       "240   AngelOne 2024-10-01       NSE         RENUKA        BUY       100   \n",
       "241   AngelOne 2024-10-04       NSE       AARTIIND       SELL         8   \n",
       "242     Upstox 2024-10-07  unlisted    HEROFINCORP        buy         5   \n",
       "243     Upstox 2024-10-07  unlisted  COCHINAIRPORT        buy        20   \n",
       "244    Zerodha 2024-10-08       NSE     DATAPATTNS       SELL         2   \n",
       "245    Zerodha 2024-10-09       NSE         CONCOR        BUY         5   \n",
       "246    Zerodha 2024-10-10       NSE       TITAGARH        BUY         9   \n",
       "247    Zerodha 2024-10-10       NSE            RCF        BUY        50   \n",
       "248    Zerodha 2024-10-10       NSE     ENGINERSIN        BUY        30   \n",
       "249    Zerodha 2024-10-10       NSE           RVNL        BUY        20   \n",
       "250    Zerodha 2024-10-10       NSE       AARTIIND        BUY        12   \n",
       "251    Zerodha 2024-10-10       NSE            IOB        BUY       150   \n",
       "252    Zerodha 2024-10-10       NSE        GMDCLTD        BUY        25   \n",
       "253    Zerodha 2024-10-10       NSE     FLUOROCHEM       SELL         2   \n",
       "254    Zerodha 2024-10-15       NSE       BAJAJHFL        BUY        13   \n",
       "255    Zerodha 2024-10-22       NSE        J&KBANK       SELL        35   \n",
       "256  Alphanity 2024-10-25       NSE        HYUNDAI        BUY        21   \n",
       "257  Alphanity 2024-10-25       NSE           FACT        BUY        10   \n",
       "258  Alphanity 2024-10-25       NSE        OLAELEC        BUY       195   \n",
       "\n",
       "       price  trade_value  \n",
       "239   350.40      7008.00  \n",
       "240    54.56      5456.00  \n",
       "241   552.00      4416.00  \n",
       "242  2123.00     10615.00  \n",
       "243   464.00      9280.00  \n",
       "244  2380.80      4761.60  \n",
       "245   896.30      4481.50  \n",
       "246  1080.00      9720.00  \n",
       "247   183.75      9187.50  \n",
       "248   200.30      6009.00  \n",
       "249   481.40      9628.00  \n",
       "250   527.90      6334.80  \n",
       "251    54.55      8182.50  \n",
       "252   326.40      8160.00  \n",
       "253  4585.00      9170.00  \n",
       "254   138.47      1800.11  \n",
       "255    93.55      3274.25  \n",
       "256  1970.00     41370.00  \n",
       "257   986.21      9862.10  \n",
       "258    89.01     17356.95  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from datetime import date\n",
    "\n",
    "df_trader['txn_date'] = pd.to_datetime(df_trader['txn_date'])\n",
    "october_trades = df_trader[df_trader['txn_date'].dt.date >= date(2024,10,1)]\n",
    "october_trades"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "october_trades = october_trades.merge(df_prices, left_on='scrip', right_on='symbol', sort=True)\n",
    "\n",
    "fields = {'price_x':'trade_price', 'price_y':'current_price',}\n",
    "october_trades.rename(fields, axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>broker</th>\n",
       "      <th>txn_date</th>\n",
       "      <th>exchange</th>\n",
       "      <th>scrip</th>\n",
       "      <th>order_type</th>\n",
       "      <th>quantity</th>\n",
       "      <th>trade_price</th>\n",
       "      <th>trade_value</th>\n",
       "      <th>symbol</th>\n",
       "      <th>company</th>\n",
       "      <th>current_price</th>\n",
       "      <th>current_worth</th>\n",
       "      <th>nett_gain</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AngelOne</td>\n",
       "      <td>2024-10-04</td>\n",
       "      <td>NSE</td>\n",
       "      <td>AARTIIND</td>\n",
       "      <td>SELL</td>\n",
       "      <td>8</td>\n",
       "      <td>552.00</td>\n",
       "      <td>4416.00</td>\n",
       "      <td>AARTIIND</td>\n",
       "      <td>Aarti Industries Ltd</td>\n",
       "      <td>504.85</td>\n",
       "      <td>4038.8</td>\n",
       "      <td>-377.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-10</td>\n",
       "      <td>NSE</td>\n",
       "      <td>AARTIIND</td>\n",
       "      <td>BUY</td>\n",
       "      <td>12</td>\n",
       "      <td>527.90</td>\n",
       "      <td>6334.80</td>\n",
       "      <td>AARTIIND</td>\n",
       "      <td>Aarti Industries Ltd</td>\n",
       "      <td>504.85</td>\n",
       "      <td>6058.2</td>\n",
       "      <td>-276.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Upstox</td>\n",
       "      <td>2024-10-07</td>\n",
       "      <td>unlisted</td>\n",
       "      <td>COCHINAIRPORT</td>\n",
       "      <td>buy</td>\n",
       "      <td>20</td>\n",
       "      <td>464.00</td>\n",
       "      <td>9280.00</td>\n",
       "      <td>COCHINAIRPORT</td>\n",
       "      <td>Cochin International Airport (unlisted)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-09</td>\n",
       "      <td>NSE</td>\n",
       "      <td>CONCOR</td>\n",
       "      <td>BUY</td>\n",
       "      <td>5</td>\n",
       "      <td>896.30</td>\n",
       "      <td>4481.50</td>\n",
       "      <td>CONCOR</td>\n",
       "      <td>Container Corporation Of India Limited</td>\n",
       "      <td>813.80</td>\n",
       "      <td>4069.0</td>\n",
       "      <td>-412.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-08</td>\n",
       "      <td>NSE</td>\n",
       "      <td>DATAPATTNS</td>\n",
       "      <td>SELL</td>\n",
       "      <td>2</td>\n",
       "      <td>2380.80</td>\n",
       "      <td>4761.60</td>\n",
       "      <td>DATAPATTNS</td>\n",
       "      <td>Data Patterns (India) Limited</td>\n",
       "      <td>2258.75</td>\n",
       "      <td>4517.5</td>\n",
       "      <td>-244.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-10</td>\n",
       "      <td>NSE</td>\n",
       "      <td>ENGINERSIN</td>\n",
       "      <td>BUY</td>\n",
       "      <td>30</td>\n",
       "      <td>200.30</td>\n",
       "      <td>6009.00</td>\n",
       "      <td>ENGINERSIN</td>\n",
       "      <td>Engineers India Limited</td>\n",
       "      <td>180.41</td>\n",
       "      <td>5412.3</td>\n",
       "      <td>-596.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>FACT</td>\n",
       "      <td>BUY</td>\n",
       "      <td>10</td>\n",
       "      <td>986.21</td>\n",
       "      <td>9862.10</td>\n",
       "      <td>FACT</td>\n",
       "      <td>Fertilisers And Chemicals Travancore Ltd</td>\n",
       "      <td>836.65</td>\n",
       "      <td>8366.5</td>\n",
       "      <td>-1495.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-10</td>\n",
       "      <td>NSE</td>\n",
       "      <td>FLUOROCHEM</td>\n",
       "      <td>SELL</td>\n",
       "      <td>2</td>\n",
       "      <td>4585.00</td>\n",
       "      <td>9170.00</td>\n",
       "      <td>FLUOROCHEM</td>\n",
       "      <td>Gujarat Fluorochemicals Limited</td>\n",
       "      <td>4274.90</td>\n",
       "      <td>8549.8</td>\n",
       "      <td>-620.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-10</td>\n",
       "      <td>NSE</td>\n",
       "      <td>GMDCLTD</td>\n",
       "      <td>BUY</td>\n",
       "      <td>25</td>\n",
       "      <td>326.40</td>\n",
       "      <td>8160.00</td>\n",
       "      <td>GMDCLTD</td>\n",
       "      <td>Gujarat Mineral Development Corporation Limited</td>\n",
       "      <td>358.20</td>\n",
       "      <td>8955.0</td>\n",
       "      <td>795.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Upstox</td>\n",
       "      <td>2024-10-07</td>\n",
       "      <td>unlisted</td>\n",
       "      <td>HEROFINCORP</td>\n",
       "      <td>buy</td>\n",
       "      <td>5</td>\n",
       "      <td>2123.00</td>\n",
       "      <td>10615.00</td>\n",
       "      <td>HEROFINCORP</td>\n",
       "      <td>Hero Fincorp (unlisted)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-10</td>\n",
       "      <td>NSE</td>\n",
       "      <td>IOB</td>\n",
       "      <td>BUY</td>\n",
       "      <td>150</td>\n",
       "      <td>54.55</td>\n",
       "      <td>8182.50</td>\n",
       "      <td>IOB</td>\n",
       "      <td>Indian Overseas Bank</td>\n",
       "      <td>51.66</td>\n",
       "      <td>7749.0</td>\n",
       "      <td>-433.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-22</td>\n",
       "      <td>NSE</td>\n",
       "      <td>J&amp;KBANK</td>\n",
       "      <td>SELL</td>\n",
       "      <td>35</td>\n",
       "      <td>93.55</td>\n",
       "      <td>3274.25</td>\n",
       "      <td>J&amp;KBANK</td>\n",
       "      <td>Jammu And Kashmir Bank Limited</td>\n",
       "      <td>93.90</td>\n",
       "      <td>3286.5</td>\n",
       "      <td>12.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Alphanity</td>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>NSE</td>\n",
       "      <td>OLAELEC</td>\n",
       "      <td>BUY</td>\n",
       "      <td>195</td>\n",
       "      <td>89.01</td>\n",
       "      <td>17356.95</td>\n",
       "      <td>OLAELEC</td>\n",
       "      <td>Ola Electric Mobility Limited</td>\n",
       "      <td>111.58</td>\n",
       "      <td>21758.1</td>\n",
       "      <td>4401.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-10</td>\n",
       "      <td>NSE</td>\n",
       "      <td>RCF</td>\n",
       "      <td>BUY</td>\n",
       "      <td>50</td>\n",
       "      <td>183.75</td>\n",
       "      <td>9187.50</td>\n",
       "      <td>RCF</td>\n",
       "      <td>Rashtriya Chemicals And Fertilizers Limited</td>\n",
       "      <td>157.60</td>\n",
       "      <td>7880.0</td>\n",
       "      <td>-1307.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-10</td>\n",
       "      <td>NSE</td>\n",
       "      <td>RVNL</td>\n",
       "      <td>BUY</td>\n",
       "      <td>20</td>\n",
       "      <td>481.40</td>\n",
       "      <td>9628.00</td>\n",
       "      <td>RVNL</td>\n",
       "      <td>Rail Vikas Nigam Limited</td>\n",
       "      <td>441.95</td>\n",
       "      <td>8839.0</td>\n",
       "      <td>-789.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Zerodha</td>\n",
       "      <td>2024-10-10</td>\n",
       "      <td>NSE</td>\n",
       "      <td>TITAGARH</td>\n",
       "      <td>BUY</td>\n",
       "      <td>9</td>\n",
       "      <td>1080.00</td>\n",
       "      <td>9720.00</td>\n",
       "      <td>TITAGARH</td>\n",
       "      <td>Titagarh Rail Systems Limited</td>\n",
       "      <td>1166.30</td>\n",
       "      <td>10496.7</td>\n",
       "      <td>776.70</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       broker   txn_date  exchange          scrip order_type  quantity  \\\n",
       "0    AngelOne 2024-10-04       NSE       AARTIIND       SELL         8   \n",
       "1     Zerodha 2024-10-10       NSE       AARTIIND        BUY        12   \n",
       "2      Upstox 2024-10-07  unlisted  COCHINAIRPORT        buy        20   \n",
       "3     Zerodha 2024-10-09       NSE         CONCOR        BUY         5   \n",
       "4     Zerodha 2024-10-08       NSE     DATAPATTNS       SELL         2   \n",
       "5     Zerodha 2024-10-10       NSE     ENGINERSIN        BUY        30   \n",
       "6   Alphanity 2024-10-25       NSE           FACT        BUY        10   \n",
       "7     Zerodha 2024-10-10       NSE     FLUOROCHEM       SELL         2   \n",
       "8     Zerodha 2024-10-10       NSE        GMDCLTD        BUY        25   \n",
       "9      Upstox 2024-10-07  unlisted    HEROFINCORP        buy         5   \n",
       "10    Zerodha 2024-10-10       NSE            IOB        BUY       150   \n",
       "11    Zerodha 2024-10-22       NSE        J&KBANK       SELL        35   \n",
       "12  Alphanity 2024-10-25       NSE        OLAELEC        BUY       195   \n",
       "13    Zerodha 2024-10-10       NSE            RCF        BUY        50   \n",
       "14    Zerodha 2024-10-10       NSE           RVNL        BUY        20   \n",
       "15    Zerodha 2024-10-10       NSE       TITAGARH        BUY         9   \n",
       "\n",
       "    trade_price  trade_value         symbol  \\\n",
       "0        552.00      4416.00       AARTIIND   \n",
       "1        527.90      6334.80       AARTIIND   \n",
       "2        464.00      9280.00  COCHINAIRPORT   \n",
       "3        896.30      4481.50         CONCOR   \n",
       "4       2380.80      4761.60     DATAPATTNS   \n",
       "5        200.30      6009.00     ENGINERSIN   \n",
       "6        986.21      9862.10           FACT   \n",
       "7       4585.00      9170.00     FLUOROCHEM   \n",
       "8        326.40      8160.00        GMDCLTD   \n",
       "9       2123.00     10615.00    HEROFINCORP   \n",
       "10        54.55      8182.50            IOB   \n",
       "11        93.55      3274.25        J&KBANK   \n",
       "12        89.01     17356.95        OLAELEC   \n",
       "13       183.75      9187.50            RCF   \n",
       "14       481.40      9628.00           RVNL   \n",
       "15      1080.00      9720.00       TITAGARH   \n",
       "\n",
       "                                            company  current_price  \\\n",
       "0                              Aarti Industries Ltd         504.85   \n",
       "1                              Aarti Industries Ltd         504.85   \n",
       "2           Cochin International Airport (unlisted)            NaN   \n",
       "3            Container Corporation Of India Limited         813.80   \n",
       "4                     Data Patterns (India) Limited        2258.75   \n",
       "5                           Engineers India Limited         180.41   \n",
       "6          Fertilisers And Chemicals Travancore Ltd         836.65   \n",
       "7                   Gujarat Fluorochemicals Limited        4274.90   \n",
       "8   Gujarat Mineral Development Corporation Limited         358.20   \n",
       "9                           Hero Fincorp (unlisted)            NaN   \n",
       "10                             Indian Overseas Bank          51.66   \n",
       "11                   Jammu And Kashmir Bank Limited          93.90   \n",
       "12                    Ola Electric Mobility Limited         111.58   \n",
       "13      Rashtriya Chemicals And Fertilizers Limited         157.60   \n",
       "14                         Rail Vikas Nigam Limited         441.95   \n",
       "15                    Titagarh Rail Systems Limited        1166.30   \n",
       "\n",
       "    current_worth  nett_gain  \n",
       "0          4038.8    -377.20  \n",
       "1          6058.2    -276.60  \n",
       "2             NaN        NaN  \n",
       "3          4069.0    -412.50  \n",
       "4          4517.5    -244.10  \n",
       "5          5412.3    -596.70  \n",
       "6          8366.5   -1495.60  \n",
       "7          8549.8    -620.20  \n",
       "8          8955.0     795.00  \n",
       "9             NaN        NaN  \n",
       "10         7749.0    -433.50  \n",
       "11         3286.5      12.25  \n",
       "12        21758.1    4401.15  \n",
       "13         7880.0   -1307.50  \n",
       "14         8839.0    -789.00  \n",
       "15        10496.7     776.70  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "october_trades['current_worth'] = october_trades['quantity'] * october_trades['current_price']\n",
    "october_trades['nett_gain'] = october_trades['current_worth'] - october_trades['trade_value']\n",
    "\n",
    "october_trades"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/8l/f2jwk87j66l_vsfyrwt7gly00000gn/T/ipykernel_23616/2033009178.py:2: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
      "  october_trades = october_trades.loc[:, required_fields][pd.notna(october_trades['current_price'])][october_trades['order_type']=='BUY']\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>txn_date</th>\n",
       "      <th>order_type</th>\n",
       "      <th>scrip</th>\n",
       "      <th>company</th>\n",
       "      <th>quantity</th>\n",
       "      <th>trade_price</th>\n",
       "      <th>current_price</th>\n",
       "      <th>nett_gain</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2024-10-10</td>\n",
       "      <td>BUY</td>\n",
       "      <td>AARTIIND</td>\n",
       "      <td>Aarti Industries Ltd</td>\n",
       "      <td>12</td>\n",
       "      <td>527.90</td>\n",
       "      <td>504.85</td>\n",
       "      <td>-276.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2024-10-09</td>\n",
       "      <td>BUY</td>\n",
       "      <td>CONCOR</td>\n",
       "      <td>Container Corporation Of India Limited</td>\n",
       "      <td>5</td>\n",
       "      <td>896.30</td>\n",
       "      <td>813.80</td>\n",
       "      <td>-412.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2024-10-10</td>\n",
       "      <td>BUY</td>\n",
       "      <td>ENGINERSIN</td>\n",
       "      <td>Engineers India Limited</td>\n",
       "      <td>30</td>\n",
       "      <td>200.30</td>\n",
       "      <td>180.41</td>\n",
       "      <td>-596.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>BUY</td>\n",
       "      <td>FACT</td>\n",
       "      <td>Fertilisers And Chemicals Travancore Ltd</td>\n",
       "      <td>10</td>\n",
       "      <td>986.21</td>\n",
       "      <td>836.65</td>\n",
       "      <td>-1495.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2024-10-10</td>\n",
       "      <td>BUY</td>\n",
       "      <td>GMDCLTD</td>\n",
       "      <td>Gujarat Mineral Development Corporation Limited</td>\n",
       "      <td>25</td>\n",
       "      <td>326.40</td>\n",
       "      <td>358.20</td>\n",
       "      <td>795.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2024-10-10</td>\n",
       "      <td>BUY</td>\n",
       "      <td>IOB</td>\n",
       "      <td>Indian Overseas Bank</td>\n",
       "      <td>150</td>\n",
       "      <td>54.55</td>\n",
       "      <td>51.66</td>\n",
       "      <td>-433.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2024-10-25</td>\n",
       "      <td>BUY</td>\n",
       "      <td>OLAELEC</td>\n",
       "      <td>Ola Electric Mobility Limited</td>\n",
       "      <td>195</td>\n",
       "      <td>89.01</td>\n",
       "      <td>111.58</td>\n",
       "      <td>4401.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2024-10-10</td>\n",
       "      <td>BUY</td>\n",
       "      <td>RCF</td>\n",
       "      <td>Rashtriya Chemicals And Fertilizers Limited</td>\n",
       "      <td>50</td>\n",
       "      <td>183.75</td>\n",
       "      <td>157.60</td>\n",
       "      <td>-1307.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2024-10-10</td>\n",
       "      <td>BUY</td>\n",
       "      <td>RVNL</td>\n",
       "      <td>Rail Vikas Nigam Limited</td>\n",
       "      <td>20</td>\n",
       "      <td>481.40</td>\n",
       "      <td>441.95</td>\n",
       "      <td>-789.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2024-10-10</td>\n",
       "      <td>BUY</td>\n",
       "      <td>TITAGARH</td>\n",
       "      <td>Titagarh Rail Systems Limited</td>\n",
       "      <td>9</td>\n",
       "      <td>1080.00</td>\n",
       "      <td>1166.30</td>\n",
       "      <td>776.70</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     txn_date order_type       scrip  \\\n",
       "1  2024-10-10        BUY    AARTIIND   \n",
       "3  2024-10-09        BUY      CONCOR   \n",
       "5  2024-10-10        BUY  ENGINERSIN   \n",
       "6  2024-10-25        BUY        FACT   \n",
       "8  2024-10-10        BUY     GMDCLTD   \n",
       "10 2024-10-10        BUY         IOB   \n",
       "12 2024-10-25        BUY     OLAELEC   \n",
       "13 2024-10-10        BUY         RCF   \n",
       "14 2024-10-10        BUY        RVNL   \n",
       "15 2024-10-10        BUY    TITAGARH   \n",
       "\n",
       "                                            company  quantity  trade_price  \\\n",
       "1                              Aarti Industries Ltd        12       527.90   \n",
       "3            Container Corporation Of India Limited         5       896.30   \n",
       "5                           Engineers India Limited        30       200.30   \n",
       "6          Fertilisers And Chemicals Travancore Ltd        10       986.21   \n",
       "8   Gujarat Mineral Development Corporation Limited        25       326.40   \n",
       "10                             Indian Overseas Bank       150        54.55   \n",
       "12                    Ola Electric Mobility Limited       195        89.01   \n",
       "13      Rashtriya Chemicals And Fertilizers Limited        50       183.75   \n",
       "14                         Rail Vikas Nigam Limited        20       481.40   \n",
       "15                    Titagarh Rail Systems Limited         9      1080.00   \n",
       "\n",
       "    current_price  nett_gain  \n",
       "1          504.85    -276.60  \n",
       "3          813.80    -412.50  \n",
       "5          180.41    -596.70  \n",
       "6          836.65   -1495.60  \n",
       "8          358.20     795.00  \n",
       "10          51.66    -433.50  \n",
       "12         111.58    4401.15  \n",
       "13         157.60   -1307.50  \n",
       "14         441.95    -789.00  \n",
       "15        1166.30     776.70  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "required_fields = ['txn_date', 'order_type', 'scrip', 'company', 'quantity', 'trade_price', 'current_price', 'nett_gain']\n",
    "october_trades = october_trades.loc[:, required_fields][pd.notna(october_trades['current_price'])][october_trades['order_type']=='BUY']\n",
    "october_trades"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "661.45"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "round(october_trades['nett_gain'].sum(),2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "scala",
   "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": 2
}