IRPF.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "pd.options.display.float_format = '${:,.2f}'.format\n",
    "import datetime as dt\n",
    "import numpy as np\n",
    "from FinanceTools import *\n",
    "from IRPF_Tools import *\n",
    "\n",
    "csv = 'debug/df_log_br.tsv'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/doreis/lowrisc/git/Finances/IRPF_Tools.py:123: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  tmp.sort_values(['PAYDATE', 'OPERATION'], ascending=[True, False],inplace=True)\n",
      "/home/doreis/lowrisc/git/Finances/IRPF_Tools.py:123: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  tmp.sort_values(['PAYDATE', 'OPERATION'], ascending=[True, False],inplace=True)\n",
      "/home/doreis/lowrisc/git/Finances/IRPF_Tools.py:123: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  tmp.sort_values(['PAYDATE', 'OPERATION'], ascending=[True, False],inplace=True)\n",
      "/home/doreis/lowrisc/git/Finances/IRPF_Tools.py:123: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  tmp.sort_values(['PAYDATE', 'OPERATION'], ascending=[True, False],inplace=True)\n",
      "/home/doreis/lowrisc/git/Finances/IRPF_Tools.py:123: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  tmp.sort_values(['PAYDATE', 'OPERATION'], ascending=[True, False],inplace=True)\n"
     ]
    }
   ],
   "source": [
    "\n",
    "irpf = IRPF_BensDireitos(csv)\n",
    "irpf.load()\n",
    "# df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "</style>\n",
       "<table id=\"T_4b0f6\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th id=\"T_4b0f6_level0_col0\" class=\"col_heading level0 col0\" colspan=\"3\">2021-12-31</th>\n",
       "      <th id=\"T_4b0f6_level0_col3\" class=\"col_heading level0 col3\" colspan=\"3\">2022-12-31</th>\n",
       "      <th id=\"T_4b0f6_level0_col6\" class=\"col_heading level0 col6\" >CNPJ</th>\n",
       "      <th id=\"T_4b0f6_level0_col7\" class=\"col_heading level0 col7\" >DESC</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th class=\"blank level1\" >&nbsp;</th>\n",
       "      <th id=\"T_4b0f6_level1_col0\" class=\"col_heading level1 col0\" >QUANTITY</th>\n",
       "      <th id=\"T_4b0f6_level1_col1\" class=\"col_heading level1 col1\" >COST</th>\n",
       "      <th id=\"T_4b0f6_level1_col2\" class=\"col_heading level1 col2\" >COST_BRL</th>\n",
       "      <th id=\"T_4b0f6_level1_col3\" class=\"col_heading level1 col3\" >QUANTITY</th>\n",
       "      <th id=\"T_4b0f6_level1_col4\" class=\"col_heading level1 col4\" >COST</th>\n",
       "      <th id=\"T_4b0f6_level1_col5\" class=\"col_heading level1 col5\" >COST_BRL</th>\n",
       "      <th id=\"T_4b0f6_level1_col6\" class=\"col_heading level1 col6\" ></th>\n",
       "      <th id=\"T_4b0f6_level1_col7\" class=\"col_heading level1 col7\" ></th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th class=\"index_name level0\" >SYMBOL</th>\n",
       "      <th class=\"blank col0\" >&nbsp;</th>\n",
       "      <th class=\"blank col1\" >&nbsp;</th>\n",
       "      <th class=\"blank col2\" >&nbsp;</th>\n",
       "      <th class=\"blank col3\" >&nbsp;</th>\n",
       "      <th class=\"blank col4\" >&nbsp;</th>\n",
       "      <th class=\"blank col5\" >&nbsp;</th>\n",
       "      <th class=\"blank col6\" >&nbsp;</th>\n",
       "      <th class=\"blank col7\" >&nbsp;</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_4b0f6_level0_row0\" class=\"row_heading level0 row0\" >CIEL3</th>\n",
       "      <td id=\"T_4b0f6_row0_col0\" class=\"data row0 col0\" >4551</td>\n",
       "      <td id=\"T_4b0f6_row0_col1\" class=\"data row0 col1\" >27285,48</td>\n",
       "      <td id=\"T_4b0f6_row0_col2\" class=\"data row0 col2\" >120449,34</td>\n",
       "      <td id=\"T_4b0f6_row0_col3\" class=\"data row0 col3\" >4551</td>\n",
       "      <td id=\"T_4b0f6_row0_col4\" class=\"data row0 col4\" >27285,48</td>\n",
       "      <td id=\"T_4b0f6_row0_col5\" class=\"data row0 col5\" >120449,34</td>\n",
       "      <td id=\"T_4b0f6_row0_col6\" class=\"data row0 col6\" >01.027.058/0001-91</td>\n",
       "      <td id=\"T_4b0f6_row0_col7\" class=\"data row0 col7\" >Corretora Clear - Ação - CIEL3 x 4551 = USD 27285.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b0f6_level0_row1\" class=\"row_heading level0 row1\" >COGN3</th>\n",
       "      <td id=\"T_4b0f6_row1_col0\" class=\"data row1 col0\" >1250</td>\n",
       "      <td id=\"T_4b0f6_row1_col1\" class=\"data row1 col1\" >8761,77</td>\n",
       "      <td id=\"T_4b0f6_row1_col2\" class=\"data row1 col2\" >37090,04</td>\n",
       "      <td id=\"T_4b0f6_row1_col3\" class=\"data row1 col3\" >1200</td>\n",
       "      <td id=\"T_4b0f6_row1_col4\" class=\"data row1 col4\" >8411,30</td>\n",
       "      <td id=\"T_4b0f6_row1_col5\" class=\"data row1 col5\" >35606,43</td>\n",
       "      <td id=\"T_4b0f6_row1_col6\" class=\"data row1 col6\" >-../-</td>\n",
       "      <td id=\"T_4b0f6_row1_col7\" class=\"data row1 col7\" >Corretora Clear - Ação - COGN3 x 1200 = USD 8411.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b0f6_level0_row2\" class=\"row_heading level0 row2\" >EGIE3</th>\n",
       "      <td id=\"T_4b0f6_row2_col0\" class=\"data row2 col0\" >100</td>\n",
       "      <td id=\"T_4b0f6_row2_col1\" class=\"data row2 col1\" >4151,32</td>\n",
       "      <td id=\"T_4b0f6_row2_col2\" class=\"data row2 col2\" >16565,85</td>\n",
       "      <td id=\"T_4b0f6_row2_col3\" class=\"data row2 col3\" >0</td>\n",
       "      <td id=\"T_4b0f6_row2_col4\" class=\"data row2 col4\" >0,00</td>\n",
       "      <td id=\"T_4b0f6_row2_col5\" class=\"data row2 col5\" >0,00</td>\n",
       "      <td id=\"T_4b0f6_row2_col6\" class=\"data row2 col6\" >-../-</td>\n",
       "      <td id=\"T_4b0f6_row2_col7\" class=\"data row2 col7\" >Corretora Clear - Ação - EGIE3 x 0 = USD 0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b0f6_level0_row3\" class=\"row_heading level0 row3\" >EZTC3</th>\n",
       "      <td id=\"T_4b0f6_row3_col0\" class=\"data row3 col0\" >600</td>\n",
       "      <td id=\"T_4b0f6_row3_col1\" class=\"data row3 col1\" >18155,46</td>\n",
       "      <td id=\"T_4b0f6_row3_col2\" class=\"data row3 col2\" >92632,52</td>\n",
       "      <td id=\"T_4b0f6_row3_col3\" class=\"data row3 col3\" >700</td>\n",
       "      <td id=\"T_4b0f6_row3_col4\" class=\"data row3 col4\" >19673,90</td>\n",
       "      <td id=\"T_4b0f6_row3_col5\" class=\"data row3 col5\" >100069,99</td>\n",
       "      <td id=\"T_4b0f6_row3_col6\" class=\"data row3 col6\" >08.312.229/0001-73</td>\n",
       "      <td id=\"T_4b0f6_row3_col7\" class=\"data row3 col7\" >Corretora Clear - Ação - EZTC3 x 700 = USD 19673.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b0f6_level0_row4\" class=\"row_heading level0 row4\" >MDIA3</th>\n",
       "      <td id=\"T_4b0f6_row4_col0\" class=\"data row4 col0\" >800</td>\n",
       "      <td id=\"T_4b0f6_row4_col1\" class=\"data row4 col1\" >27494,57</td>\n",
       "      <td id=\"T_4b0f6_row4_col2\" class=\"data row4 col2\" >122383,96</td>\n",
       "      <td id=\"T_4b0f6_row4_col3\" class=\"data row4 col3\" >0</td>\n",
       "      <td id=\"T_4b0f6_row4_col4\" class=\"data row4 col4\" >0,00</td>\n",
       "      <td id=\"T_4b0f6_row4_col5\" class=\"data row4 col5\" >0,00</td>\n",
       "      <td id=\"T_4b0f6_row4_col6\" class=\"data row4 col6\" >07.206.816/0001-15</td>\n",
       "      <td id=\"T_4b0f6_row4_col7\" class=\"data row4 col7\" >Corretora Clear - Ação - MDIA3 x 0 = USD 0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b0f6_level0_row5\" class=\"row_heading level0 row5\" >PSSA3</th>\n",
       "      <td id=\"T_4b0f6_row5_col0\" class=\"data row5 col0\" >740</td>\n",
       "      <td id=\"T_4b0f6_row5_col1\" class=\"data row5 col1\" >18149,74</td>\n",
       "      <td id=\"T_4b0f6_row5_col2\" class=\"data row5 col2\" >180320,65</td>\n",
       "      <td id=\"T_4b0f6_row5_col3\" class=\"data row5 col3\" >740</td>\n",
       "      <td id=\"T_4b0f6_row5_col4\" class=\"data row5 col4\" >18149,74</td>\n",
       "      <td id=\"T_4b0f6_row5_col5\" class=\"data row5 col5\" >180320,65</td>\n",
       "      <td id=\"T_4b0f6_row5_col6\" class=\"data row5 col6\" >02.149.205/0001-69</td>\n",
       "      <td id=\"T_4b0f6_row5_col7\" class=\"data row5 col7\" >Corretora Clear - Ação - PSSA3 x 740 = USD 18149.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b0f6_level0_row6\" class=\"row_heading level0 row6\" >SBFG3</th>\n",
       "      <td id=\"T_4b0f6_row6_col0\" class=\"data row6 col0\" >200</td>\n",
       "      <td id=\"T_4b0f6_row6_col1\" class=\"data row6 col1\" >4531,37</td>\n",
       "      <td id=\"T_4b0f6_row6_col2\" class=\"data row6 col2\" >25783,37</td>\n",
       "      <td id=\"T_4b0f6_row6_col3\" class=\"data row6 col3\" >0</td>\n",
       "      <td id=\"T_4b0f6_row6_col4\" class=\"data row6 col4\" >0,00</td>\n",
       "      <td id=\"T_4b0f6_row6_col5\" class=\"data row6 col5\" >0,00</td>\n",
       "      <td id=\"T_4b0f6_row6_col6\" class=\"data row6 col6\" >-../-</td>\n",
       "      <td id=\"T_4b0f6_row6_col7\" class=\"data row6 col7\" >Corretora Clear - Ação - SBFG3 x 0 = USD 0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b0f6_level0_row7\" class=\"row_heading level0 row7\" >TRIS3</th>\n",
       "      <td id=\"T_4b0f6_row7_col0\" class=\"data row7 col0\" >500</td>\n",
       "      <td id=\"T_4b0f6_row7_col1\" class=\"data row7 col1\" >5455,63</td>\n",
       "      <td id=\"T_4b0f6_row7_col2\" class=\"data row7 col2\" >29172,89</td>\n",
       "      <td id=\"T_4b0f6_row7_col3\" class=\"data row7 col3\" >0</td>\n",
       "      <td id=\"T_4b0f6_row7_col4\" class=\"data row7 col4\" >0,00</td>\n",
       "      <td id=\"T_4b0f6_row7_col5\" class=\"data row7 col5\" >0,00</td>\n",
       "      <td id=\"T_4b0f6_row7_col6\" class=\"data row7 col6\" >08.811.643/0001-27</td>\n",
       "      <td id=\"T_4b0f6_row7_col7\" class=\"data row7 col7\" >Corretora Clear - Ação - TRIS3 x 0 = USD 0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b0f6_level0_row8\" class=\"row_heading level0 row8\" >BBDC3</th>\n",
       "      <td id=\"T_4b0f6_row8_col0\" class=\"data row8 col0\" >220</td>\n",
       "      <td id=\"T_4b0f6_row8_col1\" class=\"data row8 col1\" >4419,33</td>\n",
       "      <td id=\"T_4b0f6_row8_col2\" class=\"data row8 col2\" >25860,49</td>\n",
       "      <td id=\"T_4b0f6_row8_col3\" class=\"data row8 col3\" >542</td>\n",
       "      <td id=\"T_4b0f6_row8_col4\" class=\"data row8 col4\" >8470,54</td>\n",
       "      <td id=\"T_4b0f6_row8_col5\" class=\"data row8 col5\" >49281,91</td>\n",
       "      <td id=\"T_4b0f6_row8_col6\" class=\"data row8 col6\" >60.746.948/0001-12</td>\n",
       "      <td id=\"T_4b0f6_row8_col7\" class=\"data row8 col7\" >Corretora Clear - Ação - BBDC3 x 542 = USD 8470.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b0f6_level0_row9\" class=\"row_heading level0 row9\" >CSUD3</th>\n",
       "      <td id=\"T_4b0f6_row9_col0\" class=\"data row9 col0\" >300</td>\n",
       "      <td id=\"T_4b0f6_row9_col1\" class=\"data row9 col1\" >4012,19</td>\n",
       "      <td id=\"T_4b0f6_row9_col2\" class=\"data row9 col2\" >22453,94</td>\n",
       "      <td id=\"T_4b0f6_row9_col3\" class=\"data row9 col3\" >300</td>\n",
       "      <td id=\"T_4b0f6_row9_col4\" class=\"data row9 col4\" >4012,19</td>\n",
       "      <td id=\"T_4b0f6_row9_col5\" class=\"data row9 col5\" >22453,94</td>\n",
       "      <td id=\"T_4b0f6_row9_col6\" class=\"data row9 col6\" >-../-</td>\n",
       "      <td id=\"T_4b0f6_row9_col7\" class=\"data row9 col7\" >Corretora Clear - Ação - CSUD3 x 300 = USD 4012.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b0f6_level0_row10\" class=\"row_heading level0 row10\" >GOLL4</th>\n",
       "      <td id=\"T_4b0f6_row10_col0\" class=\"data row10 col0\" >574</td>\n",
       "      <td id=\"T_4b0f6_row10_col1\" class=\"data row10 col1\" >21727,37</td>\n",
       "      <td id=\"T_4b0f6_row10_col2\" class=\"data row10 col2\" >107704,73</td>\n",
       "      <td id=\"T_4b0f6_row10_col3\" class=\"data row10 col3\" >500</td>\n",
       "      <td id=\"T_4b0f6_row10_col4\" class=\"data row10 col4\" >18926,28</td>\n",
       "      <td id=\"T_4b0f6_row10_col5\" class=\"data row10 col5\" >93819,45</td>\n",
       "      <td id=\"T_4b0f6_row10_col6\" class=\"data row10 col6\" >06.164.253/0001-87</td>\n",
       "      <td id=\"T_4b0f6_row10_col7\" class=\"data row10 col7\" >Corretora Clear - Ação - GOLL4 x 500 = USD 18926.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b0f6_level0_row11\" class=\"row_heading level0 row11\" >LCAM3</th>\n",
       "      <td id=\"T_4b0f6_row11_col0\" class=\"data row11 col0\" >600</td>\n",
       "      <td id=\"T_4b0f6_row11_col1\" class=\"data row11 col1\" >13925,14</td>\n",
       "      <td id=\"T_4b0f6_row11_col2\" class=\"data row11 col2\" >75080,12</td>\n",
       "      <td id=\"T_4b0f6_row11_col3\" class=\"data row11 col3\" >0</td>\n",
       "      <td id=\"T_4b0f6_row11_col4\" class=\"data row11 col4\" >0,00</td>\n",
       "      <td id=\"T_4b0f6_row11_col5\" class=\"data row11 col5\" >0,00</td>\n",
       "      <td id=\"T_4b0f6_row11_col6\" class=\"data row11 col6\" >10.215.988/0001-60</td>\n",
       "      <td id=\"T_4b0f6_row11_col7\" class=\"data row11 col7\" >Corretora Clear - Ação - LCAM3 x 0 = USD 0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b0f6_level0_row12\" class=\"row_heading level0 row12\" >MOVI3</th>\n",
       "      <td id=\"T_4b0f6_row12_col0\" class=\"data row12 col0\" >100</td>\n",
       "      <td id=\"T_4b0f6_row12_col1\" class=\"data row12 col1\" >1755,52</td>\n",
       "      <td id=\"T_4b0f6_row12_col2\" class=\"data row12 col2\" >9528,27</td>\n",
       "      <td id=\"T_4b0f6_row12_col3\" class=\"data row12 col3\" >1600</td>\n",
       "      <td id=\"T_4b0f6_row12_col4\" class=\"data row12 col4\" >20260,04</td>\n",
       "      <td id=\"T_4b0f6_row12_col5\" class=\"data row12 col5\" >105224,37</td>\n",
       "      <td id=\"T_4b0f6_row12_col6\" class=\"data row12 col6\" >-../-</td>\n",
       "      <td id=\"T_4b0f6_row12_col7\" class=\"data row12 col7\" >Corretora Clear - Ação - MOVI3 x 1600 = USD 20260.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b0f6_level0_row13\" class=\"row_heading level0 row13\" >MRVE3</th>\n",
       "      <td id=\"T_4b0f6_row13_col0\" class=\"data row13 col0\" >300</td>\n",
       "      <td id=\"T_4b0f6_row13_col1\" class=\"data row13 col1\" >3814,13</td>\n",
       "      <td id=\"T_4b0f6_row13_col2\" class=\"data row13 col2\" >20347,14</td>\n",
       "      <td id=\"T_4b0f6_row13_col3\" class=\"data row13 col3\" >0</td>\n",
       "      <td id=\"T_4b0f6_row13_col4\" class=\"data row13 col4\" >0,00</td>\n",
       "      <td id=\"T_4b0f6_row13_col5\" class=\"data row13 col5\" >0,00</td>\n",
       "      <td id=\"T_4b0f6_row13_col6\" class=\"data row13 col6\" >08.343.492/0001-20</td>\n",
       "      <td id=\"T_4b0f6_row13_col7\" class=\"data row13 col7\" >Corretora Clear - Ação - MRVE3 x 0 = USD 0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b0f6_level0_row14\" class=\"row_heading level0 row14\" >OIBR3</th>\n",
       "      <td id=\"T_4b0f6_row14_col0\" class=\"data row14 col0\" >2400</td>\n",
       "      <td id=\"T_4b0f6_row14_col1\" class=\"data row14 col1\" >2899,81</td>\n",
       "      <td id=\"T_4b0f6_row14_col2\" class=\"data row14 col2\" >15637,25</td>\n",
       "      <td id=\"T_4b0f6_row14_col3\" class=\"data row14 col3\" >2800</td>\n",
       "      <td id=\"T_4b0f6_row14_col4\" class=\"data row14 col4\" >3059,86</td>\n",
       "      <td id=\"T_4b0f6_row14_col5\" class=\"data row14 col5\" >16478,91</td>\n",
       "      <td id=\"T_4b0f6_row14_col6\" class=\"data row14 col6\" >76.535.764/0001-43</td>\n",
       "      <td id=\"T_4b0f6_row14_col7\" class=\"data row14 col7\" >Corretora Clear - Ação - OIBR3 x 2800 = USD 3059.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b0f6_level0_row15\" class=\"row_heading level0 row15\" >PARD3</th>\n",
       "      <td id=\"T_4b0f6_row15_col0\" class=\"data row15 col0\" >400</td>\n",
       "      <td id=\"T_4b0f6_row15_col1\" class=\"data row15 col1\" >7662,29</td>\n",
       "      <td id=\"T_4b0f6_row15_col2\" class=\"data row15 col2\" >42217,83</td>\n",
       "      <td id=\"T_4b0f6_row15_col3\" class=\"data row15 col3\" >0</td>\n",
       "      <td id=\"T_4b0f6_row15_col4\" class=\"data row15 col4\" >0,00</td>\n",
       "      <td id=\"T_4b0f6_row15_col5\" class=\"data row15 col5\" >0,00</td>\n",
       "      <td id=\"T_4b0f6_row15_col6\" class=\"data row15 col6\" >-../-</td>\n",
       "      <td id=\"T_4b0f6_row15_col7\" class=\"data row15 col7\" >Corretora Clear - Ação - PARD3 x 0 = USD 0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b0f6_level0_row16\" class=\"row_heading level0 row16\" >PRIO3</th>\n",
       "      <td id=\"T_4b0f6_row16_col0\" class=\"data row16 col0\" >100</td>\n",
       "      <td id=\"T_4b0f6_row16_col1\" class=\"data row16 col1\" >1730,51</td>\n",
       "      <td id=\"T_4b0f6_row16_col2\" class=\"data row16 col2\" >8954,70</td>\n",
       "      <td id=\"T_4b0f6_row16_col3\" class=\"data row16 col3\" >0</td>\n",
       "      <td id=\"T_4b0f6_row16_col4\" class=\"data row16 col4\" >0,00</td>\n",
       "      <td id=\"T_4b0f6_row16_col5\" class=\"data row16 col5\" >0,00</td>\n",
       "      <td id=\"T_4b0f6_row16_col6\" class=\"data row16 col6\" >-../-</td>\n",
       "      <td id=\"T_4b0f6_row16_col7\" class=\"data row16 col7\" >Corretora Clear - Ação - PRIO3 x 0 = USD 0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b0f6_level0_row17\" class=\"row_heading level0 row17\" >TASA4</th>\n",
       "      <td id=\"T_4b0f6_row17_col0\" class=\"data row17 col0\" >300</td>\n",
       "      <td id=\"T_4b0f6_row17_col1\" class=\"data row17 col1\" >6139,84</td>\n",
       "      <td id=\"T_4b0f6_row17_col2\" class=\"data row17 col2\" >33945,32</td>\n",
       "      <td id=\"T_4b0f6_row17_col3\" class=\"data row17 col3\" >900</td>\n",
       "      <td id=\"T_4b0f6_row17_col4\" class=\"data row17 col4\" >16283,87</td>\n",
       "      <td id=\"T_4b0f6_row17_col5\" class=\"data row17 col5\" >85879,81</td>\n",
       "      <td id=\"T_4b0f6_row17_col6\" class=\"data row17 col6\" >-../-</td>\n",
       "      <td id=\"T_4b0f6_row17_col7\" class=\"data row17 col7\" >Corretora Clear - Ação - TASA4 x 900 = USD 16283.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b0f6_level0_row18\" class=\"row_heading level0 row18\" >XPBR31</th>\n",
       "      <td id=\"T_4b0f6_row18_col0\" class=\"data row18 col0\" >12,3088</td>\n",
       "      <td id=\"T_4b0f6_row18_col1\" class=\"data row18 col1\" >2090,58</td>\n",
       "      <td id=\"T_4b0f6_row18_col2\" class=\"data row18 col2\" >11809,93</td>\n",
       "      <td id=\"T_4b0f6_row18_col3\" class=\"data row18 col3\" >0,308785</td>\n",
       "      <td id=\"T_4b0f6_row18_col4\" class=\"data row18 col4\" >52,45</td>\n",
       "      <td id=\"T_4b0f6_row18_col5\" class=\"data row18 col5\" >296,27</td>\n",
       "      <td id=\"T_4b0f6_row18_col6\" class=\"data row18 col6\" >-../-</td>\n",
       "      <td id=\"T_4b0f6_row18_col7\" class=\"data row18 col7\" >Corretora Clear - Ação - XPBR31 x 0 = USD 52.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b0f6_level0_row19\" class=\"row_heading level0 row19\" >BPAC11</th>\n",
       "      <td id=\"T_4b0f6_row19_col0\" class=\"data row19 col0\" >0</td>\n",
       "      <td id=\"T_4b0f6_row19_col1\" class=\"data row19 col1\" >0,00</td>\n",
       "      <td id=\"T_4b0f6_row19_col2\" class=\"data row19 col2\" >0,00</td>\n",
       "      <td id=\"T_4b0f6_row19_col3\" class=\"data row19 col3\" >200</td>\n",
       "      <td id=\"T_4b0f6_row19_col4\" class=\"data row19 col4\" >4646,38</td>\n",
       "      <td id=\"T_4b0f6_row19_col5\" class=\"data row19 col5\" >23430,82</td>\n",
       "      <td id=\"T_4b0f6_row19_col6\" class=\"data row19 col6\" >30.306.294/0001-45</td>\n",
       "      <td id=\"T_4b0f6_row19_col7\" class=\"data row19 col7\" >Corretora Clear - Ação - BPAC11 x 200 = USD 4646.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b0f6_level0_row20\" class=\"row_heading level0 row20\" >BPAC3</th>\n",
       "      <td id=\"T_4b0f6_row20_col0\" class=\"data row20 col0\" >0</td>\n",
       "      <td id=\"T_4b0f6_row20_col1\" class=\"data row20 col1\" >0,00</td>\n",
       "      <td id=\"T_4b0f6_row20_col2\" class=\"data row20 col2\" >0,00</td>\n",
       "      <td id=\"T_4b0f6_row20_col3\" class=\"data row20 col3\" >100</td>\n",
       "      <td id=\"T_4b0f6_row20_col4\" class=\"data row20 col4\" >1366,00</td>\n",
       "      <td id=\"T_4b0f6_row20_col5\" class=\"data row20 col5\" >6745,03</td>\n",
       "      <td id=\"T_4b0f6_row20_col6\" class=\"data row20 col6\" >30.306.294/0001-45</td>\n",
       "      <td id=\"T_4b0f6_row20_col7\" class=\"data row20 col7\" >Corretora Clear - Ação - BPAC3 x 100 = USD 1366.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_4b0f6_level0_row21\" class=\"row_heading level0 row21\" >RENT3</th>\n",
       "      <td id=\"T_4b0f6_row21_col0\" class=\"data row21 col0\" >0</td>\n",
       "      <td id=\"T_4b0f6_row21_col1\" class=\"data row21 col1\" >0,00</td>\n",
       "      <td id=\"T_4b0f6_row21_col2\" class=\"data row21 col2\" >0,00</td>\n",
       "      <td id=\"T_4b0f6_row21_col3\" class=\"data row21 col3\" >0,19112</td>\n",
       "      <td id=\"T_4b0f6_row21_col4\" class=\"data row21 col4\" >10,14</td>\n",
       "      <td id=\"T_4b0f6_row21_col5\" class=\"data row21 col5\" >54,07</td>\n",
       "      <td id=\"T_4b0f6_row21_col6\" class=\"data row21 col6\" >16.670.085/0001-55</td>\n",
       "      <td id=\"T_4b0f6_row21_col7\" class=\"data row21 col7\" >Corretora Clear - Ação - RENT3 x 0 = USD 10.14</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7f4a7c6c7670>"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ac = irpf.get_last_year()\n",
    "ac = ac[ac['DESC'].str.contains('Ação')]\n",
    "irpf.show(ac)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "</style>\n",
       "<table id=\"T_27742\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th id=\"T_27742_level0_col0\" class=\"col_heading level0 col0\" colspan=\"3\">2021-12-31</th>\n",
       "      <th id=\"T_27742_level0_col3\" class=\"col_heading level0 col3\" colspan=\"3\">2022-12-31</th>\n",
       "      <th id=\"T_27742_level0_col6\" class=\"col_heading level0 col6\" >CNPJ</th>\n",
       "      <th id=\"T_27742_level0_col7\" class=\"col_heading level0 col7\" >DESC</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th class=\"blank level1\" >&nbsp;</th>\n",
       "      <th id=\"T_27742_level1_col0\" class=\"col_heading level1 col0\" >QUANTITY</th>\n",
       "      <th id=\"T_27742_level1_col1\" class=\"col_heading level1 col1\" >COST</th>\n",
       "      <th id=\"T_27742_level1_col2\" class=\"col_heading level1 col2\" >COST_BRL</th>\n",
       "      <th id=\"T_27742_level1_col3\" class=\"col_heading level1 col3\" >QUANTITY</th>\n",
       "      <th id=\"T_27742_level1_col4\" class=\"col_heading level1 col4\" >COST</th>\n",
       "      <th id=\"T_27742_level1_col5\" class=\"col_heading level1 col5\" >COST_BRL</th>\n",
       "      <th id=\"T_27742_level1_col6\" class=\"col_heading level1 col6\" ></th>\n",
       "      <th id=\"T_27742_level1_col7\" class=\"col_heading level1 col7\" ></th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th class=\"index_name level0\" >SYMBOL</th>\n",
       "      <th class=\"blank col0\" >&nbsp;</th>\n",
       "      <th class=\"blank col1\" >&nbsp;</th>\n",
       "      <th class=\"blank col2\" >&nbsp;</th>\n",
       "      <th class=\"blank col3\" >&nbsp;</th>\n",
       "      <th class=\"blank col4\" >&nbsp;</th>\n",
       "      <th class=\"blank col5\" >&nbsp;</th>\n",
       "      <th class=\"blank col6\" >&nbsp;</th>\n",
       "      <th class=\"blank col7\" >&nbsp;</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_27742_level0_row0\" class=\"row_heading level0 row0\" >FAMB11B</th>\n",
       "      <td id=\"T_27742_row0_col0\" class=\"data row0 col0\" >6</td>\n",
       "      <td id=\"T_27742_row0_col1\" class=\"data row0 col1\" >8552,87</td>\n",
       "      <td id=\"T_27742_row0_col2\" class=\"data row0 col2\" >46770,80</td>\n",
       "      <td id=\"T_27742_row0_col3\" class=\"data row0 col3\" >6</td>\n",
       "      <td id=\"T_27742_row0_col4\" class=\"data row0 col4\" >8552,87</td>\n",
       "      <td id=\"T_27742_row0_col5\" class=\"data row0 col5\" >46770,80</td>\n",
       "      <td id=\"T_27742_row0_col6\" class=\"data row0 col6\" >05.562.312/0001-02</td>\n",
       "      <td id=\"T_27742_row0_col7\" class=\"data row0 col7\" >Corretora Clear - FII - FAMB11B x 6 = USD 8552.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_27742_level0_row1\" class=\"row_heading level0 row1\" >VISC11</th>\n",
       "      <td id=\"T_27742_row1_col0\" class=\"data row1 col0\" >59</td>\n",
       "      <td id=\"T_27742_row1_col1\" class=\"data row1 col1\" >5795,30</td>\n",
       "      <td id=\"T_27742_row1_col2\" class=\"data row1 col2\" >22869,34</td>\n",
       "      <td id=\"T_27742_row1_col3\" class=\"data row1 col3\" >0</td>\n",
       "      <td id=\"T_27742_row1_col4\" class=\"data row1 col4\" >0,00</td>\n",
       "      <td id=\"T_27742_row1_col5\" class=\"data row1 col5\" >0,00</td>\n",
       "      <td id=\"T_27742_row1_col6\" class=\"data row1 col6\" >17.554.274/0001-25</td>\n",
       "      <td id=\"T_27742_row1_col7\" class=\"data row1 col7\" >Corretora Clear - FII - VISC11 x 0 = USD 0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_27742_level0_row2\" class=\"row_heading level0 row2\" >GTWR11</th>\n",
       "      <td id=\"T_27742_row2_col0\" class=\"data row2 col0\" >12</td>\n",
       "      <td id=\"T_27742_row2_col1\" class=\"data row2 col1\" >1303,97</td>\n",
       "      <td id=\"T_27742_row2_col2\" class=\"data row2 col2\" >5352,17</td>\n",
       "      <td id=\"T_27742_row2_col3\" class=\"data row2 col3\" >12</td>\n",
       "      <td id=\"T_27742_row2_col4\" class=\"data row2 col4\" >1303,97</td>\n",
       "      <td id=\"T_27742_row2_col5\" class=\"data row2 col5\" >5352,17</td>\n",
       "      <td id=\"T_27742_row2_col6\" class=\"data row2 col6\" >23.740.527/0001-58</td>\n",
       "      <td id=\"T_27742_row2_col7\" class=\"data row2 col7\" >Corretora Clear - FII - GTWR11 x 12 = USD 1303.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_27742_level0_row3\" class=\"row_heading level0 row3\" >HTMX11</th>\n",
       "      <td id=\"T_27742_row3_col0\" class=\"data row3 col0\" >43</td>\n",
       "      <td id=\"T_27742_row3_col1\" class=\"data row3 col1\" >6811,52</td>\n",
       "      <td id=\"T_27742_row3_col2\" class=\"data row3 col2\" >29472,30</td>\n",
       "      <td id=\"T_27742_row3_col3\" class=\"data row3 col3\" >0</td>\n",
       "      <td id=\"T_27742_row3_col4\" class=\"data row3 col4\" >0,00</td>\n",
       "      <td id=\"T_27742_row3_col5\" class=\"data row3 col5\" >0,00</td>\n",
       "      <td id=\"T_27742_row3_col6\" class=\"data row3 col6\" >08.706.065/0001-69</td>\n",
       "      <td id=\"T_27742_row3_col7\" class=\"data row3 col7\" >Corretora Clear - FII - HTMX11 x 0 = USD 0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_27742_level0_row4\" class=\"row_heading level0 row4\" >XPCM11</th>\n",
       "      <td id=\"T_27742_row4_col0\" class=\"data row4 col0\" >169</td>\n",
       "      <td id=\"T_27742_row4_col1\" class=\"data row4 col1\" >9540,37</td>\n",
       "      <td id=\"T_27742_row4_col2\" class=\"data row4 col2\" >37775,24</td>\n",
       "      <td id=\"T_27742_row4_col3\" class=\"data row4 col3\" >169</td>\n",
       "      <td id=\"T_27742_row4_col4\" class=\"data row4 col4\" >9540,37</td>\n",
       "      <td id=\"T_27742_row4_col5\" class=\"data row4 col5\" >37775,24</td>\n",
       "      <td id=\"T_27742_row4_col6\" class=\"data row4 col6\" >16.802.320/0001-03</td>\n",
       "      <td id=\"T_27742_row4_col7\" class=\"data row4 col7\" >Corretora Clear - FII - XPCM11 x 169 = USD 9540.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_27742_level0_row5\" class=\"row_heading level0 row5\" >XPLG11</th>\n",
       "      <td id=\"T_27742_row5_col0\" class=\"data row5 col0\" >40</td>\n",
       "      <td id=\"T_27742_row5_col1\" class=\"data row5 col1\" >4147,51</td>\n",
       "      <td id=\"T_27742_row5_col2\" class=\"data row5 col2\" >16549,77</td>\n",
       "      <td id=\"T_27742_row5_col3\" class=\"data row5 col3\" >0</td>\n",
       "      <td id=\"T_27742_row5_col4\" class=\"data row5 col4\" >0,00</td>\n",
       "      <td id=\"T_27742_row5_col5\" class=\"data row5 col5\" >0,00</td>\n",
       "      <td id=\"T_27742_row5_col6\" class=\"data row5 col6\" >26.502.794/0001-85</td>\n",
       "      <td id=\"T_27742_row5_col7\" class=\"data row5 col7\" >Corretora Clear - FII - XPLG11 x 0 = USD 0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_27742_level0_row6\" class=\"row_heading level0 row6\" >XPML11</th>\n",
       "      <td id=\"T_27742_row6_col0\" class=\"data row6 col0\" >51</td>\n",
       "      <td id=\"T_27742_row6_col1\" class=\"data row6 col1\" >5608,53</td>\n",
       "      <td id=\"T_27742_row6_col2\" class=\"data row6 col2\" >22411,32</td>\n",
       "      <td id=\"T_27742_row6_col3\" class=\"data row6 col3\" >43</td>\n",
       "      <td id=\"T_27742_row6_col4\" class=\"data row6 col4\" >4728,76</td>\n",
       "      <td id=\"T_27742_row6_col5\" class=\"data row6 col5\" >18895,82</td>\n",
       "      <td id=\"T_27742_row6_col6\" class=\"data row6 col6\" >28.757.546/0001-00</td>\n",
       "      <td id=\"T_27742_row6_col7\" class=\"data row6 col7\" >Corretora Clear - FII - XPML11 x 43 = USD 4728.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_27742_level0_row7\" class=\"row_heading level0 row7\" >DEVA11</th>\n",
       "      <td id=\"T_27742_row7_col0\" class=\"data row7 col0\" >30</td>\n",
       "      <td id=\"T_27742_row7_col1\" class=\"data row7 col1\" >3155,79</td>\n",
       "      <td id=\"T_27742_row7_col2\" class=\"data row7 col2\" >16966,53</td>\n",
       "      <td id=\"T_27742_row7_col3\" class=\"data row7 col3\" >31</td>\n",
       "      <td id=\"T_27742_row7_col4\" class=\"data row7 col4\" >3257,36</td>\n",
       "      <td id=\"T_27742_row7_col5\" class=\"data row7 col5\" >17501,05</td>\n",
       "      <td id=\"T_27742_row7_col6\" class=\"data row7 col6\" >37.087.810/0001-37</td>\n",
       "      <td id=\"T_27742_row7_col7\" class=\"data row7 col7\" >Corretora Clear - FII - DEVA11 x 31 = USD 3257.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_27742_level0_row8\" class=\"row_heading level0 row8\" >HGRE11</th>\n",
       "      <td id=\"T_27742_row8_col0\" class=\"data row8 col0\" >29</td>\n",
       "      <td id=\"T_27742_row8_col1\" class=\"data row8 col1\" >3655,70</td>\n",
       "      <td id=\"T_27742_row8_col2\" class=\"data row8 col2\" >19697,55</td>\n",
       "      <td id=\"T_27742_row8_col3\" class=\"data row8 col3\" >29</td>\n",
       "      <td id=\"T_27742_row8_col4\" class=\"data row8 col4\" >3655,70</td>\n",
       "      <td id=\"T_27742_row8_col5\" class=\"data row8 col5\" >19697,55</td>\n",
       "      <td id=\"T_27742_row8_col6\" class=\"data row8 col6\" >09.072.017/0001-29</td>\n",
       "      <td id=\"T_27742_row8_col7\" class=\"data row8 col7\" >Corretora Clear - FII - HGRE11 x 29 = USD 3655.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_27742_level0_row9\" class=\"row_heading level0 row9\" >HGRU11</th>\n",
       "      <td id=\"T_27742_row9_col0\" class=\"data row9 col0\" >20</td>\n",
       "      <td id=\"T_27742_row9_col1\" class=\"data row9 col1\" >2395,61</td>\n",
       "      <td id=\"T_27742_row9_col2\" class=\"data row9 col2\" >12649,57</td>\n",
       "      <td id=\"T_27742_row9_col3\" class=\"data row9 col3\" >20</td>\n",
       "      <td id=\"T_27742_row9_col4\" class=\"data row9 col4\" >2395,61</td>\n",
       "      <td id=\"T_27742_row9_col5\" class=\"data row9 col5\" >12649,57</td>\n",
       "      <td id=\"T_27742_row9_col6\" class=\"data row9 col6\" >29.641.226/0001-53</td>\n",
       "      <td id=\"T_27742_row9_col7\" class=\"data row9 col7\" >Corretora Clear - FII - HGRU11 x 20 = USD 2395.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_27742_level0_row10\" class=\"row_heading level0 row10\" >HSLG11</th>\n",
       "      <td id=\"T_27742_row10_col0\" class=\"data row10 col0\" >30</td>\n",
       "      <td id=\"T_27742_row10_col1\" class=\"data row10 col1\" >3076,54</td>\n",
       "      <td id=\"T_27742_row10_col2\" class=\"data row10 col2\" >15614,94</td>\n",
       "      <td id=\"T_27742_row10_col3\" class=\"data row10 col3\" >30</td>\n",
       "      <td id=\"T_27742_row10_col4\" class=\"data row10 col4\" >3076,54</td>\n",
       "      <td id=\"T_27742_row10_col5\" class=\"data row10 col5\" >15614,94</td>\n",
       "      <td id=\"T_27742_row10_col6\" class=\"data row10 col6\" >32.903.621/0001-71</td>\n",
       "      <td id=\"T_27742_row10_col7\" class=\"data row10 col7\" >Corretora Clear - FII - HSLG11 x 30 = USD 3076.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_27742_level0_row11\" class=\"row_heading level0 row11\" >HSML11</th>\n",
       "      <td id=\"T_27742_row11_col0\" class=\"data row11 col0\" >43</td>\n",
       "      <td id=\"T_27742_row11_col1\" class=\"data row11 col1\" >3594,24</td>\n",
       "      <td id=\"T_27742_row11_col2\" class=\"data row11 col2\" >18780,70</td>\n",
       "      <td id=\"T_27742_row11_col3\" class=\"data row11 col3\" >43</td>\n",
       "      <td id=\"T_27742_row11_col4\" class=\"data row11 col4\" >3594,24</td>\n",
       "      <td id=\"T_27742_row11_col5\" class=\"data row11 col5\" >18780,70</td>\n",
       "      <td id=\"T_27742_row11_col6\" class=\"data row11 col6\" >32.892.018/0001-31</td>\n",
       "      <td id=\"T_27742_row11_col7\" class=\"data row11 col7\" >Corretora Clear - FII - HSML11 x 43 = USD 3594.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_27742_level0_row12\" class=\"row_heading level0 row12\" >KNSC11</th>\n",
       "      <td id=\"T_27742_row12_col0\" class=\"data row12 col0\" >15</td>\n",
       "      <td id=\"T_27742_row12_col1\" class=\"data row12 col1\" >1525,48</td>\n",
       "      <td id=\"T_27742_row12_col2\" class=\"data row12 col2\" >8005,63</td>\n",
       "      <td id=\"T_27742_row12_col3\" class=\"data row12 col3\" >25</td>\n",
       "      <td id=\"T_27742_row12_col4\" class=\"data row12 col4\" >2455,63</td>\n",
       "      <td id=\"T_27742_row12_col5\" class=\"data row12 col5\" >12735,20</td>\n",
       "      <td id=\"T_27742_row12_col6\" class=\"data row12 col6\" >35.864.448/0001-38</td>\n",
       "      <td id=\"T_27742_row12_col7\" class=\"data row12 col7\" >Corretora Clear - FII - KNSC11 x 25 = USD 2455.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_27742_level0_row13\" class=\"row_heading level0 row13\" >RBRF11</th>\n",
       "      <td id=\"T_27742_row13_col0\" class=\"data row13 col0\" >72</td>\n",
       "      <td id=\"T_27742_row13_col1\" class=\"data row13 col1\" >6016,74</td>\n",
       "      <td id=\"T_27742_row13_col2\" class=\"data row13 col2\" >30892,32</td>\n",
       "      <td id=\"T_27742_row13_col3\" class=\"data row13 col3\" >82</td>\n",
       "      <td id=\"T_27742_row13_col4\" class=\"data row13 col4\" >6707,64</td>\n",
       "      <td id=\"T_27742_row13_col5\" class=\"data row13 col5\" >34437,54</td>\n",
       "      <td id=\"T_27742_row13_col6\" class=\"data row13 col6\" >27.529.279/0001-51</td>\n",
       "      <td id=\"T_27742_row13_col7\" class=\"data row13 col7\" >Corretora Clear - FII - RBRF11 x 82 = USD 6707.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_27742_level0_row14\" class=\"row_heading level0 row14\" >RBRY11</th>\n",
       "      <td id=\"T_27742_row14_col0\" class=\"data row14 col0\" >40</td>\n",
       "      <td id=\"T_27742_row14_col1\" class=\"data row14 col1\" >4008,81</td>\n",
       "      <td id=\"T_27742_row14_col2\" class=\"data row14 col2\" >20565,86</td>\n",
       "      <td id=\"T_27742_row14_col3\" class=\"data row14 col3\" >68</td>\n",
       "      <td id=\"T_27742_row14_col4\" class=\"data row14 col4\" >6926,84</td>\n",
       "      <td id=\"T_27742_row14_col5\" class=\"data row14 col5\" >35301,07</td>\n",
       "      <td id=\"T_27742_row14_col6\" class=\"data row14 col6\" >30.166.700/0001-11</td>\n",
       "      <td id=\"T_27742_row14_col7\" class=\"data row14 col7\" >Corretora Clear - FII - RBRY11 x 68 = USD 6926.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_27742_level0_row15\" class=\"row_heading level0 row15\" >RVBI11</th>\n",
       "      <td id=\"T_27742_row15_col0\" class=\"data row15 col0\" >8</td>\n",
       "      <td id=\"T_27742_row15_col1\" class=\"data row15 col1\" >722,70</td>\n",
       "      <td id=\"T_27742_row15_col2\" class=\"data row15 col2\" >3550,39</td>\n",
       "      <td id=\"T_27742_row15_col3\" class=\"data row15 col3\" >20</td>\n",
       "      <td id=\"T_27742_row15_col4\" class=\"data row15 col4\" >1676,98</td>\n",
       "      <td id=\"T_27742_row15_col5\" class=\"data row15 col5\" >8402,63</td>\n",
       "      <td id=\"T_27742_row15_col6\" class=\"data row15 col6\" >35.507.457/0001-71</td>\n",
       "      <td id=\"T_27742_row15_col7\" class=\"data row15 col7\" >Corretora Clear - FII - RVBI11 x 20 = USD 1676.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_27742_level0_row16\" class=\"row_heading level0 row16\" >VILG11</th>\n",
       "      <td id=\"T_27742_row16_col0\" class=\"data row16 col0\" >65</td>\n",
       "      <td id=\"T_27742_row16_col1\" class=\"data row16 col1\" >7213,65</td>\n",
       "      <td id=\"T_27742_row16_col2\" class=\"data row16 col2\" >37412,14</td>\n",
       "      <td id=\"T_27742_row16_col3\" class=\"data row16 col3\" >65</td>\n",
       "      <td id=\"T_27742_row16_col4\" class=\"data row16 col4\" >7213,65</td>\n",
       "      <td id=\"T_27742_row16_col5\" class=\"data row16 col5\" >37412,14</td>\n",
       "      <td id=\"T_27742_row16_col6\" class=\"data row16 col6\" >24.853.044/0001-22</td>\n",
       "      <td id=\"T_27742_row16_col7\" class=\"data row16 col7\" >Corretora Clear - FII - VILG11 x 65 = USD 7213.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_27742_level0_row17\" class=\"row_heading level0 row17\" >VRTA11</th>\n",
       "      <td id=\"T_27742_row17_col0\" class=\"data row17 col0\" >53</td>\n",
       "      <td id=\"T_27742_row17_col1\" class=\"data row17 col1\" >5482,37</td>\n",
       "      <td id=\"T_27742_row17_col2\" class=\"data row17 col2\" >28887,11</td>\n",
       "      <td id=\"T_27742_row17_col3\" class=\"data row17 col3\" >100</td>\n",
       "      <td id=\"T_27742_row17_col4\" class=\"data row17 col4\" >10196,47</td>\n",
       "      <td id=\"T_27742_row17_col5\" class=\"data row17 col5\" >53269,55</td>\n",
       "      <td id=\"T_27742_row17_col6\" class=\"data row17 col6\" >11.664.201/0001-00</td>\n",
       "      <td id=\"T_27742_row17_col7\" class=\"data row17 col7\" >Corretora Clear - FII - VRTA11 x 100 = USD 10196.47</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7f4a3f1c4670>"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fii = irpf.get_last_year()\n",
    "fii = fii[fii['DESC'].str.contains('FII')]\n",
    "irpf.show(fii)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "</style>\n",
       "<table id=\"T_39429\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th id=\"T_39429_level0_col0\" class=\"col_heading level0 col0\" colspan=\"3\">2021-12-31</th>\n",
       "      <th id=\"T_39429_level0_col3\" class=\"col_heading level0 col3\" colspan=\"3\">2022-12-31</th>\n",
       "      <th id=\"T_39429_level0_col6\" class=\"col_heading level0 col6\" >CNPJ</th>\n",
       "      <th id=\"T_39429_level0_col7\" class=\"col_heading level0 col7\" >DESC</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th class=\"blank level1\" >&nbsp;</th>\n",
       "      <th id=\"T_39429_level1_col0\" class=\"col_heading level1 col0\" >QUANTITY</th>\n",
       "      <th id=\"T_39429_level1_col1\" class=\"col_heading level1 col1\" >COST</th>\n",
       "      <th id=\"T_39429_level1_col2\" class=\"col_heading level1 col2\" >COST_BRL</th>\n",
       "      <th id=\"T_39429_level1_col3\" class=\"col_heading level1 col3\" >QUANTITY</th>\n",
       "      <th id=\"T_39429_level1_col4\" class=\"col_heading level1 col4\" >COST</th>\n",
       "      <th id=\"T_39429_level1_col5\" class=\"col_heading level1 col5\" >COST_BRL</th>\n",
       "      <th id=\"T_39429_level1_col6\" class=\"col_heading level1 col6\" ></th>\n",
       "      <th id=\"T_39429_level1_col7\" class=\"col_heading level1 col7\" ></th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th class=\"index_name level0\" >SYMBOL</th>\n",
       "      <th class=\"blank col0\" >&nbsp;</th>\n",
       "      <th class=\"blank col1\" >&nbsp;</th>\n",
       "      <th class=\"blank col2\" >&nbsp;</th>\n",
       "      <th class=\"blank col3\" >&nbsp;</th>\n",
       "      <th class=\"blank col4\" >&nbsp;</th>\n",
       "      <th class=\"blank col5\" >&nbsp;</th>\n",
       "      <th class=\"blank col6\" >&nbsp;</th>\n",
       "      <th class=\"blank col7\" >&nbsp;</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row0\" class=\"row_heading level0 row0\" >CIEL3</th>\n",
       "      <td id=\"T_39429_row0_col0\" class=\"data row0 col0\" >4551</td>\n",
       "      <td id=\"T_39429_row0_col1\" class=\"data row0 col1\" >27285,48</td>\n",
       "      <td id=\"T_39429_row0_col2\" class=\"data row0 col2\" >120449,34</td>\n",
       "      <td id=\"T_39429_row0_col3\" class=\"data row0 col3\" >4551</td>\n",
       "      <td id=\"T_39429_row0_col4\" class=\"data row0 col4\" >27285,48</td>\n",
       "      <td id=\"T_39429_row0_col5\" class=\"data row0 col5\" >120449,34</td>\n",
       "      <td id=\"T_39429_row0_col6\" class=\"data row0 col6\" >01.027.058/0001-91</td>\n",
       "      <td id=\"T_39429_row0_col7\" class=\"data row0 col7\" >Corretora Clear - Ação - CIEL3 x 4551 = USD 27285.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row1\" class=\"row_heading level0 row1\" >COGN3</th>\n",
       "      <td id=\"T_39429_row1_col0\" class=\"data row1 col0\" >1250</td>\n",
       "      <td id=\"T_39429_row1_col1\" class=\"data row1 col1\" >8761,77</td>\n",
       "      <td id=\"T_39429_row1_col2\" class=\"data row1 col2\" >37090,04</td>\n",
       "      <td id=\"T_39429_row1_col3\" class=\"data row1 col3\" >1200</td>\n",
       "      <td id=\"T_39429_row1_col4\" class=\"data row1 col4\" >8411,30</td>\n",
       "      <td id=\"T_39429_row1_col5\" class=\"data row1 col5\" >35606,43</td>\n",
       "      <td id=\"T_39429_row1_col6\" class=\"data row1 col6\" >-../-</td>\n",
       "      <td id=\"T_39429_row1_col7\" class=\"data row1 col7\" >Corretora Clear - Ação - COGN3 x 1200 = USD 8411.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row2\" class=\"row_heading level0 row2\" >FAMB11B</th>\n",
       "      <td id=\"T_39429_row2_col0\" class=\"data row2 col0\" >6</td>\n",
       "      <td id=\"T_39429_row2_col1\" class=\"data row2 col1\" >8552,87</td>\n",
       "      <td id=\"T_39429_row2_col2\" class=\"data row2 col2\" >46770,80</td>\n",
       "      <td id=\"T_39429_row2_col3\" class=\"data row2 col3\" >6</td>\n",
       "      <td id=\"T_39429_row2_col4\" class=\"data row2 col4\" >8552,87</td>\n",
       "      <td id=\"T_39429_row2_col5\" class=\"data row2 col5\" >46770,80</td>\n",
       "      <td id=\"T_39429_row2_col6\" class=\"data row2 col6\" >05.562.312/0001-02</td>\n",
       "      <td id=\"T_39429_row2_col7\" class=\"data row2 col7\" >Corretora Clear - FII - FAMB11B x 6 = USD 8552.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row3\" class=\"row_heading level0 row3\" >VISC11</th>\n",
       "      <td id=\"T_39429_row3_col0\" class=\"data row3 col0\" >59</td>\n",
       "      <td id=\"T_39429_row3_col1\" class=\"data row3 col1\" >5795,30</td>\n",
       "      <td id=\"T_39429_row3_col2\" class=\"data row3 col2\" >22869,34</td>\n",
       "      <td id=\"T_39429_row3_col3\" class=\"data row3 col3\" >0</td>\n",
       "      <td id=\"T_39429_row3_col4\" class=\"data row3 col4\" >0,00</td>\n",
       "      <td id=\"T_39429_row3_col5\" class=\"data row3 col5\" >0,00</td>\n",
       "      <td id=\"T_39429_row3_col6\" class=\"data row3 col6\" >17.554.274/0001-25</td>\n",
       "      <td id=\"T_39429_row3_col7\" class=\"data row3 col7\" >Corretora Clear - FII - VISC11 x 0 = USD 0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row4\" class=\"row_heading level0 row4\" >CASH</th>\n",
       "      <td id=\"T_39429_row4_col0\" class=\"data row4 col0\" >1</td>\n",
       "      <td id=\"T_39429_row4_col1\" class=\"data row4 col1\" >22607,15</td>\n",
       "      <td id=\"T_39429_row4_col2\" class=\"data row4 col2\" >17,21</td>\n",
       "      <td id=\"T_39429_row4_col3\" class=\"data row4 col3\" >1</td>\n",
       "      <td id=\"T_39429_row4_col4\" class=\"data row4 col4\" >82766,06</td>\n",
       "      <td id=\"T_39429_row4_col5\" class=\"data row4 col5\" >105,54</td>\n",
       "      <td id=\"T_39429_row4_col6\" class=\"data row4 col6\" >Page no found</td>\n",
       "      <td id=\"T_39429_row4_col7\" class=\"data row4 col7\" >Corretora Clear - CASH - CASH x 1 = USD 82766.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row5\" class=\"row_heading level0 row5\" >EGIE3</th>\n",
       "      <td id=\"T_39429_row5_col0\" class=\"data row5 col0\" >100</td>\n",
       "      <td id=\"T_39429_row5_col1\" class=\"data row5 col1\" >4151,32</td>\n",
       "      <td id=\"T_39429_row5_col2\" class=\"data row5 col2\" >16565,85</td>\n",
       "      <td id=\"T_39429_row5_col3\" class=\"data row5 col3\" >0</td>\n",
       "      <td id=\"T_39429_row5_col4\" class=\"data row5 col4\" >0,00</td>\n",
       "      <td id=\"T_39429_row5_col5\" class=\"data row5 col5\" >0,00</td>\n",
       "      <td id=\"T_39429_row5_col6\" class=\"data row5 col6\" >-../-</td>\n",
       "      <td id=\"T_39429_row5_col7\" class=\"data row5 col7\" >Corretora Clear - Ação - EGIE3 x 0 = USD 0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row6\" class=\"row_heading level0 row6\" >EZTC3</th>\n",
       "      <td id=\"T_39429_row6_col0\" class=\"data row6 col0\" >600</td>\n",
       "      <td id=\"T_39429_row6_col1\" class=\"data row6 col1\" >18155,46</td>\n",
       "      <td id=\"T_39429_row6_col2\" class=\"data row6 col2\" >92632,52</td>\n",
       "      <td id=\"T_39429_row6_col3\" class=\"data row6 col3\" >700</td>\n",
       "      <td id=\"T_39429_row6_col4\" class=\"data row6 col4\" >19673,90</td>\n",
       "      <td id=\"T_39429_row6_col5\" class=\"data row6 col5\" >100069,99</td>\n",
       "      <td id=\"T_39429_row6_col6\" class=\"data row6 col6\" >08.312.229/0001-73</td>\n",
       "      <td id=\"T_39429_row6_col7\" class=\"data row6 col7\" >Corretora Clear - Ação - EZTC3 x 700 = USD 19673.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row7\" class=\"row_heading level0 row7\" >GTWR11</th>\n",
       "      <td id=\"T_39429_row7_col0\" class=\"data row7 col0\" >12</td>\n",
       "      <td id=\"T_39429_row7_col1\" class=\"data row7 col1\" >1303,97</td>\n",
       "      <td id=\"T_39429_row7_col2\" class=\"data row7 col2\" >5352,17</td>\n",
       "      <td id=\"T_39429_row7_col3\" class=\"data row7 col3\" >12</td>\n",
       "      <td id=\"T_39429_row7_col4\" class=\"data row7 col4\" >1303,97</td>\n",
       "      <td id=\"T_39429_row7_col5\" class=\"data row7 col5\" >5352,17</td>\n",
       "      <td id=\"T_39429_row7_col6\" class=\"data row7 col6\" >23.740.527/0001-58</td>\n",
       "      <td id=\"T_39429_row7_col7\" class=\"data row7 col7\" >Corretora Clear - FII - GTWR11 x 12 = USD 1303.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row8\" class=\"row_heading level0 row8\" >HTMX11</th>\n",
       "      <td id=\"T_39429_row8_col0\" class=\"data row8 col0\" >43</td>\n",
       "      <td id=\"T_39429_row8_col1\" class=\"data row8 col1\" >6811,52</td>\n",
       "      <td id=\"T_39429_row8_col2\" class=\"data row8 col2\" >29472,30</td>\n",
       "      <td id=\"T_39429_row8_col3\" class=\"data row8 col3\" >0</td>\n",
       "      <td id=\"T_39429_row8_col4\" class=\"data row8 col4\" >0,00</td>\n",
       "      <td id=\"T_39429_row8_col5\" class=\"data row8 col5\" >0,00</td>\n",
       "      <td id=\"T_39429_row8_col6\" class=\"data row8 col6\" >08.706.065/0001-69</td>\n",
       "      <td id=\"T_39429_row8_col7\" class=\"data row8 col7\" >Corretora Clear - FII - HTMX11 x 0 = USD 0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row9\" class=\"row_heading level0 row9\" >MDIA3</th>\n",
       "      <td id=\"T_39429_row9_col0\" class=\"data row9 col0\" >800</td>\n",
       "      <td id=\"T_39429_row9_col1\" class=\"data row9 col1\" >27494,57</td>\n",
       "      <td id=\"T_39429_row9_col2\" class=\"data row9 col2\" >122383,96</td>\n",
       "      <td id=\"T_39429_row9_col3\" class=\"data row9 col3\" >0</td>\n",
       "      <td id=\"T_39429_row9_col4\" class=\"data row9 col4\" >0,00</td>\n",
       "      <td id=\"T_39429_row9_col5\" class=\"data row9 col5\" >0,00</td>\n",
       "      <td id=\"T_39429_row9_col6\" class=\"data row9 col6\" >07.206.816/0001-15</td>\n",
       "      <td id=\"T_39429_row9_col7\" class=\"data row9 col7\" >Corretora Clear - Ação - MDIA3 x 0 = USD 0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row10\" class=\"row_heading level0 row10\" >PSSA3</th>\n",
       "      <td id=\"T_39429_row10_col0\" class=\"data row10 col0\" >740</td>\n",
       "      <td id=\"T_39429_row10_col1\" class=\"data row10 col1\" >18149,74</td>\n",
       "      <td id=\"T_39429_row10_col2\" class=\"data row10 col2\" >180320,65</td>\n",
       "      <td id=\"T_39429_row10_col3\" class=\"data row10 col3\" >740</td>\n",
       "      <td id=\"T_39429_row10_col4\" class=\"data row10 col4\" >18149,74</td>\n",
       "      <td id=\"T_39429_row10_col5\" class=\"data row10 col5\" >180320,65</td>\n",
       "      <td id=\"T_39429_row10_col6\" class=\"data row10 col6\" >02.149.205/0001-69</td>\n",
       "      <td id=\"T_39429_row10_col7\" class=\"data row10 col7\" >Corretora Clear - Ação - PSSA3 x 740 = USD 18149.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row11\" class=\"row_heading level0 row11\" >XPCM11</th>\n",
       "      <td id=\"T_39429_row11_col0\" class=\"data row11 col0\" >169</td>\n",
       "      <td id=\"T_39429_row11_col1\" class=\"data row11 col1\" >9540,37</td>\n",
       "      <td id=\"T_39429_row11_col2\" class=\"data row11 col2\" >37775,24</td>\n",
       "      <td id=\"T_39429_row11_col3\" class=\"data row11 col3\" >169</td>\n",
       "      <td id=\"T_39429_row11_col4\" class=\"data row11 col4\" >9540,37</td>\n",
       "      <td id=\"T_39429_row11_col5\" class=\"data row11 col5\" >37775,24</td>\n",
       "      <td id=\"T_39429_row11_col6\" class=\"data row11 col6\" >16.802.320/0001-03</td>\n",
       "      <td id=\"T_39429_row11_col7\" class=\"data row11 col7\" >Corretora Clear - FII - XPCM11 x 169 = USD 9540.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row12\" class=\"row_heading level0 row12\" >XPLG11</th>\n",
       "      <td id=\"T_39429_row12_col0\" class=\"data row12 col0\" >40</td>\n",
       "      <td id=\"T_39429_row12_col1\" class=\"data row12 col1\" >4147,51</td>\n",
       "      <td id=\"T_39429_row12_col2\" class=\"data row12 col2\" >16549,77</td>\n",
       "      <td id=\"T_39429_row12_col3\" class=\"data row12 col3\" >0</td>\n",
       "      <td id=\"T_39429_row12_col4\" class=\"data row12 col4\" >0,00</td>\n",
       "      <td id=\"T_39429_row12_col5\" class=\"data row12 col5\" >0,00</td>\n",
       "      <td id=\"T_39429_row12_col6\" class=\"data row12 col6\" >26.502.794/0001-85</td>\n",
       "      <td id=\"T_39429_row12_col7\" class=\"data row12 col7\" >Corretora Clear - FII - XPLG11 x 0 = USD 0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row13\" class=\"row_heading level0 row13\" >XPML11</th>\n",
       "      <td id=\"T_39429_row13_col0\" class=\"data row13 col0\" >51</td>\n",
       "      <td id=\"T_39429_row13_col1\" class=\"data row13 col1\" >5608,53</td>\n",
       "      <td id=\"T_39429_row13_col2\" class=\"data row13 col2\" >22411,32</td>\n",
       "      <td id=\"T_39429_row13_col3\" class=\"data row13 col3\" >43</td>\n",
       "      <td id=\"T_39429_row13_col4\" class=\"data row13 col4\" >4728,76</td>\n",
       "      <td id=\"T_39429_row13_col5\" class=\"data row13 col5\" >18895,82</td>\n",
       "      <td id=\"T_39429_row13_col6\" class=\"data row13 col6\" >28.757.546/0001-00</td>\n",
       "      <td id=\"T_39429_row13_col7\" class=\"data row13 col7\" >Corretora Clear - FII - XPML11 x 43 = USD 4728.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row14\" class=\"row_heading level0 row14\" >SBFG3</th>\n",
       "      <td id=\"T_39429_row14_col0\" class=\"data row14 col0\" >200</td>\n",
       "      <td id=\"T_39429_row14_col1\" class=\"data row14 col1\" >4531,37</td>\n",
       "      <td id=\"T_39429_row14_col2\" class=\"data row14 col2\" >25783,37</td>\n",
       "      <td id=\"T_39429_row14_col3\" class=\"data row14 col3\" >0</td>\n",
       "      <td id=\"T_39429_row14_col4\" class=\"data row14 col4\" >0,00</td>\n",
       "      <td id=\"T_39429_row14_col5\" class=\"data row14 col5\" >0,00</td>\n",
       "      <td id=\"T_39429_row14_col6\" class=\"data row14 col6\" >-../-</td>\n",
       "      <td id=\"T_39429_row14_col7\" class=\"data row14 col7\" >Corretora Clear - Ação - SBFG3 x 0 = USD 0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row15\" class=\"row_heading level0 row15\" >TRIS3</th>\n",
       "      <td id=\"T_39429_row15_col0\" class=\"data row15 col0\" >500</td>\n",
       "      <td id=\"T_39429_row15_col1\" class=\"data row15 col1\" >5455,63</td>\n",
       "      <td id=\"T_39429_row15_col2\" class=\"data row15 col2\" >29172,89</td>\n",
       "      <td id=\"T_39429_row15_col3\" class=\"data row15 col3\" >0</td>\n",
       "      <td id=\"T_39429_row15_col4\" class=\"data row15 col4\" >0,00</td>\n",
       "      <td id=\"T_39429_row15_col5\" class=\"data row15 col5\" >0,00</td>\n",
       "      <td id=\"T_39429_row15_col6\" class=\"data row15 col6\" >08.811.643/0001-27</td>\n",
       "      <td id=\"T_39429_row15_col7\" class=\"data row15 col7\" >Corretora Clear - Ação - TRIS3 x 0 = USD 0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row16\" class=\"row_heading level0 row16\" >BBDC3</th>\n",
       "      <td id=\"T_39429_row16_col0\" class=\"data row16 col0\" >220</td>\n",
       "      <td id=\"T_39429_row16_col1\" class=\"data row16 col1\" >4419,33</td>\n",
       "      <td id=\"T_39429_row16_col2\" class=\"data row16 col2\" >25860,49</td>\n",
       "      <td id=\"T_39429_row16_col3\" class=\"data row16 col3\" >542</td>\n",
       "      <td id=\"T_39429_row16_col4\" class=\"data row16 col4\" >8470,54</td>\n",
       "      <td id=\"T_39429_row16_col5\" class=\"data row16 col5\" >49281,91</td>\n",
       "      <td id=\"T_39429_row16_col6\" class=\"data row16 col6\" >60.746.948/0001-12</td>\n",
       "      <td id=\"T_39429_row16_col7\" class=\"data row16 col7\" >Corretora Clear - Ação - BBDC3 x 542 = USD 8470.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row17\" class=\"row_heading level0 row17\" >CSUD3</th>\n",
       "      <td id=\"T_39429_row17_col0\" class=\"data row17 col0\" >300</td>\n",
       "      <td id=\"T_39429_row17_col1\" class=\"data row17 col1\" >4012,19</td>\n",
       "      <td id=\"T_39429_row17_col2\" class=\"data row17 col2\" >22453,94</td>\n",
       "      <td id=\"T_39429_row17_col3\" class=\"data row17 col3\" >300</td>\n",
       "      <td id=\"T_39429_row17_col4\" class=\"data row17 col4\" >4012,19</td>\n",
       "      <td id=\"T_39429_row17_col5\" class=\"data row17 col5\" >22453,94</td>\n",
       "      <td id=\"T_39429_row17_col6\" class=\"data row17 col6\" >-../-</td>\n",
       "      <td id=\"T_39429_row17_col7\" class=\"data row17 col7\" >Corretora Clear - Ação - CSUD3 x 300 = USD 4012.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row18\" class=\"row_heading level0 row18\" >DEVA11</th>\n",
       "      <td id=\"T_39429_row18_col0\" class=\"data row18 col0\" >30</td>\n",
       "      <td id=\"T_39429_row18_col1\" class=\"data row18 col1\" >3155,79</td>\n",
       "      <td id=\"T_39429_row18_col2\" class=\"data row18 col2\" >16966,53</td>\n",
       "      <td id=\"T_39429_row18_col3\" class=\"data row18 col3\" >31</td>\n",
       "      <td id=\"T_39429_row18_col4\" class=\"data row18 col4\" >3257,36</td>\n",
       "      <td id=\"T_39429_row18_col5\" class=\"data row18 col5\" >17501,05</td>\n",
       "      <td id=\"T_39429_row18_col6\" class=\"data row18 col6\" >37.087.810/0001-37</td>\n",
       "      <td id=\"T_39429_row18_col7\" class=\"data row18 col7\" >Corretora Clear - FII - DEVA11 x 31 = USD 3257.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row19\" class=\"row_heading level0 row19\" >GOLL4</th>\n",
       "      <td id=\"T_39429_row19_col0\" class=\"data row19 col0\" >574</td>\n",
       "      <td id=\"T_39429_row19_col1\" class=\"data row19 col1\" >21727,37</td>\n",
       "      <td id=\"T_39429_row19_col2\" class=\"data row19 col2\" >107704,73</td>\n",
       "      <td id=\"T_39429_row19_col3\" class=\"data row19 col3\" >500</td>\n",
       "      <td id=\"T_39429_row19_col4\" class=\"data row19 col4\" >18926,28</td>\n",
       "      <td id=\"T_39429_row19_col5\" class=\"data row19 col5\" >93819,45</td>\n",
       "      <td id=\"T_39429_row19_col6\" class=\"data row19 col6\" >06.164.253/0001-87</td>\n",
       "      <td id=\"T_39429_row19_col7\" class=\"data row19 col7\" >Corretora Clear - Ação - GOLL4 x 500 = USD 18926.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row20\" class=\"row_heading level0 row20\" >HGRE11</th>\n",
       "      <td id=\"T_39429_row20_col0\" class=\"data row20 col0\" >29</td>\n",
       "      <td id=\"T_39429_row20_col1\" class=\"data row20 col1\" >3655,70</td>\n",
       "      <td id=\"T_39429_row20_col2\" class=\"data row20 col2\" >19697,55</td>\n",
       "      <td id=\"T_39429_row20_col3\" class=\"data row20 col3\" >29</td>\n",
       "      <td id=\"T_39429_row20_col4\" class=\"data row20 col4\" >3655,70</td>\n",
       "      <td id=\"T_39429_row20_col5\" class=\"data row20 col5\" >19697,55</td>\n",
       "      <td id=\"T_39429_row20_col6\" class=\"data row20 col6\" >09.072.017/0001-29</td>\n",
       "      <td id=\"T_39429_row20_col7\" class=\"data row20 col7\" >Corretora Clear - FII - HGRE11 x 29 = USD 3655.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row21\" class=\"row_heading level0 row21\" >HGRU11</th>\n",
       "      <td id=\"T_39429_row21_col0\" class=\"data row21 col0\" >20</td>\n",
       "      <td id=\"T_39429_row21_col1\" class=\"data row21 col1\" >2395,61</td>\n",
       "      <td id=\"T_39429_row21_col2\" class=\"data row21 col2\" >12649,57</td>\n",
       "      <td id=\"T_39429_row21_col3\" class=\"data row21 col3\" >20</td>\n",
       "      <td id=\"T_39429_row21_col4\" class=\"data row21 col4\" >2395,61</td>\n",
       "      <td id=\"T_39429_row21_col5\" class=\"data row21 col5\" >12649,57</td>\n",
       "      <td id=\"T_39429_row21_col6\" class=\"data row21 col6\" >29.641.226/0001-53</td>\n",
       "      <td id=\"T_39429_row21_col7\" class=\"data row21 col7\" >Corretora Clear - FII - HGRU11 x 20 = USD 2395.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row22\" class=\"row_heading level0 row22\" >HSLG11</th>\n",
       "      <td id=\"T_39429_row22_col0\" class=\"data row22 col0\" >30</td>\n",
       "      <td id=\"T_39429_row22_col1\" class=\"data row22 col1\" >3076,54</td>\n",
       "      <td id=\"T_39429_row22_col2\" class=\"data row22 col2\" >15614,94</td>\n",
       "      <td id=\"T_39429_row22_col3\" class=\"data row22 col3\" >30</td>\n",
       "      <td id=\"T_39429_row22_col4\" class=\"data row22 col4\" >3076,54</td>\n",
       "      <td id=\"T_39429_row22_col5\" class=\"data row22 col5\" >15614,94</td>\n",
       "      <td id=\"T_39429_row22_col6\" class=\"data row22 col6\" >32.903.621/0001-71</td>\n",
       "      <td id=\"T_39429_row22_col7\" class=\"data row22 col7\" >Corretora Clear - FII - HSLG11 x 30 = USD 3076.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row23\" class=\"row_heading level0 row23\" >HSML11</th>\n",
       "      <td id=\"T_39429_row23_col0\" class=\"data row23 col0\" >43</td>\n",
       "      <td id=\"T_39429_row23_col1\" class=\"data row23 col1\" >3594,24</td>\n",
       "      <td id=\"T_39429_row23_col2\" class=\"data row23 col2\" >18780,70</td>\n",
       "      <td id=\"T_39429_row23_col3\" class=\"data row23 col3\" >43</td>\n",
       "      <td id=\"T_39429_row23_col4\" class=\"data row23 col4\" >3594,24</td>\n",
       "      <td id=\"T_39429_row23_col5\" class=\"data row23 col5\" >18780,70</td>\n",
       "      <td id=\"T_39429_row23_col6\" class=\"data row23 col6\" >32.892.018/0001-31</td>\n",
       "      <td id=\"T_39429_row23_col7\" class=\"data row23 col7\" >Corretora Clear - FII - HSML11 x 43 = USD 3594.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row24\" class=\"row_heading level0 row24\" >KNSC11</th>\n",
       "      <td id=\"T_39429_row24_col0\" class=\"data row24 col0\" >15</td>\n",
       "      <td id=\"T_39429_row24_col1\" class=\"data row24 col1\" >1525,48</td>\n",
       "      <td id=\"T_39429_row24_col2\" class=\"data row24 col2\" >8005,63</td>\n",
       "      <td id=\"T_39429_row24_col3\" class=\"data row24 col3\" >25</td>\n",
       "      <td id=\"T_39429_row24_col4\" class=\"data row24 col4\" >2455,63</td>\n",
       "      <td id=\"T_39429_row24_col5\" class=\"data row24 col5\" >12735,20</td>\n",
       "      <td id=\"T_39429_row24_col6\" class=\"data row24 col6\" >35.864.448/0001-38</td>\n",
       "      <td id=\"T_39429_row24_col7\" class=\"data row24 col7\" >Corretora Clear - FII - KNSC11 x 25 = USD 2455.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row25\" class=\"row_heading level0 row25\" >LCAM3</th>\n",
       "      <td id=\"T_39429_row25_col0\" class=\"data row25 col0\" >600</td>\n",
       "      <td id=\"T_39429_row25_col1\" class=\"data row25 col1\" >13925,14</td>\n",
       "      <td id=\"T_39429_row25_col2\" class=\"data row25 col2\" >75080,12</td>\n",
       "      <td id=\"T_39429_row25_col3\" class=\"data row25 col3\" >0</td>\n",
       "      <td id=\"T_39429_row25_col4\" class=\"data row25 col4\" >0,00</td>\n",
       "      <td id=\"T_39429_row25_col5\" class=\"data row25 col5\" >0,00</td>\n",
       "      <td id=\"T_39429_row25_col6\" class=\"data row25 col6\" >10.215.988/0001-60</td>\n",
       "      <td id=\"T_39429_row25_col7\" class=\"data row25 col7\" >Corretora Clear - Ação - LCAM3 x 0 = USD 0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row26\" class=\"row_heading level0 row26\" >MOVI3</th>\n",
       "      <td id=\"T_39429_row26_col0\" class=\"data row26 col0\" >100</td>\n",
       "      <td id=\"T_39429_row26_col1\" class=\"data row26 col1\" >1755,52</td>\n",
       "      <td id=\"T_39429_row26_col2\" class=\"data row26 col2\" >9528,27</td>\n",
       "      <td id=\"T_39429_row26_col3\" class=\"data row26 col3\" >1600</td>\n",
       "      <td id=\"T_39429_row26_col4\" class=\"data row26 col4\" >20260,04</td>\n",
       "      <td id=\"T_39429_row26_col5\" class=\"data row26 col5\" >105224,37</td>\n",
       "      <td id=\"T_39429_row26_col6\" class=\"data row26 col6\" >-../-</td>\n",
       "      <td id=\"T_39429_row26_col7\" class=\"data row26 col7\" >Corretora Clear - Ação - MOVI3 x 1600 = USD 20260.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row27\" class=\"row_heading level0 row27\" >MRVE3</th>\n",
       "      <td id=\"T_39429_row27_col0\" class=\"data row27 col0\" >300</td>\n",
       "      <td id=\"T_39429_row27_col1\" class=\"data row27 col1\" >3814,13</td>\n",
       "      <td id=\"T_39429_row27_col2\" class=\"data row27 col2\" >20347,14</td>\n",
       "      <td id=\"T_39429_row27_col3\" class=\"data row27 col3\" >0</td>\n",
       "      <td id=\"T_39429_row27_col4\" class=\"data row27 col4\" >0,00</td>\n",
       "      <td id=\"T_39429_row27_col5\" class=\"data row27 col5\" >0,00</td>\n",
       "      <td id=\"T_39429_row27_col6\" class=\"data row27 col6\" >08.343.492/0001-20</td>\n",
       "      <td id=\"T_39429_row27_col7\" class=\"data row27 col7\" >Corretora Clear - Ação - MRVE3 x 0 = USD 0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row28\" class=\"row_heading level0 row28\" >OIBR3</th>\n",
       "      <td id=\"T_39429_row28_col0\" class=\"data row28 col0\" >2400</td>\n",
       "      <td id=\"T_39429_row28_col1\" class=\"data row28 col1\" >2899,81</td>\n",
       "      <td id=\"T_39429_row28_col2\" class=\"data row28 col2\" >15637,25</td>\n",
       "      <td id=\"T_39429_row28_col3\" class=\"data row28 col3\" >2800</td>\n",
       "      <td id=\"T_39429_row28_col4\" class=\"data row28 col4\" >3059,86</td>\n",
       "      <td id=\"T_39429_row28_col5\" class=\"data row28 col5\" >16478,91</td>\n",
       "      <td id=\"T_39429_row28_col6\" class=\"data row28 col6\" >76.535.764/0001-43</td>\n",
       "      <td id=\"T_39429_row28_col7\" class=\"data row28 col7\" >Corretora Clear - Ação - OIBR3 x 2800 = USD 3059.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row29\" class=\"row_heading level0 row29\" >PARD3</th>\n",
       "      <td id=\"T_39429_row29_col0\" class=\"data row29 col0\" >400</td>\n",
       "      <td id=\"T_39429_row29_col1\" class=\"data row29 col1\" >7662,29</td>\n",
       "      <td id=\"T_39429_row29_col2\" class=\"data row29 col2\" >42217,83</td>\n",
       "      <td id=\"T_39429_row29_col3\" class=\"data row29 col3\" >0</td>\n",
       "      <td id=\"T_39429_row29_col4\" class=\"data row29 col4\" >0,00</td>\n",
       "      <td id=\"T_39429_row29_col5\" class=\"data row29 col5\" >0,00</td>\n",
       "      <td id=\"T_39429_row29_col6\" class=\"data row29 col6\" >-../-</td>\n",
       "      <td id=\"T_39429_row29_col7\" class=\"data row29 col7\" >Corretora Clear - Ação - PARD3 x 0 = USD 0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row30\" class=\"row_heading level0 row30\" >PRIO3</th>\n",
       "      <td id=\"T_39429_row30_col0\" class=\"data row30 col0\" >100</td>\n",
       "      <td id=\"T_39429_row30_col1\" class=\"data row30 col1\" >1730,51</td>\n",
       "      <td id=\"T_39429_row30_col2\" class=\"data row30 col2\" >8954,70</td>\n",
       "      <td id=\"T_39429_row30_col3\" class=\"data row30 col3\" >0</td>\n",
       "      <td id=\"T_39429_row30_col4\" class=\"data row30 col4\" >0,00</td>\n",
       "      <td id=\"T_39429_row30_col5\" class=\"data row30 col5\" >0,00</td>\n",
       "      <td id=\"T_39429_row30_col6\" class=\"data row30 col6\" >-../-</td>\n",
       "      <td id=\"T_39429_row30_col7\" class=\"data row30 col7\" >Corretora Clear - Ação - PRIO3 x 0 = USD 0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row31\" class=\"row_heading level0 row31\" >RBRF11</th>\n",
       "      <td id=\"T_39429_row31_col0\" class=\"data row31 col0\" >72</td>\n",
       "      <td id=\"T_39429_row31_col1\" class=\"data row31 col1\" >6016,74</td>\n",
       "      <td id=\"T_39429_row31_col2\" class=\"data row31 col2\" >30892,32</td>\n",
       "      <td id=\"T_39429_row31_col3\" class=\"data row31 col3\" >82</td>\n",
       "      <td id=\"T_39429_row31_col4\" class=\"data row31 col4\" >6707,64</td>\n",
       "      <td id=\"T_39429_row31_col5\" class=\"data row31 col5\" >34437,54</td>\n",
       "      <td id=\"T_39429_row31_col6\" class=\"data row31 col6\" >27.529.279/0001-51</td>\n",
       "      <td id=\"T_39429_row31_col7\" class=\"data row31 col7\" >Corretora Clear - FII - RBRF11 x 82 = USD 6707.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row32\" class=\"row_heading level0 row32\" >RBRY11</th>\n",
       "      <td id=\"T_39429_row32_col0\" class=\"data row32 col0\" >40</td>\n",
       "      <td id=\"T_39429_row32_col1\" class=\"data row32 col1\" >4008,81</td>\n",
       "      <td id=\"T_39429_row32_col2\" class=\"data row32 col2\" >20565,86</td>\n",
       "      <td id=\"T_39429_row32_col3\" class=\"data row32 col3\" >68</td>\n",
       "      <td id=\"T_39429_row32_col4\" class=\"data row32 col4\" >6926,84</td>\n",
       "      <td id=\"T_39429_row32_col5\" class=\"data row32 col5\" >35301,07</td>\n",
       "      <td id=\"T_39429_row32_col6\" class=\"data row32 col6\" >30.166.700/0001-11</td>\n",
       "      <td id=\"T_39429_row32_col7\" class=\"data row32 col7\" >Corretora Clear - FII - RBRY11 x 68 = USD 6926.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row33\" class=\"row_heading level0 row33\" >RVBI11</th>\n",
       "      <td id=\"T_39429_row33_col0\" class=\"data row33 col0\" >8</td>\n",
       "      <td id=\"T_39429_row33_col1\" class=\"data row33 col1\" >722,70</td>\n",
       "      <td id=\"T_39429_row33_col2\" class=\"data row33 col2\" >3550,39</td>\n",
       "      <td id=\"T_39429_row33_col3\" class=\"data row33 col3\" >20</td>\n",
       "      <td id=\"T_39429_row33_col4\" class=\"data row33 col4\" >1676,98</td>\n",
       "      <td id=\"T_39429_row33_col5\" class=\"data row33 col5\" >8402,63</td>\n",
       "      <td id=\"T_39429_row33_col6\" class=\"data row33 col6\" >35.507.457/0001-71</td>\n",
       "      <td id=\"T_39429_row33_col7\" class=\"data row33 col7\" >Corretora Clear - FII - RVBI11 x 20 = USD 1676.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row34\" class=\"row_heading level0 row34\" >TASA4</th>\n",
       "      <td id=\"T_39429_row34_col0\" class=\"data row34 col0\" >300</td>\n",
       "      <td id=\"T_39429_row34_col1\" class=\"data row34 col1\" >6139,84</td>\n",
       "      <td id=\"T_39429_row34_col2\" class=\"data row34 col2\" >33945,32</td>\n",
       "      <td id=\"T_39429_row34_col3\" class=\"data row34 col3\" >900</td>\n",
       "      <td id=\"T_39429_row34_col4\" class=\"data row34 col4\" >16283,87</td>\n",
       "      <td id=\"T_39429_row34_col5\" class=\"data row34 col5\" >85879,81</td>\n",
       "      <td id=\"T_39429_row34_col6\" class=\"data row34 col6\" >-../-</td>\n",
       "      <td id=\"T_39429_row34_col7\" class=\"data row34 col7\" >Corretora Clear - Ação - TASA4 x 900 = USD 16283.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row35\" class=\"row_heading level0 row35\" >VILG11</th>\n",
       "      <td id=\"T_39429_row35_col0\" class=\"data row35 col0\" >65</td>\n",
       "      <td id=\"T_39429_row35_col1\" class=\"data row35 col1\" >7213,65</td>\n",
       "      <td id=\"T_39429_row35_col2\" class=\"data row35 col2\" >37412,14</td>\n",
       "      <td id=\"T_39429_row35_col3\" class=\"data row35 col3\" >65</td>\n",
       "      <td id=\"T_39429_row35_col4\" class=\"data row35 col4\" >7213,65</td>\n",
       "      <td id=\"T_39429_row35_col5\" class=\"data row35 col5\" >37412,14</td>\n",
       "      <td id=\"T_39429_row35_col6\" class=\"data row35 col6\" >24.853.044/0001-22</td>\n",
       "      <td id=\"T_39429_row35_col7\" class=\"data row35 col7\" >Corretora Clear - FII - VILG11 x 65 = USD 7213.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row36\" class=\"row_heading level0 row36\" >VRTA11</th>\n",
       "      <td id=\"T_39429_row36_col0\" class=\"data row36 col0\" >53</td>\n",
       "      <td id=\"T_39429_row36_col1\" class=\"data row36 col1\" >5482,37</td>\n",
       "      <td id=\"T_39429_row36_col2\" class=\"data row36 col2\" >28887,11</td>\n",
       "      <td id=\"T_39429_row36_col3\" class=\"data row36 col3\" >100</td>\n",
       "      <td id=\"T_39429_row36_col4\" class=\"data row36 col4\" >10196,47</td>\n",
       "      <td id=\"T_39429_row36_col5\" class=\"data row36 col5\" >53269,55</td>\n",
       "      <td id=\"T_39429_row36_col6\" class=\"data row36 col6\" >11.664.201/0001-00</td>\n",
       "      <td id=\"T_39429_row36_col7\" class=\"data row36 col7\" >Corretora Clear - FII - VRTA11 x 100 = USD 10196.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row37\" class=\"row_heading level0 row37\" >XPBR31</th>\n",
       "      <td id=\"T_39429_row37_col0\" class=\"data row37 col0\" >12,3088</td>\n",
       "      <td id=\"T_39429_row37_col1\" class=\"data row37 col1\" >2090,58</td>\n",
       "      <td id=\"T_39429_row37_col2\" class=\"data row37 col2\" >11809,93</td>\n",
       "      <td id=\"T_39429_row37_col3\" class=\"data row37 col3\" >0,308785</td>\n",
       "      <td id=\"T_39429_row37_col4\" class=\"data row37 col4\" >52,45</td>\n",
       "      <td id=\"T_39429_row37_col5\" class=\"data row37 col5\" >296,27</td>\n",
       "      <td id=\"T_39429_row37_col6\" class=\"data row37 col6\" >-../-</td>\n",
       "      <td id=\"T_39429_row37_col7\" class=\"data row37 col7\" >Corretora Clear - Ação - XPBR31 x 0 = USD 52.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row38\" class=\"row_heading level0 row38\" >BPAC11</th>\n",
       "      <td id=\"T_39429_row38_col0\" class=\"data row38 col0\" >0</td>\n",
       "      <td id=\"T_39429_row38_col1\" class=\"data row38 col1\" >0,00</td>\n",
       "      <td id=\"T_39429_row38_col2\" class=\"data row38 col2\" >0,00</td>\n",
       "      <td id=\"T_39429_row38_col3\" class=\"data row38 col3\" >200</td>\n",
       "      <td id=\"T_39429_row38_col4\" class=\"data row38 col4\" >4646,38</td>\n",
       "      <td id=\"T_39429_row38_col5\" class=\"data row38 col5\" >23430,82</td>\n",
       "      <td id=\"T_39429_row38_col6\" class=\"data row38 col6\" >30.306.294/0001-45</td>\n",
       "      <td id=\"T_39429_row38_col7\" class=\"data row38 col7\" >Corretora Clear - Ação - BPAC11 x 200 = USD 4646.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row39\" class=\"row_heading level0 row39\" >BPAC3</th>\n",
       "      <td id=\"T_39429_row39_col0\" class=\"data row39 col0\" >0</td>\n",
       "      <td id=\"T_39429_row39_col1\" class=\"data row39 col1\" >0,00</td>\n",
       "      <td id=\"T_39429_row39_col2\" class=\"data row39 col2\" >0,00</td>\n",
       "      <td id=\"T_39429_row39_col3\" class=\"data row39 col3\" >100</td>\n",
       "      <td id=\"T_39429_row39_col4\" class=\"data row39 col4\" >1366,00</td>\n",
       "      <td id=\"T_39429_row39_col5\" class=\"data row39 col5\" >6745,03</td>\n",
       "      <td id=\"T_39429_row39_col6\" class=\"data row39 col6\" >30.306.294/0001-45</td>\n",
       "      <td id=\"T_39429_row39_col7\" class=\"data row39 col7\" >Corretora Clear - Ação - BPAC3 x 100 = USD 1366.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_39429_level0_row40\" class=\"row_heading level0 row40\" >RENT3</th>\n",
       "      <td id=\"T_39429_row40_col0\" class=\"data row40 col0\" >0</td>\n",
       "      <td id=\"T_39429_row40_col1\" class=\"data row40 col1\" >0,00</td>\n",
       "      <td id=\"T_39429_row40_col2\" class=\"data row40 col2\" >0,00</td>\n",
       "      <td id=\"T_39429_row40_col3\" class=\"data row40 col3\" >0,19112</td>\n",
       "      <td id=\"T_39429_row40_col4\" class=\"data row40 col4\" >10,14</td>\n",
       "      <td id=\"T_39429_row40_col5\" class=\"data row40 col5\" >54,07</td>\n",
       "      <td id=\"T_39429_row40_col6\" class=\"data row40 col6\" >16.670.085/0001-55</td>\n",
       "      <td id=\"T_39429_row40_col7\" class=\"data row40 col7\" >Corretora Clear - Ação - RENT3 x 0 = USD 10.14</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7f4a3f168640>"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "irpf.show(irpf.get_last_year())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('/home/doreis/Documents/IRPF/2022/2022_informes_redimento/clear/proventos.csv', decimal=',', thousands='.')\n",
    "# print(df[df['Ativo'] == 'CIELO'])\n",
    "df=df[['Ativo', 'Evento', 'ValorLiquido']]\n",
    "df['Ativo'] = df['Ativo'].str.replace('FII', 'FII ')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "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>Ativo</th>\n",
       "      <th>Evento</th>\n",
       "      <th>ValorLiquido</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AMBEVS/A</td>\n",
       "      <td>DIVIDENDO</td>\n",
       "      <td>$38.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BRADESCO</td>\n",
       "      <td>JCP</td>\n",
       "      <td>$2.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BRADESCO</td>\n",
       "      <td>JCP</td>\n",
       "      <td>$3.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BRADESCO</td>\n",
       "      <td>JCP</td>\n",
       "      <td>$2.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BRADESCO</td>\n",
       "      <td>JCP</td>\n",
       "      <td>$2.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>PORTOSEGURO</td>\n",
       "      <td>DIVIDENDO</td>\n",
       "      <td>$341.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>SMILES</td>\n",
       "      <td>JCP</td>\n",
       "      <td>$321.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>SMILES</td>\n",
       "      <td>DIVIDENDO</td>\n",
       "      <td>$3,503.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>TRISUL</td>\n",
       "      <td>DIVIDENDO</td>\n",
       "      <td>$36.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>TRISUL</td>\n",
       "      <td>DIVIDENDO</td>\n",
       "      <td>$36.28</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>232 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           Ativo     Evento  ValorLiquido\n",
       "0       AMBEVS/A  DIVIDENDO        $38.35\n",
       "1       BRADESCO        JCP         $2.93\n",
       "2       BRADESCO        JCP         $3.37\n",
       "3       BRADESCO        JCP         $2.93\n",
       "4       BRADESCO        JCP         $2.93\n",
       "..           ...        ...           ...\n",
       "227  PORTOSEGURO  DIVIDENDO       $341.67\n",
       "228       SMILES        JCP       $321.30\n",
       "229       SMILES  DIVIDENDO     $3,503.57\n",
       "230       TRISUL  DIVIDENDO        $36.28\n",
       "231       TRISUL  DIVIDENDO        $36.28\n",
       "\n",
       "[232 rows x 3 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "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></th>\n",
       "      <th>ValorLiquido</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ativo</th>\n",
       "      <th>Evento</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>AMBEVS/A</th>\n",
       "      <th>DIVIDENDO</th>\n",
       "      <td>$38.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">BRADESCO</th>\n",
       "      <th>DIVIDENDO</th>\n",
       "      <td>$43.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JCP</th>\n",
       "      <td>$130.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CIAHERING</th>\n",
       "      <th>DIVIDENDO</th>\n",
       "      <td>$37.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">CIELO</th>\n",
       "      <th>DIVIDENDO</th>\n",
       "      <td>$19.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JCP</th>\n",
       "      <td>$432.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">ENGIEBRASIL</th>\n",
       "      <th>DIVIDENDO</th>\n",
       "      <td>$322.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JCP</th>\n",
       "      <td>$18.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EZTEC</th>\n",
       "      <th>DIVIDENDO</th>\n",
       "      <td>$84.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FII CSHGURB</th>\n",
       "      <th>RENDIMENTO</th>\n",
       "      <td>$103.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FII DEVANT</th>\n",
       "      <th>RENDIMENTO</th>\n",
       "      <td>$171.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FII FATORVE</th>\n",
       "      <th>RENDIMENTO</th>\n",
       "      <td>$191.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FII GTOWERS</th>\n",
       "      <th>RENDIMENTO</th>\n",
       "      <td>$96.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FII HGREAL</th>\n",
       "      <th>RENDIMENTO</th>\n",
       "      <td>$116.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FII HSILOG</th>\n",
       "      <th>RENDIMENTO</th>\n",
       "      <td>$104.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FII HSIMALL</th>\n",
       "      <th>RENDIMENTO</th>\n",
       "      <td>$97.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FII KINEASC</th>\n",
       "      <th>RENDIMENTO</th>\n",
       "      <td>$124.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FII MAXIREN</th>\n",
       "      <th>RENDIMENTO</th>\n",
       "      <td>$170.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FII RBRALPHA</th>\n",
       "      <th>RENDIMENTO</th>\n",
       "      <td>$259.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FII RBRPCRI</th>\n",
       "      <th>RENDIMENTO</th>\n",
       "      <td>$216.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">FII SPDOWNT</th>\n",
       "      <th>AMORTIZACAO</th>\n",
       "      <td>$316.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RENDIMENTO</th>\n",
       "      <td>$333.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FII VBIREIT</th>\n",
       "      <th>RENDIMENTO</th>\n",
       "      <td>$35.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FII VINCILG</th>\n",
       "      <th>RENDIMENTO</th>\n",
       "      <td>$190.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FII VINCILOG</th>\n",
       "      <th>RENDIMENTO</th>\n",
       "      <td>$34.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FII VINCISC</th>\n",
       "      <th>RENDIMENTO</th>\n",
       "      <td>$339.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FII XPLOG</th>\n",
       "      <th>RENDIMENTO</th>\n",
       "      <td>$292.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FII XPMACAE</th>\n",
       "      <th>RENDIMENTO</th>\n",
       "      <td>$790.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FII XPMALLS</th>\n",
       "      <th>RENDIMENTO</th>\n",
       "      <td>$277.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">FLEURY</th>\n",
       "      <th>DIVIDENDO</th>\n",
       "      <td>$49.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JCP</th>\n",
       "      <td>$19.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GOL</th>\n",
       "      <th>RESGATETOTAL</th>\n",
       "      <td>$4,451.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">GRENDENE</th>\n",
       "      <th>DIVIDENDO</th>\n",
       "      <td>$608.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JCP</th>\n",
       "      <td>$132.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IHPARDINI</th>\n",
       "      <th>JCP</th>\n",
       "      <td>$26.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">ITAUUNIBANCO</th>\n",
       "      <th>DIVIDENDO</th>\n",
       "      <td>$44.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JCP</th>\n",
       "      <td>$56.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LOCAMERICA</th>\n",
       "      <th>JCP</th>\n",
       "      <td>$36.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M.DIASBRANCO</th>\n",
       "      <th>JCP</th>\n",
       "      <td>$369.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MOVIDA</th>\n",
       "      <th>JCP</th>\n",
       "      <td>$6.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MRV</th>\n",
       "      <th>DIVIDENDO</th>\n",
       "      <td>$48.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">PORTOSEGURO</th>\n",
       "      <th>DIVIDENDO</th>\n",
       "      <td>$607.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JCP</th>\n",
       "      <td>$273.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">SMILES</th>\n",
       "      <th>DIVIDENDO</th>\n",
       "      <td>$3,503.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JCP</th>\n",
       "      <td>$321.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TRISUL</th>\n",
       "      <th>DIVIDENDO</th>\n",
       "      <td>$72.56</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           ValorLiquido\n",
       "Ativo        Evento                    \n",
       "AMBEVS/A     DIVIDENDO           $38.35\n",
       "BRADESCO     DIVIDENDO           $43.25\n",
       "             JCP                $130.08\n",
       "CIAHERING    DIVIDENDO           $37.39\n",
       "CIELO        DIVIDENDO           $19.05\n",
       "             JCP                $432.85\n",
       "ENGIEBRASIL  DIVIDENDO          $322.47\n",
       "             JCP                 $18.23\n",
       "EZTEC        DIVIDENDO           $84.79\n",
       "FII CSHGURB  RENDIMENTO         $103.30\n",
       "FII DEVANT   RENDIMENTO         $171.05\n",
       "FII FATORVE  RENDIMENTO         $191.30\n",
       "FII GTOWERS  RENDIMENTO          $96.90\n",
       "FII HGREAL   RENDIMENTO         $116.61\n",
       "FII HSILOG   RENDIMENTO         $104.40\n",
       "FII HSIMALL  RENDIMENTO          $97.58\n",
       "FII KINEASC  RENDIMENTO         $124.90\n",
       "FII MAXIREN  RENDIMENTO         $170.00\n",
       "FII RBRALPHA RENDIMENTO         $259.20\n",
       "FII RBRPCRI  RENDIMENTO         $216.74\n",
       "FII SPDOWNT  AMORTIZACAO        $316.25\n",
       "             RENDIMENTO         $333.96\n",
       "FII VBIREIT  RENDIMENTO          $35.76\n",
       "FII VINCILG  RENDIMENTO         $190.15\n",
       "FII VINCILOG RENDIMENTO          $34.70\n",
       "FII VINCISC  RENDIMENTO         $339.84\n",
       "FII XPLOG    RENDIMENTO         $292.40\n",
       "FII XPMACAE  RENDIMENTO         $790.92\n",
       "FII XPMALLS  RENDIMENTO         $277.35\n",
       "FLEURY       DIVIDENDO           $49.43\n",
       "             JCP                 $19.95\n",
       "GOL          RESGATETOTAL     $4,451.96\n",
       "GRENDENE     DIVIDENDO          $608.29\n",
       "             JCP                $132.04\n",
       "IHPARDINI    JCP                 $26.81\n",
       "ITAUUNIBANCO DIVIDENDO           $44.78\n",
       "             JCP                 $56.00\n",
       "LOCAMERICA   JCP                 $36.00\n",
       "M.DIASBRANCO JCP                $369.19\n",
       "MOVIDA       JCP                  $6.52\n",
       "MRV          DIVIDENDO           $48.70\n",
       "PORTOSEGURO  DIVIDENDO          $607.98\n",
       "             JCP                $273.65\n",
       "SMILES       DIVIDENDO        $3,503.57\n",
       "             JCP                $321.30\n",
       "TRISUL       DIVIDENDO           $72.56"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "g = df.groupby(['Ativo', 'Evento']).sum()\n",
    "display(g)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "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></th>\n",
       "      <th>Profit</th>\n",
       "      <th>AMOUNT</th>\n",
       "      <th>AcumLoss</th>\n",
       "      <th>Taxable</th>\n",
       "      <th>Tax</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Year</th>\n",
       "      <th>Month</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">2018</th>\n",
       "      <th>March</th>\n",
       "      <td>$10.15</td>\n",
       "      <td>$1,894.00</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$10.15</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>April</th>\n",
       "      <td>$215.05</td>\n",
       "      <td>$6,550.00</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$215.05</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>November</th>\n",
       "      <td>$1,211.07</td>\n",
       "      <td>$2,858.40</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$1,211.07</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">2020</th>\n",
       "      <th>January</th>\n",
       "      <td>$9,819.70</td>\n",
       "      <td>$19,994.85</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$9,819.70</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>June</th>\n",
       "      <td>$3,873.37</td>\n",
       "      <td>$18,396.00</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$3,873.37</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>July</th>\n",
       "      <td>$1,698.35</td>\n",
       "      <td>$5,510.75</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$1,698.35</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">2021</th>\n",
       "      <th>May</th>\n",
       "      <td>$837.52</td>\n",
       "      <td>$4,396.50</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$837.52</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>June</th>\n",
       "      <td>$4,224.91</td>\n",
       "      <td>$36,379.33</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$4,224.91</td>\n",
       "      <td>$844.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>July</th>\n",
       "      <td>$6,038.13</td>\n",
       "      <td>$19,030.00</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$6,038.13</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>August</th>\n",
       "      <td>$333.07</td>\n",
       "      <td>$867.28</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$333.07</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>November</th>\n",
       "      <td>$2,820.57</td>\n",
       "      <td>$10,835.00</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$2,820.57</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">2022</th>\n",
       "      <th>April</th>\n",
       "      <td>$57.44</td>\n",
       "      <td>$10,783.92</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$57.44</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>May</th>\n",
       "      <td>$1,171.57</td>\n",
       "      <td>$2,903.00</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$1,171.57</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>July</th>\n",
       "      <td>$-0.00</td>\n",
       "      <td>$16,302.75</td>\n",
       "      <td>$-0.00</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>August</th>\n",
       "      <td>$-1,397.06</td>\n",
       "      <td>$26,947.68</td>\n",
       "      <td>$-1,397.06</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>September</th>\n",
       "      <td>$2,856.56</td>\n",
       "      <td>$19,575.00</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$1,459.50</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>October</th>\n",
       "      <td>$5,244.23</td>\n",
       "      <td>$30,116.00</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$5,244.23</td>\n",
       "      <td>$1,048.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>November</th>\n",
       "      <td>$2,890.67</td>\n",
       "      <td>$17,662.00</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$2,890.67</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023</th>\n",
       "      <th>January</th>\n",
       "      <td>$-54,197.66</td>\n",
       "      <td>$88,985.74</td>\n",
       "      <td>$-54,197.66</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Profit     AMOUNT    AcumLoss   Taxable       Tax\n",
       "Year Month                                                           \n",
       "2018 March          $10.15  $1,894.00       $0.00    $10.15     $0.00\n",
       "     April         $215.05  $6,550.00       $0.00   $215.05     $0.00\n",
       "     November    $1,211.07  $2,858.40       $0.00 $1,211.07     $0.00\n",
       "2020 January     $9,819.70 $19,994.85       $0.00 $9,819.70     $0.00\n",
       "     June        $3,873.37 $18,396.00       $0.00 $3,873.37     $0.00\n",
       "     July        $1,698.35  $5,510.75       $0.00 $1,698.35     $0.00\n",
       "2021 May           $837.52  $4,396.50       $0.00   $837.52     $0.00\n",
       "     June        $4,224.91 $36,379.33       $0.00 $4,224.91   $844.98\n",
       "     July        $6,038.13 $19,030.00       $0.00 $6,038.13     $0.00\n",
       "     August        $333.07    $867.28       $0.00   $333.07     $0.00\n",
       "     November    $2,820.57 $10,835.00       $0.00 $2,820.57     $0.00\n",
       "2022 April          $57.44 $10,783.92       $0.00    $57.44     $0.00\n",
       "     May         $1,171.57  $2,903.00       $0.00 $1,171.57     $0.00\n",
       "     July           $-0.00 $16,302.75      $-0.00     $0.00     $0.00\n",
       "     August     $-1,397.06 $26,947.68  $-1,397.06     $0.00     $0.00\n",
       "     September   $2,856.56 $19,575.00       $0.00 $1,459.50     $0.00\n",
       "     October     $5,244.23 $30,116.00       $0.00 $5,244.23 $1,048.85\n",
       "     November    $2,890.67 $17,662.00       $0.00 $2,890.67     $0.00\n",
       "2023 January   $-54,197.66 $88,985.74 $-54,197.66     $0.00     $0.00"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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></th>\n",
       "      <th>Profit</th>\n",
       "      <th>AcumLoss</th>\n",
       "      <th>Taxable</th>\n",
       "      <th>Tax</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Year</th>\n",
       "      <th>Month</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2019</th>\n",
       "      <th>November</th>\n",
       "      <td>$19.00</td>\n",
       "      <td>0</td>\n",
       "      <td>$19.00</td>\n",
       "      <td>$3.80</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               Profit  AcumLoss  Taxable   Tax\n",
       "Year Month                                    \n",
       "2019 November  $19.00         0   $19.00 $3.80"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "tx = Taxation(csv)\n",
    "tx.Process('Ação')\n",
    "display(tx.swingTradeTable)\n",
    "display(tx.dayTradeTable)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "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></th>\n",
       "      <th>Profit</th>\n",
       "      <th>AMOUNT</th>\n",
       "      <th>AcumLoss</th>\n",
       "      <th>Taxable</th>\n",
       "      <th>Tax</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Year</th>\n",
       "      <th>Month</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">2018</th>\n",
       "      <th>May</th>\n",
       "      <td>$126.45</td>\n",
       "      <td>$11,111.47</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$126.45</td>\n",
       "      <td>$25.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>June</th>\n",
       "      <td>$1.51</td>\n",
       "      <td>$2,004.80</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$1.51</td>\n",
       "      <td>$0.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>September</th>\n",
       "      <td>$-5,072.77</td>\n",
       "      <td>$8,600.05</td>\n",
       "      <td>$-5,072.77</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">2019</th>\n",
       "      <th>April</th>\n",
       "      <td>$807.86</td>\n",
       "      <td>$15,894.00</td>\n",
       "      <td>$-4,264.92</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>July</th>\n",
       "      <td>$4,412.68</td>\n",
       "      <td>$19,500.06</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$147.76</td>\n",
       "      <td>$29.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021</th>\n",
       "      <th>November</th>\n",
       "      <td>$-1,048.49</td>\n",
       "      <td>$3,073.00</td>\n",
       "      <td>$-1,048.49</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">2022</th>\n",
       "      <th>April</th>\n",
       "      <td>$-3,055.47</td>\n",
       "      <td>$9,551.83</td>\n",
       "      <td>$-4,103.96</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>August</th>\n",
       "      <td>$88.41</td>\n",
       "      <td>$6,478.92</td>\n",
       "      <td>$-4,015.55</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>September</th>\n",
       "      <td>$-32.02</td>\n",
       "      <td>$848.00</td>\n",
       "      <td>$-4,047.57</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023</th>\n",
       "      <th>January</th>\n",
       "      <td>$-17,986.50</td>\n",
       "      <td>$56,842.13</td>\n",
       "      <td>$-22,034.07</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Profit     AMOUNT    AcumLoss  Taxable    Tax\n",
       "Year Month                                                       \n",
       "2018 May           $126.45 $11,111.47       $0.00  $126.45 $25.29\n",
       "     June            $1.51  $2,004.80       $0.00    $1.51  $0.30\n",
       "     September  $-5,072.77  $8,600.05  $-5,072.77    $0.00  $0.00\n",
       "2019 April         $807.86 $15,894.00  $-4,264.92    $0.00  $0.00\n",
       "     July        $4,412.68 $19,500.06       $0.00  $147.76 $29.55\n",
       "2021 November   $-1,048.49  $3,073.00  $-1,048.49    $0.00  $0.00\n",
       "2022 April      $-3,055.47  $9,551.83  $-4,103.96    $0.00  $0.00\n",
       "     August         $88.41  $6,478.92  $-4,015.55    $0.00  $0.00\n",
       "     September     $-32.02    $848.00  $-4,047.57    $0.00  $0.00\n",
       "2023 January   $-17,986.50 $56,842.13 $-22,034.07    $0.00  $0.00"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "tx = Taxation(csv)\n",
    "tx.Process('FII')\n",
    "display(tx.swingTradeTable)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.8.10 64-bit",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.6"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "31f2aee4e71d21fbe5cf8b01ff0e069b9275f58929596ceb00d14d90e3e16cd6"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}