coletando-dados-usando-yfinance.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Coletando dados de ações do mercado financeiro"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Yahoo Finance"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "#!pip install yfinance\n",
    "import yfinance as yf\n",
    "from pandas import json_normalize\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "###### Criando um Ticker"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "ticker = yf.Ticker('BBAS3.SA') #\"MSFT\", ^BVSP, USDBRL=X BTC-USD"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "###### Cotações"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>Dividends</th>\n",
       "      <th>Stock Splits</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-05-04</th>\n",
       "      <td>26.149300</td>\n",
       "      <td>26.521906</td>\n",
       "      <td>25.786247</td>\n",
       "      <td>26.521906</td>\n",
       "      <td>16586000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-05</th>\n",
       "      <td>26.770315</td>\n",
       "      <td>27.276676</td>\n",
       "      <td>26.330830</td>\n",
       "      <td>26.560125</td>\n",
       "      <td>15799600</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-06</th>\n",
       "      <td>26.712987</td>\n",
       "      <td>26.875405</td>\n",
       "      <td>25.556953</td>\n",
       "      <td>25.786249</td>\n",
       "      <td>20312700</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-07</th>\n",
       "      <td>26.216181</td>\n",
       "      <td>26.225735</td>\n",
       "      <td>24.907282</td>\n",
       "      <td>25.088808</td>\n",
       "      <td>26405900</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-08</th>\n",
       "      <td>25.891342</td>\n",
       "      <td>26.474135</td>\n",
       "      <td>25.604721</td>\n",
       "      <td>25.891342</td>\n",
       "      <td>17576000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-04-28</th>\n",
       "      <td>29.990000</td>\n",
       "      <td>30.370001</td>\n",
       "      <td>29.850000</td>\n",
       "      <td>30.299999</td>\n",
       "      <td>15213600</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-04-29</th>\n",
       "      <td>30.299999</td>\n",
       "      <td>30.520000</td>\n",
       "      <td>29.570000</td>\n",
       "      <td>29.639999</td>\n",
       "      <td>14692400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-04-30</th>\n",
       "      <td>29.670000</td>\n",
       "      <td>29.850000</td>\n",
       "      <td>29.440001</td>\n",
       "      <td>29.639999</td>\n",
       "      <td>12656100</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-05-03</th>\n",
       "      <td>29.820000</td>\n",
       "      <td>30.030001</td>\n",
       "      <td>29.549999</td>\n",
       "      <td>29.770000</td>\n",
       "      <td>9153600</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-05-04</th>\n",
       "      <td>29.900000</td>\n",
       "      <td>29.969999</td>\n",
       "      <td>29.190001</td>\n",
       "      <td>29.370001</td>\n",
       "      <td>12156900</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>247 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Open       High        Low      Close    Volume  Dividends  \\\n",
       "Date                                                                          \n",
       "2020-05-04  26.149300  26.521906  25.786247  26.521906  16586000        0.0   \n",
       "2020-05-05  26.770315  27.276676  26.330830  26.560125  15799600        0.0   \n",
       "2020-05-06  26.712987  26.875405  25.556953  25.786249  20312700        0.0   \n",
       "2020-05-07  26.216181  26.225735  24.907282  25.088808  26405900        0.0   \n",
       "2020-05-08  25.891342  26.474135  25.604721  25.891342  17576000        0.0   \n",
       "...               ...        ...        ...        ...       ...        ...   \n",
       "2021-04-28  29.990000  30.370001  29.850000  30.299999  15213600        0.0   \n",
       "2021-04-29  30.299999  30.520000  29.570000  29.639999  14692400        0.0   \n",
       "2021-04-30  29.670000  29.850000  29.440001  29.639999  12656100        0.0   \n",
       "2021-05-03  29.820000  30.030001  29.549999  29.770000   9153600        0.0   \n",
       "2021-05-04  29.900000  29.969999  29.190001  29.370001  12156900        0.0   \n",
       "\n",
       "            Stock Splits  \n",
       "Date                      \n",
       "2020-05-04             0  \n",
       "2020-05-05             0  \n",
       "2020-05-06             0  \n",
       "2020-05-07             0  \n",
       "2020-05-08             0  \n",
       "...                  ...  \n",
       "2021-04-28             0  \n",
       "2021-04-29             0  \n",
       "2021-04-30             0  \n",
       "2021-05-03             0  \n",
       "2021-05-04             0  \n",
       "\n",
       "[247 rows x 7 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ticker.history(period='1y', interval='1d')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "###### Balanço Patrimonial anual"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>2020-12-31</th>\n",
       "      <th>2019-12-31</th>\n",
       "      <th>2018-12-31</th>\n",
       "      <th>2017-12-31</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Intangible Assets</th>\n",
       "      <td>6.220666e+09</td>\n",
       "      <td>5.920549e+09</td>\n",
       "      <td>5.782032e+09</td>\n",
       "      <td>6.926729e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Liab</th>\n",
       "      <td>1.598701e+12</td>\n",
       "      <td>1.372530e+12</td>\n",
       "      <td>1.314649e+12</td>\n",
       "      <td>1.270478e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Stockholder Equity</th>\n",
       "      <td>1.245677e+11</td>\n",
       "      <td>1.066612e+11</td>\n",
       "      <td>9.974197e+10</td>\n",
       "      <td>9.532573e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Minority Interest</th>\n",
       "      <td>2.403457e+09</td>\n",
       "      <td>1.903656e+09</td>\n",
       "      <td>2.510915e+09</td>\n",
       "      <td>3.397672e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Current Liab</th>\n",
       "      <td>5.410652e+10</td>\n",
       "      <td>5.015906e+10</td>\n",
       "      <td>9.600237e+10</td>\n",
       "      <td>8.549135e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Assets</th>\n",
       "      <td>1.725672e+12</td>\n",
       "      <td>1.481095e+12</td>\n",
       "      <td>1.416901e+12</td>\n",
       "      <td>1.369201e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Common Stock</th>\n",
       "      <td>9.000002e+10</td>\n",
       "      <td>6.700000e+10</td>\n",
       "      <td>6.700000e+10</td>\n",
       "      <td>6.700000e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Current Assets</th>\n",
       "      <td>1.369531e+11</td>\n",
       "      <td>1.372411e+11</td>\n",
       "      <td>6.577648e+10</td>\n",
       "      <td>9.496479e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Retained Earnings</th>\n",
       "      <td>3.919847e+10</td>\n",
       "      <td>5.381466e+10</td>\n",
       "      <td>4.261258e+10</td>\n",
       "      <td>3.528069e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Liab</th>\n",
       "      <td>1.305880e+11</td>\n",
       "      <td>1.129271e+11</td>\n",
       "      <td>2.403604e+10</td>\n",
       "      <td>2.516772e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Treasury Stock</th>\n",
       "      <td>-4.630839e+09</td>\n",
       "      <td>-1.415342e+10</td>\n",
       "      <td>-9.870615e+09</td>\n",
       "      <td>-6.954961e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Assets</th>\n",
       "      <td>7.148683e+11</td>\n",
       "      <td>6.543640e+11</td>\n",
       "      <td>6.673905e+11</td>\n",
       "      <td>6.759390e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cash</th>\n",
       "      <td>1.761895e+11</td>\n",
       "      <td>7.193602e+10</td>\n",
       "      <td>3.818834e+10</td>\n",
       "      <td>3.560214e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Current Liabilities</th>\n",
       "      <td>1.278059e+12</td>\n",
       "      <td>1.063533e+12</td>\n",
       "      <td>1.082949e+12</td>\n",
       "      <td>1.051245e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Deferred Long Term Asset Charges</th>\n",
       "      <td>5.814258e+10</td>\n",
       "      <td>5.946293e+10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Short Long Term Debt</th>\n",
       "      <td>5.880469e+11</td>\n",
       "      <td>4.898459e+11</td>\n",
       "      <td>4.925471e+11</td>\n",
       "      <td>5.042522e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Stockholder Equity</th>\n",
       "      <td>-4.350197e+09</td>\n",
       "      <td>-1.381378e+10</td>\n",
       "      <td>-8.037184e+09</td>\n",
       "      <td>-5.104918e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Property Plant Equipment</th>\n",
       "      <td>8.230854e+09</td>\n",
       "      <td>7.882695e+09</td>\n",
       "      <td>7.537617e+09</td>\n",
       "      <td>7.415302e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Current Assets</th>\n",
       "      <td>3.484755e+11</td>\n",
       "      <td>2.302539e+11</td>\n",
       "      <td>6.071002e+11</td>\n",
       "      <td>5.531098e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Long Term Investments</th>\n",
       "      <td>6.478766e+11</td>\n",
       "      <td>5.826741e+11</td>\n",
       "      <td>1.290911e+11</td>\n",
       "      <td>1.258103e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Net Tangible Assets</th>\n",
       "      <td>1.183470e+11</td>\n",
       "      <td>1.007407e+11</td>\n",
       "      <td>9.395994e+10</td>\n",
       "      <td>8.839900e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Short Term Investments</th>\n",
       "      <td>7.315580e+08</td>\n",
       "      <td>2.065050e+08</td>\n",
       "      <td>4.281338e+11</td>\n",
       "      <td>3.821750e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Net Receivables</th>\n",
       "      <td>1.336690e+10</td>\n",
       "      <td>1.444640e+10</td>\n",
       "      <td>7.407338e+10</td>\n",
       "      <td>3.953169e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Long Term Debt</th>\n",
       "      <td>1.900535e+11</td>\n",
       "      <td>1.960705e+11</td>\n",
       "      <td>2.076640e+11</td>\n",
       "      <td>1.940653e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Accounts Payable</th>\n",
       "      <td>6.334196e+11</td>\n",
       "      <td>5.187375e+11</td>\n",
       "      <td>4.860368e+11</td>\n",
       "      <td>4.502294e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Inventory</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.098800e+07</td>\n",
       "      <td>5.623500e+07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    2020-12-31    2019-12-31    2018-12-31  \\\n",
       "Intangible Assets                 6.220666e+09  5.920549e+09  5.782032e+09   \n",
       "Total Liab                        1.598701e+12  1.372530e+12  1.314649e+12   \n",
       "Total Stockholder Equity          1.245677e+11  1.066612e+11  9.974197e+10   \n",
       "Minority Interest                 2.403457e+09  1.903656e+09  2.510915e+09   \n",
       "Other Current Liab                5.410652e+10  5.015906e+10  9.600237e+10   \n",
       "Total Assets                      1.725672e+12  1.481095e+12  1.416901e+12   \n",
       "Common Stock                      9.000002e+10  6.700000e+10  6.700000e+10   \n",
       "Other Current Assets              1.369531e+11  1.372411e+11  6.577648e+10   \n",
       "Retained Earnings                 3.919847e+10  5.381466e+10  4.261258e+10   \n",
       "Other Liab                        1.305880e+11  1.129271e+11  2.403604e+10   \n",
       "Treasury Stock                   -4.630839e+09 -1.415342e+10 -9.870615e+09   \n",
       "Other Assets                      7.148683e+11  6.543640e+11  6.673905e+11   \n",
       "Cash                              1.761895e+11  7.193602e+10  3.818834e+10   \n",
       "Total Current Liabilities         1.278059e+12  1.063533e+12  1.082949e+12   \n",
       "Deferred Long Term Asset Charges  5.814258e+10  5.946293e+10           NaN   \n",
       "Short Long Term Debt              5.880469e+11  4.898459e+11  4.925471e+11   \n",
       "Other Stockholder Equity         -4.350197e+09 -1.381378e+10 -8.037184e+09   \n",
       "Property Plant Equipment          8.230854e+09  7.882695e+09  7.537617e+09   \n",
       "Total Current Assets              3.484755e+11  2.302539e+11  6.071002e+11   \n",
       "Long Term Investments             6.478766e+11  5.826741e+11  1.290911e+11   \n",
       "Net Tangible Assets               1.183470e+11  1.007407e+11  9.395994e+10   \n",
       "Short Term Investments            7.315580e+08  2.065050e+08  4.281338e+11   \n",
       "Net Receivables                   1.336690e+10  1.444640e+10  7.407338e+10   \n",
       "Long Term Debt                    1.900535e+11  1.960705e+11  2.076640e+11   \n",
       "Accounts Payable                  6.334196e+11  5.187375e+11  4.860368e+11   \n",
       "Inventory                                  NaN           NaN  6.098800e+07   \n",
       "\n",
       "                                    2017-12-31  \n",
       "Intangible Assets                 6.926729e+09  \n",
       "Total Liab                        1.270478e+12  \n",
       "Total Stockholder Equity          9.532573e+10  \n",
       "Minority Interest                 3.397672e+09  \n",
       "Other Current Liab                8.549135e+10  \n",
       "Total Assets                      1.369201e+12  \n",
       "Common Stock                      6.700000e+10  \n",
       "Other Current Assets              9.496479e+10  \n",
       "Retained Earnings                 3.528069e+10  \n",
       "Other Liab                        2.516772e+10  \n",
       "Treasury Stock                   -6.954961e+09  \n",
       "Other Assets                      6.759390e+11  \n",
       "Cash                              3.560214e+10  \n",
       "Total Current Liabilities         1.051245e+12  \n",
       "Deferred Long Term Asset Charges           NaN  \n",
       "Short Long Term Debt              5.042522e+11  \n",
       "Other Stockholder Equity         -5.104918e+09  \n",
       "Property Plant Equipment          7.415302e+09  \n",
       "Total Current Assets              5.531098e+11  \n",
       "Long Term Investments             1.258103e+11  \n",
       "Net Tangible Assets               8.839900e+10  \n",
       "Short Term Investments            3.821750e+11  \n",
       "Net Receivables                   3.953169e+10  \n",
       "Long Term Debt                    1.940653e+11  \n",
       "Accounts Payable                  4.502294e+11  \n",
       "Inventory                         5.623500e+07  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ticker.balance_sheet"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "###### Balanço Patrimonial Trimestral"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "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>2020-12-31</th>\n",
       "      <th>2020-09-30</th>\n",
       "      <th>2020-06-30</th>\n",
       "      <th>2020-03-31</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Intangible Assets</th>\n",
       "      <td>6.220666e+09</td>\n",
       "      <td>6.366255e+09</td>\n",
       "      <td>6.896055e+09</td>\n",
       "      <td>6.580505e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Liab</th>\n",
       "      <td>1.598701e+12</td>\n",
       "      <td>1.647590e+12</td>\n",
       "      <td>1.595398e+12</td>\n",
       "      <td>1.467875e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Stockholder Equity</th>\n",
       "      <td>1.245677e+11</td>\n",
       "      <td>1.199186e+11</td>\n",
       "      <td>1.128099e+11</td>\n",
       "      <td>1.099949e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Minority Interest</th>\n",
       "      <td>2.403457e+09</td>\n",
       "      <td>2.415103e+09</td>\n",
       "      <td>2.026446e+09</td>\n",
       "      <td>2.320385e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Current Liab</th>\n",
       "      <td>5.410652e+10</td>\n",
       "      <td>5.645059e+10</td>\n",
       "      <td>5.268821e+10</td>\n",
       "      <td>1.165273e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Assets</th>\n",
       "      <td>1.725672e+12</td>\n",
       "      <td>1.769923e+12</td>\n",
       "      <td>1.710234e+12</td>\n",
       "      <td>1.580190e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Common Stock</th>\n",
       "      <td>9.000002e+10</td>\n",
       "      <td>9.000000e+10</td>\n",
       "      <td>6.700000e+10</td>\n",
       "      <td>6.700000e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Current Assets</th>\n",
       "      <td>1.369531e+11</td>\n",
       "      <td>1.428031e+11</td>\n",
       "      <td>1.464974e+11</td>\n",
       "      <td>9.202280e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Retained Earnings</th>\n",
       "      <td>3.919847e+10</td>\n",
       "      <td>3.762960e+10</td>\n",
       "      <td>5.841287e+10</td>\n",
       "      <td>5.648046e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Liab</th>\n",
       "      <td>1.305880e+11</td>\n",
       "      <td>1.274683e+11</td>\n",
       "      <td>1.369143e+11</td>\n",
       "      <td>3.877309e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Treasury Stock</th>\n",
       "      <td>-4.630839e+09</td>\n",
       "      <td>-7.711041e+09</td>\n",
       "      <td>-1.260299e+10</td>\n",
       "      <td>-1.348552e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Assets</th>\n",
       "      <td>7.148683e+11</td>\n",
       "      <td>6.999928e+11</td>\n",
       "      <td>6.918273e+11</td>\n",
       "      <td>6.250512e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cash</th>\n",
       "      <td>1.761895e+11</td>\n",
       "      <td>7.789134e+10</td>\n",
       "      <td>8.115539e+10</td>\n",
       "      <td>4.562298e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Current Liabilities</th>\n",
       "      <td>1.278059e+12</td>\n",
       "      <td>1.314441e+12</td>\n",
       "      <td>1.251331e+12</td>\n",
       "      <td>1.218374e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Deferred Long Term Asset Charges</th>\n",
       "      <td>5.814258e+10</td>\n",
       "      <td>6.010949e+10</td>\n",
       "      <td>6.271350e+10</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Short Long Term Debt</th>\n",
       "      <td>5.880469e+11</td>\n",
       "      <td>6.513166e+11</td>\n",
       "      <td>6.054860e+11</td>\n",
       "      <td>5.639742e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Stockholder Equity</th>\n",
       "      <td>-4.350197e+09</td>\n",
       "      <td>-7.430335e+09</td>\n",
       "      <td>-1.229771e+10</td>\n",
       "      <td>-1.318021e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Property Plant Equipment</th>\n",
       "      <td>8.230854e+09</td>\n",
       "      <td>7.925262e+09</td>\n",
       "      <td>7.972408e+09</td>\n",
       "      <td>7.719945e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Current Assets</th>\n",
       "      <td>3.484755e+11</td>\n",
       "      <td>7.991924e+11</td>\n",
       "      <td>7.370415e+11</td>\n",
       "      <td>8.164038e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Long Term Investments</th>\n",
       "      <td>6.478766e+11</td>\n",
       "      <td>2.564465e+11</td>\n",
       "      <td>2.664967e+11</td>\n",
       "      <td>1.244349e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Net Tangible Assets</th>\n",
       "      <td>1.183470e+11</td>\n",
       "      <td>1.135523e+11</td>\n",
       "      <td>1.059138e+11</td>\n",
       "      <td>1.034144e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Short Term Investments</th>\n",
       "      <td>7.315580e+08</td>\n",
       "      <td>5.374247e+11</td>\n",
       "      <td>4.666445e+11</td>\n",
       "      <td>5.492726e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Net Receivables</th>\n",
       "      <td>1.336690e+10</td>\n",
       "      <td>1.461691e+10</td>\n",
       "      <td>1.618670e+10</td>\n",
       "      <td>1.232749e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Long Term Debt</th>\n",
       "      <td>1.900535e+11</td>\n",
       "      <td>2.056806e+11</td>\n",
       "      <td>2.071521e+11</td>\n",
       "      <td>2.107280e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Accounts Payable</th>\n",
       "      <td>6.334196e+11</td>\n",
       "      <td>6.055115e+11</td>\n",
       "      <td>5.931571e+11</td>\n",
       "      <td>5.368101e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Inventory</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.245300e+07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    2020-12-31    2020-09-30    2020-06-30  \\\n",
       "Intangible Assets                 6.220666e+09  6.366255e+09  6.896055e+09   \n",
       "Total Liab                        1.598701e+12  1.647590e+12  1.595398e+12   \n",
       "Total Stockholder Equity          1.245677e+11  1.199186e+11  1.128099e+11   \n",
       "Minority Interest                 2.403457e+09  2.415103e+09  2.026446e+09   \n",
       "Other Current Liab                5.410652e+10  5.645059e+10  5.268821e+10   \n",
       "Total Assets                      1.725672e+12  1.769923e+12  1.710234e+12   \n",
       "Common Stock                      9.000002e+10  9.000000e+10  6.700000e+10   \n",
       "Other Current Assets              1.369531e+11  1.428031e+11  1.464974e+11   \n",
       "Retained Earnings                 3.919847e+10  3.762960e+10  5.841287e+10   \n",
       "Other Liab                        1.305880e+11  1.274683e+11  1.369143e+11   \n",
       "Treasury Stock                   -4.630839e+09 -7.711041e+09 -1.260299e+10   \n",
       "Other Assets                      7.148683e+11  6.999928e+11  6.918273e+11   \n",
       "Cash                              1.761895e+11  7.789134e+10  8.115539e+10   \n",
       "Total Current Liabilities         1.278059e+12  1.314441e+12  1.251331e+12   \n",
       "Deferred Long Term Asset Charges  5.814258e+10  6.010949e+10  6.271350e+10   \n",
       "Short Long Term Debt              5.880469e+11  6.513166e+11  6.054860e+11   \n",
       "Other Stockholder Equity         -4.350197e+09 -7.430335e+09 -1.229771e+10   \n",
       "Property Plant Equipment          8.230854e+09  7.925262e+09  7.972408e+09   \n",
       "Total Current Assets              3.484755e+11  7.991924e+11  7.370415e+11   \n",
       "Long Term Investments             6.478766e+11  2.564465e+11  2.664967e+11   \n",
       "Net Tangible Assets               1.183470e+11  1.135523e+11  1.059138e+11   \n",
       "Short Term Investments            7.315580e+08  5.374247e+11  4.666445e+11   \n",
       "Net Receivables                   1.336690e+10  1.461691e+10  1.618670e+10   \n",
       "Long Term Debt                    1.900535e+11  2.056806e+11  2.071521e+11   \n",
       "Accounts Payable                  6.334196e+11  6.055115e+11  5.931571e+11   \n",
       "Inventory                                  NaN           NaN           NaN   \n",
       "\n",
       "                                    2020-03-31  \n",
       "Intangible Assets                 6.580505e+09  \n",
       "Total Liab                        1.467875e+12  \n",
       "Total Stockholder Equity          1.099949e+11  \n",
       "Minority Interest                 2.320385e+09  \n",
       "Other Current Liab                1.165273e+11  \n",
       "Total Assets                      1.580190e+12  \n",
       "Common Stock                      6.700000e+10  \n",
       "Other Current Assets              9.202280e+10  \n",
       "Retained Earnings                 5.648046e+10  \n",
       "Other Liab                        3.877309e+10  \n",
       "Treasury Stock                   -1.348552e+10  \n",
       "Other Assets                      6.250512e+11  \n",
       "Cash                              4.562298e+10  \n",
       "Total Current Liabilities         1.218374e+12  \n",
       "Deferred Long Term Asset Charges           NaN  \n",
       "Short Long Term Debt              5.639742e+11  \n",
       "Other Stockholder Equity         -1.318021e+10  \n",
       "Property Plant Equipment          7.719945e+09  \n",
       "Total Current Assets              8.164038e+11  \n",
       "Long Term Investments             1.244349e+11  \n",
       "Net Tangible Assets               1.034144e+11  \n",
       "Short Term Investments            5.492726e+11  \n",
       "Net Receivables                   1.232749e+11  \n",
       "Long Term Debt                    2.107280e+11  \n",
       "Accounts Payable                  5.368101e+11  \n",
       "Inventory                         6.245300e+07  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ticker.quarterly_balance_sheet"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "###### Fluxo de Caixa anual"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>2020-12-31</th>\n",
       "      <th>2019-12-31</th>\n",
       "      <th>2018-12-31</th>\n",
       "      <th>2017-12-31</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Investments</th>\n",
       "      <td>-9.416455e+10</td>\n",
       "      <td>-2.728768e+10</td>\n",
       "      <td>-1.153321e+10</td>\n",
       "      <td>-1.538465e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Change To Liabilities</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.662160e+08</td>\n",
       "      <td>8.200310e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Cashflows From Investing Activities</th>\n",
       "      <td>-9.564641e+10</td>\n",
       "      <td>-3.013845e+10</td>\n",
       "      <td>-1.059416e+10</td>\n",
       "      <td>-1.447812e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Net Borrowings</th>\n",
       "      <td>-1.278763e+10</td>\n",
       "      <td>-7.284291e+09</td>\n",
       "      <td>-3.097480e+09</td>\n",
       "      <td>1.720000e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Cash From Financing Activities</th>\n",
       "      <td>1.011075e+11</td>\n",
       "      <td>1.918133e+10</td>\n",
       "      <td>2.679381e+10</td>\n",
       "      <td>3.534301e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Change To Operating Activities</th>\n",
       "      <td>4.105831e+10</td>\n",
       "      <td>-4.258229e+09</td>\n",
       "      <td>-4.313130e+10</td>\n",
       "      <td>-8.495338e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Issuance Of Stock</th>\n",
       "      <td>1.526800e+07</td>\n",
       "      <td>2.805364e+09</td>\n",
       "      <td>1.661200e+07</td>\n",
       "      <td>4.706000e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Net Income</th>\n",
       "      <td>1.269738e+10</td>\n",
       "      <td>1.816207e+10</td>\n",
       "      <td>1.286203e+10</td>\n",
       "      <td>1.101078e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Change In Cash</th>\n",
       "      <td>1.042535e+11</td>\n",
       "      <td>1.160057e+10</td>\n",
       "      <td>1.315150e+10</td>\n",
       "      <td>-5.593972e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Effect Of Exchange Rate</th>\n",
       "      <td>1.032067e+10</td>\n",
       "      <td>-1.587850e+08</td>\n",
       "      <td>2.522422e+09</td>\n",
       "      <td>3.614600e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Cash From Operating Activities</th>\n",
       "      <td>8.847173e+10</td>\n",
       "      <td>2.271647e+10</td>\n",
       "      <td>-5.570568e+09</td>\n",
       "      <td>-4.503204e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Depreciation</th>\n",
       "      <td>2.762620e+09</td>\n",
       "      <td>3.036181e+09</td>\n",
       "      <td>3.157990e+09</td>\n",
       "      <td>4.456598e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Cashflows From Investing Activities</th>\n",
       "      <td>2.265323e+09</td>\n",
       "      <td>1.473059e+09</td>\n",
       "      <td>2.925249e+09</td>\n",
       "      <td>3.219813e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dividends Paid</th>\n",
       "      <td>-2.404018e+09</td>\n",
       "      <td>-2.451730e+09</td>\n",
       "      <td>-1.706455e+09</td>\n",
       "      <td>-2.623783e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Cashflows From Financing Activities</th>\n",
       "      <td>1.180794e+11</td>\n",
       "      <td>3.078126e+10</td>\n",
       "      <td>3.408120e+10</td>\n",
       "      <td>4.433378e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Change To Netincome</th>\n",
       "      <td>3.322187e+10</td>\n",
       "      <td>2.724141e+10</td>\n",
       "      <td>2.276248e+10</td>\n",
       "      <td>2.847375e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Capital Expenditures</th>\n",
       "      <td>-1.700104e+09</td>\n",
       "      <td>-1.651586e+09</td>\n",
       "      <td>-1.361242e+09</td>\n",
       "      <td>-1.020391e+09</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             2020-12-31    2019-12-31  \\\n",
       "Investments                               -9.416455e+10 -2.728768e+10   \n",
       "Change To Liabilities                      0.000000e+00  0.000000e+00   \n",
       "Total Cashflows From Investing Activities -9.564641e+10 -3.013845e+10   \n",
       "Net Borrowings                            -1.278763e+10 -7.284291e+09   \n",
       "Total Cash From Financing Activities       1.011075e+11  1.918133e+10   \n",
       "Change To Operating Activities             4.105831e+10 -4.258229e+09   \n",
       "Issuance Of Stock                          1.526800e+07  2.805364e+09   \n",
       "Net Income                                 1.269738e+10  1.816207e+10   \n",
       "Change In Cash                             1.042535e+11  1.160057e+10   \n",
       "Effect Of Exchange Rate                    1.032067e+10 -1.587850e+08   \n",
       "Total Cash From Operating Activities       8.847173e+10  2.271647e+10   \n",
       "Depreciation                               2.762620e+09  3.036181e+09   \n",
       "Other Cashflows From Investing Activities  2.265323e+09  1.473059e+09   \n",
       "Dividends Paid                            -2.404018e+09 -2.451730e+09   \n",
       "Other Cashflows From Financing Activities  1.180794e+11  3.078126e+10   \n",
       "Change To Netincome                        3.322187e+10  2.724141e+10   \n",
       "Capital Expenditures                      -1.700104e+09 -1.651586e+09   \n",
       "\n",
       "                                             2018-12-31    2017-12-31  \n",
       "Investments                               -1.153321e+10 -1.538465e+10  \n",
       "Change To Liabilities                      2.662160e+08  8.200310e+08  \n",
       "Total Cashflows From Investing Activities -1.059416e+10 -1.447812e+10  \n",
       "Net Borrowings                            -3.097480e+09  1.720000e+09  \n",
       "Total Cash From Financing Activities       2.679381e+10  3.534301e+09  \n",
       "Change To Operating Activities            -4.313130e+10 -8.495338e+10  \n",
       "Issuance Of Stock                          1.661200e+07  4.706000e+06  \n",
       "Net Income                                 1.286203e+10  1.101078e+10  \n",
       "Change In Cash                             1.315150e+10 -5.593972e+10  \n",
       "Effect Of Exchange Rate                    2.522422e+09  3.614600e+07  \n",
       "Total Cash From Operating Activities      -5.570568e+09 -4.503204e+10  \n",
       "Depreciation                               3.157990e+09  4.456598e+09  \n",
       "Other Cashflows From Investing Activities  2.925249e+09  3.219813e+09  \n",
       "Dividends Paid                            -1.706455e+09 -2.623783e+09  \n",
       "Other Cashflows From Financing Activities  3.408120e+10  4.433378e+09  \n",
       "Change To Netincome                        2.276248e+10  2.847375e+10  \n",
       "Capital Expenditures                      -1.361242e+09 -1.020391e+09  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ticker.cashflow"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "###### Fluxo de Caixa Trimestral"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "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>2020-12-31</th>\n",
       "      <th>2020-09-30</th>\n",
       "      <th>2020-06-30</th>\n",
       "      <th>2020-03-31</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Investments</th>\n",
       "      <td>-4.206059e+10</td>\n",
       "      <td>1.010226e+09</td>\n",
       "      <td>-6.147968e+10</td>\n",
       "      <td>8.365488e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Change To Liabilities</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>7.360000e+05</td>\n",
       "      <td>-7.360000e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Cashflows From Investing Activities</th>\n",
       "      <td>-4.264485e+10</td>\n",
       "      <td>1.451048e+09</td>\n",
       "      <td>-6.192076e+10</td>\n",
       "      <td>7.468157e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Net Borrowings</th>\n",
       "      <td>-5.828426e+09</td>\n",
       "      <td>-1.032453e+09</td>\n",
       "      <td>-1.400006e+10</td>\n",
       "      <td>8.073314e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Cash From Financing Activities</th>\n",
       "      <td>2.792613e+10</td>\n",
       "      <td>1.277831e+10</td>\n",
       "      <td>3.855944e+10</td>\n",
       "      <td>2.184362e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Change To Operating Activities</th>\n",
       "      <td>1.067268e+11</td>\n",
       "      <td>-4.137604e+10</td>\n",
       "      <td>3.982240e+09</td>\n",
       "      <td>-2.827466e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Net Income</th>\n",
       "      <td>3.199054e+09</td>\n",
       "      <td>3.084902e+09</td>\n",
       "      <td>3.208748e+09</td>\n",
       "      <td>3.204681e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Change In Cash</th>\n",
       "      <td>9.829817e+10</td>\n",
       "      <td>-3.264048e+09</td>\n",
       "      <td>-1.797224e+10</td>\n",
       "      <td>2.719161e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Effect Of Exchange Rate</th>\n",
       "      <td>-3.759054e+09</td>\n",
       "      <td>6.231200e+08</td>\n",
       "      <td>5.078782e+09</td>\n",
       "      <td>8.377820e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Cash From Operating Activities</th>\n",
       "      <td>1.167759e+11</td>\n",
       "      <td>-1.811652e+10</td>\n",
       "      <td>3.103020e+08</td>\n",
       "      <td>-1.049799e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Depreciation</th>\n",
       "      <td>7.102640e+08</td>\n",
       "      <td>7.093000e+08</td>\n",
       "      <td>6.639800e+08</td>\n",
       "      <td>6.790760e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Cashflows From Investing Activities</th>\n",
       "      <td>4.226660e+08</td>\n",
       "      <td>6.544890e+08</td>\n",
       "      <td>8.678950e+08</td>\n",
       "      <td>3.202730e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Cashflows From Financing Activities</th>\n",
       "      <td>3.555012e+10</td>\n",
       "      <td>1.536086e+10</td>\n",
       "      <td>5.255950e+10</td>\n",
       "      <td>1.551499e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Change To Netincome</th>\n",
       "      <td>3.753609e+09</td>\n",
       "      <td>8.109767e+09</td>\n",
       "      <td>8.619080e+09</td>\n",
       "      <td>1.273941e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Capital Expenditures</th>\n",
       "      <td>-6.138230e+08</td>\n",
       "      <td>-3.453670e+08</td>\n",
       "      <td>-5.666590e+08</td>\n",
       "      <td>-1.742550e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dividends Paid</th>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.550105e+09</td>\n",
       "      <td>-1.550105e+09</td>\n",
       "      <td>-1.759951e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Issuance Of Stock</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.526800e+07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             2020-12-31    2020-09-30  \\\n",
       "Investments                               -4.206059e+10  1.010226e+09   \n",
       "Change To Liabilities                      0.000000e+00  0.000000e+00   \n",
       "Total Cashflows From Investing Activities -4.264485e+10  1.451048e+09   \n",
       "Net Borrowings                            -5.828426e+09 -1.032453e+09   \n",
       "Total Cash From Financing Activities       2.792613e+10  1.277831e+10   \n",
       "Change To Operating Activities             1.067268e+11 -4.137604e+10   \n",
       "Net Income                                 3.199054e+09  3.084902e+09   \n",
       "Change In Cash                             9.829817e+10 -3.264048e+09   \n",
       "Effect Of Exchange Rate                   -3.759054e+09  6.231200e+08   \n",
       "Total Cash From Operating Activities       1.167759e+11 -1.811652e+10   \n",
       "Depreciation                               7.102640e+08  7.093000e+08   \n",
       "Other Cashflows From Investing Activities  4.226660e+08  6.544890e+08   \n",
       "Other Cashflows From Financing Activities  3.555012e+10  1.536086e+10   \n",
       "Change To Netincome                        3.753609e+09  8.109767e+09   \n",
       "Capital Expenditures                      -6.138230e+08 -3.453670e+08   \n",
       "Dividends Paid                                      NaN -1.550105e+09   \n",
       "Issuance Of Stock                                   NaN           NaN   \n",
       "\n",
       "                                             2020-06-30    2020-03-31  \n",
       "Investments                               -6.147968e+10  8.365488e+09  \n",
       "Change To Liabilities                      7.360000e+05 -7.360000e+05  \n",
       "Total Cashflows From Investing Activities -6.192076e+10  7.468157e+09  \n",
       "Net Borrowings                            -1.400006e+10  8.073314e+09  \n",
       "Total Cash From Financing Activities       3.855944e+10  2.184362e+10  \n",
       "Change To Operating Activities             3.982240e+09 -2.827466e+10  \n",
       "Net Income                                 3.208748e+09  3.204681e+09  \n",
       "Change In Cash                            -1.797224e+10  2.719161e+10  \n",
       "Effect Of Exchange Rate                    5.078782e+09  8.377820e+09  \n",
       "Total Cash From Operating Activities       3.103020e+08 -1.049799e+10  \n",
       "Depreciation                               6.639800e+08  6.790760e+08  \n",
       "Other Cashflows From Investing Activities  8.678950e+08  3.202730e+08  \n",
       "Other Cashflows From Financing Activities  5.255950e+10  1.551499e+10  \n",
       "Change To Netincome                        8.619080e+09  1.273941e+10  \n",
       "Capital Expenditures                      -5.666590e+08 -1.742550e+08  \n",
       "Dividends Paid                            -1.550105e+09 -1.759951e+09  \n",
       "Issuance Of Stock                                   NaN  1.526800e+07  "
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ticker.quarterly_cashflow"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "###### Financeiro anual"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "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>2020-12-31</th>\n",
       "      <th>2019-12-31</th>\n",
       "      <th>2018-12-31</th>\n",
       "      <th>2017-12-31</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Research Development</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Effect Of Accounting Charges</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Income Before Tax</th>\n",
       "      <td>1.2821e+10</td>\n",
       "      <td>1.37834e+10</td>\n",
       "      <td>1.90252e+10</td>\n",
       "      <td>1.67117e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Minority Interest</th>\n",
       "      <td>2.40346e+09</td>\n",
       "      <td>1.90366e+09</td>\n",
       "      <td>2.51092e+09</td>\n",
       "      <td>3.39767e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Net Income</th>\n",
       "      <td>1.26974e+10</td>\n",
       "      <td>1.81621e+10</td>\n",
       "      <td>1.2862e+10</td>\n",
       "      <td>1.10108e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Selling General Administrative</th>\n",
       "      <td>3.40472e+10</td>\n",
       "      <td>3.48473e+10</td>\n",
       "      <td>3.32618e+10</td>\n",
       "      <td>3.42098e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gross Profit</th>\n",
       "      <td>5.77461e+10</td>\n",
       "      <td>6.10117e+10</td>\n",
       "      <td>5.96184e+10</td>\n",
       "      <td>5.73988e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ebit</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Operating Income</th>\n",
       "      <td>1.36218e+10</td>\n",
       "      <td>1.70365e+10</td>\n",
       "      <td>2.03122e+10</td>\n",
       "      <td>1.65838e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Operating Expenses</th>\n",
       "      <td>1.00771e+10</td>\n",
       "      <td>9.12783e+09</td>\n",
       "      <td>6.04446e+09</td>\n",
       "      <td>6.60522e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Interest Expense</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Extraordinary Items</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Non Recurring</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Items</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Income Tax Expense</th>\n",
       "      <td>-1.45286e+09</td>\n",
       "      <td>-6.8605e+09</td>\n",
       "      <td>4.76737e+09</td>\n",
       "      <td>4.05086e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Revenue</th>\n",
       "      <td>5.84832e+10</td>\n",
       "      <td>6.17459e+10</td>\n",
       "      <td>6.03344e+10</td>\n",
       "      <td>5.81058e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Operating Expenses</th>\n",
       "      <td>4.48614e+10</td>\n",
       "      <td>4.47093e+10</td>\n",
       "      <td>4.00222e+10</td>\n",
       "      <td>4.1522e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cost Of Revenue</th>\n",
       "      <td>7.37076e+08</td>\n",
       "      <td>7.34209e+08</td>\n",
       "      <td>7.15937e+08</td>\n",
       "      <td>7.06984e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Other Income Expense Net</th>\n",
       "      <td>-8.00745e+08</td>\n",
       "      <td>-3.25309e+09</td>\n",
       "      <td>-1.28694e+09</td>\n",
       "      <td>1.2788e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Discontinued Operations</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Net Income From Continuing Ops</th>\n",
       "      <td>1.42739e+10</td>\n",
       "      <td>2.06439e+10</td>\n",
       "      <td>1.42579e+10</td>\n",
       "      <td>1.26608e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Net Income Applicable To Common Shares</th>\n",
       "      <td>1.25122e+10</td>\n",
       "      <td>1.78993e+10</td>\n",
       "      <td>1.26488e+10</td>\n",
       "      <td>1.08811e+10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         2020-12-31   2019-12-31   2018-12-31  \\\n",
       "Research Development                           None         None         None   \n",
       "Effect Of Accounting Charges                   None         None         None   \n",
       "Income Before Tax                        1.2821e+10  1.37834e+10  1.90252e+10   \n",
       "Minority Interest                       2.40346e+09  1.90366e+09  2.51092e+09   \n",
       "Net Income                              1.26974e+10  1.81621e+10   1.2862e+10   \n",
       "Selling General Administrative          3.40472e+10  3.48473e+10  3.32618e+10   \n",
       "Gross Profit                            5.77461e+10  6.10117e+10  5.96184e+10   \n",
       "Ebit                                              0            0            0   \n",
       "Operating Income                        1.36218e+10  1.70365e+10  2.03122e+10   \n",
       "Other Operating Expenses                1.00771e+10  9.12783e+09  6.04446e+09   \n",
       "Interest Expense                               None         None         None   \n",
       "Extraordinary Items                            None         None         None   \n",
       "Non Recurring                                  None         None         None   \n",
       "Other Items                                    None         None         None   \n",
       "Income Tax Expense                     -1.45286e+09  -6.8605e+09  4.76737e+09   \n",
       "Total Revenue                           5.84832e+10  6.17459e+10  6.03344e+10   \n",
       "Total Operating Expenses                4.48614e+10  4.47093e+10  4.00222e+10   \n",
       "Cost Of Revenue                         7.37076e+08  7.34209e+08  7.15937e+08   \n",
       "Total Other Income Expense Net         -8.00745e+08 -3.25309e+09 -1.28694e+09   \n",
       "Discontinued Operations                        None         None         None   \n",
       "Net Income From Continuing Ops          1.42739e+10  2.06439e+10  1.42579e+10   \n",
       "Net Income Applicable To Common Shares  1.25122e+10  1.78993e+10  1.26488e+10   \n",
       "\n",
       "                                         2017-12-31  \n",
       "Research Development                           None  \n",
       "Effect Of Accounting Charges                   None  \n",
       "Income Before Tax                       1.67117e+10  \n",
       "Minority Interest                       3.39767e+09  \n",
       "Net Income                              1.10108e+10  \n",
       "Selling General Administrative          3.42098e+10  \n",
       "Gross Profit                            5.73988e+10  \n",
       "Ebit                                              0  \n",
       "Operating Income                        1.65838e+10  \n",
       "Other Operating Expenses                6.60522e+09  \n",
       "Interest Expense                               None  \n",
       "Extraordinary Items                            None  \n",
       "Non Recurring                                  None  \n",
       "Other Items                                    None  \n",
       "Income Tax Expense                      4.05086e+09  \n",
       "Total Revenue                           5.81058e+10  \n",
       "Total Operating Expenses                 4.1522e+10  \n",
       "Cost Of Revenue                         7.06984e+08  \n",
       "Total Other Income Expense Net           1.2788e+08  \n",
       "Discontinued Operations                        None  \n",
       "Net Income From Continuing Ops          1.26608e+10  \n",
       "Net Income Applicable To Common Shares  1.08811e+10  "
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ticker.financials"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "###### Financeiro Trimestral"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "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>2020-12-31</th>\n",
       "      <th>2020-09-30</th>\n",
       "      <th>2020-06-30</th>\n",
       "      <th>2020-03-31</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Research Development</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Effect Of Accounting Charges</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Income Before Tax</th>\n",
       "      <td>4.09066e+09</td>\n",
       "      <td>3.6267e+09</td>\n",
       "      <td>3.75554e+09</td>\n",
       "      <td>1.34814e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Minority Interest</th>\n",
       "      <td>2.40346e+09</td>\n",
       "      <td>2.4151e+09</td>\n",
       "      <td>2.02645e+09</td>\n",
       "      <td>2.32038e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Net Income</th>\n",
       "      <td>3.19905e+09</td>\n",
       "      <td>3.0849e+09</td>\n",
       "      <td>3.20875e+09</td>\n",
       "      <td>3.20468e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Selling General Administrative</th>\n",
       "      <td>8.64576e+09</td>\n",
       "      <td>8.61449e+09</td>\n",
       "      <td>8.42615e+09</td>\n",
       "      <td>8.36081e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gross Profit</th>\n",
       "      <td>1.69122e+10</td>\n",
       "      <td>1.46639e+10</td>\n",
       "      <td>1.43829e+10</td>\n",
       "      <td>1.17871e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ebit</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Operating Income</th>\n",
       "      <td>4.64876e+09</td>\n",
       "      <td>3.75639e+09</td>\n",
       "      <td>3.63129e+09</td>\n",
       "      <td>1.58535e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Operating Expenses</th>\n",
       "      <td>3.61773e+09</td>\n",
       "      <td>2.29301e+09</td>\n",
       "      <td>2.32546e+09</td>\n",
       "      <td>1.8409e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Interest Expense</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Extraordinary Items</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Non Recurring</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Items</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Income Tax Expense</th>\n",
       "      <td>5.19266e+08</td>\n",
       "      <td>1.03634e+08</td>\n",
       "      <td>1.31115e+08</td>\n",
       "      <td>-2.20688e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Revenue</th>\n",
       "      <td>1.71029e+10</td>\n",
       "      <td>1.48426e+10</td>\n",
       "      <td>1.45643e+10</td>\n",
       "      <td>1.19734e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Operating Expenses</th>\n",
       "      <td>1.24541e+10</td>\n",
       "      <td>1.10862e+10</td>\n",
       "      <td>1.0933e+10</td>\n",
       "      <td>1.0388e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cost Of Revenue</th>\n",
       "      <td>1.90614e+08</td>\n",
       "      <td>1.78731e+08</td>\n",
       "      <td>1.81424e+08</td>\n",
       "      <td>1.86307e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Other Income Expense Net</th>\n",
       "      <td>-5.58097e+08</td>\n",
       "      <td>-1.29689e+08</td>\n",
       "      <td>1.24249e+08</td>\n",
       "      <td>-2.37208e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Discontinued Operations</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Net Income From Continuing Ops</th>\n",
       "      <td>3.5714e+09</td>\n",
       "      <td>3.52307e+09</td>\n",
       "      <td>3.62442e+09</td>\n",
       "      <td>3.55502e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Net Income Applicable To Common Shares</th>\n",
       "      <td>3.12682e+09</td>\n",
       "      <td>3.03748e+09</td>\n",
       "      <td>3.15858e+09</td>\n",
       "      <td>3.18928e+09</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         2020-12-31   2020-09-30   2020-06-30  \\\n",
       "Research Development                           None         None         None   \n",
       "Effect Of Accounting Charges                   None         None         None   \n",
       "Income Before Tax                       4.09066e+09   3.6267e+09  3.75554e+09   \n",
       "Minority Interest                       2.40346e+09   2.4151e+09  2.02645e+09   \n",
       "Net Income                              3.19905e+09   3.0849e+09  3.20875e+09   \n",
       "Selling General Administrative          8.64576e+09  8.61449e+09  8.42615e+09   \n",
       "Gross Profit                            1.69122e+10  1.46639e+10  1.43829e+10   \n",
       "Ebit                                              0            0            0   \n",
       "Operating Income                        4.64876e+09  3.75639e+09  3.63129e+09   \n",
       "Other Operating Expenses                3.61773e+09  2.29301e+09  2.32546e+09   \n",
       "Interest Expense                               None         None         None   \n",
       "Extraordinary Items                            None         None         None   \n",
       "Non Recurring                                  None         None         None   \n",
       "Other Items                                    None         None         None   \n",
       "Income Tax Expense                      5.19266e+08  1.03634e+08  1.31115e+08   \n",
       "Total Revenue                           1.71029e+10  1.48426e+10  1.45643e+10   \n",
       "Total Operating Expenses                1.24541e+10  1.10862e+10   1.0933e+10   \n",
       "Cost Of Revenue                         1.90614e+08  1.78731e+08  1.81424e+08   \n",
       "Total Other Income Expense Net         -5.58097e+08 -1.29689e+08  1.24249e+08   \n",
       "Discontinued Operations                        None         None         None   \n",
       "Net Income From Continuing Ops           3.5714e+09  3.52307e+09  3.62442e+09   \n",
       "Net Income Applicable To Common Shares  3.12682e+09  3.03748e+09  3.15858e+09   \n",
       "\n",
       "                                         2020-03-31  \n",
       "Research Development                           None  \n",
       "Effect Of Accounting Charges                   None  \n",
       "Income Before Tax                       1.34814e+09  \n",
       "Minority Interest                       2.32038e+09  \n",
       "Net Income                              3.20468e+09  \n",
       "Selling General Administrative          8.36081e+09  \n",
       "Gross Profit                            1.17871e+10  \n",
       "Ebit                                              0  \n",
       "Operating Income                        1.58535e+09  \n",
       "Other Operating Expenses                 1.8409e+09  \n",
       "Interest Expense                               None  \n",
       "Extraordinary Items                            None  \n",
       "Non Recurring                                  None  \n",
       "Other Items                                    None  \n",
       "Income Tax Expense                     -2.20688e+09  \n",
       "Total Revenue                           1.19734e+10  \n",
       "Total Operating Expenses                 1.0388e+10  \n",
       "Cost Of Revenue                         1.86307e+08  \n",
       "Total Other Income Expense Net         -2.37208e+08  \n",
       "Discontinued Operations                        None  \n",
       "Net Income From Continuing Ops          3.55502e+09  \n",
       "Net Income Applicable To Common Shares  3.18928e+09  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ticker.quarterly_financials"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "###### Informações e Estatística"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1615507200"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ticker.get_info()['lastDividendDate']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "info = json_normalize(ticker.get_info())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "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>sector</th>\n",
       "      <th>fullTimeEmployees</th>\n",
       "      <th>longBusinessSummary</th>\n",
       "      <th>city</th>\n",
       "      <th>state</th>\n",
       "      <th>country</th>\n",
       "      <th>companyOfficers</th>\n",
       "      <th>website</th>\n",
       "      <th>maxAge</th>\n",
       "      <th>address1</th>\n",
       "      <th>...</th>\n",
       "      <th>dateShortInterest</th>\n",
       "      <th>pegRatio</th>\n",
       "      <th>lastCapGain</th>\n",
       "      <th>shortPercentOfFloat</th>\n",
       "      <th>sharesShortPriorMonth</th>\n",
       "      <th>impliedSharesOutstanding</th>\n",
       "      <th>category</th>\n",
       "      <th>fiveYearAverageReturn</th>\n",
       "      <th>regularMarketPrice</th>\n",
       "      <th>logo_url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Financial Services</td>\n",
       "      <td>91673</td>\n",
       "      <td>Banco do Brasil S.A. provides banking products...</td>\n",
       "      <td>BrasÃ­lia</td>\n",
       "      <td>DF</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>[]</td>\n",
       "      <td>http://www.bb.com.br</td>\n",
       "      <td>1</td>\n",
       "      <td>Setor de Autarquias Norte</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>29.37</td>\n",
       "      <td>https://logo.clearbit.com/bb.com.br</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 122 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               sector  fullTimeEmployees  \\\n",
       "0  Financial Services              91673   \n",
       "\n",
       "                                 longBusinessSummary       city state country  \\\n",
       "0  Banco do Brasil S.A. provides banking products...  BrasÃ­lia    DF  Brazil   \n",
       "\n",
       "  companyOfficers               website  maxAge                   address1  \\\n",
       "0              []  http://www.bb.com.br       1  Setor de Autarquias Norte   \n",
       "\n",
       "   ... dateShortInterest pegRatio  lastCapGain  shortPercentOfFloat  \\\n",
       "0  ...              None     None         None                 None   \n",
       "\n",
       "   sharesShortPriorMonth  impliedSharesOutstanding  category  \\\n",
       "0                   None                      None      None   \n",
       "\n",
       "  fiveYearAverageReturn  regularMarketPrice  \\\n",
       "0                  None               29.37   \n",
       "\n",
       "                              logo_url  \n",
       "0  https://logo.clearbit.com/bb.com.br  \n",
       "\n",
       "[1 rows x 122 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "info.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "122"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(info.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [],
   "source": [
    "selected = [c for c in list(info.columns) if 'beta' in c] #PE, Dividend, beta"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['beta', 'beta3Year']"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "selected"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "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>beta</th>\n",
       "      <th>beta3Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.069438</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       beta beta3Year\n",
       "0  1.069438      None"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "info[selected]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "###### Detentores de fundo mútuo"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "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>Holder</th>\n",
       "      <th>Shares</th>\n",
       "      <th>Date Reported</th>\n",
       "      <th>% Out</th>\n",
       "      <th>Value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Fidelity Series Emerging Markets Opportunities...</td>\n",
       "      <td>18411038</td>\n",
       "      <td>2021-02-27</td>\n",
       "      <td>0.0064</td>\n",
       "      <td>516429615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>iShares MSCI Brazil ETF</td>\n",
       "      <td>15391287</td>\n",
       "      <td>2021-03-30</td>\n",
       "      <td>0.0054</td>\n",
       "      <td>468664689</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Lazard Emerging Markets Equity Portfolio</td>\n",
       "      <td>11825926</td>\n",
       "      <td>2020-12-30</td>\n",
       "      <td>0.0041</td>\n",
       "      <td>458845928</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Vanguard International Stock Index-Emerging Ma...</td>\n",
       "      <td>11823037</td>\n",
       "      <td>2021-01-30</td>\n",
       "      <td>0.0041</td>\n",
       "      <td>400328032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Vanguard International Stock Index-Total Intl ...</td>\n",
       "      <td>11803398</td>\n",
       "      <td>2021-01-30</td>\n",
       "      <td>0.0041</td>\n",
       "      <td>399663056</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>iShares Core MSCI Emerging Markets ETF</td>\n",
       "      <td>7251713</td>\n",
       "      <td>2021-03-30</td>\n",
       "      <td>0.0025</td>\n",
       "      <td>220814660</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>iShares Latin America 40 ETF</td>\n",
       "      <td>6206900</td>\n",
       "      <td>2021-03-30</td>\n",
       "      <td>0.0022</td>\n",
       "      <td>189000105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Blackrock Ser Inc-Blackrock International Fund</td>\n",
       "      <td>4209764</td>\n",
       "      <td>2021-02-27</td>\n",
       "      <td>0.0015</td>\n",
       "      <td>118083880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Nuveen Investment Trust II - International Gro...</td>\n",
       "      <td>3915700</td>\n",
       "      <td>2021-03-30</td>\n",
       "      <td>0.0014</td>\n",
       "      <td>119233065</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>DFA Investment Dimensions-DFA Emerging Mkts Value</td>\n",
       "      <td>3882886</td>\n",
       "      <td>2021-01-30</td>\n",
       "      <td>0.0014</td>\n",
       "      <td>131474519</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              Holder    Shares Date Reported  \\\n",
       "0  Fidelity Series Emerging Markets Opportunities...  18411038    2021-02-27   \n",
       "1                            iShares MSCI Brazil ETF  15391287    2021-03-30   \n",
       "2           Lazard Emerging Markets Equity Portfolio  11825926    2020-12-30   \n",
       "3  Vanguard International Stock Index-Emerging Ma...  11823037    2021-01-30   \n",
       "4  Vanguard International Stock Index-Total Intl ...  11803398    2021-01-30   \n",
       "5             iShares Core MSCI Emerging Markets ETF   7251713    2021-03-30   \n",
       "6                       iShares Latin America 40 ETF   6206900    2021-03-30   \n",
       "7     Blackrock Ser Inc-Blackrock International Fund   4209764    2021-02-27   \n",
       "8  Nuveen Investment Trust II - International Gro...   3915700    2021-03-30   \n",
       "9  DFA Investment Dimensions-DFA Emerging Mkts Value   3882886    2021-01-30   \n",
       "\n",
       "    % Out      Value  \n",
       "0  0.0064  516429615  \n",
       "1  0.0054  468664689  \n",
       "2  0.0041  458845928  \n",
       "3  0.0041  400328032  \n",
       "4  0.0041  399663056  \n",
       "5  0.0025  220814660  \n",
       "6  0.0022  189000105  \n",
       "7  0.0015  118083880  \n",
       "8  0.0014  119233065  \n",
       "9  0.0014  131474519  "
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ticker.get_institutional_holders()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "ticker.get_mutualfund_holders()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "###### Distribuição acionária"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "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>0</th>\n",
       "      <th>1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>50.00%</td>\n",
       "      <td>% of Shares Held by All Insider</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20.15%</td>\n",
       "      <td>% of Shares Held by Institutions</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>40.31%</td>\n",
       "      <td>% of Float Held by Institutions</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>451</td>\n",
       "      <td>Number of Institutions Holding Shares</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        0                                      1\n",
       "0  50.00%        % of Shares Held by All Insider\n",
       "1  20.15%       % of Shares Held by Institutions\n",
       "2  40.31%        % of Float Held by Institutions\n",
       "3     451  Number of Institutions Holding Shares"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ticker.get_major_holders()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}