Model_Input.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "#15.433 - Finance Lab\n",
    "#William Blair Team\n",
    "#Getting the necessary inputs for the Option Pricing Model"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "In /Users/panqian/anaconda3/lib/python3.7/site-packages/matplotlib/mpl-data/stylelib/_classic_test.mplstyle: \n",
      "The text.latex.preview rcparam was deprecated in Matplotlib 3.3 and will be removed two minor releases later.\n",
      "In /Users/panqian/anaconda3/lib/python3.7/site-packages/matplotlib/mpl-data/stylelib/_classic_test.mplstyle: \n",
      "The mathtext.fallback_to_cm rcparam was deprecated in Matplotlib 3.3 and will be removed two minor releases later.\n",
      "In /Users/panqian/anaconda3/lib/python3.7/site-packages/matplotlib/mpl-data/stylelib/_classic_test.mplstyle: Support for setting the 'mathtext.fallback_to_cm' rcParam is deprecated since 3.3 and will be removed two minor releases later; use 'mathtext.fallback : 'cm' instead.\n",
      "In /Users/panqian/anaconda3/lib/python3.7/site-packages/matplotlib/mpl-data/stylelib/_classic_test.mplstyle: \n",
      "The validate_bool_maybe_none function was deprecated in Matplotlib 3.3 and will be removed two minor releases later.\n",
      "In /Users/panqian/anaconda3/lib/python3.7/site-packages/matplotlib/mpl-data/stylelib/_classic_test.mplstyle: \n",
      "The savefig.jpeg_quality rcparam was deprecated in Matplotlib 3.3 and will be removed two minor releases later.\n",
      "In /Users/panqian/anaconda3/lib/python3.7/site-packages/matplotlib/mpl-data/stylelib/_classic_test.mplstyle: \n",
      "The keymap.all_axes rcparam was deprecated in Matplotlib 3.3 and will be removed two minor releases later.\n",
      "In /Users/panqian/anaconda3/lib/python3.7/site-packages/matplotlib/mpl-data/stylelib/_classic_test.mplstyle: \n",
      "The animation.avconv_path rcparam was deprecated in Matplotlib 3.3 and will be removed two minor releases later.\n",
      "In /Users/panqian/anaconda3/lib/python3.7/site-packages/matplotlib/mpl-data/stylelib/_classic_test.mplstyle: \n",
      "The animation.avconv_args rcparam was deprecated in Matplotlib 3.3 and will be removed two minor releases later.\n"
     ]
    }
   ],
   "source": [
    "#Importing necessary libraries\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "from datetime import datetime, timedelta\n",
    "from scipy import stats\n",
    "\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "#Reading the provided files\n",
    "##Reading the Initial File\n",
    "Col_Names_1 = ['Date', 'Issuer Name', 'Ticker', 'Country Code', 'Country', 'Debt Security Name', 'Bid Price USD', 'Equity Security Name', 'Equity Price USD', 'Equity Total Return', 'Fiscal Date', 'Total Assets', 'Total Liabilities', 'Total Corporate Debt', 'Total Shareholders Equity', 'Shares Outstanding', 'Dividends per Share', 'Dividends Paid', 'Dividend Yield']\n",
    "Filepath_1 = 'MexicanSecurityData.csv'\n",
    "Type = {'Date':'object', 'Issuer Name':'object', 'Ticker':'object', 'Country Code':'object', 'Country':'object', 'Debt Security Name':'object', 'Bid Price USD':'float64', 'Equity Security Name':'object', 'Equity Price USD':'float64', 'Equity Total Return':'float64', 'Fiscal Date':'float64', 'Total Assets':'float64', 'Total Liabilities':'float64', 'Total Corporate Debt':'float64', 'Total Shareholders Equity':'float64', 'Shares Outstanding':'float64', 'Dividends per Share':'float64', 'Dividends Paid':'float64', 'Dividend Yield':'float64'}\n",
    "Mexican_Data = pd.read_csv(Filepath_1, header = 0, dtype = Type, names = Col_Names_1, na_values = ' NA')\n",
    "\n",
    "\n",
    "##Reading the Maturity File\n",
    "Col_Names_2 = ['Debt Name', 'Maturity']\n",
    "Filepath_2 = 'MexicanMaturities.xlsx'\n",
    "Mexican_Maturities = pd.read_excel(Filepath_2, header = 0, names = Col_Names_2, na_values = ' NA')\n",
    "\n",
    "\n",
    "##Reading the Treasury File\n",
    "Col_Names_3 = ['Date', '3M Libor', '1Y', '3Y', '5Y', '7Y', '10Y', '15Y', '30Y']\n",
    "Filepath_3 = 'USTRateData.csv'\n",
    "Treasury_Rate = pd.read_csv(Filepath_3, header = 0, names = Col_Names_3, na_values = ' NA')\n",
    "\n",
    "\n",
    "## For simplicity, we will start working with one bond - the one of Banorte\n",
    "Banorte = Mexican_Data[Mexican_Data['Ticker'] == 'BANORT']\n",
    "# Banorte.head(10)"
   ]
  },
  {
   "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>Date</th>\n",
       "      <th>3M Libor</th>\n",
       "      <th>1Y</th>\n",
       "      <th>3Y</th>\n",
       "      <th>5Y</th>\n",
       "      <th>7Y</th>\n",
       "      <th>10Y</th>\n",
       "      <th>15Y</th>\n",
       "      <th>30Y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2013-12-24</td>\n",
       "      <td>0.002468</td>\n",
       "      <td>0.00134</td>\n",
       "      <td>0.00798</td>\n",
       "      <td>0.01724</td>\n",
       "      <td>0.02420</td>\n",
       "      <td>0.02988</td>\n",
       "      <td>0.03440</td>\n",
       "      <td>0.03894</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2013-12-25</td>\n",
       "      <td>0.002468</td>\n",
       "      <td>0.00134</td>\n",
       "      <td>0.00799</td>\n",
       "      <td>0.01725</td>\n",
       "      <td>0.02420</td>\n",
       "      <td>0.02989</td>\n",
       "      <td>0.03440</td>\n",
       "      <td>0.03894</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2013-12-26</td>\n",
       "      <td>0.002468</td>\n",
       "      <td>0.00131</td>\n",
       "      <td>0.00803</td>\n",
       "      <td>0.01736</td>\n",
       "      <td>0.02434</td>\n",
       "      <td>0.03002</td>\n",
       "      <td>0.03453</td>\n",
       "      <td>0.03924</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2013-12-27</td>\n",
       "      <td>0.002466</td>\n",
       "      <td>0.00126</td>\n",
       "      <td>0.00789</td>\n",
       "      <td>0.01730</td>\n",
       "      <td>0.02434</td>\n",
       "      <td>0.03011</td>\n",
       "      <td>0.03470</td>\n",
       "      <td>0.03938</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2013-12-28</td>\n",
       "      <td>0.002466</td>\n",
       "      <td>0.00126</td>\n",
       "      <td>0.00789</td>\n",
       "      <td>0.01730</td>\n",
       "      <td>0.02434</td>\n",
       "      <td>0.03011</td>\n",
       "      <td>0.03470</td>\n",
       "      <td>0.03938</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2550</th>\n",
       "      <td>2020-12-17</td>\n",
       "      <td>0.002386</td>\n",
       "      <td>0.00090</td>\n",
       "      <td>0.00185</td>\n",
       "      <td>0.00385</td>\n",
       "      <td>0.00659</td>\n",
       "      <td>0.00937</td>\n",
       "      <td>0.01142</td>\n",
       "      <td>0.01681</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2551</th>\n",
       "      <td>2020-12-18</td>\n",
       "      <td>0.002357</td>\n",
       "      <td>0.00091</td>\n",
       "      <td>0.00184</td>\n",
       "      <td>0.00390</td>\n",
       "      <td>0.00667</td>\n",
       "      <td>0.00953</td>\n",
       "      <td>0.01159</td>\n",
       "      <td>0.01693</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2552</th>\n",
       "      <td>2020-12-19</td>\n",
       "      <td>0.002357</td>\n",
       "      <td>0.00091</td>\n",
       "      <td>0.00184</td>\n",
       "      <td>0.00390</td>\n",
       "      <td>0.00667</td>\n",
       "      <td>0.00953</td>\n",
       "      <td>0.01159</td>\n",
       "      <td>0.01693</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2553</th>\n",
       "      <td>2020-12-20</td>\n",
       "      <td>0.002357</td>\n",
       "      <td>0.00091</td>\n",
       "      <td>0.00184</td>\n",
       "      <td>0.00390</td>\n",
       "      <td>0.00667</td>\n",
       "      <td>0.00953</td>\n",
       "      <td>0.01159</td>\n",
       "      <td>0.01693</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2554</th>\n",
       "      <td>2020-12-21</td>\n",
       "      <td>0.002449</td>\n",
       "      <td>0.00091</td>\n",
       "      <td>0.00181</td>\n",
       "      <td>0.00388</td>\n",
       "      <td>0.00660</td>\n",
       "      <td>0.00939</td>\n",
       "      <td>0.01142</td>\n",
       "      <td>0.01674</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2555 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Date  3M Libor       1Y       3Y       5Y       7Y      10Y  \\\n",
       "0     2013-12-24  0.002468  0.00134  0.00798  0.01724  0.02420  0.02988   \n",
       "1     2013-12-25  0.002468  0.00134  0.00799  0.01725  0.02420  0.02989   \n",
       "2     2013-12-26  0.002468  0.00131  0.00803  0.01736  0.02434  0.03002   \n",
       "3     2013-12-27  0.002466  0.00126  0.00789  0.01730  0.02434  0.03011   \n",
       "4     2013-12-28  0.002466  0.00126  0.00789  0.01730  0.02434  0.03011   \n",
       "...          ...       ...      ...      ...      ...      ...      ...   \n",
       "2550  2020-12-17  0.002386  0.00090  0.00185  0.00385  0.00659  0.00937   \n",
       "2551  2020-12-18  0.002357  0.00091  0.00184  0.00390  0.00667  0.00953   \n",
       "2552  2020-12-19  0.002357  0.00091  0.00184  0.00390  0.00667  0.00953   \n",
       "2553  2020-12-20  0.002357  0.00091  0.00184  0.00390  0.00667  0.00953   \n",
       "2554  2020-12-21  0.002449  0.00091  0.00181  0.00388  0.00660  0.00939   \n",
       "\n",
       "          15Y      30Y  \n",
       "0     0.03440  0.03894  \n",
       "1     0.03440  0.03894  \n",
       "2     0.03453  0.03924  \n",
       "3     0.03470  0.03938  \n",
       "4     0.03470  0.03938  \n",
       "...       ...      ...  \n",
       "2550  0.01142  0.01681  \n",
       "2551  0.01159  0.01693  \n",
       "2552  0.01159  0.01693  \n",
       "2553  0.01159  0.01693  \n",
       "2554  0.01142  0.01674  \n",
       "\n",
       "[2555 rows x 9 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Treasury_Rate"
   ]
  },
  {
   "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>Date</th>\n",
       "      <th>Issuer Name</th>\n",
       "      <th>Ticker</th>\n",
       "      <th>Country Code</th>\n",
       "      <th>Country</th>\n",
       "      <th>Debt Security Name</th>\n",
       "      <th>Bid Price USD</th>\n",
       "      <th>Equity Security Name</th>\n",
       "      <th>Equity Price USD</th>\n",
       "      <th>Equity Total Return</th>\n",
       "      <th>Fiscal Date</th>\n",
       "      <th>Total Assets</th>\n",
       "      <th>Total Liabilities</th>\n",
       "      <th>Total Corporate Debt</th>\n",
       "      <th>Total Shareholders Equity</th>\n",
       "      <th>Shares Outstanding</th>\n",
       "      <th>Dividends per Share</th>\n",
       "      <th>Dividends Paid</th>\n",
       "      <th>Dividend Yield</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2014-02-03</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>6.288432</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20131231.0</td>\n",
       "      <td>7.687077e+10</td>\n",
       "      <td>6.857194e+10</td>\n",
       "      <td>5.088787e+10</td>\n",
       "      <td>8.143544e+09</td>\n",
       "      <td>2.773730e+09</td>\n",
       "      <td>0.059952</td>\n",
       "      <td>1.247470e+08</td>\n",
       "      <td>1.131130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>2014-03-17</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>6.105702</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20131231.0</td>\n",
       "      <td>7.687077e+10</td>\n",
       "      <td>6.857194e+10</td>\n",
       "      <td>5.088787e+10</td>\n",
       "      <td>8.143544e+09</td>\n",
       "      <td>2.773730e+09</td>\n",
       "      <td>0.059952</td>\n",
       "      <td>1.247470e+08</td>\n",
       "      <td>1.185034</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>2014-04-17</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>6.585953</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20140331.0</td>\n",
       "      <td>7.986190e+10</td>\n",
       "      <td>7.118488e+10</td>\n",
       "      <td>2.898470e+10</td>\n",
       "      <td>8.533073e+09</td>\n",
       "      <td>2.773730e+09</td>\n",
       "      <td>0.063792</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.109962</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>2014-05-01</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>6.643177</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20140331.0</td>\n",
       "      <td>7.986190e+10</td>\n",
       "      <td>7.118488e+10</td>\n",
       "      <td>2.898470e+10</td>\n",
       "      <td>8.533073e+09</td>\n",
       "      <td>2.773730e+09</td>\n",
       "      <td>0.063792</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.101003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>2014-09-16</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>6.859356</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20140630.0</td>\n",
       "      <td>7.961892e+10</td>\n",
       "      <td>7.058194e+10</td>\n",
       "      <td>2.704320e+10</td>\n",
       "      <td>8.910423e+09</td>\n",
       "      <td>2.773730e+09</td>\n",
       "      <td>0.052671</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.865902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>2014-11-17</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.521833</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20140930.0</td>\n",
       "      <td>7.794321e+10</td>\n",
       "      <td>6.896228e+10</td>\n",
       "      <td>2.575122e+10</td>\n",
       "      <td>8.856185e+09</td>\n",
       "      <td>2.773730e+09</td>\n",
       "      <td>0.069008</td>\n",
       "      <td>4.054155e+07</td>\n",
       "      <td>1.109127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>2014-12-12</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.291779</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20140930.0</td>\n",
       "      <td>7.794321e+10</td>\n",
       "      <td>6.896228e+10</td>\n",
       "      <td>2.575122e+10</td>\n",
       "      <td>8.856185e+09</td>\n",
       "      <td>2.773730e+09</td>\n",
       "      <td>0.069008</td>\n",
       "      <td>4.054155e+07</td>\n",
       "      <td>1.064586</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276</th>\n",
       "      <td>2015-02-02</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.116013</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20141231.0</td>\n",
       "      <td>7.433444e+10</td>\n",
       "      <td>6.587622e+10</td>\n",
       "      <td>2.490938e+10</td>\n",
       "      <td>8.339500e+09</td>\n",
       "      <td>2.769344e+09</td>\n",
       "      <td>0.066080</td>\n",
       "      <td>4.569392e+07</td>\n",
       "      <td>0.898252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>305</th>\n",
       "      <td>2015-03-16</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.627877</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20141231.0</td>\n",
       "      <td>7.433444e+10</td>\n",
       "      <td>6.587622e+10</td>\n",
       "      <td>2.490938e+10</td>\n",
       "      <td>8.339500e+09</td>\n",
       "      <td>2.769344e+09</td>\n",
       "      <td>0.066080</td>\n",
       "      <td>4.569392e+07</td>\n",
       "      <td>0.787121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>318</th>\n",
       "      <td>2015-04-02</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.949733</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20150331.0</td>\n",
       "      <td>7.751563e+10</td>\n",
       "      <td>6.912326e+10</td>\n",
       "      <td>2.751575e+10</td>\n",
       "      <td>8.274305e+09</td>\n",
       "      <td>2.769344e+09</td>\n",
       "      <td>0.065970</td>\n",
       "      <td>4.428197e+07</td>\n",
       "      <td>1.121652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>319</th>\n",
       "      <td>2015-04-03</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.949733</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20150331.0</td>\n",
       "      <td>7.751563e+10</td>\n",
       "      <td>6.912326e+10</td>\n",
       "      <td>2.751575e+10</td>\n",
       "      <td>8.274305e+09</td>\n",
       "      <td>2.769344e+09</td>\n",
       "      <td>0.065970</td>\n",
       "      <td>4.428197e+07</td>\n",
       "      <td>1.121652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>339</th>\n",
       "      <td>2015-05-01</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.628203</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20150331.0</td>\n",
       "      <td>7.751563e+10</td>\n",
       "      <td>6.912326e+10</td>\n",
       "      <td>2.751575e+10</td>\n",
       "      <td>8.274305e+09</td>\n",
       "      <td>2.769344e+09</td>\n",
       "      <td>0.065970</td>\n",
       "      <td>4.428197e+07</td>\n",
       "      <td>1.059442</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>434</th>\n",
       "      <td>2015-09-16</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>4.753384</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20150630.0</td>\n",
       "      <td>7.599611e+10</td>\n",
       "      <td>6.770109e+10</td>\n",
       "      <td>2.707725e+10</td>\n",
       "      <td>8.178842e+09</td>\n",
       "      <td>2.769344e+09</td>\n",
       "      <td>0.077690</td>\n",
       "      <td>4.304494e+07</td>\n",
       "      <td>1.236668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>466</th>\n",
       "      <td>2015-11-02</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.396256</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20150930.0</td>\n",
       "      <td>6.894958e+10</td>\n",
       "      <td>6.103333e+10</td>\n",
       "      <td>2.210989e+10</td>\n",
       "      <td>7.807184e+09</td>\n",
       "      <td>2.769344e+09</td>\n",
       "      <td>0.084560</td>\n",
       "      <td>3.985444e+07</td>\n",
       "      <td>1.611040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>475</th>\n",
       "      <td>2015-11-16</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.352543</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20150930.0</td>\n",
       "      <td>6.894958e+10</td>\n",
       "      <td>6.103333e+10</td>\n",
       "      <td>2.210989e+10</td>\n",
       "      <td>7.807184e+09</td>\n",
       "      <td>2.769344e+09</td>\n",
       "      <td>0.084560</td>\n",
       "      <td>3.985444e+07</td>\n",
       "      <td>1.594548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>526</th>\n",
       "      <td>2016-02-01</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.180309</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20151231.0</td>\n",
       "      <td>6.923054e+10</td>\n",
       "      <td>6.127785e+10</td>\n",
       "      <td>2.132342e+10</td>\n",
       "      <td>7.842674e+09</td>\n",
       "      <td>2.758464e+09</td>\n",
       "      <td>0.166786</td>\n",
       "      <td>4.409615e+07</td>\n",
       "      <td>1.514340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>560</th>\n",
       "      <td>2016-03-21</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.676919</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20151231.0</td>\n",
       "      <td>6.923054e+10</td>\n",
       "      <td>6.127785e+10</td>\n",
       "      <td>2.132342e+10</td>\n",
       "      <td>7.842674e+09</td>\n",
       "      <td>2.758464e+09</td>\n",
       "      <td>0.166786</td>\n",
       "      <td>4.409615e+07</td>\n",
       "      <td>1.451159</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>563</th>\n",
       "      <td>2016-03-24</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.494446</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20151231.0</td>\n",
       "      <td>6.923054e+10</td>\n",
       "      <td>6.127785e+10</td>\n",
       "      <td>2.132342e+10</td>\n",
       "      <td>7.842674e+09</td>\n",
       "      <td>2.758464e+09</td>\n",
       "      <td>0.166786</td>\n",
       "      <td>4.409615e+07</td>\n",
       "      <td>1.479934</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>685</th>\n",
       "      <td>2016-09-16</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.110094</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20160630.0</td>\n",
       "      <td>6.701126e+10</td>\n",
       "      <td>5.931436e+10</td>\n",
       "      <td>2.003998e+10</td>\n",
       "      <td>7.588271e+09</td>\n",
       "      <td>2.773730e+09</td>\n",
       "      <td>0.116458</td>\n",
       "      <td>6.878325e+07</td>\n",
       "      <td>2.866534</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>717</th>\n",
       "      <td>2016-11-02</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>96.50000</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.622478</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20160930.0</td>\n",
       "      <td>6.281821e+10</td>\n",
       "      <td>5.539917e+10</td>\n",
       "      <td>1.879505e+10</td>\n",
       "      <td>7.313741e+09</td>\n",
       "      <td>2.773730e+09</td>\n",
       "      <td>0.151115</td>\n",
       "      <td>2.423615e+08</td>\n",
       "      <td>2.682882</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>729</th>\n",
       "      <td>2016-11-21</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>91.35000</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>4.458378</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20160930.0</td>\n",
       "      <td>6.281821e+10</td>\n",
       "      <td>5.539917e+10</td>\n",
       "      <td>1.879505e+10</td>\n",
       "      <td>7.313741e+09</td>\n",
       "      <td>2.773730e+09</td>\n",
       "      <td>0.151115</td>\n",
       "      <td>2.423615e+08</td>\n",
       "      <td>3.195946</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>743</th>\n",
       "      <td>2016-12-12</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>92.93500</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>4.957143</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20160930.0</td>\n",
       "      <td>6.281821e+10</td>\n",
       "      <td>5.539917e+10</td>\n",
       "      <td>1.879505e+10</td>\n",
       "      <td>7.313741e+09</td>\n",
       "      <td>2.773730e+09</td>\n",
       "      <td>0.151115</td>\n",
       "      <td>2.423615e+08</td>\n",
       "      <td>2.914700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>780</th>\n",
       "      <td>2017-02-06</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>96.37500</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>4.976156</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20161231.0</td>\n",
       "      <td>6.136082e+10</td>\n",
       "      <td>5.443409e+10</td>\n",
       "      <td>1.850351e+10</td>\n",
       "      <td>6.831833e+09</td>\n",
       "      <td>2.749220e+09</td>\n",
       "      <td>0.256281</td>\n",
       "      <td>2.221727e+04</td>\n",
       "      <td>2.859975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>809</th>\n",
       "      <td>2017-03-20</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>97.69500</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.501255</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20161231.0</td>\n",
       "      <td>6.136082e+10</td>\n",
       "      <td>5.443409e+10</td>\n",
       "      <td>1.850351e+10</td>\n",
       "      <td>6.831833e+09</td>\n",
       "      <td>2.749220e+09</td>\n",
       "      <td>0.256281</td>\n",
       "      <td>2.221727e+04</td>\n",
       "      <td>2.794391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>827</th>\n",
       "      <td>2017-04-13</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>97.63000</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.777407</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20170331.0</td>\n",
       "      <td>6.592196e+10</td>\n",
       "      <td>5.828785e+10</td>\n",
       "      <td>1.971321e+10</td>\n",
       "      <td>7.528259e+09</td>\n",
       "      <td>2.773730e+09</td>\n",
       "      <td>0.280330</td>\n",
       "      <td>1.816670e+08</td>\n",
       "      <td>4.933913</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>838</th>\n",
       "      <td>2017-05-01</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>97.50000</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.795213</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20170331.0</td>\n",
       "      <td>6.592196e+10</td>\n",
       "      <td>5.828785e+10</td>\n",
       "      <td>1.971321e+10</td>\n",
       "      <td>7.528259e+09</td>\n",
       "      <td>2.773730e+09</td>\n",
       "      <td>0.280330</td>\n",
       "      <td>1.816670e+08</td>\n",
       "      <td>4.846058</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>967</th>\n",
       "      <td>2017-11-02</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>101.62500</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.972677</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20170930.0</td>\n",
       "      <td>7.115437e+10</td>\n",
       "      <td>6.328025e+10</td>\n",
       "      <td>2.072365e+10</td>\n",
       "      <td>7.769729e+09</td>\n",
       "      <td>2.773730e+09</td>\n",
       "      <td>0.222819</td>\n",
       "      <td>5.506835e-02</td>\n",
       "      <td>3.563704</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>979</th>\n",
       "      <td>2017-11-20</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>101.52500</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>6.157889</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20170930.0</td>\n",
       "      <td>7.115437e+10</td>\n",
       "      <td>6.328025e+10</td>\n",
       "      <td>2.072365e+10</td>\n",
       "      <td>7.769729e+09</td>\n",
       "      <td>2.773730e+09</td>\n",
       "      <td>0.222819</td>\n",
       "      <td>5.506835e-02</td>\n",
       "      <td>3.453593</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>994</th>\n",
       "      <td>2017-12-12</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>101.37500</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.426882</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20170930.0</td>\n",
       "      <td>7.115437e+10</td>\n",
       "      <td>6.328025e+10</td>\n",
       "      <td>2.072365e+10</td>\n",
       "      <td>7.769729e+09</td>\n",
       "      <td>2.773730e+09</td>\n",
       "      <td>0.222819</td>\n",
       "      <td>5.506835e-02</td>\n",
       "      <td>3.885002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1030</th>\n",
       "      <td>2018-02-05</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>100.75000</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>6.441351</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20171231.0</td>\n",
       "      <td>6.906023e+10</td>\n",
       "      <td>6.151716e+10</td>\n",
       "      <td>1.971946e+10</td>\n",
       "      <td>7.449439e+09</td>\n",
       "      <td>2.753002e+09</td>\n",
       "      <td>0.176218</td>\n",
       "      <td>1.575769e+04</td>\n",
       "      <td>3.381157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1059</th>\n",
       "      <td>2018-03-19</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>98.75000</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>6.162879</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20171231.0</td>\n",
       "      <td>6.906023e+10</td>\n",
       "      <td>6.151716e+10</td>\n",
       "      <td>1.971946e+10</td>\n",
       "      <td>7.449439e+09</td>\n",
       "      <td>2.753002e+09</td>\n",
       "      <td>0.176218</td>\n",
       "      <td>1.575769e+04</td>\n",
       "      <td>3.504443</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1067</th>\n",
       "      <td>2018-03-29</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>97.87500</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>6.088147</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20171231.0</td>\n",
       "      <td>6.906023e+10</td>\n",
       "      <td>6.151716e+10</td>\n",
       "      <td>1.971946e+10</td>\n",
       "      <td>7.449439e+09</td>\n",
       "      <td>2.753002e+09</td>\n",
       "      <td>0.176218</td>\n",
       "      <td>1.575769e+04</td>\n",
       "      <td>3.640988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1089</th>\n",
       "      <td>2018-05-01</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>96.36647</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>6.204337</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20180331.0</td>\n",
       "      <td>7.565108e+10</td>\n",
       "      <td>6.720993e+10</td>\n",
       "      <td>2.165930e+10</td>\n",
       "      <td>8.336166e+09</td>\n",
       "      <td>2.773730e+09</td>\n",
       "      <td>0.188884</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.946325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1218</th>\n",
       "      <td>2018-11-02</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>91.00000</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.919553</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20180930.0</td>\n",
       "      <td>8.456420e+10</td>\n",
       "      <td>7.539479e+10</td>\n",
       "      <td>2.823600e+10</td>\n",
       "      <td>9.057754e+09</td>\n",
       "      <td>2.883457e+09</td>\n",
       "      <td>0.184381</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.904870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1228</th>\n",
       "      <td>2018-11-19</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>85.35000</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>4.833159</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20180930.0</td>\n",
       "      <td>8.456420e+10</td>\n",
       "      <td>7.539479e+10</td>\n",
       "      <td>2.823600e+10</td>\n",
       "      <td>9.057754e+09</td>\n",
       "      <td>2.883457e+09</td>\n",
       "      <td>0.184381</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>3.509558</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1243</th>\n",
       "      <td>2018-12-12</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>88.37500</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>4.522208</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20180930.0</td>\n",
       "      <td>8.456420e+10</td>\n",
       "      <td>7.539479e+10</td>\n",
       "      <td>2.823600e+10</td>\n",
       "      <td>9.057754e+09</td>\n",
       "      <td>2.883457e+09</td>\n",
       "      <td>0.184381</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>3.805928</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1278</th>\n",
       "      <td>2019-02-04</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>93.63000</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.516420</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>8.206421e+10</td>\n",
       "      <td>7.320536e+10</td>\n",
       "      <td>2.761013e+10</td>\n",
       "      <td>8.747902e+09</td>\n",
       "      <td>2.858987e+09</td>\n",
       "      <td>0.281387</td>\n",
       "      <td>-1.180958e+04</td>\n",
       "      <td>3.279549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1307</th>\n",
       "      <td>2019-03-18</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>93.54350</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.273690</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>8.206421e+10</td>\n",
       "      <td>7.320536e+10</td>\n",
       "      <td>2.761013e+10</td>\n",
       "      <td>8.747902e+09</td>\n",
       "      <td>2.858987e+09</td>\n",
       "      <td>0.281387</td>\n",
       "      <td>-1.180958e+04</td>\n",
       "      <td>3.420427</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1330</th>\n",
       "      <td>2019-04-18</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>97.25650</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>6.536820</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20190331.0</td>\n",
       "      <td>8.207118e+10</td>\n",
       "      <td>7.252820e+10</td>\n",
       "      <td>2.621025e+10</td>\n",
       "      <td>9.423196e+09</td>\n",
       "      <td>2.883457e+09</td>\n",
       "      <td>0.285685</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>4.508274</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1338</th>\n",
       "      <td>2019-05-01</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>99.47250</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>6.355343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20190331.0</td>\n",
       "      <td>8.207118e+10</td>\n",
       "      <td>7.252820e+10</td>\n",
       "      <td>2.621025e+10</td>\n",
       "      <td>9.423196e+09</td>\n",
       "      <td>2.883457e+09</td>\n",
       "      <td>0.285685</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>4.624526</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1433</th>\n",
       "      <td>2019-09-16</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>97.67188</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.520671</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20190630.0</td>\n",
       "      <td>8.263306e+10</td>\n",
       "      <td>7.334871e+10</td>\n",
       "      <td>2.755292e+10</td>\n",
       "      <td>9.166727e+09</td>\n",
       "      <td>2.883457e+09</td>\n",
       "      <td>0.288448</td>\n",
       "      <td>8.304305e+08</td>\n",
       "      <td>5.172753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1476</th>\n",
       "      <td>2019-11-18</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>101.59375</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.348240</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20190930.0</td>\n",
       "      <td>8.010973e+10</td>\n",
       "      <td>7.060416e+10</td>\n",
       "      <td>2.546973e+10</td>\n",
       "      <td>9.389664e+09</td>\n",
       "      <td>2.883457e+09</td>\n",
       "      <td>0.280671</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>5.375468</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1493</th>\n",
       "      <td>2019-12-12</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>102.89062</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.570788</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20190930.0</td>\n",
       "      <td>8.010973e+10</td>\n",
       "      <td>7.060416e+10</td>\n",
       "      <td>2.546973e+10</td>\n",
       "      <td>9.389664e+09</td>\n",
       "      <td>2.883457e+09</td>\n",
       "      <td>0.280671</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>5.215104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1527</th>\n",
       "      <td>2020-02-03</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>107.09375</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>6.179108</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20191231.0</td>\n",
       "      <td>8.363609e+10</td>\n",
       "      <td>7.325704e+10</td>\n",
       "      <td>2.534934e+10</td>\n",
       "      <td>1.025826e+10</td>\n",
       "      <td>2.867523e+09</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>3.167655e+03</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1556</th>\n",
       "      <td>2020-03-16</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>95.56250</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>4.015891</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20191231.0</td>\n",
       "      <td>8.363609e+10</td>\n",
       "      <td>7.325704e+10</td>\n",
       "      <td>2.534934e+10</td>\n",
       "      <td>1.025826e+10</td>\n",
       "      <td>2.867523e+09</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>3.167655e+03</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1574</th>\n",
       "      <td>2020-04-09</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>83.46875</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>2.864516</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20200331.0</td>\n",
       "      <td>7.355471e+10</td>\n",
       "      <td>6.513626e+10</td>\n",
       "      <td>2.215501e+10</td>\n",
       "      <td>8.321401e+09</td>\n",
       "      <td>2.883457e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1589</th>\n",
       "      <td>2020-05-01</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>92.06250</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>2.668664</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20200331.0</td>\n",
       "      <td>7.355471e+10</td>\n",
       "      <td>6.513626e+10</td>\n",
       "      <td>2.215501e+10</td>\n",
       "      <td>8.321401e+09</td>\n",
       "      <td>2.883457e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1684</th>\n",
       "      <td>2020-09-16</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>102.37500</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>3.699279</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20200630.0</td>\n",
       "      <td>7.717921e+10</td>\n",
       "      <td>6.816270e+10</td>\n",
       "      <td>2.363337e+10</td>\n",
       "      <td>8.910770e+09</td>\n",
       "      <td>2.883457e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716</th>\n",
       "      <td>2020-11-02</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>101.09375</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>4.412125</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20200930.0</td>\n",
       "      <td>8.132478e+10</td>\n",
       "      <td>7.147819e+10</td>\n",
       "      <td>2.383104e+10</td>\n",
       "      <td>9.723409e+09</td>\n",
       "      <td>2.883457e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1725</th>\n",
       "      <td>2020-11-16</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>103.98438</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.003083</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20200930.0</td>\n",
       "      <td>8.132478e+10</td>\n",
       "      <td>7.147819e+10</td>\n",
       "      <td>2.383104e+10</td>\n",
       "      <td>9.723409e+09</td>\n",
       "      <td>2.883457e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Date Issuer Name  Ticker Country Code Country  \\\n",
       "27    2014-02-03  MX Banorte  BANORT           MX  MEXICO   \n",
       "56    2014-03-17  MX Banorte  BANORT           MX  MEXICO   \n",
       "79    2014-04-17  MX Banorte  BANORT           MX  MEXICO   \n",
       "88    2014-05-01  MX Banorte  BANORT           MX  MEXICO   \n",
       "183   2014-09-16  MX Banorte  BANORT           MX  MEXICO   \n",
       "225   2014-11-17  MX Banorte  BANORT           MX  MEXICO   \n",
       "243   2014-12-12  MX Banorte  BANORT           MX  MEXICO   \n",
       "276   2015-02-02  MX Banorte  BANORT           MX  MEXICO   \n",
       "305   2015-03-16  MX Banorte  BANORT           MX  MEXICO   \n",
       "318   2015-04-02  MX Banorte  BANORT           MX  MEXICO   \n",
       "319   2015-04-03  MX Banorte  BANORT           MX  MEXICO   \n",
       "339   2015-05-01  MX Banorte  BANORT           MX  MEXICO   \n",
       "434   2015-09-16  MX Banorte  BANORT           MX  MEXICO   \n",
       "466   2015-11-02  MX Banorte  BANORT           MX  MEXICO   \n",
       "475   2015-11-16  MX Banorte  BANORT           MX  MEXICO   \n",
       "526   2016-02-01  MX Banorte  BANORT           MX  MEXICO   \n",
       "560   2016-03-21  MX Banorte  BANORT           MX  MEXICO   \n",
       "563   2016-03-24  MX Banorte  BANORT           MX  MEXICO   \n",
       "685   2016-09-16  MX Banorte  BANORT           MX  MEXICO   \n",
       "717   2016-11-02  MX Banorte  BANORT           MX  MEXICO   \n",
       "729   2016-11-21  MX Banorte  BANORT           MX  MEXICO   \n",
       "743   2016-12-12  MX Banorte  BANORT           MX  MEXICO   \n",
       "780   2017-02-06  MX Banorte  BANORT           MX  MEXICO   \n",
       "809   2017-03-20  MX Banorte  BANORT           MX  MEXICO   \n",
       "827   2017-04-13  MX Banorte  BANORT           MX  MEXICO   \n",
       "838   2017-05-01  MX Banorte  BANORT           MX  MEXICO   \n",
       "967   2017-11-02  MX Banorte  BANORT           MX  MEXICO   \n",
       "979   2017-11-20  MX Banorte  BANORT           MX  MEXICO   \n",
       "994   2017-12-12  MX Banorte  BANORT           MX  MEXICO   \n",
       "1030  2018-02-05  MX Banorte  BANORT           MX  MEXICO   \n",
       "1059  2018-03-19  MX Banorte  BANORT           MX  MEXICO   \n",
       "1067  2018-03-29  MX Banorte  BANORT           MX  MEXICO   \n",
       "1089  2018-05-01  MX Banorte  BANORT           MX  MEXICO   \n",
       "1218  2018-11-02  MX Banorte  BANORT           MX  MEXICO   \n",
       "1228  2018-11-19  MX Banorte  BANORT           MX  MEXICO   \n",
       "1243  2018-12-12  MX Banorte  BANORT           MX  MEXICO   \n",
       "1278  2019-02-04  MX Banorte  BANORT           MX  MEXICO   \n",
       "1307  2019-03-18  MX Banorte  BANORT           MX  MEXICO   \n",
       "1330  2019-04-18  MX Banorte  BANORT           MX  MEXICO   \n",
       "1338  2019-05-01  MX Banorte  BANORT           MX  MEXICO   \n",
       "1433  2019-09-16  MX Banorte  BANORT           MX  MEXICO   \n",
       "1476  2019-11-18  MX Banorte  BANORT           MX  MEXICO   \n",
       "1493  2019-12-12  MX Banorte  BANORT           MX  MEXICO   \n",
       "1527  2020-02-03  MX Banorte  BANORT           MX  MEXICO   \n",
       "1556  2020-03-16  MX Banorte  BANORT           MX  MEXICO   \n",
       "1574  2020-04-09  MX Banorte  BANORT           MX  MEXICO   \n",
       "1589  2020-05-01  MX Banorte  BANORT           MX  MEXICO   \n",
       "1684  2020-09-16  MX Banorte  BANORT           MX  MEXICO   \n",
       "1716  2020-11-02  MX Banorte  BANORT           MX  MEXICO   \n",
       "1725  2020-11-16  MX Banorte  BANORT           MX  MEXICO   \n",
       "\n",
       "                             Debt Security Name  Bid Price USD  \\\n",
       "27    MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "56    MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "79    MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "88    MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "183   MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "225   MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "243   MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "276   MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "305   MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "318   MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "319   MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "339   MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "434   MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "466   MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "475   MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "526   MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "560   MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "563   MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "685   MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "717   MX Banorte 5 3/4% due 31 Quoted Price Bid       96.50000   \n",
       "729   MX Banorte 5 3/4% due 31 Quoted Price Bid       91.35000   \n",
       "743   MX Banorte 5 3/4% due 31 Quoted Price Bid       92.93500   \n",
       "780   MX Banorte 5 3/4% due 31 Quoted Price Bid       96.37500   \n",
       "809   MX Banorte 5 3/4% due 31 Quoted Price Bid       97.69500   \n",
       "827   MX Banorte 5 3/4% due 31 Quoted Price Bid       97.63000   \n",
       "838   MX Banorte 5 3/4% due 31 Quoted Price Bid       97.50000   \n",
       "967   MX Banorte 5 3/4% due 31 Quoted Price Bid      101.62500   \n",
       "979   MX Banorte 5 3/4% due 31 Quoted Price Bid      101.52500   \n",
       "994   MX Banorte 5 3/4% due 31 Quoted Price Bid      101.37500   \n",
       "1030  MX Banorte 5 3/4% due 31 Quoted Price Bid      100.75000   \n",
       "1059  MX Banorte 5 3/4% due 31 Quoted Price Bid       98.75000   \n",
       "1067  MX Banorte 5 3/4% due 31 Quoted Price Bid       97.87500   \n",
       "1089  MX Banorte 5 3/4% due 31 Quoted Price Bid       96.36647   \n",
       "1218  MX Banorte 5 3/4% due 31 Quoted Price Bid       91.00000   \n",
       "1228  MX Banorte 5 3/4% due 31 Quoted Price Bid       85.35000   \n",
       "1243  MX Banorte 5 3/4% due 31 Quoted Price Bid       88.37500   \n",
       "1278  MX Banorte 5 3/4% due 31 Quoted Price Bid       93.63000   \n",
       "1307  MX Banorte 5 3/4% due 31 Quoted Price Bid       93.54350   \n",
       "1330  MX Banorte 5 3/4% due 31 Quoted Price Bid       97.25650   \n",
       "1338  MX Banorte 5 3/4% due 31 Quoted Price Bid       99.47250   \n",
       "1433  MX Banorte 5 3/4% due 31 Quoted Price Bid       97.67188   \n",
       "1476  MX Banorte 5 3/4% due 31 Quoted Price Bid      101.59375   \n",
       "1493  MX Banorte 5 3/4% due 31 Quoted Price Bid      102.89062   \n",
       "1527  MX Banorte 5 3/4% due 31 Quoted Price Bid      107.09375   \n",
       "1556  MX Banorte 5 3/4% due 31 Quoted Price Bid       95.56250   \n",
       "1574  MX Banorte 5 3/4% due 31 Quoted Price Bid       83.46875   \n",
       "1589  MX Banorte 5 3/4% due 31 Quoted Price Bid       92.06250   \n",
       "1684  MX Banorte 5 3/4% due 31 Quoted Price Bid      102.37500   \n",
       "1716  MX Banorte 5 3/4% due 31 Quoted Price Bid      101.09375   \n",
       "1725  MX Banorte 5 3/4% due 31 Quoted Price Bid      103.98438   \n",
       "\n",
       "                  Equity Security Name  Equity Price USD  Equity Total Return  \\\n",
       "27    GPO FIN BANORTE COM NPV SERIES O          6.288432                  NaN   \n",
       "56    GPO FIN BANORTE COM NPV SERIES O          6.105702                  NaN   \n",
       "79    GPO FIN BANORTE COM NPV SERIES O          6.585953                  NaN   \n",
       "88    GPO FIN BANORTE COM NPV SERIES O          6.643177                  NaN   \n",
       "183   GPO FIN BANORTE COM NPV SERIES O          6.859356                  NaN   \n",
       "225   GPO FIN BANORTE COM NPV SERIES O          5.521833                  NaN   \n",
       "243   GPO FIN BANORTE COM NPV SERIES O          5.291779                  NaN   \n",
       "276   GPO FIN BANORTE COM NPV SERIES O          5.116013                  NaN   \n",
       "305   GPO FIN BANORTE COM NPV SERIES O          5.627877                  NaN   \n",
       "318   GPO FIN BANORTE COM NPV SERIES O          5.949733                  NaN   \n",
       "319   GPO FIN BANORTE COM NPV SERIES O          5.949733                  NaN   \n",
       "339   GPO FIN BANORTE COM NPV SERIES O          5.628203                  NaN   \n",
       "434   GPO FIN BANORTE COM NPV SERIES O          4.753384                  NaN   \n",
       "466   GPO FIN BANORTE COM NPV SERIES O          5.396256                  NaN   \n",
       "475   GPO FIN BANORTE COM NPV SERIES O          5.352543                  NaN   \n",
       "526   GPO FIN BANORTE COM NPV SERIES O          5.180309                  NaN   \n",
       "560   GPO FIN BANORTE COM NPV SERIES O          5.676919                  NaN   \n",
       "563   GPO FIN BANORTE COM NPV SERIES O          5.494446                  NaN   \n",
       "685   GPO FIN BANORTE COM NPV SERIES O          5.110094                  NaN   \n",
       "717   GPO FIN BANORTE COM NPV SERIES O          5.622478                  NaN   \n",
       "729   GPO FIN BANORTE COM NPV SERIES O          4.458378                  NaN   \n",
       "743   GPO FIN BANORTE COM NPV SERIES O          4.957143                  NaN   \n",
       "780   GPO FIN BANORTE COM NPV SERIES O          4.976156                  NaN   \n",
       "809   GPO FIN BANORTE COM NPV SERIES O          5.501255                  NaN   \n",
       "827   GPO FIN BANORTE COM NPV SERIES O          5.777407                  NaN   \n",
       "838   GPO FIN BANORTE COM NPV SERIES O          5.795213                  NaN   \n",
       "967   GPO FIN BANORTE COM NPV SERIES O          5.972677                  NaN   \n",
       "979   GPO FIN BANORTE COM NPV SERIES O          6.157889                  NaN   \n",
       "994   GPO FIN BANORTE COM NPV SERIES O          5.426882                  NaN   \n",
       "1030  GPO FIN BANORTE COM NPV SERIES O          6.441351                  NaN   \n",
       "1059  GPO FIN BANORTE COM NPV SERIES O          6.162879                  NaN   \n",
       "1067  GPO FIN BANORTE COM NPV SERIES O          6.088147                  NaN   \n",
       "1089  GPO FIN BANORTE COM NPV SERIES O          6.204337                  NaN   \n",
       "1218  GPO FIN BANORTE COM NPV SERIES O          5.919553                  NaN   \n",
       "1228  GPO FIN BANORTE COM NPV SERIES O          4.833159                  NaN   \n",
       "1243  GPO FIN BANORTE COM NPV SERIES O          4.522208                  NaN   \n",
       "1278  GPO FIN BANORTE COM NPV SERIES O          5.516420                  NaN   \n",
       "1307  GPO FIN BANORTE COM NPV SERIES O          5.273690                  NaN   \n",
       "1330  GPO FIN BANORTE COM NPV SERIES O          6.536820                  NaN   \n",
       "1338  GPO FIN BANORTE COM NPV SERIES O          6.355343                  NaN   \n",
       "1433  GPO FIN BANORTE COM NPV SERIES O          5.520671                  NaN   \n",
       "1476  GPO FIN BANORTE COM NPV SERIES O          5.348240                  NaN   \n",
       "1493  GPO FIN BANORTE COM NPV SERIES O          5.570788                  NaN   \n",
       "1527  GPO FIN BANORTE COM NPV SERIES O          6.179108                  NaN   \n",
       "1556  GPO FIN BANORTE COM NPV SERIES O          4.015891                  NaN   \n",
       "1574  GPO FIN BANORTE COM NPV SERIES O          2.864516                  NaN   \n",
       "1589  GPO FIN BANORTE COM NPV SERIES O          2.668664                  NaN   \n",
       "1684  GPO FIN BANORTE COM NPV SERIES O          3.699279                  NaN   \n",
       "1716  GPO FIN BANORTE COM NPV SERIES O          4.412125                  NaN   \n",
       "1725  GPO FIN BANORTE COM NPV SERIES O          5.003083                  NaN   \n",
       "\n",
       "      Fiscal Date  Total Assets  Total Liabilities  Total Corporate Debt  \\\n",
       "27     20131231.0  7.687077e+10       6.857194e+10          5.088787e+10   \n",
       "56     20131231.0  7.687077e+10       6.857194e+10          5.088787e+10   \n",
       "79     20140331.0  7.986190e+10       7.118488e+10          2.898470e+10   \n",
       "88     20140331.0  7.986190e+10       7.118488e+10          2.898470e+10   \n",
       "183    20140630.0  7.961892e+10       7.058194e+10          2.704320e+10   \n",
       "225    20140930.0  7.794321e+10       6.896228e+10          2.575122e+10   \n",
       "243    20140930.0  7.794321e+10       6.896228e+10          2.575122e+10   \n",
       "276    20141231.0  7.433444e+10       6.587622e+10          2.490938e+10   \n",
       "305    20141231.0  7.433444e+10       6.587622e+10          2.490938e+10   \n",
       "318    20150331.0  7.751563e+10       6.912326e+10          2.751575e+10   \n",
       "319    20150331.0  7.751563e+10       6.912326e+10          2.751575e+10   \n",
       "339    20150331.0  7.751563e+10       6.912326e+10          2.751575e+10   \n",
       "434    20150630.0  7.599611e+10       6.770109e+10          2.707725e+10   \n",
       "466    20150930.0  6.894958e+10       6.103333e+10          2.210989e+10   \n",
       "475    20150930.0  6.894958e+10       6.103333e+10          2.210989e+10   \n",
       "526    20151231.0  6.923054e+10       6.127785e+10          2.132342e+10   \n",
       "560    20151231.0  6.923054e+10       6.127785e+10          2.132342e+10   \n",
       "563    20151231.0  6.923054e+10       6.127785e+10          2.132342e+10   \n",
       "685    20160630.0  6.701126e+10       5.931436e+10          2.003998e+10   \n",
       "717    20160930.0  6.281821e+10       5.539917e+10          1.879505e+10   \n",
       "729    20160930.0  6.281821e+10       5.539917e+10          1.879505e+10   \n",
       "743    20160930.0  6.281821e+10       5.539917e+10          1.879505e+10   \n",
       "780    20161231.0  6.136082e+10       5.443409e+10          1.850351e+10   \n",
       "809    20161231.0  6.136082e+10       5.443409e+10          1.850351e+10   \n",
       "827    20170331.0  6.592196e+10       5.828785e+10          1.971321e+10   \n",
       "838    20170331.0  6.592196e+10       5.828785e+10          1.971321e+10   \n",
       "967    20170930.0  7.115437e+10       6.328025e+10          2.072365e+10   \n",
       "979    20170930.0  7.115437e+10       6.328025e+10          2.072365e+10   \n",
       "994    20170930.0  7.115437e+10       6.328025e+10          2.072365e+10   \n",
       "1030   20171231.0  6.906023e+10       6.151716e+10          1.971946e+10   \n",
       "1059   20171231.0  6.906023e+10       6.151716e+10          1.971946e+10   \n",
       "1067   20171231.0  6.906023e+10       6.151716e+10          1.971946e+10   \n",
       "1089   20180331.0  7.565108e+10       6.720993e+10          2.165930e+10   \n",
       "1218   20180930.0  8.456420e+10       7.539479e+10          2.823600e+10   \n",
       "1228   20180930.0  8.456420e+10       7.539479e+10          2.823600e+10   \n",
       "1243   20180930.0  8.456420e+10       7.539479e+10          2.823600e+10   \n",
       "1278   20181231.0  8.206421e+10       7.320536e+10          2.761013e+10   \n",
       "1307   20181231.0  8.206421e+10       7.320536e+10          2.761013e+10   \n",
       "1330   20190331.0  8.207118e+10       7.252820e+10          2.621025e+10   \n",
       "1338   20190331.0  8.207118e+10       7.252820e+10          2.621025e+10   \n",
       "1433   20190630.0  8.263306e+10       7.334871e+10          2.755292e+10   \n",
       "1476   20190930.0  8.010973e+10       7.060416e+10          2.546973e+10   \n",
       "1493   20190930.0  8.010973e+10       7.060416e+10          2.546973e+10   \n",
       "1527   20191231.0  8.363609e+10       7.325704e+10          2.534934e+10   \n",
       "1556   20191231.0  8.363609e+10       7.325704e+10          2.534934e+10   \n",
       "1574   20200331.0  7.355471e+10       6.513626e+10          2.215501e+10   \n",
       "1589   20200331.0  7.355471e+10       6.513626e+10          2.215501e+10   \n",
       "1684   20200630.0  7.717921e+10       6.816270e+10          2.363337e+10   \n",
       "1716   20200930.0  8.132478e+10       7.147819e+10          2.383104e+10   \n",
       "1725   20200930.0  8.132478e+10       7.147819e+10          2.383104e+10   \n",
       "\n",
       "      Total Shareholders Equity  Shares Outstanding  Dividends per Share  \\\n",
       "27                 8.143544e+09        2.773730e+09             0.059952   \n",
       "56                 8.143544e+09        2.773730e+09             0.059952   \n",
       "79                 8.533073e+09        2.773730e+09             0.063792   \n",
       "88                 8.533073e+09        2.773730e+09             0.063792   \n",
       "183                8.910423e+09        2.773730e+09             0.052671   \n",
       "225                8.856185e+09        2.773730e+09             0.069008   \n",
       "243                8.856185e+09        2.773730e+09             0.069008   \n",
       "276                8.339500e+09        2.769344e+09             0.066080   \n",
       "305                8.339500e+09        2.769344e+09             0.066080   \n",
       "318                8.274305e+09        2.769344e+09             0.065970   \n",
       "319                8.274305e+09        2.769344e+09             0.065970   \n",
       "339                8.274305e+09        2.769344e+09             0.065970   \n",
       "434                8.178842e+09        2.769344e+09             0.077690   \n",
       "466                7.807184e+09        2.769344e+09             0.084560   \n",
       "475                7.807184e+09        2.769344e+09             0.084560   \n",
       "526                7.842674e+09        2.758464e+09             0.166786   \n",
       "560                7.842674e+09        2.758464e+09             0.166786   \n",
       "563                7.842674e+09        2.758464e+09             0.166786   \n",
       "685                7.588271e+09        2.773730e+09             0.116458   \n",
       "717                7.313741e+09        2.773730e+09             0.151115   \n",
       "729                7.313741e+09        2.773730e+09             0.151115   \n",
       "743                7.313741e+09        2.773730e+09             0.151115   \n",
       "780                6.831833e+09        2.749220e+09             0.256281   \n",
       "809                6.831833e+09        2.749220e+09             0.256281   \n",
       "827                7.528259e+09        2.773730e+09             0.280330   \n",
       "838                7.528259e+09        2.773730e+09             0.280330   \n",
       "967                7.769729e+09        2.773730e+09             0.222819   \n",
       "979                7.769729e+09        2.773730e+09             0.222819   \n",
       "994                7.769729e+09        2.773730e+09             0.222819   \n",
       "1030               7.449439e+09        2.753002e+09             0.176218   \n",
       "1059               7.449439e+09        2.753002e+09             0.176218   \n",
       "1067               7.449439e+09        2.753002e+09             0.176218   \n",
       "1089               8.336166e+09        2.773730e+09             0.188884   \n",
       "1218               9.057754e+09        2.883457e+09             0.184381   \n",
       "1228               9.057754e+09        2.883457e+09             0.184381   \n",
       "1243               9.057754e+09        2.883457e+09             0.184381   \n",
       "1278               8.747902e+09        2.858987e+09             0.281387   \n",
       "1307               8.747902e+09        2.858987e+09             0.281387   \n",
       "1330               9.423196e+09        2.883457e+09             0.285685   \n",
       "1338               9.423196e+09        2.883457e+09             0.285685   \n",
       "1433               9.166727e+09        2.883457e+09             0.288448   \n",
       "1476               9.389664e+09        2.883457e+09             0.280671   \n",
       "1493               9.389664e+09        2.883457e+09             0.280671   \n",
       "1527               1.025826e+10        2.867523e+09             0.000000   \n",
       "1556               1.025826e+10        2.867523e+09             0.000000   \n",
       "1574               8.321401e+09        2.883457e+09                  NaN   \n",
       "1589               8.321401e+09        2.883457e+09                  NaN   \n",
       "1684               8.910770e+09        2.883457e+09                  NaN   \n",
       "1716               9.723409e+09        2.883457e+09                  NaN   \n",
       "1725               9.723409e+09        2.883457e+09                  NaN   \n",
       "\n",
       "      Dividends Paid  Dividend Yield  \n",
       "27      1.247470e+08        1.131130  \n",
       "56      1.247470e+08        1.185034  \n",
       "79      0.000000e+00        1.109962  \n",
       "88      0.000000e+00        1.101003  \n",
       "183     0.000000e+00        0.865902  \n",
       "225     4.054155e+07        1.109127  \n",
       "243     4.054155e+07        1.064586  \n",
       "276     4.569392e+07        0.898252  \n",
       "305     4.569392e+07        0.787121  \n",
       "318     4.428197e+07        1.121652  \n",
       "319     4.428197e+07        1.121652  \n",
       "339     4.428197e+07        1.059442  \n",
       "434     4.304494e+07        1.236668  \n",
       "466     3.985444e+07        1.611040  \n",
       "475     3.985444e+07        1.594548  \n",
       "526     4.409615e+07        1.514340  \n",
       "560     4.409615e+07        1.451159  \n",
       "563     4.409615e+07        1.479934  \n",
       "685     6.878325e+07        2.866534  \n",
       "717     2.423615e+08        2.682882  \n",
       "729     2.423615e+08        3.195946  \n",
       "743     2.423615e+08        2.914700  \n",
       "780     2.221727e+04        2.859975  \n",
       "809     2.221727e+04        2.794391  \n",
       "827     1.816670e+08        4.933913  \n",
       "838     1.816670e+08        4.846058  \n",
       "967     5.506835e-02        3.563704  \n",
       "979     5.506835e-02        3.453593  \n",
       "994     5.506835e-02        3.885002  \n",
       "1030    1.575769e+04        3.381157  \n",
       "1059    1.575769e+04        3.504443  \n",
       "1067    1.575769e+04        3.640988  \n",
       "1089    0.000000e+00        2.946325  \n",
       "1218    0.000000e+00        2.904870  \n",
       "1228    0.000000e+00        3.509558  \n",
       "1243    0.000000e+00        3.805928  \n",
       "1278   -1.180958e+04        3.279549  \n",
       "1307   -1.180958e+04        3.420427  \n",
       "1330    0.000000e+00        4.508274  \n",
       "1338    0.000000e+00        4.624526  \n",
       "1433    8.304305e+08        5.172753  \n",
       "1476    0.000000e+00        5.375468  \n",
       "1493    0.000000e+00        5.215104  \n",
       "1527    3.167655e+03        0.000000  \n",
       "1556    3.167655e+03        0.000000  \n",
       "1574    0.000000e+00        0.000000  \n",
       "1589    0.000000e+00        0.000000  \n",
       "1684    0.000000e+00        0.000000  \n",
       "1716    0.000000e+00        0.000000  \n",
       "1725    0.000000e+00        0.000000  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check for missing values in Equity Total Return\n",
    "Banorte[Banorte['Equity Total Return'].isna()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>Issuer Name</th>\n",
       "      <th>Ticker</th>\n",
       "      <th>Country Code</th>\n",
       "      <th>Country</th>\n",
       "      <th>Debt Security Name</th>\n",
       "      <th>Bid Price USD</th>\n",
       "      <th>Equity Security Name</th>\n",
       "      <th>Equity Price USD</th>\n",
       "      <th>Equity Total Return</th>\n",
       "      <th>Fiscal Date</th>\n",
       "      <th>Total Assets</th>\n",
       "      <th>Total Liabilities</th>\n",
       "      <th>Total Corporate Debt</th>\n",
       "      <th>Total Shareholders Equity</th>\n",
       "      <th>Shares Outstanding</th>\n",
       "      <th>Dividends per Share</th>\n",
       "      <th>Dividends Paid</th>\n",
       "      <th>Dividend Yield</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2013-12-23</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>6.994969</td>\n",
       "      <td>0.002093</td>\n",
       "      <td>20130930.0</td>\n",
       "      <td>7.528279e+10</td>\n",
       "      <td>6.597613e+10</td>\n",
       "      <td>2.623357e+10</td>\n",
       "      <td>8.979458e+09</td>\n",
       "      <td>2.312838e+09</td>\n",
       "      <td>0.058638</td>\n",
       "      <td>3.229858e+07</td>\n",
       "      <td>0.821448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2013-12-24</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>6.942352</td>\n",
       "      <td>-0.007522</td>\n",
       "      <td>20130930.0</td>\n",
       "      <td>7.528279e+10</td>\n",
       "      <td>6.597613e+10</td>\n",
       "      <td>2.623357e+10</td>\n",
       "      <td>8.979458e+09</td>\n",
       "      <td>2.312838e+09</td>\n",
       "      <td>0.058638</td>\n",
       "      <td>3.229858e+07</td>\n",
       "      <td>0.825177</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2013-12-26</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>6.881383</td>\n",
       "      <td>-0.004448</td>\n",
       "      <td>20130930.0</td>\n",
       "      <td>7.528279e+10</td>\n",
       "      <td>6.597613e+10</td>\n",
       "      <td>2.623357e+10</td>\n",
       "      <td>8.979458e+09</td>\n",
       "      <td>2.312838e+09</td>\n",
       "      <td>0.058638</td>\n",
       "      <td>3.229858e+07</td>\n",
       "      <td>0.830048</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2013-12-27</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>6.892352</td>\n",
       "      <td>0.001594</td>\n",
       "      <td>20130930.0</td>\n",
       "      <td>7.528279e+10</td>\n",
       "      <td>6.597613e+10</td>\n",
       "      <td>2.623357e+10</td>\n",
       "      <td>8.979458e+09</td>\n",
       "      <td>2.312838e+09</td>\n",
       "      <td>0.058638</td>\n",
       "      <td>3.229858e+07</td>\n",
       "      <td>0.828203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2013-12-30</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>6.940789</td>\n",
       "      <td>0.007028</td>\n",
       "      <td>20130930.0</td>\n",
       "      <td>7.528279e+10</td>\n",
       "      <td>6.597613e+10</td>\n",
       "      <td>2.623357e+10</td>\n",
       "      <td>8.979458e+09</td>\n",
       "      <td>2.312838e+09</td>\n",
       "      <td>0.058638</td>\n",
       "      <td>3.229858e+07</td>\n",
       "      <td>0.821448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1745</th>\n",
       "      <td>2020-12-15</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>107.28125</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.380600</td>\n",
       "      <td>-0.020741</td>\n",
       "      <td>20200930.0</td>\n",
       "      <td>8.132478e+10</td>\n",
       "      <td>7.147819e+10</td>\n",
       "      <td>2.383104e+10</td>\n",
       "      <td>9.723409e+09</td>\n",
       "      <td>2.883457e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1746</th>\n",
       "      <td>2020-12-16</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>107.76000</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.494833</td>\n",
       "      <td>0.021231</td>\n",
       "      <td>20200930.0</td>\n",
       "      <td>8.132478e+10</td>\n",
       "      <td>7.147819e+10</td>\n",
       "      <td>2.383104e+10</td>\n",
       "      <td>9.723409e+09</td>\n",
       "      <td>2.883457e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1747</th>\n",
       "      <td>2020-12-17</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>107.65625</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.794077</td>\n",
       "      <td>0.054459</td>\n",
       "      <td>20200930.0</td>\n",
       "      <td>8.132478e+10</td>\n",
       "      <td>7.147819e+10</td>\n",
       "      <td>2.383104e+10</td>\n",
       "      <td>9.723409e+09</td>\n",
       "      <td>2.883457e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1748</th>\n",
       "      <td>2020-12-18</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>107.68750</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.427956</td>\n",
       "      <td>-0.063189</td>\n",
       "      <td>20200930.0</td>\n",
       "      <td>8.132478e+10</td>\n",
       "      <td>7.147819e+10</td>\n",
       "      <td>2.383104e+10</td>\n",
       "      <td>9.723409e+09</td>\n",
       "      <td>2.883457e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1749</th>\n",
       "      <td>2020-12-21</td>\n",
       "      <td>MX Banorte</td>\n",
       "      <td>BANORT</td>\n",
       "      <td>MX</td>\n",
       "      <td>MEXICO</td>\n",
       "      <td>MX Banorte 5 3/4% due 31 Quoted Price Bid</td>\n",
       "      <td>107.50000</td>\n",
       "      <td>GPO FIN BANORTE COM NPV SERIES O</td>\n",
       "      <td>5.335945</td>\n",
       "      <td>-0.016951</td>\n",
       "      <td>20200930.0</td>\n",
       "      <td>8.132478e+10</td>\n",
       "      <td>7.147819e+10</td>\n",
       "      <td>2.383104e+10</td>\n",
       "      <td>9.723409e+09</td>\n",
       "      <td>2.883457e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1700 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Date Issuer Name  Ticker Country Code Country  \\\n",
       "0     2013-12-23  MX Banorte  BANORT           MX  MEXICO   \n",
       "1     2013-12-24  MX Banorte  BANORT           MX  MEXICO   \n",
       "2     2013-12-26  MX Banorte  BANORT           MX  MEXICO   \n",
       "3     2013-12-27  MX Banorte  BANORT           MX  MEXICO   \n",
       "4     2013-12-30  MX Banorte  BANORT           MX  MEXICO   \n",
       "...          ...         ...     ...          ...     ...   \n",
       "1745  2020-12-15  MX Banorte  BANORT           MX  MEXICO   \n",
       "1746  2020-12-16  MX Banorte  BANORT           MX  MEXICO   \n",
       "1747  2020-12-17  MX Banorte  BANORT           MX  MEXICO   \n",
       "1748  2020-12-18  MX Banorte  BANORT           MX  MEXICO   \n",
       "1749  2020-12-21  MX Banorte  BANORT           MX  MEXICO   \n",
       "\n",
       "                             Debt Security Name  Bid Price USD  \\\n",
       "0     MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "1     MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "2     MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "3     MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "4     MX Banorte 5 3/4% due 31 Quoted Price Bid            NaN   \n",
       "...                                         ...            ...   \n",
       "1745  MX Banorte 5 3/4% due 31 Quoted Price Bid      107.28125   \n",
       "1746  MX Banorte 5 3/4% due 31 Quoted Price Bid      107.76000   \n",
       "1747  MX Banorte 5 3/4% due 31 Quoted Price Bid      107.65625   \n",
       "1748  MX Banorte 5 3/4% due 31 Quoted Price Bid      107.68750   \n",
       "1749  MX Banorte 5 3/4% due 31 Quoted Price Bid      107.50000   \n",
       "\n",
       "                  Equity Security Name  Equity Price USD  Equity Total Return  \\\n",
       "0     GPO FIN BANORTE COM NPV SERIES O          6.994969             0.002093   \n",
       "1     GPO FIN BANORTE COM NPV SERIES O          6.942352            -0.007522   \n",
       "2     GPO FIN BANORTE COM NPV SERIES O          6.881383            -0.004448   \n",
       "3     GPO FIN BANORTE COM NPV SERIES O          6.892352             0.001594   \n",
       "4     GPO FIN BANORTE COM NPV SERIES O          6.940789             0.007028   \n",
       "...                                ...               ...                  ...   \n",
       "1745  GPO FIN BANORTE COM NPV SERIES O          5.380600            -0.020741   \n",
       "1746  GPO FIN BANORTE COM NPV SERIES O          5.494833             0.021231   \n",
       "1747  GPO FIN BANORTE COM NPV SERIES O          5.794077             0.054459   \n",
       "1748  GPO FIN BANORTE COM NPV SERIES O          5.427956            -0.063189   \n",
       "1749  GPO FIN BANORTE COM NPV SERIES O          5.335945            -0.016951   \n",
       "\n",
       "      Fiscal Date  Total Assets  Total Liabilities  Total Corporate Debt  \\\n",
       "0      20130930.0  7.528279e+10       6.597613e+10          2.623357e+10   \n",
       "1      20130930.0  7.528279e+10       6.597613e+10          2.623357e+10   \n",
       "2      20130930.0  7.528279e+10       6.597613e+10          2.623357e+10   \n",
       "3      20130930.0  7.528279e+10       6.597613e+10          2.623357e+10   \n",
       "4      20130930.0  7.528279e+10       6.597613e+10          2.623357e+10   \n",
       "...           ...           ...                ...                   ...   \n",
       "1745   20200930.0  8.132478e+10       7.147819e+10          2.383104e+10   \n",
       "1746   20200930.0  8.132478e+10       7.147819e+10          2.383104e+10   \n",
       "1747   20200930.0  8.132478e+10       7.147819e+10          2.383104e+10   \n",
       "1748   20200930.0  8.132478e+10       7.147819e+10          2.383104e+10   \n",
       "1749   20200930.0  8.132478e+10       7.147819e+10          2.383104e+10   \n",
       "\n",
       "      Total Shareholders Equity  Shares Outstanding  Dividends per Share  \\\n",
       "0                  8.979458e+09        2.312838e+09             0.058638   \n",
       "1                  8.979458e+09        2.312838e+09             0.058638   \n",
       "2                  8.979458e+09        2.312838e+09             0.058638   \n",
       "3                  8.979458e+09        2.312838e+09             0.058638   \n",
       "4                  8.979458e+09        2.312838e+09             0.058638   \n",
       "...                         ...                 ...                  ...   \n",
       "1745               9.723409e+09        2.883457e+09                  NaN   \n",
       "1746               9.723409e+09        2.883457e+09                  NaN   \n",
       "1747               9.723409e+09        2.883457e+09                  NaN   \n",
       "1748               9.723409e+09        2.883457e+09                  NaN   \n",
       "1749               9.723409e+09        2.883457e+09                  NaN   \n",
       "\n",
       "      Dividends Paid  Dividend Yield  \n",
       "0       3.229858e+07        0.821448  \n",
       "1       3.229858e+07        0.825177  \n",
       "2       3.229858e+07        0.830048  \n",
       "3       3.229858e+07        0.828203  \n",
       "4       3.229858e+07        0.821448  \n",
       "...              ...             ...  \n",
       "1745    0.000000e+00        0.000000  \n",
       "1746    0.000000e+00        0.000000  \n",
       "1747    0.000000e+00        0.000000  \n",
       "1748    0.000000e+00        0.000000  \n",
       "1749    0.000000e+00        0.000000  \n",
       "\n",
       "[1700 rows x 19 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## Drop missing values in Equity Total Return\n",
    "\n",
    "Banorte = Banorte.dropna(subset=['Equity Total Return'])\n",
    "Banorte"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1700"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#First, we get the Total MV of Assets\n",
    "\n",
    "##Getting the necessary inputs with the correct data type\n",
    "Total_Debt = pd.to_numeric(Banorte['Total Corporate Debt'], errors = 'coerce').to_numpy()\n",
    "Stock_Price = pd.to_numeric(Banorte['Equity Price USD'], errors = 'coerce').to_numpy()\n",
    "Shares_Outstanding = pd.to_numeric(Banorte['Shares Outstanding'], errors = 'coerce').to_numpy()\n",
    "\n",
    "##Getting the MV of Equity\n",
    "Equity = Stock_Price *  Shares_Outstanding\n",
    "\n",
    "##Getting the MV of Assets\n",
    "MV_Assets = Total_Debt + Equity\n",
    "len(Total_Debt)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "#Second, we get the Assets' Volatility\n",
    "\n",
    "##We calculate the equity volatility\n",
    "Lambda = 0.9075\n",
    "\n",
    "\n",
    "Equity_Returns = pd.to_numeric(Banorte['Equity Total Return'], errors = 'coerce').to_numpy()\n",
    "l = len(Equity_Returns)\n",
    "Equity_Volatility = np.zeros(l)\n",
    "Equity_Volatility[1] = np.sqrt(Equity_Returns[0]**2)\n",
    "\n",
    "\n",
    "#Louccas' old version\n",
    "# for i in range(2,l):\n",
    "#     Equity_Volatility[i] = np.sqrt(Lambda * Equity_Volatility[i-1]**2 + (1 - Lambda) * Equity_Returns[i-1]**2)\n",
    "\n",
    "\n",
    "## Need to fix this\n",
    "## Using EWMA, assume we are using last 252 days (one year)\n",
    "EWMA1 = []\n",
    "n = len(Equity_Returns)-250\n",
    "for i in range(n):\n",
    "    total = 0\n",
    "    for j in range(250):\n",
    "        total = total + (Lambda**(250-j)) * (Equity_Returns[i+j]**2)\n",
    "    EWMA1.append((total*(1-Lambda))**0.5)\n",
    "\n",
    "\n",
    "##Since we used 250 days as the time window, we cannot calculate the volatilities for the first 250 days. \n",
    "##For consistency in list lengths of other variables below, I filled EWMA with 250 NaN in the beginning of the list.\n",
    "\n",
    "EWMA = [np.nan]*250+EWMA1\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[0.01242899 0.01283545 0.01187296 0.01270764 0.01234256 0.01302971\n",
      " 0.01446606 0.01423405 0.01366495 0.0128117  0.01281637 0.01233737\n",
      " 0.01209149 0.0122139  0.01198361 0.01127814 0.01114238 0.01124387\n",
      " 0.01205272]\n"
     ]
    }
   ],
   "source": [
    "##We get the D/E ratio\n",
    "DE_Ratio = Total_Debt / Equity\n",
    "\n",
    "##Finally, we calculate the Asset Volatility\n",
    "#####Asset_Volatility = (1 / (1 + DE_Ratio)) * Equity_Volatility\n",
    "Asset_Volatility = (1 / (1 + DE_Ratio)) * EWMA\n",
    "\n",
    "##Annuliaze Volatility\n",
    "Annual_Volatility = Asset_Volatility*np.sqrt(250)\n",
    "\n",
    "print(Asset_Volatility[-20:-1])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Third, we get the strike price - straightforward\n",
    "Strike_Price = Total_Debt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1700"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(Strike_Price)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Fourth, we get the time to maturity\n",
    "\n",
    "##We get the maturity of the Banorte Bond from the Mexican Maturities File\n",
    "Banorte_Maturity = Mexican_Maturities[Mexican_Maturities['Debt Name'] == 'MX Banorte 5 3/4% due 31 Yield to Mat Bid']\n",
    "Banorte_Maturity = pd.to_datetime(Banorte_Maturity['Maturity'], format = '%Y%m%d').to_numpy()\n",
    "\n",
    "##We get the date of the bond from the intial file\n",
    "Date = pd.to_datetime(Banorte['Date'], format = '%Y/%m/%d').to_numpy()\n",
    "\n",
    "#Finally, we take the time difference between the actual date and Maturity to get the time to expiration\n",
    "Expiration_Time = ( Banorte_Maturity - Date ) / (365 * 24 * 60 * 60 * 10**9)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1700"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Fifth, we get the risk-free rate for the US Yield Curve\n",
    "Treasury_Date = pd.to_datetime(Treasury_Rate['Date'], format = '%Y/%m/%d').to_numpy()\n",
    "# Treasury_Date[0:20]\n",
    "\n",
    "#For a specific trading day of the bond, we get the closest Treasury Date and for this Treasury Date the closest maturity\n",
    "Mat = np.array([0.25, 1, 3, 5, 7, 10, 15, 30])\n",
    "Risk_Free_Rate = []\n",
    "m = len(Date)\n",
    "for i in range(m):\n",
    "    #Specific_Date = Date[i]\n",
    "    #We get the closest day when treasury rates are reported\n",
    "    #should be a list of 2555 entries\n",
    "    \n",
    "    ## some changes here!\n",
    "    day_difference = [abs(Date[i] - x) for x in Treasury_Date]\n",
    "    \n",
    "    #Find the index of that closest bond issuing day \n",
    "    #Need to be fixed \n",
    "    Day_Index = day_difference.index(min(day_difference))\n",
    "    \n",
    "    #We get the closest maturity for the specific date\n",
    "    # should be a list of 8 entries\n",
    "    maturity_difference = [abs(Expiration_Time[i].astype(np.int64) - x) for x in Mat]\n",
    "    \n",
    "    #Find the index of that closest maturity \n",
    "    Maturity_Index = maturity_difference.index(min(maturity_difference))\n",
    "    \n",
    "    Treasury_Specific_Rate = Treasury_Rate.iloc[Day_Index, Maturity_Index]\n",
    "#     print(Treasury_Specific_Rate)\n",
    "    #We get the continuously-compounded rate\n",
    "    Rate = np.log(1 + Treasury_Specific_Rate)\n",
    "    Risk_Free_Rate.append(Rate) \n",
    "\n",
    "len(Risk_Free_Rate)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[0.005136784105152353,\n",
       " 0.0055843782939006634,\n",
       " 0.005524710642700101,\n",
       " 0.005514765688024084,\n",
       " 0.00507708974028272,\n",
       " 0.00507708974028272,\n",
       " 0.005186526687300154,\n",
       " 0.005286004429237438,\n",
       " 0.0055048206344449615,\n",
       " 0.0055843782939006634,\n",
       " 0.00589260445479898,\n",
       " 0.0061411047567629965,\n",
       " 0.006121227004936164,\n",
       " 0.005773302371841829,\n",
       " 0.005494875481960764,\n",
       " 0.005554544913328957,\n",
       " 0.006001952195634335,\n",
       " 0.006419351802183406,\n",
       " 0.006608118214244683,\n",
       " 0.0055048206344449615,\n",
       " 0.0054749848802694975,\n",
       " 0.00594230945562923,\n",
       " 0.006826645342277345,\n",
       " 0.007174203748000453,\n",
       " 0.006379606964038988,\n",
       " 0.006538576839582357,\n",
       " 0.006220611813056201,\n",
       " 0.006389543321668518,\n",
       " 0.006081470315867954,\n",
       " 0.006081470315867954,\n",
       " 0.00631004969602168,\n",
       " 0.0064491593941792685,\n",
       " 0.006469030628581134,\n",
       " 0.006081470315867954,\n",
       " 0.006101348857976239,\n",
       " 0.006826645342277345,\n",
       " 0.006836577258988437,\n",
       " 0.006568380878031968,\n",
       " 0.0069855441737120905,\n",
       " 0.006588249743520312,\n",
       " 0.006588249743520312,\n",
       " 0.00672732074942653,\n",
       " 0.0064789660977090735,\n",
       " 0.00631004969602168,\n",
       " 0.006250425329512961,\n",
       " 0.006379606964038988,\n",
       " 0.0064292877649038205,\n",
       " 0.006568380878031968,\n",
       " 0.006647853971464475,\n",
       " 0.006578315360122507]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Risk_Free_Rate[1650:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "# option pricing function (no dividend)\n",
    "def priceBS(S0, K, T, r, sigma, Type):\n",
    "    d1 = (np.log(S0/K) + (r+0.5*sigma**2)*T) / (sigma*np.sqrt(T))\n",
    "    d2 = (np.log(S0/K) + (r-0.5*sigma**2)*T) / (sigma*np.sqrt(T))\n",
    "    if Type == \"C\":\n",
    "        return S0*stats.norm.cdf(d1,0,1) - K*np.exp(-r*T)*stats.norm.cdf(d2, 0, 1)\n",
    "    else: \n",
    "        return K*np.exp(-r*T)*stats.norm.cdf(-d2, 0, 1) - S0*stats.norm.cdf(-d1,0,1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "## Non-dividend paying \n",
    "simu_asset_price = []\n",
    "for i in range(len(Equity_Returns)):\n",
    "    simu_asset_price.append(Strike_Price[i]-priceBS(MV_Assets[i], Strike_Price[i], int(Expiration_Time[i]), Risk_Free_Rate[i], Annual_Volatility[i], 'P'))\n",
    "# simu_asset_price"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "## Dividend yield \n",
    "Dividend_yield = pd.to_numeric(Banorte['Dividend Yield'], errors = 'coerce').to_numpy()\n",
    "#####Questions on it????\n",
    "Dividend_yield = np.log(1 + Dividend_yield)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "# I put Black Scholes dividend pricing model here. \n",
    "# But I don't feel like this is the model that we need. \n",
    "\n",
    "def priceBS_div(S0, K, T, r, sigma, q, Type):\n",
    "    d1 = (np.log(S0/K) + (r - q + 0.5*sigma**2)*T) / (sigma*np.sqrt(T))\n",
    "    d2 = (np.log(S0/K) + (r - q - 0.5*sigma**2)*T) / (sigma*np.sqrt(T))\n",
    "    if Type == \"C\":\n",
    "        return S0*np.exp(-q*T)*stats.norm.cdf(d1,0,1) - K*np.exp(-r*T)*stats.norm.cdf(d2, 0, 1)\n",
    "    else: \n",
    "        return K*np.exp(-r*T)*stats.norm.cdf(-d2, 0, 1) - S0*np.exp(-q*T)*stats.norm.cdf(-d1,0,1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0.0016536613165938768\n"
     ]
    }
   ],
   "source": [
    "d1 = (np.log(100/95) + (0.01 - 0 + 0.5*0.02**2)*1) / (0.02*np.sqrt(1))\n",
    "d2 = (np.log(100/95) + (0.01 - 0 - 0.5*0.02**2)*1) / (0.02*np.sqrt(1))\n",
    "print(95*np.exp(0)*stats.norm.cdf(-d2, 0, 1) - 100*np.exp(0)*stats.norm.cdf(-d1,0,1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([1.82698253, 1.79644707, 1.76905263, 1.74965765, 1.75022472,\n",
       "       1.78974274, 1.80773679, 1.79531271, 1.79652276, 1.80085026,\n",
       "       1.80627745, 1.8370014 , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "       0.        , 0.        , 0.        , 0.        , 0.        ])"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Dividend_yield[1450:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[21074441872.42282,\n",
       " 21019832544.655907,\n",
       " 20906558283.902596,\n",
       " 20890753066.570263,\n",
       " 20820915215.791664,\n",
       " 20811922516.40288,\n",
       " 20820915306.635017,\n",
       " 20789459135.65368,\n",
       " 20861435240.724842,\n",
       " 20883983493.25057,\n",
       " 20929159796.744648,\n",
       " 20933683316.088493,\n",
       " 1.3229858134755014e-114,\n",
       " 2.248123996342174e-124,\n",
       " 5.988947840291271e-103,\n",
       " 2.2044825356087964e-114,\n",
       " 5.847051096095147e-127,\n",
       " 5.7022156469226686e-117,\n",
       " 1.1967246861931538e-117,\n",
       " 3.812796143456957e-103,\n",
       " 9.202902034027688e-106,\n",
       " 9.736967448953849e-116,\n",
       " 1.4568383334611656e-125,\n",
       " 2.3413692399877412e-137,\n",
       " 4.1109054777766356e-126,\n",
       " 5.353746482851865e-128,\n",
       " 3.584185077986998e-141,\n",
       " 1.568085727941539e-150,\n",
       " 4.272092683257476e-158,\n",
       " 4.8815271694046116e-169,\n",
       " 2.6263078644112116e-176,\n",
       " 6.793344346686992e-186,\n",
       " 1.1766646641075108e-166,\n",
       " 1.3055329119470408e-178,\n",
       " 8.96573309147055e-202,\n",
       " 1.21353521637118e-220,\n",
       " 2.916740695404925e-243,\n",
       " 4.281210536357484e-262,\n",
       " 2.0219969577460094e-235,\n",
       " 1.5738107993443624e-262,\n",
       " 4.4181587591218476e-269,\n",
       " 3.704696128938726e-249,\n",
       " 1.282346303444171e-261,\n",
       " 5.085364969024316e-284,\n",
       " 2.71718203728709e-302,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 3.529361892276544e-219,\n",
       " 4.934602188205243e-240,\n",
       " 2.1063658902516546e-255,\n",
       " 5.982700116069358e-126,\n",
       " 3.119213783371934e-104,\n",
       " 3.282180984790946e-68,\n",
       " 1.4787215715190747e-72,\n",
       " 3.164714281799963e-76,\n",
       " 6.717509054049459e-44,\n",
       " 1.580955751702283e-32,\n",
       " 3.120222378159702e-12,\n",
       " 1.3277063118835345e-14,\n",
       " 4.998936625214399e-13,\n",
       " 9.37153230262045e-10,\n",
       " 9.711492238015052e-09,\n",
       " 0.0003078745566079191,\n",
       " 0.0019182028829042574,\n",
       " 0.023336784112782283,\n",
       " 0.015062072948453409,\n",
       " 0.008055686303313658,\n",
       " 0.013464331020850429,\n",
       " 0.03309661261858032,\n",
       " 0.03570615913603348,\n",
       " 0.9268250425246976,\n",
       " 0.36838117179972585,\n",
       " 0.1939899415516102,\n",
       " 0.8177748585668496,\n",
       " 0.2447804734850969,\n",
       " 0.030190593231416596,\n",
       " 0.024906382882597278,\n",
       " 0.0024618032836254966,\n",
       " 0.0002716231250323928,\n",
       " 4.110892786256953e-05,\n",
       " 2.1017828901534995e-05,\n",
       " 0.000562525632619576,\n",
       " 4.462132487906452e-05,\n",
       " 0.00013721485833768574,\n",
       " 2.581629307319474e-05,\n",
       " 4.324642116497013e-06,\n",
       " 2.356726985974623e-07,\n",
       " 1.7681218429036278e-08,\n",
       " 3.7676540849563987e-10,\n",
       " 3.01839860862249e-11,\n",
       " 8.506507841291834e-12,\n",
       " 1.0795554918627424e-10,\n",
       " 2.359212766661768e-12,\n",
       " 5.179909368572702e-13,\n",
       " 4.670650684486414e-14,\n",
       " 6.612848571620579e-15,\n",
       " 3.0778806016476284e-16,\n",
       " 1.7091430774929217e-10,\n",
       " 7.541251167960767e-12,\n",
       " 2.549424836242619e-11,\n",
       " 1.394156991969472e-10,\n",
       " 2.7067980998114475e-12,\n",
       " 2.7903250258756646e-14,\n",
       " 1.9705837691441162e-14,\n",
       " 1.1472522682875954e-15,\n",
       " 6.964142378384137e-18,\n",
       " 6.234257555475105e-20,\n",
       " 1.1942979970730338e-21,\n",
       " 2.7203884170281893e-21,\n",
       " 2.257738042785674e-22,\n",
       " 1.0387045464910663e-24,\n",
       " 8.135043463863906e-25,\n",
       " 8.328424029397521e-24,\n",
       " 9.929471118221371e-23,\n",
       " 2.579148826138971e-17,\n",
       " 1.4820637683939125e-20,\n",
       " 4.352840126232047e-21,\n",
       " 5.559136399242715e-19,\n",
       " 3.489412615424726e-20,\n",
       " 3.790113064212437e-18,\n",
       " 1.5727692417508457e-10,\n",
       " 7.282534633481545e-11,\n",
       " 1.1335991754364422e-12,\n",
       " 1.7634307103714186e-13,\n",
       " 5.54894865992814e-13,\n",
       " 9.874522405782536e-14,\n",
       " 3.6241904083965795e-13,\n",
       " 3.9065806151594544e-14,\n",
       " 5.66356636009289e-16,\n",
       " 4.431655062925317e-18,\n",
       " 1.5152105461171118e-19,\n",
       " 6.452865088893581e-20,\n",
       " 2.0456744169689848e-22,\n",
       " 5.898981422325132e-25,\n",
       " 2.8570937860038637e-27,\n",
       " 1.1787559949173733e-29,\n",
       " 5.916484680725761e-32,\n",
       " 5.2937809690224606e-36,\n",
       " 7.810560663755345e-39,\n",
       " 4.083006843170175e-44,\n",
       " 1.0071358736708343e-46,\n",
       " 1.0737774057851462e-50,\n",
       " 3.7226899852516394e-55,\n",
       " 9.760764623482077e-58,\n",
       " 1.3712025947130178e-59,\n",
       " 1.3373686860899463e-49,\n",
       " 8.298749801310572e-54,\n",
       " 1.7510798483833476e-52,\n",
       " 2.3163214558937403e-45,\n",
       " 1.4321912344655874e-47,\n",
       " 1.4231661241993573e-49,\n",
       " 2.544892793942434e-53,\n",
       " 7.696311644419761e-43,\n",
       " 1.0051293961481948e-45,\n",
       " 1.6434590777255685e-43,\n",
       " 1.4838151636295054e-43,\n",
       " 7.656613154412151e-46,\n",
       " 2.415877854522773e-41,\n",
       " 5.0930048270114534e-42,\n",
       " 1.2614645302977798e-47,\n",
       " 8.931794913728392e-53,\n",
       " 6.634659098628519e-60,\n",
       " 2.830423135029595e-57,\n",
       " 6.175887909358784e-58,\n",
       " 1.8927121809143693e-63,\n",
       " 4.3124814148736087e-67,\n",
       " 1.8374694843782235e-73,\n",
       " 1.6056260272542876e-78,\n",
       " 4.963075338209399e-86,\n",
       " 9.540723716393088e-92,\n",
       " 1.5989601499800309e-84,\n",
       " 2.9659152056977184e-79,\n",
       " 1.7028817099491075e-85,\n",
       " 3.45531949077539e-95,\n",
       " 2.73920524744794e-103,\n",
       " 1.2633880419077986e-111,\n",
       " 3.198591741389893e-88,\n",
       " 2.699744890571294e-84,\n",
       " 2.0796806761051773e-73,\n",
       " 9.936746673828313e-85,\n",
       " 8.688138396436969e-89,\n",
       " 2.293597918826068e-88,\n",
       " 4.040575179122483e-94,\n",
       " 1.9112627399724327e-89,\n",
       " 5.395051210635856e-100,\n",
       " 8.69472551014491e-74,\n",
       " 4.068917273533588e-82,\n",
       " 1.4152420388862822e-69,\n",
       " 9.84946922138974e-61,\n",
       " 7.198917359967167e-37,\n",
       " 3.484497701655179e-41,\n",
       " 2.7266615975865238e-36,\n",
       " 1.7063157210606957e-40,\n",
       " 4.2965122027703796e-45,\n",
       " 1.0257580180082009e-43,\n",
       " 5.666868382140523e-49,\n",
       " 9.684657858732888e-50,\n",
       " 7.637344638203861e-56,\n",
       " 3.9919578333798406e-61,\n",
       " 1.8149182747461314e-64,\n",
       " 3.9109129754614886e-72,\n",
       " 2.9114211439317074e-74,\n",
       " 2.7639924618000854e-51,\n",
       " 4.957701237040352e-49,\n",
       " 1.4804406017804778e-52,\n",
       " 1.5566187328525727e-57,\n",
       " 4.167411936742705e-62,\n",
       " 3.4135187066388597e-66,\n",
       " 7.035818872902563e-73,\n",
       " 2.7158979586033406e-82,\n",
       " 1.7686139516347075e-78,\n",
       " 2.5479135095159184e-85,\n",
       " 1.1116006014427682e-91,\n",
       " 3.388823625282558e-100,\n",
       " 1.9609117920161172e-107,\n",
       " 1.609239668975582e-84,\n",
       " 9.188704945072803e-92,\n",
       " 1.1982443760950003e-53,\n",
       " 1.2400512328003282e-56,\n",
       " 2.815635990001182e-63,\n",
       " 2.292988816349849e-53,\n",
       " 1.0155005117268015e-56,\n",
       " 9.705667303247342e-36,\n",
       " 1.451742014751838e-36,\n",
       " 4.1860600211685706e-30,\n",
       " 1.359554843905965e-33,\n",
       " 1.2209009029362599e-32,\n",
       " 1.9657016734145906e-34,\n",
       " 2.3102327712894757e-38,\n",
       " 1.007892890664156e-42,\n",
       " 1.5852408885317066e-40,\n",
       " 2.6567420773406166e-44,\n",
       " 3.468403386279406e-35,\n",
       " 3.016679002904033e-35,\n",
       " 2.732241909953258e-35,\n",
       " 1.3733566552536289e-28,\n",
       " 2.3099990089424572e-30,\n",
       " 1.6201671009444884e-33,\n",
       " 2.0730419750543525e-36,\n",
       " 6.048173451320956e-37,\n",
       " 2.75709751625578e-41,\n",
       " 1.7704423298473757e-45,\n",
       " 2.1983613355620033e-42,\n",
       " 6.005721790844816e-44,\n",
       " 4.842062477103708e-49,\n",
       " 3.6356675330981864e-52,\n",
       " 9.373592131536614e-56,\n",
       " 3.1744624001275354e-43,\n",
       " 1.7339289044826255e-32]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Dividend paying \n",
    "simu_liability_price_div = []\n",
    "for i in range(len(Equity_Returns)):\n",
    "    simu_liability_price_div.append(priceBS_div(MV_Assets[i], Strike_Price[i], int(Expiration_Time[i]), Risk_Free_Rate[i], Asset_Volatility[i], Dividend_yield[i], 'P'))\n",
    "simu_liability_price_div[1450:]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "259    6.587622e+10\n",
       "260    6.587622e+10\n",
       "261    6.587622e+10\n",
       "262    6.587622e+10\n",
       "263    6.587622e+10\n",
       "264    6.587622e+10\n",
       "265    6.587622e+10\n",
       "266    6.587622e+10\n",
       "267    6.587622e+10\n",
       "268    6.587622e+10\n",
       "269    6.587622e+10\n",
       "270    6.587622e+10\n",
       "271    6.587622e+10\n",
       "272    6.587622e+10\n",
       "273    6.587622e+10\n",
       "274    6.587622e+10\n",
       "275    6.587622e+10\n",
       "277    6.587622e+10\n",
       "278    6.587622e+10\n",
       "279    6.587622e+10\n",
       "280    6.587622e+10\n",
       "281    6.587622e+10\n",
       "282    6.587622e+10\n",
       "283    6.587622e+10\n",
       "284    6.587622e+10\n",
       "285    6.587622e+10\n",
       "286    6.587622e+10\n",
       "287    6.587622e+10\n",
       "Name: Total Liabilities, dtype: float64"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Banorte['Total Liabilities'][252:280]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.legend.Legend at 0x7ffaa06c3710>"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXsAAAEDCAYAAADUT6SnAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAAthklEQVR4nO3deZgU1fX/8feZYWBAkB1EQQFFZBUREDQSRATcIIgE0V8UN6KERLOQL0YjRM2ikpi4REQl7opbFI0JuO+og4IioKCiDKJsgrLKzNzfH7ea7tl7oGq6Z/rzep5+urbuPl3Tc7r61K17zTmHiIjUblmpDkBERKKnZC8ikgGU7EVEMoCSvYhIBlCyFxHJAEr2IiIZIKXJ3sxmmdlaM1ucxLYDzexdMysws9NLrDvHzJYHt3Oii1hEpGZK9ZH9XcDwJLf9AhgPPJC40MyaAVOBo4B+wFQzaxpeiCIiNV9Kk71z7hVgY+IyMzvYzP5nZgvM7FUzOyzYdqVz7n2gqMTTDAOedc5tdM59AzxL8l8gIiIZoU6qAyjDTOAi59xyMzsK+CcwuILtDwBWJcznB8tERCSQVsnezBoCRwOPmFlscb3URSQiUjukVbLHl5U2Oed6VeExq4FBCfNtgZfCC0lEpOZL9QnaYpxz3wKfmdkYAPMOr+Rhc4GhZtY0ODE7NFgmIiKBVDe9fBB4E+hsZvlmdj5wFnC+mS0CPgRGBtv2NbN8YAxwm5l9COCc2whcDbwT3K4KlomISMDUxbGISO2XVmUcERGJRspO0LZo0cK1b98+VS8vIlIjLViwYL1zrmVVH5eyZN++fXvy8vJS9fIiIjWSmX2+J49TGUdEJAMo2YuIZAAlexGRDKBkLyKSAZTsRUQygJK9iEgGULIXEckASvYiEo6FD8DaZamOQsqhZC8ie2/Oz+GJi+GpS1IdiZQj3fqzF5GaZOOnsGQOvHuPn1+3NLXxSLmU7EVkz734J/jgkYQFBkWFkJWdspCkbCrjiMieKSoqnuiP/Q3s2ARb1qYsJCmfkr2IVF3hLvjT/vH5w06Btn399Ef/gWmNfXlH0oaSvYhU3fqPoWB7fP6M+6HxAX76jZv9/cM/qf64pFxK9iJSdds3xafP/Z+/b9zW33/zWbWHI5VTsheRqtuxyd9PeBkOGuCn6zeFdkfFt6m3b7WHJeVTsheRqvt6CWDQ5MDiyzevjk9n163WkKRiSvYiUrkv5vsrZGO+XQ37tIQGzYpvV7TL3x86HFxh9cUnlVKyF5HKzRrmr5DdvBo+fxN2bIbcxqW3O/Uf0PIwX78vUrJPJ7qoSkQqlpi0b+ganz6gT+ltO5/ob3Mvh6KC6GOTpOnIXkQqVvh92ctj7erLklXHf0ls+iKamKTKlOxFpGKlkr1Bn/PhhKvKf0xWNhTuhL/3gHfvjTQ8SY7KOCJSscLgpGuXEbB/Lzj215U/JishtSx+DHrrAqtUU7IXkYrFjuwPOR6OHJ/cYxKT/bb1oYckVacyjohULJbsq9Ju3hJSyzdB3f72wfDq38KLS6pER/YiUrFYGWdPk/3Ozb5jNIDVC3xrnddvhEUPQN8L4OS/hherlEtH9iKZxDmYdwV8uTD5xxTs8PfZOck/JtY/zkE/KL3un/19ogd45w7/BSCRU7IXySSv3QBv3AQzf5jc9ts3wYwgYVflyH5X0CPmCVfBpDzIquCL4vbBsPM72KgO1KKkZC+SSdYuqdr2D46LTzc7OPnHDfsTjLgZDugNLTrB5BUw+s74+gtfhOOnxuf/3BZu7gO7dlQtPkmakr1ITVdUCFvX+xJNZb58z9/Xb1r+NgXfwx0nwLQm8MUbflmnodDy0ORjatjKN7c0C16vCfQ4HbLr+fk2h8Oxv4Ir1kJOg+B9FJR/AZfsNZ2gFanJvt8aHzHqtNuh548r2HYbbFjhpwsr6Mpgw3LIfzs+f+bDcOiwvY8V4KLXfGdpsTFq69SDi9+AO0+ArevCeQ0pU+0/st+2Eb5a7KeTOfIRqSmKCosPDbjyNX9fuAs+ngs7t/jPfMFO33HZn9okPLaCZP/tmvh0p2HhJXrwvw5adyu+rFkHOObSYEb/o1Gp/Uf2d50Caz+EVt38/RXroI762ZYabse3kDer+LJ6jfz9y9fBK9eV/9hDhsCnL5W/fnPQLv68udCm195EmbxYuUciU+mRvZm1M7MXzWyJmX1oZpeUsY2Z2Y1mtsLM3jez3tGEuwfWflj8/i/tfE1SpCZ7/ip4bmrxZW/eDP/5Nbw9s+zHWBb8+mM44Eh/ZF/eL91Xb/D3bftCTm54MUtKJVPGKQB+7ZzrCvQHfmZmXUtscyLQKbhNAG4NNcq90a5/8fmCHbBmUWpiEQnL14vj079MaGHzzh3xIQP3P6L4SFKDr4BGrePNIMsq5Wzb6I/s920br6tLrVBpsnfOrXHOvRtMfwcsBQ4osdlI4B7nzQeamFkb0kFstJyuI+PLtnydmlhEwrB9k29V0+xguOAFaHwA/GopHHpifJtBv4MJL8GlH8AZD0Lr7nDUxX5ddlC9jV0ZG7P4cbiug58eenXU76JsOq8WmSqdoDWz9sARwFslVh0ArEqYz6f0FwJmNsHM8swsb926ajrzXlToa5Q/vgdOCX6evnt39by2SNi+XQO3H+d/oY64Edoe6Zfvuz+c+RAM/aNP7j/8bfwxh50EF78OdYMmjrFOykoe2T96bnw68eCoWqhmH7Wkk72ZNQQeAy51zn27Jy/mnJvpnOvjnOvTsmXLPXmKPXjRQrDg5+iRwYd5+bzqeW2RMKx5H56b5s813XIUbPzUj/964IDS2x49ySf3ik54xpL9m7fA2qXw7Zfwp7bx9R1+qBJOLZRUaxwzy8En+vudc4+XsclqoF3CfNtgWeoVFcU/uGbQfTR8Hlwo4hwsecLXNpu2T+753r4dvlkJw/4YQbAiZbjtWH+/8AHfqRgGFzy35wk51hfNy3/xt0QTXvZ91qeMyjhRSaY1jgF3Akudc+X1TzoHODtoldMf2OycW1POttWrqKB4D3yN2sB3a+D+MfCHJvDIeLh3VPLP98xvfKuHRKvfha8/DCNakbi5l8P1h8Tnt3ztf6X++qPkD07KctzlZS8/+W+pS/Rqehm5ZMo4xwA/AQab2cLgdpKZXWRmFwXbPAN8CqwAbgcmRhPuHnCFxY+AGrby94mlnMQBlSuyfVN8esfm+PTtx8GtR+9xiCKlbN/kDypiV5XGSjYNmvkWNXujWQeYugn6TfDzdRvBT56APuft3fNKWqu0jOOce41Kzp445xzws7CCClVRYfFRc1qU0b9HQZKdL234JD798nX+xK+6Z5UoxFqMZdWBjoNg5D/hHz3h8HEVPixpZjD8WmjZGQ4eDM06hvO8krZq/hW0BTt9Qo+1NCgp8QQtlN1z35a1/uTX/Ft8B1Elh1578U/w8rXFl715c+lyjkhYYgcgY+6GLqf46d99Ge5rZGX5wUPSiZpeRqbm943zzwHF+/woKfEELZTuua/9sYDzZZ3npsFTl/gj+Nn/z/fJXbCzdKIvS+MDK99GJFkfz/X3derFl2Vl1+JWMqrZR63mJvsNn/hmYxs/qXi7kkf24E9wNWgBJ02Hbj/yy2afFV9/U29Y+hSsegtuKzHIQ5/zKPOD2fSgqr4DkbJ99zW8GLT2Skz2Inuh5pZxbirR/Y5zZZ/RLyr0P1cTNdoPfht8SSx/tvzX2LEZ1i2Nz3cd6S/MGvYn3+/2X4Kj+YOO0c9PCc/2b+LTddQ3jYSj5h7Zl7Ts6bKXl3Vkn6jTCeWvW5rwnJ1PglFBB1M59SG3MfzgV9Cqa9C0U8lewpLwWarKUIA1mZpeRq72JPsta8teXlRYeZ3z4OP9/dG/KL78g4f9/W8/g3EPlu4BcMhUmPim/6C6oqrHLFKWxM+SkqCEpPYk+53flV628nXYvrHiI3uItzduc3jpdQ33822bK2JZSvYSnlhJsOtI2K9namOpbiqHRqZmJvtNCX2unXi9T+Y7S3TXs2Ut3HWSn67syL7zcLj4Td+VwvnPFV93STLdIevIXsIUJLzup2fQkX2mvM/UqXnJfucW+Ht3Pz3hZThqAuTu60fuKdwF6z7y66Z3ij/Gknibrbv6f6x2feHsJ31NPrdJcoM3WJaOSCQ8sc9SMp9bkSTVvNY465bFp/fr4e9zm8A7t8OSJ2HrWjh7TvHHNKzi5eUdB/n+wZOlMo6EKfZZypijeqkONe/QYdvG+HSsPNP+B/5+a3CS9r7Tgoul8HXPPgn9dCer7j7+lgydoJVQxX4lZmKy1y/kqNS8ZB9rMz/mrviykt0NHzrct5HvNNQPWhIbiDkqOrKXMGViGUe/YiJX88o4hwyBaZuLL8ttXHw+1ua+bd/qiUnt7CVMu5O9EqCEp/YcOsQGVu6W0Dd9dQ2tlo4naGMnqqUGyuAyTrr9H9UitSfZT5zvL34amlDS6fjD8rcPWzqVcVa+Drf0g7xZqY5E9kQmlnEkcrXn01R3H3/xU/0m1f/a6XZkv22Dv//gsdTGIXtmd2uc1IYhtUvNq9lXJqcB/OCX0GVE9b1mOp2g3fBJvCfQHZsr3lbSVAaXcSQytS/Zm8GQadX8mmmS7L/fVrw30PIGdJH0ltFlnDT6hVzLZOKnKXzp0s5+yZPF53PqpyYO2TuZeFFVJr3XFFGyD0N1NL1cNBvmXl582ZZ1flnBTli/Ap64qOzHSg2jMo6Er/aVcVIh6jLO99vg30HPnK7ID57yzWdw4xF+Wdu+fgB08NchrAg6cyssiC4miU4mt7NPp4YOtYyO7EMRcRnn+avi0/P/CR/+O57oAVbnxa8zGH0njPynny5Ssq+RdpdxMunfMwO/2KpZJn2aohNG08vCAvjH4TD/1tLrvvvS38c6fnvyZ/F1dXLhjZvg4//6I/z6TeCIs/yALEW79i4mSRGVcSR8SvZhiCX7rz/0tz2x9kP4ZiX8bwpMawwLH4yv+34btOkFF70GnYbBrm1+eb8JcPi4+HbHXBqfzqqjI/uaKpPLOGqNExnV7MMQa41z69F+/uI3oHW3qj3H528Un3/iIugVJPJd2+I9cB79c1g+10//8P9gnxZwzCU+hqbt44/PzoE1i2DF83DI8VV+S5JKmdz0UqKiT1MYzPzA5jG3Hg0v/qlqz/H14tLLPnzCj6H7+ev+Br4752MugXP/5xM9QLMOxRM9wMbP/P19p1UtDkm93ed/MujIPiN/xVQvJfswWBZs+br4spevjU8XFfma/Odv+BG1Slr1Nrx3ny+9dBkBJ033yx85B+b93k/HTsCawQlXwUEDKo5pbUI5afsm2PgpfDyvSm9LUmR3yV4JUMKjZB+GL+bHp8feF5/ess7fP/wTuLo5/OtEmH1W6ZO584PWM73OgrH3Qt8LEtbd4u9Pu6NqMR2Y8GXwxETfeueBMf7LY9kzVXsuqWYZXMZR08vIZOCnKQKdTohPN2wdT7SfvuT7p4n1rw/w2Stwx/F+LF3w5ZbYP/XJf/P3ZnDWo8Vf48CjqhbTGQ/AmQ/76Y/+E1/+xo3w0Dh/EvjuU+HqVrDqHdi6AZ7+pf8VIKmViWWcjHqvqaFkH4YTro5P5zSAM2eDZcPjF8BfDiy9/eoF8NrffGnnxl6w+DHoMBCyE86XJ36B/OK9qsfUoBkcOgzaVfAl8dkrULgT8u70vz7yZpXd9FOq1+7WOKkNQ2oXtcYJgxn830rfXLJ1Nz9/+Bmw8H6/fp9W8fFxY179a/Exbo+fVvp5f7fG1/Hr1N3z2Mbe74/g+54PzQ+GvH9B55OKd62wKKGZZ02rE+/aAX/v4Yem7PnjVEcTkgwu46jpZWSU7MNSvykMmBifj7WOGXSZbw//n1/B8VP9CFKPXwg7v41fGTvod9D2yNLPGUavlQ1bws8SzikcPNjfdxoK65bCvaf5o/uYokJqlFlD/Rfp4xfWnmSfiWWcmnaQUQNl4qFD9eh3oU/0R57rSypj7vJNJDsP9+tiDjkBBv1f9ce3T3PfjPP438eXZeVA4ffVH0tVOedPft87yl9LEJPYf//jE+C+031LqO3fwHdfw7aN/pbuMvqiKomKjuyjUr8pDJpS9rrE8s2gy6onnvL0/xm0ORwOPBquPQgK07SLhaJC/0W0dgn8+2JYX8YYu/eP8S2Z9j8C3p/tl/3rRFg1v/S2AEP+AD+4tGpxFBb4ayrq1Kva46okk8s4EpVKP01mNsvM1ppZGVf9gJkNMrPNZrYwuF0Zfpi1zHdf+ftjf1N2+aY6ZWXFTw5n56Rnfzpb1sE1reGP+8Htg4sn+h/fA1M3+V9Iq97y5ZwXEk6Yl5foAZ6b6lsllew6uiKzhsE1reD9R8pev2lVvMntnsrEMk6Mml5GJplDh7uA4ZVs86pzrldwu6qSbaXfBOh9Ngz8TaojKS67bnqVcd66zSfj6YeU/hLapyVMWgBdR/pyx+l3Qt1Gft2SJ6HevtDn/Pj2gy6DwVf46xU6DYWjfxFf9+bNyce0Os/fP36Bb6pa0t+7+3hj1i6Dt2+vWhLLyDJOJr3X1Ki0jOOce8XM2ldDLJmjRScYcVOqoygtKye9yjhvzSi9rONxcPYTpZfnNobLVvmj/4Id/gT4Sdf70boOHwf7dY9v23OML8e8ebM/im7UJvmYGrWB79b46bxZ/tdZ4wNKb7d1A6xZGO+uolnHKvRRpF4vJXxhFQUHmNkiM/uvmZXbA5iZTTCzPDPLW7duL3/qSviy0+wEbeeT/H2nob4Z6rTNZSf6GDM4979+uttpkJXtm2QmJvqY7DpwyfvQ+WR/bUSyGrXxA8RcHHRc99gFvunnc3+And/Ft7u+Y/F+ib58158sLmnTF/DR/4of+WsMWolAGCdo3wUOcs5tMbOTgCeATmVt6JybCcwE6NOnj/6q6aZ+E1j8OHwQ1KN7jIHh1/qWO9Vpy1pfhinYAQ2aw1nl1MfLckBv/6WQjCbt/C+CqnzBFRX4X0CtuvrrJ74Ikv5rf4vvt0RH/ATeuxdeuMbf9usBP33Vr3v5Ongp6DAvpwGMfxoOOFJj0Eok9vrQwTn3rXNuSzD9DJBjZi32OjKpfu2PLd575weP+CPURbPDfZ38PNjwSenly54JavSd4I+t4Z07YNuGcF+7pDr1/JdKsooK/S8GMzg56LDuuCv8/eZV/otgyhdw6WKYsgpGljgf8NUHsG4ZvDo9nujBd2N9++ASZTQlQAnPXid7M9vPzH8tm1m/4Dkj/g+VSBx8XHx6yLT49PsPhfs6dxwPN/WOz3/0P3jpWt9nT3WrUw8KqnpkH/wg7joSLsuHH072TVgBupzqfy00aQe5+/pll38NV26Ei4Juqv/Z3x/lA5z/LPxyCdSp7+evbgHfb/XTmVjGUWucyFRaxjGzB4FBQAszywemAjkAzrkZwOnAxWZWAGwHznBOf7EaqcMg3069xxjYvzfs2u6PrhNr0Xtr5Wvx6TtOgFEz4MmJ8SP4DgMht4nvG2jOz8N73fLs+BZ2bobPXoUOx1a+fdGueLIHqBe0ADrhD76zusNOKf2YnFx/v1936Dk2fg3AiJuhXT8//bsv4ZZ+sGE5PBW0FFJpQ0KUTGucCg+3nHM3A1VouyZpKysLTv5rfP643/mSw9pl4Tz/U5fCgn/F5/PfLn6Ef/QvYGhCG/l9WsZ7B43KYSfDogfg7lPgnKf8l01Figr8ieySsnP8kX5lTpsJJ17rf000ah1fnpUFP3sb/to53o9Sg2bJv48aT19sUcvA34lSJfX2Ld4Nwd5ITPSDryi+7rx5xRM9QOcTfTPJKHU5JT52792n+pJSRWI1+71Rv2nxRB+TlQWXfuCHm7zoNb+dSEiU7KViDZrB9o1lNxus8nMF5+3P/S8MnAyTP/GtULqOrHp//WH64f/Fm3k+OLbihJ9Ys49CTq7/RbVfj+heI62pAhwVJXupWJMDfdPELV+F8GTOnxM4KBiYfZ8WvuVKVUfhClvdBnDa7fErcB8cW/5J28Jd0Sb7TKXzE5FTspeKNTnI3z8YQkuZgu8hu0QHYtk5e9dff1jqNYTf5cOhQc8gb9/mf818+yXkL4Ct630Pm9s3ZmYrGanxdIgiFWt+sL9fsxDuHOovcMptvGfPVbiz7JOb6WT4n+Hj/8G8K/ytLPuW0T2ChEMN+SKjQxSpWLOOcOiJfnrVW36YxcpOYpbFOV8OirRr4BA07RCv35fnqJ9WTywZRWWcqOnIXip3yg3wt//G51+7wQ/Ckr8AmneENe9Dm56+9ci3X/ouDpbMAVx89KjYlaHpfmRvBuMehPXL4eY+ftmEl3zHZjm5vq/8nPopDbE8u3btIj8/nx07qnBFcLrI6gzDHoYvv4WvlqY6mrSQm5tL27ZtyckJ539GyV4qt28b39/MtKB889UH/nbH4Pg29RrD5OXwty7+KtKlT/nlPYKmk68GXQsUFlRf3HujRadgDODs9P81EsjPz6dRo0a0b98eq2knPLdtgE3Z0OrQGrO/o+ScY8OGDeTn59OhQ4dQnlNlHEneZath4G9h11aY8YPi63ZuhluDVjaxRA/w5Xu+ff3L1/r59R9XT6xhqNugRiWeHTt20Lx585qX6KUUM6N58+ah/kpTspfk1WsYH7A8JmcfaB20Cd+wovRjHksY5KNVN9/HvERGib72CPtvqTKOVM2B/WH0nX6w8kb7+WVb1vqmmV99AGc+5Hu0POhoyH8Hnrok/tiJb6QmZqkx2h9yKHl5C2jRYu86zm3fvj15eXl7/Ty1iZK9VI0Z9Di9+LKGreDC5+PzsaP/5ofEk/34/1RPfJIWnHM458jKUvEgXegvIdGpU88PCD7wt3DQMamORiK2cuVKOnfuzNlnn0337t1ZtWoV119/PX379qVnz55MnTp197Y/+tGPOPLII+nWrRszZ86s8HlnzJjB5MmTd8/fddddTJo0KannWblyJd27x0cqmz59OtOmTQPgk08+Yfjw4Rx55JEce+yxLFsWUod/aUpH9hKtriOT6w1SQvWHpz5kyZffhvqcXfffl6mnljvqKADLly/n7rvvpn///sybN4/ly5fz9ttv45xjxIgRvPLKKwwcOJBZs2bRrFkztm/fTt++fRl94nE0L6d/udGjRzNgwACuv96f75k9ezaXX345QOnnGT2a5s2TG1ltwoQJzJgxg06dOvHWW28xceJEXnjhheR3SA2jZC8ioTnooIPo378/APPmzWPevHkcccQRAGzZsoXly5czcOBAbrzxRv79738DsGrVKpZ/8inND21V5nO2bNmSjh07Mn/+fDp16sSyZcs45hj/S7HU8yxfnlSy37JlC2+88QZjxsR7Vd25c+eev/EaQMlepBaq7Ag8Kvvss8/uaeccl112GT/9afErjl966SWee+453nzzTRo0aMCgQYMqbWJ4xhln8PDDD3PYYYcxatQozCyp56lTpw5FCT22xtYXFRXRpEkTFi5cuJfvuOZQzV5EIjFs2DBmzZrFli1+AJrVq1ezdu1aNm/eTNOmTWnQoAHLli1j/vz5VNZdwqhRo3jyySd58MEHOeOMMwDKeZ7iWrduzdq1a9mwYQM7d+7k6aefBmDfffelQ4cOPPKIHyTeOceiRYtCfPfpR8leRCIxdOhQzjzzTAYMGECPHj04/fTT+e677xg+fDgFBQV06dKFKVOm7C77VKRp06Z06dKFzz//nH79/FCOyTxPTk4OV155Jf369eOEE07gsMMO273u/vvv58477+Twww+nW7duPPnkk+G9+TRkqRoutk+fPi4vLy8lry1SGy1dupQuXbqkOow9s20jbPocWnWBOrmpjiZtlPU3NbMFzrk+VX0uHdmLiGQAJXsRkQygZC8ikgGU7EVEMoCSvYhIBlCyFxHJAEr2IpISd911F19++eXu+Qt+cxVLPtz7IQlXrlzJAw88UOXHjR8/nkcffXSvXz+s5wmbkr2IpETJZH/H9Cvp2nXvrxPY02Rf2ynZi0ho7rvvPvr160evXr346U9/SmFhIYWFhYwfP57u3bvTo0cPbrjhBh599FHy8vI466yz6NWrF9u3b2fQ6ReSt2ABAA0bNmTy5Ml069aNIUOG8PbbbzNo0CA6duzInDlzAJ/Ujz32WHr37k3v3r154w0/OM6UKVN49dVX6dWrFzfccAOFhYVMnjx5d1fLt912G+C7SJg0aRKdO3dmyJAhrF27ttT7WbZs2e4rdmOv2aOHH5ntqquuom/fvnTv3p0JEyZQ1gWq7du3Z/369QDk5eUxaNAgALZu3cp5551Hv379OOKII6rl6l11hCZSG/13ih85LEz79YAT/1Lu6qVLlzJ79mxef/11cnJymDhxIvfffz/dunVj9erVLF68GIBNmzbRpEkTbr75ZqZPn06fPn38FbQJtm7dyuDBg7n++usZNWoUV1xxBc8++yxLlizhnHPOYcSIEbRq1Ypnn32W3Nxcli9fzrhx48jLy+Mvf/kL06dP390PzsyZM2ncuDHvvPMOO3fu5JhjjmHo0KG89957fPTRRyxZsoSvv/6arl27ct555xWL47DDDuP777/ns88+o0OHDsyePZuxY8cCMGnSJK688koAfvKTn/D0009z6qmnJrUr//jHPzJ48GBmzZrFpk2b6NevH0OGDCnWkVzYlOxFJBTPP/88CxYsoG/fvgBs376dVq1aceqpp/Lpp5/y85//nJNPPpmhQ4dW+lx169Zl+PDhAPTo0YN69eqRk5NDjx49WLlyJQC7du1i0qRJLFy4kOzsbD7+uOzB7OfNm8f777+/u46+efNmli9fziuvvMK4cePIzs5m//33Z/DgwWU+/sc//jGzZ89mypQpzJ49m9mzZwPw4osvct1117Ft2zY2btxIt27dkk728+bNY86cOUyfPh3wvXF+8cUXkXZ3oWQvUhtVcAQeFecc55xzDn/+859LrVu0aBFz585lxowZPPzww8yaNavC58rJydk94HZWVhb16tXbPV1QUADADTfcQOvWrVm0aBFFRUXk5pbdp45zjptuuolhw4YVW/7MM88k9b7Gjh3LmDFjOO200zAzOnXqxI4dO5g4cSJ5eXm0a9eOadOmldlNc2IXy4nrnXM89thjdO7cOakYwqCavYiE4vjjj+fRRx/dXfveuHEjn3/+OevXr6eoqIjRo0dzzTXX8O677wLQqFEjvvvuuz1+vc2bN9OmTRuysrK49957KSwsLPN5hw0bxq233squXbsA+Pjjj9m6dSsDBw5k9uzZFBYWsmbNGl588cUyX+fggw8mOzubq6++encJJ5a4W7RowZYtW8ptfdO+fXsWBOchHnvssWIx3XTTTbvr/O+9994e74dk6cheRELRtWtXrrnmGoYOHUpRURE5OTnccsst1K9fn3PPPXf3EW7syH/8+PFcdNFF1K9fnzefr/qA9BMnTmT06NHcc889DB8+fHe9u2fPnmRnZ3P44Yczfvx4LrnkElauXEnv3r1xztGyZUueeOIJRo0axQsvvEDXrl058MADGTBgQLmvNXbsWCZPnsxnn30GQJMmTbjwwgvp3r07++233+7SVUlTp07l/PPP5/e///3uk7MAv//977n00kvp2bMnRUVFdOjQYfc5hqhU2sWxmc0CTgHWOue6l7HegH8AJwHbgPHOuXcre2F1cSwSrlrRxXHLLpCjLo5jqruL47uA4RWsPxHoFNwmALdWNQgREYlWpcneOfcKsLGCTUYC9zhvPtDEzNqEFaCIiOy9ME7QHgCsSpjPD5aVYmYTzCzPzPLWrVsXwkuLSK1gFY9BK3uvWlvjOOdmOuf6OOf6tGzZsjpfWiQjpGqYUQlf2H/LMJL9aqBdwnzbYJmIVKPc3Fw2bNhQwxN+TY49PM45NmzYUO61A3sijKaXc4BJZvYQcBSw2Tm3JoTnFZEqaNu2Lfn5+dTIEun322DbetiYDdk5qY4mLeTm5tK2bdvQnq/SZG9mDwKDgBZmlg9MBXIAnHMzgGfwzS5X4JtenhtadCKStJycHDp06JDqMPbM4sdh7rkw8S1odViqo6mVKk32zrlxlax3wM9Ci0hEREKn7hJEJI2oZh8VJXsRST01vYyckr2ISAZQsheR9FGjm42mNyV7EUkDKuNETcleRCQDKNmLSBpRGScqSvYiIhlAyV5EUk9NLyOnZC8ikgGU7EUkfajpZWSU7EUkDaiMEzUlexGRDKBkLyJpRGWcqCjZi4hkACV7EUk9Nb2MnJK9iEgGULIXkfShppeRUbIXkTSgMk7UlOxFRDKAkr2IpBGVcaKiZC8iqafWOJFTshcRyQBK9iKSPtQaJzJK9iIiGUDJXkTSgGr2UVOyFxHJAEr2IpJGVLOPipK9iKSeml5GTsleRCQDKNmLSPpQ08vIKNmLiGQAJXsRSQOq2UctqWRvZsPN7CMzW2FmU8pYP97M1pnZwuB2QfihiojInqpT2QZmlg3cApwA5APvmNkc59ySEpvOds5NiiBGEckYqtlHJZkj+37ACufcp86574GHgJHRhiUiGUVNLyOXTLI/AFiVMJ8fLCtptJm9b2aPmlm7UKITEZFQhHWC9imgvXOuJ/AscHdZG5nZBDPLM7O8devWhfTSIlJrqIoTmWSS/Wog8Ui9bbBsN+fcBufczmD2DuDIsp7IOTfTOdfHOdenZcuWexKviNRKKuNELZlk/w7Qycw6mFld4AxgTuIGZtYmYXYEsDS8EEVEZG9V2hrHOVdgZpOAuUA2MMs596GZXQXkOefmAL8wsxFAAbARGB9hzCJSa6mOE5VKkz2Ac+4Z4JkSy65MmL4MuCzc0EREJCy6glZEUk9NLyOnZC8ikgGU7EUkfajXy8go2YtIGlAZJ2pK9iIiGUDJXkTSiMo4UVGyFxHJAEr2IpJ6KtlHTsleRNKHWuNERsleRCQDKNmLSBpQHSdqSvYiIhlAyV5E0ohq9lFRshcRyQBK9iKSeur1MnJK9iKSPtT0MjJK9iIiGUDJXkTSgMo4UVOyFxHJAEr2IpJGVLOPipK9iKSeWuNETsleRCQDKNmLSPpQ08vIKNmLiGQAJXsRSQOq2UdNyV5E0ojKOFFRshcRyQBK9iKSemp6GTklexGRDKBkLyLpQ00vI6NkLyKSAZTsRSQNqGYfNSV7EUkjKuNERcleRCQDJJXszWy4mX1kZivMbEoZ6+uZ2exg/Vtm1j70SEWk9lLTy8hVmuzNLBu4BTgR6AqMM7OuJTY7H/jGOXcIcANwbdiBiojInquTxDb9gBXOuU8BzOwhYCSwJGGbkcC0YPpR4GYzM+fUjqomG/73Vygs0p9QotezYDF/Bb6+5zy2W26qw9ljd9X7f7yeM6DS7cb2bccFx3ashojikkn2BwCrEubzgaPK28Y5V2Bmm4HmwPrEjcxsAjAB4MADD9zDkKW6dGrdiMKiolSHIRnAFfbgjfXDyS3alupQ9kqTxi3o1KBhpdu1aFivGqIpLplkHxrn3ExgJkCfPn10yJjmbhp3RKpDkIwyMNUB7LXeqQ6gAsmcoF0NtEuYbxssK3MbM6sDNAY2hBGgiIjsvWSS/TtAJzPrYGZ1gTOAOSW2mQOcE0yfDryger2ISPqotIwT1OAnAXOBbGCWc+5DM7sKyHPOzQHuBO41sxXARvwXgoiIpImkavbOuWeAZ0osuzJhegcwJtzQREQkLLqCVkQkAyjZi4hkACV7EZEMoGQvIpIBLFUtJM1sHfB5icUtKHHVbRpK9xjTPT5QjGFI9/hAMYahrPgOcs61rOoTpSzZl8XM8pxzfVIdR0XSPcZ0jw8UYxjSPT5QjGEIMz6VcUREMoCSvYhIBki3ZD8z1QEkId1jTPf4QDGGId3jA8UYhtDiS6uavYiIRCPdjuxFRCQCSvYiIhmgWpO9mbUzsxfNbImZfWhmlwTLm5nZs2a2PLhvGiw3M7sxGMj8fTOrlrEBzCzbzN4zs6eD+Q7BQOorgoHV6wbLUzLQupk1MbNHzWyZmS01swHptA/N7JfB33exmT1oZrmp3odmNsvM1prZ4oRlVd5nZnZOsP1yMzunrNcKOcbrg7/z+2b2bzNrkrDusiDGj8xsWMLy4cGyFWY2Jcr4Etb92sycmbUI5tNmHwbLfx7sxw/N7LqE5dW6D8uL0cx6mdl8M1toZnlm1i9YHt5+dM5V2w1oA/QOphsBH+MHMb8OmBIsnwJcG0yfBPwXMKA/8FY1xfkr4AHg6WD+YeCMYHoGcHEwPRGYEUyfAcyupvjuBi4IpusCTdJlH+KHqPwMqJ+w78aneh/ih0HqDSxOWFalfQY0Az4N7psG000jjnEoUCeYvjYhxq7AIqAe0AH4BN8FeXYw3TH4bCwCukYVX7C8Hb4L9M+BFmm4D48DngPqBfOtUrUPK4hxHnBiwr57Kez9GNk/fZJv+kngBOAjoE2wrA3wUTB9GzAuYfvd20UYU1vgeWAw8HSwk9cn/MMNAOYG03OBAcF0nWA7izi+xvhkaiWWp8U+JD4ecbNgnzwNDEuHfQi0L/EPVqV9BowDbktYXmy7KGIssW4UcH8wfRlwWcK6ucF+3b1vy9ouiviAR4HDgZXEk33a7EP8gcaQMrZLyT4sJ8a5wNhgehzwQNj7MWU1++Dn+hHAW0Br59yaYNVXQOtguqzBzg+IOLS/A78FYiNtNwc2OecKyoih2EDrQGyg9Sh1ANYB/zJfarrDzPYhTfahc241MB34AliD3ycLSK99GFPVfZaKz2Oi8/BHeVQQS7XGaGYjgdXOuUUlVqVFfIFDgWODMuHLZtY3DWO8FLjezFbh/38uCzvGlCR7M2sIPAZc6pz7NnGd819TKWkPamanAGudcwtS8fpJqoP/CXirc+4IYCu+BLFbivdhU2Ak/ktpf2AfYHgqYqmKVO6zZJjZ5UABcH+qY4kxswbA74ArK9s2xergf2n2ByYDD5uZpTakUi4Gfumcawf8Ej/6X6iqPdmbWQ4+0d/vnHs8WPy1mbUJ1rcB1gbLkxnsPEzHACPMbCXwEL6U8w+gifmB1EvGkIqB1vOBfOfcW8H8o/jkny77cAjwmXNunXNuF/A4fr+m0z6Mqeo+q+59SRDbeOAU4KzgSyldYjwY/6W+KPifaQu8a2b7pUl8MfnA4857G/+rvUWaxXgO/n8F4BGgXzAdWozV3RrH8N9YS51zf0tYlThg+Tn4Wn5s+dnBGen+wOaEn92hc85d5pxr65xrjz9Z+IJz7izgRfxA6mXFV60DrTvnvgJWmVnnYNHxwBLSZB/iyzf9zaxB8PeOxZc2+zBBVffZXGComTUNfsEMDZZFxsyG48uKI5xz20rEfob51kwdgE7A28A7QCfzrZ/q4j/Hc6KIzTn3gXOulXOuffA/k49vgPEVabQPgSfwJ2kxs0PxJ13Xkwb7MMGXwA+D6cHA8mA6vP0Y5kmHJE5K/AD/U/l9YGFwOwlfo30+eIPPAc2C7Q24BX9m/AOgTzXGOoh4a5yO+A/BCvy3buysfm4wvyJY37GaYusF5AX78Qn82fi02YfAH4BlwGLgXnxrh5TuQ+BB/DmEXfikdP6e7DN83XxFcDu3GmJcga/Nxv5fZiRsf3kQ40cELTmC5SfhW7p9AlweZXwl1q8kfoI2nfZhXeC+4PP4LjA4Vfuwghh/gD+3tQh/HvPIsPejuksQEckAuoJWRCQDKNmLiGQAJXsRkQygZC8ikgGU7EVEMoCSvYhIBlCyFxHJAP8f8BCm0hQtAnAAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.plot(Banorte['Bid Price USD'], label = \"real value\")\n",
    "plt.plot(simu_liability_price_div, label = \"estimated value\")\n",
    "plt.legend()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}