CompanySeleniumMultiple.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "6b929474",
   "metadata": {},
   "outputs": [],
   "source": [
    "from Quantamental_functions import *\n",
    "\n",
    "%load_ext autoreload\n",
    "%autoreload 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "0873bfc9",
   "metadata": {},
   "outputs": [],
   "source": [
    "pd.set_option('display.float_format', lambda x: '%.2f' % x)\n",
    "pd.options.display.max_columns = 99999"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "33b852fc",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "[*********************100%%**********************]  1 of 1 completed\n"
     ]
    }
   ],
   "source": [
    "start_year, end_year = 2019, 2024\n",
    "start_date = datetime(start_year, 1, 1)\n",
    "end_date = datetime(end_year, 4, 1)\n",
    "bond_ticker = \"^IRX\"\n",
    "bond_yield = get_data(bond_ticker, start_date, end_date) / 100\n",
    "company_info = fetch_company_info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "e6ce643c",
   "metadata": {},
   "outputs": [],
   "source": [
    "form_type = \"10-Q\"\n",
    "dateb = \"20240101\"\n",
    "ciks = ['0000789019', '0001652044', '0001018724', '0001318605', '0001326801', '0000069488', '0000930420', '0000104169', '0000354950', '0001045810', '0000021344', '0001874178', '0000097210', '0001409171', '0000722313', '0000819793', '0000097476', '0000815556', '0000042888', '0001121788']\n",
    "tickers = ['MSFT', 'GOOG', 'AMZN', 'TSLA', 'META', 'MYE', 'KFRC', 'WMT', 'HD', 'NVDA', 'KO', 'RIVN', 'TER', 'TITN', 'NSYS', 'AIN', 'TXN', 'FAST', 'GGG', 'GRMN']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "49f39170",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CF DataFrame for MSFT\n",
      "BS DataFrame for MSFT\n",
      "IS DataFrame for MSFT\n",
      "CF DataFrame for RIVN\n",
      "BS DataFrame for RIVN\n",
      "IS DataFrame for RIVN\n",
      "CF DataFrame for META\n",
      "BS DataFrame for META\n",
      "IS DataFrame for META\n",
      "CF DataFrame for TER\n",
      "BS DataFrame for TER\n",
      "IS DataFrame for TER\n",
      "CF DataFrame for KO\n",
      "BS DataFrame for KO\n",
      "IS DataFrame for KO\n",
      "CF DataFrame for GOOG\n",
      "BS DataFrame for GOOG\n",
      "IS DataFrame for GOOG\n",
      "CF DataFrame for KFRC\n",
      "BS DataFrame for KFRC\n",
      "IS DataFrame for KFRC\n",
      "CF DataFrame for MYE\n",
      "BS DataFrame for MYE\n",
      "IS DataFrame for MYE\n",
      "CF DataFrame for AIN\n",
      "BS DataFrame for AIN\n",
      "IS DataFrame for AIN\n",
      "CF DataFrame for GGG\n",
      "BS DataFrame for GGG\n",
      "IS DataFrame for GGG\n",
      "CF DataFrame for NVDA\n",
      "BS DataFrame for NVDA\n",
      "IS DataFrame for NVDA\n",
      "CF DataFrame for TXN\n",
      "BS DataFrame for TXN\n",
      "IS DataFrame for TXN\n",
      "CF DataFrame for FAST\n",
      "BS DataFrame for FAST\n",
      "IS DataFrame for FAST\n",
      "CF DataFrame for TSLA\n",
      "BS DataFrame for TSLA\n",
      "IS DataFrame for TSLA\n",
      "CF DataFrame for GRMN\n",
      "BS DataFrame for GRMN\n",
      "IS DataFrame for GRMN\n",
      "CF DataFrame for NSYS\n",
      "BS DataFrame for NSYS\n",
      "IS DataFrame for NSYS\n",
      "CF DataFrame for WMT\n",
      "BS DataFrame for WMT\n",
      "IS DataFrame for WMT\n",
      "CF DataFrame for HD\n",
      "BS DataFrame for HD\n",
      "IS DataFrame for HD\n",
      "CF DataFrame for AMZN\n",
      "BS DataFrame for AMZN\n",
      "IS DataFrame for AMZN\n",
      "CF DataFrame for TITN\n",
      "BS DataFrame for TITN\n",
      "IS DataFrame for TITN\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "[*********************100%%**********************]  1 of 1 completed\n",
      "[*********************100%%**********************]  1 of 1 completed\n",
      "[*********************100%%**********************]  1 of 1 completed\n",
      "[*********************100%%**********************]  1 of 1 completed\n",
      "[*********************100%%**********************]  1 of 1 completed\n",
      "[*********************100%%**********************]  1 of 1 completed\n",
      "[*********************100%%**********************]  1 of 1 completed\n",
      "[*********************100%%**********************]  1 of 1 completed\n",
      "[*********************100%%**********************]  1 of 1 completed\n",
      "[*********************100%%**********************]  1 of 1 completed\n",
      "[*********************100%%**********************]  1 of 1 completed\n",
      "[*********************100%%**********************]  1 of 1 completed\n",
      "[*********************100%%**********************]  1 of 1 completed\n",
      "[*********************100%%**********************]  1 of 1 completed\n",
      "[*********************100%%**********************]  1 of 1 completed\n",
      "[*********************100%%**********************]  1 of 1 completed\n",
      "[*********************100%%**********************]  1 of 1 completed\n",
      "[*********************100%%**********************]  1 of 1 completed\n",
      "[*********************100%%**********************]  1 of 1 completed\n",
      "[*********************100%%**********************]  1 of 1 completed\n"
     ]
    }
   ],
   "source": [
    "selenium_cf_dfs, selenium_bs_dfs, selenium_is_dfs = get_consolidated_dfs(ciks, tickers, form_type, dateb)\n",
    "selenium_df = combine_combo_dfs(selenium_cf_dfs, selenium_bs_dfs, selenium_is_dfs, tickers, bond_yield, start_date, end_date)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "3ff145ea",
   "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>cik_str</th>\n",
       "      <th>ticker</th>\n",
       "      <th>title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1018724</td>\n",
       "      <td>AMZN</td>\n",
       "      <td>AMAZON COM INC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>723</th>\n",
       "      <td>1086222</td>\n",
       "      <td>AKAM</td>\n",
       "      <td>AKAMAI TECHNOLOGIES INC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>788</th>\n",
       "      <td>1090425</td>\n",
       "      <td>LAMR</td>\n",
       "      <td>LAMAR ADVERTISING CO/NEW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>944</th>\n",
       "      <td>1584509</td>\n",
       "      <td>ARMK</td>\n",
       "      <td>ARAMARK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2042</th>\n",
       "      <td>1503584</td>\n",
       "      <td>CMRE</td>\n",
       "      <td>COSTAMARE INC.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2777</th>\n",
       "      <td>1823608</td>\n",
       "      <td>AMAL</td>\n",
       "      <td>AMALGAMATED FINANCIAL CORP.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3002</th>\n",
       "      <td>1687187</td>\n",
       "      <td>METC</td>\n",
       "      <td>RAMACO RESOURCES, INC.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3667</th>\n",
       "      <td>1567529</td>\n",
       "      <td>KMDA</td>\n",
       "      <td>KAMADA LTD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3686</th>\n",
       "      <td>897448</td>\n",
       "      <td>AMRN</td>\n",
       "      <td>AMARIN CORP PLC\\UK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3842</th>\n",
       "      <td>1520358</td>\n",
       "      <td>MAMA</td>\n",
       "      <td>MAMA'S CREATIONS, INC.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5840</th>\n",
       "      <td>1175596</td>\n",
       "      <td>AXREF</td>\n",
       "      <td>AMARC RESOURCES LTD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6368</th>\n",
       "      <td>1884072</td>\n",
       "      <td>JEWL</td>\n",
       "      <td>ADAMAS ONE CORP.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7830</th>\n",
       "      <td>1447100</td>\n",
       "      <td>YAMHF</td>\n",
       "      <td>YAMAHA MOTOR CO., LTD.</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      cik_str ticker                        title\n",
       "4     1018724   AMZN               AMAZON COM INC\n",
       "723   1086222   AKAM      AKAMAI TECHNOLOGIES INC\n",
       "788   1090425   LAMR     LAMAR ADVERTISING CO/NEW\n",
       "944   1584509   ARMK                      ARAMARK\n",
       "2042  1503584   CMRE               COSTAMARE INC.\n",
       "2777  1823608   AMAL  AMALGAMATED FINANCIAL CORP.\n",
       "3002  1687187   METC       RAMACO RESOURCES, INC.\n",
       "3667  1567529   KMDA                   KAMADA LTD\n",
       "3686   897448   AMRN           AMARIN CORP PLC\\UK\n",
       "3842  1520358   MAMA       MAMA'S CREATIONS, INC.\n",
       "5840  1175596  AXREF          AMARC RESOURCES LTD\n",
       "6368  1884072   JEWL             ADAMAS ONE CORP.\n",
       "7830  1447100  YAMHF       YAMAHA MOTOR CO., LTD."
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "user_title = input(\"Enter the company name: \").upper()\n",
    "filtered_companies = company_info[company_info['title'].str.contains(user_title, na=False)]\n",
    "filtered_companies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "f504dae2",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Ticker: AMZN\n",
      "AMZN cannot be classified due to insufficient data.\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>accounts payable</th>\n",
       "      <th>accounts receivable</th>\n",
       "      <th>accrued expenses and other</th>\n",
       "      <th>basic earnings per share</th>\n",
       "      <th>capex</th>\n",
       "      <th>cash and cash equivalents</th>\n",
       "      <th>cash flow from financing</th>\n",
       "      <th>cash flow from investing</th>\n",
       "      <th>cash flow from operations</th>\n",
       "      <th>change in cash</th>\n",
       "      <th>cost of sales</th>\n",
       "      <th>depreciation and amortization</th>\n",
       "      <th>diluted earnings per share</th>\n",
       "      <th>goodwill</th>\n",
       "      <th>income before income taxes</th>\n",
       "      <th>inventories</th>\n",
       "      <th>long term debt</th>\n",
       "      <th>marketable securities</th>\n",
       "      <th>net income</th>\n",
       "      <th>nshares</th>\n",
       "      <th>operating income</th>\n",
       "      <th>operating leases</th>\n",
       "      <th>retained earnings</th>\n",
       "      <th>tangible assets</th>\n",
       "      <th>total assets</th>\n",
       "      <th>total current assets</th>\n",
       "      <th>total current liabilities</th>\n",
       "      <th>total liabilities and equity</th>\n",
       "      <th>total non operating expenses</th>\n",
       "      <th>total operating expenses</th>\n",
       "      <th>total revenues</th>\n",
       "      <th>total shareholders equity</th>\n",
       "      <th>bond_yield</th>\n",
       "      <th>share_price</th>\n",
       "      <th>eps growth rate</th>\n",
       "      <th>intrinsic value</th>\n",
       "      <th>owner earnings</th>\n",
       "      <th>invested capital</th>\n",
       "      <th>roic</th>\n",
       "      <th>current ratio</th>\n",
       "      <th>net current assets</th>\n",
       "      <th>bvps</th>\n",
       "      <th>pe ratio</th>\n",
       "      <th>pb ratio</th>\n",
       "      <th>multiplier pb</th>\n",
       "      <th>margin safety</th>\n",
       "      <th>total debt</th>\n",
       "      <th>tbvps</th>\n",
       "      <th>ncav</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",
       "      <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",
       "      <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>30-09-2013</th>\n",
       "      <td>10037.00</td>\n",
       "      <td>3057.00</td>\n",
       "      <td>6098.00</td>\n",
       "      <td>-0.09</td>\n",
       "      <td>-1038.00</td>\n",
       "      <td>3872.00</td>\n",
       "      <td>-230.00</td>\n",
       "      <td>-1063.00</td>\n",
       "      <td>1388.00</td>\n",
       "      <td>168.00</td>\n",
       "      <td>12366.00</td>\n",
       "      <td>834.00</td>\n",
       "      <td>-0.09</td>\n",
       "      <td>2635.00</td>\n",
       "      <td>-43.00</td>\n",
       "      <td>6068.00</td>\n",
       "      <td>3043.00</td>\n",
       "      <td>3817.00</td>\n",
       "      <td>-41.00</td>\n",
       "      <td>455</td>\n",
       "      <td>-25.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1950.00</td>\n",
       "      <td>9991.00</td>\n",
       "      <td>31861.00</td>\n",
       "      <td>17334.00</td>\n",
       "      <td>16135.00</td>\n",
       "      <td>31861.00</td>\n",
       "      <td>-18.00</td>\n",
       "      <td>17117.00</td>\n",
       "      <td>17092.00</td>\n",
       "      <td>9087.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>997.00</td>\n",
       "      <td>40307.00</td>\n",
       "      <td>0.02</td>\n",
       "      <td>1.07</td>\n",
       "      <td>1199.00</td>\n",
       "      <td>19.97</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22774.00</td>\n",
       "      <td>21.96</td>\n",
       "      <td>-11.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31-03-2014</th>\n",
       "      <td>10590.00</td>\n",
       "      <td>3945.00</td>\n",
       "      <td>6251.00</td>\n",
       "      <td>0.23</td>\n",
       "      <td>-1080.00</td>\n",
       "      <td>5074.00</td>\n",
       "      <td>-175.00</td>\n",
       "      <td>-924.00</td>\n",
       "      <td>-2502.00</td>\n",
       "      <td>-3584.00</td>\n",
       "      <td>14055.00</td>\n",
       "      <td>1010.00</td>\n",
       "      <td>0.23</td>\n",
       "      <td>2653.00</td>\n",
       "      <td>120.00</td>\n",
       "      <td>6716.00</td>\n",
       "      <td>3147.00</td>\n",
       "      <td>3592.00</td>\n",
       "      <td>108.00</td>\n",
       "      <td>469</td>\n",
       "      <td>146.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2298.00</td>\n",
       "      <td>12267.00</td>\n",
       "      <td>36364.00</td>\n",
       "      <td>19327.00</td>\n",
       "      <td>18357.00</td>\n",
       "      <td>36364.00</td>\n",
       "      <td>-26.00</td>\n",
       "      <td>19595.00</td>\n",
       "      <td>19741.00</td>\n",
       "      <td>10328.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-3.56</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1188.00</td>\n",
       "      <td>44539.00</td>\n",
       "      <td>0.03</td>\n",
       "      <td>1.05</td>\n",
       "      <td>970.00</td>\n",
       "      <td>22.02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26036.00</td>\n",
       "      <td>26.16</td>\n",
       "      <td>-14.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30-06-2014</th>\n",
       "      <td>10457.00</td>\n",
       "      <td>4125.00</td>\n",
       "      <td>6688.00</td>\n",
       "      <td>-0.27</td>\n",
       "      <td>-1290.00</td>\n",
       "      <td>5057.00</td>\n",
       "      <td>-189.00</td>\n",
       "      <td>-731.00</td>\n",
       "      <td>862.00</td>\n",
       "      <td>-17.00</td>\n",
       "      <td>13399.00</td>\n",
       "      <td>1109.00</td>\n",
       "      <td>-0.27</td>\n",
       "      <td>2677.00</td>\n",
       "      <td>-27.00</td>\n",
       "      <td>6644.00</td>\n",
       "      <td>3119.00</td>\n",
       "      <td>2929.00</td>\n",
       "      <td>-126.00</td>\n",
       "      <td>466</td>\n",
       "      <td>-15.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2172.00</td>\n",
       "      <td>14089.00</td>\n",
       "      <td>37898.00</td>\n",
       "      <td>18755.00</td>\n",
       "      <td>18751.00</td>\n",
       "      <td>37898.00</td>\n",
       "      <td>-12.00</td>\n",
       "      <td>19355.00</td>\n",
       "      <td>19340.00</td>\n",
       "      <td>10602.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-2.17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1164.00</td>\n",
       "      <td>47057.00</td>\n",
       "      <td>0.02</td>\n",
       "      <td>1.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>22.75</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27296.00</td>\n",
       "      <td>30.23</td>\n",
       "      <td>-18.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30-09-2014</th>\n",
       "      <td>11811.00</td>\n",
       "      <td>4373.00</td>\n",
       "      <td>7217.00</td>\n",
       "      <td>-0.95</td>\n",
       "      <td>-1378.00</td>\n",
       "      <td>5258.00</td>\n",
       "      <td>-412.00</td>\n",
       "      <td>-946.00</td>\n",
       "      <td>1766.00</td>\n",
       "      <td>201.00</td>\n",
       "      <td>14627.00</td>\n",
       "      <td>1247.00</td>\n",
       "      <td>-0.95</td>\n",
       "      <td>3332.00</td>\n",
       "      <td>-634.00</td>\n",
       "      <td>7316.00</td>\n",
       "      <td>3099.00</td>\n",
       "      <td>1625.00</td>\n",
       "      <td>-437.00</td>\n",
       "      <td>460</td>\n",
       "      <td>-544.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1735.00</td>\n",
       "      <td>15702.00</td>\n",
       "      <td>40419.00</td>\n",
       "      <td>18572.00</td>\n",
       "      <td>20842.00</td>\n",
       "      <td>40419.00</td>\n",
       "      <td>-90.00</td>\n",
       "      <td>21123.00</td>\n",
       "      <td>20579.00</td>\n",
       "      <td>10336.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.52</td>\n",
       "      <td>NaN</td>\n",
       "      <td>941.00</td>\n",
       "      <td>52564.00</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.89</td>\n",
       "      <td>-2270.00</td>\n",
       "      <td>22.47</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30083.00</td>\n",
       "      <td>34.13</td>\n",
       "      <td>-25.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31-03-2015</th>\n",
       "      <td>11917.00</td>\n",
       "      <td>4772.00</td>\n",
       "      <td>8840.00</td>\n",
       "      <td>-0.12</td>\n",
       "      <td>-871.00</td>\n",
       "      <td>10237.00</td>\n",
       "      <td>-652.00</td>\n",
       "      <td>-1847.00</td>\n",
       "      <td>-1499.00</td>\n",
       "      <td>-4320.00</td>\n",
       "      <td>15395.00</td>\n",
       "      <td>1426.00</td>\n",
       "      <td>-0.12</td>\n",
       "      <td>3491.00</td>\n",
       "      <td>21.00</td>\n",
       "      <td>7369.00</td>\n",
       "      <td>8257.00</td>\n",
       "      <td>3544.00</td>\n",
       "      <td>-57.00</td>\n",
       "      <td>475</td>\n",
       "      <td>255.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1892.00</td>\n",
       "      <td>17736.00</td>\n",
       "      <td>50075.00</td>\n",
       "      <td>25922.00</td>\n",
       "      <td>23177.00</td>\n",
       "      <td>50075.00</td>\n",
       "      <td>-234.00</td>\n",
       "      <td>22462.00</td>\n",
       "      <td>22717.00</td>\n",
       "      <td>10873.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.87</td>\n",
       "      <td>NaN</td>\n",
       "      <td>814.00</td>\n",
       "      <td>57051.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1.12</td>\n",
       "      <td>2745.00</td>\n",
       "      <td>22.89</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>39202.00</td>\n",
       "      <td>37.34</td>\n",
       "      <td>-27.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30-06-2015</th>\n",
       "      <td>12391.00</td>\n",
       "      <td>4920.00</td>\n",
       "      <td>8959.00</td>\n",
       "      <td>0.20</td>\n",
       "      <td>-1213.00</td>\n",
       "      <td>10269.00</td>\n",
       "      <td>-691.00</td>\n",
       "      <td>-1376.00</td>\n",
       "      <td>1997.00</td>\n",
       "      <td>32.00</td>\n",
       "      <td>15160.00</td>\n",
       "      <td>1504.00</td>\n",
       "      <td>0.19</td>\n",
       "      <td>3523.00</td>\n",
       "      <td>362.00</td>\n",
       "      <td>7470.00</td>\n",
       "      <td>8250.00</td>\n",
       "      <td>3732.00</td>\n",
       "      <td>92.00</td>\n",
       "      <td>484</td>\n",
       "      <td>464.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1984.00</td>\n",
       "      <td>19479.00</td>\n",
       "      <td>52440.00</td>\n",
       "      <td>26391.00</td>\n",
       "      <td>23912.00</td>\n",
       "      <td>52440.00</td>\n",
       "      <td>-102.00</td>\n",
       "      <td>22721.00</td>\n",
       "      <td>23185.00</td>\n",
       "      <td>11768.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-2.58</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1305.00</td>\n",
       "      <td>59789.00</td>\n",
       "      <td>0.02</td>\n",
       "      <td>1.10</td>\n",
       "      <td>2479.00</td>\n",
       "      <td>24.31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40672.00</td>\n",
       "      <td>40.25</td>\n",
       "      <td>-29.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30-09-2015</th>\n",
       "      <td>14437.00</td>\n",
       "      <td>5440.00</td>\n",
       "      <td>9157.00</td>\n",
       "      <td>0.17</td>\n",
       "      <td>-1195.00</td>\n",
       "      <td>10709.00</td>\n",
       "      <td>-730.00</td>\n",
       "      <td>-1377.00</td>\n",
       "      <td>2610.00</td>\n",
       "      <td>440.00</td>\n",
       "      <td>16755.00</td>\n",
       "      <td>1599.00</td>\n",
       "      <td>0.17</td>\n",
       "      <td>3529.00</td>\n",
       "      <td>247.00</td>\n",
       "      <td>8981.00</td>\n",
       "      <td>8243.00</td>\n",
       "      <td>3719.00</td>\n",
       "      <td>79.00</td>\n",
       "      <td>464</td>\n",
       "      <td>406.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2063.00</td>\n",
       "      <td>20636.00</td>\n",
       "      <td>56230.00</td>\n",
       "      <td>28849.00</td>\n",
       "      <td>26657.00</td>\n",
       "      <td>56230.00</td>\n",
       "      <td>-159.00</td>\n",
       "      <td>24952.00</td>\n",
       "      <td>25358.00</td>\n",
       "      <td>12430.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1274.00</td>\n",
       "      <td>65396.00</td>\n",
       "      <td>0.02</td>\n",
       "      <td>1.08</td>\n",
       "      <td>2192.00</td>\n",
       "      <td>26.79</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43800.00</td>\n",
       "      <td>44.47</td>\n",
       "      <td>-32.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31-03-2016</th>\n",
       "      <td>14990.00</td>\n",
       "      <td>5072.00</td>\n",
       "      <td>9431.00</td>\n",
       "      <td>1.09</td>\n",
       "      <td>-1179.00</td>\n",
       "      <td>12470.00</td>\n",
       "      <td>-789.00</td>\n",
       "      <td>-693.00</td>\n",
       "      <td>-2160.00</td>\n",
       "      <td>-3420.00</td>\n",
       "      <td>18866.00</td>\n",
       "      <td>1827.00</td>\n",
       "      <td>1.07</td>\n",
       "      <td>3785.00</td>\n",
       "      <td>1056.00</td>\n",
       "      <td>9582.00</td>\n",
       "      <td>8219.00</td>\n",
       "      <td>3389.00</td>\n",
       "      <td>513.00</td>\n",
       "      <td>479</td>\n",
       "      <td>1071.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3058.00</td>\n",
       "      <td>23308.00</td>\n",
       "      <td>61128.00</td>\n",
       "      <td>30513.00</td>\n",
       "      <td>28187.00</td>\n",
       "      <td>61128.00</td>\n",
       "      <td>-15.00</td>\n",
       "      <td>28057.00</td>\n",
       "      <td>29128.00</td>\n",
       "      <td>14756.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1692.00</td>\n",
       "      <td>69690.00</td>\n",
       "      <td>0.02</td>\n",
       "      <td>1.08</td>\n",
       "      <td>2326.00</td>\n",
       "      <td>30.81</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>46372.00</td>\n",
       "      <td>48.66</td>\n",
       "      <td>-33.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30-06-2016</th>\n",
       "      <td>16123.00</td>\n",
       "      <td>6092.00</td>\n",
       "      <td>9613.00</td>\n",
       "      <td>1.81</td>\n",
       "      <td>-1711.00</td>\n",
       "      <td>12521.00</td>\n",
       "      <td>-1039.00</td>\n",
       "      <td>-2439.00</td>\n",
       "      <td>3465.00</td>\n",
       "      <td>51.00</td>\n",
       "      <td>19180.00</td>\n",
       "      <td>1909.00</td>\n",
       "      <td>1.78</td>\n",
       "      <td>3774.00</td>\n",
       "      <td>1179.00</td>\n",
       "      <td>9588.00</td>\n",
       "      <td>8212.00</td>\n",
       "      <td>4019.00</td>\n",
       "      <td>857.00</td>\n",
       "      <td>481</td>\n",
       "      <td>1285.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3915.00</td>\n",
       "      <td>25190.00</td>\n",
       "      <td>65076.00</td>\n",
       "      <td>32220.00</td>\n",
       "      <td>29587.00</td>\n",
       "      <td>65076.00</td>\n",
       "      <td>-106.00</td>\n",
       "      <td>29119.00</td>\n",
       "      <td>30404.00</td>\n",
       "      <td>16538.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.66</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2568.00</td>\n",
       "      <td>74272.00</td>\n",
       "      <td>0.03</td>\n",
       "      <td>1.09</td>\n",
       "      <td>2633.00</td>\n",
       "      <td>34.38</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>48538.00</td>\n",
       "      <td>52.37</td>\n",
       "      <td>-33.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30-09-2016</th>\n",
       "      <td>18801.00</td>\n",
       "      <td>6566.00</td>\n",
       "      <td>10497.00</td>\n",
       "      <td>0.53</td>\n",
       "      <td>-1841.00</td>\n",
       "      <td>13656.00</td>\n",
       "      <td>-827.00</td>\n",
       "      <td>-2570.00</td>\n",
       "      <td>4486.00</td>\n",
       "      <td>1135.00</td>\n",
       "      <td>21260.00</td>\n",
       "      <td>2084.00</td>\n",
       "      <td>0.52</td>\n",
       "      <td>3815.00</td>\n",
       "      <td>491.00</td>\n",
       "      <td>10696.00</td>\n",
       "      <td>8205.00</td>\n",
       "      <td>4691.00</td>\n",
       "      <td>252.00</td>\n",
       "      <td>484</td>\n",
       "      <td>575.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4167.00</td>\n",
       "      <td>27177.00</td>\n",
       "      <td>70897.00</td>\n",
       "      <td>35609.00</td>\n",
       "      <td>33498.00</td>\n",
       "      <td>70897.00</td>\n",
       "      <td>-84.00</td>\n",
       "      <td>32139.00</td>\n",
       "      <td>32714.00</td>\n",
       "      <td>17782.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.71</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2093.00</td>\n",
       "      <td>81848.00</td>\n",
       "      <td>0.03</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2111.00</td>\n",
       "      <td>36.74</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>53115.00</td>\n",
       "      <td>56.15</td>\n",
       "      <td>-36.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31-03-2017</th>\n",
       "      <td>18891.00</td>\n",
       "      <td>7329.00</td>\n",
       "      <td>13054.00</td>\n",
       "      <td>1.52</td>\n",
       "      <td>-1861.00</td>\n",
       "      <td>15440.00</td>\n",
       "      <td>-914.00</td>\n",
       "      <td>-1616.00</td>\n",
       "      <td>-1590.00</td>\n",
       "      <td>-3894.00</td>\n",
       "      <td>22440.00</td>\n",
       "      <td>2435.00</td>\n",
       "      <td>1.48</td>\n",
       "      <td>3823.00</td>\n",
       "      <td>953.00</td>\n",
       "      <td>10600.00</td>\n",
       "      <td>7691.00</td>\n",
       "      <td>6091.00</td>\n",
       "      <td>724.00</td>\n",
       "      <td>489</td>\n",
       "      <td>1005.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>6327.00</td>\n",
       "      <td>32632.00</td>\n",
       "      <td>80969.00</td>\n",
       "      <td>39460.00</td>\n",
       "      <td>37399.00</td>\n",
       "      <td>80969.00</td>\n",
       "      <td>-52.00</td>\n",
       "      <td>34709.00</td>\n",
       "      <td>35714.00</td>\n",
       "      <td>21674.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.85</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2585.00</td>\n",
       "      <td>91383.00</td>\n",
       "      <td>0.03</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2061.00</td>\n",
       "      <td>44.32</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>59295.00</td>\n",
       "      <td>66.73</td>\n",
       "      <td>-40.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30-06-2017</th>\n",
       "      <td>21439.00</td>\n",
       "      <td>8046.00</td>\n",
       "      <td>14016.00</td>\n",
       "      <td>0.41</td>\n",
       "      <td>-2501.00</td>\n",
       "      <td>13203.00</td>\n",
       "      <td>-1263.00</td>\n",
       "      <td>-5051.00</td>\n",
       "      <td>3829.00</td>\n",
       "      <td>-2237.00</td>\n",
       "      <td>23451.00</td>\n",
       "      <td>2633.00</td>\n",
       "      <td>0.40</td>\n",
       "      <td>4254.00</td>\n",
       "      <td>666.00</td>\n",
       "      <td>11510.00</td>\n",
       "      <td>7683.00</td>\n",
       "      <td>8248.00</td>\n",
       "      <td>197.00</td>\n",
       "      <td>492</td>\n",
       "      <td>628.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>6524.00</td>\n",
       "      <td>37083.00</td>\n",
       "      <td>87781.00</td>\n",
       "      <td>41007.00</td>\n",
       "      <td>40520.00</td>\n",
       "      <td>87781.00</td>\n",
       "      <td>38.00</td>\n",
       "      <td>37327.00</td>\n",
       "      <td>37955.00</td>\n",
       "      <td>23214.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.73</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2698.00</td>\n",
       "      <td>101785.00</td>\n",
       "      <td>0.03</td>\n",
       "      <td>1.01</td>\n",
       "      <td>487.00</td>\n",
       "      <td>47.18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>64567.00</td>\n",
       "      <td>75.37</td>\n",
       "      <td>-47.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30-09-2017</th>\n",
       "      <td>26075.00</td>\n",
       "      <td>10557.00</td>\n",
       "      <td>15844.00</td>\n",
       "      <td>0.53</td>\n",
       "      <td>-2659.00</td>\n",
       "      <td>12767.00</td>\n",
       "      <td>14685.00</td>\n",
       "      <td>-19120.00</td>\n",
       "      <td>3851.00</td>\n",
       "      <td>-436.00</td>\n",
       "      <td>27549.00</td>\n",
       "      <td>2912.00</td>\n",
       "      <td>0.52</td>\n",
       "      <td>13271.00</td>\n",
       "      <td>316.00</td>\n",
       "      <td>13711.00</td>\n",
       "      <td>24710.00</td>\n",
       "      <td>11543.00</td>\n",
       "      <td>256.00</td>\n",
       "      <td>492</td>\n",
       "      <td>347.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>6779.00</td>\n",
       "      <td>45335.00</td>\n",
       "      <td>115267.00</td>\n",
       "      <td>48578.00</td>\n",
       "      <td>47072.00</td>\n",
       "      <td>115267.00</td>\n",
       "      <td>-31.00</td>\n",
       "      <td>43397.00</td>\n",
       "      <td>43744.00</td>\n",
       "      <td>24658.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2915.00</td>\n",
       "      <td>132876.00</td>\n",
       "      <td>0.02</td>\n",
       "      <td>1.03</td>\n",
       "      <td>1506.00</td>\n",
       "      <td>50.12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>90609.00</td>\n",
       "      <td>92.14</td>\n",
       "      <td>-85.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31-03-2018</th>\n",
       "      <td>25172.00</td>\n",
       "      <td>12026.00</td>\n",
       "      <td>16691.00</td>\n",
       "      <td>3.36</td>\n",
       "      <td>-3098.00</td>\n",
       "      <td>16676.00</td>\n",
       "      <td>-2164.00</td>\n",
       "      <td>-533.00</td>\n",
       "      <td>-1791.00</td>\n",
       "      <td>-4240.00</td>\n",
       "      <td>30735.00</td>\n",
       "      <td>3671.00</td>\n",
       "      <td>3.27</td>\n",
       "      <td>13388.00</td>\n",
       "      <td>1916.00</td>\n",
       "      <td>13840.00</td>\n",
       "      <td>24640.00</td>\n",
       "      <td>8287.00</td>\n",
       "      <td>1629.00</td>\n",
       "      <td>498</td>\n",
       "      <td>1927.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>11199.00</td>\n",
       "      <td>52331.00</td>\n",
       "      <td>126362.00</td>\n",
       "      <td>50829.00</td>\n",
       "      <td>48045.00</td>\n",
       "      <td>126362.00</td>\n",
       "      <td>-11.00</td>\n",
       "      <td>49115.00</td>\n",
       "      <td>51042.00</td>\n",
       "      <td>31463.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4727.00</td>\n",
       "      <td>143262.00</td>\n",
       "      <td>0.03</td>\n",
       "      <td>1.06</td>\n",
       "      <td>2784.00</td>\n",
       "      <td>63.18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>94899.00</td>\n",
       "      <td>105.08</td>\n",
       "      <td>-88.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30-06-2018</th>\n",
       "      <td>27657.00</td>\n",
       "      <td>12607.00</td>\n",
       "      <td>17140.00</td>\n",
       "      <td>5.21</td>\n",
       "      <td>-3243.00</td>\n",
       "      <td>19823.00</td>\n",
       "      <td>-1394.00</td>\n",
       "      <td>-2692.00</td>\n",
       "      <td>7449.00</td>\n",
       "      <td>2920.00</td>\n",
       "      <td>30632.00</td>\n",
       "      <td>3630.00</td>\n",
       "      <td>5.07</td>\n",
       "      <td>13944.00</td>\n",
       "      <td>2605.00</td>\n",
       "      <td>14824.00</td>\n",
       "      <td>24638.00</td>\n",
       "      <td>7227.00</td>\n",
       "      <td>2534.00</td>\n",
       "      <td>499</td>\n",
       "      <td>2983.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>13733.00</td>\n",
       "      <td>54768.00</td>\n",
       "      <td>134100.00</td>\n",
       "      <td>54481.00</td>\n",
       "      <td>50801.00</td>\n",
       "      <td>134100.00</td>\n",
       "      <td>-378.00</td>\n",
       "      <td>49903.00</td>\n",
       "      <td>52886.00</td>\n",
       "      <td>34995.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.55</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5777.00</td>\n",
       "      <td>151847.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>1.07</td>\n",
       "      <td>3680.00</td>\n",
       "      <td>70.13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>99105.00</td>\n",
       "      <td>109.76</td>\n",
       "      <td>-89.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30-09-2018</th>\n",
       "      <td>30904.00</td>\n",
       "      <td>14258.00</td>\n",
       "      <td>18420.00</td>\n",
       "      <td>5.91</td>\n",
       "      <td>-3074.00</td>\n",
       "      <td>20425.00</td>\n",
       "      <td>14662.00</td>\n",
       "      <td>-18478.00</td>\n",
       "      <td>3777.00</td>\n",
       "      <td>109.00</td>\n",
       "      <td>33003.00</td>\n",
       "      <td>2912.00</td>\n",
       "      <td>5.75</td>\n",
       "      <td>14553.00</td>\n",
       "      <td>3390.00</td>\n",
       "      <td>15862.00</td>\n",
       "      <td>24684.00</td>\n",
       "      <td>9340.00</td>\n",
       "      <td>2883.00</td>\n",
       "      <td>501</td>\n",
       "      <td>3724.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>16616.00</td>\n",
       "      <td>58019.00</td>\n",
       "      <td>143695.00</td>\n",
       "      <td>59885.00</td>\n",
       "      <td>55324.00</td>\n",
       "      <td>143695.00</td>\n",
       "      <td>-334.00</td>\n",
       "      <td>52852.00</td>\n",
       "      <td>56576.00</td>\n",
       "      <td>39125.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5957.00</td>\n",
       "      <td>163254.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>1.08</td>\n",
       "      <td>4561.00</td>\n",
       "      <td>78.09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>104570.00</td>\n",
       "      <td>115.81</td>\n",
       "      <td>-89.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31-03-2019</th>\n",
       "      <td>31809.00</td>\n",
       "      <td>15979.00</td>\n",
       "      <td>24588.00</td>\n",
       "      <td>7.24</td>\n",
       "      <td>-3290.00</td>\n",
       "      <td>23115.00</td>\n",
       "      <td>-2377.00</td>\n",
       "      <td>-8123.00</td>\n",
       "      <td>1846.00</td>\n",
       "      <td>-8666.00</td>\n",
       "      <td>33920.00</td>\n",
       "      <td>4854.00</td>\n",
       "      <td>7.09</td>\n",
       "      <td>14708.00</td>\n",
       "      <td>4401.00</td>\n",
       "      <td>16432.00</td>\n",
       "      <td>23322.00</td>\n",
       "      <td>13905.00</td>\n",
       "      <td>3561.00</td>\n",
       "      <td>502</td>\n",
       "      <td>4420.00</td>\n",
       "      <td>20132.00</td>\n",
       "      <td>23193.00</td>\n",
       "      <td>61048.00</td>\n",
       "      <td>178102.00</td>\n",
       "      <td>69431.00</td>\n",
       "      <td>63695.00</td>\n",
       "      <td>178102.00</td>\n",
       "      <td>-19.00</td>\n",
       "      <td>55280.00</td>\n",
       "      <td>59700.00</td>\n",
       "      <td>48410.00</td>\n",
       "      <td>0.02</td>\n",
       "      <td>89.04</td>\n",
       "      <td>0.23</td>\n",
       "      <td>12014.86</td>\n",
       "      <td>6851.00</td>\n",
       "      <td>197479.00</td>\n",
       "      <td>0.03</td>\n",
       "      <td>1.09</td>\n",
       "      <td>5736.00</td>\n",
       "      <td>96.43</td>\n",
       "      <td>12.56</td>\n",
       "      <td>0.92</td>\n",
       "      <td>11.59</td>\n",
       "      <td>0.99</td>\n",
       "      <td>129692.00</td>\n",
       "      <td>121.61</td>\n",
       "      <td>-120.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30-06-2019</th>\n",
       "      <td>36063.00</td>\n",
       "      <td>16747.00</td>\n",
       "      <td>26140.00</td>\n",
       "      <td>5.32</td>\n",
       "      <td>-3562.00</td>\n",
       "      <td>22616.00</td>\n",
       "      <td>-2158.00</td>\n",
       "      <td>-7549.00</td>\n",
       "      <td>9118.00</td>\n",
       "      <td>-542.00</td>\n",
       "      <td>36337.00</td>\n",
       "      <td>5202.00</td>\n",
       "      <td>5.22</td>\n",
       "      <td>14727.00</td>\n",
       "      <td>2889.00</td>\n",
       "      <td>18580.00</td>\n",
       "      <td>23329.00</td>\n",
       "      <td>18847.00</td>\n",
       "      <td>2625.00</td>\n",
       "      <td>502</td>\n",
       "      <td>3084.00</td>\n",
       "      <td>21649.00</td>\n",
       "      <td>25818.00</td>\n",
       "      <td>64723.00</td>\n",
       "      <td>191351.00</td>\n",
       "      <td>76790.00</td>\n",
       "      <td>69678.00</td>\n",
       "      <td>191351.00</td>\n",
       "      <td>-195.00</td>\n",
       "      <td>60320.00</td>\n",
       "      <td>63404.00</td>\n",
       "      <td>53061.00</td>\n",
       "      <td>0.02</td>\n",
       "      <td>94.68</td>\n",
       "      <td>-0.26</td>\n",
       "      <td>8998.15</td>\n",
       "      <td>6187.00</td>\n",
       "      <td>212091.00</td>\n",
       "      <td>0.03</td>\n",
       "      <td>1.10</td>\n",
       "      <td>7112.00</td>\n",
       "      <td>105.70</td>\n",
       "      <td>18.14</td>\n",
       "      <td>0.90</td>\n",
       "      <td>16.25</td>\n",
       "      <td>0.99</td>\n",
       "      <td>138290.00</td>\n",
       "      <td>128.93</td>\n",
       "      <td>-122.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30-09-2019</th>\n",
       "      <td>35794.00</td>\n",
       "      <td>16887.00</td>\n",
       "      <td>28961.00</td>\n",
       "      <td>4.31</td>\n",
       "      <td>-4697.00</td>\n",
       "      <td>23255.00</td>\n",
       "      <td>-1960.00</td>\n",
       "      <td>-5074.00</td>\n",
       "      <td>7892.00</td>\n",
       "      <td>589.00</td>\n",
       "      <td>41302.00</td>\n",
       "      <td>5563.00</td>\n",
       "      <td>4.23</td>\n",
       "      <td>14734.00</td>\n",
       "      <td>2632.00</td>\n",
       "      <td>18766.00</td>\n",
       "      <td>22472.00</td>\n",
       "      <td>20146.00</td>\n",
       "      <td>2134.00</td>\n",
       "      <td>504</td>\n",
       "      <td>3157.00</td>\n",
       "      <td>23114.00</td>\n",
       "      <td>27952.00</td>\n",
       "      <td>67662.00</td>\n",
       "      <td>199099.00</td>\n",
       "      <td>79054.00</td>\n",
       "      <td>72136.00</td>\n",
       "      <td>199099.00</td>\n",
       "      <td>-525.00</td>\n",
       "      <td>66824.00</td>\n",
       "      <td>69981.00</td>\n",
       "      <td>56508.00</td>\n",
       "      <td>0.02</td>\n",
       "      <td>86.80</td>\n",
       "      <td>-0.19</td>\n",
       "      <td>8539.11</td>\n",
       "      <td>6831.00</td>\n",
       "      <td>220453.00</td>\n",
       "      <td>0.03</td>\n",
       "      <td>1.10</td>\n",
       "      <td>6918.00</td>\n",
       "      <td>112.12</td>\n",
       "      <td>20.52</td>\n",
       "      <td>0.77</td>\n",
       "      <td>15.88</td>\n",
       "      <td>0.99</td>\n",
       "      <td>142591.00</td>\n",
       "      <td>134.25</td>\n",
       "      <td>-126.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31-03-2020</th>\n",
       "      <td>40056.00</td>\n",
       "      <td>17836.00</td>\n",
       "      <td>30791.00</td>\n",
       "      <td>5.09</td>\n",
       "      <td>-6795.00</td>\n",
       "      <td>27201.00</td>\n",
       "      <td>-2591.00</td>\n",
       "      <td>-8894.00</td>\n",
       "      <td>3064.00</td>\n",
       "      <td>-8905.00</td>\n",
       "      <td>44257.00</td>\n",
       "      <td>5362.00</td>\n",
       "      <td>5.01</td>\n",
       "      <td>14739.00</td>\n",
       "      <td>3383.00</td>\n",
       "      <td>18857.00</td>\n",
       "      <td>23437.00</td>\n",
       "      <td>22091.00</td>\n",
       "      <td>2535.00</td>\n",
       "      <td>505</td>\n",
       "      <td>3989.00</td>\n",
       "      <td>26279.00</td>\n",
       "      <td>33755.00</td>\n",
       "      <td>77779.00</td>\n",
       "      <td>221238.00</td>\n",
       "      <td>85985.00</td>\n",
       "      <td>79711.00</td>\n",
       "      <td>221238.00</td>\n",
       "      <td>-606.00</td>\n",
       "      <td>71463.00</td>\n",
       "      <td>75452.00</td>\n",
       "      <td>65272.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>97.49</td>\n",
       "      <td>0.18</td>\n",
       "      <td>651679.02</td>\n",
       "      <td>9330.00</td>\n",
       "      <td>242793.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>1.08</td>\n",
       "      <td>6274.00</td>\n",
       "      <td>129.25</td>\n",
       "      <td>19.46</td>\n",
       "      <td>0.75</td>\n",
       "      <td>14.68</td>\n",
       "      <td>1.00</td>\n",
       "      <td>155966.00</td>\n",
       "      <td>154.02</td>\n",
       "      <td>-138.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30-06-2020</th>\n",
       "      <td>51036.00</td>\n",
       "      <td>19918.00</td>\n",
       "      <td>33863.00</td>\n",
       "      <td>10.50</td>\n",
       "      <td>-7459.00</td>\n",
       "      <td>37466.00</td>\n",
       "      <td>7408.00</td>\n",
       "      <td>-17804.00</td>\n",
       "      <td>20606.00</td>\n",
       "      <td>10337.00</td>\n",
       "      <td>52660.00</td>\n",
       "      <td>5748.00</td>\n",
       "      <td>10.30</td>\n",
       "      <td>14751.00</td>\n",
       "      <td>6221.00</td>\n",
       "      <td>19599.00</td>\n",
       "      <td>33128.00</td>\n",
       "      <td>33925.00</td>\n",
       "      <td>5243.00</td>\n",
       "      <td>509</td>\n",
       "      <td>5843.00</td>\n",
       "      <td>28537.00</td>\n",
       "      <td>38998.00</td>\n",
       "      <td>86517.00</td>\n",
       "      <td>258314.00</td>\n",
       "      <td>110908.00</td>\n",
       "      <td>93896.00</td>\n",
       "      <td>258314.00</td>\n",
       "      <td>378.00</td>\n",
       "      <td>83069.00</td>\n",
       "      <td>88912.00</td>\n",
       "      <td>73728.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>137.94</td>\n",
       "      <td>1.06</td>\n",
       "      <td>356241.25</td>\n",
       "      <td>12702.00</td>\n",
       "      <td>271822.00</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1.18</td>\n",
       "      <td>17012.00</td>\n",
       "      <td>144.85</td>\n",
       "      <td>13.39</td>\n",
       "      <td>0.95</td>\n",
       "      <td>12.75</td>\n",
       "      <td>1.00</td>\n",
       "      <td>184586.00</td>\n",
       "      <td>169.97</td>\n",
       "      <td>-144.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30-09-2020</th>\n",
       "      <td>58334.00</td>\n",
       "      <td>20832.00</td>\n",
       "      <td>34327.00</td>\n",
       "      <td>12.63</td>\n",
       "      <td>-11063.00</td>\n",
       "      <td>29930.00</td>\n",
       "      <td>-4105.00</td>\n",
       "      <td>-15876.00</td>\n",
       "      <td>11964.00</td>\n",
       "      <td>-7640.00</td>\n",
       "      <td>57106.00</td>\n",
       "      <td>6523.00</td>\n",
       "      <td>12.37</td>\n",
       "      <td>14960.00</td>\n",
       "      <td>6809.00</td>\n",
       "      <td>23735.00</td>\n",
       "      <td>32929.00</td>\n",
       "      <td>38472.00</td>\n",
       "      <td>6331.00</td>\n",
       "      <td>511</td>\n",
       "      <td>6194.00</td>\n",
       "      <td>34119.00</td>\n",
       "      <td>45329.00</td>\n",
       "      <td>99981.00</td>\n",
       "      <td>282179.00</td>\n",
       "      <td>112969.00</td>\n",
       "      <td>101912.00</td>\n",
       "      <td>282179.00</td>\n",
       "      <td>615.00</td>\n",
       "      <td>89951.00</td>\n",
       "      <td>96145.00</td>\n",
       "      <td>82775.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>157.44</td>\n",
       "      <td>0.20</td>\n",
       "      <td>570017.51</td>\n",
       "      <td>17394.00</td>\n",
       "      <td>306438.00</td>\n",
       "      <td>0.06</td>\n",
       "      <td>1.11</td>\n",
       "      <td>11057.00</td>\n",
       "      <td>161.99</td>\n",
       "      <td>12.73</td>\n",
       "      <td>0.97</td>\n",
       "      <td>12.37</td>\n",
       "      <td>1.00</td>\n",
       "      <td>199404.00</td>\n",
       "      <td>195.66</td>\n",
       "      <td>-169.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31-03-2021</th>\n",
       "      <td>63926.00</td>\n",
       "      <td>24289.00</td>\n",
       "      <td>40939.00</td>\n",
       "      <td>16.09</td>\n",
       "      <td>-12082.00</td>\n",
       "      <td>33834.00</td>\n",
       "      <td>-3476.00</td>\n",
       "      <td>-8666.00</td>\n",
       "      <td>4213.00</td>\n",
       "      <td>-8222.00</td>\n",
       "      <td>62403.00</td>\n",
       "      <td>7508.00</td>\n",
       "      <td>15.79</td>\n",
       "      <td>15220.00</td>\n",
       "      <td>10268.00</td>\n",
       "      <td>23849.00</td>\n",
       "      <td>31868.00</td>\n",
       "      <td>39436.00</td>\n",
       "      <td>8107.00</td>\n",
       "      <td>513</td>\n",
       "      <td>8865.00</td>\n",
       "      <td>39328.00</td>\n",
       "      <td>60658.00</td>\n",
       "      <td>121461.00</td>\n",
       "      <td>323077.00</td>\n",
       "      <td>121408.00</td>\n",
       "      <td>115404.00</td>\n",
       "      <td>323077.00</td>\n",
       "      <td>1403.00</td>\n",
       "      <td>99653.00</td>\n",
       "      <td>108518.00</td>\n",
       "      <td>103320.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>154.70</td>\n",
       "      <td>0.28</td>\n",
       "      <td>4838175.30</td>\n",
       "      <td>20189.00</td>\n",
       "      <td>354672.00</td>\n",
       "      <td>0.06</td>\n",
       "      <td>1.05</td>\n",
       "      <td>6004.00</td>\n",
       "      <td>201.40</td>\n",
       "      <td>9.80</td>\n",
       "      <td>0.77</td>\n",
       "      <td>7.53</td>\n",
       "      <td>1.00</td>\n",
       "      <td>219757.00</td>\n",
       "      <td>236.77</td>\n",
       "      <td>-191.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30-06-2021</th>\n",
       "      <td>66090.00</td>\n",
       "      <td>26835.00</td>\n",
       "      <td>41007.00</td>\n",
       "      <td>15.40</td>\n",
       "      <td>-14288.00</td>\n",
       "      <td>40380.00</td>\n",
       "      <td>15643.00</td>\n",
       "      <td>-22080.00</td>\n",
       "      <td>12715.00</td>\n",
       "      <td>6512.00</td>\n",
       "      <td>64176.00</td>\n",
       "      <td>8038.00</td>\n",
       "      <td>15.12</td>\n",
       "      <td>15350.00</td>\n",
       "      <td>8634.00</td>\n",
       "      <td>24119.00</td>\n",
       "      <td>50279.00</td>\n",
       "      <td>49514.00</td>\n",
       "      <td>7778.00</td>\n",
       "      <td>514</td>\n",
       "      <td>7702.00</td>\n",
       "      <td>43346.00</td>\n",
       "      <td>68436.00</td>\n",
       "      <td>133502.00</td>\n",
       "      <td>360319.00</td>\n",
       "      <td>140848.00</td>\n",
       "      <td>117792.00</td>\n",
       "      <td>360319.00</td>\n",
       "      <td>932.00</td>\n",
       "      <td>105378.00</td>\n",
       "      <td>113080.00</td>\n",
       "      <td>114803.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>172.01</td>\n",
       "      <td>-0.04</td>\n",
       "      <td>1399605.48</td>\n",
       "      <td>22066.00</td>\n",
       "      <td>377522.00</td>\n",
       "      <td>0.06</td>\n",
       "      <td>1.20</td>\n",
       "      <td>23056.00</td>\n",
       "      <td>223.35</td>\n",
       "      <td>11.38</td>\n",
       "      <td>0.77</td>\n",
       "      <td>8.76</td>\n",
       "      <td>1.00</td>\n",
       "      <td>245516.00</td>\n",
       "      <td>259.73</td>\n",
       "      <td>-203.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30-09-2021</th>\n",
       "      <td>71474.00</td>\n",
       "      <td>28610.00</td>\n",
       "      <td>41546.00</td>\n",
       "      <td>6.23</td>\n",
       "      <td>-15748.00</td>\n",
       "      <td>29944.00</td>\n",
       "      <td>-2776.00</td>\n",
       "      <td>-14828.00</td>\n",
       "      <td>7313.00</td>\n",
       "      <td>-10490.00</td>\n",
       "      <td>62930.00</td>\n",
       "      <td>8948.00</td>\n",
       "      <td>6.12</td>\n",
       "      <td>15345.00</td>\n",
       "      <td>4315.00</td>\n",
       "      <td>30933.00</td>\n",
       "      <td>50055.00</td>\n",
       "      <td>49044.00</td>\n",
       "      <td>3156.00</td>\n",
       "      <td>515</td>\n",
       "      <td>4852.00</td>\n",
       "      <td>52151.00</td>\n",
       "      <td>71592.00</td>\n",
       "      <td>147152.00</td>\n",
       "      <td>382406.00</td>\n",
       "      <td>138531.00</td>\n",
       "      <td>123994.00</td>\n",
       "      <td>382406.00</td>\n",
       "      <td>-537.00</td>\n",
       "      <td>105960.00</td>\n",
       "      <td>110812.00</td>\n",
       "      <td>120564.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>164.25</td>\n",
       "      <td>-0.60</td>\n",
       "      <td>702967.33</td>\n",
       "      <td>18904.00</td>\n",
       "      <td>416438.00</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1.12</td>\n",
       "      <td>14537.00</td>\n",
       "      <td>234.10</td>\n",
       "      <td>26.84</td>\n",
       "      <td>0.70</td>\n",
       "      <td>18.83</td>\n",
       "      <td>1.00</td>\n",
       "      <td>261842.00</td>\n",
       "      <td>285.73</td>\n",
       "      <td>-239.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31-03-2022</th>\n",
       "      <td>68547.00</td>\n",
       "      <td>32504.00</td>\n",
       "      <td>58141.00</td>\n",
       "      <td>-7.56</td>\n",
       "      <td>-14951.00</td>\n",
       "      <td>36393.00</td>\n",
       "      <td>1990.00</td>\n",
       "      <td>906.00</td>\n",
       "      <td>-2790.00</td>\n",
       "      <td>122.00</td>\n",
       "      <td>66499.00</td>\n",
       "      <td>8978.00</td>\n",
       "      <td>-7.56</td>\n",
       "      <td>20229.00</td>\n",
       "      <td>-5265.00</td>\n",
       "      <td>34987.00</td>\n",
       "      <td>47556.00</td>\n",
       "      <td>29992.00</td>\n",
       "      <td>-3844.00</td>\n",
       "      <td>508</td>\n",
       "      <td>3669.00</td>\n",
       "      <td>56161.00</td>\n",
       "      <td>82071.00</td>\n",
       "      <td>168468.00</td>\n",
       "      <td>410767.00</td>\n",
       "      <td>133876.00</td>\n",
       "      <td>139508.00</td>\n",
       "      <td>410767.00</td>\n",
       "      <td>-8934.00</td>\n",
       "      <td>112775.00</td>\n",
       "      <td>116444.00</td>\n",
       "      <td>134001.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>163.00</td>\n",
       "      <td>-2.24</td>\n",
       "      <td>-27187.50</td>\n",
       "      <td>11107.00</td>\n",
       "      <td>471070.00</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.96</td>\n",
       "      <td>-5632.00</td>\n",
       "      <td>263.78</td>\n",
       "      <td>-21.56</td>\n",
       "      <td>0.62</td>\n",
       "      <td>-13.32</td>\n",
       "      <td>1.01</td>\n",
       "      <td>276766.00</td>\n",
       "      <td>331.63</td>\n",
       "      <td>-281.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30-06-2022</th>\n",
       "      <td>71219.00</td>\n",
       "      <td>34804.00</td>\n",
       "      <td>56254.00</td>\n",
       "      <td>-0.20</td>\n",
       "      <td>-15724.00</td>\n",
       "      <td>37478.00</td>\n",
       "      <td>4626.00</td>\n",
       "      <td>-12078.00</td>\n",
       "      <td>8965.00</td>\n",
       "      <td>1101.00</td>\n",
       "      <td>66424.00</td>\n",
       "      <td>9594.00</td>\n",
       "      <td>-0.20</td>\n",
       "      <td>20195.00</td>\n",
       "      <td>-2653.00</td>\n",
       "      <td>38153.00</td>\n",
       "      <td>58053.00</td>\n",
       "      <td>23232.00</td>\n",
       "      <td>-2028.00</td>\n",
       "      <td>10140</td>\n",
       "      <td>3317.00</td>\n",
       "      <td>58430.00</td>\n",
       "      <td>80043.00</td>\n",
       "      <td>173706.00</td>\n",
       "      <td>419728.00</td>\n",
       "      <td>133667.00</td>\n",
       "      <td>140291.00</td>\n",
       "      <td>419728.00</td>\n",
       "      <td>-5970.00</td>\n",
       "      <td>117917.00</td>\n",
       "      <td>121234.00</td>\n",
       "      <td>131402.00</td>\n",
       "      <td>0.02</td>\n",
       "      <td>106.21</td>\n",
       "      <td>-0.97</td>\n",
       "      <td>-360.41</td>\n",
       "      <td>13696.00</td>\n",
       "      <td>486491.00</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0.95</td>\n",
       "      <td>-6624.00</td>\n",
       "      <td>12.96</td>\n",
       "      <td>-531.05</td>\n",
       "      <td>8.20</td>\n",
       "      <td>-4352.48</td>\n",
       "      <td>1.29</td>\n",
       "      <td>288326.00</td>\n",
       "      <td>17.13</td>\n",
       "      <td>-15.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30-09-2022</th>\n",
       "      <td>67760.00</td>\n",
       "      <td>36154.00</td>\n",
       "      <td>59974.00</td>\n",
       "      <td>0.28</td>\n",
       "      <td>-16378.00</td>\n",
       "      <td>34947.00</td>\n",
       "      <td>3016.00</td>\n",
       "      <td>-15608.00</td>\n",
       "      <td>11404.00</td>\n",
       "      <td>-2522.00</td>\n",
       "      <td>70268.00</td>\n",
       "      <td>10204.00</td>\n",
       "      <td>0.28</td>\n",
       "      <td>20168.00</td>\n",
       "      <td>2944.00</td>\n",
       "      <td>36647.00</td>\n",
       "      <td>58919.00</td>\n",
       "      <td>23715.00</td>\n",
       "      <td>2872.00</td>\n",
       "      <td>10257</td>\n",
       "      <td>2525.00</td>\n",
       "      <td>62033.00</td>\n",
       "      <td>82915.00</td>\n",
       "      <td>177195.00</td>\n",
       "      <td>428362.00</td>\n",
       "      <td>131463.00</td>\n",
       "      <td>140363.00</td>\n",
       "      <td>428362.00</td>\n",
       "      <td>419.00</td>\n",
       "      <td>124576.00</td>\n",
       "      <td>127101.00</td>\n",
       "      <td>137489.00</td>\n",
       "      <td>0.03</td>\n",
       "      <td>113.00</td>\n",
       "      <td>-2.40</td>\n",
       "      <td>143.35</td>\n",
       "      <td>19250.00</td>\n",
       "      <td>497434.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.94</td>\n",
       "      <td>-8900.00</td>\n",
       "      <td>13.40</td>\n",
       "      <td>403.57</td>\n",
       "      <td>8.43</td>\n",
       "      <td>3402.13</td>\n",
       "      <td>0.21</td>\n",
       "      <td>290873.00</td>\n",
       "      <td>17.28</td>\n",
       "      <td>-15.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31-03-2023</th>\n",
       "      <td>66907.00</td>\n",
       "      <td>37646.00</td>\n",
       "      <td>66382.00</td>\n",
       "      <td>0.31</td>\n",
       "      <td>-14207.00</td>\n",
       "      <td>49343.00</td>\n",
       "      <td>6354.00</td>\n",
       "      <td>-15806.00</td>\n",
       "      <td>4788.00</td>\n",
       "      <td>-4519.00</td>\n",
       "      <td>67791.00</td>\n",
       "      <td>11123.00</td>\n",
       "      <td>0.31</td>\n",
       "      <td>22749.00</td>\n",
       "      <td>4119.00</td>\n",
       "      <td>34170.00</td>\n",
       "      <td>67084.00</td>\n",
       "      <td>15062.00</td>\n",
       "      <td>3172.00</td>\n",
       "      <td>10232</td>\n",
       "      <td>4774.00</td>\n",
       "      <td>68262.00</td>\n",
       "      <td>86365.00</td>\n",
       "      <td>190754.00</td>\n",
       "      <td>464378.00</td>\n",
       "      <td>136221.00</td>\n",
       "      <td>147570.00</td>\n",
       "      <td>464378.00</td>\n",
       "      <td>-655.00</td>\n",
       "      <td>122584.00</td>\n",
       "      <td>127358.00</td>\n",
       "      <td>154526.00</td>\n",
       "      <td>0.05</td>\n",
       "      <td>103.29</td>\n",
       "      <td>0.11</td>\n",
       "      <td>259.24</td>\n",
       "      <td>17379.00</td>\n",
       "      <td>533262.00</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0.92</td>\n",
       "      <td>-11349.00</td>\n",
       "      <td>15.10</td>\n",
       "      <td>333.19</td>\n",
       "      <td>6.84</td>\n",
       "      <td>2278.84</td>\n",
       "      <td>0.60</td>\n",
       "      <td>309852.00</td>\n",
       "      <td>18.64</td>\n",
       "      <td>-16.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30-06-2023</th>\n",
       "      <td>69481.00</td>\n",
       "      <td>39925.00</td>\n",
       "      <td>64235.00</td>\n",
       "      <td>0.66</td>\n",
       "      <td>-11455.00</td>\n",
       "      <td>49529.00</td>\n",
       "      <td>-6539.00</td>\n",
       "      <td>-9673.00</td>\n",
       "      <td>16476.00</td>\n",
       "      <td>333.00</td>\n",
       "      <td>69373.00</td>\n",
       "      <td>11589.00</td>\n",
       "      <td>0.65</td>\n",
       "      <td>22785.00</td>\n",
       "      <td>7563.00</td>\n",
       "      <td>36587.00</td>\n",
       "      <td>63092.00</td>\n",
       "      <td>14441.00</td>\n",
       "      <td>6750.00</td>\n",
       "      <td>10384</td>\n",
       "      <td>7681.00</td>\n",
       "      <td>70332.00</td>\n",
       "      <td>93115.00</td>\n",
       "      <td>193784.00</td>\n",
       "      <td>477607.00</td>\n",
       "      <td>140482.00</td>\n",
       "      <td>148238.00</td>\n",
       "      <td>477607.00</td>\n",
       "      <td>-118.00</td>\n",
       "      <td>126702.00</td>\n",
       "      <td>134383.00</td>\n",
       "      <td>168602.00</td>\n",
       "      <td>0.05</td>\n",
       "      <td>130.36</td>\n",
       "      <td>1.10</td>\n",
       "      <td>593.51</td>\n",
       "      <td>18205.00</td>\n",
       "      <td>547353.00</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0.95</td>\n",
       "      <td>-7756.00</td>\n",
       "      <td>16.24</td>\n",
       "      <td>200.55</td>\n",
       "      <td>8.03</td>\n",
       "      <td>1610.19</td>\n",
       "      <td>0.78</td>\n",
       "      <td>309005.00</td>\n",
       "      <td>18.66</td>\n",
       "      <td>-16.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30-09-2023</th>\n",
       "      <td>72004.00</td>\n",
       "      <td>43420.00</td>\n",
       "      <td>58812.00</td>\n",
       "      <td>0.96</td>\n",
       "      <td>-12479.00</td>\n",
       "      <td>49605.00</td>\n",
       "      <td>-8948.00</td>\n",
       "      <td>-11753.00</td>\n",
       "      <td>21217.00</td>\n",
       "      <td>14.00</td>\n",
       "      <td>75022.00</td>\n",
       "      <td>12131.00</td>\n",
       "      <td>0.94</td>\n",
       "      <td>22749.00</td>\n",
       "      <td>12189.00</td>\n",
       "      <td>35406.00</td>\n",
       "      <td>61098.00</td>\n",
       "      <td>14564.00</td>\n",
       "      <td>9879.00</td>\n",
       "      <td>10509</td>\n",
       "      <td>11188.00</td>\n",
       "      <td>70758.00</td>\n",
       "      <td>102994.00</td>\n",
       "      <td>196468.00</td>\n",
       "      <td>486883.00</td>\n",
       "      <td>142995.00</td>\n",
       "      <td>145214.00</td>\n",
       "      <td>486883.00</td>\n",
       "      <td>1001.00</td>\n",
       "      <td>131895.00</td>\n",
       "      <td>143083.00</td>\n",
       "      <td>182973.00</td>\n",
       "      <td>0.05</td>\n",
       "      <td>127.12</td>\n",
       "      <td>0.45</td>\n",
       "      <td>732.95</td>\n",
       "      <td>22358.00</td>\n",
       "      <td>553530.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.98</td>\n",
       "      <td>-2219.00</td>\n",
       "      <td>17.41</td>\n",
       "      <td>135.23</td>\n",
       "      <td>7.30</td>\n",
       "      <td>987.36</td>\n",
       "      <td>0.83</td>\n",
       "      <td>303910.00</td>\n",
       "      <td>18.70</td>\n",
       "      <td>-15.31</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            accounts payable  accounts receivable  accrued expenses and other  \\\n",
       "Date                                                                            \n",
       "30-09-2013          10037.00              3057.00                     6098.00   \n",
       "31-03-2014          10590.00              3945.00                     6251.00   \n",
       "30-06-2014          10457.00              4125.00                     6688.00   \n",
       "30-09-2014          11811.00              4373.00                     7217.00   \n",
       "31-03-2015          11917.00              4772.00                     8840.00   \n",
       "30-06-2015          12391.00              4920.00                     8959.00   \n",
       "30-09-2015          14437.00              5440.00                     9157.00   \n",
       "31-03-2016          14990.00              5072.00                     9431.00   \n",
       "30-06-2016          16123.00              6092.00                     9613.00   \n",
       "30-09-2016          18801.00              6566.00                    10497.00   \n",
       "31-03-2017          18891.00              7329.00                    13054.00   \n",
       "30-06-2017          21439.00              8046.00                    14016.00   \n",
       "30-09-2017          26075.00             10557.00                    15844.00   \n",
       "31-03-2018          25172.00             12026.00                    16691.00   \n",
       "30-06-2018          27657.00             12607.00                    17140.00   \n",
       "30-09-2018          30904.00             14258.00                    18420.00   \n",
       "31-03-2019          31809.00             15979.00                    24588.00   \n",
       "30-06-2019          36063.00             16747.00                    26140.00   \n",
       "30-09-2019          35794.00             16887.00                    28961.00   \n",
       "31-03-2020          40056.00             17836.00                    30791.00   \n",
       "30-06-2020          51036.00             19918.00                    33863.00   \n",
       "30-09-2020          58334.00             20832.00                    34327.00   \n",
       "31-03-2021          63926.00             24289.00                    40939.00   \n",
       "30-06-2021          66090.00             26835.00                    41007.00   \n",
       "30-09-2021          71474.00             28610.00                    41546.00   \n",
       "31-03-2022          68547.00             32504.00                    58141.00   \n",
       "30-06-2022          71219.00             34804.00                    56254.00   \n",
       "30-09-2022          67760.00             36154.00                    59974.00   \n",
       "31-03-2023          66907.00             37646.00                    66382.00   \n",
       "30-06-2023          69481.00             39925.00                    64235.00   \n",
       "30-09-2023          72004.00             43420.00                    58812.00   \n",
       "\n",
       "            basic earnings per share     capex  cash and cash equivalents  \\\n",
       "Date                                                                        \n",
       "30-09-2013                     -0.09  -1038.00                    3872.00   \n",
       "31-03-2014                      0.23  -1080.00                    5074.00   \n",
       "30-06-2014                     -0.27  -1290.00                    5057.00   \n",
       "30-09-2014                     -0.95  -1378.00                    5258.00   \n",
       "31-03-2015                     -0.12   -871.00                   10237.00   \n",
       "30-06-2015                      0.20  -1213.00                   10269.00   \n",
       "30-09-2015                      0.17  -1195.00                   10709.00   \n",
       "31-03-2016                      1.09  -1179.00                   12470.00   \n",
       "30-06-2016                      1.81  -1711.00                   12521.00   \n",
       "30-09-2016                      0.53  -1841.00                   13656.00   \n",
       "31-03-2017                      1.52  -1861.00                   15440.00   \n",
       "30-06-2017                      0.41  -2501.00                   13203.00   \n",
       "30-09-2017                      0.53  -2659.00                   12767.00   \n",
       "31-03-2018                      3.36  -3098.00                   16676.00   \n",
       "30-06-2018                      5.21  -3243.00                   19823.00   \n",
       "30-09-2018                      5.91  -3074.00                   20425.00   \n",
       "31-03-2019                      7.24  -3290.00                   23115.00   \n",
       "30-06-2019                      5.32  -3562.00                   22616.00   \n",
       "30-09-2019                      4.31  -4697.00                   23255.00   \n",
       "31-03-2020                      5.09  -6795.00                   27201.00   \n",
       "30-06-2020                     10.50  -7459.00                   37466.00   \n",
       "30-09-2020                     12.63 -11063.00                   29930.00   \n",
       "31-03-2021                     16.09 -12082.00                   33834.00   \n",
       "30-06-2021                     15.40 -14288.00                   40380.00   \n",
       "30-09-2021                      6.23 -15748.00                   29944.00   \n",
       "31-03-2022                     -7.56 -14951.00                   36393.00   \n",
       "30-06-2022                     -0.20 -15724.00                   37478.00   \n",
       "30-09-2022                      0.28 -16378.00                   34947.00   \n",
       "31-03-2023                      0.31 -14207.00                   49343.00   \n",
       "30-06-2023                      0.66 -11455.00                   49529.00   \n",
       "30-09-2023                      0.96 -12479.00                   49605.00   \n",
       "\n",
       "            cash flow from financing  cash flow from investing  \\\n",
       "Date                                                             \n",
       "30-09-2013                   -230.00                  -1063.00   \n",
       "31-03-2014                   -175.00                   -924.00   \n",
       "30-06-2014                   -189.00                   -731.00   \n",
       "30-09-2014                   -412.00                   -946.00   \n",
       "31-03-2015                   -652.00                  -1847.00   \n",
       "30-06-2015                   -691.00                  -1376.00   \n",
       "30-09-2015                   -730.00                  -1377.00   \n",
       "31-03-2016                   -789.00                   -693.00   \n",
       "30-06-2016                  -1039.00                  -2439.00   \n",
       "30-09-2016                   -827.00                  -2570.00   \n",
       "31-03-2017                   -914.00                  -1616.00   \n",
       "30-06-2017                  -1263.00                  -5051.00   \n",
       "30-09-2017                  14685.00                 -19120.00   \n",
       "31-03-2018                  -2164.00                   -533.00   \n",
       "30-06-2018                  -1394.00                  -2692.00   \n",
       "30-09-2018                  14662.00                 -18478.00   \n",
       "31-03-2019                  -2377.00                  -8123.00   \n",
       "30-06-2019                  -2158.00                  -7549.00   \n",
       "30-09-2019                  -1960.00                  -5074.00   \n",
       "31-03-2020                  -2591.00                  -8894.00   \n",
       "30-06-2020                   7408.00                 -17804.00   \n",
       "30-09-2020                  -4105.00                 -15876.00   \n",
       "31-03-2021                  -3476.00                  -8666.00   \n",
       "30-06-2021                  15643.00                 -22080.00   \n",
       "30-09-2021                  -2776.00                 -14828.00   \n",
       "31-03-2022                   1990.00                    906.00   \n",
       "30-06-2022                   4626.00                 -12078.00   \n",
       "30-09-2022                   3016.00                 -15608.00   \n",
       "31-03-2023                   6354.00                 -15806.00   \n",
       "30-06-2023                  -6539.00                  -9673.00   \n",
       "30-09-2023                  -8948.00                 -11753.00   \n",
       "\n",
       "            cash flow from operations  change in cash  cost of sales  \\\n",
       "Date                                                                   \n",
       "30-09-2013                    1388.00          168.00       12366.00   \n",
       "31-03-2014                   -2502.00        -3584.00       14055.00   \n",
       "30-06-2014                     862.00          -17.00       13399.00   \n",
       "30-09-2014                    1766.00          201.00       14627.00   \n",
       "31-03-2015                   -1499.00        -4320.00       15395.00   \n",
       "30-06-2015                    1997.00           32.00       15160.00   \n",
       "30-09-2015                    2610.00          440.00       16755.00   \n",
       "31-03-2016                   -2160.00        -3420.00       18866.00   \n",
       "30-06-2016                    3465.00           51.00       19180.00   \n",
       "30-09-2016                    4486.00         1135.00       21260.00   \n",
       "31-03-2017                   -1590.00        -3894.00       22440.00   \n",
       "30-06-2017                    3829.00        -2237.00       23451.00   \n",
       "30-09-2017                    3851.00         -436.00       27549.00   \n",
       "31-03-2018                   -1791.00        -4240.00       30735.00   \n",
       "30-06-2018                    7449.00         2920.00       30632.00   \n",
       "30-09-2018                    3777.00          109.00       33003.00   \n",
       "31-03-2019                    1846.00        -8666.00       33920.00   \n",
       "30-06-2019                    9118.00         -542.00       36337.00   \n",
       "30-09-2019                    7892.00          589.00       41302.00   \n",
       "31-03-2020                    3064.00        -8905.00       44257.00   \n",
       "30-06-2020                   20606.00        10337.00       52660.00   \n",
       "30-09-2020                   11964.00        -7640.00       57106.00   \n",
       "31-03-2021                    4213.00        -8222.00       62403.00   \n",
       "30-06-2021                   12715.00         6512.00       64176.00   \n",
       "30-09-2021                    7313.00       -10490.00       62930.00   \n",
       "31-03-2022                   -2790.00          122.00       66499.00   \n",
       "30-06-2022                    8965.00         1101.00       66424.00   \n",
       "30-09-2022                   11404.00        -2522.00       70268.00   \n",
       "31-03-2023                    4788.00        -4519.00       67791.00   \n",
       "30-06-2023                   16476.00          333.00       69373.00   \n",
       "30-09-2023                   21217.00           14.00       75022.00   \n",
       "\n",
       "            depreciation and amortization  diluted earnings per share  \\\n",
       "Date                                                                    \n",
       "30-09-2013                         834.00                       -0.09   \n",
       "31-03-2014                        1010.00                        0.23   \n",
       "30-06-2014                        1109.00                       -0.27   \n",
       "30-09-2014                        1247.00                       -0.95   \n",
       "31-03-2015                        1426.00                       -0.12   \n",
       "30-06-2015                        1504.00                        0.19   \n",
       "30-09-2015                        1599.00                        0.17   \n",
       "31-03-2016                        1827.00                        1.07   \n",
       "30-06-2016                        1909.00                        1.78   \n",
       "30-09-2016                        2084.00                        0.52   \n",
       "31-03-2017                        2435.00                        1.48   \n",
       "30-06-2017                        2633.00                        0.40   \n",
       "30-09-2017                        2912.00                        0.52   \n",
       "31-03-2018                        3671.00                        3.27   \n",
       "30-06-2018                        3630.00                        5.07   \n",
       "30-09-2018                        2912.00                        5.75   \n",
       "31-03-2019                        4854.00                        7.09   \n",
       "30-06-2019                        5202.00                        5.22   \n",
       "30-09-2019                        5563.00                        4.23   \n",
       "31-03-2020                        5362.00                        5.01   \n",
       "30-06-2020                        5748.00                       10.30   \n",
       "30-09-2020                        6523.00                       12.37   \n",
       "31-03-2021                        7508.00                       15.79   \n",
       "30-06-2021                        8038.00                       15.12   \n",
       "30-09-2021                        8948.00                        6.12   \n",
       "31-03-2022                        8978.00                       -7.56   \n",
       "30-06-2022                        9594.00                       -0.20   \n",
       "30-09-2022                       10204.00                        0.28   \n",
       "31-03-2023                       11123.00                        0.31   \n",
       "30-06-2023                       11589.00                        0.65   \n",
       "30-09-2023                       12131.00                        0.94   \n",
       "\n",
       "            goodwill  income before income taxes  inventories  long term debt  \\\n",
       "Date                                                                            \n",
       "30-09-2013   2635.00                      -43.00      6068.00         3043.00   \n",
       "31-03-2014   2653.00                      120.00      6716.00         3147.00   \n",
       "30-06-2014   2677.00                      -27.00      6644.00         3119.00   \n",
       "30-09-2014   3332.00                     -634.00      7316.00         3099.00   \n",
       "31-03-2015   3491.00                       21.00      7369.00         8257.00   \n",
       "30-06-2015   3523.00                      362.00      7470.00         8250.00   \n",
       "30-09-2015   3529.00                      247.00      8981.00         8243.00   \n",
       "31-03-2016   3785.00                     1056.00      9582.00         8219.00   \n",
       "30-06-2016   3774.00                     1179.00      9588.00         8212.00   \n",
       "30-09-2016   3815.00                      491.00     10696.00         8205.00   \n",
       "31-03-2017   3823.00                      953.00     10600.00         7691.00   \n",
       "30-06-2017   4254.00                      666.00     11510.00         7683.00   \n",
       "30-09-2017  13271.00                      316.00     13711.00        24710.00   \n",
       "31-03-2018  13388.00                     1916.00     13840.00        24640.00   \n",
       "30-06-2018  13944.00                     2605.00     14824.00        24638.00   \n",
       "30-09-2018  14553.00                     3390.00     15862.00        24684.00   \n",
       "31-03-2019  14708.00                     4401.00     16432.00        23322.00   \n",
       "30-06-2019  14727.00                     2889.00     18580.00        23329.00   \n",
       "30-09-2019  14734.00                     2632.00     18766.00        22472.00   \n",
       "31-03-2020  14739.00                     3383.00     18857.00        23437.00   \n",
       "30-06-2020  14751.00                     6221.00     19599.00        33128.00   \n",
       "30-09-2020  14960.00                     6809.00     23735.00        32929.00   \n",
       "31-03-2021  15220.00                    10268.00     23849.00        31868.00   \n",
       "30-06-2021  15350.00                     8634.00     24119.00        50279.00   \n",
       "30-09-2021  15345.00                     4315.00     30933.00        50055.00   \n",
       "31-03-2022  20229.00                    -5265.00     34987.00        47556.00   \n",
       "30-06-2022  20195.00                    -2653.00     38153.00        58053.00   \n",
       "30-09-2022  20168.00                     2944.00     36647.00        58919.00   \n",
       "31-03-2023  22749.00                     4119.00     34170.00        67084.00   \n",
       "30-06-2023  22785.00                     7563.00     36587.00        63092.00   \n",
       "30-09-2023  22749.00                    12189.00     35406.00        61098.00   \n",
       "\n",
       "            marketable securities  net income  nshares  operating income  \\\n",
       "Date                                                                       \n",
       "30-09-2013                3817.00      -41.00      455            -25.00   \n",
       "31-03-2014                3592.00      108.00      469            146.00   \n",
       "30-06-2014                2929.00     -126.00      466            -15.00   \n",
       "30-09-2014                1625.00     -437.00      460           -544.00   \n",
       "31-03-2015                3544.00      -57.00      475            255.00   \n",
       "30-06-2015                3732.00       92.00      484            464.00   \n",
       "30-09-2015                3719.00       79.00      464            406.00   \n",
       "31-03-2016                3389.00      513.00      479           1071.00   \n",
       "30-06-2016                4019.00      857.00      481           1285.00   \n",
       "30-09-2016                4691.00      252.00      484            575.00   \n",
       "31-03-2017                6091.00      724.00      489           1005.00   \n",
       "30-06-2017                8248.00      197.00      492            628.00   \n",
       "30-09-2017               11543.00      256.00      492            347.00   \n",
       "31-03-2018                8287.00     1629.00      498           1927.00   \n",
       "30-06-2018                7227.00     2534.00      499           2983.00   \n",
       "30-09-2018                9340.00     2883.00      501           3724.00   \n",
       "31-03-2019               13905.00     3561.00      502           4420.00   \n",
       "30-06-2019               18847.00     2625.00      502           3084.00   \n",
       "30-09-2019               20146.00     2134.00      504           3157.00   \n",
       "31-03-2020               22091.00     2535.00      505           3989.00   \n",
       "30-06-2020               33925.00     5243.00      509           5843.00   \n",
       "30-09-2020               38472.00     6331.00      511           6194.00   \n",
       "31-03-2021               39436.00     8107.00      513           8865.00   \n",
       "30-06-2021               49514.00     7778.00      514           7702.00   \n",
       "30-09-2021               49044.00     3156.00      515           4852.00   \n",
       "31-03-2022               29992.00    -3844.00      508           3669.00   \n",
       "30-06-2022               23232.00    -2028.00    10140           3317.00   \n",
       "30-09-2022               23715.00     2872.00    10257           2525.00   \n",
       "31-03-2023               15062.00     3172.00    10232           4774.00   \n",
       "30-06-2023               14441.00     6750.00    10384           7681.00   \n",
       "30-09-2023               14564.00     9879.00    10509          11188.00   \n",
       "\n",
       "            operating leases  retained earnings  tangible assets  \\\n",
       "Date                                                               \n",
       "30-09-2013              0.00            1950.00          9991.00   \n",
       "31-03-2014              0.00            2298.00         12267.00   \n",
       "30-06-2014              0.00            2172.00         14089.00   \n",
       "30-09-2014              0.00            1735.00         15702.00   \n",
       "31-03-2015              0.00            1892.00         17736.00   \n",
       "30-06-2015              0.00            1984.00         19479.00   \n",
       "30-09-2015              0.00            2063.00         20636.00   \n",
       "31-03-2016              0.00            3058.00         23308.00   \n",
       "30-06-2016              0.00            3915.00         25190.00   \n",
       "30-09-2016              0.00            4167.00         27177.00   \n",
       "31-03-2017              0.00            6327.00         32632.00   \n",
       "30-06-2017              0.00            6524.00         37083.00   \n",
       "30-09-2017              0.00            6779.00         45335.00   \n",
       "31-03-2018              0.00           11199.00         52331.00   \n",
       "30-06-2018              0.00           13733.00         54768.00   \n",
       "30-09-2018              0.00           16616.00         58019.00   \n",
       "31-03-2019          20132.00           23193.00         61048.00   \n",
       "30-06-2019          21649.00           25818.00         64723.00   \n",
       "30-09-2019          23114.00           27952.00         67662.00   \n",
       "31-03-2020          26279.00           33755.00         77779.00   \n",
       "30-06-2020          28537.00           38998.00         86517.00   \n",
       "30-09-2020          34119.00           45329.00         99981.00   \n",
       "31-03-2021          39328.00           60658.00        121461.00   \n",
       "30-06-2021          43346.00           68436.00        133502.00   \n",
       "30-09-2021          52151.00           71592.00        147152.00   \n",
       "31-03-2022          56161.00           82071.00        168468.00   \n",
       "30-06-2022          58430.00           80043.00        173706.00   \n",
       "30-09-2022          62033.00           82915.00        177195.00   \n",
       "31-03-2023          68262.00           86365.00        190754.00   \n",
       "30-06-2023          70332.00           93115.00        193784.00   \n",
       "30-09-2023          70758.00          102994.00        196468.00   \n",
       "\n",
       "            total assets  total current assets  total current liabilities  \\\n",
       "Date                                                                        \n",
       "30-09-2013      31861.00              17334.00                   16135.00   \n",
       "31-03-2014      36364.00              19327.00                   18357.00   \n",
       "30-06-2014      37898.00              18755.00                   18751.00   \n",
       "30-09-2014      40419.00              18572.00                   20842.00   \n",
       "31-03-2015      50075.00              25922.00                   23177.00   \n",
       "30-06-2015      52440.00              26391.00                   23912.00   \n",
       "30-09-2015      56230.00              28849.00                   26657.00   \n",
       "31-03-2016      61128.00              30513.00                   28187.00   \n",
       "30-06-2016      65076.00              32220.00                   29587.00   \n",
       "30-09-2016      70897.00              35609.00                   33498.00   \n",
       "31-03-2017      80969.00              39460.00                   37399.00   \n",
       "30-06-2017      87781.00              41007.00                   40520.00   \n",
       "30-09-2017     115267.00              48578.00                   47072.00   \n",
       "31-03-2018     126362.00              50829.00                   48045.00   \n",
       "30-06-2018     134100.00              54481.00                   50801.00   \n",
       "30-09-2018     143695.00              59885.00                   55324.00   \n",
       "31-03-2019     178102.00              69431.00                   63695.00   \n",
       "30-06-2019     191351.00              76790.00                   69678.00   \n",
       "30-09-2019     199099.00              79054.00                   72136.00   \n",
       "31-03-2020     221238.00              85985.00                   79711.00   \n",
       "30-06-2020     258314.00             110908.00                   93896.00   \n",
       "30-09-2020     282179.00             112969.00                  101912.00   \n",
       "31-03-2021     323077.00             121408.00                  115404.00   \n",
       "30-06-2021     360319.00             140848.00                  117792.00   \n",
       "30-09-2021     382406.00             138531.00                  123994.00   \n",
       "31-03-2022     410767.00             133876.00                  139508.00   \n",
       "30-06-2022     419728.00             133667.00                  140291.00   \n",
       "30-09-2022     428362.00             131463.00                  140363.00   \n",
       "31-03-2023     464378.00             136221.00                  147570.00   \n",
       "30-06-2023     477607.00             140482.00                  148238.00   \n",
       "30-09-2023     486883.00             142995.00                  145214.00   \n",
       "\n",
       "            total liabilities and equity  total non operating expenses  \\\n",
       "Date                                                                     \n",
       "30-09-2013                      31861.00                        -18.00   \n",
       "31-03-2014                      36364.00                        -26.00   \n",
       "30-06-2014                      37898.00                        -12.00   \n",
       "30-09-2014                      40419.00                        -90.00   \n",
       "31-03-2015                      50075.00                       -234.00   \n",
       "30-06-2015                      52440.00                       -102.00   \n",
       "30-09-2015                      56230.00                       -159.00   \n",
       "31-03-2016                      61128.00                        -15.00   \n",
       "30-06-2016                      65076.00                       -106.00   \n",
       "30-09-2016                      70897.00                        -84.00   \n",
       "31-03-2017                      80969.00                        -52.00   \n",
       "30-06-2017                      87781.00                         38.00   \n",
       "30-09-2017                     115267.00                        -31.00   \n",
       "31-03-2018                     126362.00                        -11.00   \n",
       "30-06-2018                     134100.00                       -378.00   \n",
       "30-09-2018                     143695.00                       -334.00   \n",
       "31-03-2019                     178102.00                        -19.00   \n",
       "30-06-2019                     191351.00                       -195.00   \n",
       "30-09-2019                     199099.00                       -525.00   \n",
       "31-03-2020                     221238.00                       -606.00   \n",
       "30-06-2020                     258314.00                        378.00   \n",
       "30-09-2020                     282179.00                        615.00   \n",
       "31-03-2021                     323077.00                       1403.00   \n",
       "30-06-2021                     360319.00                        932.00   \n",
       "30-09-2021                     382406.00                       -537.00   \n",
       "31-03-2022                     410767.00                      -8934.00   \n",
       "30-06-2022                     419728.00                      -5970.00   \n",
       "30-09-2022                     428362.00                        419.00   \n",
       "31-03-2023                     464378.00                       -655.00   \n",
       "30-06-2023                     477607.00                       -118.00   \n",
       "30-09-2023                     486883.00                       1001.00   \n",
       "\n",
       "            total operating expenses  total revenues  \\\n",
       "Date                                                   \n",
       "30-09-2013                  17117.00        17092.00   \n",
       "31-03-2014                  19595.00        19741.00   \n",
       "30-06-2014                  19355.00        19340.00   \n",
       "30-09-2014                  21123.00        20579.00   \n",
       "31-03-2015                  22462.00        22717.00   \n",
       "30-06-2015                  22721.00        23185.00   \n",
       "30-09-2015                  24952.00        25358.00   \n",
       "31-03-2016                  28057.00        29128.00   \n",
       "30-06-2016                  29119.00        30404.00   \n",
       "30-09-2016                  32139.00        32714.00   \n",
       "31-03-2017                  34709.00        35714.00   \n",
       "30-06-2017                  37327.00        37955.00   \n",
       "30-09-2017                  43397.00        43744.00   \n",
       "31-03-2018                  49115.00        51042.00   \n",
       "30-06-2018                  49903.00        52886.00   \n",
       "30-09-2018                  52852.00        56576.00   \n",
       "31-03-2019                  55280.00        59700.00   \n",
       "30-06-2019                  60320.00        63404.00   \n",
       "30-09-2019                  66824.00        69981.00   \n",
       "31-03-2020                  71463.00        75452.00   \n",
       "30-06-2020                  83069.00        88912.00   \n",
       "30-09-2020                  89951.00        96145.00   \n",
       "31-03-2021                  99653.00       108518.00   \n",
       "30-06-2021                 105378.00       113080.00   \n",
       "30-09-2021                 105960.00       110812.00   \n",
       "31-03-2022                 112775.00       116444.00   \n",
       "30-06-2022                 117917.00       121234.00   \n",
       "30-09-2022                 124576.00       127101.00   \n",
       "31-03-2023                 122584.00       127358.00   \n",
       "30-06-2023                 126702.00       134383.00   \n",
       "30-09-2023                 131895.00       143083.00   \n",
       "\n",
       "            total shareholders equity  bond_yield  share_price  \\\n",
       "Date                                                             \n",
       "30-09-2013                    9087.00         NaN          NaN   \n",
       "31-03-2014                   10328.00         NaN          NaN   \n",
       "30-06-2014                   10602.00         NaN          NaN   \n",
       "30-09-2014                   10336.00         NaN          NaN   \n",
       "31-03-2015                   10873.00         NaN          NaN   \n",
       "30-06-2015                   11768.00         NaN          NaN   \n",
       "30-09-2015                   12430.00         NaN          NaN   \n",
       "31-03-2016                   14756.00         NaN          NaN   \n",
       "30-06-2016                   16538.00         NaN          NaN   \n",
       "30-09-2016                   17782.00         NaN          NaN   \n",
       "31-03-2017                   21674.00         NaN          NaN   \n",
       "30-06-2017                   23214.00         NaN          NaN   \n",
       "30-09-2017                   24658.00         NaN          NaN   \n",
       "31-03-2018                   31463.00         NaN          NaN   \n",
       "30-06-2018                   34995.00         NaN          NaN   \n",
       "30-09-2018                   39125.00         NaN          NaN   \n",
       "31-03-2019                   48410.00        0.02        89.04   \n",
       "30-06-2019                   53061.00        0.02        94.68   \n",
       "30-09-2019                   56508.00        0.02        86.80   \n",
       "31-03-2020                   65272.00        0.00        97.49   \n",
       "30-06-2020                   73728.00        0.00       137.94   \n",
       "30-09-2020                   82775.00        0.00       157.44   \n",
       "31-03-2021                  103320.00        0.00       154.70   \n",
       "30-06-2021                  114803.00        0.00       172.01   \n",
       "30-09-2021                  120564.00        0.00       164.25   \n",
       "31-03-2022                  134001.00        0.00       163.00   \n",
       "30-06-2022                  131402.00        0.02       106.21   \n",
       "30-09-2022                  137489.00        0.03       113.00   \n",
       "31-03-2023                  154526.00        0.05       103.29   \n",
       "30-06-2023                  168602.00        0.05       130.36   \n",
       "30-09-2023                  182973.00        0.05       127.12   \n",
       "\n",
       "            eps growth rate  intrinsic value  owner earnings  \\\n",
       "Date                                                           \n",
       "30-09-2013             0.00              NaN          997.00   \n",
       "31-03-2014            -3.56              NaN         1188.00   \n",
       "30-06-2014            -2.17              NaN         1164.00   \n",
       "30-09-2014             2.52              NaN          941.00   \n",
       "31-03-2015            -0.87              NaN          814.00   \n",
       "30-06-2015            -2.58              NaN         1305.00   \n",
       "30-09-2015            -0.11              NaN         1274.00   \n",
       "31-03-2016             5.29              NaN         1692.00   \n",
       "30-06-2016             0.66              NaN         2568.00   \n",
       "30-09-2016            -0.71              NaN         2093.00   \n",
       "31-03-2017             1.85              NaN         2585.00   \n",
       "30-06-2017            -0.73              NaN         2698.00   \n",
       "30-09-2017             0.30              NaN         2915.00   \n",
       "31-03-2018             5.29              NaN         4727.00   \n",
       "30-06-2018             0.55              NaN         5777.00   \n",
       "30-09-2018             0.13              NaN         5957.00   \n",
       "31-03-2019             0.23         12014.86         6851.00   \n",
       "30-06-2019            -0.26          8998.15         6187.00   \n",
       "30-09-2019            -0.19          8539.11         6831.00   \n",
       "31-03-2020             0.18        651679.02         9330.00   \n",
       "30-06-2020             1.06        356241.25        12702.00   \n",
       "30-09-2020             0.20        570017.51        17394.00   \n",
       "31-03-2021             0.28       4838175.30        20189.00   \n",
       "30-06-2021            -0.04       1399605.48        22066.00   \n",
       "30-09-2021            -0.60        702967.33        18904.00   \n",
       "31-03-2022            -2.24        -27187.50        11107.00   \n",
       "30-06-2022            -0.97          -360.41        13696.00   \n",
       "30-09-2022            -2.40           143.35        19250.00   \n",
       "31-03-2023             0.11           259.24        17379.00   \n",
       "30-06-2023             1.10           593.51        18205.00   \n",
       "30-09-2023             0.45           732.95        22358.00   \n",
       "\n",
       "            invested capital  roic  current ratio  net current assets   bvps  \\\n",
       "Date                                                                           \n",
       "30-09-2013          40307.00  0.02           1.07             1199.00  19.97   \n",
       "31-03-2014          44539.00  0.03           1.05              970.00  22.02   \n",
       "30-06-2014          47057.00  0.02           1.00                4.00  22.75   \n",
       "30-09-2014          52564.00  0.02           0.89            -2270.00  22.47   \n",
       "31-03-2015          57051.00  0.01           1.12             2745.00  22.89   \n",
       "30-06-2015          59789.00  0.02           1.10             2479.00  24.31   \n",
       "30-09-2015          65396.00  0.02           1.08             2192.00  26.79   \n",
       "31-03-2016          69690.00  0.02           1.08             2326.00  30.81   \n",
       "30-06-2016          74272.00  0.03           1.09             2633.00  34.38   \n",
       "30-09-2016          81848.00  0.03           1.06             2111.00  36.74   \n",
       "31-03-2017          91383.00  0.03           1.06             2061.00  44.32   \n",
       "30-06-2017         101785.00  0.03           1.01              487.00  47.18   \n",
       "30-09-2017         132876.00  0.02           1.03             1506.00  50.12   \n",
       "31-03-2018         143262.00  0.03           1.06             2784.00  63.18   \n",
       "30-06-2018         151847.00  0.04           1.07             3680.00  70.13   \n",
       "30-09-2018         163254.00  0.04           1.08             4561.00  78.09   \n",
       "31-03-2019         197479.00  0.03           1.09             5736.00  96.43   \n",
       "30-06-2019         212091.00  0.03           1.10             7112.00 105.70   \n",
       "30-09-2019         220453.00  0.03           1.10             6918.00 112.12   \n",
       "31-03-2020         242793.00  0.04           1.08             6274.00 129.25   \n",
       "30-06-2020         271822.00  0.05           1.18            17012.00 144.85   \n",
       "30-09-2020         306438.00  0.06           1.11            11057.00 161.99   \n",
       "31-03-2021         354672.00  0.06           1.05             6004.00 201.40   \n",
       "30-06-2021         377522.00  0.06           1.20            23056.00 223.35   \n",
       "30-09-2021         416438.00  0.05           1.12            14537.00 234.10   \n",
       "31-03-2022         471070.00  0.02           0.96            -5632.00 263.78   \n",
       "30-06-2022         486491.00  0.03           0.95            -6624.00  12.96   \n",
       "30-09-2022         497434.00  0.04           0.94            -8900.00  13.40   \n",
       "31-03-2023         533262.00  0.03           0.92           -11349.00  15.10   \n",
       "30-06-2023         547353.00  0.03           0.95            -7756.00  16.24   \n",
       "30-09-2023         553530.00  0.04           0.98            -2219.00  17.41   \n",
       "\n",
       "            pe ratio  pb ratio  multiplier pb  margin safety  total debt  \\\n",
       "Date                                                                       \n",
       "30-09-2013       NaN       NaN            NaN            NaN    22774.00   \n",
       "31-03-2014       NaN       NaN            NaN            NaN    26036.00   \n",
       "30-06-2014       NaN       NaN            NaN            NaN    27296.00   \n",
       "30-09-2014       NaN       NaN            NaN            NaN    30083.00   \n",
       "31-03-2015       NaN       NaN            NaN            NaN    39202.00   \n",
       "30-06-2015       NaN       NaN            NaN            NaN    40672.00   \n",
       "30-09-2015       NaN       NaN            NaN            NaN    43800.00   \n",
       "31-03-2016       NaN       NaN            NaN            NaN    46372.00   \n",
       "30-06-2016       NaN       NaN            NaN            NaN    48538.00   \n",
       "30-09-2016       NaN       NaN            NaN            NaN    53115.00   \n",
       "31-03-2017       NaN       NaN            NaN            NaN    59295.00   \n",
       "30-06-2017       NaN       NaN            NaN            NaN    64567.00   \n",
       "30-09-2017       NaN       NaN            NaN            NaN    90609.00   \n",
       "31-03-2018       NaN       NaN            NaN            NaN    94899.00   \n",
       "30-06-2018       NaN       NaN            NaN            NaN    99105.00   \n",
       "30-09-2018       NaN       NaN            NaN            NaN   104570.00   \n",
       "31-03-2019     12.56      0.92          11.59           0.99   129692.00   \n",
       "30-06-2019     18.14      0.90          16.25           0.99   138290.00   \n",
       "30-09-2019     20.52      0.77          15.88           0.99   142591.00   \n",
       "31-03-2020     19.46      0.75          14.68           1.00   155966.00   \n",
       "30-06-2020     13.39      0.95          12.75           1.00   184586.00   \n",
       "30-09-2020     12.73      0.97          12.37           1.00   199404.00   \n",
       "31-03-2021      9.80      0.77           7.53           1.00   219757.00   \n",
       "30-06-2021     11.38      0.77           8.76           1.00   245516.00   \n",
       "30-09-2021     26.84      0.70          18.83           1.00   261842.00   \n",
       "31-03-2022    -21.56      0.62         -13.32           1.01   276766.00   \n",
       "30-06-2022   -531.05      8.20       -4352.48           1.29   288326.00   \n",
       "30-09-2022    403.57      8.43        3402.13           0.21   290873.00   \n",
       "31-03-2023    333.19      6.84        2278.84           0.60   309852.00   \n",
       "30-06-2023    200.55      8.03        1610.19           0.78   309005.00   \n",
       "30-09-2023    135.23      7.30         987.36           0.83   303910.00   \n",
       "\n",
       "            tbvps    ncav  \n",
       "Date                       \n",
       "30-09-2013  21.96  -11.96  \n",
       "31-03-2014  26.16  -14.30  \n",
       "30-06-2014  30.23  -18.33  \n",
       "30-09-2014  34.13  -25.02  \n",
       "31-03-2015  37.34  -27.96  \n",
       "30-06-2015  40.25  -29.51  \n",
       "30-09-2015  44.47  -32.22  \n",
       "31-03-2016  48.66  -33.11  \n",
       "30-06-2016  52.37  -33.93  \n",
       "30-09-2016  56.15  -36.17  \n",
       "31-03-2017  66.73  -40.56  \n",
       "30-06-2017  75.37  -47.89  \n",
       "30-09-2017  92.14  -85.43  \n",
       "31-03-2018 105.08  -88.49  \n",
       "30-06-2018 109.76  -89.43  \n",
       "30-09-2018 115.81  -89.19  \n",
       "31-03-2019 121.61 -120.04  \n",
       "30-06-2019 128.93 -122.51  \n",
       "30-09-2019 134.25 -126.07  \n",
       "31-03-2020 154.02 -138.58  \n",
       "30-06-2020 169.97 -144.75  \n",
       "30-09-2020 195.66 -169.15  \n",
       "31-03-2021 236.77 -191.71  \n",
       "30-06-2021 259.73 -203.63  \n",
       "30-09-2021 285.73 -239.44  \n",
       "31-03-2022 331.63 -281.28  \n",
       "30-06-2022  17.13  -15.25  \n",
       "30-09-2022  17.28  -15.54  \n",
       "31-03-2023  18.64  -16.97  \n",
       "30-06-2023  18.66  -16.23  \n",
       "30-09-2023  18.70  -15.31  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "user_cik = input(\"Enter the CIK: \")\n",
    "show_ticker_from_cik(user_cik, selenium_df=selenium_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "eb4d6217",
   "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>Defensive Assets</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>META</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>KFRC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NVDA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>TER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>TITN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>NSYS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>AIN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>FAST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>GGG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>GRMN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Defensive Assets\n",
       "0             META\n",
       "1             KFRC\n",
       "2             NVDA\n",
       "3              TER\n",
       "4             TITN\n",
       "5             NSYS\n",
       "6              AIN\n",
       "7             FAST\n",
       "8              GGG\n",
       "9             GRMN"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>Enterprising Assets</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>MSFT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TSLA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>MYE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>WMT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>RIVN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>TXN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Enterprising Assets\n",
       "0                MSFT\n",
       "1                TSLA\n",
       "2                 MYE\n",
       "3                 WMT\n",
       "4                RIVN\n",
       "5                 TXN"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>NCAV Assets</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [NCAV Assets]\n",
       "Index: []"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "defensive_selenium, enterprising_selenium, ncav_selenium = classify_multiple_ciks(ciks, 'selenium', selenium_df=selenium_df)\n",
    "\n",
    "display(defensive_selenium)\n",
    "display(enterprising_selenium)\n",
    "display(ncav_selenium)"
   ]
  }
 ],
 "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.11.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}