{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Run Asset Pool 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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",
   "metadata": {},
   "source": [
    "### Pool\n",
    "\n",
    "In `Pool` , it will have a field named `assets` ,which contains a list of `assets`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "mortgage1 = [\"Mortgage\"\n",
    "            ,{\"originBalance\": 12000.0\n",
    "            ,\"originRate\": [\"fix\",0.045]\n",
    "            ,\"originTerm\": 40\n",
    "            ,\"freq\": \"monthly\"\n",
    "            ,\"type\": \"level\"\n",
    "            ,\"originDate\": \"2021-02-01\"}\n",
    "            ,{\"currentBalance\": 10000.0\n",
    "            ,\"currentRate\": 0.075\n",
    "            ,\"remainTerm\": 30\n",
    "            ,\"status\": \"current\"}]\n",
    "\n",
    "mortgage2 = [\"Mortgage\"\n",
    "            ,{\"originBalance\": 8000.0\n",
    "            ,\"originRate\": [\"fix\",0.045]\n",
    "            ,\"originTerm\": 25\n",
    "            ,\"freq\": \"monthly\"\n",
    "            ,\"type\": \"level\"\n",
    "            ,\"originDate\": \"2021-02-01\"}\n",
    "            ,{\"currentBalance\": 6000.0\n",
    "            ,\"currentRate\": 0.075\n",
    "            ,\"remainTerm\": 15\n",
    "            ,\"status\": \"current\"}]\n",
    "\n",
    "myPool = {'assets':[ mortgage1, mortgage2  ],\n",
    "         'cutoffDate':\"2022-03-01\"}"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Assumption on Pool Level\n",
    "\n",
    "User can set assumption on pool level ,which suggests the assumption will be applied to all the assets in the pool."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": true
   },
   "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"
     ]
    },
    {
     "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>2022-03-01</th>\n",
       "      <td>13891.98</td>\n",
       "      <td>693.78</td>\n",
       "      <td>91.15</td>\n",
       "      <td>0</td>\n",
       "      <td>11.24</td>\n",
       "      <td>0</td>\n",
       "      <td>11.24</td>\n",
       "      <td>0.075</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>693.78</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11.24</td>\n",
       "      <td>0</td>\n",
       "      <td>11.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-01</th>\n",
       "      <td>13182.62</td>\n",
       "      <td>697.52</td>\n",
       "      <td>86.74</td>\n",
       "      <td>0</td>\n",
       "      <td>11.84</td>\n",
       "      <td>0</td>\n",
       "      <td>11.84</td>\n",
       "      <td>0.075</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1391.30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>23.08</td>\n",
       "      <td>0</td>\n",
       "      <td>23.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-05-01</th>\n",
       "      <td>12470.45</td>\n",
       "      <td>701.30</td>\n",
       "      <td>82.31</td>\n",
       "      <td>0</td>\n",
       "      <td>10.87</td>\n",
       "      <td>0</td>\n",
       "      <td>10.87</td>\n",
       "      <td>0.075</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>2092.60</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>33.95</td>\n",
       "      <td>0</td>\n",
       "      <td>33.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-06-01</th>\n",
       "      <td>11754.74</td>\n",
       "      <td>705.08</td>\n",
       "      <td>77.87</td>\n",
       "      <td>0</td>\n",
       "      <td>10.63</td>\n",
       "      <td>0</td>\n",
       "      <td>10.63</td>\n",
       "      <td>0.075</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>2797.68</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>44.58</td>\n",
       "      <td>0</td>\n",
       "      <td>44.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-07-01</th>\n",
       "      <td>11036.14</td>\n",
       "      <td>708.90</td>\n",
       "      <td>73.40</td>\n",
       "      <td>0</td>\n",
       "      <td>9.70</td>\n",
       "      <td>0</td>\n",
       "      <td>9.70</td>\n",
       "      <td>0.075</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>3506.58</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>54.28</td>\n",
       "      <td>0</td>\n",
       "      <td>54.28</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Balance  Principal  Interest  Prepayment  Default  Recovery  \\\n",
       "Date                                                                       \n",
       "2022-03-01  13891.98     693.78     91.15           0    11.24         0   \n",
       "2022-04-01  13182.62     697.52     86.74           0    11.84         0   \n",
       "2022-05-01  12470.45     701.30     82.31           0    10.87         0   \n",
       "2022-06-01  11754.74     705.08     77.87           0    10.63         0   \n",
       "2022-07-01  11036.14     708.90     73.40           0     9.70         0   \n",
       "\n",
       "             Loss    WAC BorrowerNum PrepayPenalty  CumPrincipal  CumPrepay  \\\n",
       "Date                                                                          \n",
       "2022-03-01  11.24  0.075        None          None        693.78          0   \n",
       "2022-04-01  11.84  0.075        None          None       1391.30          0   \n",
       "2022-05-01  10.87  0.075        None          None       2092.60          0   \n",
       "2022-06-01  10.63  0.075        None          None       2797.68          0   \n",
       "2022-07-01   9.70  0.075        None          None       3506.58          0   \n",
       "\n",
       "            CumDelinq  CumDefault  CumRecovery  CumLoss  \n",
       "Date                                                     \n",
       "2022-03-01          0       11.24            0    11.24  \n",
       "2022-04-01          0       23.08            0    23.08  \n",
       "2022-05-01          0       33.95            0    33.95  \n",
       "2022-06-01          0       44.58            0    44.58  \n",
       "2022-07-01          0       54.28            0    54.28  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r = localAPI.runPool(myPool\n",
    "                  ,poolAssump=(\"Pool\",(\"Mortgage\",{\"CDR\":0.01},None,None,None)\n",
    "                                    ,None\n",
    "                                    ,None)\n",
    "                  ,read=True)\n",
    "\n",
    "r['PoolConsol']['flow'].head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Assumption on Asset Level"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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"
     ]
    },
    {
     "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>2022-03-01</th>\n",
       "      <td>13891.98</td>\n",
       "      <td>693.78</td>\n",
       "      <td>91.15</td>\n",
       "      <td>4.02</td>\n",
       "      <td>7.22</td>\n",
       "      <td>0</td>\n",
       "      <td>7.22</td>\n",
       "      <td>0.075</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>693.78</td>\n",
       "      <td>4.02</td>\n",
       "      <td>0</td>\n",
       "      <td>7.22</td>\n",
       "      <td>0</td>\n",
       "      <td>7.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-01</th>\n",
       "      <td>13182.62</td>\n",
       "      <td>697.52</td>\n",
       "      <td>86.74</td>\n",
       "      <td>4.12</td>\n",
       "      <td>7.72</td>\n",
       "      <td>0</td>\n",
       "      <td>7.72</td>\n",
       "      <td>0.075</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1391.30</td>\n",
       "      <td>8.14</td>\n",
       "      <td>0</td>\n",
       "      <td>14.94</td>\n",
       "      <td>0</td>\n",
       "      <td>14.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-05-01</th>\n",
       "      <td>12470.45</td>\n",
       "      <td>701.30</td>\n",
       "      <td>82.31</td>\n",
       "      <td>3.66</td>\n",
       "      <td>7.21</td>\n",
       "      <td>0</td>\n",
       "      <td>7.21</td>\n",
       "      <td>0.075</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>2092.60</td>\n",
       "      <td>11.80</td>\n",
       "      <td>0</td>\n",
       "      <td>22.15</td>\n",
       "      <td>0</td>\n",
       "      <td>22.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-06-01</th>\n",
       "      <td>11754.74</td>\n",
       "      <td>705.08</td>\n",
       "      <td>77.87</td>\n",
       "      <td>3.45</td>\n",
       "      <td>7.18</td>\n",
       "      <td>0</td>\n",
       "      <td>7.18</td>\n",
       "      <td>0.075</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>2797.68</td>\n",
       "      <td>15.25</td>\n",
       "      <td>0</td>\n",
       "      <td>29.33</td>\n",
       "      <td>0</td>\n",
       "      <td>29.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-07-01</th>\n",
       "      <td>11036.14</td>\n",
       "      <td>708.90</td>\n",
       "      <td>73.40</td>\n",
       "      <td>3.01</td>\n",
       "      <td>6.69</td>\n",
       "      <td>0</td>\n",
       "      <td>6.69</td>\n",
       "      <td>0.075</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>3506.58</td>\n",
       "      <td>18.26</td>\n",
       "      <td>0</td>\n",
       "      <td>36.02</td>\n",
       "      <td>0</td>\n",
       "      <td>36.02</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Balance  Principal  Interest  Prepayment  Default  Recovery  \\\n",
       "Date                                                                       \n",
       "2022-03-01  13891.98     693.78     91.15        4.02     7.22         0   \n",
       "2022-04-01  13182.62     697.52     86.74        4.12     7.72         0   \n",
       "2022-05-01  12470.45     701.30     82.31        3.66     7.21         0   \n",
       "2022-06-01  11754.74     705.08     77.87        3.45     7.18         0   \n",
       "2022-07-01  11036.14     708.90     73.40        3.01     6.69         0   \n",
       "\n",
       "            Loss    WAC BorrowerNum PrepayPenalty  CumPrincipal  CumPrepay  \\\n",
       "Date                                                                         \n",
       "2022-03-01  7.22  0.075        None          None        693.78       4.02   \n",
       "2022-04-01  7.72  0.075        None          None       1391.30       8.14   \n",
       "2022-05-01  7.21  0.075        None          None       2092.60      11.80   \n",
       "2022-06-01  7.18  0.075        None          None       2797.68      15.25   \n",
       "2022-07-01  6.69  0.075        None          None       3506.58      18.26   \n",
       "\n",
       "            CumDelinq  CumDefault  CumRecovery  CumLoss  \n",
       "Date                                                     \n",
       "2022-03-01          0        7.22            0     7.22  \n",
       "2022-04-01          0       14.94            0    14.94  \n",
       "2022-05-01          0       22.15            0    22.15  \n",
       "2022-06-01          0       29.33            0    29.33  \n",
       "2022-07-01          0       36.02            0    36.02  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "assetLevelAssump = (\"ByIndex\"\n",
    "                      ,([0],((\"Mortgage\",{\"CDR\":0.01},None,None,None)\n",
    "                                    ,None\n",
    "                                    ,None))\n",
    "                       ,([1],((\"Mortgage\",None,{\"CPR\":0.01},None,None)\n",
    "                                    ,None\n",
    "                                    ,None))\n",
    "                      )\n",
    "\n",
    "r = localAPI.runPool(myPool\n",
    "                  ,poolAssump=assetLevelAssump\n",
    "                  ,read=True)\n",
    "\n",
    "r['PoolConsol']['flow'].head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Cumulative Stats\n",
    "\n",
    "User can annotate the `HistoryDefaults` which suggusts as of the `cutoffDate`, how much balance is in status of `Default`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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"
     ]
    },
    {
     "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>2022-03-01</th>\n",
       "      <td>13891.98</td>\n",
       "      <td>693.78</td>\n",
       "      <td>91.15</td>\n",
       "      <td>0</td>\n",
       "      <td>11.24</td>\n",
       "      <td>0</td>\n",
       "      <td>11.24</td>\n",
       "      <td>0.075</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>693.78</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11.24</td>\n",
       "      <td>0</td>\n",
       "      <td>11.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-01</th>\n",
       "      <td>13182.62</td>\n",
       "      <td>697.52</td>\n",
       "      <td>86.74</td>\n",
       "      <td>0</td>\n",
       "      <td>11.84</td>\n",
       "      <td>0</td>\n",
       "      <td>11.84</td>\n",
       "      <td>0.075</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1391.30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>23.08</td>\n",
       "      <td>0</td>\n",
       "      <td>23.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-05-01</th>\n",
       "      <td>12470.45</td>\n",
       "      <td>701.30</td>\n",
       "      <td>82.31</td>\n",
       "      <td>0</td>\n",
       "      <td>10.87</td>\n",
       "      <td>0</td>\n",
       "      <td>10.87</td>\n",
       "      <td>0.075</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>2092.60</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>33.95</td>\n",
       "      <td>0</td>\n",
       "      <td>33.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-06-01</th>\n",
       "      <td>11754.74</td>\n",
       "      <td>705.08</td>\n",
       "      <td>77.87</td>\n",
       "      <td>0</td>\n",
       "      <td>10.63</td>\n",
       "      <td>0</td>\n",
       "      <td>10.63</td>\n",
       "      <td>0.075</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>2797.68</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>44.58</td>\n",
       "      <td>0</td>\n",
       "      <td>44.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-07-01</th>\n",
       "      <td>11036.14</td>\n",
       "      <td>708.90</td>\n",
       "      <td>73.40</td>\n",
       "      <td>0</td>\n",
       "      <td>9.70</td>\n",
       "      <td>0</td>\n",
       "      <td>9.70</td>\n",
       "      <td>0.075</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>3506.58</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>54.28</td>\n",
       "      <td>0</td>\n",
       "      <td>54.28</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Balance  Principal  Interest  Prepayment  Default  Recovery  \\\n",
       "Date                                                                       \n",
       "2022-03-01  13891.98     693.78     91.15           0    11.24         0   \n",
       "2022-04-01  13182.62     697.52     86.74           0    11.84         0   \n",
       "2022-05-01  12470.45     701.30     82.31           0    10.87         0   \n",
       "2022-06-01  11754.74     705.08     77.87           0    10.63         0   \n",
       "2022-07-01  11036.14     708.90     73.40           0     9.70         0   \n",
       "\n",
       "             Loss    WAC BorrowerNum PrepayPenalty  CumPrincipal  CumPrepay  \\\n",
       "Date                                                                          \n",
       "2022-03-01  11.24  0.075        None          None        693.78          0   \n",
       "2022-04-01  11.84  0.075        None          None       1391.30          0   \n",
       "2022-05-01  10.87  0.075        None          None       2092.60          0   \n",
       "2022-06-01  10.63  0.075        None          None       2797.68          0   \n",
       "2022-07-01   9.70  0.075        None          None       3506.58          0   \n",
       "\n",
       "            CumDelinq  CumDefault  CumRecovery  CumLoss  \n",
       "Date                                                     \n",
       "2022-03-01          0       11.24            0    11.24  \n",
       "2022-04-01          0       23.08            0    23.08  \n",
       "2022-05-01          0       33.95            0    33.95  \n",
       "2022-06-01          0       44.58            0    44.58  \n",
       "2022-07-01          0       54.28            0    54.28  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "myPool2 = {'assets':[ mortgage1, mortgage2  ],\n",
    "           'cutoffDate':\"2022-03-01\"\n",
    "           ,'issuanceStat':{\"HistoryDefaults\":200,\"HistoryLoss\":50}}\n",
    "\n",
    "r = localAPI.runPool(myPool2\n",
    "                  ,poolAssump=(\"Pool\",(\"Mortgage\",{\"CDR\":0.01},None,None,None)\n",
    "                                    ,None\n",
    "                                    ,None)\n",
    "                  ,read=True)\n",
    "\n",
    "r['PoolConsol']['flow'].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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": 4
}