{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "a5688603",
   "metadata": {},
   "source": [
    "### Three ways to run deal "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "2e646c1c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<pre style=\"white-space:pre;overflow-x:auto;line-height:normal;font-family:Menlo,'DejaVu Sans Mono',consolas,'Courier New',monospace\">Connecting engine server -&gt; <span style=\"color: #0000ff; text-decoration-color: #0000ff; text-decoration: underline\">https://absbox.org/api/dev</span>\n",
       "</pre>\n"
      ],
      "text/plain": [
       "Connecting engine server -> \u001b[4;94mhttps://absbox.org/api/dev\u001b[0m\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/xiaoyu/repo/AbsBox/lib/python3.13/site-packages/urllib3/connectionpool.py:1097: InsecureRequestWarning: Unverified HTTPS request is being made to host 'absbox.org'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#tls-warnings\n",
      "  warnings.warn(\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<pre style=\"white-space:pre;overflow-x:auto;line-height:normal;font-family:Menlo,'DejaVu Sans Mono',consolas,'Courier New',monospace\">✅Connected, local li<span style=\"color: #00ff00; text-decoration-color: #00ff00; font-weight: bold\">b:0</span>.<span style=\"color: #008080; text-decoration-color: #008080; font-weight: bold\">46.5</span>, server:<span style=\"color: #008080; text-decoration-color: #008080; font-weight: bold\">0.50</span>.<span style=\"color: #008080; text-decoration-color: #008080; font-weight: bold\">1</span>\n",
       "</pre>\n"
      ],
      "text/plain": [
       "✅Connected, local li\u001b[1;92mb:0\u001b[0m.\u001b[1;36m46.5\u001b[0m, server:\u001b[1;36m0.50\u001b[0m.\u001b[1;36m1\u001b[0m\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "from absbox import API,EnginePath\n",
    "\n",
    "localAPI = API(EnginePath.DEV, lang='english', check=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "64b56f59",
   "metadata": {},
   "source": [
    "#### Single Run"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "6db2f452",
   "metadata": {},
   "outputs": [],
   "source": [
    "from absbox import examples"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "c7dc2e51",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/xiaoyu/repo/AbsBox/lib/python3.13/site-packages/urllib3/connectionpool.py:1097: InsecureRequestWarning: Unverified HTTPS request is being made to host 'absbox.org'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#tls-warnings\n",
      "  warnings.warn(\n"
     ]
    }
   ],
   "source": [
    "myAssumption = (\"Pool\",(\"Mortgage\",{\"CDR\":0.01},None,None,None)\n",
    "                                ,None\n",
    "                                ,None)\n",
    "\n",
    "\n",
    "r = localAPI.run(examples.test01\n",
    "                ,poolAssump=myAssumption\n",
    "                ,read=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "751051de",
   "metadata": {},
   "source": [
    "the result `r` returned by API function `run()`."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ea339b21",
   "metadata": {},
   "source": [
    "#### Scenario Sensitivity Run"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1a0b8986",
   "metadata": {},
   "source": [
    "User can build a pool performance map and call the API function `runByScenarios`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "7f24f33a",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/xiaoyu/repo/AbsBox/lib/python3.13/site-packages/urllib3/connectionpool.py:1097: InsecureRequestWarning: Unverified HTTPS request is being made to host 'absbox.org'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#tls-warnings\n",
      "  warnings.warn(\n"
     ]
    }
   ],
   "source": [
    "myAssumption = (\"Pool\",(\"Mortgage\",{\"CDR\":0.01},None,None,None)\n",
    "                                ,None\n",
    "                                ,None)\n",
    "\n",
    "myAssumption2 = (\"Pool\",(\"Mortgage\",None,{\"CPR\":0.01},None,None)\n",
    "                                ,None\n",
    "                                ,None)\n",
    "\n",
    "r = localAPI.runByScenarios(examples.test01\n",
    "                            ,poolAssump={\"00\":myAssumption\n",
    "                                        ,\"stressed\":myAssumption2}\n",
    "                            ,read=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a1e0e565",
   "metadata": {},
   "source": [
    "The result `r` is a dict whose keys came fromt he pool assumpiton map"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "ee85d1e1",
   "metadata": {
    "scrolled": true
   },
   "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>Balance</th>\n",
       "      <th>Principal</th>\n",
       "      <th>Interest</th>\n",
       "      <th>Prepayment</th>\n",
       "      <th>Default</th>\n",
       "      <th>Recovery</th>\n",
       "      <th>Loss</th>\n",
       "      <th>WAC</th>\n",
       "      <th>BorrowerNum</th>\n",
       "      <th>PrepayPenalty</th>\n",
       "      <th>CumPrincipal</th>\n",
       "      <th>CumPrepay</th>\n",
       "      <th>CumDelinq</th>\n",
       "      <th>CumDefault</th>\n",
       "      <th>CumRecovery</th>\n",
       "      <th>CumLoss</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-04-01</th>\n",
       "      <td>1989.69</td>\n",
       "      <td>206.84</td>\n",
       "      <td>28.60</td>\n",
       "      <td>0</td>\n",
       "      <td>3.47</td>\n",
       "      <td>0</td>\n",
       "      <td>3.47</td>\n",
       "      <td>0.08</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>206.84</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3.47</td>\n",
       "      <td>0</td>\n",
       "      <td>3.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-05-01</th>\n",
       "      <td>1883.73</td>\n",
       "      <td>104.32</td>\n",
       "      <td>13.25</td>\n",
       "      <td>0</td>\n",
       "      <td>1.64</td>\n",
       "      <td>0</td>\n",
       "      <td>1.64</td>\n",
       "      <td>0.08</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>311.16</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.11</td>\n",
       "      <td>0</td>\n",
       "      <td>5.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-06-01</th>\n",
       "      <td>1777.20</td>\n",
       "      <td>104.93</td>\n",
       "      <td>12.54</td>\n",
       "      <td>0</td>\n",
       "      <td>1.60</td>\n",
       "      <td>0</td>\n",
       "      <td>1.60</td>\n",
       "      <td>0.08</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>416.09</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6.71</td>\n",
       "      <td>0</td>\n",
       "      <td>6.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-07-01</th>\n",
       "      <td>1670.20</td>\n",
       "      <td>105.54</td>\n",
       "      <td>11.83</td>\n",
       "      <td>0</td>\n",
       "      <td>1.46</td>\n",
       "      <td>0</td>\n",
       "      <td>1.46</td>\n",
       "      <td>0.08</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>521.63</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8.17</td>\n",
       "      <td>0</td>\n",
       "      <td>8.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-08-01</th>\n",
       "      <td>1562.63</td>\n",
       "      <td>106.15</td>\n",
       "      <td>11.12</td>\n",
       "      <td>0</td>\n",
       "      <td>1.42</td>\n",
       "      <td>0</td>\n",
       "      <td>1.42</td>\n",
       "      <td>0.08</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>627.78</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9.59</td>\n",
       "      <td>0</td>\n",
       "      <td>9.59</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Balance  Principal  Interest  Prepayment  Default  Recovery  Loss  \\\n",
       "Date                                                                            \n",
       "2021-04-01  1989.69     206.84     28.60           0     3.47         0  3.47   \n",
       "2021-05-01  1883.73     104.32     13.25           0     1.64         0  1.64   \n",
       "2021-06-01  1777.20     104.93     12.54           0     1.60         0  1.60   \n",
       "2021-07-01  1670.20     105.54     11.83           0     1.46         0  1.46   \n",
       "2021-08-01  1562.63     106.15     11.12           0     1.42         0  1.42   \n",
       "\n",
       "             WAC BorrowerNum PrepayPenalty  CumPrincipal  CumPrepay  \\\n",
       "Date                                                                  \n",
       "2021-04-01  0.08        None          None        206.84          0   \n",
       "2021-05-01  0.08        None          None        311.16          0   \n",
       "2021-06-01  0.08        None          None        416.09          0   \n",
       "2021-07-01  0.08        None          None        521.63          0   \n",
       "2021-08-01  0.08        None          None        627.78          0   \n",
       "\n",
       "            CumDelinq  CumDefault  CumRecovery  CumLoss  \n",
       "Date                                                     \n",
       "2021-04-01          0        3.47            0     3.47  \n",
       "2021-05-01          0        5.11            0     5.11  \n",
       "2021-06-01          0        6.71            0     6.71  \n",
       "2021-07-01          0        8.17            0     8.17  \n",
       "2021-08-01          0        9.59            0     9.59  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r['00']['pool']['flow']['PoolConsol'].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "a532517d",
   "metadata": {
    "scrolled": true
   },
   "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>Balance</th>\n",
       "      <th>Principal</th>\n",
       "      <th>Interest</th>\n",
       "      <th>Prepayment</th>\n",
       "      <th>Default</th>\n",
       "      <th>Recovery</th>\n",
       "      <th>Loss</th>\n",
       "      <th>WAC</th>\n",
       "      <th>BorrowerNum</th>\n",
       "      <th>PrepayPenalty</th>\n",
       "      <th>CumPrincipal</th>\n",
       "      <th>CumPrepay</th>\n",
       "      <th>CumDelinq</th>\n",
       "      <th>CumDefault</th>\n",
       "      <th>CumRecovery</th>\n",
       "      <th>CumLoss</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-04-01</th>\n",
       "      <td>1989.69</td>\n",
       "      <td>206.84</td>\n",
       "      <td>28.60</td>\n",
       "      <td>3.47</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.08</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>206.84</td>\n",
       "      <td>3.47</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-05-01</th>\n",
       "      <td>1883.73</td>\n",
       "      <td>104.32</td>\n",
       "      <td>13.25</td>\n",
       "      <td>1.64</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.08</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>311.16</td>\n",
       "      <td>5.11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-06-01</th>\n",
       "      <td>1777.20</td>\n",
       "      <td>104.93</td>\n",
       "      <td>12.54</td>\n",
       "      <td>1.60</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.08</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>416.09</td>\n",
       "      <td>6.71</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-07-01</th>\n",
       "      <td>1670.20</td>\n",
       "      <td>105.54</td>\n",
       "      <td>11.83</td>\n",
       "      <td>1.46</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.08</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>521.63</td>\n",
       "      <td>8.17</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-08-01</th>\n",
       "      <td>1562.63</td>\n",
       "      <td>106.15</td>\n",
       "      <td>11.12</td>\n",
       "      <td>1.42</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.08</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>627.78</td>\n",
       "      <td>9.59</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Balance  Principal  Interest  Prepayment  Default  Recovery  Loss  \\\n",
       "Date                                                                            \n",
       "2021-04-01  1989.69     206.84     28.60        3.47        0         0     0   \n",
       "2021-05-01  1883.73     104.32     13.25        1.64        0         0     0   \n",
       "2021-06-01  1777.20     104.93     12.54        1.60        0         0     0   \n",
       "2021-07-01  1670.20     105.54     11.83        1.46        0         0     0   \n",
       "2021-08-01  1562.63     106.15     11.12        1.42        0         0     0   \n",
       "\n",
       "             WAC BorrowerNum PrepayPenalty  CumPrincipal  CumPrepay  \\\n",
       "Date                                                                  \n",
       "2021-04-01  0.08        None          None        206.84       3.47   \n",
       "2021-05-01  0.08        None          None        311.16       5.11   \n",
       "2021-06-01  0.08        None          None        416.09       6.71   \n",
       "2021-07-01  0.08        None          None        521.63       8.17   \n",
       "2021-08-01  0.08        None          None        627.78       9.59   \n",
       "\n",
       "            CumDelinq  CumDefault  CumRecovery  CumLoss  \n",
       "Date                                                     \n",
       "2021-04-01          0           0            0        0  \n",
       "2021-05-01          0           0            0        0  \n",
       "2021-06-01          0           0            0        0  \n",
       "2021-07-01          0           0            0        0  \n",
       "2021-08-01          0           0            0        0  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r['stressed']['pool']['flow']['PoolConsol'].head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0541be7b",
   "metadata": {},
   "source": [
    "#### Structure Senstivity Run"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "36ca75d9",
   "metadata": {},
   "source": [
    "To run mulitple deals with same pool/deal run assumption , user can call `runStructs()` from the API.\n",
    "\n",
    "The function will return the result as a map."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "6cb13e03",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/xiaoyu/repo/AbsBox/lib/python3.13/site-packages/urllib3/connectionpool.py:1097: InsecureRequestWarning: Unverified HTTPS request is being made to host 'absbox.org'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#tls-warnings\n",
      "  warnings.warn(\n"
     ]
    }
   ],
   "source": [
    "r = localAPI.runStructs({\"A\":examples.test01\n",
    "                         ,\"B\":examples.test02}\n",
    "                        ,read=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "d82d915b",
   "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>balance</th>\n",
       "      <th>interest</th>\n",
       "      <th>principal</th>\n",
       "      <th>rate</th>\n",
       "      <th>cash</th>\n",
       "      <th>intDue</th>\n",
       "      <th>intOverInt</th>\n",
       "      <th>factor</th>\n",
       "      <th>memo</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-06-20</th>\n",
       "      <td>543.90</td>\n",
       "      <td>15.34</td>\n",
       "      <td>456.10</td>\n",
       "      <td>0.07</td>\n",
       "      <td>471.44</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.54390</td>\n",
       "      <td>[&lt;PayInt:A1&gt;, &lt;PayPrin:A1&gt;]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-07-20</th>\n",
       "      <td>429.17</td>\n",
       "      <td>3.12</td>\n",
       "      <td>114.73</td>\n",
       "      <td>0.07</td>\n",
       "      <td>117.85</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.42917</td>\n",
       "      <td>[&lt;PayInt:A1&gt;, &lt;PayPrin:A1&gt;]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-08-20</th>\n",
       "      <td>313.86</td>\n",
       "      <td>2.55</td>\n",
       "      <td>115.31</td>\n",
       "      <td>0.07</td>\n",
       "      <td>117.86</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.31386</td>\n",
       "      <td>[&lt;PayInt:A1&gt;, &lt;PayPrin:A1&gt;]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-20</th>\n",
       "      <td>197.87</td>\n",
       "      <td>1.86</td>\n",
       "      <td>115.99</td>\n",
       "      <td>0.07</td>\n",
       "      <td>117.85</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.19787</td>\n",
       "      <td>[&lt;PayInt:A1&gt;, &lt;PayPrin:A1&gt;]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-20</th>\n",
       "      <td>81.15</td>\n",
       "      <td>1.13</td>\n",
       "      <td>116.72</td>\n",
       "      <td>0.07</td>\n",
       "      <td>117.85</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.08115</td>\n",
       "      <td>[&lt;PayInt:A1&gt;, &lt;PayPrin:A1&gt;]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            balance  interest  principal  rate    cash  intDue  intOverInt  \\\n",
       "date                                                                         \n",
       "2021-06-20   543.90     15.34     456.10  0.07  471.44       0           0   \n",
       "2021-07-20   429.17      3.12     114.73  0.07  117.85       0           0   \n",
       "2021-08-20   313.86      2.55     115.31  0.07  117.86       0           0   \n",
       "2021-09-20   197.87      1.86     115.99  0.07  117.85       0           0   \n",
       "2021-10-20    81.15      1.13     116.72  0.07  117.85       0           0   \n",
       "\n",
       "             factor                         memo  \n",
       "date                                              \n",
       "2021-06-20  0.54390  [<PayInt:A1>, <PayPrin:A1>]  \n",
       "2021-07-20  0.42917  [<PayInt:A1>, <PayPrin:A1>]  \n",
       "2021-08-20  0.31386  [<PayInt:A1>, <PayPrin:A1>]  \n",
       "2021-09-20  0.19787  [<PayInt:A1>, <PayPrin:A1>]  \n",
       "2021-10-20  0.08115  [<PayInt:A1>, <PayPrin:A1>]  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r['A']['bonds']['A1'].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "376360fe",
   "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>balance</th>\n",
       "      <th>interest</th>\n",
       "      <th>principal</th>\n",
       "      <th>rate</th>\n",
       "      <th>cash</th>\n",
       "      <th>intDue</th>\n",
       "      <th>intOverInt</th>\n",
       "      <th>factor</th>\n",
       "      <th>memo</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-06-20</th>\n",
       "      <td>340.83</td>\n",
       "      <td>12.27</td>\n",
       "      <td>459.17</td>\n",
       "      <td>0.07</td>\n",
       "      <td>471.44</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.34083</td>\n",
       "      <td>[&lt;PayInt:A1&gt;, &lt;PayPrin:A1&gt;]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-07-20</th>\n",
       "      <td>224.94</td>\n",
       "      <td>1.96</td>\n",
       "      <td>115.89</td>\n",
       "      <td>0.07</td>\n",
       "      <td>117.85</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.22494</td>\n",
       "      <td>[&lt;PayInt:A1&gt;, &lt;PayPrin:A1&gt;]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-08-20</th>\n",
       "      <td>108.41</td>\n",
       "      <td>1.33</td>\n",
       "      <td>116.53</td>\n",
       "      <td>0.07</td>\n",
       "      <td>117.86</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.10841</td>\n",
       "      <td>[&lt;PayInt:A1&gt;, &lt;PayPrin:A1&gt;]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-20</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.64</td>\n",
       "      <td>108.41</td>\n",
       "      <td>0.07</td>\n",
       "      <td>109.05</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>[&lt;PayInt:A1&gt;, &lt;PayPrin:A1&gt;]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            balance  interest  principal  rate    cash  intDue  intOverInt  \\\n",
       "date                                                                         \n",
       "2021-06-20   340.83     12.27     459.17  0.07  471.44       0           0   \n",
       "2021-07-20   224.94      1.96     115.89  0.07  117.85       0           0   \n",
       "2021-08-20   108.41      1.33     116.53  0.07  117.86       0           0   \n",
       "2021-09-20     0.00      0.64     108.41  0.07  109.05       0           0   \n",
       "\n",
       "             factor                         memo  \n",
       "date                                              \n",
       "2021-06-20  0.34083  [<PayInt:A1>, <PayPrin:A1>]  \n",
       "2021-07-20  0.22494  [<PayInt:A1>, <PayPrin:A1>]  \n",
       "2021-08-20  0.10841  [<PayInt:A1>, <PayPrin:A1>]  \n",
       "2021-09-20  0.00000  [<PayInt:A1>, <PayPrin:A1>]  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r['B']['bonds']['A1'].head()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.13.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}