now its cleared, again my bad

1 files changed, 19 insertions, 604 deletions

diff --git a/ui_security_inventory_23_parsing.ipynb b/ui_security_inventory_23_parsing.ipynb
index 84be050..0091ac6 100644
--- a/ui_security_inventory_23_parsing.ipynb
+++ b/ui_security_inventory_23_parsing.ipynb
@@ -2,7 +2,7 @@
  "cells": [
   {
    "cell_type": "code",
-   "execution_count": 1,
+   "execution_count": null,
    "id": "8ce6b023",
    "metadata": {},
    "outputs": [],
@@ -15,18 +15,10 @@
   },
   {
    "cell_type": "code",
-   "execution_count": 2,
+   "execution_count": null,
    "id": "8304939a",
    "metadata": {},
-   "outputs": [
-    {
-     "name": "stdout",
-     "output_type": "stream",
-     "text": [
-      "Sheet1\n"
-     ]
-    }
-   ],
+   "outputs": [],
    "source": [
     "file_path_23 = \"./data/23-138.Records.xlsx\"\n",
     " # skip header rows so column names align, drop all NaN rows\n",
@@ -43,147 +35,10 @@
   },
   {
    "cell_type": "code",
-   "execution_count": 3,
+   "execution_count": null,
    "id": "96dee5bc",
    "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>Account or Security</th>\n",
-       "      <th>Coupon</th>\n",
-       "      <th>Date</th>\n",
-       "      <th>Quantity</th>\n",
-       "      <th>Cost Value</th>\n",
-       "      <th>Market Value</th>\n",
-       "      <th>Bank</th>\n",
-       "      <th>Asset Type</th>\n",
-       "      <th>Company</th>\n",
-       "      <th>Industry</th>\n",
-       "      <th>Private Placement</th>\n",
-       "    </tr>\n",
-       "  </thead>\n",
-       "  <tbody>\n",
-       "    <tr>\n",
-       "      <th>36</th>\n",
-       "      <td>9-200100-Neuberger Intermediate</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>False</td>\n",
-       "    </tr>\n",
-       "    <tr>\n",
-       "      <th>37</th>\n",
-       "      <td>Asset-Backed Securities</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>False</td>\n",
-       "    </tr>\n",
-       "    <tr>\n",
-       "      <th>38</th>\n",
-       "      <td>CHASE FDG MTG LN 2004-1 MTG LN</td>\n",
-       "      <td>2.08</td>\n",
-       "      <td>1933-12-25 00:00:00</td>\n",
-       "      <td>6462.53</td>\n",
-       "      <td>6462.53</td>\n",
-       "      <td>6068.88</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>False</td>\n",
-       "    </tr>\n",
-       "    <tr>\n",
-       "      <th>39</th>\n",
-       "      <td>MVW 2021-2 LLC TIMESHARE LN BK</td>\n",
-       "      <td>1.43</td>\n",
-       "      <td>1939-05-20 00:00:00</td>\n",
-       "      <td>737880.25</td>\n",
-       "      <td>737679.54</td>\n",
-       "      <td>672033.22</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>False</td>\n",
-       "    </tr>\n",
-       "    <tr>\n",
-       "      <th>40</th>\n",
-       "      <td>PFS FING CORP .77% 08-15-2026</td>\n",
-       "      <td>0.77</td>\n",
-       "      <td>2026-08-15 00:00:00</td>\n",
-       "      <td>1090000.00</td>\n",
-       "      <td>1089872.25</td>\n",
-       "      <td>1010524.50</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>False</td>\n",
-       "    </tr>\n",
-       "  </tbody>\n",
-       "</table>\n",
-       "</div>"
-      ],
-      "text/plain": [
-       "                Account or Security Coupon                 Date    Quantity  \\\n",
-       "36  9-200100-Neuberger Intermediate    NaN                  NaN         NaN   \n",
-       "37          Asset-Backed Securities    NaN                  NaN         NaN   \n",
-       "38   CHASE FDG MTG LN 2004-1 MTG LN   2.08  1933-12-25 00:00:00     6462.53   \n",
-       "39   MVW 2021-2 LLC TIMESHARE LN BK   1.43  1939-05-20 00:00:00   737880.25   \n",
-       "40   PFS FING CORP .77% 08-15-2026    0.77  2026-08-15 00:00:00  1090000.00   \n",
-       "\n",
-       "    Cost Value  Market Value  Bank Asset Type Company Industry  \\\n",
-       "36         NaN           NaN  <NA>       <NA>    <NA>     <NA>   \n",
-       "37         NaN           NaN  <NA>       <NA>    <NA>     <NA>   \n",
-       "38     6462.53       6068.88  <NA>       <NA>    <NA>     <NA>   \n",
-       "39   737679.54     672033.22  <NA>       <NA>    <NA>     <NA>   \n",
-       "40  1089872.25    1010524.50  <NA>       <NA>    <NA>     <NA>   \n",
-       "\n",
-       "    Private Placement  \n",
-       "36              False  \n",
-       "37              False  \n",
-       "38              False  \n",
-       "39              False  \n",
-       "40              False  "
-      ]
-     },
-     "execution_count": 3,
-     "metadata": {},
-     "output_type": "execute_result"
-    }
-   ],
+   "outputs": [],
    "source": [
     "bank_i = df[df['Account or Security'].str.contains(\"9-200100\", na=False)].index\n",
     "op_i = df[df['Account or Security'].str.contains(\"Operating Funds Pool\", na=False)].index\n",
@@ -207,147 +62,10 @@
   },
   {
    "cell_type": "code",
-   "execution_count": 4,
+   "execution_count": null,
    "id": "29c95d09",
    "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>Account or Security</th>\n",
-       "      <th>Coupon</th>\n",
-       "      <th>Date</th>\n",
-       "      <th>Quantity</th>\n",
-       "      <th>Cost Value</th>\n",
-       "      <th>Market Value</th>\n",
-       "      <th>Bank</th>\n",
-       "      <th>Asset Type</th>\n",
-       "      <th>Company</th>\n",
-       "      <th>Industry</th>\n",
-       "      <th>Private Placement</th>\n",
-       "    </tr>\n",
-       "  </thead>\n",
-       "  <tbody>\n",
-       "    <tr>\n",
-       "      <th>36</th>\n",
-       "      <td>9-200100-Neuberger Intermediate</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>9-200100-Neuberger Intermediate</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>False</td>\n",
-       "    </tr>\n",
-       "    <tr>\n",
-       "      <th>37</th>\n",
-       "      <td>Asset-Backed Securities</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>9-200100-Neuberger Intermediate</td>\n",
-       "      <td>Asset-Backed Securities</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>False</td>\n",
-       "    </tr>\n",
-       "    <tr>\n",
-       "      <th>38</th>\n",
-       "      <td>CHASE FDG MTG LN 2004-1 MTG LN</td>\n",
-       "      <td>2.08</td>\n",
-       "      <td>1933-12-25 00:00:00</td>\n",
-       "      <td>6462.53</td>\n",
-       "      <td>6462.53</td>\n",
-       "      <td>6068.88</td>\n",
-       "      <td>9-200100-Neuberger Intermediate</td>\n",
-       "      <td>Asset-Backed Securities</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>False</td>\n",
-       "    </tr>\n",
-       "    <tr>\n",
-       "      <th>39</th>\n",
-       "      <td>MVW 2021-2 LLC TIMESHARE LN BK</td>\n",
-       "      <td>1.43</td>\n",
-       "      <td>1939-05-20 00:00:00</td>\n",
-       "      <td>737880.25</td>\n",
-       "      <td>737679.54</td>\n",
-       "      <td>672033.22</td>\n",
-       "      <td>9-200100-Neuberger Intermediate</td>\n",
-       "      <td>Asset-Backed Securities</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>False</td>\n",
-       "    </tr>\n",
-       "    <tr>\n",
-       "      <th>40</th>\n",
-       "      <td>PFS FING CORP .77% 08-15-2026</td>\n",
-       "      <td>0.77</td>\n",
-       "      <td>2026-08-15 00:00:00</td>\n",
-       "      <td>1090000.00</td>\n",
-       "      <td>1089872.25</td>\n",
-       "      <td>1010524.50</td>\n",
-       "      <td>9-200100-Neuberger Intermediate</td>\n",
-       "      <td>Asset-Backed Securities</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>False</td>\n",
-       "    </tr>\n",
-       "  </tbody>\n",
-       "</table>\n",
-       "</div>"
-      ],
-      "text/plain": [
-       "                Account or Security Coupon                 Date    Quantity  \\\n",
-       "36  9-200100-Neuberger Intermediate    NaN                  NaN         NaN   \n",
-       "37          Asset-Backed Securities    NaN                  NaN         NaN   \n",
-       "38   CHASE FDG MTG LN 2004-1 MTG LN   2.08  1933-12-25 00:00:00     6462.53   \n",
-       "39   MVW 2021-2 LLC TIMESHARE LN BK   1.43  1939-05-20 00:00:00   737880.25   \n",
-       "40   PFS FING CORP .77% 08-15-2026    0.77  2026-08-15 00:00:00  1090000.00   \n",
-       "\n",
-       "    Cost Value  Market Value                             Bank  \\\n",
-       "36         NaN           NaN  9-200100-Neuberger Intermediate   \n",
-       "37         NaN           NaN  9-200100-Neuberger Intermediate   \n",
-       "38     6462.53       6068.88  9-200100-Neuberger Intermediate   \n",
-       "39   737679.54     672033.22  9-200100-Neuberger Intermediate   \n",
-       "40  1089872.25    1010524.50  9-200100-Neuberger Intermediate   \n",
-       "\n",
-       "                 Asset Type Company Industry  Private Placement  \n",
-       "36                     <NA>    <NA>     <NA>              False  \n",
-       "37  Asset-Backed Securities    <NA>     <NA>              False  \n",
-       "38  Asset-Backed Securities    <NA>     <NA>              False  \n",
-       "39  Asset-Backed Securities    <NA>     <NA>              False  \n",
-       "40  Asset-Backed Securities    <NA>     <NA>              False  "
-      ]
-     },
-     "execution_count": 4,
-     "metadata": {},
-     "output_type": "execute_result"
-    }
-   ],
+   "outputs": [],
    "source": [
     "bank_name = pd.NA\n",
     "asset_type = pd.NA\n",
@@ -364,41 +82,10 @@
   },
   {
    "cell_type": "code",
-   "execution_count": 5,
+   "execution_count": null,
    "id": "3ea40a3e",
    "metadata": {},
-   "outputs": [
-    {
-     "data": {
-      "text/plain": [
-       "{<NA>,\n",
-       " 'Account Totals',\n",
-       " 'Account Totals - Allspring Conservative Income Fund',\n",
-       " 'Account Totals - Allspring Short Duration',\n",
-       " 'Account Totals - Galliard Capital',\n",
-       " 'Account Totals - Income Research Intermediate',\n",
-       " 'Account Totals - Income Research Short Duration',\n",
-       " 'Account Totals - JP Morgan Managed Reserves ',\n",
-       " 'Account Totals - Neuberger Berman Enhanced Cash',\n",
-       " 'Account Totals - Neuberger Intermediate',\n",
-       " 'Account Totals - Northern Trust UI Short Duration',\n",
-       " 'Asset Backed Securities',\n",
-       " 'Asset-Backed Securities',\n",
-       " 'Cash & Cash Equivalents',\n",
-       " 'Commercial Mortgage Backed Securities',\n",
-       " 'Commercial Paper',\n",
-       " 'Corporate Bonds',\n",
-       " 'International Government Bonds',\n",
-       " 'Municipal Bonds',\n",
-       " 'U.S. Agency Bonds',\n",
-       " 'U.S. Treasury Securities'}"
-      ]
-     },
-     "execution_count": 5,
-     "metadata": {},
-     "output_type": "execute_result"
-    }
-   ],
+   "outputs": [],
    "source": [
     "all_asset_types = set([op_df.loc[i]['Asset Type'] for i in op_df.index]);all_asset_types"
    ]
@@ -413,20 +100,10 @@
   },
   {
    "cell_type": "code",
-   "execution_count": 6,
+   "execution_count": null,
    "id": "fe124c92",
    "metadata": {},
-   "outputs": [
-    {
-     "name": "stdout",
-     "output_type": "stream",
-     "text": [
-      "Corperate Bond Totals\n",
-      "Cost Value\t $1,020,500,769.44\n",
-      "Market Value\t $985,000,673.71\n"
-     ]
-    }
-   ],
+   "outputs": [],
    "source": [
     "cb_df = op_df[op_df['Asset Type'].str.contains(\"Corporate Bonds\", na=False)]\n",
     "print(\"Corperate Bond Totals\")\n",
@@ -457,7 +134,7 @@
   },
   {
    "cell_type": "code",
-   "execution_count": 7,
+   "execution_count": null,
    "id": "d78a9733",
    "metadata": {},
    "outputs": [],
@@ -556,7 +233,7 @@
   },
   {
    "cell_type": "code",
-   "execution_count": 8,
+   "execution_count": null,
    "id": "659c0ba7",
    "metadata": {},
    "outputs": [],
@@ -588,21 +265,10 @@
   },
   {
    "cell_type": "code",
-   "execution_count": 9,
+   "execution_count": null,
    "id": "0ba92284",
    "metadata": {},
-   "outputs": [
-    {
-     "data": {
-      "text/plain": [
-       "408"
-      ]
-     },
-     "execution_count": 9,
-     "metadata": {},
-     "output_type": "execute_result"
-    }
-   ],
+   "outputs": [],
    "source": [
     "len(company_names)"
    ]
@@ -617,252 +283,10 @@
   },
   {
    "cell_type": "code",
-   "execution_count": 10,
+   "execution_count": null,
    "id": "e7e06dfe",
    "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>Account or Security</th>\n",
-       "      <th>Coupon</th>\n",
-       "      <th>Date</th>\n",
-       "      <th>Quantity</th>\n",
-       "      <th>Cost Value</th>\n",
-       "      <th>Market Value</th>\n",
-       "      <th>Bank</th>\n",
-       "      <th>Asset Type</th>\n",
-       "      <th>Company</th>\n",
-       "      <th>Industry</th>\n",
-       "      <th>Private Placement</th>\n",
-       "    </tr>\n",
-       "  </thead>\n",
-       "  <tbody>\n",
-       "    <tr>\n",
-       "      <th>103</th>\n",
-       "      <td>Corporate Bonds</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>NaN</td>\n",
-       "      <td>9-200100-Neuberger Intermediate</td>\n",
-       "      <td>Corporate Bonds</td>\n",
-       "      <td>Corporate Bonds</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>False</td>\n",
-       "    </tr>\n",
-       "    <tr>\n",
-       "      <th>104</th>\n",
-       "      <td>ABBVIE INC 2.6% DUE 11-21-2024</td>\n",
-       "      <td>2.6</td>\n",
-       "      <td>2024-11-21 00:00:00</td>\n",
-       "      <td>1065000.0</td>\n",
-       "      <td>1135158.13</td>\n",
-       "      <td>1030877.86</td>\n",
-       "      <td>9-200100-Neuberger Intermediate</td>\n",
-       "      <td>Corporate Bonds</td>\n",
-       "      <td>ABBVIE  INC</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>False</td>\n",
-       "    </tr>\n",
-       "    <tr>\n",
-       "      <th>105</th>\n",
-       "      <td>ABBVIE INC 2.95% DUE</td>\n",
-       "      <td>2.95</td>\n",
-       "      <td>2026-11-21 00:00:00</td>\n",
-       "      <td>495000.0</td>\n",
-       "      <td>545836.80</td>\n",
-       "      <td>469035.55</td>\n",
-       "      <td>9-200100-Neuberger Intermediate</td>\n",
-       "      <td>Corporate Bonds</td>\n",
-       "      <td>ABBVIE  INC</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>False</td>\n",
-       "    </tr>\n",
-       "    <tr>\n",
-       "      <th>106</th>\n",
-       "      <td>AERCAP IRELAND CAP / GLOBA 3.0</td>\n",
-       "      <td>3</td>\n",
-       "      <td>2028-10-29 00:00:00</td>\n",
-       "      <td>440000.0</td>\n",
-       "      <td>439199.20</td>\n",
-       "      <td>370620.29</td>\n",
-       "      <td>9-200100-Neuberger Intermediate</td>\n",
-       "      <td>Corporate Bonds</td>\n",
-       "      <td>AERCAP IRELAND  CAP</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>False</td>\n",
-       "    </tr>\n",
-       "    <tr>\n",
-       "      <th>107</th>\n",
-       "      <td>AERCAP IRELAND CAP / GLOBA</td>\n",
-       "      <td>3.56</td>\n",
-       "      <td>1932-01-30 00:00:00</td>\n",
-       "      <td>430000.0</td>\n",
-       "      <td>428383.20</td>\n",
-       "      <td>344211.28</td>\n",
-       "      <td>9-200100-Neuberger Intermediate</td>\n",
-       "      <td>Corporate Bonds</td>\n",
-       "      <td>AERCAP IRELAND  CAP</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>False</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",
-       "    </tr>\n",
-       "    <tr>\n",
-       "      <th>2706</th>\n",
-       "      <td>UBS AG LONDON BRH NT FLTG RATE</td>\n",
-       "      <td>1.39</td>\n",
-       "      <td>2024-08-09 00:00:00</td>\n",
-       "      <td>1766000.0</td>\n",
-       "      <td>1766000.00</td>\n",
-       "      <td>1754003.40</td>\n",
-       "      <td>9-200100-JP Morgan Managed Reserves</td>\n",
-       "      <td>Corporate Bonds</td>\n",
-       "      <td>UBS AG LONDON</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>False</td>\n",
-       "    </tr>\n",
-       "    <tr>\n",
-       "      <th>2707</th>\n",
-       "      <td>UBS GROUP FDG SWITZ AG NT FLTG</td>\n",
-       "      <td>2.36</td>\n",
-       "      <td>2023-08-15 00:00:00</td>\n",
-       "      <td>2000000.0</td>\n",
-       "      <td>1999460.00</td>\n",
-       "      <td>1999374.24</td>\n",
-       "      <td>9-200100-JP Morgan Managed Reserves</td>\n",
-       "      <td>Corporate Bonds</td>\n",
-       "      <td>UBS AG LONDON</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>False</td>\n",
-       "    </tr>\n",
-       "    <tr>\n",
-       "      <th>2708</th>\n",
-       "      <td>UNITED PARCEL SVC INC 2.45% DU</td>\n",
-       "      <td>2.45</td>\n",
-       "      <td>2022-10-01 00:00:00</td>\n",
-       "      <td>145000.0</td>\n",
-       "      <td>148575.70</td>\n",
-       "      <td>144922.71</td>\n",
-       "      <td>9-200100-JP Morgan Managed Reserves</td>\n",
-       "      <td>Corporate Bonds</td>\n",
-       "      <td>UNITED PARCEL SVC  INC</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>False</td>\n",
-       "    </tr>\n",
-       "    <tr>\n",
-       "      <th>2709</th>\n",
-       "      <td>WESTPAC BKG CORP 2.0% DUE 01-1</td>\n",
-       "      <td>2</td>\n",
-       "      <td>2023-01-13 00:00:00</td>\n",
-       "      <td>72000.0</td>\n",
-       "      <td>73785.60</td>\n",
-       "      <td>71637.73</td>\n",
-       "      <td>9-200100-JP Morgan Managed Reserves</td>\n",
-       "      <td>Corporate Bonds</td>\n",
-       "      <td>WESTPAC BANKING</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>False</td>\n",
-       "    </tr>\n",
-       "    <tr>\n",
-       "      <th>2710</th>\n",
-       "      <td>WESTPAC BKG CORP 2.75% DUE 01-</td>\n",
-       "      <td>2.75</td>\n",
-       "      <td>2023-01-11 00:00:00</td>\n",
-       "      <td>2497000.0</td>\n",
-       "      <td>2589713.61</td>\n",
-       "      <td>2492680.54</td>\n",
-       "      <td>9-200100-JP Morgan Managed Reserves</td>\n",
-       "      <td>Corporate Bonds</td>\n",
-       "      <td>WESTPAC BANKING</td>\n",
-       "      <td>&lt;NA&gt;</td>\n",
-       "      <td>False</td>\n",
-       "    </tr>\n",
-       "  </tbody>\n",
-       "</table>\n",
-       "<p>1222 rows × 11 columns</p>\n",
-       "</div>"
-      ],
-      "text/plain": [
-       "                 Account or Security Coupon                 Date   Quantity  \\\n",
-       "103                  Corporate Bonds    NaN                  NaN        NaN   \n",
-       "104   ABBVIE INC 2.6% DUE 11-21-2024    2.6  2024-11-21 00:00:00  1065000.0   \n",
-       "105            ABBVIE INC 2.95% DUE    2.95  2026-11-21 00:00:00   495000.0   \n",
-       "106   AERCAP IRELAND CAP / GLOBA 3.0      3  2028-10-29 00:00:00   440000.0   \n",
-       "107      AERCAP IRELAND CAP / GLOBA    3.56  1932-01-30 00:00:00   430000.0   \n",
-       "...                              ...    ...                  ...        ...   \n",
-       "2706  UBS AG LONDON BRH NT FLTG RATE   1.39  2024-08-09 00:00:00  1766000.0   \n",
-       "2707  UBS GROUP FDG SWITZ AG NT FLTG   2.36  2023-08-15 00:00:00  2000000.0   \n",
-       "2708  UNITED PARCEL SVC INC 2.45% DU   2.45  2022-10-01 00:00:00   145000.0   \n",
-       "2709  WESTPAC BKG CORP 2.0% DUE 01-1      2  2023-01-13 00:00:00    72000.0   \n",
-       "2710  WESTPAC BKG CORP 2.75% DUE 01-   2.75  2023-01-11 00:00:00  2497000.0   \n",
-       "\n",
-       "      Cost Value  Market Value                                 Bank  \\\n",
-       "103          NaN           NaN      9-200100-Neuberger Intermediate   \n",
-       "104   1135158.13    1030877.86      9-200100-Neuberger Intermediate   \n",
-       "105    545836.80     469035.55      9-200100-Neuberger Intermediate   \n",
-       "106    439199.20     370620.29      9-200100-Neuberger Intermediate   \n",
-       "107    428383.20     344211.28      9-200100-Neuberger Intermediate   \n",
-       "...          ...           ...                                  ...   \n",
-       "2706  1766000.00    1754003.40  9-200100-JP Morgan Managed Reserves   \n",
-       "2707  1999460.00    1999374.24  9-200100-JP Morgan Managed Reserves   \n",
-       "2708   148575.70     144922.71  9-200100-JP Morgan Managed Reserves   \n",
-       "2709    73785.60      71637.73  9-200100-JP Morgan Managed Reserves   \n",
-       "2710  2589713.61    2492680.54  9-200100-JP Morgan Managed Reserves   \n",
-       "\n",
-       "           Asset Type                 Company Industry  Private Placement  \n",
-       "103   Corporate Bonds         Corporate Bonds     <NA>              False  \n",
-       "104   Corporate Bonds             ABBVIE  INC     <NA>              False  \n",
-       "105   Corporate Bonds             ABBVIE  INC     <NA>              False  \n",
-       "106   Corporate Bonds     AERCAP IRELAND  CAP     <NA>              False  \n",
-       "107   Corporate Bonds     AERCAP IRELAND  CAP     <NA>              False  \n",
-       "...               ...                     ...      ...                ...  \n",
-       "2706  Corporate Bonds           UBS AG LONDON     <NA>              False  \n",
-       "2707  Corporate Bonds           UBS AG LONDON     <NA>              False  \n",
-       "2708  Corporate Bonds  UNITED PARCEL SVC  INC     <NA>              False  \n",
-       "2709  Corporate Bonds         WESTPAC BANKING     <NA>              False  \n",
-       "2710  Corporate Bonds         WESTPAC BANKING     <NA>              False  \n",
-       "\n",
-       "[1222 rows x 11 columns]"
-      ]
-     },
-     "execution_count": 10,
-     "metadata": {},
-     "output_type": "execute_result"
-    }
-   ],
+   "outputs": [],
    "source": [
     "cb_df"
    ]
@@ -877,19 +301,10 @@
   },
   {
    "cell_type": "code",
-   "execution_count": 11,
+   "execution_count": null,
    "id": "6fe3d0df",
    "metadata": {},
-   "outputs": [
-    {
-     "name": "stdout",
-     "output_type": "stream",
-     "text": [
-      "WARNING: No decryption keys could be extracted from JS file. Falling back to backup decrypt methods.\n",
-      "Drug Manufacturers—General\n"
-     ]
-    }
-   ],
+   "outputs": [],
    "source": [
     "# Replace \"company_name\" with the name of the company you're searching for\n",
     "company_name = \"ABBV\"\n",