Generar dataset.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "#import quandl\n",
    "import dateutil.parser\n",
    "import warnings\n",
    "import glob\n",
    "warnings.filterwarnings('ignore')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>FISCAL_YEAR</th>\n",
       "      <th>BS__ACCOUNTS_PAYABLE</th>\n",
       "      <th>BS__ACCOUNTS_PAYABLE__ACCRUED_EXPENSE</th>\n",
       "      <th>BS__ACCOUNTS_PAYABLE__ACCRUED_EXPENSE_FOR_FINANCIAL_COMPANIES</th>\n",
       "      <th>BS__ACCOUNTS_RECEIVABLE</th>\n",
       "      <th>BS__ACCUMULATED_DEPRECIATION</th>\n",
       "      <th>BS__ACCUMULATED_OTHER_COMPREHENSIVE_INCOME_LOSS</th>\n",
       "      <th>BS__ADDITIONAL_PAID_IN_CAPITAL</th>\n",
       "      <th>BS__ALLOWANCE_FOR_LOANS_AND_LEASE_LOSSES</th>\n",
       "      <th>BS__BUILDINGS_AND_IMPROVEMENTS</th>\n",
       "      <th>...</th>\n",
       "      <th>PRICE_INI</th>\n",
       "      <th>PRICE_FIN</th>\n",
       "      <th>INDEX_RETURNS</th>\n",
       "      <th>RETURNS_NEXT</th>\n",
       "      <th>INDEX_RETURNS_NEXT</th>\n",
       "      <th>RETURNS_CAT</th>\n",
       "      <th>RETURNS_NEXT_CAT</th>\n",
       "      <th>RETURNS_vs_INDEX</th>\n",
       "      <th>RETURNS_vs_INDEX_NEXT</th>\n",
       "      <th>Ticker</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1999-01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.041009</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.043403</td>\n",
       "      <td>NEGATIVE</td>\n",
       "      <td>NEGATIVE</td>\n",
       "      <td>LOSES</td>\n",
       "      <td>LOSES</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1999-04</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.043403</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.004838</td>\n",
       "      <td>NEGATIVE</td>\n",
       "      <td>NEGATIVE</td>\n",
       "      <td>LOSES</td>\n",
       "      <td>WINS</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1999-07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-0.004838</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.025747</td>\n",
       "      <td>NEGATIVE</td>\n",
       "      <td>NEGATIVE</td>\n",
       "      <td>WINS</td>\n",
       "      <td>LOSES</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1999-10</td>\n",
       "      <td>510.0</td>\n",
       "      <td>510.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1635.0</td>\n",
       "      <td>-2270.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3378.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.025747</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-0.074249</td>\n",
       "      <td>NEGATIVE</td>\n",
       "      <td>NEGATIVE</td>\n",
       "      <td>LOSES</td>\n",
       "      <td>WINS</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2000-01</td>\n",
       "      <td>303.0</td>\n",
       "      <td>736.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1445.0</td>\n",
       "      <td>-2226.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>4297.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>45.86</td>\n",
       "      <td>-0.074249</td>\n",
       "      <td>0.248119</td>\n",
       "      <td>0.041572</td>\n",
       "      <td>NEGATIVE</td>\n",
       "      <td>POSITIVE</td>\n",
       "      <td>WINS</td>\n",
       "      <td>WINS</td>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 326 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  FISCAL_YEAR  BS__ACCOUNTS_PAYABLE  BS__ACCOUNTS_PAYABLE__ACCRUED_EXPENSE  \\\n",
       "0     1999-01                   0.0                                    0.0   \n",
       "1     1999-04                   0.0                                    0.0   \n",
       "2     1999-07                   0.0                                    0.0   \n",
       "3     1999-10                 510.0                                  510.0   \n",
       "4     2000-01                 303.0                                  736.0   \n",
       "\n",
       "   BS__ACCOUNTS_PAYABLE__ACCRUED_EXPENSE_FOR_FINANCIAL_COMPANIES  \\\n",
       "0                                                NaN               \n",
       "1                                                NaN               \n",
       "2                                                NaN               \n",
       "3                                                NaN               \n",
       "4                                                NaN               \n",
       "\n",
       "   BS__ACCOUNTS_RECEIVABLE  BS__ACCUMULATED_DEPRECIATION  \\\n",
       "0                      0.0                           0.0   \n",
       "1                      0.0                           0.0   \n",
       "2                      0.0                           0.0   \n",
       "3                   1635.0                       -2270.0   \n",
       "4                   1445.0                       -2226.0   \n",
       "\n",
       "   BS__ACCUMULATED_OTHER_COMPREHENSIVE_INCOME_LOSS  \\\n",
       "0                                              0.0   \n",
       "1                                              0.0   \n",
       "2                                              0.0   \n",
       "3                                              0.0   \n",
       "4                                             53.0   \n",
       "\n",
       "   BS__ADDITIONAL_PAID_IN_CAPITAL  BS__ALLOWANCE_FOR_LOANS_AND_LEASE_LOSSES  \\\n",
       "0                             0.0                                       NaN   \n",
       "1                             0.0                                       NaN   \n",
       "2                             0.0                                       NaN   \n",
       "3                          3378.0                                       NaN   \n",
       "4                          4297.0                                       NaN   \n",
       "\n",
       "   BS__BUILDINGS_AND_IMPROVEMENTS   ...    PRICE_INI  PRICE_FIN  \\\n",
       "0                             0.0   ...          0.0       0.00   \n",
       "1                             0.0   ...          0.0       0.00   \n",
       "2                             0.0   ...          0.0       0.00   \n",
       "3                             0.0   ...          0.0       0.00   \n",
       "4                             0.0   ...          0.0      45.86   \n",
       "\n",
       "   INDEX_RETURNS  RETURNS_NEXT  INDEX_RETURNS_NEXT  RETURNS_CAT  \\\n",
       "0       0.041009      0.000000            0.043403     NEGATIVE   \n",
       "1       0.043403      0.000000           -0.004838     NEGATIVE   \n",
       "2      -0.004838      0.000000            0.025747     NEGATIVE   \n",
       "3       0.025747      0.000000           -0.074249     NEGATIVE   \n",
       "4      -0.074249      0.248119            0.041572     NEGATIVE   \n",
       "\n",
       "   RETURNS_NEXT_CAT  RETURNS_vs_INDEX  RETURNS_vs_INDEX_NEXT  Ticker  \n",
       "0          NEGATIVE             LOSES                  LOSES       A  \n",
       "1          NEGATIVE             LOSES                   WINS       A  \n",
       "2          NEGATIVE              WINS                  LOSES       A  \n",
       "3          NEGATIVE             LOSES                   WINS       A  \n",
       "4          POSITIVE              WINS                   WINS       A  \n",
       "\n",
       "[5 rows x 326 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dd = pd.read_csv('Datos/financials_prices_quaterly_guru_v2.csv', sep=',', header=0)\n",
    "dd.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['A', 'AA', 'AAALF', ..., 'SVKEF', 'SVLC', 'SVLPF'], dtype=object)"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dd['Ticker'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>BALANCE_SHEET__ACCOUNTS_PAYABLE</th>\n",
       "      <th>BALANCE_SHEET__ACCOUNTS_PAYABLE__ACCRUED_EXPENSE</th>\n",
       "      <th>BALANCE_SHEET__ACCOUNTS_PAYABLE__ACCRUED_EXPENSE_FOR_FINANCIAL_COMPANIES</th>\n",
       "      <th>BALANCE_SHEET__ACCOUNTS_RECEIVABLE</th>\n",
       "      <th>BALANCE_SHEET__ACCUMULATED_DEPRECIATION</th>\n",
       "      <th>BALANCE_SHEET__ACCUMULATED_OTHER_COMPREHENSIVE_INCOME_LOSS</th>\n",
       "      <th>BALANCE_SHEET__ADDITIONAL_PAID_IN_CAPITAL</th>\n",
       "      <th>BALANCE_SHEET__ALLOWANCE_FOR_LOANS_AND_LEASE_LOSSES</th>\n",
       "      <th>BALANCE_SHEET__BUILDINGS_AND_IMPROVEMENTS</th>\n",
       "      <th>BALANCE_SHEET__CAPITAL_LEASE_OBLIGATION</th>\n",
       "      <th>...</th>\n",
       "      <th>VALUATION_RATIOS__FORWARD_RATE_OF_RETURN_YACKTMAN</th>\n",
       "      <th>VALUATION_RATIOS__PB_RATIO</th>\n",
       "      <th>VALUATION_RATIOS__PEG_RATIO</th>\n",
       "      <th>VALUATION_RATIOS__PE_RATIO</th>\n",
       "      <th>VALUATION_RATIOS__PRICE_TO_FREE_CASH_FLOW</th>\n",
       "      <th>VALUATION_RATIOS__PRICE_TO_OPERATING_CASH_FLOW</th>\n",
       "      <th>VALUATION_RATIOS__PRICE_TO_OWNER_EARNINGS</th>\n",
       "      <th>VALUATION_RATIOS__PRICE_TO_TANGIBLE_BOOK</th>\n",
       "      <th>VALUATION_RATIOS__PS_RATIO</th>\n",
       "      <th>VALUATION_RATIOS__SHILLER_PE_RATIO</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CODE</th>\n",
       "      <th>FISCAL_YEAR</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></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 rowspan=\"5\" valign=\"top\">YKLTF</th>\n",
       "      <th>2005-03</th>\n",
       "      <td>226.499060</td>\n",
       "      <td>252.198723</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1095.356674</td>\n",
       "      <td>0.0</td>\n",
       "      <td>387.328594</td>\n",
       "      <td>NaN</td>\n",
       "      <td>726.174608</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2006-03</th>\n",
       "      <td>231.373713</td>\n",
       "      <td>269.854994</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1036.803214</td>\n",
       "      <td>0.0</td>\n",
       "      <td>349.213577</td>\n",
       "      <td>NaN</td>\n",
       "      <td>658.368421</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2008-03</th>\n",
       "      <td>236.124427</td>\n",
       "      <td>251.527946</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1223.120761</td>\n",
       "      <td>0.0</td>\n",
       "      <td>406.476227</td>\n",
       "      <td>NaN</td>\n",
       "      <td>866.864769</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2008-09</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>34.09</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.43</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2008-12</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.64</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.10</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 314 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   BALANCE_SHEET__ACCOUNTS_PAYABLE  \\\n",
       "CODE  FISCAL_YEAR                                    \n",
       "YKLTF 2005-03                           226.499060   \n",
       "      2006-03                           231.373713   \n",
       "      2008-03                           236.124427   \n",
       "      2008-09                             0.000000   \n",
       "      2008-12                             0.000000   \n",
       "\n",
       "                   BALANCE_SHEET__ACCOUNTS_PAYABLE__ACCRUED_EXPENSE  \\\n",
       "CODE  FISCAL_YEAR                                                     \n",
       "YKLTF 2005-03                                            252.198723   \n",
       "      2006-03                                            269.854994   \n",
       "      2008-03                                            251.527946   \n",
       "      2008-09                                              0.000000   \n",
       "      2008-12                                              0.000000   \n",
       "\n",
       "                   BALANCE_SHEET__ACCOUNTS_PAYABLE__ACCRUED_EXPENSE_FOR_FINANCIAL_COMPANIES  \\\n",
       "CODE  FISCAL_YEAR                                                                             \n",
       "YKLTF 2005-03                                                    NaN                          \n",
       "      2006-03                                                    NaN                          \n",
       "      2008-03                                                    NaN                          \n",
       "      2008-09                                                    NaN                          \n",
       "      2008-12                                                    NaN                          \n",
       "\n",
       "                   BALANCE_SHEET__ACCOUNTS_RECEIVABLE  \\\n",
       "CODE  FISCAL_YEAR                                       \n",
       "YKLTF 2005-03                                     0.0   \n",
       "      2006-03                                     0.0   \n",
       "      2008-03                                     0.0   \n",
       "      2008-09                                     0.0   \n",
       "      2008-12                                     0.0   \n",
       "\n",
       "                   BALANCE_SHEET__ACCUMULATED_DEPRECIATION  \\\n",
       "CODE  FISCAL_YEAR                                            \n",
       "YKLTF 2005-03                                 -1095.356674   \n",
       "      2006-03                                 -1036.803214   \n",
       "      2008-03                                 -1223.120761   \n",
       "      2008-09                                     0.000000   \n",
       "      2008-12                                     0.000000   \n",
       "\n",
       "                   BALANCE_SHEET__ACCUMULATED_OTHER_COMPREHENSIVE_INCOME_LOSS  \\\n",
       "CODE  FISCAL_YEAR                                                               \n",
       "YKLTF 2005-03                                                    0.0            \n",
       "      2006-03                                                    0.0            \n",
       "      2008-03                                                    0.0            \n",
       "      2008-09                                                    0.0            \n",
       "      2008-12                                                    0.0            \n",
       "\n",
       "                   BALANCE_SHEET__ADDITIONAL_PAID_IN_CAPITAL  \\\n",
       "CODE  FISCAL_YEAR                                              \n",
       "YKLTF 2005-03                                     387.328594   \n",
       "      2006-03                                     349.213577   \n",
       "      2008-03                                     406.476227   \n",
       "      2008-09                                       0.000000   \n",
       "      2008-12                                       0.000000   \n",
       "\n",
       "                   BALANCE_SHEET__ALLOWANCE_FOR_LOANS_AND_LEASE_LOSSES  \\\n",
       "CODE  FISCAL_YEAR                                                        \n",
       "YKLTF 2005-03                                                    NaN     \n",
       "      2006-03                                                    NaN     \n",
       "      2008-03                                                    NaN     \n",
       "      2008-09                                                    NaN     \n",
       "      2008-12                                                    NaN     \n",
       "\n",
       "                   BALANCE_SHEET__BUILDINGS_AND_IMPROVEMENTS  \\\n",
       "CODE  FISCAL_YEAR                                              \n",
       "YKLTF 2005-03                                     726.174608   \n",
       "      2006-03                                     658.368421   \n",
       "      2008-03                                     866.864769   \n",
       "      2008-09                                       0.000000   \n",
       "      2008-12                                       0.000000   \n",
       "\n",
       "                   BALANCE_SHEET__CAPITAL_LEASE_OBLIGATION  \\\n",
       "CODE  FISCAL_YEAR                                            \n",
       "YKLTF 2005-03                                          0.0   \n",
       "      2006-03                                          0.0   \n",
       "      2008-03                                          0.0   \n",
       "      2008-09                                          0.0   \n",
       "      2008-12                                          0.0   \n",
       "\n",
       "                                  ...                  \\\n",
       "CODE  FISCAL_YEAR                 ...                   \n",
       "YKLTF 2005-03                     ...                   \n",
       "      2006-03                     ...                   \n",
       "      2008-03                     ...                   \n",
       "      2008-09                     ...                   \n",
       "      2008-12                     ...                   \n",
       "\n",
       "                   VALUATION_RATIOS__FORWARD_RATE_OF_RETURN_YACKTMAN  \\\n",
       "CODE  FISCAL_YEAR                                                      \n",
       "YKLTF 2005-03                                                    0.0   \n",
       "      2006-03                                                    0.0   \n",
       "      2008-03                                                    0.0   \n",
       "      2008-09                                                    0.0   \n",
       "      2008-12                                                    0.0   \n",
       "\n",
       "                   VALUATION_RATIOS__PB_RATIO  VALUATION_RATIOS__PEG_RATIO  \\\n",
       "CODE  FISCAL_YEAR                                                            \n",
       "YKLTF 2005-03                             0.0                          0.0   \n",
       "      2006-03                             0.0                          0.0   \n",
       "      2008-03                             0.0                          0.0   \n",
       "      2008-09                             0.0                          0.0   \n",
       "      2008-12                             0.0                          0.0   \n",
       "\n",
       "                   VALUATION_RATIOS__PE_RATIO  \\\n",
       "CODE  FISCAL_YEAR                               \n",
       "YKLTF 2005-03                            0.00   \n",
       "      2006-03                            0.00   \n",
       "      2008-03                            0.00   \n",
       "      2008-09                           34.09   \n",
       "      2008-12                           14.64   \n",
       "\n",
       "                   VALUATION_RATIOS__PRICE_TO_FREE_CASH_FLOW  \\\n",
       "CODE  FISCAL_YEAR                                              \n",
       "YKLTF 2005-03                                            0.0   \n",
       "      2006-03                                            0.0   \n",
       "      2008-03                                            0.0   \n",
       "      2008-09                                            0.0   \n",
       "      2008-12                                            0.0   \n",
       "\n",
       "                   VALUATION_RATIOS__PRICE_TO_OPERATING_CASH_FLOW  \\\n",
       "CODE  FISCAL_YEAR                                                   \n",
       "YKLTF 2005-03                                                0.00   \n",
       "      2006-03                                                0.00   \n",
       "      2008-03                                                0.00   \n",
       "      2008-09                                               12.09   \n",
       "      2008-12                                                0.00   \n",
       "\n",
       "                   VALUATION_RATIOS__PRICE_TO_OWNER_EARNINGS  \\\n",
       "CODE  FISCAL_YEAR                                              \n",
       "YKLTF 2005-03                                            NaN   \n",
       "      2006-03                                            NaN   \n",
       "      2008-03                                            NaN   \n",
       "      2008-09                                            NaN   \n",
       "      2008-12                                            NaN   \n",
       "\n",
       "                   VALUATION_RATIOS__PRICE_TO_TANGIBLE_BOOK  \\\n",
       "CODE  FISCAL_YEAR                                             \n",
       "YKLTF 2005-03                                           0.0   \n",
       "      2006-03                                           0.0   \n",
       "      2008-03                                           0.0   \n",
       "      2008-09                                           0.0   \n",
       "      2008-12                                           0.0   \n",
       "\n",
       "                   VALUATION_RATIOS__PS_RATIO  \\\n",
       "CODE  FISCAL_YEAR                               \n",
       "YKLTF 2005-03                            0.00   \n",
       "      2006-03                            0.00   \n",
       "      2008-03                            0.00   \n",
       "      2008-09                            1.43   \n",
       "      2008-12                            2.10   \n",
       "\n",
       "                   VALUATION_RATIOS__SHILLER_PE_RATIO  \n",
       "CODE  FISCAL_YEAR                                      \n",
       "YKLTF 2005-03                                     0.0  \n",
       "      2006-03                                     0.0  \n",
       "      2008-03                                     0.0  \n",
       "      2008-09                                     0.0  \n",
       "      2008-12                                     0.0  \n",
       "\n",
       "[5 rows x 314 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "financialDF = pd.read_csv('Datos/financials_quaterly_guru.csv', sep=',', header=0, index_col=[137,164])\n",
    "financialDF = financialDF.drop(['Unnamed: 0'], axis=1)\n",
    "financialDF.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>BS__ACCOUNTS_PAYABLE</th>\n",
       "      <th>BS__ACCOUNTS_PAYABLE__ACCRUED_EXPENSE</th>\n",
       "      <th>BS__ACCOUNTS_PAYABLE__ACCRUED_EXPENSE_FOR_FINANCIAL_COMPANIES</th>\n",
       "      <th>BS__ACCOUNTS_RECEIVABLE</th>\n",
       "      <th>BS__ACCUMULATED_DEPRECIATION</th>\n",
       "      <th>BS__ACCUMULATED_OTHER_COMPREHENSIVE_INCOME_LOSS</th>\n",
       "      <th>BS__ADDITIONAL_PAID_IN_CAPITAL</th>\n",
       "      <th>BS__ALLOWANCE_FOR_LOANS_AND_LEASE_LOSSES</th>\n",
       "      <th>BS__BUILDINGS_AND_IMPROVEMENTS</th>\n",
       "      <th>BS__CAPITAL_LEASE_OBLIGATION</th>\n",
       "      <th>...</th>\n",
       "      <th>VR__FORWARD_RATE_OF_RETURN_YACKTMAN</th>\n",
       "      <th>VR__PB_RATIO</th>\n",
       "      <th>VR__PEG_RATIO</th>\n",
       "      <th>VR__PE_RATIO</th>\n",
       "      <th>VR__PRICE_TO_FREE_CASH_FLOW</th>\n",
       "      <th>VR__PRICE_TO_OPERATING_CASH_FLOW</th>\n",
       "      <th>VR__PRICE_TO_OWNER_EARNINGS</th>\n",
       "      <th>VR__PRICE_TO_TANGIBLE_BOOK</th>\n",
       "      <th>VR__PS_RATIO</th>\n",
       "      <th>VR__SHILLER_PE_RATIO</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CODE</th>\n",
       "      <th>FISCAL_YEAR</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></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 rowspan=\"5\" valign=\"top\">YKLTF</th>\n",
       "      <th>2005-03</th>\n",
       "      <td>226.499060</td>\n",
       "      <td>252.198723</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1095.356674</td>\n",
       "      <td>0.0</td>\n",
       "      <td>387.328594</td>\n",
       "      <td>NaN</td>\n",
       "      <td>726.174608</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2006-03</th>\n",
       "      <td>231.373713</td>\n",
       "      <td>269.854994</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1036.803214</td>\n",
       "      <td>0.0</td>\n",
       "      <td>349.213577</td>\n",
       "      <td>NaN</td>\n",
       "      <td>658.368421</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2008-03</th>\n",
       "      <td>236.124427</td>\n",
       "      <td>251.527946</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1223.120761</td>\n",
       "      <td>0.0</td>\n",
       "      <td>406.476227</td>\n",
       "      <td>NaN</td>\n",
       "      <td>866.864769</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2008-09</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>34.09</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.43</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2008-12</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.64</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.10</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 314 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   BS__ACCOUNTS_PAYABLE  \\\n",
       "CODE  FISCAL_YEAR                         \n",
       "YKLTF 2005-03                226.499060   \n",
       "      2006-03                231.373713   \n",
       "      2008-03                236.124427   \n",
       "      2008-09                  0.000000   \n",
       "      2008-12                  0.000000   \n",
       "\n",
       "                   BS__ACCOUNTS_PAYABLE__ACCRUED_EXPENSE  \\\n",
       "CODE  FISCAL_YEAR                                          \n",
       "YKLTF 2005-03                                 252.198723   \n",
       "      2006-03                                 269.854994   \n",
       "      2008-03                                 251.527946   \n",
       "      2008-09                                   0.000000   \n",
       "      2008-12                                   0.000000   \n",
       "\n",
       "                   BS__ACCOUNTS_PAYABLE__ACCRUED_EXPENSE_FOR_FINANCIAL_COMPANIES  \\\n",
       "CODE  FISCAL_YEAR                                                                  \n",
       "YKLTF 2005-03                                                    NaN               \n",
       "      2006-03                                                    NaN               \n",
       "      2008-03                                                    NaN               \n",
       "      2008-09                                                    NaN               \n",
       "      2008-12                                                    NaN               \n",
       "\n",
       "                   BS__ACCOUNTS_RECEIVABLE  BS__ACCUMULATED_DEPRECIATION  \\\n",
       "CODE  FISCAL_YEAR                                                          \n",
       "YKLTF 2005-03                          0.0                  -1095.356674   \n",
       "      2006-03                          0.0                  -1036.803214   \n",
       "      2008-03                          0.0                  -1223.120761   \n",
       "      2008-09                          0.0                      0.000000   \n",
       "      2008-12                          0.0                      0.000000   \n",
       "\n",
       "                   BS__ACCUMULATED_OTHER_COMPREHENSIVE_INCOME_LOSS  \\\n",
       "CODE  FISCAL_YEAR                                                    \n",
       "YKLTF 2005-03                                                  0.0   \n",
       "      2006-03                                                  0.0   \n",
       "      2008-03                                                  0.0   \n",
       "      2008-09                                                  0.0   \n",
       "      2008-12                                                  0.0   \n",
       "\n",
       "                   BS__ADDITIONAL_PAID_IN_CAPITAL  \\\n",
       "CODE  FISCAL_YEAR                                   \n",
       "YKLTF 2005-03                          387.328594   \n",
       "      2006-03                          349.213577   \n",
       "      2008-03                          406.476227   \n",
       "      2008-09                            0.000000   \n",
       "      2008-12                            0.000000   \n",
       "\n",
       "                   BS__ALLOWANCE_FOR_LOANS_AND_LEASE_LOSSES  \\\n",
       "CODE  FISCAL_YEAR                                             \n",
       "YKLTF 2005-03                                           NaN   \n",
       "      2006-03                                           NaN   \n",
       "      2008-03                                           NaN   \n",
       "      2008-09                                           NaN   \n",
       "      2008-12                                           NaN   \n",
       "\n",
       "                   BS__BUILDINGS_AND_IMPROVEMENTS  \\\n",
       "CODE  FISCAL_YEAR                                   \n",
       "YKLTF 2005-03                          726.174608   \n",
       "      2006-03                          658.368421   \n",
       "      2008-03                          866.864769   \n",
       "      2008-09                            0.000000   \n",
       "      2008-12                            0.000000   \n",
       "\n",
       "                   BS__CAPITAL_LEASE_OBLIGATION          ...           \\\n",
       "CODE  FISCAL_YEAR                                        ...            \n",
       "YKLTF 2005-03                               0.0          ...            \n",
       "      2006-03                               0.0          ...            \n",
       "      2008-03                               0.0          ...            \n",
       "      2008-09                               0.0          ...            \n",
       "      2008-12                               0.0          ...            \n",
       "\n",
       "                   VR__FORWARD_RATE_OF_RETURN_YACKTMAN  VR__PB_RATIO  \\\n",
       "CODE  FISCAL_YEAR                                                      \n",
       "YKLTF 2005-03                                      0.0           0.0   \n",
       "      2006-03                                      0.0           0.0   \n",
       "      2008-03                                      0.0           0.0   \n",
       "      2008-09                                      0.0           0.0   \n",
       "      2008-12                                      0.0           0.0   \n",
       "\n",
       "                   VR__PEG_RATIO  VR__PE_RATIO  VR__PRICE_TO_FREE_CASH_FLOW  \\\n",
       "CODE  FISCAL_YEAR                                                             \n",
       "YKLTF 2005-03                0.0          0.00                          0.0   \n",
       "      2006-03                0.0          0.00                          0.0   \n",
       "      2008-03                0.0          0.00                          0.0   \n",
       "      2008-09                0.0         34.09                          0.0   \n",
       "      2008-12                0.0         14.64                          0.0   \n",
       "\n",
       "                   VR__PRICE_TO_OPERATING_CASH_FLOW  \\\n",
       "CODE  FISCAL_YEAR                                     \n",
       "YKLTF 2005-03                                  0.00   \n",
       "      2006-03                                  0.00   \n",
       "      2008-03                                  0.00   \n",
       "      2008-09                                 12.09   \n",
       "      2008-12                                  0.00   \n",
       "\n",
       "                   VR__PRICE_TO_OWNER_EARNINGS  VR__PRICE_TO_TANGIBLE_BOOK  \\\n",
       "CODE  FISCAL_YEAR                                                            \n",
       "YKLTF 2005-03                              NaN                         0.0   \n",
       "      2006-03                              NaN                         0.0   \n",
       "      2008-03                              NaN                         0.0   \n",
       "      2008-09                              NaN                         0.0   \n",
       "      2008-12                              NaN                         0.0   \n",
       "\n",
       "                   VR__PS_RATIO  VR__SHILLER_PE_RATIO  \n",
       "CODE  FISCAL_YEAR                                      \n",
       "YKLTF 2005-03              0.00                   0.0  \n",
       "      2006-03              0.00                   0.0  \n",
       "      2008-03              0.00                   0.0  \n",
       "      2008-09              1.43                   0.0  \n",
       "      2008-12              2.10                   0.0  \n",
       "\n",
       "[5 rows x 314 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Renombro las columnas\n",
    "financialDF.columns = ['BS__ACCOUNTS_PAYABLE',\n",
    "'BS__ACCOUNTS_PAYABLE__ACCRUED_EXPENSE',\n",
    "'BS__ACCOUNTS_PAYABLE__ACCRUED_EXPENSE_FOR_FINANCIAL_COMPANIES',\n",
    "'BS__ACCOUNTS_RECEIVABLE',\n",
    "'BS__ACCUMULATED_DEPRECIATION',\n",
    "'BS__ACCUMULATED_OTHER_COMPREHENSIVE_INCOME_LOSS',\n",
    "'BS__ADDITIONAL_PAID_IN_CAPITAL',\n",
    "'BS__ALLOWANCE_FOR_LOANS_AND_LEASE_LOSSES',\n",
    "'BS__BUILDINGS_AND_IMPROVEMENTS',\n",
    "'BS__CAPITAL_LEASE_OBLIGATION',\n",
    "'BS__CASH_AND_CASH_EQUIVALENTS',\n",
    "'BS__CASH_CASH_EQUIVALENTS_MARKETABLE_SECURITIES',\n",
    "'BS__COMMON_STOCK',\n",
    "'BS__CONSTRUCTION_IN_PROGRESS',\n",
    "'BS__CURRENT_ACCRUED_EXPENSE',\n",
    "'BS__CURRENT_DEFERRED_REVENUE',\n",
    "'BS__CURRENT_DEFERRED_TAXES_LIABILITIES',\n",
    "'BS__CURRENT_PORTION_OF_LONG_TERM_DEBT',\n",
    "'BS__DEBT_TO_EQUITY',\n",
    "'BS__DEFERREDTAXANDREVENUE',\n",
    "'BS__DEFERRED_POLICY_ACQUISITION_COSTS',\n",
    "'BS__EQUITY_INVESTMENTS',\n",
    "'BS__EQUITY_TO_ASSET',\n",
    "'BS__FIXED_MATURITY_INVESTMENT',\n",
    "'BS__FUTURE_POLICY_BENEFITS',\n",
    "'BS__GOODWILL',\n",
    "'BS__GROSS_PROPERTY_PLANT_AND_EQUIPMENT',\n",
    "'BS__INTANGIBLE_ASSETS',\n",
    "'BS__INVENTORIES_FINISHED_GOODS',\n",
    "'BS__INVENTORIES_INVENTORIES_ADJUSTMENTS',\n",
    "'BS__INVENTORIES_OTHER',\n",
    "'BS__INVENTORIES_RAW_MATERIALS__COMPONENTS',\n",
    "'BS__INVENTORIES_WORK_IN_PROCESS',\n",
    "'BS__INVESTMENTS_AND_ADVANCES',\n",
    "'BS__LAND_AND_IMPROVEMENTS',\n",
    "'BS__LONG_TERM_DEBT',\n",
    "'BS__LONG_TERM_DEBT__CAPITAL_LEASE_OBLIGATION',\n",
    "'BS__MACHINERY_FURNITURE_EQUIPMENT',\n",
    "'BS__MARKETABLE_SECURITIES',\n",
    "'BS__MINORITY_INTEREST',\n",
    "'BS__MONEY_MARKET_INVESTMENTS',\n",
    "'BS__NET_LOAN',\n",
    "'BS__NONCURRENT_DEFERRED_LIABILITIES',\n",
    "'BS__NOTES_RECEIVABLE',\n",
    "'BS__OTHER_ASSETS_FOR_BANKS',\n",
    "'BS__OTHER_ASSETS_FOR_INSURANCE_COMPANIES',\n",
    "'BS__OTHER_CURRENT_ASSETS',\n",
    "'BS__OTHER_CURRENT_LIABILITIES',\n",
    "'BS__OTHER_CURRENT_PAYABLES',\n",
    "'BS__OTHER_CURRENT_RECEIVABLES',\n",
    "'BS__OTHER_GROSS_PPE',\n",
    "'BS__OTHER_LIABILITIES_FOR_BANKS',\n",
    "'BS__OTHER_LIABILITIES_FOR_INSURANCE_COMPANIES',\n",
    "'BS__OTHER_LONG_TERM_ASSETS',\n",
    "'BS__OTHER_LONG_TERM_LIABILITIES',\n",
    "'BS__OTHER_STOCKHOLDERS_EQUITY',\n",
    "'BS__PENSIONANDRETIREMENTBENEFIT',\n",
    "'BS__POLICYHOLDER_FUNDS',\n",
    "'BS__PREFERRED_STOCK',\n",
    "'BS__PROPERTY_PLANT_AND_EQUIPMENT',\n",
    "'BS__RETAINED_EARNINGS',\n",
    "'BS__SECURITIES__INVESTMENTS',\n",
    "'BS__SHORT_TERM_INVESTMENTS',\n",
    "'BS__TOTAL_ASSETS',\n",
    "'BS__TOTAL_CURRENT_ASSETS',\n",
    "'BS__TOTAL_CURRENT_LIABILITIES',\n",
    "'BS__TOTAL_DEPOSITS',\n",
    "'BS__TOTAL_EQUITY',\n",
    "'BS__TOTAL_INVENTORIES',\n",
    "'BS__TOTAL_INVESTMENTS',\n",
    "'BS__TOTAL_LIABILITIES',\n",
    "'BS__TOTAL_RECEIVABLES',\n",
    "'BS__TOTAL_STOCKHOLDERS_EQUITY',\n",
    "'BS__TOTAL_TAX_PAYABLE',\n",
    "'BS__TREASURY_STOCK',\n",
    "'BS__UNEARNED_PREMIUMS',\n",
    "'BS__UNPAID_LOSS__LOSS_RESERVE',\n",
    "'CS__ALL_TAXES_PAID',\n",
    "'CS__CAPITAL_EXPENDITURE',\n",
    "'CS__CASH_FLOW_FOR_DIVIDENDS',\n",
    "'CS__CASH_FLOW_FROM_DISCONTINUED_OPERATIONS',\n",
    "'CS__CASH_FLOW_FROM_FINANCING',\n",
    "'CS__CASH_FLOW_FROM_INVESTING',\n",
    "'CS__CASH_FLOW_FROM_OPERATIONS',\n",
    "'CS__CASH_FLOW_FROM_OTHERS',\n",
    "'CS__CASH_FROM_DISCONTINUED_INVESTING_ACTIVITIES',\n",
    "'CS__CASH_FROM_OTHER_INVESTING_ACTIVITIES',\n",
    "'CS__CASH_PAID_FOR_INSURANCE_ACTIVITIES',\n",
    "'CS__CASH_PAYMENTS',\n",
    "'CS__CASH_PAYMENTS_FOR_DEPOSITS_BY_BANKS_AND_CUSTOMERS',\n",
    "'CS__CASH_PAYMENTS_FOR_LOANS',\n",
    "'CS__CASH_RECEIPTS_FROM_DEPOSITS_BY_BANKS_AND_CUSTOMERS',\n",
    "'CS__CASH_RECEIPTS_FROM_FEES_AND_COMMISSIONS',\n",
    "'CS__CASH_RECEIPTS_FROM_LOANS',\n",
    "'CS__CASH_RECEIPTS_FROM_OPERATING_ACTIVITIES',\n",
    "'CS__CASH_RECEIPTS_FROM_SECURITIES_RELATED_ACTIVITIES',\n",
    "'CS__CASH_RECEIPTS_FROM_TAX_REFUNDS',\n",
    "'CS__CASH_RECEIVED_FROM_INSURANCE_ACTIVITIES',\n",
    "'CS__CHANGE_IN_DEFERREDTAX',\n",
    "'CS__CHANGE_IN_INVENTORY',\n",
    "'CS__CHANGE_IN_PAYABLES_AND_ACCRUED_EXPENSE',\n",
    "'CS__CHANGE_IN_PREPAID_ASSETS',\n",
    "'CS__CHANGE_IN_RECEIVABLES',\n",
    "'CS__CHANGE_IN_WORKING_CAPITAL',\n",
    "'CS__DEPRECIATION_DEPLETION_AND_AMORTIZATION',\n",
    "'CS__DIVIDENDS_PAID',\n",
    "'CS__DIVIDENDS_RECEIVED',\n",
    "'CS__FFO',\n",
    "'CS__FREE_CASH_FLOW',\n",
    "'CS__INTEREST_AND_COMMISSION_PAID',\n",
    "'CS__INTEREST_PAID',\n",
    "'CS__INTEREST_RECEIVED',\n",
    "'CS__ISSUANCE_OF_STOCK',\n",
    "'CS__NET_CHANGE_IN_CASH',\n",
    "'CS__NET_FOREIGN_CURRENCY_EXCHANGE_GAIN',\n",
    "'CS__NET_INCOME',\n",
    "'CS__NET_INCOME_FROM_CONTINUING_OPERATIONS',\n",
    "'CS__NET_INTANGIBLES_PURCHASE_AND_SALE',\n",
    "'CS__NET_ISSUANCE_OF_DEBT',\n",
    "'CS__NET_ISSUANCE_OF_PREFERRED_STOCK',\n",
    "'CS__OTHER_CASH_PAYMENTS_FROM_OPERATING_ACTIVITIES',\n",
    "'CS__OTHER_CASH_RECEIPTS_FROM_OPERATING_ACTIVITIES',\n",
    "'CS__OTHER_FINANCING',\n",
    "'CS__PAYMENTS_ON_BEHALF_OF_EMPLOYEES',\n",
    "'CS__PAYMENTS_TO_SUPPLIERS_FOR_GOODS_AND_SERVICES',\n",
    "'CS__PURCHASE_OF_BUSINESS',\n",
    "'CS__PURCHASE_OF_INVESTMENT',\n",
    "'CS__PURCHASE_OF_PROPERTY_PLANT_EQUIPMENT',\n",
    "'CS__RECEIPTS_FROM_CUSTOMERS',\n",
    "'CS__RECEIPTS_FROM_GOVERNMENT_GRANTS',\n",
    "'CS__REPURCHASE_OF_STOCK',\n",
    "'CS__SALE_OF_BUSINESS',\n",
    "'CS__SALE_OF_INVESTMENT',\n",
    "'CS__SALE_OF_PROPERTY_PLANT_EQUIPMENT',\n",
    "'CS__STOCK_BASED_COMPENSATION',\n",
    "'CS__TAXES_REFUND_PAID',\n",
    "'CSR__ASSET_TURNOVER',\n",
    "'CSR__CASH_CONVERSION_CYCLE',\n",
    "'CSR__COGS_TO_REVENUE',\n",
    "'CSR__DAYS_INVENTORY',\n",
    "'CSR__DAYS_PAYABLE',\n",
    "'CSR__DAYS_SALES_OUTSTANDING',\n",
    "'CSR__DEBT_TO_ASSET',\n",
    "'CSR__DEBT_TO_EQUITY',\n",
    "'CSR__DIVIDEND_PAYOUT_RATIO',\n",
    "'CSR__DIVIDEND_PAYOUT_TO_FFO',\n",
    "'CSR__EFFECTIVE_INTEREST_RATE_ON_DEBT',\n",
    "'CSR__EQUITY_TO_ASSET',\n",
    "'CSR__FCF_MARGIN',\n",
    "'CSR__GROSS_MARGIN',\n",
    "'CSR__GROSS_PROFIT_TO_ASSET',\n",
    "'CSR__INVENTORY_TO_REVENUE',\n",
    "'CSR__INVENTORY_TURNOVER',\n",
    "'CSR__NET_INTEREST_MARGIN_BANK_ONLY',\n",
    "'CSR__NET_MARGIN',\n",
    "'CSR__OPERATING_MARGIN',\n",
    "'CSR__ROA',\n",
    "'CSR__ROC_JOEL_GREENBLATT',\n",
    "'CSR__ROE',\n",
    "'CSR__ROE__ADJUSTED_TO_BOOK_VALUE',\n",
    "'CSR__ROIC',\n",
    "'CSR__WACC',\n",
    "'IS__ADVERTISING',\n",
    "'IS__COST_OF_GOODS_SOLD',\n",
    "'IS__CREDIT_LOSSES_PROVISION',\n",
    "'IS__DEPRECIATION_DEPLETION_AND_AMORTIZATION',\n",
    "'IS__EBITDA',\n",
    "'IS__EPS_BASIC',\n",
    "'IS__EPS_DILUTED',\n",
    "'IS__FEES_AND_OTHER_INCOME',\n",
    "'IS__GAIN_ON_SALE_OF_SECURITY',\n",
    "'IS__GROSS_MARGIN',\n",
    "'IS__GROSS_PROFIT',\n",
    "'IS__IMPAIRMENT_OF_CAPITAL_ASSETS',\n",
    "'IS__INTEREST_EXPENSE',\n",
    "'IS__INTEREST_EXPENSE_POSITIVE',\n",
    "'IS__INTEREST_INCOME',\n",
    "'IS__NET_INCOME',\n",
    "'IS__NET_INCOME_CONTINUING_OPERATIONS',\n",
    "'IS__NET_INCOME_DISCONTINUED_OPERATIONS',\n",
    "'IS__NET_INTEREST_INCOME',\n",
    "'IS__NET_INTEREST_INCOME_FOR_BANKS',\n",
    "'IS__NET_INVESTMENT_INCOME',\n",
    "'IS__NET_MARGIN',\n",
    "'IS__NET_POLICYHOLDER_BENEFITS_CLAIMS',\n",
    "'IS__NON_INTEREST_INCOME',\n",
    "'IS__NON_OPERATING_INCOME',\n",
    "'IS__OPERATING_INCOME',\n",
    "'IS__OPERATING_MARGIN',\n",
    "'IS__OTHER_EXPENSE',\n",
    "'IS__OTHER_INCOME_EXPENSE',\n",
    "'IS__OTHER_INCOME_MINORITY_INTEREST',\n",
    "'IS__OTHER_NONINTEREST_EXPENSE',\n",
    "'IS__OTHER_OPERATING_EXPENSE',\n",
    "'IS__POLICY_ACQUISITION_EXPENSE',\n",
    "'IS__PREFERRED_DIVIDENDS',\n",
    "'IS__PRE_TAX_INCOME',\n",
    "'IS__RESEARCH__DEVELOPMENT',\n",
    "'IS__RESTRUCTURING_AND_MERGERN_ACQUISITION',\n",
    "'IS__REVENUE',\n",
    "'IS__SELLING_GENERAL__ADMIN_EXPENSE',\n",
    "'IS__SHARES_OUTSTANDING_DILUTED_AVERAGE',\n",
    "'IS__SPECIALCHARGES',\n",
    "'IS__TAX_PROVISION',\n",
    "'IS__TAX_RATE',\n",
    "'IS__TOTAL_PREMIUMS_EARNED',\n",
    "'IS__WRITE_OFF',\n",
    "'PSDA__BOOK_VALUE_PER_SHARE',\n",
    "'PSDA__DIVIDENDS_PER_SHARE',\n",
    "'PSDA__EARNINGS_PER_SHARE_DILUTED',\n",
    "'PSDA__EBITDA_PER_SHARE',\n",
    "'PSDA__EBIT_PER_SHARE',\n",
    "'PSDA__EPS_WITHOUT_NRI',\n",
    "'PSDA__FFO_PER_SHARE',\n",
    "'PSDA__FREE_CASH_FLOW_PER_SHARE',\n",
    "'PSDA__MONTH_END_STOCK_PRICE',\n",
    "'PSDA__OPERATING_CASH_FLOW_PER_SHARE',\n",
    "'PSDA__OWNER_EARNINGS_PER_SHARE_TTM',\n",
    "'PSDA__REVENUE_PER_SHARE',\n",
    "'PSDA__TANGIBLE_BOOK_PER_SHARE',\n",
    "'PSDA__TOTAL_DEBT_PER_SHARE',\n",
    "'PRELIMINARY',\n",
    "'REGION',\n",
    "'VQ__5_YEAR_EBITDA_GROWTH_RATE',\n",
    "'VQ__ALTMAN_Z_SCORE',\n",
    "'VQ__BENEISH_M_SCORE',\n",
    "'VQ__BETA',\n",
    "'VQ__CURRENT_RATIO',\n",
    "'VQ__EARNINGS_POWER_VALUE_EPV',\n",
    "'VQ__ENTERPRISE_VALUE',\n",
    "'VQ__FILING_DATE',\n",
    "'VQ__FOREX_RATE_USD_ARS',\n",
    "'VQ__FOREX_RATE_USD_AUD',\n",
    "'VQ__FOREX_RATE_USD_BRL',\n",
    "'VQ__FOREX_RATE_USD_CAD',\n",
    "'VQ__FOREX_RATE_USD_CHF',\n",
    "'VQ__FOREX_RATE_USD_CLP',\n",
    "'VQ__FOREX_RATE_USD_CNY',\n",
    "'VQ__FOREX_RATE_USD_COP',\n",
    "'VQ__FOREX_RATE_USD_CZK',\n",
    "'VQ__FOREX_RATE_USD_DKK',\n",
    "'VQ__FOREX_RATE_USD_EGP',\n",
    "'VQ__FOREX_RATE_USD_EUR',\n",
    "'VQ__FOREX_RATE_USD_GBP',\n",
    "'VQ__FOREX_RATE_USD_GEL',\n",
    "'VQ__FOREX_RATE_USD_HKD',\n",
    "'VQ__FOREX_RATE_USD_HUF',\n",
    "'VQ__FOREX_RATE_USD_IDR',\n",
    "'VQ__FOREX_RATE_USD_ILS',\n",
    "'VQ__FOREX_RATE_USD_INR',\n",
    "'VQ__FOREX_RATE_USD_JPY',\n",
    "'VQ__FOREX_RATE_USD_KRW',\n",
    "'VQ__FOREX_RATE_USD_LBP',\n",
    "'VQ__FOREX_RATE_USD_MAD',\n",
    "'VQ__FOREX_RATE_USD_MXN',\n",
    "'VQ__FOREX_RATE_USD_MYR',\n",
    "'VQ__FOREX_RATE_USD_NAD',\n",
    "'VQ__FOREX_RATE_USD_NGN',\n",
    "'VQ__FOREX_RATE_USD_NOK',\n",
    "'VQ__FOREX_RATE_USD_NZD',\n",
    "'VQ__FOREX_RATE_USD_PEN',\n",
    "'VQ__FOREX_RATE_USD_PHP',\n",
    "'VQ__FOREX_RATE_USD_PLN',\n",
    "'VQ__FOREX_RATE_USD_RUB',\n",
    "'VQ__FOREX_RATE_USD_SAR',\n",
    "'VQ__FOREX_RATE_USD_SEK',\n",
    "'VQ__FOREX_RATE_USD_SGD',\n",
    "'VQ__FOREX_RATE_USD_THB',\n",
    "'VQ__FOREX_RATE_USD_TRY',\n",
    "'VQ__FOREX_RATE_USD_TWD',\n",
    "'VQ__FOREX_RATE_USD_UAH',\n",
    "'VQ__FOREX_RATE_USD_VEF',\n",
    "'VQ__FOREX_RATE_USD_ZAR',\n",
    "'VQ__GRAHAM_NUMBER',\n",
    "'VQ__HIGHEST_STOCK_PRICE',\n",
    "'VQ__INTEREST_COVERAGE',\n",
    "'VQ__INTRINSIC_VALUE_PROJECTED_FCF',\n",
    "'VQ__LOWEST_STOCK_PRICE',\n",
    "'VQ__MARKET_CAP',\n",
    "'VQ__MEDIAN_PB_VALUE',\n",
    "'VQ__MEDIAN_PS_VALUE',\n",
    "'VQ__MONTH_END_STOCK_PRICE',\n",
    "'VQ__NET_CASH_PER_SHARE',\n",
    "'VQ__NET_CURRENT_ASSET_VALUE',\n",
    "'VQ__NET_NET_WORKING_CAPITAL',\n",
    "'VQ__NUMBER_OF_EMPLOYEES',\n",
    "'VQ__NUMBER_OF_SHAREHOLDERS',\n",
    "'VQ__PETER_LYNCH_FAIR_VALUE',\n",
    "'VQ__PIOTROSKI_F_SCORE',\n",
    "'VQ__QUICK_RATIO',\n",
    "'VQ__RESTATED_FILING_DATE',\n",
    "'VQ__SCALED_NET_OPERATING_ASSETS',\n",
    "'VQ__SHARES_BUYBACK_RATIO',\n",
    "'VQ__SHARES_OUTSTANDING_BASIC_AVERAGE',\n",
    "'VQ__SHARES_OUTSTANDING_EOP',\n",
    "'VQ__SLOAN_RATIO',\n",
    "'VQ__YOY_EBITDA_GROWTH',\n",
    "'VQ__YOY_EPS_GROWTH',\n",
    "'VQ__YOY_REV_PER_SH_GROWTH',\n",
    "'VR__DIVIDEND_YIELD',\n",
    "'VR__EARNINGS_YIELD_JOEL_GREENBLATT',\n",
    "'VR__EV_TO_EBIT',\n",
    "'VR__EV_TO_EBITDA',\n",
    "'VR__EV_TO_REVENUE',\n",
    "'VR__FORWARD_RATE_OF_RETURN_YACKTMAN',\n",
    "'VR__PB_RATIO',\n",
    "'VR__PEG_RATIO',\n",
    "'VR__PE_RATIO',\n",
    "'VR__PRICE_TO_FREE_CASH_FLOW',\n",
    "'VR__PRICE_TO_OPERATING_CASH_FLOW',\n",
    "'VR__PRICE_TO_OWNER_EARNINGS',\n",
    "'VR__PRICE_TO_TANGIBLE_BOOK',\n",
    "'VR__PS_RATIO',\n",
    "'VR__SHILLER_PE_RATIO']\n",
    "financialDF.head() "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Tenemos 9500 compañias\n"
     ]
    }
   ],
   "source": [
    "lista_companias = financialDF.index.levels[0]\n",
    "print('Tenemos',len(lista_companias),'compañias')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0 : SVMK\n",
      "1 : SVNDF\n",
      "2 : SVNDY\n",
      "3 : SVNLF\n",
      "4 : SVNT\n",
      "5 : SVRGF\n",
      "6 : SVT\n",
      "7 : SVU\n",
      "8 : SVVTF\n",
      "9 : SVVZF\n",
      "10 : SWDAF\n",
      "11 : SWDBY\n",
      "12 : SWDHF\n",
      "13 : SWEE\n",
      "14 : SWGAF\n",
      "15 : SWHN\n",
      "16 : SWIR\n",
      "17 : SWKS\n",
      "18 : SWM\n",
      "19 : SWMAY\n",
      "20 : SWN\n",
      "21 : SWNLF\n",
      "22 : SWPFF\n",
      "23 : SWPIF\n",
      "24 : SWPRF\n",
      "25 : SWRAF\n",
      "26 : SWRBF\n",
      "27 : SWRBY\n",
      "28 : SWROY\n",
      "29 : SWSH\n",
      "30 : SWSKF\n",
      "31 : SWSSF\n",
      "32 : SWYBF\n",
      "33 : SWYBY\n",
      "34 : SWZCF\n",
      "35 : SWZNF\n",
      "36 : SXC\n",
      "37 : SXGAF\n",
      "38 : SXMDF\n",
      "39 : SXNTF\n",
      "40 : SXOOF\n",
      "41 : SXYEY\n",
      "42 : SYA\n",
      "43 : SYAAF\n",
      "44 : SYANF\n",
      "45 : SYANY\n",
      "46 : SYATF\n",
      "47 : SYBF\n",
      "48 : SYBJF\n",
      "49 : SYBT\n",
      "50 : SYENF\n",
      "51 : SYEV\n",
      "52 : SYF\n",
      "53 : SYFHF\n",
      "54 : SYHEF\n",
      "55 : SYIEF\n",
      "56 : SYIEY\n",
      "57 : SYKWF\n",
      "58 : SYMC\n",
      "59 : SYN\n",
      "60 : SYNC\n",
      "61 : SYNL\n",
      "62 : SYNYY\n",
      "63 : SYT\n",
      "64 : SYUT\n",
      "65 : SYYC\n",
      "66 : SYZLF\n",
      "67 : SZBHF\n",
      "68 : SZBI\n",
      "69 : SZCRF\n",
      "70 : SZEVY\n",
      "71 : SZGPF\n",
      "72 : SZHFF\n",
      "73 : SZHNF\n",
      "74 : SZKBF\n",
      "75 : SZKMY\n",
      "76 : SZLMY\n",
      "77 : SZMK\n",
      "78 : SZNTF\n",
      "79 : SZNTY\n",
      "80 : T\n",
      "81 : TABCF\n",
      "82 : TAC\n",
      "83 : TACI\n",
      "84 : TACJF\n",
      "85 : TACYY\n",
      "86 : TAER\n",
      "87 : TAFFF\n",
      "88 : TAGOF\n",
      "89 : TAHO\n",
      "90 : TAICY\n",
      "91 : TAIPY\n",
      "92 : TAISF\n",
      "93 : TAIT\n",
      "94 : TAKD\n",
      "95 : TALO\n",
      "96 : TAMG\n",
      "97 : TANEF\n",
      "98 : TAOEF\n",
      "99 : TAOIF\n",
      "100 : TAP\n",
      "101 : TAP.A\n",
      "102 : TAPCF\n",
      "103 : TAPOF\n",
      "104 : TAQR\n",
      "105 : TASEF\n",
      "106 : TAST\n",
      "107 : TATT\n",
      "108 : TATYF\n",
      "109 : TATYY\n",
      "110 : TAUG\n",
      "111 : TAVHY\n",
      "112 : TAWNF\n",
      "113 : TAWNY\n",
      "114 : TAXA\n",
      "115 : TBBK\n",
      "116 : TBCCF\n",
      "117 : TBGPF\n",
      "118 : TBIO\n",
      "119 : TBLEF\n",
      "120 : TBMIF\n",
      "121 : TBNC\n",
      "122 : TBNK\n",
      "123 : TBPMF\n",
      "124 : TBRG\n",
      "125 : TBRIF\n",
      "126 : TBTC\n",
      "127 : TBUFF\n",
      "128 : TBVPF\n",
      "129 : TCBI\n",
      "130 : TCBK\n",
      "131 : TCCMF\n",
      "132 : TCCNY\n",
      "133 : TCEC\n",
      "134 : TCEHY\n",
      "135 : TCF\n",
      "136 : TCFC\n",
      "137 : TCGN\n",
      "138 : TCHC\n",
      "139 : TCIJF\n",
      "140 : TCKGY\n",
      "141 : TCKRF\n",
      "142 : TCLAF\n",
      "143 : TCLHF\n",
      "144 : TCLRY\n",
      "145 : TCNB\n",
      "146 : TCNT\n",
      "147 : TCPC\n",
      "148 : TCPFF\n",
      "149 : TCPIF\n",
      "150 : TCPP\n",
      "151 : TCPTF\n",
      "152 : TCRD\n",
      "153 : TCTZF\n",
      "154 : TCX\n",
      "155 : TCYMF\n",
      "156 : TD\n",
      "157 : TDAC\n",
      "158 : TDBK\n",
      "159 : TDBOY\n",
      "160 : TDBSF\n",
      "161 : TDCAF\n",
      "162 : TDG\n",
      "163 : TDHOY\n",
      "164 : TDLAF\n",
      "165 : TDNOF\n",
      "166 : TDPAY\n",
      "167 : TDRLF\n",
      "168 : TDRRF\n",
      "169 : TDRYF\n",
      "170 : TDS\n",
      "171 : TDSNA\n",
      "172 : TDW\n",
      "173 : TDY\n",
      "174 : TDYT\n",
      "175 : TE\n",
      "176 : TEAR\n",
      "177 : TECD\n",
      "178 : TECH\n",
      "179 : TECK\n",
      "180 : TEDU\n",
      "181 : TEF\n",
      "182 : TEFOF\n",
      "183 : TEGY\n",
      "184 : TEKXF\n",
      "185 : TELLF\n",
      "186 : TEN\n",
      "187 : TENB\n",
      "188 : TENG\n",
      "189 : TEO\n",
      "190 : TEP\n",
      "191 : TER\n",
      "192 : TERP\n",
      "193 : TETHF\n",
      "194 : TETZF\n",
      "195 : TEUTF\n",
      "196 : TEVE\n",
      "197 : TEVJF\n",
      "198 : TEZNY\n",
      "199 : TFCCF\n",
      "200 : TFIFF\n",
      "201 : TFLG\n",
      "202 : TFOXL\n",
      "203 : TFRFF\n",
      "204 : TFSCF\n",
      "205 : TG\n",
      "206 : TGAFF\n",
      "207 : TGASF\n",
      "208 : TGATF\n",
      "209 : TGCDF\n",
      "210 : TGE\n",
      "211 : TGISQ\n",
      "212 : TGLP\n",
      "213 : TGLTY\n",
      "214 : TGLVY\n",
      "215 : TGRAF\n",
      "216 : TGRF\n",
      "217 : TGRLF\n",
      "218 : TGSNF\n",
      "219 : TGT\n",
      "220 : TGTMF\n",
      "221 : TGTNF\n",
      "222 : TGVSF\n",
      "223 : TGXSF\n",
      "224 : THC\n",
      "225 : THCBF\n",
      "226 : THDS\n",
      "227 : THERF\n",
      "228 : THFF\n",
      "229 : THIXY\n",
      "230 : THLM\n",
      "231 : THM\n",
      "232 : THMG\n",
      "233 : THMNF\n",
      "234 : THMNY\n",
      "235 : THO\n",
      "236 : THOR\n",
      "237 : THRLF\n",
      "238 : THRO\n",
      "239 : THRPF\n",
      "240 : THRSF\n",
      "241 : THS\n",
      "242 : THTI\n",
      "243 : THURF\n",
      "244 : THVB\n",
      "245 : THVGF\n",
      "246 : THVUF\n",
      "247 : THYCF\n",
      "248 : THYCY\n",
      "249 : THYOF\n",
      "250 : TIACF\n",
      "251 : TIANF\n",
      "252 : TIAOF\n",
      "253 : TIDZQ\n",
      "254 : TIEFF\n",
      "255 : TIF\n",
      "256 : TIGCF\n",
      "257 : TIGR\n",
      "258 : TIK\n",
      "259 : TIMCF\n",
      "260 : TIME\n",
      "261 : TIMGF\n",
      "262 : TINKF\n",
      "263 : TIPT\n",
      "264 : TIS\n",
      "265 : TISCF\n",
      "266 : TISI\n",
      "267 : TITCF\n",
      "268 : TITN\n",
      "269 : TIXC\n",
      "270 : TJSCF\n",
      "271 : TJX\n",
      "272 : TK\n",
      "273 : TKAGY\n",
      "274 : TKAYF\n",
      "275 : TKCM\n",
      "276 : TKFHY\n",
      "277 : TKFTF\n",
      "278 : TKGBY\n",
      "279 : TKGSF\n",
      "280 : TKGSY\n",
      "281 : TKGZY\n",
      "282 : TKHGF\n",
      "283 : TKHVF\n",
      "284 : TKHVY\n",
      "285 : TKKIF\n",
      "286 : TKPYY\n",
      "287 : TKR\n",
      "288 : TKRFF\n",
      "289 : TKSKF\n",
      "290 : TKSTF\n",
      "291 : TKTCY\n",
      "292 : TKURF\n",
      "293 : TKWAF\n",
      "294 : TKYMF\n",
      "295 : TKYMY\n",
      "296 : TLCO\n",
      "297 : TLF\n",
      "298 : TLGAF\n",
      "299 : TLGRF\n",
      "300 : TLK\n",
      "301 : TLLYF\n",
      "302 : TLMMF\n",
      "303 : TLMR\n",
      "304 : TLND\n",
      "305 : TLOFF\n",
      "306 : TLOG\n",
      "307 : TLRA\n",
      "308 : TLRD\n",
      "309 : TLRS\n",
      "310 : TLRY\n",
      "311 : TLSNF\n",
      "312 : TLSNY\n",
      "313 : TLSW\n",
      "314 : TLTFF\n",
      "315 : TLTZY\n",
      "316 : TLUXF\n",
      "317 : TLVLF\n",
      "318 : TLWDF\n",
      "319 : TLXPF\n",
      "320 : TMAK\n",
      "321 : TMBBY\n",
      "322 : TMCGF\n",
      "323 : TMCX\n",
      "324 : TMDI\n",
      "325 : TMED\n",
      "326 : TMHC\n",
      "327 : TMIAF\n",
      "328 : TMICF\n",
      "329 : TMICY\n",
      "330 : TMKOL\n",
      "331 : TMMFF\n",
      "332 : TMNSF\n",
      "333 : TMOAF\n",
      "334 : TMOAY\n",
      "335 : TMP\n",
      "336 : TMPHF\n",
      "337 : TMPPF\n",
      "338 : TMRR\n",
      "339 : TMSNY\n",
      "340 : TMSR\n",
      "341 : TMST\n",
      "342 : TMXN\n",
      "343 : TMXXF\n",
      "344 : TNABF\n",
      "345 : TNAV\n",
      "346 : TNBI\n",
      "347 : TNEN\n",
      "348 : TNGRY\n",
      "349 : TNGZF\n",
      "350 : TNISF\n",
      "351 : TNISY\n",
      "352 : TNK\n",
      "353 : TNKHF\n",
      "354 : TNLX\n",
      "355 : TNMCF\n",
      "356 : TNMRY\n",
      "357 : TNNFF\n",
      "358 : TNPH\n",
      "359 : TNREF\n",
      "360 : TNRG\n",
      "361 : TNRK\n",
      "362 : TNSGF\n",
      "363 : TNUG\n",
      "364 : TNXP\n",
      "365 : TNYYF\n",
      "366 : TOAK\n",
      "367 : TODGF\n",
      "368 : TOELY\n",
      "369 : TOEYF\n",
      "370 : TOIPY\n",
      "371 : TOISF\n",
      "372 : TOKCF\n",
      "373 : TOKSF\n",
      "374 : TOKUY\n",
      "375 : TOLWF\n",
      "376 : TONPF\n",
      "377 : TOOTQ\n",
      "378 : TOPS\n",
      "379 : TOPZ\n",
      "380 : TORC\n",
      "381 : TORM\n",
      "382 : TORXF\n",
      "383 : TOSCF\n",
      "384 : TOT\n",
      "385 : TOTA\n",
      "386 : TOTDY\n",
      "387 : TOTTF\n",
      "388 : TOTXF\n",
      "389 : TOUMF\n",
      "390 : TOWTF\n",
      "391 : TOYOF\n",
      "392 : TPB\n",
      "393 : TPBTF\n",
      "394 : TPC\n",
      "395 : TPCA\n",
      "396 : TPCFF\n",
      "397 : TPDKY\n",
      "398 : TPGH\n",
      "399 : TPGVF\n",
      "400 : TPH\n",
      "401 : TPHS\n",
      "402 : TPIC\n",
      "403 : TPLM\n",
      "404 : TPLWF\n",
      "405 : TPPPF\n",
      "406 : TPPRF\n",
      "407 : TPPTY\n",
      "408 : TPR\n",
      "409 : TPRFF\n",
      "410 : TPRP\n",
      "411 : TPTJF\n",
      "412 : TPTW\n",
      "413 : TPVTF\n",
      "414 : TPYSF\n",
      "415 : TRAGF\n",
      "416 : TRAYF\n",
      "417 : TRCH\n",
      "418 : TRCLF\n",
      "419 : TRCY\n",
      "420 : TREAF\n",
      "421 : TREE\n",
      "422 : TREVF\n",
      "423 : TREX\n",
      "424 : TRGAF\n",
      "425 : TRGGF\n",
      "426 : TRGM\n",
      "427 : TRGNF\n",
      "428 : TRGP\n",
      "429 : TRHF\n",
      "430 : TRHIF\n",
      "431 : TRHXF\n",
      "432 : TRI\n",
      "433 : TRIB\n",
      "434 : TRIL\n",
      "435 : TRIP\n",
      "436 : TRK\n",
      "437 : TRKCF\n",
      "438 : TRKK\n",
      "439 : TRKNF\n",
      "440 : TRKTF\n",
      "441 : TRLFF\n",
      "442 : TRLPF\n",
      "443 : TRMB\n",
      "444 : TRMEF\n",
      "445 : TRMLF\n",
      "446 : TRMT\n",
      "447 : TRMYQ\n",
      "448 : TRNLY\n",
      "449 : TRNO\n",
      "450 : TRON\n",
      "451 : TROV\n",
      "452 : TROX\n",
      "453 : TRPRY\n",
      "454 : TRPX\n",
      "455 : TRRFF\n",
      "456 : TRRNF\n",
      "457 : TRRSF\n",
      "458 : TRRVF\n",
      "459 : TRRXF\n",
      "460 : TRSBF\n",
      "461 : TRSDF\n",
      "462 : TRSU\n",
      "463 : TRT\n",
      "464 : TRTI\n",
      "465 : TRTN\n",
      "466 : TRUHF\n",
      "467 : TRUP\n",
      "468 : TRUU\n",
      "469 : TRUX\n",
      "470 : TRVB\n",
      "471 : TRVN\n",
      "472 : TRWKF\n",
      "473 : TRWRF\n",
      "474 : TRX\n",
      "475 : TRXA\n",
      "476 : TRXC\n",
      "477 : TRYF\n",
      "478 : TRYIY\n",
      "479 : TS\n",
      "480 : TSBBY\n",
      "481 : TSBLF\n",
      "482 : TSC\n",
      "483 : TSCAP\n",
      "484 : TSCC\n",
      "485 : TSCDF\n",
      "486 : TSCEF\n",
      "487 : TSCFY\n",
      "488 : TSCHY\n",
      "489 : TSCO\n",
      "490 : TSDOF\n",
      "491 : TSDRF\n",
      "492 : TSE\n",
      "493 : TSEM\n",
      "494 : TSETF\n",
      "495 : TSGL\n",
      "496 : TSGMY\n",
      "497 : TSGTF\n",
      "498 : TSHMY\n",
      "499 : TSHTF\n",
      "500 : TSLA\n",
      "501 : TSLLF\n",
      "502 : TSM\n",
      "503 : TSNLF\n",
      "504 : TSOCF\n",
      "505 : TSOH\n",
      "506 : TSPCF\n",
      "507 : TSPPF\n",
      "508 : TSQ\n",
      "509 : TSRO\n",
      "510 : TSS\n",
      "511 : TSSHF\n",
      "512 : TSSI\n",
      "513 : TSSJF\n",
      "514 : TSSNF\n",
      "515 : TST\n",
      "516 : TSU\n",
      "517 : TSUSF\n",
      "518 : TSYHY\n",
      "519 : TTALF\n",
      "520 : TTAZF\n",
      "521 : TTCNF\n",
      "522 : TTD\n",
      "523 : TTDKF\n",
      "524 : TTEC\n",
      "525 : TTEK\n",
      "526 : TTEN\n",
      "527 : TTEXF\n",
      "528 : TTGT\n",
      "529 : TTLO\n",
      "530 : TTNDF\n",
      "531 : TTNP\n",
      "532 : TTOBF\n",
      "533 : TTPH\n",
      "534 : TTRKF\n",
      "535 : TTSNF\n",
      "536 : TTTM\n",
      "537 : TTTRF\n",
      "538 : TTTXF\n",
      "539 : TTWO\n",
      "540 : TTWPF\n",
      "541 : TTWSF\n",
      "542 : TUBE\n",
      "543 : TUFBY\n",
      "544 : TUGHF\n",
      "545 : TUIFY\n",
      "546 : TUMI\n",
      "547 : TUMIF\n",
      "548 : TUP\n",
      "549 : TUPRF\n",
      "550 : TURA\n",
      "551 : TURN\n",
      "552 : TUSK\n",
      "553 : TUUNF\n",
      "554 : TUWLF\n",
      "555 : TV\n",
      "556 : TVBCF\n",
      "557 : TVBCY\n",
      "558 : TVIPF\n",
      "559 : TVNWY\n",
      "560 : TVPKF\n",
      "561 : TVPT\n",
      "562 : TW\n",
      "563 : TWC\n",
      "564 : TWCF\n",
      "565 : TWER\n",
      "566 : TWFH\n",
      "567 : TWI\n",
      "568 : TWIN\n",
      "569 : TWIRF\n",
      "570 : TWOC\n",
      "571 : TWODY\n",
      "572 : TWOU\n",
      "573 : TWRFF\n",
      "574 : TWSCF\n",
      "575 : TWTR\n",
      "576 : TWX\n",
      "577 : TXHD\n",
      "578 : TXHG\n",
      "579 : TXLZF\n",
      "580 : TXMD\n",
      "581 : TXN\n",
      "582 : TXSP\n",
      "583 : TXT\n",
      "584 : TXTR\n",
      "585 : TXWHF\n",
      "586 : TYBT\n",
      "587 : TYCB\n",
      "588 : TYHOF\n",
      "589 : TYIDY\n",
      "590 : TYL\n",
      "591 : TYME\n",
      "592 : TYPE\n",
      "593 : TYRA\n",
      "594 : TYUCF\n",
      "595 : TZLTF\n",
      "596 : TZNMF\n",
      "597 : TZNOF\n",
      "598 : TZOO\n",
      "599 : True\n",
      "600 : UACJF\n",
      "601 : UAHC\n",
      "602 : UAMA\n",
      "603 : UAMY\n",
      "604 : UAN\n",
      "605 : UBA\n",
      "606 : UBAB\n",
      "607 : UBEOF\n",
      "608 : UBEOY\n",
      "609 : UBFO\n",
      "610 : UBINF\n",
      "611 : UBKZF\n",
      "612 : UBMOF\n",
      "613 : UBMRF\n",
      "614 : UBNC\n",
      "615 : UBNSF\n",
      "616 : UBOH\n",
      "617 : UBS\n",
      "618 : UBSBF\n",
      "619 : UBSFY\n",
      "620 : UCAP\n",
      "621 : UCBI\n",
      "622 : UCBJF\n",
      "623 : UCBJY\n",
      "624 : UCCC\n",
      "625 : UCFC\n",
      "626 : UCMDF\n",
      "627 : UCP\n",
      "628 : UCPA\n",
      "629 : UCPH\n",
      "630 : UCTT\n",
      "631 : UDFI\n",
      "632 : UDHCF\n",
      "633 : UDIRF\n",
      "634 : UE\n",
      "635 : UEDVF\n",
      "636 : UEEC\n",
      "637 : UEIC\n",
      "638 : UFGSY\n",
      "639 : UFI\n",
      "640 : UFODF\n",
      "641 : UFPT\n",
      "642 : UG\n",
      "643 : UGDIF\n",
      "644 : UGEIF\n",
      "645 : UHAL\n",
      "646 : UHID\n",
      "647 : UHS\n",
      "648 : UIHC\n",
      "649 : UIS\n",
      "650 : UKLLF\n",
      "651 : UL\n",
      "652 : ULIHF\n",
      "653 : ULNV\n",
      "654 : ULPPF\n",
      "655 : ULTA\n",
      "656 : ULTI\n",
      "657 : ULTRF\n",
      "658 : ULTXF\n",
      "659 : ULUCF\n",
      "660 : UMBF\n",
      "661 : UMC\n",
      "662 : UMGP\n",
      "663 : UMH\n",
      "664 : UMHL\n",
      "665 : UMICY\n",
      "666 : UMRX\n",
      "667 : UMTAF\n",
      "668 : UNAM\n",
      "669 : UNB\n",
      "670 : UNBLF\n",
      "671 : UNCFF\n",
      "672 : UNCHF\n",
      "673 : UNCRY\n",
      "674 : UNDT\n",
      "675 : UNEGF\n",
      "676 : UNEQ\n",
      "677 : UNF\n",
      "678 : UNH\n",
      "679 : UNICY\n",
      "680 : UNIGF\n",
      "681 : UNISQ\n",
      "682 : UNISZ\n",
      "683 : UNIT\n",
      "684 : UNLRY\n",
      "685 : UNLVF\n",
      "686 : UNLYF\n",
      "687 : UNM\n",
      "688 : UNPLF\n",
      "689 : UNPRF\n",
      "690 : UNPSF\n",
      "691 : UNRDY\n",
      "692 : UNSI\n",
      "693 : UNSS\n",
      "694 : UNTD\n",
      "695 : UNTDV\n",
      "696 : UNTN\n",
      "697 : UNTOF\n",
      "698 : UOLGF\n",
      "699 : UOLGY\n",
      "700 : UOMO\n",
      "701 : UOVEF\n",
      "702 : UPBMF\n",
      "703 : UPCHY\n",
      "704 : UPDC\n",
      "705 : UPL\n",
      "706 : UPMKY\n",
      "707 : UPNRF\n",
      "708 : UPNRY\n",
      "709 : UPPR\n",
      "710 : URAGF\n",
      "711 : URAYY\n",
      "712 : URBT\n",
      "713 : URG\n",
      "714 : URGYF\n",
      "715 : URHG\n",
      "716 : URHY\n",
      "717 : URI\n",
      "718 : URNXF\n",
      "719 : URSL\n",
      "720 : URYL\n",
      "721 : URZZF\n",
      "722 : USAK\n",
      "723 : USAQ\n",
      "724 : USAS\n",
      "725 : USAT\n",
      "726 : USAU\n",
      "727 : USBL\n",
      "728 : USCFF\n",
      "729 : USCS\n",
      "730 : USDF\n",
      "731 : USDMY\n",
      "732 : USDP\n",
      "733 : USDR\n",
      "734 : USEL\n",
      "735 : USFD\n",
      "736 : USGDF\n",
      "737 : USLM\n",
      "738 : USMD\n",
      "739 : USMN\n",
      "740 : USMT\n",
      "741 : USNU\n",
      "742 : USNZY\n",
      "743 : USPI\n",
      "744 : USRM\n",
      "745 : USSJF\n",
      "746 : USSJY\n",
      "747 : USTC\n",
      "748 : USX\n",
      "749 : USYNF\n",
      "750 : UTEK\n",
      "751 : UTGPF\n",
      "752 : UTIW\n",
      "753 : UTOLF\n",
      "754 : UTRK\n",
      "755 : UTSI\n",
      "756 : UUUU\n",
      "757 : UVBIF\n",
      "758 : UVPOF\n",
      "759 : UVRBF\n",
      "760 : UVRBY\n",
      "761 : UVSP\n",
      "762 : UWHR\n",
      "763 : UXCLF\n",
      "764 : UXIN\n",
      "765 : V\n",
      "766 : VACNY\n",
      "767 : VALE\n",
      "768 : VALU\n",
      "769 : VALV\n",
      "770 : VANTF\n",
      "771 : VARHF\n",
      "772 : VASC\n",
      "773 : VASO\n",
      "774 : VAUCF\n",
      "775 : VBFC\n",
      "776 : VBHLF\n",
      "777 : VBIO\n",
      "778 : VBIV\n",
      "779 : VBLT\n",
      "780 : VBTX\n",
      "781 : VC\n",
      "782 : VCANF\n",
      "783 : VCBP\n",
      "784 : VCEL\n",
      "785 : VCHYF\n",
      "786 : VCIGF\n",
      "787 : VCISF\n",
      "788 : VCISY\n",
      "789 : VCMMF\n",
      "790 : VCNYY\n",
      "791 : VCOR\n",
      "792 : VCOYY\n",
      "793 : VDAHF\n",
      "794 : VDMCY\n",
      "795 : VDMRF\n",
      "796 : VDNRF\n",
      "797 : VDQSF\n",
      "798 : VDTAF\n",
      "799 : VDTH\n",
      "800 : VEAC\n",
      "801 : VECT\n",
      "802 : VEGYF\n",
      "803 : VEND\n",
      "804 : VEOEF\n",
      "805 : VERF\n",
      "806 : VERI\n",
      "807 : VESTF\n",
      "808 : VET\n",
      "809 : VETTF\n",
      "810 : VFC\n",
      "811 : VFFIF\n",
      "812 : VG\n",
      "813 : VGCEF\n",
      "814 : VGLDF\n",
      "815 : VGRBF\n",
      "816 : VGZ\n",
      "817 : VHC\n",
      "818 : VHI\n",
      "819 : VIA\n",
      "820 : VIAAY\n",
      "821 : VIAV\n",
      "822 : VIBVY\n",
      "823 : VICA\n",
      "824 : VICR\n",
      "825 : VIDE\n",
      "826 : VINO\n",
      "827 : VIPRF\n",
      "828 : VIPS\n",
      "829 : VIRC\n",
      "830 : VIRT\n",
      "831 : VISM\n",
      "832 : VITFF\n",
      "833 : VITIF\n",
      "834 : VIV\n",
      "835 : VIVE\n",
      "836 : VIVHY\n",
      "837 : VIVK\n",
      "838 : VIVO\n",
      "839 : VJET\n",
      "840 : VKEMF\n",
      "841 : VKPPF\n",
      "842 : VLDI\n",
      "843 : VLGEA\n",
      "844 : VLKAF\n",
      "845 : VLKPF\n",
      "846 : VLNVF\n",
      "847 : VLO\n",
      "848 : VLPNF\n",
      "849 : VLPNY\n",
      "850 : VLRDF\n",
      "851 : VLTHF\n",
      "852 : VLVLY\n",
      "853 : VLY\n",
      "854 : VMC\n",
      "855 : VMEMQ\n",
      "856 : VMPT\n",
      "857 : VMTG\n",
      "858 : VNAPF\n",
      "859 : VNARF\n",
      "860 : VNCI\n",
      "861 : VNCKF\n",
      "862 : VNDA\n",
      "863 : VNDSL\n",
      "864 : VNET\n",
      "865 : VNLPF\n",
      "866 : VNLPY\n",
      "867 : VNNVF\n",
      "868 : VNO\n",
      "869 : VNOM\n",
      "870 : VNRCF\n",
      "871 : VNRFY\n",
      "872 : VNRGF\n",
      "873 : VNRSQ\n",
      "874 : VOD\n",
      "875 : VODAF\n",
      "876 : VODG\n",
      "877 : VODOF\n",
      "878 : VODPF\n",
      "879 : VOHO\n",
      "880 : VOIL\n",
      "881 : VOLAF\n",
      "882 : VOLVF\n",
      "883 : VOLVY\n",
      "884 : VOMT\n",
      "885 : VONOY\n",
      "886 : VOPKF\n",
      "887 : VOPKY\n",
      "888 : VOQP\n",
      "889 : VOSSF\n",
      "890 : VOXX\n",
      "891 : VOYJF\n",
      "892 : VPGLF\n",
      "893 : VPOSF\n",
      "894 : VPPNY\n",
      "895 : VPTV\n",
      "896 : VPYYF\n",
      "897 : VQSLF\n",
      "898 : VRA\n",
      "899 : VRCFF\n",
      "900 : VRCP\n",
      "901 : VRCV\n",
      "902 : VREX\n",
      "903 : VREYF\n",
      "904 : VRHD\n",
      "905 : VRME\n",
      "906 : VRML\n",
      "907 : VRNDF\n",
      "908 : VRNT\n",
      "909 : VRPMF\n",
      "910 : VRRKF\n",
      "911 : VRSO\n",
      "912 : VRSSF\n",
      "913 : VRTA\n",
      "914 : VRTHF\n",
      "915 : VRTS\n",
      "916 : VRTT\n",
      "917 : VRTV\n",
      "918 : VRTY\n",
      "919 : VRXWF\n",
      "920 : VSAR\n",
      "921 : VSBN\n",
      "922 : VSCP\n",
      "923 : VSEC\n",
      "924 : VSMR\n",
      "925 : VSNDF\n",
      "926 : VSRI\n",
      "927 : VSRV\n",
      "928 : VSSPY\n",
      "929 : VSSSF\n",
      "930 : VST\n",
      "931 : VSTHY\n",
      "932 : VSTM\n",
      "933 : VSTO\n",
      "934 : VTCCF\n",
      "935 : VTDI\n",
      "936 : VTEPF\n",
      "937 : VTEQ\n",
      "938 : VTGFF\n",
      "939 : VTGN\n",
      "940 : VTIQ\n",
      "941 : VTIQW\n",
      "942 : VTKLY\n",
      "943 : VTL\n",
      "944 : VTLR\n",
      "945 : VTMTF\n",
      "946 : VTNA\n",
      "947 : VTR\n",
      "948 : VTRLY\n",
      "949 : VTSI\n",
      "950 : VTTCF\n",
      "951 : VTVT\n",
      "952 : VULC\n",
      "953 : VUPPF\n",
      "954 : VVC\n",
      "955 : VVCIF\n",
      "956 : VVDB\n",
      "957 : VVDL\n",
      "958 : VVI\n",
      "959 : VVIVF\n",
      "960 : VVPR\n",
      "961 : VVUS\n",
      "962 : VVV\n",
      "963 : VWAPY\n",
      "964 : VWIN\n",
      "965 : VWLTF\n",
      "966 : VWR\n",
      "967 : VWSYF\n",
      "968 : VXMFF\n",
      "969 : VXSYF\n",
      "970 : VYEY\n",
      "971 : VYYRF\n",
      "972 : VZ\n",
      "973 : VZHGF\n",
      "974 : WAAS\n",
      "975 : WAB\n",
      "976 : WACMF\n",
      "977 : WACMY\n",
      "978 : WAFD\n",
      "979 : WAIR\n",
      "980 : WAKE\n",
      "981 : WALKQ\n",
      "982 : WANHF\n",
      "983 : WANSF\n",
      "984 : WARFF\n",
      "985 : WAT\n",
      "986 : WATKF\n",
      "987 : WAVXQ\n",
      "988 : WAWL\n",
      "989 : WAYN\n",
      "990 : WB\n",
      "991 : WBAI\n",
      "992 : WBBW\n",
      "993 : WBC\n",
      "994 : WBEMF\n",
      "995 : WBHC\n",
      "996 : WBKC\n",
      "997 : WBRBF\n",
      "998 : WBRBY\n",
      "999 : WBS\n",
      "1000 : WBSI\n",
      "1001 : WCAGY\n",
      "1002 : WCC\n",
      "1003 : WCCP\n",
      "1004 : WCRE\n",
      "1005 : WCRS\n",
      "1006 : WCTXD\n",
      "1007 : WCVC\n",
      "1008 : WCYN\n",
      "1009 : WD\n",
      "1010 : WDC\n",
      "1011 : WDCRF\n",
      "1012 : WDDD\n",
      "1013 : WDDYF\n",
      "1014 : WDFC\n",
      "1015 : WDFPF\n",
      "1016 : WDGJF\n",
      "1017 : WDPSF\n",
      "1018 : WDR\n",
      "1019 : WDRP\n",
      "1020 : WEB\n",
      "1021 : WEBJF\n",
      "1022 : WEC\n",
      "1023 : WECFY\n",
      "1024 : WECT\n",
      "1025 : WEDG\n",
      "1026 : WEDXF\n",
      "1027 : WEFIF\n",
      "1028 : WEGOF\n",
      "1029 : WEGZY\n",
      "1030 : WEICY\n",
      "1031 : WEQL\n",
      "1032 : WERN\n",
      "1033 : WEWA\n",
      "1034 : WEX\n",
      "1035 : WFAFF\n",
      "1036 : WFBI\n",
      "1037 : WFCF\n",
      "1038 : WFM\n",
      "1039 : WFMRF\n",
      "1040 : WFRSF\n",
      "1041 : WFTSF\n",
      "1042 : WGBS\n",
      "1043 : WGL\n",
      "1044 : WGO\n",
      "1045 : WGP\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1046 : WGRP\n",
      "1047 : WHGLY\n",
      "1048 : WHGRF\n",
      "1049 : WHLKF\n",
      "1050 : WHLR\n",
      "1051 : WHLX\n",
      "1052 : WHWRF\n",
      "1053 : WHXT\n",
      "1054 : WHZT\n",
      "1055 : WILC\n",
      "1056 : WILD\n",
      "1057 : WILLF\n",
      "1058 : WILYY\n",
      "1059 : WIMHF\n",
      "1060 : WINA\n",
      "1061 : WIPKF\n",
      "1062 : WIRE\n",
      "1063 : WISA\n",
      "1064 : WISH\n",
      "1065 : WISRF\n",
      "1066 : WIT\n",
      "1067 : WIX\n",
      "1068 : WJAVF\n",
      "1069 : WJRYF\n",
      "1070 : WJRYY\n",
      "1071 : WKCMF\n",
      "1072 : WKHS\n",
      "1073 : WKLDF\n",
      "1074 : WKLN\n",
      "1075 : WLDFF\n",
      "1076 : WLDVF\n",
      "1077 : WLFC\n",
      "1078 : WLFDF\n",
      "1079 : WLFFF\n",
      "1080 : WLHSF\n",
      "1081 : WLK\n",
      "1082 : WLMIF\n",
      "1083 : WLMIY\n",
      "1084 : WLMS\n",
      "1085 : WLSE\n",
      "1086 : WLTNF\n",
      "1087 : WLTW\n",
      "1088 : WLWHY\n",
      "1089 : WLYYF\n",
      "1090 : WMAR\n",
      "1091 : WMC\n",
      "1092 : WMDS\n",
      "1093 : WMEG\n",
      "1094 : WMGI\n",
      "1095 : WMGR\n",
      "1096 : WMGTF\n",
      "1097 : WMLLF\n",
      "1098 : WMMVF\n",
      "1099 : WMMVY\n",
      "1100 : WMNNF\n",
      "1101 : WMPN\n",
      "1102 : WMT\n",
      "1103 : WNDLF\n",
      "1104 : WNHTF\n",
      "1105 : WNRL\n",
      "1106 : WNRP\n",
      "1107 : WNS\n",
      "1108 : WNXDF\n",
      "1109 : WOLWF\n",
      "1110 : WONCF\n",
      "1111 : WONEF\n",
      "1112 : WOPEF\n",
      "1113 : WOSSF\n",
      "1114 : WOWMF\n",
      "1115 : WP\n",
      "1116 : WPCZF\n",
      "1117 : WPFH\n",
      "1118 : WPG\n",
      "1119 : WPM\n",
      "1120 : WPP\n",
      "1121 : WPPGF\n",
      "1122 : WPRXF\n",
      "1123 : WPTIF\n",
      "1124 : WPYGY\n",
      "1125 : WRCDF\n",
      "1126 : WRD\n",
      "1127 : WRDEF\n",
      "1128 : WRE\n",
      "1129 : WRESQ\n",
      "1130 : WRGP\n",
      "1131 : WRN\n",
      "1132 : WRRNF\n",
      "1133 : WRTBY\n",
      "1134 : WRTC\n",
      "1135 : WSBC\n",
      "1136 : WSBF\n",
      "1137 : WSBHF\n",
      "1138 : WSCO\n",
      "1139 : WSCRF\n",
      "1140 : WSEYF\n",
      "1141 : WSHE\n",
      "1142 : WSM\n",
      "1143 : WSMTF\n",
      "1144 : WSPS\n",
      "1145 : WSRA\n",
      "1146 : WSRRF\n",
      "1147 : WSSXF\n",
      "1148 : WSTL\n",
      "1149 : WSTM\n",
      "1150 : WSTRF\n",
      "1151 : WTBDY\n",
      "1152 : WTCG\n",
      "1153 : WTCRF\n",
      "1154 : WTCZF\n",
      "1155 : WTFC\n",
      "1156 : WTHVF\n",
      "1157 : WTKN\n",
      "1158 : WTKWY\n",
      "1159 : WTLC\n",
      "1160 : WTM\n",
      "1161 : WTNW\n",
      "1162 : WTR\n",
      "1163 : WTS\n",
      "1164 : WTSHF\n",
      "1165 : WTT\n",
      "1166 : WTTR\n",
      "1167 : WTXR\n",
      "1168 : WU\n",
      "1169 : WUBA\n",
      "1170 : WUHN\n",
      "1171 : WUMSF\n",
      "1172 : WUMSY\n",
      "1173 : WVE\n",
      "1174 : WVVI\n",
      "1175 : WWAV\n",
      "1176 : WWE\n",
      "1177 : WWNTF\n",
      "1178 : WWNTY\n",
      "1179 : WWR\n",
      "1180 : WWW\n",
      "1181 : WY\n",
      "1182 : WYNMF\n",
      "1183 : WYNMY\n",
      "1184 : WYNN\n",
      "1185 : WYY\n",
      "1186 : WZENY\n",
      "1187 : WZZZY\n",
      "1188 : X\n",
      "1189 : XAARF\n",
      "1190 : XANAF\n",
      "1191 : XAUMF\n",
      "1192 : XBIO\n",
      "1193 : XBIT\n",
      "1194 : XBKS\n",
      "1195 : XCOMQ\n",
      "1196 : XCOOQ\n",
      "1197 : XCRA\n",
      "1198 : XCUR\n",
      "1199 : XDRC\n",
      "1200 : XEBEF\n",
      "1201 : XEL\n",
      "1202 : XELA\n",
      "1203 : XENE\n",
      "1204 : XENT\n",
      "1205 : XERS\n",
      "1206 : XFTB\n",
      "1207 : XHFNF\n",
      "1208 : XHR\n",
      "1209 : XIN\n",
      "1210 : XL\n",
      "1211 : XLEFF\n",
      "1212 : XLMDF\n",
      "1213 : XNCR\n",
      "1214 : XNGSF\n",
      "1215 : XNGSY\n",
      "1216 : XNJJY\n",
      "1217 : XNPT\n",
      "1218 : XOM\n",
      "1219 : XOMA\n",
      "1220 : XON\n",
      "1221 : XOOM\n",
      "1222 : XOXO\n",
      "1223 : XPL\n",
      "1224 : XPLR\n",
      "1225 : XPO\n",
      "1226 : XPPLF\n",
      "1227 : XPWR\n",
      "1228 : XRA\n",
      "1229 : XRAY\n",
      "1230 : XRDC\n",
      "1231 : XRELF\n",
      "1232 : XRESF\n",
      "1233 : XRF\n",
      "1234 : XSPA\n",
      "1235 : XSPY\n",
      "1236 : XTEPY\n",
      "1237 : XTGRF\n",
      "1238 : XTHCF\n",
      "1239 : XTLB\n",
      "1240 : XTLS\n",
      "1241 : XTNY\n",
      "1242 : XTRRF\n",
      "1243 : XXJZA\n",
      "1244 : XXLLY\n",
      "1245 : XXMMF\n",
      "1246 : XXNCB\n",
      "1247 : XXNCC\n",
      "1248 : XYF\n",
      "1249 : XYLTF\n",
      "1250 : XZJCF\n",
      "1251 : Y\n",
      "1252 : YACAF\n",
      "1253 : YAGOY\n",
      "1254 : YAMCF\n",
      "1255 : YAMCY\n",
      "1256 : YAMHF\n",
      "1257 : YASKF\n",
      "1258 : YASKY\n",
      "1259 : YATRY\n",
      "1260 : YBAO\n",
      "1261 : YDLE\n",
      "1262 : YDVL\n",
      "1263 : YDWAF\n",
      "1264 : YECO\n",
      "1265 : YELP\n",
      "1266 : YEWB\n",
      "1267 : YFGSF\n",
      "1268 : YGEHY\n",
      "1269 : YGYI\n",
      "1270 : YHMGF\n",
      "1271 : YI\n",
      "1272 : YIN\n",
      "1273 : YINGY\n",
      "1274 : YITYF\n",
      "1275 : YKLTF\n",
      "1276 : YKYOF\n",
      "1277 : YLDGF\n",
      "1278 : YLLWF\n",
      "1279 : YLWDF\n",
      "1280 : YMAB\n",
      "1281 : YMAIF\n",
      "1282 : YMMTY\n",
      "1283 : YMTKF\n",
      "1284 : YNSGF\n",
      "1285 : YNSKF\n",
      "1286 : YONGY\n",
      "1287 : YOOIF\n",
      "1288 : YOSN\n",
      "1289 : YPFSF\n",
      "1290 : YRLLF\n",
      "1291 : YSHLF\n",
      "1292 : YSYB\n",
      "1293 : YTEN\n",
      "1294 : YTFD\n",
      "1295 : YTRGF\n",
      "1296 : YUANF\n",
      "1297 : YUEIF\n",
      "1298 : YUEXF\n",
      "1299 : YUGVF\n",
      "1300 : YUM\n",
      "1301 : YUMM\n",
      "1302 : YUMSF\n",
      "1303 : YUSG\n",
      "1304 : YY\n",
      "1305 : YYEQF\n",
      "1306 : YYEQG\n",
      "1307 : YYSSM\n",
      "1308 : YZCHF\n",
      "1309 : ZAIS\n",
      "1310 : ZARFF\n",
      "1311 : ZBH\n",
      "1312 : ZDGE\n",
      "1313 : ZDPY\n",
      "1314 : ZEAL\n",
      "1315 : ZENO\n",
      "1316 : ZENYF\n",
      "1317 : ZEUS\n",
      "1318 : ZFGN\n",
      "1319 : ZFSVF\n",
      "1320 : ZG\n",
      "1321 : ZGBEF\n",
      "1322 : ZGSI\n",
      "1323 : ZHAOY\n",
      "1324 : ZHEXF\n",
      "1325 : ZHULF\n",
      "1326 : ZHUZY\n",
      "1327 : ZIGGF\n",
      "1328 : ZIGNY\n",
      "1329 : ZIJMF\n",
      "1330 : ZINCQ\n",
      "1331 : ZION\n",
      "1332 : ZIXI\n",
      "1333 : ZKCCD\n",
      "1334 : ZLDAF\n",
      "1335 : ZLDPF\n",
      "1336 : ZLDSF\n",
      "1337 : ZLIOF\n",
      "1338 : ZLIOY\n",
      "1339 : ZLPSF\n",
      "1340 : ZMMDF\n",
      "1341 : ZMTP\n",
      "1342 : ZMWYF\n",
      "1343 : ZNCM\n",
      "1344 : ZNDX\n",
      "1345 : ZNKKY\n",
      "1346 : ZNRNF\n",
      "1347 : ZNZNF\n",
      "1348 : ZODFF\n",
      "1349 : ZODFY\n",
      "1350 : ZOES\n",
      "1351 : ZOM\n",
      "1352 : ZONMY\n",
      "1353 : ZONNF\n",
      "1354 : ZPAS\n",
      "1355 : ZPHYF\n",
      "1356 : ZPIN\n",
      "1357 : ZPTAF\n",
      "1358 : ZRMG\n",
      "1359 : ZRRRF\n",
      "1360 : ZRSEF\n",
      "1361 : ZRVT\n",
      "1362 : ZSHGY\n",
      "1363 : ZSTN\n",
      "1364 : ZTCOY\n",
      "1365 : ZTO\n",
      "1366 : ZTSTF\n",
      "1367 : ZUGFF\n",
      "1368 : ZUMZ\n",
      "1369 : ZXAIY\n",
      "1370 : ZYNE\n",
      "1371 : ZYXI\n",
      "1372 : ZZZOF\n"
     ]
    }
   ],
   "source": [
    "lista_companias = lista_companias[8127:]\n",
    "for i,c in enumerate(lista_companias):\n",
    "    print(i, ':', c)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1950-01-03</th>\n",
       "      <td>16.66</td>\n",
       "      <td>16.66</td>\n",
       "      <td>16.66</td>\n",
       "      <td>16.66</td>\n",
       "      <td>16.66</td>\n",
       "      <td>1260000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1950-01-04</th>\n",
       "      <td>16.85</td>\n",
       "      <td>16.85</td>\n",
       "      <td>16.85</td>\n",
       "      <td>16.85</td>\n",
       "      <td>16.85</td>\n",
       "      <td>1890000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1950-01-05</th>\n",
       "      <td>16.93</td>\n",
       "      <td>16.93</td>\n",
       "      <td>16.93</td>\n",
       "      <td>16.93</td>\n",
       "      <td>16.93</td>\n",
       "      <td>2550000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1950-01-06</th>\n",
       "      <td>16.98</td>\n",
       "      <td>16.98</td>\n",
       "      <td>16.98</td>\n",
       "      <td>16.98</td>\n",
       "      <td>16.98</td>\n",
       "      <td>2010000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1950-01-09</th>\n",
       "      <td>17.08</td>\n",
       "      <td>17.08</td>\n",
       "      <td>17.08</td>\n",
       "      <td>17.08</td>\n",
       "      <td>17.08</td>\n",
       "      <td>2520000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Open   High    Low  Close  Adj Close   Volume\n",
       "Date                                                      \n",
       "1950-01-03  16.66  16.66  16.66  16.66      16.66  1260000\n",
       "1950-01-04  16.85  16.85  16.85  16.85      16.85  1890000\n",
       "1950-01-05  16.93  16.93  16.93  16.93      16.93  2550000\n",
       "1950-01-06  16.98  16.98  16.98  16.98      16.98  2010000\n",
       "1950-01-09  17.08  17.08  17.08  17.08      17.08  2520000"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "index = pd.read_csv('Datos/index_SP500.csv', sep=',', header=0, index_col=0, parse_dates=True)\n",
    "index.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "index.loc[('1950-03-30'),]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>DATE</th>\n",
       "      <th>PRICE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CODE</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>STKKF</th>\n",
       "      <td>06-24-2014</td>\n",
       "      <td>0.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>STKKF</th>\n",
       "      <td>06-25-2014</td>\n",
       "      <td>0.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>STKKF</th>\n",
       "      <td>06-26-2014</td>\n",
       "      <td>0.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>STKKF</th>\n",
       "      <td>06-27-2014</td>\n",
       "      <td>0.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>STKKF</th>\n",
       "      <td>06-30-2014</td>\n",
       "      <td>0.15</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             DATE  PRICE\n",
       "CODE                    \n",
       "STKKF  06-24-2014   0.15\n",
       "STKKF  06-25-2014   0.15\n",
       "STKKF  06-26-2014   0.15\n",
       "STKKF  06-27-2014   0.15\n",
       "STKKF  06-30-2014   0.15"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "prices = pd.read_csv('Datos/prices_guru.csv', sep=',', header=0, index_col=1, parse_dates=True)\n",
    "prices = prices.drop(['Unnamed: 0'], axis=1)\n",
    "prices.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "def calcular_returns(date, df, es_stock):\n",
    "    f = dateutil.parser.parse(date)            \n",
    "    Qini = 0\n",
    "    maxIntentos = 1            \n",
    "    returns = 0\n",
    "    while Qini==0 and maxIntentos < 30:\n",
    "        if (es_stock):\n",
    "            fini = (str(f.month - 2)).zfill(2) + '-' + (str(maxIntentos)).zfill(2) + '-' + str(f.year)\n",
    "        else:\n",
    "            fini = str(f.year) + '-' + (str(f.month - 2)).zfill(2) + '-' + (str(maxIntentos)).zfill(2)\n",
    "        try:\n",
    "            if (es_stock):\n",
    "                dd = df[df['DATE'] == fini]\n",
    "                Qini = dd['PRICE'].values[0]\n",
    "            else:\n",
    "                Qini = df.loc[fini]['Open']        \n",
    "        except:\n",
    "            pass\n",
    "        maxIntentos = maxIntentos + 1\n",
    "    Qfin = 0\n",
    "    maxIntentos = 31 if f.month == 3 or f.month==12 else 30\n",
    "    while Qfin == 0 and maxIntentos > 1:\n",
    "        if (es_stock):\n",
    "            ffin = (str(f.month)).zfill(2) + '-' + str(maxIntentos).zfill(2) + '-' + str(f.year)\n",
    "        else:\n",
    "            ffin = str(f.year) + '-' + (str(f.month)).zfill(2) + '-' + str(maxIntentos).zfill(2)\n",
    "        try:\n",
    "            if (es_stock):\n",
    "                dd = df[df['DATE'] == ffin]        \n",
    "                Qfin = dd['PRICE'].values[0]\n",
    "            else:\n",
    "                Qfin = df.loc[ffin]['Close']        \n",
    "        except:\n",
    "            pass\n",
    "        maxIntentos = maxIntentos - 1      \n",
    "    try :\n",
    "        if Qini == 0:\n",
    "            returns = 0 #Ha habido una excepcion porque no encontraba el precio para ese día\n",
    "        else:\n",
    "            returns = (Qfin - Qini) / Qini\n",
    "    except:\n",
    "        returns = 0\n",
    "    if returns == -np.inf:\n",
    "        returns = 0\n",
    "    return returns, Qini, Qfin"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Ticker SVMK calculado\n",
      "Ticker SVNDF calculado\n",
      "Ticker SVNDY calculado\n",
      "Ticker SVNLF calculado\n",
      "Ticker SVNT calculado\n",
      "Ticker SVRGF calculado\n",
      "Ticker SVT calculado\n",
      "Ticker SVU calculado\n",
      "Ticker SVVTF calculado\n",
      "Ticker SVVZF calculado\n",
      "Ticker SWDAF calculado\n",
      "Ticker SWDBY calculado\n",
      "Ticker SWDHF calculado\n",
      "Ticker SWEE calculado\n",
      "Ticker SWGAF calculado\n",
      "Ticker SWHN calculado\n",
      "Ticker SWIR calculado\n",
      "Ticker SWKS calculado\n",
      "Ticker SWM calculado\n",
      "Ticker SWMAY calculado\n",
      "Ticker SWN calculado\n",
      "Ticker SWNLF calculado\n",
      "Ticker SWPFF calculado\n",
      "Ticker SWPIF calculado\n",
      "Ticker SWPRF calculado\n",
      "Ticker SWRAF calculado\n",
      "Ticker SWRBF calculado\n",
      "Ticker SWRBY calculado\n",
      "Ticker SWROY calculado\n",
      "Ticker SWSH calculado\n",
      "Ticker SWSKF calculado\n",
      "Ticker SWSSF calculado\n",
      "Ticker SWYBF calculado\n",
      "Ticker SWYBY calculado\n",
      "Ticker SWZCF calculado\n",
      "Ticker SWZNF calculado\n",
      "Ticker SXC calculado\n",
      "Ticker SXGAF calculado\n",
      "Ticker SXMDF calculado\n",
      "Ticker SXNTF calculado\n",
      "Ticker SXOOF calculado\n",
      "Ticker SXYEY calculado\n",
      "Ticker SYA calculado\n",
      "Ticker SYAAF calculado\n",
      "Ticker SYANF calculado\n",
      "Ticker SYANY calculado\n",
      "Ticker SYATF calculado\n",
      "Ticker SYBF calculado\n",
      "Ticker SYBJF calculado\n",
      "Ticker SYBT calculado\n",
      "Ticker SYENF calculado\n",
      "Ticker SYEV calculado\n",
      "Ticker SYF calculado\n",
      "Ticker SYFHF calculado\n",
      "Ticker SYHEF calculado\n",
      "Ticker SYIEF calculado\n",
      "Ticker SYIEY calculado\n",
      "Ticker SYKWF calculado\n",
      "Ticker SYMC calculado\n",
      "Ticker SYN calculado\n",
      "Ticker SYNC calculado\n",
      "Ticker SYNL calculado\n",
      "Ticker SYNYY calculado\n",
      "Ticker SYT calculado\n",
      "Ticker SYUT calculado\n",
      "Ticker SYYC calculado\n",
      "Ticker SYZLF calculado\n",
      "Ticker SZBHF calculado\n",
      "Ticker SZBI calculado\n",
      "Ticker SZCRF calculado\n",
      "Ticker SZEVY calculado\n",
      "Ticker SZGPF calculado\n",
      "Ticker SZHFF calculado\n",
      "Ticker SZKBF calculado\n",
      "Ticker SZKMY calculado\n",
      "Ticker SZLMY calculado\n",
      "Ticker SZMK calculado\n",
      "Ticker SZNTF calculado\n",
      "Ticker SZNTY calculado\n",
      "Ticker T calculado\n",
      "Ticker TABCF calculado\n",
      "Ticker TAC calculado\n",
      "Ticker TACI calculado\n",
      "Ticker TACJF calculado\n",
      "Ticker TACYY calculado\n",
      "Ticker TAER calculado\n",
      "Ticker TAFFF calculado\n",
      "Ticker TAGOF calculado\n",
      "Ticker TAHO calculado\n",
      "Ticker TAICY calculado\n",
      "Ticker TAIPY calculado\n",
      "Ticker TAISF calculado\n",
      "Ticker TAIT calculado\n",
      "Ticker TAKD calculado\n",
      "Ticker TALO calculado\n",
      "Ticker TAMG calculado\n",
      "Ticker TANEF calculado\n",
      "Ticker TAOEF calculado\n",
      "Ticker TAOIF calculado\n",
      "Ticker TAP calculado\n",
      "Ticker TAP.A calculado\n",
      "Ticker TAPCF calculado\n",
      "Ticker TAPOF calculado\n",
      "Ticker TAQR calculado\n",
      "Ticker TASEF calculado\n",
      "Ticker TAST calculado\n",
      "Ticker TATT calculado\n",
      "Ticker TATYF calculado\n",
      "Ticker TATYY calculado\n",
      "Ticker TAUG calculado\n",
      "Ticker TAVHY calculado\n",
      "Ticker TAWNF calculado\n",
      "Ticker TAXA calculado\n",
      "Ticker TBBK calculado\n",
      "Ticker TBCCF calculado\n",
      "Ticker TBGPF calculado\n",
      "Ticker TBIO calculado\n",
      "Ticker TBLEF calculado\n",
      "Ticker TBMIF calculado\n",
      "Ticker TBNC calculado\n",
      "Ticker TBNK calculado\n",
      "Ticker TBPMF calculado\n",
      "Ticker TBRG calculado\n",
      "Ticker TBRIF calculado\n",
      "Ticker TBTC calculado\n",
      "Ticker TBUFF calculado\n",
      "Ticker TBVPF calculado\n",
      "Ticker TCBI calculado\n",
      "Ticker TCBK calculado\n",
      "Ticker TCCMF calculado\n",
      "Ticker TCCNY calculado\n",
      "Ticker TCEC calculado\n",
      "Ticker TCEHY calculado\n",
      "Ticker TCF calculado\n",
      "Ticker TCFC calculado\n",
      "Ticker TCGN calculado\n",
      "Ticker TCHC calculado\n",
      "Ticker TCIJF calculado\n",
      "Ticker TCKGY calculado\n",
      "Ticker TCKRF calculado\n",
      "Ticker TCLAF calculado\n",
      "Ticker TCLHF calculado\n",
      "Ticker TCLRY calculado\n",
      "Ticker TCNB calculado\n",
      "Ticker TCNT calculado\n",
      "Ticker TCPC calculado\n",
      "Ticker TCPFF calculado\n",
      "Ticker TCPIF calculado\n",
      "Ticker TCPP calculado\n",
      "Ticker TCPTF calculado\n",
      "Ticker TCRD calculado\n",
      "Ticker TCTZF calculado\n",
      "Ticker TCX calculado\n",
      "Ticker TCYMF calculado\n",
      "Ticker TD calculado\n",
      "Ticker TDAC calculado\n",
      "Ticker TDBK calculado\n",
      "Ticker TDBOY calculado\n",
      "Ticker TDBSF calculado\n",
      "Ticker TDCAF calculado\n",
      "Ticker TDG calculado\n",
      "Ticker TDHOY calculado\n",
      "Ticker TDLAF calculado\n",
      "Ticker TDNOF calculado\n",
      "Ticker TDPAY calculado\n",
      "Ticker TDRLF calculado\n",
      "Ticker TDRRF calculado\n",
      "Ticker TDRYF calculado\n",
      "Ticker TDS calculado\n",
      "Ticker TDW calculado\n",
      "Ticker TDY calculado\n",
      "Ticker TDYT calculado\n",
      "Ticker TE calculado\n",
      "Ticker TEAR calculado\n",
      "Ticker TECD calculado\n",
      "Ticker TECH calculado\n",
      "Ticker TECK calculado\n",
      "Ticker TEDU calculado\n",
      "Ticker TEF calculado\n",
      "Ticker TEFOF calculado\n",
      "Ticker TEGY calculado\n",
      "Ticker TEKXF calculado\n",
      "Ticker TELLF calculado\n",
      "Ticker TEN calculado\n",
      "Ticker TENB calculado\n",
      "Ticker TENG calculado\n",
      "Ticker TEO calculado\n",
      "Ticker TEP calculado\n",
      "Ticker TER calculado\n",
      "Ticker TERP calculado\n",
      "Ticker TETHF calculado\n",
      "Ticker TETZF calculado\n",
      "Ticker TEUTF calculado\n",
      "Ticker TEVE calculado\n",
      "Ticker TEVJF calculado\n",
      "Ticker TEZNY calculado\n",
      "Ticker TFCCF calculado\n",
      "Ticker TFIFF calculado\n",
      "Ticker TFLG calculado\n",
      "Ticker TFOXL calculado\n",
      "Ticker TFRFF calculado\n",
      "Ticker TFSCF calculado\n",
      "Ticker TG calculado\n",
      "Ticker TGAFF calculado\n",
      "Ticker TGASF calculado\n",
      "Ticker TGATF calculado\n",
      "Ticker TGCDF calculado\n",
      "Ticker TGISQ calculado\n",
      "Ticker TGLP calculado\n",
      "Ticker TGLTY calculado\n",
      "Ticker TGLVY calculado\n",
      "Ticker TGRAF calculado\n",
      "Ticker TGRF calculado\n",
      "Ticker TGRLF calculado\n",
      "Ticker TGSNF calculado\n",
      "Ticker TGT calculado\n",
      "Ticker TGTMF calculado\n",
      "Ticker TGTNF calculado\n",
      "Ticker TGVSF calculado\n",
      "Ticker TGXSF calculado\n",
      "Ticker THC calculado\n",
      "Ticker THCBF calculado\n",
      "Ticker THDS calculado\n",
      "Ticker THERF calculado\n",
      "Ticker THFF calculado\n",
      "Ticker THIXY calculado\n",
      "Ticker THLM calculado\n",
      "Ticker THM calculado\n",
      "Ticker THMG calculado\n",
      "Ticker THMNF calculado\n",
      "Ticker THMNY calculado\n",
      "Ticker THO calculado\n",
      "Ticker THOR calculado\n",
      "Ticker THRLF calculado\n",
      "Ticker THRO calculado\n",
      "Ticker THRPF calculado\n",
      "Ticker THRSF calculado\n",
      "Ticker THS calculado\n",
      "Ticker THTI calculado\n",
      "Ticker THURF calculado\n",
      "Ticker THVB calculado\n",
      "Ticker THVGF calculado\n",
      "Ticker THVUF calculado\n",
      "Ticker THYCF calculado\n",
      "Ticker THYCY calculado\n",
      "Ticker THYOF calculado\n",
      "Ticker TIACF calculado\n",
      "Ticker TIANF calculado\n",
      "Ticker TIAOF calculado\n",
      "Ticker TIDZQ calculado\n",
      "Ticker TIEFF calculado\n",
      "Ticker TIF calculado\n",
      "Ticker TIGCF calculado\n",
      "Ticker TIGR calculado\n",
      "Ticker TIK calculado\n",
      "Ticker TIMCF calculado\n",
      "Ticker TIME calculado\n",
      "Ticker TIMGF calculado\n",
      "Ticker TINKF calculado\n",
      "Ticker TIPT calculado\n",
      "Ticker TIS calculado\n",
      "Ticker TISCF calculado\n",
      "Ticker TISI calculado\n",
      "Ticker TITCF calculado\n",
      "Ticker TITN calculado\n",
      "Ticker TIXC calculado\n",
      "Ticker TJSCF calculado\n",
      "Ticker TJX calculado\n",
      "Ticker TK calculado\n",
      "Ticker TKAGY calculado\n",
      "Ticker TKAYF calculado\n",
      "Ticker TKCM calculado\n",
      "Ticker TKFTF calculado\n",
      "Ticker TKGBY calculado\n",
      "Ticker TKGSF calculado\n",
      "Ticker TKGSY calculado\n",
      "Ticker TKGZY calculado\n",
      "Ticker TKHGF calculado\n",
      "Ticker TKHVF calculado\n",
      "Ticker TKHVY calculado\n",
      "Ticker TKKIF calculado\n",
      "Ticker TKPYY calculado\n",
      "Ticker TKR calculado\n",
      "Ticker TKRFF calculado\n",
      "Ticker TKSKF calculado\n",
      "Ticker TKSTF calculado\n",
      "Ticker TKTCY calculado\n",
      "Ticker TKURF calculado\n",
      "Ticker TKWAF calculado\n",
      "Ticker TKYMF calculado\n",
      "Ticker TKYMY calculado\n",
      "Ticker TLCO calculado\n",
      "Ticker TLF calculado\n",
      "Ticker TLGAF calculado\n",
      "Ticker TLGRF calculado\n",
      "Ticker TLK calculado\n",
      "Ticker TLLYF calculado\n",
      "Ticker TLMMF calculado\n",
      "Ticker TLMR calculado\n",
      "Ticker TLND calculado\n",
      "Ticker TLOFF calculado\n",
      "Ticker TLOG calculado\n",
      "Ticker TLRA calculado\n",
      "Ticker TLRD calculado\n",
      "Ticker TLRS calculado\n",
      "Ticker TLRY calculado\n",
      "Ticker TLSNF calculado\n",
      "Ticker TLSNY calculado\n",
      "Ticker TLSW calculado\n",
      "Ticker TLTFF calculado\n",
      "Ticker TLTZY calculado\n",
      "Ticker TLUXF calculado\n",
      "Ticker TLVLF calculado\n",
      "Ticker TLWDF calculado\n",
      "Ticker TLXPF calculado\n",
      "Ticker TMAK calculado\n",
      "Ticker TMBBY calculado\n",
      "Ticker TMCGF calculado\n",
      "Ticker TMCX calculado\n",
      "Ticker TMDI calculado\n",
      "Ticker TMED calculado\n",
      "Ticker TMHC calculado\n",
      "Ticker TMIAF calculado\n",
      "Ticker TMICF calculado\n",
      "Ticker TMICY calculado\n",
      "Ticker TMKOL calculado\n",
      "Ticker TMMFF calculado\n",
      "Ticker TMNSF calculado\n",
      "Ticker TMOAF calculado\n",
      "Ticker TMOAY calculado\n",
      "Ticker TMP calculado\n",
      "Ticker TMPHF calculado\n",
      "Ticker TMPPF calculado\n",
      "Ticker TMRR calculado\n",
      "Ticker TMSNY calculado\n",
      "Ticker TMSR calculado\n",
      "Ticker TMST calculado\n",
      "Ticker TMXN calculado\n",
      "Ticker TMXXF calculado\n",
      "Ticker TNABF calculado\n",
      "Ticker TNAV calculado\n",
      "Ticker TNBI calculado\n",
      "Ticker TNEN calculado\n",
      "Ticker TNGRY calculado\n",
      "Ticker TNGZF calculado\n",
      "Ticker TNISF calculado\n",
      "Ticker TNISY calculado\n",
      "Ticker TNK calculado\n",
      "Ticker TNLX calculado\n",
      "Ticker TNMCF calculado\n",
      "Ticker TNMRY calculado\n",
      "Ticker TNNFF calculado\n",
      "Ticker TNPH calculado\n",
      "Ticker TNREF calculado\n",
      "Ticker TNRG calculado\n",
      "Ticker TNRK calculado\n",
      "Ticker TNSGF calculado\n",
      "Ticker TNUG calculado\n",
      "Ticker TNXP calculado\n",
      "Ticker TNYYF calculado\n",
      "Ticker TOAK calculado\n",
      "Ticker TODGF calculado\n",
      "Ticker TOELY calculado\n",
      "Ticker TOEYF calculado\n",
      "Ticker TOIPY calculado\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Ticker TOISF calculado\n",
      "Ticker TOKCF calculado\n",
      "Ticker TOKSF calculado\n",
      "Ticker TOKUY calculado\n",
      "Ticker TOLWF calculado\n",
      "Ticker TONPF calculado\n",
      "Ticker TOOTQ calculado\n",
      "Ticker TOPS calculado\n",
      "Ticker TOPZ calculado\n",
      "Ticker TORC calculado\n",
      "Ticker TORM calculado\n",
      "Ticker TORXF calculado\n",
      "Ticker TOSCF calculado\n",
      "Ticker TOT calculado\n",
      "Ticker TOTA calculado\n",
      "Ticker TOTDY calculado\n",
      "Ticker TOTTF calculado\n",
      "Ticker TOTXF calculado\n",
      "Ticker TOUMF calculado\n",
      "Ticker TOWTF calculado\n",
      "Ticker TOYOF calculado\n",
      "Ticker TPB calculado\n",
      "Ticker TPBTF calculado\n",
      "Ticker TPC calculado\n",
      "Ticker TPCA calculado\n",
      "Ticker TPCFF calculado\n",
      "Ticker TPDKY calculado\n",
      "Ticker TPGH calculado\n",
      "Ticker TPH calculado\n",
      "Ticker TPHS calculado\n",
      "Ticker TPIC calculado\n",
      "Ticker TPLM calculado\n",
      "Ticker TPLWF calculado\n",
      "Ticker TPPPF calculado\n",
      "Ticker TPPRF calculado\n",
      "Ticker TPPTY calculado\n",
      "Ticker TPR calculado\n",
      "Ticker TPRFF calculado\n",
      "Ticker TPRP calculado\n",
      "Ticker TPTJF calculado\n",
      "Ticker TPTW calculado\n",
      "Ticker TPVTF calculado\n",
      "Ticker TPYSF calculado\n",
      "Ticker TRAGF calculado\n",
      "Ticker TRAYF calculado\n",
      "Ticker TRCH calculado\n",
      "Ticker TRCLF calculado\n",
      "Ticker TRCY calculado\n",
      "Ticker TREAF calculado\n",
      "Ticker TREE calculado\n",
      "Ticker TREVF calculado\n",
      "Ticker TREX calculado\n",
      "Ticker TRGAF calculado\n",
      "Ticker TRGGF calculado\n",
      "Ticker TRGM calculado\n",
      "Ticker TRGNF calculado\n",
      "Ticker TRGP calculado\n",
      "Ticker TRHF calculado\n",
      "Ticker TRHIF calculado\n",
      "Ticker TRHXF calculado\n",
      "Ticker TRI calculado\n",
      "Ticker TRIB calculado\n",
      "Ticker TRIL calculado\n",
      "Ticker TRIP calculado\n",
      "Ticker TRK calculado\n",
      "Ticker TRKCF calculado\n",
      "Ticker TRKK calculado\n",
      "Ticker TRKNF calculado\n",
      "Ticker TRKTF calculado\n",
      "Ticker TRLFF calculado\n",
      "Ticker TRLPF calculado\n",
      "Ticker TRMB calculado\n",
      "Ticker TRMEF calculado\n",
      "Ticker TRMLF calculado\n",
      "Ticker TRMT calculado\n",
      "Ticker TRMYQ calculado\n",
      "Ticker TRNLY calculado\n",
      "Ticker TRNO calculado\n",
      "Ticker TRON calculado\n",
      "Ticker TROV calculado\n",
      "Ticker TROX calculado\n",
      "Ticker TRPRY calculado\n",
      "Ticker TRPX calculado\n",
      "Ticker TRRFF calculado\n",
      "Ticker TRRNF calculado\n",
      "Ticker TRRSF calculado\n",
      "Ticker TRRVF calculado\n",
      "Ticker TRRXF calculado\n",
      "Ticker TRSBF calculado\n",
      "Ticker TRSDF calculado\n",
      "Ticker TRSU calculado\n",
      "Ticker TRT calculado\n",
      "Ticker TRTI calculado\n",
      "Ticker TRTN calculado\n",
      "Ticker TRUHF calculado\n",
      "Ticker TRUP calculado\n",
      "Ticker TRUU calculado\n",
      "Ticker TRUX calculado\n",
      "Ticker TRVB calculado\n",
      "Ticker TRVN calculado\n",
      "Ticker TRWKF calculado\n",
      "Ticker TRWRF calculado\n",
      "Ticker TRX calculado\n",
      "Ticker TRXA calculado\n",
      "Ticker TRXC calculado\n",
      "Ticker TRYF calculado\n",
      "Ticker TRYIY calculado\n",
      "Ticker TS calculado\n",
      "Ticker TSBBY calculado\n",
      "Ticker TSBLF calculado\n",
      "Ticker TSC calculado\n",
      "Ticker TSCAP calculado\n",
      "Ticker TSCC calculado\n",
      "Ticker TSCDF calculado\n",
      "Ticker TSCEF calculado\n",
      "Ticker TSCFY calculado\n",
      "Ticker TSCHY calculado\n",
      "Ticker TSCO calculado\n",
      "Ticker TSDOF calculado\n",
      "Ticker TSDRF calculado\n",
      "Ticker TSE calculado\n",
      "Ticker TSEM calculado\n",
      "Ticker TSETF calculado\n",
      "Ticker TSGL calculado\n",
      "Ticker TSGMY calculado\n",
      "Ticker TSGTF calculado\n",
      "Ticker TSHMY calculado\n",
      "Ticker TSHTF calculado\n",
      "Ticker TSLA calculado\n",
      "Ticker TSLLF calculado\n",
      "Ticker TSM calculado\n",
      "Ticker TSNLF calculado\n",
      "Ticker TSOCF calculado\n",
      "Ticker TSOH calculado\n",
      "Ticker TSPCF calculado\n",
      "Ticker TSQ calculado\n",
      "Ticker TSRO calculado\n",
      "Ticker TSS calculado\n",
      "Ticker TSSHF calculado\n",
      "Ticker TSSI calculado\n",
      "Ticker TSSJF calculado\n",
      "Ticker TSSNF calculado\n",
      "Ticker TST calculado\n",
      "Ticker TSU calculado\n",
      "Ticker TSUSF calculado\n",
      "Ticker TSYHY calculado\n",
      "Ticker TTALF calculado\n",
      "Ticker TTAZF calculado\n",
      "Ticker TTCNF calculado\n",
      "Ticker TTD calculado\n",
      "Ticker TTDKF calculado\n",
      "Ticker TTEC calculado\n",
      "Ticker TTEK calculado\n",
      "Ticker TTEN calculado\n",
      "Ticker TTEXF calculado\n",
      "Ticker TTGT calculado\n",
      "Ticker TTLO calculado\n",
      "Ticker TTNDF calculado\n",
      "Ticker TTNP calculado\n",
      "Ticker TTOBF calculado\n",
      "Ticker TTPH calculado\n",
      "Ticker TTRKF calculado\n",
      "Ticker TTTM calculado\n",
      "Ticker TTTRF calculado\n",
      "Ticker TTTXF calculado\n",
      "Ticker TTWO calculado\n",
      "Ticker TTWPF calculado\n",
      "Ticker TTWSF calculado\n",
      "Ticker TUBE calculado\n",
      "Ticker TUFBY calculado\n",
      "Ticker TUGHF calculado\n",
      "Ticker TUIFY calculado\n",
      "Ticker TUMI calculado\n",
      "Ticker TUMIF calculado\n",
      "Ticker TUP calculado\n",
      "Ticker TUPRF calculado\n",
      "Ticker TURA calculado\n",
      "Ticker TURN calculado\n",
      "Ticker TUSK calculado\n",
      "Ticker TUUNF calculado\n",
      "Ticker TUWLF calculado\n",
      "Ticker TV calculado\n",
      "Ticker TVBCF calculado\n",
      "Ticker TVBCY calculado\n",
      "Ticker TVIPF calculado\n",
      "Ticker TVNWY calculado\n",
      "Ticker TVPKF calculado\n",
      "Ticker TVPT calculado\n",
      "Ticker TW calculado\n",
      "Ticker TWC calculado\n",
      "Ticker TWCF calculado\n",
      "Ticker TWER calculado\n",
      "Ticker TWFH calculado\n",
      "Ticker TWI calculado\n",
      "Ticker TWIN calculado\n",
      "Ticker TWIRF calculado\n",
      "Ticker TWOC calculado\n",
      "Ticker TWODY calculado\n",
      "Ticker TWOU calculado\n",
      "Ticker TWRFF calculado\n",
      "Ticker TWSCF calculado\n",
      "Ticker TWTR calculado\n",
      "Ticker TWX calculado\n",
      "Ticker TXHD calculado\n",
      "Ticker TXHG calculado\n",
      "Ticker TXLZF calculado\n",
      "Ticker TXMD calculado\n",
      "Ticker TXN calculado\n",
      "Ticker TXSP calculado\n",
      "Ticker TXT calculado\n",
      "Ticker TXTR calculado\n",
      "Ticker TXWHF calculado\n",
      "Ticker TYBT calculado\n",
      "Ticker TYCB calculado\n",
      "Ticker TYHOF calculado\n",
      "Ticker TYIDY calculado\n",
      "Ticker TYL calculado\n",
      "Ticker TYME calculado\n",
      "Ticker TYPE calculado\n",
      "Ticker TYRA calculado\n",
      "Ticker TYUCF calculado\n",
      "Ticker TZLTF calculado\n",
      "Ticker TZNMF calculado\n",
      "Ticker TZNOF calculado\n",
      "Ticker TZOO calculado\n",
      "Ticker UACJF calculado\n",
      "Ticker UAHC calculado\n",
      "Ticker UAMA calculado\n",
      "Ticker UAMY calculado\n",
      "Ticker UAN calculado\n",
      "Ticker UBA calculado\n",
      "Ticker UBAB calculado\n",
      "Ticker UBEOF calculado\n",
      "Ticker UBEOY calculado\n",
      "Ticker UBFO calculado\n",
      "Ticker UBINF calculado\n",
      "Ticker UBMOF calculado\n",
      "Ticker UBMRF calculado\n",
      "Ticker UBNC calculado\n",
      "Ticker UBNSF calculado\n",
      "Ticker UBOH calculado\n",
      "Ticker UBS calculado\n",
      "Ticker UBSBF calculado\n",
      "Ticker UBSFY calculado\n",
      "Ticker UCAP calculado\n",
      "Ticker UCBI calculado\n",
      "Ticker UCBJF calculado\n",
      "Ticker UCBJY calculado\n",
      "Ticker UCCC calculado\n",
      "Ticker UCFC calculado\n",
      "Ticker UCMDF calculado\n",
      "Ticker UCP calculado\n",
      "Ticker UCPA calculado\n",
      "Ticker UCPH calculado\n",
      "Ticker UCTT calculado\n",
      "Ticker UDFI calculado\n",
      "Ticker UDHCF calculado\n",
      "Ticker UDIRF calculado\n",
      "Ticker UE calculado\n",
      "Ticker UEDVF calculado\n",
      "Ticker UEEC calculado\n",
      "Ticker UEIC calculado\n",
      "Ticker UFGSY calculado\n",
      "Ticker UFI calculado\n",
      "Ticker UFODF calculado\n",
      "Ticker UFPT calculado\n",
      "Ticker UG calculado\n",
      "Ticker UGDIF calculado\n",
      "Ticker UGEIF calculado\n",
      "Ticker UHAL calculado\n",
      "Ticker UHID calculado\n",
      "Ticker UHS calculado\n",
      "Ticker UIHC calculado\n",
      "Ticker UIS calculado\n",
      "Ticker UKLLF calculado\n",
      "Ticker UL calculado\n",
      "Ticker ULIHF calculado\n",
      "Ticker ULNV calculado\n",
      "Ticker ULPPF calculado\n",
      "Ticker ULTA calculado\n",
      "Ticker ULTI calculado\n",
      "Ticker ULTRF calculado\n",
      "Ticker ULTXF calculado\n",
      "Ticker ULUCF calculado\n",
      "Ticker UMBF calculado\n",
      "Ticker UMC calculado\n",
      "Ticker UMGP calculado\n",
      "Ticker UMH calculado\n",
      "Ticker UMHL calculado\n",
      "Ticker UMICY calculado\n",
      "Ticker UMRX calculado\n",
      "Ticker UMTAF calculado\n",
      "Ticker UNAM calculado\n",
      "Ticker UNB calculado\n",
      "Ticker UNBLF calculado\n",
      "Ticker UNCFF calculado\n",
      "Ticker UNCHF calculado\n",
      "Ticker UNCRY calculado\n",
      "Ticker UNDT calculado\n",
      "Ticker UNEGF calculado\n",
      "Ticker UNEQ calculado\n",
      "Ticker UNF calculado\n",
      "Ticker UNH calculado\n",
      "Ticker UNICY calculado\n",
      "Ticker UNIGF calculado\n",
      "Ticker UNISQ calculado\n",
      "Ticker UNISZ calculado\n",
      "Ticker UNIT calculado\n",
      "Ticker UNLRY calculado\n",
      "Ticker UNLVF calculado\n",
      "Ticker UNLYF calculado\n",
      "Ticker UNM calculado\n",
      "Ticker UNPLF calculado\n",
      "Ticker UNPRF calculado\n",
      "Ticker UNPSF calculado\n",
      "Ticker UNRDY calculado\n",
      "Ticker UNSI calculado\n",
      "Ticker UNSS calculado\n",
      "Ticker UNTD calculado\n",
      "Ticker UNTN calculado\n",
      "Ticker UNTOF calculado\n",
      "Ticker UOLGF calculado\n",
      "Ticker UOLGY calculado\n",
      "Ticker UOMO calculado\n",
      "Ticker UOVEF calculado\n",
      "Ticker UPBMF calculado\n",
      "Ticker UPCHY calculado\n",
      "Ticker UPDC calculado\n",
      "Ticker UPL calculado\n",
      "Ticker UPMKY calculado\n",
      "Ticker UPNRF calculado\n",
      "Ticker UPNRY calculado\n",
      "Ticker UPPR calculado\n",
      "Ticker URAGF calculado\n",
      "Ticker URAYY calculado\n",
      "Ticker URBT calculado\n",
      "Ticker URG calculado\n",
      "Ticker URGYF calculado\n",
      "Ticker URHG calculado\n",
      "Ticker URHY calculado\n",
      "Ticker URI calculado\n",
      "Ticker URNXF calculado\n",
      "Ticker URSL calculado\n",
      "Ticker URYL calculado\n",
      "Ticker URZZF calculado\n",
      "Ticker USAK calculado\n",
      "Ticker USAQ calculado\n",
      "Ticker USAS calculado\n",
      "Ticker USAT calculado\n",
      "Ticker USAU calculado\n",
      "Ticker USBL calculado\n",
      "Ticker USCFF calculado\n",
      "Ticker USCS calculado\n",
      "Ticker USDF calculado\n",
      "Ticker USDMY calculado\n",
      "Ticker USDP calculado\n",
      "Ticker USDR calculado\n",
      "Ticker USEL calculado\n",
      "Ticker USFD calculado\n",
      "Ticker USGDF calculado\n",
      "Ticker USLM calculado\n",
      "Ticker USMD calculado\n",
      "Ticker USMN calculado\n",
      "Ticker USMT calculado\n",
      "Ticker USNU calculado\n",
      "Ticker USNZY calculado\n",
      "Ticker USPI calculado\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Ticker USRM calculado\n",
      "Ticker USSJF calculado\n",
      "Ticker USSJY calculado\n",
      "Ticker USTC calculado\n",
      "Ticker USX calculado\n",
      "Ticker USYNF calculado\n",
      "Ticker UTEK calculado\n",
      "Ticker UTGPF calculado\n",
      "Ticker UTIW calculado\n",
      "Ticker UTOLF calculado\n",
      "Ticker UTRK calculado\n",
      "Ticker UTSI calculado\n",
      "Ticker UUUU calculado\n",
      "Ticker UVBIF calculado\n",
      "Ticker UVPOF calculado\n",
      "Ticker UVRBF calculado\n",
      "Ticker UVRBY calculado\n",
      "Ticker UVSP calculado\n",
      "Ticker UWHR calculado\n",
      "Ticker UXCLF calculado\n",
      "Ticker UXIN calculado\n",
      "Ticker V calculado\n",
      "Ticker VACNY calculado\n",
      "Ticker VALE calculado\n",
      "Ticker VALU calculado\n",
      "Ticker VALV calculado\n",
      "Ticker VANTF calculado\n",
      "Ticker VARHF calculado\n",
      "Ticker VASC calculado\n",
      "Ticker VASO calculado\n",
      "Ticker VAUCF calculado\n",
      "Ticker VBFC calculado\n",
      "Ticker VBHLF calculado\n",
      "Ticker VBIO calculado\n",
      "Ticker VBIV calculado\n",
      "Ticker VBLT calculado\n",
      "Ticker VBTX calculado\n",
      "Ticker VC calculado\n",
      "Ticker VCANF calculado\n",
      "Ticker VCBP calculado\n",
      "Ticker VCEL calculado\n",
      "Ticker VCHYF calculado\n",
      "Ticker VCIGF calculado\n",
      "Ticker VCISF calculado\n",
      "Ticker VCISY calculado\n",
      "Ticker VCMMF calculado\n",
      "Ticker VCOR calculado\n",
      "Ticker VCOYY calculado\n",
      "Ticker VDAHF calculado\n",
      "Ticker VDMCY calculado\n",
      "Ticker VDMRF calculado\n",
      "Ticker VDNRF calculado\n",
      "Ticker VDQSF calculado\n",
      "Ticker VDTAF calculado\n",
      "Ticker VDTH calculado\n",
      "Ticker VEAC calculado\n",
      "Ticker VECT calculado\n",
      "Ticker VEGYF calculado\n",
      "Ticker VEND calculado\n",
      "Ticker VEOEF calculado\n",
      "Ticker VERF calculado\n",
      "Ticker VERI calculado\n",
      "Ticker VESTF calculado\n",
      "Ticker VET calculado\n",
      "Ticker VETTF calculado\n",
      "Ticker VFC calculado\n",
      "Ticker VFFIF calculado\n",
      "Ticker VG calculado\n",
      "Ticker VGCEF calculado\n",
      "Ticker VGLDF calculado\n",
      "Ticker VGRBF calculado\n",
      "Ticker VGZ calculado\n",
      "Ticker VHC calculado\n",
      "Ticker VHI calculado\n",
      "Ticker VIA calculado\n",
      "Ticker VIAAY calculado\n",
      "Ticker VIAV calculado\n",
      "Ticker VIBVY calculado\n",
      "Ticker VICA calculado\n",
      "Ticker VICR calculado\n",
      "Ticker VIDE calculado\n",
      "Ticker VINO calculado\n",
      "Ticker VIPRF calculado\n",
      "Ticker VIPS calculado\n",
      "Ticker VIRC calculado\n",
      "Ticker VIRT calculado\n",
      "Ticker VISM calculado\n",
      "Ticker VITFF calculado\n",
      "Ticker VITIF calculado\n",
      "Ticker VIV calculado\n",
      "Ticker VIVE calculado\n",
      "Ticker VIVHY calculado\n",
      "Ticker VIVK calculado\n",
      "Ticker VIVO calculado\n",
      "Ticker VJET calculado\n",
      "Ticker VKEMF calculado\n",
      "Ticker VKPPF calculado\n",
      "Ticker VLDI calculado\n",
      "Ticker VLGEA calculado\n",
      "Ticker VLKAF calculado\n",
      "Ticker VLKPF calculado\n",
      "Ticker VLNVF calculado\n",
      "Ticker VLO calculado\n",
      "Ticker VLPNF calculado\n",
      "Ticker VLPNY calculado\n",
      "Ticker VLRDF calculado\n",
      "Ticker VLTHF calculado\n",
      "Ticker VLVLY calculado\n",
      "Ticker VLY calculado\n",
      "Ticker VMC calculado\n",
      "Ticker VMEMQ calculado\n",
      "Ticker VMPT calculado\n",
      "Ticker VMTG calculado\n",
      "Ticker VNAPF calculado\n",
      "Ticker VNARF calculado\n",
      "Ticker VNCI calculado\n",
      "Ticker VNCKF calculado\n",
      "Ticker VNDA calculado\n",
      "Ticker VNDSL calculado\n",
      "Ticker VNET calculado\n",
      "Ticker VNLPF calculado\n",
      "Ticker VNLPY calculado\n",
      "Ticker VNNVF calculado\n",
      "Ticker VNO calculado\n",
      "Ticker VNOM calculado\n",
      "Ticker VNRCF calculado\n",
      "Ticker VNRFY calculado\n",
      "Ticker VNRGF calculado\n",
      "Ticker VNRSQ calculado\n",
      "Ticker VOD calculado\n",
      "Ticker VODAF calculado\n",
      "Ticker VODG calculado\n",
      "Ticker VODOF calculado\n",
      "Ticker VODPF calculado\n",
      "Ticker VOHO calculado\n",
      "Ticker VOIL calculado\n",
      "Ticker VOLAF calculado\n",
      "Ticker VOLVF calculado\n",
      "Ticker VOLVY calculado\n",
      "Ticker VONOY calculado\n",
      "Ticker VOPKF calculado\n",
      "Ticker VOPKY calculado\n",
      "Ticker VOQP calculado\n",
      "Ticker VOSSF calculado\n",
      "Ticker VOXX calculado\n",
      "Ticker VOYJF calculado\n",
      "Ticker VPGLF calculado\n",
      "Ticker VPOSF calculado\n",
      "Ticker VPPNY calculado\n",
      "Ticker VPTV calculado\n",
      "Ticker VPYYF calculado\n",
      "Ticker VQSLF calculado\n",
      "Ticker VRA calculado\n",
      "Ticker VRCFF calculado\n",
      "Ticker VRCP calculado\n",
      "Ticker VRCV calculado\n",
      "Ticker VREX calculado\n",
      "Ticker VREYF calculado\n",
      "Ticker VRHD calculado\n",
      "Ticker VRME calculado\n",
      "Ticker VRML calculado\n",
      "Ticker VRNDF calculado\n",
      "Ticker VRNT calculado\n",
      "Ticker VRPMF calculado\n",
      "Ticker VRRKF calculado\n",
      "Ticker VRSO calculado\n",
      "Ticker VRSSF calculado\n",
      "Ticker VRTA calculado\n",
      "Ticker VRTHF calculado\n",
      "Ticker VRTS calculado\n",
      "Ticker VRTT calculado\n",
      "Ticker VRTV calculado\n",
      "Ticker VRTY calculado\n",
      "Ticker VRXWF calculado\n",
      "Ticker VSAR calculado\n",
      "Ticker VSBN calculado\n",
      "Ticker VSCP calculado\n",
      "Ticker VSEC calculado\n",
      "Ticker VSMR calculado\n",
      "Ticker VSNDF calculado\n",
      "Ticker VSRI calculado\n",
      "Ticker VSRV calculado\n",
      "Ticker VSSPY calculado\n",
      "Ticker VSSSF calculado\n",
      "Ticker VST calculado\n",
      "Ticker VSTHY calculado\n",
      "Ticker VSTM calculado\n",
      "Ticker VSTO calculado\n",
      "Ticker VTCCF calculado\n",
      "Ticker VTDI calculado\n",
      "Ticker VTEPF calculado\n",
      "Ticker VTEQ calculado\n",
      "Ticker VTGFF calculado\n",
      "Ticker VTGN calculado\n",
      "Ticker VTIQ calculado\n",
      "Ticker VTIQW calculado\n",
      "Ticker VTKLY calculado\n",
      "Ticker VTL calculado\n",
      "Ticker VTLR calculado\n",
      "Ticker VTMTF calculado\n",
      "Ticker VTNA calculado\n",
      "Ticker VTR calculado\n",
      "Ticker VTRLY calculado\n",
      "Ticker VTSI calculado\n",
      "Ticker VTTCF calculado\n",
      "Ticker VTVT calculado\n",
      "Ticker VULC calculado\n",
      "Ticker VUPPF calculado\n",
      "Ticker VVC calculado\n",
      "Ticker VVCIF calculado\n",
      "Ticker VVDB calculado\n",
      "Ticker VVDL calculado\n",
      "Ticker VVI calculado\n",
      "Ticker VVIVF calculado\n",
      "Ticker VVPR calculado\n",
      "Ticker VVUS calculado\n",
      "Ticker VVV calculado\n",
      "Ticker VWAPY calculado\n",
      "Ticker VWIN calculado\n",
      "Ticker VWLTF calculado\n",
      "Ticker VWR calculado\n",
      "Ticker VWSYF calculado\n",
      "Ticker VXMFF calculado\n",
      "Ticker VXSYF calculado\n",
      "Ticker VYEY calculado\n",
      "Ticker VYYRF calculado\n",
      "Ticker VZ calculado\n",
      "Ticker VZHGF calculado\n",
      "Ticker WAAS calculado\n",
      "Ticker WAB calculado\n",
      "Ticker WACMF calculado\n",
      "Ticker WACMY calculado\n",
      "Ticker WAFD calculado\n",
      "Ticker WAIR calculado\n",
      "Ticker WAKE calculado\n",
      "Ticker WALKQ calculado\n",
      "Ticker WANHF calculado\n",
      "Ticker WANSF calculado\n",
      "Ticker WARFF calculado\n",
      "Ticker WAT calculado\n",
      "Ticker WATKF calculado\n",
      "Ticker WAVXQ calculado\n",
      "Ticker WAWL calculado\n",
      "Ticker WAYN calculado\n",
      "Ticker WB calculado\n",
      "Ticker WBAI calculado\n",
      "Ticker WBBW calculado\n",
      "Ticker WBC calculado\n",
      "Ticker WBHC calculado\n",
      "Ticker WBKC calculado\n",
      "Ticker WBRBF calculado\n",
      "Ticker WBRBY calculado\n",
      "Ticker WBS calculado\n",
      "Ticker WBSI calculado\n",
      "Ticker WCAGY calculado\n",
      "Ticker WCC calculado\n",
      "Ticker WCCP calculado\n",
      "Ticker WCRE calculado\n",
      "Ticker WCRS calculado\n",
      "Ticker WCTXD calculado\n",
      "Ticker WCVC calculado\n",
      "Ticker WCYN calculado\n",
      "Ticker WD calculado\n",
      "Ticker WDC calculado\n",
      "Ticker WDCRF calculado\n",
      "Ticker WDDD calculado\n",
      "Ticker WDDYF calculado\n",
      "Ticker WDFC calculado\n",
      "Ticker WDFPF calculado\n",
      "Ticker WDGJF calculado\n",
      "Ticker WDPSF calculado\n",
      "Ticker WDR calculado\n",
      "Ticker WDRP calculado\n",
      "Ticker WEB calculado\n",
      "Ticker WEBJF calculado\n",
      "Ticker WEC calculado\n",
      "Ticker WECFY calculado\n",
      "Ticker WECT calculado\n",
      "Ticker WEDG calculado\n",
      "Ticker WEDXF calculado\n",
      "Ticker WEFIF calculado\n",
      "Ticker WEGOF calculado\n",
      "Ticker WEGZY calculado\n",
      "Ticker WEICY calculado\n",
      "Ticker WEQL calculado\n",
      "Ticker WERN calculado\n",
      "Ticker WEWA calculado\n",
      "Ticker WEX calculado\n",
      "Ticker WFAFF calculado\n",
      "Ticker WFBI calculado\n",
      "Ticker WFCF calculado\n",
      "Ticker WFM calculado\n",
      "Ticker WFMRF calculado\n",
      "Ticker WFRSF calculado\n",
      "Ticker WFTSF calculado\n",
      "Ticker WGBS calculado\n",
      "Ticker WGL calculado\n",
      "Ticker WGO calculado\n",
      "Ticker WGP calculado\n",
      "Ticker WGRP calculado\n",
      "Ticker WHGLY calculado\n",
      "Ticker WHGRF calculado\n",
      "Ticker WHLKF calculado\n",
      "Ticker WHLR calculado\n",
      "Ticker WHLX calculado\n",
      "Ticker WHWRF calculado\n",
      "Ticker WHXT calculado\n",
      "Ticker WHZT calculado\n",
      "Ticker WILC calculado\n",
      "Ticker WILD calculado\n",
      "Ticker WILLF calculado\n",
      "Ticker WILYY calculado\n",
      "Ticker WIMHF calculado\n",
      "Ticker WINA calculado\n",
      "Ticker WIPKF calculado\n",
      "Ticker WIRE calculado\n",
      "Ticker WISA calculado\n",
      "Ticker WISH calculado\n",
      "Ticker WISRF calculado\n",
      "Ticker WIT calculado\n",
      "Ticker WIX calculado\n",
      "Ticker WJAVF calculado\n",
      "Ticker WJRYF calculado\n",
      "Ticker WJRYY calculado\n",
      "Ticker WKCMF calculado\n",
      "Ticker WKHS calculado\n",
      "Ticker WKLDF calculado\n",
      "Ticker WKLN calculado\n",
      "Ticker WLDFF calculado\n",
      "Ticker WLDVF calculado\n",
      "Ticker WLFC calculado\n",
      "Ticker WLFDF calculado\n",
      "Ticker WLFFF calculado\n",
      "Ticker WLHSF calculado\n",
      "Ticker WLK calculado\n",
      "Ticker WLMIF calculado\n",
      "Ticker WLMIY calculado\n",
      "Ticker WLMS calculado\n",
      "Ticker WLSE calculado\n",
      "Ticker WLTNF calculado\n",
      "Ticker WLTW calculado\n",
      "Ticker WLWHY calculado\n",
      "Ticker WLYYF calculado\n",
      "Ticker WMAR calculado\n",
      "Ticker WMC calculado\n",
      "Ticker WMDS calculado\n",
      "Ticker WMEG calculado\n",
      "Ticker WMGI calculado\n",
      "Ticker WMGR calculado\n",
      "Ticker WMGTF calculado\n",
      "Ticker WMLLF calculado\n",
      "Ticker WMMVF calculado\n",
      "Ticker WMMVY calculado\n",
      "Ticker WMNNF calculado\n",
      "Ticker WMPN calculado\n",
      "Ticker WMT calculado\n",
      "Ticker WNDLF calculado\n",
      "Ticker WNHTF calculado\n",
      "Ticker WNRL calculado\n",
      "Ticker WNRP calculado\n",
      "Ticker WNS calculado\n",
      "Ticker WNXDF calculado\n",
      "Ticker WOLWF calculado\n",
      "Ticker WONEF calculado\n",
      "Ticker WOPEF calculado\n",
      "Ticker WOSSF calculado\n",
      "Ticker WOWMF calculado\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Ticker WP calculado\n",
      "Ticker WPCZF calculado\n",
      "Ticker WPFH calculado\n",
      "Ticker WPG calculado\n",
      "Ticker WPM calculado\n",
      "Ticker WPP calculado\n",
      "Ticker WPPGF calculado\n",
      "Ticker WPRXF calculado\n",
      "Ticker WPTIF calculado\n",
      "Ticker WPYGY calculado\n",
      "Ticker WRCDF calculado\n",
      "Ticker WRD calculado\n",
      "Ticker WRDEF calculado\n",
      "Ticker WRE calculado\n",
      "Ticker WRESQ calculado\n",
      "Ticker WRGP calculado\n",
      "Ticker WRN calculado\n",
      "Ticker WRRNF calculado\n",
      "Ticker WRTBY calculado\n",
      "Ticker WRTC calculado\n",
      "Ticker WSBC calculado\n",
      "Ticker WSBF calculado\n",
      "Ticker WSBHF calculado\n",
      "Ticker WSCO calculado\n",
      "Ticker WSCRF calculado\n",
      "Ticker WSEYF calculado\n",
      "Ticker WSHE calculado\n",
      "Ticker WSM calculado\n",
      "Ticker WSMTF calculado\n",
      "Ticker WSPS calculado\n",
      "Ticker WSRA calculado\n",
      "Ticker WSRRF calculado\n",
      "Ticker WSSXF calculado\n",
      "Ticker WSTL calculado\n",
      "Ticker WSTM calculado\n",
      "Ticker WSTRF calculado\n",
      "Ticker WTBDY calculado\n",
      "Ticker WTCG calculado\n",
      "Ticker WTCRF calculado\n",
      "Ticker WTCZF calculado\n",
      "Ticker WTFC calculado\n",
      "Ticker WTHVF calculado\n",
      "Ticker WTKN calculado\n",
      "Ticker WTKWY calculado\n",
      "Ticker WTLC calculado\n",
      "Ticker WTM calculado\n",
      "Ticker WTNW calculado\n",
      "Ticker WTR calculado\n",
      "Ticker WTS calculado\n",
      "Ticker WTSHF calculado\n",
      "Ticker WTT calculado\n",
      "Ticker WTTR calculado\n",
      "Ticker WTXR calculado\n",
      "Ticker WU calculado\n",
      "Ticker WUBA calculado\n",
      "Ticker WUHN calculado\n",
      "Ticker WUMSF calculado\n",
      "Ticker WUMSY calculado\n",
      "Ticker WVE calculado\n",
      "Ticker WVVI calculado\n",
      "Ticker WWAV calculado\n",
      "Ticker WWE calculado\n",
      "Ticker WWNTF calculado\n",
      "Ticker WWNTY calculado\n",
      "Ticker WWR calculado\n",
      "Ticker WWW calculado\n",
      "Ticker WY calculado\n",
      "Ticker WYNMF calculado\n",
      "Ticker WYNMY calculado\n",
      "Ticker WYNN calculado\n",
      "Ticker WYY calculado\n",
      "Ticker WZENY calculado\n",
      "Ticker WZZZY calculado\n",
      "Ticker X calculado\n",
      "Ticker XAARF calculado\n",
      "Ticker XANAF calculado\n",
      "Ticker XAUMF calculado\n",
      "Ticker XBIO calculado\n",
      "Ticker XBIT calculado\n",
      "Ticker XBKS calculado\n",
      "Ticker XCOMQ calculado\n",
      "Ticker XCOOQ calculado\n",
      "Ticker XCRA calculado\n",
      "Ticker XCUR calculado\n",
      "Ticker XDRC calculado\n",
      "Ticker XEBEF calculado\n",
      "Ticker XEL calculado\n",
      "Ticker XELA calculado\n",
      "Ticker XENE calculado\n",
      "Ticker XENT calculado\n",
      "Ticker XERS calculado\n",
      "Ticker XFTB calculado\n",
      "Ticker XHFNF calculado\n",
      "Ticker XHR calculado\n",
      "Ticker XIN calculado\n",
      "Ticker XL calculado\n",
      "Ticker XLEFF calculado\n",
      "Ticker XLMDF calculado\n",
      "Ticker XNCR calculado\n",
      "Ticker XNGSF calculado\n",
      "Ticker XNGSY calculado\n",
      "Ticker XNJJY calculado\n",
      "Ticker XNPT calculado\n",
      "Ticker XOM calculado\n",
      "Ticker XOMA calculado\n",
      "Ticker XON calculado\n",
      "Ticker XOOM calculado\n",
      "Ticker XOXO calculado\n",
      "Ticker XPL calculado\n",
      "Ticker XPLR calculado\n",
      "Ticker XPO calculado\n",
      "Ticker XPPLF calculado\n",
      "Ticker XPWR calculado\n",
      "Ticker XRA calculado\n",
      "Ticker XRAY calculado\n",
      "Ticker XRDC calculado\n",
      "Ticker XRELF calculado\n",
      "Ticker XRESF calculado\n",
      "Ticker XRF calculado\n",
      "Ticker XSPA calculado\n",
      "Ticker XSPY calculado\n",
      "Ticker XTEPY calculado\n",
      "Ticker XTGRF calculado\n",
      "Ticker XTHCF calculado\n",
      "Ticker XTLB calculado\n",
      "Ticker XTLS calculado\n",
      "Ticker XTNY calculado\n",
      "Ticker XTRRF calculado\n",
      "Ticker XXLLY calculado\n",
      "Ticker XXMMF calculado\n",
      "Ticker XXNCB calculado\n",
      "Ticker XXNCC calculado\n",
      "Ticker XYF calculado\n",
      "Ticker XYLTF calculado\n",
      "Ticker XZJCF calculado\n",
      "Ticker Y calculado\n",
      "Ticker YACAF calculado\n",
      "Ticker YAGOY calculado\n",
      "Ticker YAMCF calculado\n",
      "Ticker YAMCY calculado\n",
      "Ticker YAMHF calculado\n",
      "Ticker YASKF calculado\n",
      "Ticker YASKY calculado\n",
      "Ticker YATRY calculado\n",
      "Ticker YBAO calculado\n",
      "Ticker YDLE calculado\n",
      "Ticker YDVL calculado\n",
      "Ticker YDWAF calculado\n",
      "Ticker YECO calculado\n",
      "Ticker YELP calculado\n",
      "Ticker YEWB calculado\n",
      "Ticker YFGSF calculado\n",
      "Ticker YGEHY calculado\n",
      "Ticker YGYI calculado\n",
      "Ticker YHMGF calculado\n",
      "Ticker YI calculado\n",
      "Ticker YIN calculado\n",
      "Ticker YINGY calculado\n",
      "Ticker YITYF calculado\n",
      "Ticker YKLTF calculado\n",
      "Ticker YKYOF calculado\n",
      "Ticker YLDGF calculado\n",
      "Ticker YLWDF calculado\n",
      "Ticker YMAB calculado\n",
      "Ticker YMAIF calculado\n",
      "Ticker YMMTY calculado\n",
      "Ticker YMTKF calculado\n",
      "Ticker YNSGF calculado\n",
      "Ticker YNSKF calculado\n",
      "Ticker YONGY calculado\n",
      "Ticker YOOIF calculado\n",
      "Ticker YOSN calculado\n",
      "Ticker YPFSF calculado\n",
      "Ticker YRLLF calculado\n",
      "Ticker YSHLF calculado\n",
      "Ticker YSYB calculado\n",
      "Ticker YTEN calculado\n",
      "Ticker YTFD calculado\n",
      "Ticker YTRGF calculado\n",
      "Ticker YUANF calculado\n",
      "Ticker YUEIF calculado\n",
      "Ticker YUEXF calculado\n",
      "Ticker YUGVF calculado\n",
      "Ticker YUM calculado\n",
      "Ticker YUMM calculado\n",
      "Ticker YUMSF calculado\n",
      "Ticker YUSG calculado\n",
      "Ticker YY calculado\n",
      "Ticker YYEQF calculado\n",
      "Ticker YYEQG calculado\n",
      "Ticker YZCHF calculado\n",
      "Ticker ZAIS calculado\n",
      "Ticker ZARFF calculado\n",
      "Ticker ZBH calculado\n",
      "Ticker ZDGE calculado\n",
      "Ticker ZDPY calculado\n",
      "Ticker ZEAL calculado\n",
      "Ticker ZENO calculado\n",
      "Ticker ZENYF calculado\n",
      "Ticker ZEUS calculado\n",
      "Ticker ZFGN calculado\n",
      "Ticker ZFSVF calculado\n",
      "Ticker ZG calculado\n",
      "Ticker ZGBEF calculado\n",
      "Ticker ZGSI calculado\n",
      "Ticker ZHEXF calculado\n",
      "Ticker ZHUZY calculado\n",
      "Ticker ZIGGF calculado\n",
      "Ticker ZIJMF calculado\n",
      "Ticker ZINCQ calculado\n",
      "Ticker ZION calculado\n",
      "Ticker ZIXI calculado\n",
      "Ticker ZKCCD calculado\n",
      "Ticker ZLDAF calculado\n",
      "Ticker ZLDPF calculado\n",
      "Ticker ZLDSF calculado\n",
      "Ticker ZLIOF calculado\n",
      "Ticker ZLIOY calculado\n",
      "Ticker ZLPSF calculado\n",
      "Ticker ZMMDF calculado\n",
      "Ticker ZMTP calculado\n",
      "Ticker ZMWYF calculado\n",
      "Ticker ZNCM calculado\n",
      "Ticker ZNDX calculado\n",
      "Ticker ZNKKY calculado\n",
      "Ticker ZNRNF calculado\n",
      "Ticker ZNZNF calculado\n",
      "Ticker ZODFF calculado\n",
      "Ticker ZODFY calculado\n",
      "Ticker ZOES calculado\n",
      "Ticker ZOM calculado\n",
      "Ticker ZONMY calculado\n",
      "Ticker ZONNF calculado\n",
      "Ticker ZPAS calculado\n",
      "Ticker ZPHYF calculado\n",
      "Ticker ZPIN calculado\n",
      "Ticker ZPTAF calculado\n",
      "Ticker ZRMG calculado\n",
      "Ticker ZRRRF calculado\n",
      "Ticker ZRSEF calculado\n",
      "Ticker ZRVT calculado\n",
      "Ticker ZSHGY calculado\n",
      "Ticker ZSTN calculado\n",
      "Ticker ZTCOY calculado\n",
      "Ticker ZTO calculado\n",
      "Ticker ZTSTF calculado\n",
      "Ticker ZUGFF calculado\n",
      "Ticker ZUMZ calculado\n",
      "Ticker ZXAIY calculado\n",
      "Ticker ZYNE calculado\n",
      "Ticker ZYXI calculado\n",
      "Ticker ZZZOF calculado\n",
      "Wall time: 1h 10min 43s\n"
     ]
    }
   ],
   "source": [
    "%%time\n",
    "financialDF['RETURNS'] = 0\n",
    "tickers_no_calculados = []\n",
    "#¡¡NO EJECUTAR CON TODAS LAS COMPAÑIAS!!\n",
    "for c in lista_companias:    \n",
    "#for c in ['AAPL']:\n",
    "    try:        \n",
    "        df = financialDF.loc[(c),]        \n",
    "        list_returns = []\n",
    "        list_returns_index = []\n",
    "        list_prices_open = []\n",
    "        list_prices_close = []\n",
    "        price_company = prices.loc[(c),]\n",
    "        for date in df.index:            \n",
    "            returns, qini, qfin = calcular_returns(date, price_company, True)\n",
    "            returns_index, _, _, = calcular_returns(date, index, False)\n",
    "            #No he conseguido que me actualice financialDF, pongo esto:\n",
    "            #financialDF.loc[(date),'RETURNS'] = returns\n",
    "            #y no me actualiza la columna returns, sin embargo con esto si actualiza df\n",
    "            #df.loc[(date),'RETURNS'] = returns\n",
    "            #df.loc[(date),'INDEX_RETURNS'] = returns_index\n",
    "            list_returns.append(returns)\n",
    "            list_returns_index.append(returns_index)\n",
    "            list_prices_open.append(qini)\n",
    "            list_prices_close.append(qfin)\n",
    "        df['PRICE_INI'] = np.array(list_prices_open)\n",
    "        df['PRICE_FIN'] = np.array(list_prices_close)\n",
    "        df['RETURNS'] = np.array(list_returns)        \n",
    "        df['INDEX_RETURNS'] = np.array(list_returns_index)\n",
    "        col_to_shift1 = ['RETURNS']\n",
    "        col_to_shift2 = ['INDEX_RETURNS']\n",
    "        df['RETURNS_NEXT'] = df[col_to_shift1].shift(-1)\n",
    "        df['INDEX_RETURNS_NEXT'] = df[col_to_shift2].shift(-1)\n",
    "        df['RETURNS_CAT'] = np.where(df['RETURNS']>0, 'POSITIVE', 'NEGATIVE')\n",
    "        df['RETURNS_NEXT_CAT'] = np.where(df['RETURNS_NEXT']>0, 'POSITIVE', 'NEGATIVE')\n",
    "        df['RETURNS_vs_INDEX'] = np.where(df['RETURNS']>df['INDEX_RETURNS'], 'WINS', 'LOSES')\n",
    "        df['RETURNS_vs_INDEX_NEXT'] = np.where(df['RETURNS_NEXT']>df['INDEX_RETURNS_NEXT'], 'WINS', 'LOSES')\n",
    "        df['Ticker'] = c\n",
    "        filename = 'Datos_csv/'+c+'.csv'\n",
    "        df.to_csv(filename, sep=';')\n",
    "        print('Ticker',c,'calculado')\n",
    "    except:\n",
    "        tickers_no_calculados.append(c)\n",
    "        pass"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['SZHNF',\n",
       " 'TAWNY',\n",
       " 'TDSNA',\n",
       " 'TGE',\n",
       " 'TKFHY',\n",
       " 'TNKHF',\n",
       " 'TPGVF',\n",
       " 'TSPPF',\n",
       " 'TTSNF',\n",
       " 'True',\n",
       " 'UBKZF',\n",
       " 'UNTDV',\n",
       " 'VCNYY',\n",
       " 'VOMT',\n",
       " 'WBEMF',\n",
       " 'WONCF',\n",
       " 'XXJZA',\n",
       " 'YLLWF',\n",
       " 'YYSSM',\n",
       " 'ZHAOY',\n",
       " 'ZHULF',\n",
       " 'ZIGNY']"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tickers_no_calculados"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "####  Y cuando estén generados todos los csvs.... ejecutar :-)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.concat([pd.read_csv(f, sep=';') for f in glob.glob('Datos_csv/*.csv')], ignore_index = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.concat([df, dd])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "9398"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df['Ticker'].unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('Datos_csv/financials_prices_quaterly_guru_v2.csv', sep=',', index=False)"
   ]
  }
 ],
 "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.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}