Ações_Analises6.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Ações_Analises6.ipynb",
      "provenance": [],
      "authorship_tag": "ABX9TyO7IUXPQZz80RrTgni/LT1k",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/fonsecajr/Projects/blob/master/A%C3%A7%C3%B5es_Analises6.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Q6f6n-3TMCp_",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import pandas as pd\n",
        "import numpy as nd\n",
        "import string\n",
        "import warnings\n",
        "warnings.filterwarnings('ignore')"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "C82F-c7wMsiT",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "url = 'https://www.fundamentus.com.br/resultado.php'\n",
        "df = pd.read_html(url)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "pA3D3jO2NKMd",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 33
        },
        "outputId": "1c6e7af7-d9d3-42b9-9cbc-ee79bf86505c"
      },
      "source": [
        "list(df)\n",
        "type(df)"
      ],
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "list"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "8UKIXlCbNfaP",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 245
        },
        "outputId": "fdfb8dbc-dd3a-42ab-9caf-8d1d2df9b17e"
      },
      "source": [
        "df"
      ],
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[     Papel  Cotação      P/L  ...       Patrim. Líq  Dív.Brut/ Patrim. Cresc. Rec.5a\n",
              " 0    VNET3      0.0  0.00000  ...   9.257.250.00000                0.0        -2,71%\n",
              " 1    CFLU4      1.0  0.00000  ...      60.351.00000                6.0         8,14%\n",
              " 2    CLAN3      0.0  0.00000  ...   1.012.240.00000                0.0       -63,96%\n",
              " 3    CLSC6      0.0  0.00000  ...   1.551.160.00000                0.0         6,66%\n",
              " 4    CSTB3  15000.0  0.00000  ...   8.420.670.00000               14.0        31,91%\n",
              " ..     ...      ...      ...  ...               ...                ...           ...\n",
              " 880  CEPE6   2000.0  1.54585  ...   1.667.000.00000              336.0         8,63%\n",
              " 881  CEPE3   2453.0  1.89599  ...   1.667.000.00000              336.0         8,63%\n",
              " 882  CEPE5   2511.0  1.94081  ...   1.667.000.00000              336.0         8,63%\n",
              " 883  BRAP3   3311.0  2.04316  ...  10.522.400.00000                0.0         0,00%\n",
              " 884  BRAP4   3659.0  2.25790  ...  10.522.400.00000                0.0         0,00%\n",
              " \n",
              " [885 rows x 21 columns]]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 4
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "wUBZ10bcNuai",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 427
        },
        "outputId": "bbc7c915-9f0f-43bc-c7a0-f984438ba8d1"
      },
      "source": [
        "df[0]"
      ],
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Papel</th>\n",
              "      <th>Cotação</th>\n",
              "      <th>P/L</th>\n",
              "      <th>P/VP</th>\n",
              "      <th>PSR</th>\n",
              "      <th>Div.Yield</th>\n",
              "      <th>P/Ativo</th>\n",
              "      <th>P/Cap.Giro</th>\n",
              "      <th>P/EBIT</th>\n",
              "      <th>P/Ativ Circ.Liq</th>\n",
              "      <th>EV/EBIT</th>\n",
              "      <th>EV/EBITDA</th>\n",
              "      <th>Mrg Ebit</th>\n",
              "      <th>Mrg. Líq.</th>\n",
              "      <th>Liq. Corr.</th>\n",
              "      <th>ROIC</th>\n",
              "      <th>ROE</th>\n",
              "      <th>Liq.2meses</th>\n",
              "      <th>Patrim. Líq</th>\n",
              "      <th>Dív.Brut/ Patrim.</th>\n",
              "      <th>Cresc. Rec.5a</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>VNET3</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0,00%</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0,00%</td>\n",
              "      <td>0,00%</td>\n",
              "      <td>0</td>\n",
              "      <td>0,00%</td>\n",
              "      <td>12,99%</td>\n",
              "      <td>000</td>\n",
              "      <td>9.257.250.00000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>-2,71%</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>CFLU4</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0,00%</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>8,88%</td>\n",
              "      <td>10,72%</td>\n",
              "      <td>110</td>\n",
              "      <td>17,68%</td>\n",
              "      <td>32,15%</td>\n",
              "      <td>000</td>\n",
              "      <td>60.351.00000</td>\n",
              "      <td>6.0</td>\n",
              "      <td>8,14%</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>CLAN3</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0,00%</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0,00%</td>\n",
              "      <td>0,00%</td>\n",
              "      <td>0</td>\n",
              "      <td>0,00%</td>\n",
              "      <td>-1,05%</td>\n",
              "      <td>000</td>\n",
              "      <td>1.012.240.00000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>-63,96%</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>CLSC6</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0,00%</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0,00%</td>\n",
              "      <td>0,00%</td>\n",
              "      <td>0</td>\n",
              "      <td>0,00%</td>\n",
              "      <td>22,88%</td>\n",
              "      <td>000</td>\n",
              "      <td>1.551.160.00000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>6,66%</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>CSTB3</td>\n",
              "      <td>15000.0</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0,00%</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>40,85%</td>\n",
              "      <td>28,98%</td>\n",
              "      <td>260</td>\n",
              "      <td>22,40%</td>\n",
              "      <td>20,11%</td>\n",
              "      <td>000</td>\n",
              "      <td>8.420.670.00000</td>\n",
              "      <td>14.0</td>\n",
              "      <td>31,91%</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>880</th>\n",
              "      <td>CEPE6</td>\n",
              "      <td>2000.0</td>\n",
              "      <td>1.54585</td>\n",
              "      <td>90.0</td>\n",
              "      <td>-18326.0</td>\n",
              "      <td>3,46%</td>\n",
              "      <td>167.0</td>\n",
              "      <td>-971.0</td>\n",
              "      <td>7138.0</td>\n",
              "      <td>-33.0</td>\n",
              "      <td>30999.0</td>\n",
              "      <td>25658.0</td>\n",
              "      <td>-25,67%</td>\n",
              "      <td>-1,19%</td>\n",
              "      <td>95</td>\n",
              "      <td>0,27%</td>\n",
              "      <td>0,06%</td>\n",
              "      <td>45000</td>\n",
              "      <td>1.667.000.00000</td>\n",
              "      <td>336.0</td>\n",
              "      <td>8,63%</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>881</th>\n",
              "      <td>CEPE3</td>\n",
              "      <td>2453.0</td>\n",
              "      <td>1.89599</td>\n",
              "      <td>110.0</td>\n",
              "      <td>-22477.0</td>\n",
              "      <td>0,00%</td>\n",
              "      <td>204.0</td>\n",
              "      <td>-1191.0</td>\n",
              "      <td>8755.0</td>\n",
              "      <td>-41.0</td>\n",
              "      <td>32616.0</td>\n",
              "      <td>26996.0</td>\n",
              "      <td>-25,67%</td>\n",
              "      <td>-1,19%</td>\n",
              "      <td>95</td>\n",
              "      <td>0,27%</td>\n",
              "      <td>0,06%</td>\n",
              "      <td>000</td>\n",
              "      <td>1.667.000.00000</td>\n",
              "      <td>336.0</td>\n",
              "      <td>8,63%</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>882</th>\n",
              "      <td>CEPE5</td>\n",
              "      <td>2511.0</td>\n",
              "      <td>1.94081</td>\n",
              "      <td>112.0</td>\n",
              "      <td>-23008.0</td>\n",
              "      <td>2,51%</td>\n",
              "      <td>209.0</td>\n",
              "      <td>-1219.0</td>\n",
              "      <td>8962.0</td>\n",
              "      <td>-42.0</td>\n",
              "      <td>32823.0</td>\n",
              "      <td>27168.0</td>\n",
              "      <td>-25,67%</td>\n",
              "      <td>-1,19%</td>\n",
              "      <td>95</td>\n",
              "      <td>0,27%</td>\n",
              "      <td>0,06%</td>\n",
              "      <td>000</td>\n",
              "      <td>1.667.000.00000</td>\n",
              "      <td>336.0</td>\n",
              "      <td>8,63%</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>883</th>\n",
              "      <td>BRAP3</td>\n",
              "      <td>3311.0</td>\n",
              "      <td>2.04316</td>\n",
              "      <td>110.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2,19%</td>\n",
              "      <td>1045.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>-65976.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>-66124.0</td>\n",
              "      <td>-66124.0</td>\n",
              "      <td>0,00%</td>\n",
              "      <td>0,00%</td>\n",
              "      <td>0</td>\n",
              "      <td>0,00%</td>\n",
              "      <td>0,05%</td>\n",
              "      <td>2.108.74000</td>\n",
              "      <td>10.522.400.00000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0,00%</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>884</th>\n",
              "      <td>BRAP4</td>\n",
              "      <td>3659.0</td>\n",
              "      <td>2.25790</td>\n",
              "      <td>121.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2,18%</td>\n",
              "      <td>1154.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>-72911.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>-73058.0</td>\n",
              "      <td>-73058.0</td>\n",
              "      <td>0,00%</td>\n",
              "      <td>0,00%</td>\n",
              "      <td>0</td>\n",
              "      <td>0,00%</td>\n",
              "      <td>0,05%</td>\n",
              "      <td>81.444.00000</td>\n",
              "      <td>10.522.400.00000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0,00%</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>885 rows × 21 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "     Papel  Cotação      P/L  ...       Patrim. Líq  Dív.Brut/ Patrim. Cresc. Rec.5a\n",
              "0    VNET3      0.0  0.00000  ...   9.257.250.00000                0.0        -2,71%\n",
              "1    CFLU4      1.0  0.00000  ...      60.351.00000                6.0         8,14%\n",
              "2    CLAN3      0.0  0.00000  ...   1.012.240.00000                0.0       -63,96%\n",
              "3    CLSC6      0.0  0.00000  ...   1.551.160.00000                0.0         6,66%\n",
              "4    CSTB3  15000.0  0.00000  ...   8.420.670.00000               14.0        31,91%\n",
              "..     ...      ...      ...  ...               ...                ...           ...\n",
              "880  CEPE6   2000.0  1.54585  ...   1.667.000.00000              336.0         8,63%\n",
              "881  CEPE3   2453.0  1.89599  ...   1.667.000.00000              336.0         8,63%\n",
              "882  CEPE5   2511.0  1.94081  ...   1.667.000.00000              336.0         8,63%\n",
              "883  BRAP3   3311.0  2.04316  ...  10.522.400.00000                0.0         0,00%\n",
              "884  BRAP4   3659.0  2.25790  ...  10.522.400.00000                0.0         0,00%\n",
              "\n",
              "[885 rows x 21 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "b0uOj5NxNzdj",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "df0 = pd.read_html(url, decimal=',', thousands='.')[0]"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "qdS5VKo1QI01",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 427
        },
        "outputId": "96d093ab-a6df-4b8d-912d-b68827530192"
      },
      "source": [
        "for coluna in ['Div.Yield', 'Mrg Ebit', 'Mrg. Líq.', 'ROIC', 'Cresc. Rec.5a']:\n",
        "  df0[coluna] = df0[coluna].str.replace('.', '')\n",
        "  df0[coluna] = df0[coluna].str.replace(',', '.')\n",
        "  df0[coluna] = df0[coluna].str.rstrip('%').astype('float') / 100\n",
        "df0"
      ],
      "execution_count": 7,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Papel</th>\n",
              "      <th>Cotação</th>\n",
              "      <th>P/L</th>\n",
              "      <th>P/VP</th>\n",
              "      <th>PSR</th>\n",
              "      <th>Div.Yield</th>\n",
              "      <th>P/Ativo</th>\n",
              "      <th>P/Cap.Giro</th>\n",
              "      <th>P/EBIT</th>\n",
              "      <th>P/Ativ Circ.Liq</th>\n",
              "      <th>EV/EBIT</th>\n",
              "      <th>EV/EBITDA</th>\n",
              "      <th>Mrg Ebit</th>\n",
              "      <th>Mrg. Líq.</th>\n",
              "      <th>Liq. Corr.</th>\n",
              "      <th>ROIC</th>\n",
              "      <th>ROE</th>\n",
              "      <th>Liq.2meses</th>\n",
              "      <th>Patrim. Líq</th>\n",
              "      <th>Dív.Brut/ Patrim.</th>\n",
              "      <th>Cresc. Rec.5a</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>VNET3</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>12,99%</td>\n",
              "      <td>0.0</td>\n",
              "      <td>9.257250e+09</td>\n",
              "      <td>0.00</td>\n",
              "      <td>-0.0271</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>CFLU4</td>\n",
              "      <td>1000.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0888</td>\n",
              "      <td>0.1072</td>\n",
              "      <td>1.10</td>\n",
              "      <td>0.1768</td>\n",
              "      <td>32,15%</td>\n",
              "      <td>0.0</td>\n",
              "      <td>6.035100e+07</td>\n",
              "      <td>0.06</td>\n",
              "      <td>0.0814</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>CLAN3</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>-1,05%</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.012240e+09</td>\n",
              "      <td>0.00</td>\n",
              "      <td>-0.6396</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>CLSC6</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>22,88%</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.551160e+09</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0666</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>CSTB3</td>\n",
              "      <td>150.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.4085</td>\n",
              "      <td>0.2898</td>\n",
              "      <td>2.60</td>\n",
              "      <td>0.2240</td>\n",
              "      <td>20,11%</td>\n",
              "      <td>0.0</td>\n",
              "      <td>8.420670e+09</td>\n",
              "      <td>0.14</td>\n",
              "      <td>0.3191</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>881</th>\n",
              "      <td>CEPE6</td>\n",
              "      <td>20.00</td>\n",
              "      <td>1545.85</td>\n",
              "      <td>0.90</td>\n",
              "      <td>-18.326</td>\n",
              "      <td>0.0346</td>\n",
              "      <td>0.167</td>\n",
              "      <td>-9.71</td>\n",
              "      <td>71.38</td>\n",
              "      <td>-0.33</td>\n",
              "      <td>309.99</td>\n",
              "      <td>256.58</td>\n",
              "      <td>-0.2567</td>\n",
              "      <td>-0.0119</td>\n",
              "      <td>0.95</td>\n",
              "      <td>0.0027</td>\n",
              "      <td>0,06%</td>\n",
              "      <td>450.0</td>\n",
              "      <td>1.667000e+09</td>\n",
              "      <td>3.36</td>\n",
              "      <td>0.0863</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>882</th>\n",
              "      <td>CEPE3</td>\n",
              "      <td>24.53</td>\n",
              "      <td>1895.99</td>\n",
              "      <td>1.10</td>\n",
              "      <td>-22.477</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.204</td>\n",
              "      <td>-11.91</td>\n",
              "      <td>87.55</td>\n",
              "      <td>-0.41</td>\n",
              "      <td>326.16</td>\n",
              "      <td>269.96</td>\n",
              "      <td>-0.2567</td>\n",
              "      <td>-0.0119</td>\n",
              "      <td>0.95</td>\n",
              "      <td>0.0027</td>\n",
              "      <td>0,06%</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.667000e+09</td>\n",
              "      <td>3.36</td>\n",
              "      <td>0.0863</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>883</th>\n",
              "      <td>CEPE5</td>\n",
              "      <td>25.11</td>\n",
              "      <td>1940.81</td>\n",
              "      <td>1.12</td>\n",
              "      <td>-23.008</td>\n",
              "      <td>0.0251</td>\n",
              "      <td>0.209</td>\n",
              "      <td>-12.19</td>\n",
              "      <td>89.62</td>\n",
              "      <td>-0.42</td>\n",
              "      <td>328.23</td>\n",
              "      <td>271.68</td>\n",
              "      <td>-0.2567</td>\n",
              "      <td>-0.0119</td>\n",
              "      <td>0.95</td>\n",
              "      <td>0.0027</td>\n",
              "      <td>0,06%</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.667000e+09</td>\n",
              "      <td>3.36</td>\n",
              "      <td>0.0863</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>884</th>\n",
              "      <td>BRAP3</td>\n",
              "      <td>33.11</td>\n",
              "      <td>2043.16</td>\n",
              "      <td>1.10</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.0219</td>\n",
              "      <td>1.045</td>\n",
              "      <td>0.00</td>\n",
              "      <td>-659.76</td>\n",
              "      <td>0.00</td>\n",
              "      <td>-661.24</td>\n",
              "      <td>-661.24</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0,05%</td>\n",
              "      <td>2108740.0</td>\n",
              "      <td>1.052240e+10</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>885</th>\n",
              "      <td>BRAP4</td>\n",
              "      <td>36.59</td>\n",
              "      <td>2257.90</td>\n",
              "      <td>1.21</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.0218</td>\n",
              "      <td>1.154</td>\n",
              "      <td>0.00</td>\n",
              "      <td>-729.11</td>\n",
              "      <td>0.00</td>\n",
              "      <td>-730.58</td>\n",
              "      <td>-730.58</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0,05%</td>\n",
              "      <td>81444000.0</td>\n",
              "      <td>1.052240e+10</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.0000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>886 rows × 21 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "     Papel  Cotação      P/L  ...   Patrim. Líq  Dív.Brut/ Patrim.  Cresc. Rec.5a\n",
              "0    VNET3     0.00     0.00  ...  9.257250e+09               0.00        -0.0271\n",
              "1    CFLU4  1000.00     0.00  ...  6.035100e+07               0.06         0.0814\n",
              "2    CLAN3     0.00     0.00  ...  1.012240e+09               0.00        -0.6396\n",
              "3    CLSC6     0.00     0.00  ...  1.551160e+09               0.00         0.0666\n",
              "4    CSTB3   150.00     0.00  ...  8.420670e+09               0.14         0.3191\n",
              "..     ...      ...      ...  ...           ...                ...            ...\n",
              "881  CEPE6    20.00  1545.85  ...  1.667000e+09               3.36         0.0863\n",
              "882  CEPE3    24.53  1895.99  ...  1.667000e+09               3.36         0.0863\n",
              "883  CEPE5    25.11  1940.81  ...  1.667000e+09               3.36         0.0863\n",
              "884  BRAP3    33.11  2043.16  ...  1.052240e+10               0.00         0.0000\n",
              "885  BRAP4    36.59  2257.90  ...  1.052240e+10               0.00         0.0000\n",
              "\n",
              "[886 rows x 21 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "NNM7D6DoTy1X",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 33
        },
        "outputId": "95968aa0-1775-4ab7-80f2-5bc4a4c7a063"
      },
      "source": [
        "df0.shape"
      ],
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(886, 21)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "1XDTMqmWTNI1",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "dfliquidas = df0[df0['Liq.2meses'] > 1000000]"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "c49w8ITfUAby",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 33
        },
        "outputId": "9b157089-8f10-4d86-bd71-5dcbacb99c71"
      },
      "source": [
        "dfliquidas.shape"
      ],
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(198, 21)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "xWGSxCHWUEyT",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "mfa = pd.DataFrame()\n",
        "mfa['pos'] = range(1, 151)\n",
        "mfa['EV/EBIT'] = dfliquidas[dfliquidas['EV/EBIT'] > 0].sort_values(by=['EV/EBIT'])['Papel'][:150].values\n",
        "mfa['ROIC'] = dfliquidas.sort_values(by=['ROIC'], ascending=False)['Papel'][:150].values"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "6Vnxjy10ZQd_",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 391
        },
        "outputId": "3ee44c52-c6d7-4b70-b1e8-b8036b44dd5d"
      },
      "source": [
        "magicaformula"
      ],
      "execution_count": 14,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>pos</th>\n",
              "      <th>EV/EBIT</th>\n",
              "      <th>ROIC</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>EMBR3</td>\n",
              "      <td>RCSL4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>PSSA3</td>\n",
              "      <td>WIZS3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>SMLS3</td>\n",
              "      <td>PSSA3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4</td>\n",
              "      <td>SULA11</td>\n",
              "      <td>TOTS3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>5</td>\n",
              "      <td>WIZS3</td>\n",
              "      <td>ODPV3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>145</th>\n",
              "      <td>146</td>\n",
              "      <td>PNVL3</td>\n",
              "      <td>SUZB3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>146</th>\n",
              "      <td>147</td>\n",
              "      <td>GNDI3</td>\n",
              "      <td>JHSF3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>147</th>\n",
              "      <td>148</td>\n",
              "      <td>WEGE3</td>\n",
              "      <td>COGN3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>148</th>\n",
              "      <td>149</td>\n",
              "      <td>RADL3</td>\n",
              "      <td>LOGG3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>149</th>\n",
              "      <td>150</td>\n",
              "      <td>HAPV3</td>\n",
              "      <td>GFSA3</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>150 rows × 3 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "     pos EV/EBIT   ROIC\n",
              "0      1   EMBR3  RCSL4\n",
              "1      2   PSSA3  WIZS3\n",
              "2      3   SMLS3  PSSA3\n",
              "3      4  SULA11  TOTS3\n",
              "4      5   WIZS3  ODPV3\n",
              "..   ...     ...    ...\n",
              "145  146   PNVL3  SUZB3\n",
              "146  147   GNDI3  JHSF3\n",
              "147  148   WEGE3  COGN3\n",
              "148  149   RADL3  LOGG3\n",
              "149  150   HAPV3  GFSA3\n",
              "\n",
              "[150 rows x 3 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "VYju8BXvZdaY",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "mfb = magicaformula.pivot_table(columns='EV/EBIT', values='pos')\n",
        "mfc = magicaformula.pivot_table(columns='ROIC', values='pos')"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "HTs_gBkBZyhb",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 152
        },
        "outputId": "b4dabbb8-7c3a-40e2-b99b-fcc8ab4b7ccf"
      },
      "source": [
        "mfd = pd.concat([mfb,mfc])\n",
        "mfd"
      ],
      "execution_count": 19,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>AALR3</th>\n",
              "      <th>ABEV3</th>\n",
              "      <th>AGRO3</th>\n",
              "      <th>ALPA4</th>\n",
              "      <th>ALSO3</th>\n",
              "      <th>ALUP11</th>\n",
              "      <th>AMAR3</th>\n",
              "      <th>ANIM3</th>\n",
              "      <th>ARZZ3</th>\n",
              "      <th>B3SA3</th>\n",
              "      <th>BEEF3</th>\n",
              "      <th>BKBR3</th>\n",
              "      <th>BRDT3</th>\n",
              "      <th>BRFS3</th>\n",
              "      <th>BRKM5</th>\n",
              "      <th>BRML3</th>\n",
              "      <th>BRPR3</th>\n",
              "      <th>CAML3</th>\n",
              "      <th>CARD3</th>\n",
              "      <th>CCPR3</th>\n",
              "      <th>CCRO3</th>\n",
              "      <th>CEAB3</th>\n",
              "      <th>CESP6</th>\n",
              "      <th>CIEL3</th>\n",
              "      <th>CMIG3</th>\n",
              "      <th>CMIG4</th>\n",
              "      <th>COCE5</th>\n",
              "      <th>COGN3</th>\n",
              "      <th>CPFE3</th>\n",
              "      <th>CPLE3</th>\n",
              "      <th>CPLE6</th>\n",
              "      <th>CRFB3</th>\n",
              "      <th>CSAN3</th>\n",
              "      <th>CSMG3</th>\n",
              "      <th>CSNA3</th>\n",
              "      <th>CVCB3</th>\n",
              "      <th>CYRE3</th>\n",
              "      <th>DIRR3</th>\n",
              "      <th>DTEX3</th>\n",
              "      <th>ECOR3</th>\n",
              "      <th>...</th>\n",
              "      <th>SAPR4</th>\n",
              "      <th>SBSP3</th>\n",
              "      <th>SEER3</th>\n",
              "      <th>SGPS3</th>\n",
              "      <th>SHUL4</th>\n",
              "      <th>SLCE3</th>\n",
              "      <th>SMLS3</th>\n",
              "      <th>SMTO3</th>\n",
              "      <th>SULA11</th>\n",
              "      <th>TASA4</th>\n",
              "      <th>TEND3</th>\n",
              "      <th>TESA3</th>\n",
              "      <th>TGMA3</th>\n",
              "      <th>TIET11</th>\n",
              "      <th>TIET4</th>\n",
              "      <th>TIMP3</th>\n",
              "      <th>TOTS3</th>\n",
              "      <th>TRIS3</th>\n",
              "      <th>TRPL4</th>\n",
              "      <th>TUPY3</th>\n",
              "      <th>UCAS3</th>\n",
              "      <th>UGPA3</th>\n",
              "      <th>UNIP6</th>\n",
              "      <th>USIM3</th>\n",
              "      <th>USIM5</th>\n",
              "      <th>VALE3</th>\n",
              "      <th>VIVT3</th>\n",
              "      <th>VIVT4</th>\n",
              "      <th>VLID3</th>\n",
              "      <th>VULC3</th>\n",
              "      <th>VVAR3</th>\n",
              "      <th>WEGE3</th>\n",
              "      <th>WIZS3</th>\n",
              "      <th>WSON33</th>\n",
              "      <th>YDUQ3</th>\n",
              "      <th>LWSA3</th>\n",
              "      <th>MGLU3</th>\n",
              "      <th>PRNR3</th>\n",
              "      <th>RCSL4</th>\n",
              "      <th>SUZB3</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>pos</th>\n",
              "      <td>115.0</td>\n",
              "      <td>88.0</td>\n",
              "      <td>89.0</td>\n",
              "      <td>140.0</td>\n",
              "      <td>71.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>15.0</td>\n",
              "      <td>118.0</td>\n",
              "      <td>135.0</td>\n",
              "      <td>130.0</td>\n",
              "      <td>40.0</td>\n",
              "      <td>119.0</td>\n",
              "      <td>95.0</td>\n",
              "      <td>69.0</td>\n",
              "      <td>117.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>126.0</td>\n",
              "      <td>107.0</td>\n",
              "      <td>60.0</td>\n",
              "      <td>74.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>59.0</td>\n",
              "      <td>111.0</td>\n",
              "      <td>20.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>65.0</td>\n",
              "      <td>129.0</td>\n",
              "      <td>64.0</td>\n",
              "      <td>28.0</td>\n",
              "      <td>33.0</td>\n",
              "      <td>66.0</td>\n",
              "      <td>106.0</td>\n",
              "      <td>32.0</td>\n",
              "      <td>54.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>103.0</td>\n",
              "      <td>31.0</td>\n",
              "      <td>128.0</td>\n",
              "      <td>68.0</td>\n",
              "      <td>...</td>\n",
              "      <td>8.0</td>\n",
              "      <td>36.0</td>\n",
              "      <td>45.0</td>\n",
              "      <td>109.0</td>\n",
              "      <td>75.0</td>\n",
              "      <td>79.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>116.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>101.0</td>\n",
              "      <td>19.0</td>\n",
              "      <td>93.0</td>\n",
              "      <td>37.0</td>\n",
              "      <td>72.0</td>\n",
              "      <td>70.0</td>\n",
              "      <td>58.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>38.0</td>\n",
              "      <td>34.0</td>\n",
              "      <td>18.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>114.0</td>\n",
              "      <td>42.0</td>\n",
              "      <td>53.0</td>\n",
              "      <td>43.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>91.0</td>\n",
              "      <td>92.0</td>\n",
              "      <td>21.0</td>\n",
              "      <td>26.0</td>\n",
              "      <td>123.0</td>\n",
              "      <td>148.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>23.0</td>\n",
              "      <td>73.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>pos</th>\n",
              "      <td>142.0</td>\n",
              "      <td>15.0</td>\n",
              "      <td>88.0</td>\n",
              "      <td>23.0</td>\n",
              "      <td>130.0</td>\n",
              "      <td>22.0</td>\n",
              "      <td>26.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>19.0</td>\n",
              "      <td>36.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>133.0</td>\n",
              "      <td>73.0</td>\n",
              "      <td>72.0</td>\n",
              "      <td>132.0</td>\n",
              "      <td>126.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>98.0</td>\n",
              "      <td>50.0</td>\n",
              "      <td>119.0</td>\n",
              "      <td>44.0</td>\n",
              "      <td>94.0</td>\n",
              "      <td>138.0</td>\n",
              "      <td>37.0</td>\n",
              "      <td>69.0</td>\n",
              "      <td>68.0</td>\n",
              "      <td>103.0</td>\n",
              "      <td>148.0</td>\n",
              "      <td>39.0</td>\n",
              "      <td>65.0</td>\n",
              "      <td>66.0</td>\n",
              "      <td>54.0</td>\n",
              "      <td>93.0</td>\n",
              "      <td>42.0</td>\n",
              "      <td>59.0</td>\n",
              "      <td>41.0</td>\n",
              "      <td>125.0</td>\n",
              "      <td>123.0</td>\n",
              "      <td>129.0</td>\n",
              "      <td>35.0</td>\n",
              "      <td>...</td>\n",
              "      <td>13.0</td>\n",
              "      <td>38.0</td>\n",
              "      <td>74.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>95.0</td>\n",
              "      <td>75.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>116.0</td>\n",
              "      <td>106.0</td>\n",
              "      <td>91.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>141.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>28.0</td>\n",
              "      <td>27.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>57.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>43.0</td>\n",
              "      <td>62.0</td>\n",
              "      <td>109.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>128.0</td>\n",
              "      <td>127.0</td>\n",
              "      <td>18.0</td>\n",
              "      <td>107.0</td>\n",
              "      <td>108.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>47.0</td>\n",
              "      <td>124.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>34.0</td>\n",
              "      <td>17.0</td>\n",
              "      <td>104.0</td>\n",
              "      <td>70.0</td>\n",
              "      <td>145.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>146.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>2 rows × 154 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "     AALR3  ABEV3  AGRO3  ALPA4  ALSO3  ...  LWSA3  MGLU3  PRNR3  RCSL4  SUZB3\n",
              "pos  115.0   88.0   89.0  140.0   71.0  ...    NaN    NaN    NaN    NaN    NaN\n",
              "pos  142.0   15.0   88.0   23.0  130.0  ...  104.0   70.0  145.0    1.0  146.0\n",
              "\n",
              "[2 rows x 154 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 19
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "mijvM5SeaTm8",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 277
        },
        "outputId": "920bf86b-c192-4f66-90b0-ecab9064c661"
      },
      "source": [
        "magicaformula = mfd.dropna(axis=1).sum()\n",
        "magicaformula.sort_values()[:15]"
      ],
      "execution_count": 24,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "PSSA3      5.0\n",
              "WIZS3      7.0\n",
              "SMLS3      9.0\n",
              "SAPR4     21.0\n",
              "SAPR11    23.0\n",
              "LEVE3     27.0\n",
              "VALE3     29.0\n",
              "ALUP11    32.0\n",
              "GOLL4     34.0\n",
              "AMAR3     41.0\n",
              "TGMA3     46.0\n",
              "CVCB3     48.0\n",
              "TEND3     49.0\n",
              "BEEF3     50.0\n",
              "MRFG3     51.0\n",
              "dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 24
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "YDI_JqwJb9VG",
        "colab_type": "text"
      },
      "source": [
        "**A Fórmula Mágica de Joel Grenblatt.**\n",
        "\n",
        "Olhe para o “retorno de lucro” (earnings yield) e o “retorno sobre o capital” (return on capital) ao montar sua carteira de investimentos. *(https://www.sunoresearch.com.br/artigos/formula-magica-de-joel-grenblatt-little-book-beats-market/)*\n",
        "\n",
        "Dispensando as distorções desta função para as empresas financeiras, todas as demais apresentam a barganha, ou seja, empresas que geram mais caixa do que aquele valorizado pela ação no mercado."
      ]
    }
  ]
}