{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "489b7d06",
   "metadata": {},
   "outputs": [],
   "source": [
    "%load_ext autoreload\n",
    "%autoreload 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "6c7b8c35",
   "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)\n",
    "\n",
    "import absbox.examples as examples"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7fc3d420",
   "metadata": {},
   "source": [
    "### View Multiple cashflow\n",
    "\n",
    "User can have view multiple cashflows via single function"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "487d9ddb",
   "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.run(examples.test03\n",
    "               ,poolAssump = (\"Pool\",(\"Mortgage\",None,None,None,None)\n",
    "                                       ,None\n",
    "                                       ,None)\n",
    "               ,runAssump = None\n",
    "               ,read=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0523c0d5",
   "metadata": {},
   "source": [
    "#### View multiple bonds casfhlow\n",
    "\n",
    "include cashflow view function"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "3b90a4d6",
   "metadata": {},
   "outputs": [],
   "source": [
    "from absbox import readBondsCf,readFeesCf,readAccsCf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "904476db",
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"5\" halign=\"left\">A1</th>\n",
       "      <th colspan=\"5\" halign=\"left\">B</th>\n",
       "    </tr>\n",
       "    <tr>\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>balance</th>\n",
       "      <th>interest</th>\n",
       "      <th>principal</th>\n",
       "      <th>rate</th>\n",
       "      <th>cash</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-06-20</th>\n",
       "      <td>383.31</td>\n",
       "      <td>12.27</td>\n",
       "      <td>416.69</td>\n",
       "      <td>0.07</td>\n",
       "      <td>428.96</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-07-20</th>\n",
       "      <td>296.39</td>\n",
       "      <td>2.20</td>\n",
       "      <td>86.92</td>\n",
       "      <td>0.07</td>\n",
       "      <td>89.12</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-08-20</th>\n",
       "      <td>207.31</td>\n",
       "      <td>1.76</td>\n",
       "      <td>89.08</td>\n",
       "      <td>0.07</td>\n",
       "      <td>90.84</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-20</th>\n",
       "      <td>115.86</td>\n",
       "      <td>1.23</td>\n",
       "      <td>91.45</td>\n",
       "      <td>0.07</td>\n",
       "      <td>92.68</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-20</th>\n",
       "      <td>21.86</td>\n",
       "      <td>0.66</td>\n",
       "      <td>94.00</td>\n",
       "      <td>0.07</td>\n",
       "      <td>94.66</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                A1                                        B           \\\n",
       "           balance interest principal  rate    cash balance interest   \n",
       "date                                                                   \n",
       "2021-06-20  383.31    12.27    416.69  0.07  428.96  1000.0      0.0   \n",
       "2021-07-20  296.39     2.20     86.92  0.07   89.12  1000.0      0.0   \n",
       "2021-08-20  207.31     1.76     89.08  0.07   90.84  1000.0      0.0   \n",
       "2021-09-20  115.86     1.23     91.45  0.07   92.68  1000.0      0.0   \n",
       "2021-10-20   21.86     0.66     94.00  0.07   94.66  1000.0      0.0   \n",
       "\n",
       "                                \n",
       "           principal rate cash  \n",
       "date                            \n",
       "2021-06-20       0.0    0  0.0  \n",
       "2021-07-20       0.0    0  0.0  \n",
       "2021-08-20       0.0    0  0.0  \n",
       "2021-09-20       0.0    0  0.0  \n",
       "2021-10-20       0.0    0  0.0  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "readBondsCf(r['bonds']).head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "29794a4b",
   "metadata": {},
   "source": [
    "User can keep all columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "5f4862be",
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"9\" halign=\"left\">A1</th>\n",
       "      <th colspan=\"9\" halign=\"left\">B</th>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <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",
       "      <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>383.31</td>\n",
       "      <td>12.27</td>\n",
       "      <td>416.69</td>\n",
       "      <td>0.07</td>\n",
       "      <td>428.96</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.38331</td>\n",
       "      <td>[&lt;PayInt:A1&gt;, &lt;PayPrin:A1&gt;]</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>&lt;PayYield:B&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-07-20</th>\n",
       "      <td>296.39</td>\n",
       "      <td>2.20</td>\n",
       "      <td>86.92</td>\n",
       "      <td>0.07</td>\n",
       "      <td>89.12</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.29639</td>\n",
       "      <td>[&lt;PayInt:A1&gt;, &lt;PayPrin:A1&gt;]</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>&lt;PayYield:B&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-08-20</th>\n",
       "      <td>207.31</td>\n",
       "      <td>1.76</td>\n",
       "      <td>89.08</td>\n",
       "      <td>0.07</td>\n",
       "      <td>90.84</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.20731</td>\n",
       "      <td>[&lt;PayInt:A1&gt;, &lt;PayPrin:A1&gt;]</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>&lt;PayYield:B&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-20</th>\n",
       "      <td>115.86</td>\n",
       "      <td>1.23</td>\n",
       "      <td>91.45</td>\n",
       "      <td>0.07</td>\n",
       "      <td>92.68</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.11586</td>\n",
       "      <td>[&lt;PayInt:A1&gt;, &lt;PayPrin:A1&gt;]</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>&lt;PayYield:B&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-20</th>\n",
       "      <td>21.86</td>\n",
       "      <td>0.66</td>\n",
       "      <td>94.00</td>\n",
       "      <td>0.07</td>\n",
       "      <td>94.66</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.02186</td>\n",
       "      <td>[&lt;PayInt:A1&gt;, &lt;PayPrin:A1&gt;]</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>&lt;PayYield:B&gt;</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                A1                                                     \\\n",
       "           balance interest principal  rate    cash intDue intOverInt   \n",
       "date                                                                    \n",
       "2021-06-20  383.31    12.27    416.69  0.07  428.96    0.0        0.0   \n",
       "2021-07-20  296.39     2.20     86.92  0.07   89.12    0.0        0.0   \n",
       "2021-08-20  207.31     1.76     89.08  0.07   90.84    0.0        0.0   \n",
       "2021-09-20  115.86     1.23     91.45  0.07   92.68    0.0        0.0   \n",
       "2021-10-20   21.86     0.66     94.00  0.07   94.66    0.0        0.0   \n",
       "\n",
       "                                                       B                     \\\n",
       "             factor                         memo balance interest principal   \n",
       "date                                                                          \n",
       "2021-06-20  0.38331  [<PayInt:A1>, <PayPrin:A1>]  1000.0      0.0       0.0   \n",
       "2021-07-20  0.29639  [<PayInt:A1>, <PayPrin:A1>]  1000.0      0.0       0.0   \n",
       "2021-08-20  0.20731  [<PayInt:A1>, <PayPrin:A1>]  1000.0      0.0       0.0   \n",
       "2021-09-20  0.11586  [<PayInt:A1>, <PayPrin:A1>]  1000.0      0.0       0.0   \n",
       "2021-10-20  0.02186  [<PayInt:A1>, <PayPrin:A1>]  1000.0      0.0       0.0   \n",
       "\n",
       "                                                             \n",
       "           rate cash intDue intOverInt factor          memo  \n",
       "date                                                         \n",
       "2021-06-20    0  0.0      0          0    1.0  <PayYield:B>  \n",
       "2021-07-20    0  0.0      0          0    1.0  <PayYield:B>  \n",
       "2021-08-20    0  0.0      0          0    1.0  <PayYield:B>  \n",
       "2021-09-20    0  0.0      0          0    1.0  <PayYield:B>  \n",
       "2021-10-20    0  0.0      0          0    1.0  <PayYield:B>  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "readBondsCf(r['bonds'],popColumns=[]).head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "500d7644",
   "metadata": {},
   "source": [
    "#### View multiple fee cashflow"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "63d3c8af",
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th colspan=\"2\" halign=\"left\">bondAdmFee</th>\n",
       "      <th colspan=\"2\" halign=\"left\">poolServFee</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>balance</th>\n",
       "      <th>payment</th>\n",
       "      <th>balance</th>\n",
       "      <th>payment</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th>daySeq</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",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>36.00</td>\n",
       "      <td>0</td>\n",
       "      <td>6.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-07-20</th>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>27.66</td>\n",
       "      <td>0</td>\n",
       "      <td>1.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-08-20</th>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>25.92</td>\n",
       "      <td>0</td>\n",
       "      <td>1.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-20</th>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>24.14</td>\n",
       "      <td>0</td>\n",
       "      <td>1.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-20</th>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>22.31</td>\n",
       "      <td>0</td>\n",
       "      <td>0.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-11-20</th>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>20.43</td>\n",
       "      <td>0</td>\n",
       "      <td>0.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-20</th>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>18.50</td>\n",
       "      <td>0</td>\n",
       "      <td>0.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-20</th>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>16.53</td>\n",
       "      <td>0</td>\n",
       "      <td>0.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-20</th>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>14.52</td>\n",
       "      <td>0</td>\n",
       "      <td>0.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-20</th>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>12.47</td>\n",
       "      <td>0</td>\n",
       "      <td>0.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-20</th>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>10.37</td>\n",
       "      <td>0</td>\n",
       "      <td>0.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-05-20</th>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>8.23</td>\n",
       "      <td>0</td>\n",
       "      <td>0.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-06-20</th>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>6.04</td>\n",
       "      <td>0</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-07-20</th>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>3.82</td>\n",
       "      <td>0</td>\n",
       "      <td>0.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-08-20</th>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1.54</td>\n",
       "      <td>0</td>\n",
       "      <td>0.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-20</th>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-10-20</th>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  bondAdmFee         poolServFee        \n",
       "                     balance payment     balance payment\n",
       "date       daySeq                                       \n",
       "2021-06-20 0               0   36.00           0    6.48\n",
       "2021-07-20 0               0   27.66           0    1.07\n",
       "2021-08-20 0               0   25.92           0    1.10\n",
       "2021-09-20 0               0   24.14           0    1.03\n",
       "2021-10-20 0               0   22.31           0    0.88\n",
       "2021-11-20 0               0   20.43           0    0.89\n",
       "2021-12-20 0               0   18.50           0    0.75\n",
       "2022-01-20 0               0   16.53           0    0.74\n",
       "2022-02-20 0               0   14.52           0    0.67\n",
       "2022-03-20 0               0   12.47           0    0.45\n",
       "2022-04-20 0               0   10.37           0    0.52\n",
       "2022-05-20 0               0    8.23           0    0.41\n",
       "2022-06-20 0               0    6.04           0    0.37\n",
       "2022-07-20 0               0    3.82           0    0.27\n",
       "2022-08-20 0               0    1.54           0    0.22\n",
       "2022-09-20 0               0    0.00           0    0.15\n",
       "2022-10-20 0               0    0.00           0    0.07"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "readFeesCf(r['fees'])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "78548232",
   "metadata": {},
   "source": [
    "#### View multiple account cashflow"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "21c28f64",
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th colspan=\"2\" halign=\"left\">acc01</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>balance</th>\n",
       "      <th>change</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th>daySeq</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">2021-04-01</th>\n",
       "      <th>0</th>\n",
       "      <td>28.63</td>\n",
       "      <td>28.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>235.72</td>\n",
       "      <td>207.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>235.72</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>235.72</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-05-01</th>\n",
       "      <th>0</th>\n",
       "      <td>249.00</td>\n",
       "      <td>13.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">2022-10-20</th>\n",
       "      <th>0</th>\n",
       "      <td>117.79</td>\n",
       "      <td>-0.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>117.79</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>117.79</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>117.79</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.00</td>\n",
       "      <td>-117.79</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>161 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    acc01        \n",
       "                  balance  change\n",
       "date       daySeq                \n",
       "2021-04-01 0        28.63   28.63\n",
       "           1       235.72  207.09\n",
       "           2       235.72    0.00\n",
       "           3       235.72    0.00\n",
       "2021-05-01 0       249.00   13.28\n",
       "...                   ...     ...\n",
       "2022-10-20 0       117.79   -0.07\n",
       "           1       117.79    0.00\n",
       "           2       117.79    0.00\n",
       "           3       117.79    0.00\n",
       "           4         0.00 -117.79\n",
       "\n",
       "[161 rows x 2 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "readAccsCf(r['accounts'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0b744ecc",
   "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": 5
}