research.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "from datetime import datetime, timedelta\n",
    "from tinkoff.invest import Client, CandleInterval\n",
    "from decimal import Decimal"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "token = 'ваш тиньков токен (api 2.0)'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "def units_nano_convert(d):\n",
    "    # https://github.com/Tinkoff/invest-python/issues/45\n",
    "    nano = d['nano'] / Decimal(\"10e8\")\n",
    "    price = d['units'] + float(nano)\n",
    "    return price"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Берём все тикеты IMOEX отсюда\n",
    "table = pd.read_html('https://www.tinkoff.ru/invest/etfs/TMOS/structure/details/')      \n",
    "\n",
    "df = table[0]\n",
    "df = df.rename(columns={'Название': 'name'})\n",
    "df = df[df['name'] != 'Денежные средстваВалюта']\n",
    "df['name'] = df['name'].str[:-5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "with Client(token) as client:\n",
    "    shares = client.instruments.shares()\n",
    "\n",
    "all_stocks = pd.DataFrame(shares.instruments)\n",
    "\n",
    "df = pd.merge(df, all_stocks, how='left', on='name', sort=True)\n",
    "\n",
    "df['min_price_increment'] = df['min_price_increment'].apply(units_nano_convert) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Текущие цены акций\n",
    "with Client(token) as client:\n",
    "    last_prices = client.market_data.get_last_prices(figi=df['figi'].to_list())\n",
    "\n",
    "last_prices = pd.DataFrame(last_prices.last_prices)\n",
    "\n",
    "last_prices['price'] = last_prices['price'].apply(units_nano_convert)\n",
    "\n",
    "\n",
    "df = last_prices.merge(df, on='figi')\n",
    "\n",
    "df = df[['name', 'ticker', 'figi', 'lot', 'price', 'min_price_increment', 'currency']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df[df['currency'] != 'usd']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Считаем для стартового капитала в 10 тыс рублей\n",
    "capital = 10000\n",
    "\n",
    "df['lot_price'] = df['lot'] * df['price']\n",
    "df['shares_available'] = capital // df['lot_price']\n",
    "df['profit'] = df['shares_available']  * df['min_price_increment'] * df['lot']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.sort_values(by=['profit'], ascending=False)\n",
    "df.index = np.arange(1, len(df) + 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>ticker</th>\n",
       "      <th>figi</th>\n",
       "      <th>lot</th>\n",
       "      <th>price</th>\n",
       "      <th>min_price_increment</th>\n",
       "      <th>currency</th>\n",
       "      <th>lot_price</th>\n",
       "      <th>shares_available</th>\n",
       "      <th>profit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>En+ Group</td>\n",
       "      <td>ENPG</td>\n",
       "      <td>BBG000RMWQD4</td>\n",
       "      <td>1</td>\n",
       "      <td>688.00000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>rub</td>\n",
       "      <td>688.00</td>\n",
       "      <td>14.0</td>\n",
       "      <td>7.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Аэрофлот</td>\n",
       "      <td>AFLT</td>\n",
       "      <td>BBG004S683W7</td>\n",
       "      <td>10</td>\n",
       "      <td>30.62000</td>\n",
       "      <td>0.020000</td>\n",
       "      <td>rub</td>\n",
       "      <td>306.20</td>\n",
       "      <td>32.0</td>\n",
       "      <td>6.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Petropavlovsk PLC</td>\n",
       "      <td>POGR</td>\n",
       "      <td>BBG00VPKLPX4</td>\n",
       "      <td>100</td>\n",
       "      <td>8.13500</td>\n",
       "      <td>0.005000</td>\n",
       "      <td>rub</td>\n",
       "      <td>813.50</td>\n",
       "      <td>12.0</td>\n",
       "      <td>6.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ozon Holdings PLC</td>\n",
       "      <td>OZON</td>\n",
       "      <td>BBG00Y91R9T3</td>\n",
       "      <td>1</td>\n",
       "      <td>1000.00000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>rub</td>\n",
       "      <td>1000.00</td>\n",
       "      <td>10.0</td>\n",
       "      <td>5.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>VK</td>\n",
       "      <td>VKCO</td>\n",
       "      <td>BBG00178PGX3</td>\n",
       "      <td>1</td>\n",
       "      <td>416.80000</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>rub</td>\n",
       "      <td>416.80</td>\n",
       "      <td>23.0</td>\n",
       "      <td>4.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>ГДР X5 RetailGroup</td>\n",
       "      <td>FIVE</td>\n",
       "      <td>BBG00JXPFBN0</td>\n",
       "      <td>1</td>\n",
       "      <td>1107.50000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>rub</td>\n",
       "      <td>1107.50</td>\n",
       "      <td>9.0</td>\n",
       "      <td>4.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Татнефть - привилегированные акции</td>\n",
       "      <td>TATNP</td>\n",
       "      <td>BBG004S68829</td>\n",
       "      <td>1</td>\n",
       "      <td>310.40000</td>\n",
       "      <td>0.100000</td>\n",
       "      <td>rub</td>\n",
       "      <td>310.40</td>\n",
       "      <td>32.0</td>\n",
       "      <td>3.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Татнефть</td>\n",
       "      <td>TATN</td>\n",
       "      <td>BBG004RVFFC0</td>\n",
       "      <td>1</td>\n",
       "      <td>359.70000</td>\n",
       "      <td>0.100000</td>\n",
       "      <td>rub</td>\n",
       "      <td>359.70</td>\n",
       "      <td>27.0</td>\n",
       "      <td>2.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Банк ВТБ</td>\n",
       "      <td>VTBR</td>\n",
       "      <td>BBG004730ZJ9</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.01881</td>\n",
       "      <td>0.000005</td>\n",
       "      <td>rub</td>\n",
       "      <td>188.10</td>\n",
       "      <td>53.0</td>\n",
       "      <td>2.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Fix Price Group</td>\n",
       "      <td>FIXP</td>\n",
       "      <td>BBG00ZHCX1X2</td>\n",
       "      <td>1</td>\n",
       "      <td>383.20000</td>\n",
       "      <td>0.100000</td>\n",
       "      <td>rub</td>\n",
       "      <td>383.20</td>\n",
       "      <td>26.0</td>\n",
       "      <td>2.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Детский Мир</td>\n",
       "      <td>DSKY</td>\n",
       "      <td>BBG000BN56Q9</td>\n",
       "      <td>10</td>\n",
       "      <td>74.00000</td>\n",
       "      <td>0.020000</td>\n",
       "      <td>rub</td>\n",
       "      <td>740.00</td>\n",
       "      <td>13.0</td>\n",
       "      <td>2.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>МТС</td>\n",
       "      <td>MTSS</td>\n",
       "      <td>BBG004S681W1</td>\n",
       "      <td>10</td>\n",
       "      <td>188.05000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>rub</td>\n",
       "      <td>1880.50</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Интер РАО ЕЭС</td>\n",
       "      <td>IRAO</td>\n",
       "      <td>BBG004S68473</td>\n",
       "      <td>100</td>\n",
       "      <td>2.43000</td>\n",
       "      <td>0.000500</td>\n",
       "      <td>rub</td>\n",
       "      <td>243.00</td>\n",
       "      <td>41.0</td>\n",
       "      <td>2.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>ФСК ЕЭС</td>\n",
       "      <td>FEES</td>\n",
       "      <td>BBG00475JZZ6</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.09448</td>\n",
       "      <td>0.000020</td>\n",
       "      <td>rub</td>\n",
       "      <td>944.80</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>НОВАТЭК</td>\n",
       "      <td>NVTK</td>\n",
       "      <td>BBG00475KKY8</td>\n",
       "      <td>1</td>\n",
       "      <td>970.20000</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>rub</td>\n",
       "      <td>970.20</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Сургутнефтегаз</td>\n",
       "      <td>SNGS</td>\n",
       "      <td>BBG0047315D0</td>\n",
       "      <td>100</td>\n",
       "      <td>22.69000</td>\n",
       "      <td>0.005000</td>\n",
       "      <td>rub</td>\n",
       "      <td>2269.00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>МКБ</td>\n",
       "      <td>CBOM</td>\n",
       "      <td>BBG009GSYN76</td>\n",
       "      <td>100</td>\n",
       "      <td>4.76300</td>\n",
       "      <td>0.001000</td>\n",
       "      <td>rub</td>\n",
       "      <td>476.30</td>\n",
       "      <td>20.0</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>TCS Group</td>\n",
       "      <td>TCSG</td>\n",
       "      <td>BBG00QPYJ5H0</td>\n",
       "      <td>1</td>\n",
       "      <td>2270.00000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>rub</td>\n",
       "      <td>2270.00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Северсталь</td>\n",
       "      <td>CHMF</td>\n",
       "      <td>BBG00475K6C3</td>\n",
       "      <td>1</td>\n",
       "      <td>1061.80000</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>rub</td>\n",
       "      <td>1061.80</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>ПИК</td>\n",
       "      <td>PIKK</td>\n",
       "      <td>BBG004S68BH6</td>\n",
       "      <td>1</td>\n",
       "      <td>550.00000</td>\n",
       "      <td>0.100000</td>\n",
       "      <td>rub</td>\n",
       "      <td>550.00</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Ростелеком</td>\n",
       "      <td>RTKM</td>\n",
       "      <td>BBG004S682Z6</td>\n",
       "      <td>10</td>\n",
       "      <td>57.90000</td>\n",
       "      <td>0.010000</td>\n",
       "      <td>rub</td>\n",
       "      <td>579.00</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Globaltrans Investment PLC</td>\n",
       "      <td>GLTR</td>\n",
       "      <td>BBG000VFX6Y4</td>\n",
       "      <td>1</td>\n",
       "      <td>318.60000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>rub</td>\n",
       "      <td>318.60</td>\n",
       "      <td>31.0</td>\n",
       "      <td>1.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Сургутнефтегаз - привилегированные акции</td>\n",
       "      <td>SNGSP</td>\n",
       "      <td>BBG004S681M2</td>\n",
       "      <td>100</td>\n",
       "      <td>32.57500</td>\n",
       "      <td>0.005000</td>\n",
       "      <td>rub</td>\n",
       "      <td>3257.50</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Роснефть</td>\n",
       "      <td>ROSN</td>\n",
       "      <td>BBG004731354</td>\n",
       "      <td>1</td>\n",
       "      <td>397.35000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>rub</td>\n",
       "      <td>397.35</td>\n",
       "      <td>25.0</td>\n",
       "      <td>1.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Polymetal</td>\n",
       "      <td>POLY</td>\n",
       "      <td>BBG004PYF2N3</td>\n",
       "      <td>1</td>\n",
       "      <td>775.00000</td>\n",
       "      <td>0.100000</td>\n",
       "      <td>rub</td>\n",
       "      <td>775.00</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>РусГидро</td>\n",
       "      <td>HYDR</td>\n",
       "      <td>BBG00475K2X9</td>\n",
       "      <td>1000</td>\n",
       "      <td>0.77470</td>\n",
       "      <td>0.000100</td>\n",
       "      <td>rub</td>\n",
       "      <td>774.70</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>АЛРОСА</td>\n",
       "      <td>ALRS</td>\n",
       "      <td>BBG004S68B31</td>\n",
       "      <td>10</td>\n",
       "      <td>80.11000</td>\n",
       "      <td>0.010000</td>\n",
       "      <td>rub</td>\n",
       "      <td>801.10</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>НЛМК</td>\n",
       "      <td>NLMK</td>\n",
       "      <td>BBG004S681B4</td>\n",
       "      <td>10</td>\n",
       "      <td>155.86000</td>\n",
       "      <td>0.020000</td>\n",
       "      <td>rub</td>\n",
       "      <td>1558.60</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Магнитогорский металлургический комбинат</td>\n",
       "      <td>MAGN</td>\n",
       "      <td>BBG004S68507</td>\n",
       "      <td>10</td>\n",
       "      <td>42.00000</td>\n",
       "      <td>0.005000</td>\n",
       "      <td>rub</td>\n",
       "      <td>420.00</td>\n",
       "      <td>23.0</td>\n",
       "      <td>1.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Московская Биржа</td>\n",
       "      <td>MOEX</td>\n",
       "      <td>BBG004730JJ5</td>\n",
       "      <td>10</td>\n",
       "      <td>90.05000</td>\n",
       "      <td>0.010000</td>\n",
       "      <td>rub</td>\n",
       "      <td>900.50</td>\n",
       "      <td>11.0</td>\n",
       "      <td>1.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Магнит</td>\n",
       "      <td>MGNT</td>\n",
       "      <td>BBG004RVFCY3</td>\n",
       "      <td>1</td>\n",
       "      <td>4170.00000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>rub</td>\n",
       "      <td>4170.00</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>ЛУКОЙЛ</td>\n",
       "      <td>LKOH</td>\n",
       "      <td>BBG004731032</td>\n",
       "      <td>1</td>\n",
       "      <td>3828.00000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>rub</td>\n",
       "      <td>3828.00</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Yandex</td>\n",
       "      <td>YNDX</td>\n",
       "      <td>BBG006L8G4H1</td>\n",
       "      <td>1</td>\n",
       "      <td>1692.00000</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>rub</td>\n",
       "      <td>1692.00</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>ФосАгро</td>\n",
       "      <td>PHOR</td>\n",
       "      <td>BBG004S689R0</td>\n",
       "      <td>1</td>\n",
       "      <td>7000.00000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>rub</td>\n",
       "      <td>7000.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Сбер Банк</td>\n",
       "      <td>SBER</td>\n",
       "      <td>BBG004730N88</td>\n",
       "      <td>10</td>\n",
       "      <td>116.97000</td>\n",
       "      <td>0.010000</td>\n",
       "      <td>rub</td>\n",
       "      <td>1169.70</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Сбер Банк - привилегированные акции</td>\n",
       "      <td>SBERP</td>\n",
       "      <td>BBG0047315Y7</td>\n",
       "      <td>10</td>\n",
       "      <td>123.27000</td>\n",
       "      <td>0.010000</td>\n",
       "      <td>rub</td>\n",
       "      <td>1232.70</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>АФК Система</td>\n",
       "      <td>AFKS</td>\n",
       "      <td>BBG004S68614</td>\n",
       "      <td>100</td>\n",
       "      <td>12.30000</td>\n",
       "      <td>0.001000</td>\n",
       "      <td>rub</td>\n",
       "      <td>1230.00</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>РУСАЛ</td>\n",
       "      <td>RUAL</td>\n",
       "      <td>BBG008F2T3T2</td>\n",
       "      <td>10</td>\n",
       "      <td>64.89500</td>\n",
       "      <td>0.005000</td>\n",
       "      <td>rub</td>\n",
       "      <td>648.95</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Газпром</td>\n",
       "      <td>GAZP</td>\n",
       "      <td>BBG004730RP0</td>\n",
       "      <td>10</td>\n",
       "      <td>208.00000</td>\n",
       "      <td>0.010000</td>\n",
       "      <td>rub</td>\n",
       "      <td>2080.00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Полюс Золото</td>\n",
       "      <td>PLZL</td>\n",
       "      <td>BBG000R607Y3</td>\n",
       "      <td>1</td>\n",
       "      <td>13400.00000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>rub</td>\n",
       "      <td>13400.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Норильский никель</td>\n",
       "      <td>GMKN</td>\n",
       "      <td>BBG004731489</td>\n",
       "      <td>1</td>\n",
       "      <td>19700.00000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>rub</td>\n",
       "      <td>19700.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Транснефть - привилегированные акции</td>\n",
       "      <td>TRNFP</td>\n",
       "      <td>BBG00475KHX6</td>\n",
       "      <td>1</td>\n",
       "      <td>108150.00000</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>rub</td>\n",
       "      <td>108150.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        name ticker          figi    lot  \\\n",
       "1                                  En+ Group   ENPG  BBG000RMWQD4      1   \n",
       "2                                   Аэрофлот   AFLT  BBG004S683W7     10   \n",
       "3                          Petropavlovsk PLC   POGR  BBG00VPKLPX4    100   \n",
       "4                          Ozon Holdings PLC   OZON  BBG00Y91R9T3      1   \n",
       "5                                         VK   VKCO  BBG00178PGX3      1   \n",
       "6                         ГДР X5 RetailGroup   FIVE  BBG00JXPFBN0      1   \n",
       "7         Татнефть - привилегированные акции  TATNP  BBG004S68829      1   \n",
       "8                                   Татнефть   TATN  BBG004RVFFC0      1   \n",
       "9                                   Банк ВТБ   VTBR  BBG004730ZJ9  10000   \n",
       "10                           Fix Price Group   FIXP  BBG00ZHCX1X2      1   \n",
       "11                               Детский Мир   DSKY  BBG000BN56Q9     10   \n",
       "12                                       МТС   MTSS  BBG004S681W1     10   \n",
       "13                             Интер РАО ЕЭС   IRAO  BBG004S68473    100   \n",
       "14                                   ФСК ЕЭС   FEES  BBG00475JZZ6  10000   \n",
       "15                                   НОВАТЭК   NVTK  BBG00475KKY8      1   \n",
       "16                            Сургутнефтегаз   SNGS  BBG0047315D0    100   \n",
       "17                                       МКБ   CBOM  BBG009GSYN76    100   \n",
       "18                                 TCS Group   TCSG  BBG00QPYJ5H0      1   \n",
       "19                                Северсталь   CHMF  BBG00475K6C3      1   \n",
       "20                                       ПИК   PIKK  BBG004S68BH6      1   \n",
       "21                                Ростелеком   RTKM  BBG004S682Z6     10   \n",
       "22                Globaltrans Investment PLC   GLTR  BBG000VFX6Y4      1   \n",
       "23  Сургутнефтегаз - привилегированные акции  SNGSP  BBG004S681M2    100   \n",
       "24                                  Роснефть   ROSN  BBG004731354      1   \n",
       "25                                 Polymetal   POLY  BBG004PYF2N3      1   \n",
       "26                                  РусГидро   HYDR  BBG00475K2X9   1000   \n",
       "27                                    АЛРОСА   ALRS  BBG004S68B31     10   \n",
       "28                                      НЛМК   NLMK  BBG004S681B4     10   \n",
       "29  Магнитогорский металлургический комбинат   MAGN  BBG004S68507     10   \n",
       "30                          Московская Биржа   MOEX  BBG004730JJ5     10   \n",
       "31                                    Магнит   MGNT  BBG004RVFCY3      1   \n",
       "32                                    ЛУКОЙЛ   LKOH  BBG004731032      1   \n",
       "33                                    Yandex   YNDX  BBG006L8G4H1      1   \n",
       "34                                   ФосАгро   PHOR  BBG004S689R0      1   \n",
       "35                                 Сбер Банк   SBER  BBG004730N88     10   \n",
       "36       Сбер Банк - привилегированные акции  SBERP  BBG0047315Y7     10   \n",
       "37                               АФК Система   AFKS  BBG004S68614    100   \n",
       "38                                     РУСАЛ   RUAL  BBG008F2T3T2     10   \n",
       "39                                   Газпром   GAZP  BBG004730RP0     10   \n",
       "40                              Полюс Золото   PLZL  BBG000R607Y3      1   \n",
       "41                         Норильский никель   GMKN  BBG004731489      1   \n",
       "42      Транснефть - привилегированные акции  TRNFP  BBG00475KHX6      1   \n",
       "\n",
       "           price  min_price_increment currency  lot_price  shares_available  \\\n",
       "1      688.00000             0.500000      rub     688.00              14.0   \n",
       "2       30.62000             0.020000      rub     306.20              32.0   \n",
       "3        8.13500             0.005000      rub     813.50              12.0   \n",
       "4     1000.00000             0.500000      rub    1000.00              10.0   \n",
       "5      416.80000             0.200000      rub     416.80              23.0   \n",
       "6     1107.50000             0.500000      rub    1107.50               9.0   \n",
       "7      310.40000             0.100000      rub     310.40              32.0   \n",
       "8      359.70000             0.100000      rub     359.70              27.0   \n",
       "9        0.01881             0.000005      rub     188.10              53.0   \n",
       "10     383.20000             0.100000      rub     383.20              26.0   \n",
       "11      74.00000             0.020000      rub     740.00              13.0   \n",
       "12     188.05000             0.050000      rub    1880.50               5.0   \n",
       "13       2.43000             0.000500      rub     243.00              41.0   \n",
       "14       0.09448             0.000020      rub     944.80              10.0   \n",
       "15     970.20000             0.200000      rub     970.20              10.0   \n",
       "16      22.69000             0.005000      rub    2269.00               4.0   \n",
       "17       4.76300             0.001000      rub     476.30              20.0   \n",
       "18    2270.00000             0.500000      rub    2270.00               4.0   \n",
       "19    1061.80000             0.200000      rub    1061.80               9.0   \n",
       "20     550.00000             0.100000      rub     550.00              18.0   \n",
       "21      57.90000             0.010000      rub     579.00              17.0   \n",
       "22     318.60000             0.050000      rub     318.60              31.0   \n",
       "23      32.57500             0.005000      rub    3257.50               3.0   \n",
       "24     397.35000             0.050000      rub     397.35              25.0   \n",
       "25     775.00000             0.100000      rub     775.00              12.0   \n",
       "26       0.77470             0.000100      rub     774.70              12.0   \n",
       "27      80.11000             0.010000      rub     801.10              12.0   \n",
       "28     155.86000             0.020000      rub    1558.60               6.0   \n",
       "29      42.00000             0.005000      rub     420.00              23.0   \n",
       "30      90.05000             0.010000      rub     900.50              11.0   \n",
       "31    4170.00000             0.500000      rub    4170.00               2.0   \n",
       "32    3828.00000             0.500000      rub    3828.00               2.0   \n",
       "33    1692.00000             0.200000      rub    1692.00               5.0   \n",
       "34    7000.00000             1.000000      rub    7000.00               1.0   \n",
       "35     116.97000             0.010000      rub    1169.70               8.0   \n",
       "36     123.27000             0.010000      rub    1232.70               8.0   \n",
       "37      12.30000             0.001000      rub    1230.00               8.0   \n",
       "38      64.89500             0.005000      rub     648.95              15.0   \n",
       "39     208.00000             0.010000      rub    2080.00               4.0   \n",
       "40   13400.00000             0.500000      rub   13400.00               0.0   \n",
       "41   19700.00000             2.000000      rub   19700.00               0.0   \n",
       "42  108150.00000            50.000000      rub  108150.00               0.0   \n",
       "\n",
       "    profit  \n",
       "1     7.00  \n",
       "2     6.40  \n",
       "3     6.00  \n",
       "4     5.00  \n",
       "5     4.60  \n",
       "6     4.50  \n",
       "7     3.20  \n",
       "8     2.70  \n",
       "9     2.65  \n",
       "10    2.60  \n",
       "11    2.60  \n",
       "12    2.50  \n",
       "13    2.05  \n",
       "14    2.00  \n",
       "15    2.00  \n",
       "16    2.00  \n",
       "17    2.00  \n",
       "18    2.00  \n",
       "19    1.80  \n",
       "20    1.80  \n",
       "21    1.70  \n",
       "22    1.55  \n",
       "23    1.50  \n",
       "24    1.25  \n",
       "25    1.20  \n",
       "26    1.20  \n",
       "27    1.20  \n",
       "28    1.20  \n",
       "29    1.15  \n",
       "30    1.10  \n",
       "31    1.00  \n",
       "32    1.00  \n",
       "33    1.00  \n",
       "34    1.00  \n",
       "35    0.80  \n",
       "36    0.80  \n",
       "37    0.80  \n",
       "38    0.75  \n",
       "39    0.40  \n",
       "40    0.00  \n",
       "41    0.00  \n",
       "42    0.00  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "# https://ru.wikipedia.org/wiki/Голубые_фишки\n",
    "moexbc = ['GAZP', 'SBER', 'LKOH', 'MGNT', 'NVTK', 'SNGS', 'GMKN', \n",
    "          'ROSN', 'NLMK', 'TATN', 'MTSS', 'ALRS', 'YNDX', 'FIVE', 'CHMF']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>name</th>\n",
       "      <th>ticker</th>\n",
       "      <th>figi</th>\n",
       "      <th>lot</th>\n",
       "      <th>price</th>\n",
       "      <th>min_price_increment</th>\n",
       "      <th>currency</th>\n",
       "      <th>lot_price</th>\n",
       "      <th>shares_available</th>\n",
       "      <th>profit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>ГДР X5 RetailGroup</td>\n",
       "      <td>FIVE</td>\n",
       "      <td>BBG00JXPFBN0</td>\n",
       "      <td>1</td>\n",
       "      <td>1107.50</td>\n",
       "      <td>0.500</td>\n",
       "      <td>rub</td>\n",
       "      <td>1107.50</td>\n",
       "      <td>9.0</td>\n",
       "      <td>4.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Татнефть</td>\n",
       "      <td>TATN</td>\n",
       "      <td>BBG004RVFFC0</td>\n",
       "      <td>1</td>\n",
       "      <td>359.70</td>\n",
       "      <td>0.100</td>\n",
       "      <td>rub</td>\n",
       "      <td>359.70</td>\n",
       "      <td>27.0</td>\n",
       "      <td>2.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>МТС</td>\n",
       "      <td>MTSS</td>\n",
       "      <td>BBG004S681W1</td>\n",
       "      <td>10</td>\n",
       "      <td>188.05</td>\n",
       "      <td>0.050</td>\n",
       "      <td>rub</td>\n",
       "      <td>1880.50</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>НОВАТЭК</td>\n",
       "      <td>NVTK</td>\n",
       "      <td>BBG00475KKY8</td>\n",
       "      <td>1</td>\n",
       "      <td>970.20</td>\n",
       "      <td>0.200</td>\n",
       "      <td>rub</td>\n",
       "      <td>970.20</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Сургутнефтегаз</td>\n",
       "      <td>SNGS</td>\n",
       "      <td>BBG0047315D0</td>\n",
       "      <td>100</td>\n",
       "      <td>22.69</td>\n",
       "      <td>0.005</td>\n",
       "      <td>rub</td>\n",
       "      <td>2269.00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Северсталь</td>\n",
       "      <td>CHMF</td>\n",
       "      <td>BBG00475K6C3</td>\n",
       "      <td>1</td>\n",
       "      <td>1061.80</td>\n",
       "      <td>0.200</td>\n",
       "      <td>rub</td>\n",
       "      <td>1061.80</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Роснефть</td>\n",
       "      <td>ROSN</td>\n",
       "      <td>BBG004731354</td>\n",
       "      <td>1</td>\n",
       "      <td>397.35</td>\n",
       "      <td>0.050</td>\n",
       "      <td>rub</td>\n",
       "      <td>397.35</td>\n",
       "      <td>25.0</td>\n",
       "      <td>1.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>АЛРОСА</td>\n",
       "      <td>ALRS</td>\n",
       "      <td>BBG004S68B31</td>\n",
       "      <td>10</td>\n",
       "      <td>80.11</td>\n",
       "      <td>0.010</td>\n",
       "      <td>rub</td>\n",
       "      <td>801.10</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>НЛМК</td>\n",
       "      <td>NLMK</td>\n",
       "      <td>BBG004S681B4</td>\n",
       "      <td>10</td>\n",
       "      <td>155.86</td>\n",
       "      <td>0.020</td>\n",
       "      <td>rub</td>\n",
       "      <td>1558.60</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Магнит</td>\n",
       "      <td>MGNT</td>\n",
       "      <td>BBG004RVFCY3</td>\n",
       "      <td>1</td>\n",
       "      <td>4170.00</td>\n",
       "      <td>0.500</td>\n",
       "      <td>rub</td>\n",
       "      <td>4170.00</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>ЛУКОЙЛ</td>\n",
       "      <td>LKOH</td>\n",
       "      <td>BBG004731032</td>\n",
       "      <td>1</td>\n",
       "      <td>3828.00</td>\n",
       "      <td>0.500</td>\n",
       "      <td>rub</td>\n",
       "      <td>3828.00</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Yandex</td>\n",
       "      <td>YNDX</td>\n",
       "      <td>BBG006L8G4H1</td>\n",
       "      <td>1</td>\n",
       "      <td>1692.00</td>\n",
       "      <td>0.200</td>\n",
       "      <td>rub</td>\n",
       "      <td>1692.00</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Сбер Банк</td>\n",
       "      <td>SBER</td>\n",
       "      <td>BBG004730N88</td>\n",
       "      <td>10</td>\n",
       "      <td>116.97</td>\n",
       "      <td>0.010</td>\n",
       "      <td>rub</td>\n",
       "      <td>1169.70</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Газпром</td>\n",
       "      <td>GAZP</td>\n",
       "      <td>BBG004730RP0</td>\n",
       "      <td>10</td>\n",
       "      <td>208.00</td>\n",
       "      <td>0.010</td>\n",
       "      <td>rub</td>\n",
       "      <td>2080.00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Норильский никель</td>\n",
       "      <td>GMKN</td>\n",
       "      <td>BBG004731489</td>\n",
       "      <td>1</td>\n",
       "      <td>19700.00</td>\n",
       "      <td>2.000</td>\n",
       "      <td>rub</td>\n",
       "      <td>19700.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  name ticker          figi  lot     price  \\\n",
       "6   ГДР X5 RetailGroup   FIVE  BBG00JXPFBN0    1   1107.50   \n",
       "8             Татнефть   TATN  BBG004RVFFC0    1    359.70   \n",
       "12                 МТС   MTSS  BBG004S681W1   10    188.05   \n",
       "15             НОВАТЭК   NVTK  BBG00475KKY8    1    970.20   \n",
       "16      Сургутнефтегаз   SNGS  BBG0047315D0  100     22.69   \n",
       "19          Северсталь   CHMF  BBG00475K6C3    1   1061.80   \n",
       "24            Роснефть   ROSN  BBG004731354    1    397.35   \n",
       "27              АЛРОСА   ALRS  BBG004S68B31   10     80.11   \n",
       "28                НЛМК   NLMK  BBG004S681B4   10    155.86   \n",
       "31              Магнит   MGNT  BBG004RVFCY3    1   4170.00   \n",
       "32              ЛУКОЙЛ   LKOH  BBG004731032    1   3828.00   \n",
       "33              Yandex   YNDX  BBG006L8G4H1    1   1692.00   \n",
       "35           Сбер Банк   SBER  BBG004730N88   10    116.97   \n",
       "39             Газпром   GAZP  BBG004730RP0   10    208.00   \n",
       "41   Норильский никель   GMKN  BBG004731489    1  19700.00   \n",
       "\n",
       "    min_price_increment currency  lot_price  shares_available  profit  \n",
       "6                 0.500      rub    1107.50               9.0    4.50  \n",
       "8                 0.100      rub     359.70              27.0    2.70  \n",
       "12                0.050      rub    1880.50               5.0    2.50  \n",
       "15                0.200      rub     970.20              10.0    2.00  \n",
       "16                0.005      rub    2269.00               4.0    2.00  \n",
       "19                0.200      rub    1061.80               9.0    1.80  \n",
       "24                0.050      rub     397.35              25.0    1.25  \n",
       "27                0.010      rub     801.10              12.0    1.20  \n",
       "28                0.020      rub    1558.60               6.0    1.20  \n",
       "31                0.500      rub    4170.00               2.0    1.00  \n",
       "32                0.500      rub    3828.00               2.0    1.00  \n",
       "33                0.200      rub    1692.00               5.0    1.00  \n",
       "35                0.010      rub    1169.70               8.0    0.80  \n",
       "39                0.010      rub    2080.00               4.0    0.40  \n",
       "41                2.000      rub   19700.00               0.0    0.00  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['ticker'].isin(moexbc)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "191062.7"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Стоимость IMOEX, если купить всего по одному лоту\n",
    "df['lot_price'].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "43045.45"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Стоимость MOEXBC, если купить всего по одному лоту\n",
    "df[df['ticker'].isin(moexbc)]['lot_price'].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('data.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "# # таблица в виде изображения\n",
    "# # https://stackoverflow.com/a/39358752/10418812\n",
    "\n",
    "# import pandas as pd\n",
    "# import numpy as np\n",
    "# import matplotlib.pyplot as plt\n",
    "# import six\n",
    "\n",
    "# df_print = df.copy()\n",
    "\n",
    "# df_print = df_print[['name', 'ticker', 'min_price_increment', 'lot', 'price', 'shares_available', 'profit']]\n",
    "# df_print['name'] = df_print['name'].apply(lambda x: x.replace('привилегированные', 'прив'))\n",
    "# df_print['name'] = df_print['name'].apply(lambda x: x[:23])\n",
    "# df_print['shares_available'] = df_print['shares_available'].astype(int)\n",
    "# df_print['profit'] = df_print['profit'].round(5)\n",
    "# cols = df_print.columns.to_list()\n",
    "# df_print['N'] = df_print.index\n",
    "# df_print = df_print[['N'] + cols]\n",
    "# df_print.columns = ['Номер', 'Название', 'Тикет', 'Шаг цены', 'Кол-во акций в лоте', 'Цена', 'Кол-во акций', 'Прибыль за один шаг']\n",
    "\n",
    "# def render_mpl_table(data, col_width=3.0, row_height=0.625, font_size=14,\n",
    "#                      header_color='#40466e', row_colors=['#f1f1f2', 'w'], edge_color='w',\n",
    "#                      bbox=[0, 0, 1, 1], header_columns=0,\n",
    "#                      ax=None, **kwargs):\n",
    "#     if ax is None:\n",
    "#         size = (np.array(data.shape[::-1]) + np.array([0, 1])) * np.array([col_width, row_height])\n",
    "#         fig, ax = plt.subplots(figsize=size)\n",
    "#         ax.axis('off')\n",
    "\n",
    "#     mpl_table = ax.table(cellText=data.values, bbox=bbox, colLabels=data.columns, **kwargs)\n",
    "\n",
    "#     mpl_table.auto_set_font_size(False)\n",
    "#     mpl_table.set_fontsize(font_size)\n",
    "\n",
    "#     for k, cell in six.iteritems(mpl_table._cells):\n",
    "#         cell.set_edgecolor(edge_color)\n",
    "#         if k[0] == 0 or k[1] < header_columns:\n",
    "#             cell.set_text_props(weight='bold', color='w')\n",
    "#             cell.set_facecolor(header_color)\n",
    "#         else:\n",
    "#             cell.set_facecolor(row_colors[k[0]%len(row_colors) ])\n",
    "            \n",
    "#     return ax\n",
    "\n",
    "# render_mpl_table(df_print, header_columns=0, col_width=3.7)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}