CompanyConcept.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "aaf832d4",
   "metadata": {},
   "outputs": [],
   "source": [
    "from Quantamental_functions import *\n",
    "\n",
    "%load_ext autoreload\n",
    "%autoreload 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "e6727748",
   "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": "60dc09e7",
   "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": "3972e46b",
   "metadata": {},
   "outputs": [],
   "source": [
    "facts_file = fetch_form_accno()\n",
    "form_accno, form_accno_concept, url_facts, url_submissions = load_pickle(facts_file)\n",
    "#form_accno, form_accno_concept, url_facts, url_submissions = load_pickle('accno_data.pkl')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "1bcf90c4",
   "metadata": {},
   "outputs": [],
   "source": [
    "concept_responses = fetch_concept_url(form_accno_concept)\n",
    "concept_urls = load_pickle(concept_responses)\n",
    "#concept_urls = load_pickle('concept_urls.pkl')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "aafebfc4",
   "metadata": {},
   "outputs": [],
   "source": [
    "concept_file = fetch_concept(form_accno_concept, concept_urls)\n",
    "concept_data = load_pickle(concept_file)\n",
    "#concept_data = load_pickle('concept_data.pkl')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "31ae379c",
   "metadata": {},
   "outputs": [],
   "source": [
    "concept_df_file = dfs_facts_tickers(concept_data, bond_yield, 'concept')\n",
    "concept_df = load_pickle(concept_df_file)\n",
    "#concept_df = load_pickle('concept_df_file.pkl')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "59b6f760",
   "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>9</th>\n",
       "      <td>1730168</td>\n",
       "      <td>AVGO</td>\n",
       "      <td>BROADCOM INC.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>513</th>\n",
       "      <td>1383312</td>\n",
       "      <td>BR</td>\n",
       "      <td>BROADRIDGE FINANCIAL SOLUTIONS, INC.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1036</th>\n",
       "      <td>1611983</td>\n",
       "      <td>LBRDA</td>\n",
       "      <td>LIBERTY BROADBAND CORP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1666</th>\n",
       "      <td>1424182</td>\n",
       "      <td>BNL</td>\n",
       "      <td>BROADSTONE NET LEASE, INC.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4967</th>\n",
       "      <td>1120370</td>\n",
       "      <td>BWEN</td>\n",
       "      <td>BROADWIND, INC.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5210</th>\n",
       "      <td>1865120</td>\n",
       "      <td>BRAC</td>\n",
       "      <td>BROAD CAPITAL ACQUISITION CORP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5319</th>\n",
       "      <td>1001171</td>\n",
       "      <td>BYFC</td>\n",
       "      <td>BROADWAY FINANCIAL CORP DE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5839</th>\n",
       "      <td>1099160</td>\n",
       "      <td>BBGI</td>\n",
       "      <td>BEASLEY BROADCAST GROUP INC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6092</th>\n",
       "      <td>1452583</td>\n",
       "      <td>CBMJ</td>\n",
       "      <td>CONSERVATIVE BROADCAST MEDIA &amp; PUBLISHING, INC.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6236</th>\n",
       "      <td>764897</td>\n",
       "      <td>BRST</td>\n",
       "      <td>BROAD STREET REALTY, INC.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7398</th>\n",
       "      <td>1970371</td>\n",
       "      <td>OMG</td>\n",
       "      <td>BROAD CAPITAL ACQUISITION LTD</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      cik_str ticker                                            title\n",
       "9     1730168   AVGO                                    BROADCOM INC.\n",
       "513   1383312     BR             BROADRIDGE FINANCIAL SOLUTIONS, INC.\n",
       "1036  1611983  LBRDA                           LIBERTY BROADBAND CORP\n",
       "1666  1424182    BNL                       BROADSTONE NET LEASE, INC.\n",
       "4967  1120370   BWEN                                  BROADWIND, INC.\n",
       "5210  1865120   BRAC                   BROAD CAPITAL ACQUISITION CORP\n",
       "5319  1001171   BYFC                       BROADWAY FINANCIAL CORP DE\n",
       "5839  1099160   BBGI                      BEASLEY BROADCAST GROUP INC\n",
       "6092  1452583   CBMJ  CONSERVATIVE BROADCAST MEDIA & PUBLISHING, INC.\n",
       "6236   764897   BRST                        BROAD STREET REALTY, INC.\n",
       "7398  1970371    OMG                    BROAD CAPITAL ACQUISITION LTD"
      ]
     },
     "execution_count": 8,
     "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": 9,
   "id": "298e5578",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CIK: 1730168\n",
      "AVGO is classified as Enterprising.\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 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 amortisation</th>\n",
       "      <th>diluted earnings per share</th>\n",
       "      <th>goodwill</th>\n",
       "      <th>gross profit</th>\n",
       "      <th>income before income taxes</th>\n",
       "      <th>intangible assets</th>\n",
       "      <th>inventories</th>\n",
       "      <th>long term debt</th>\n",
       "      <th>net income</th>\n",
       "      <th>nshares</th>\n",
       "      <th>operating income</th>\n",
       "      <th>operating leases</th>\n",
       "      <th>research and development expense</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</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>share_price</th>\n",
       "      <th>marketable securities</th>\n",
       "      <th>bond_yield</th>\n",
       "      <th>eps growth rate</th>\n",
       "      <th>intrinsic value</th>\n",
       "      <th>margin safety</th>\n",
       "      <th>current ratio</th>\n",
       "      <th>net current assets</th>\n",
       "      <th>pe ratio</th>\n",
       "      <th>bvps</th>\n",
       "      <th>pb ratio</th>\n",
       "      <th>multiplier pb</th>\n",
       "      <th>total debt</th>\n",
       "      <th>tbvps</th>\n",
       "      <th>ncav</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2018-06-30</th>\n",
       "      <td>1105000000.00</td>\n",
       "      <td>2448000000.00</td>\n",
       "      <td>1418000000.00</td>\n",
       "      <td>1.69</td>\n",
       "      <td>581000000.00</td>\n",
       "      <td>-967000000.00</td>\n",
       "      <td>-812000000.00</td>\n",
       "      <td>2936000000.00</td>\n",
       "      <td>1157000000.00</td>\n",
       "      <td>4352000000.00</td>\n",
       "      <td>882000000.00</td>\n",
       "      <td>1.63</td>\n",
       "      <td>24706000000.00</td>\n",
       "      <td>3977000000.00</td>\n",
       "      <td>632000000.00</td>\n",
       "      <td>10832000000.00</td>\n",
       "      <td>1447000000.00</td>\n",
       "      <td>17548000000.00</td>\n",
       "      <td>679000000.00</td>\n",
       "      <td>408732155.00</td>\n",
       "      <td>980000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>1637000000.00</td>\n",
       "      <td>-129000000.00</td>\n",
       "      <td>2599000000.00</td>\n",
       "      <td>54418000000.00</td>\n",
       "      <td>15823000000.00</td>\n",
       "      <td>2529000000.00</td>\n",
       "      <td>31232000000.00</td>\n",
       "      <td>54418000000.00</td>\n",
       "      <td>34000000.00</td>\n",
       "      <td>2997000000.00</td>\n",
       "      <td>8329000000.00</td>\n",
       "      <td>20285000000.00</td>\n",
       "      <td>246.73</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>6.26</td>\n",
       "      <td>13294000000.00</td>\n",
       "      <td>151.37</td>\n",
       "      <td>49.63</td>\n",
       "      <td>4.97</td>\n",
       "      <td>752.52</td>\n",
       "      <td>34133000000.00</td>\n",
       "      <td>6.36</td>\n",
       "      <td>-44.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-30</th>\n",
       "      <td>1105000000.00</td>\n",
       "      <td>2448000000.00</td>\n",
       "      <td>1418000000.00</td>\n",
       "      <td>2.88</td>\n",
       "      <td>836000000.00</td>\n",
       "      <td>-1370000000.00</td>\n",
       "      <td>-1070000000.00</td>\n",
       "      <td>4592000000.00</td>\n",
       "      <td>2152000000.00</td>\n",
       "      <td>6666000000.00</td>\n",
       "      <td>3518000000.00</td>\n",
       "      <td>2.77</td>\n",
       "      <td>24706000000.00</td>\n",
       "      <td>6126000000.00</td>\n",
       "      <td>1180000000.00</td>\n",
       "      <td>10832000000.00</td>\n",
       "      <td>1447000000.00</td>\n",
       "      <td>17548000000.00</td>\n",
       "      <td>1160000000.00</td>\n",
       "      <td>408732155.00</td>\n",
       "      <td>1628000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>2464000000.00</td>\n",
       "      <td>-129000000.00</td>\n",
       "      <td>2599000000.00</td>\n",
       "      <td>54418000000.00</td>\n",
       "      <td>15823000000.00</td>\n",
       "      <td>2529000000.00</td>\n",
       "      <td>31232000000.00</td>\n",
       "      <td>54418000000.00</td>\n",
       "      <td>46000000.00</td>\n",
       "      <td>4498000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>20285000000.00</td>\n",
       "      <td>246.73</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.70</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>6.26</td>\n",
       "      <td>13294000000.00</td>\n",
       "      <td>89.07</td>\n",
       "      <td>49.63</td>\n",
       "      <td>4.97</td>\n",
       "      <td>442.82</td>\n",
       "      <td>34133000000.00</td>\n",
       "      <td>6.36</td>\n",
       "      <td>-44.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-12-31</th>\n",
       "      <td>1105000000.00</td>\n",
       "      <td>2448000000.00</td>\n",
       "      <td>1418000000.00</td>\n",
       "      <td>2.88</td>\n",
       "      <td>836000000.00</td>\n",
       "      <td>-1370000000.00</td>\n",
       "      <td>-1070000000.00</td>\n",
       "      <td>4592000000.00</td>\n",
       "      <td>2152000000.00</td>\n",
       "      <td>6666000000.00</td>\n",
       "      <td>3518000000.00</td>\n",
       "      <td>2.77</td>\n",
       "      <td>24706000000.00</td>\n",
       "      <td>6126000000.00</td>\n",
       "      <td>1180000000.00</td>\n",
       "      <td>10832000000.00</td>\n",
       "      <td>1447000000.00</td>\n",
       "      <td>17548000000.00</td>\n",
       "      <td>1160000000.00</td>\n",
       "      <td>408732155.00</td>\n",
       "      <td>1628000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>2464000000.00</td>\n",
       "      <td>-129000000.00</td>\n",
       "      <td>2599000000.00</td>\n",
       "      <td>54418000000.00</td>\n",
       "      <td>15823000000.00</td>\n",
       "      <td>2529000000.00</td>\n",
       "      <td>31232000000.00</td>\n",
       "      <td>54418000000.00</td>\n",
       "      <td>46000000.00</td>\n",
       "      <td>4498000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>20285000000.00</td>\n",
       "      <td>254.28</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>6.26</td>\n",
       "      <td>13294000000.00</td>\n",
       "      <td>91.80</td>\n",
       "      <td>49.63</td>\n",
       "      <td>5.12</td>\n",
       "      <td>470.34</td>\n",
       "      <td>34133000000.00</td>\n",
       "      <td>6.36</td>\n",
       "      <td>-44.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-31</th>\n",
       "      <td>811000000.00</td>\n",
       "      <td>3325000000.00</td>\n",
       "      <td>1418000000.00</td>\n",
       "      <td>1.17</td>\n",
       "      <td>99000000.00</td>\n",
       "      <td>13862000000.00</td>\n",
       "      <td>-15193000000.00</td>\n",
       "      <td>2132000000.00</td>\n",
       "      <td>2152000000.00</td>\n",
       "      <td>2581000000.00</td>\n",
       "      <td>143000000.00</td>\n",
       "      <td>14.62</td>\n",
       "      <td>26913000000.00</td>\n",
       "      <td>2628000000.00</td>\n",
       "      <td>278000000.00</td>\n",
       "      <td>10762000000.00</td>\n",
       "      <td>1124000000.00</td>\n",
       "      <td>17493000000.00</td>\n",
       "      <td>1160000000.00</td>\n",
       "      <td>407637618.00</td>\n",
       "      <td>943000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>1133000000.00</td>\n",
       "      <td>3487000000.00</td>\n",
       "      <td>2635000000.00</td>\n",
       "      <td>50124000000.00</td>\n",
       "      <td>9107000000.00</td>\n",
       "      <td>2338000000.00</td>\n",
       "      <td>23467000000.00</td>\n",
       "      <td>50124000000.00</td>\n",
       "      <td>68000000.00</td>\n",
       "      <td>2653000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>26657000000.00</td>\n",
       "      <td>300.71</td>\n",
       "      <td>0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>4.28</td>\n",
       "      <td>47129.53</td>\n",
       "      <td>0.99</td>\n",
       "      <td>3.90</td>\n",
       "      <td>6769000000.00</td>\n",
       "      <td>20.57</td>\n",
       "      <td>65.39</td>\n",
       "      <td>4.60</td>\n",
       "      <td>94.58</td>\n",
       "      <td>23467000000.00</td>\n",
       "      <td>6.46</td>\n",
       "      <td>-35.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-06-30</th>\n",
       "      <td>811000000.00</td>\n",
       "      <td>3325000000.00</td>\n",
       "      <td>1418000000.00</td>\n",
       "      <td>23.97</td>\n",
       "      <td>409000000.00</td>\n",
       "      <td>-2633000000.00</td>\n",
       "      <td>-4382000000.00</td>\n",
       "      <td>3998000000.00</td>\n",
       "      <td>-3017000000.00</td>\n",
       "      <td>5162000000.00</td>\n",
       "      <td>2148000000.00</td>\n",
       "      <td>22.99</td>\n",
       "      <td>26913000000.00</td>\n",
       "      <td>5179000000.00</td>\n",
       "      <td>1894000000.00</td>\n",
       "      <td>10762000000.00</td>\n",
       "      <td>1124000000.00</td>\n",
       "      <td>17493000000.00</td>\n",
       "      <td>9948000000.00</td>\n",
       "      <td>407637618.00</td>\n",
       "      <td>2144000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>1861000000.00</td>\n",
       "      <td>3487000000.00</td>\n",
       "      <td>2635000000.00</td>\n",
       "      <td>50124000000.00</td>\n",
       "      <td>9107000000.00</td>\n",
       "      <td>2338000000.00</td>\n",
       "      <td>23467000000.00</td>\n",
       "      <td>50124000000.00</td>\n",
       "      <td>81000000.00</td>\n",
       "      <td>3035000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>26657000000.00</td>\n",
       "      <td>287.86</td>\n",
       "      <td>0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.57</td>\n",
       "      <td>47943.50</td>\n",
       "      <td>0.99</td>\n",
       "      <td>3.90</td>\n",
       "      <td>6769000000.00</td>\n",
       "      <td>12.52</td>\n",
       "      <td>65.39</td>\n",
       "      <td>4.40</td>\n",
       "      <td>55.12</td>\n",
       "      <td>23467000000.00</td>\n",
       "      <td>6.46</td>\n",
       "      <td>-35.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-09-30</th>\n",
       "      <td>811000000.00</td>\n",
       "      <td>3325000000.00</td>\n",
       "      <td>1418000000.00</td>\n",
       "      <td>26.53</td>\n",
       "      <td>529000000.00</td>\n",
       "      <td>-8757000000.00</td>\n",
       "      <td>-4556000000.00</td>\n",
       "      <td>6245000000.00</td>\n",
       "      <td>-7068000000.00</td>\n",
       "      <td>7606000000.00</td>\n",
       "      <td>3113000000.00</td>\n",
       "      <td>25.74</td>\n",
       "      <td>26913000000.00</td>\n",
       "      <td>7798000000.00</td>\n",
       "      <td>3123000000.00</td>\n",
       "      <td>10762000000.00</td>\n",
       "      <td>1124000000.00</td>\n",
       "      <td>17493000000.00</td>\n",
       "      <td>11144000000.00</td>\n",
       "      <td>407637618.00</td>\n",
       "      <td>3483000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>2820000000.00</td>\n",
       "      <td>3487000000.00</td>\n",
       "      <td>2635000000.00</td>\n",
       "      <td>50124000000.00</td>\n",
       "      <td>9107000000.00</td>\n",
       "      <td>2338000000.00</td>\n",
       "      <td>23467000000.00</td>\n",
       "      <td>50124000000.00</td>\n",
       "      <td>120000000.00</td>\n",
       "      <td>4315000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>26657000000.00</td>\n",
       "      <td>276.07</td>\n",
       "      <td>0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.12</td>\n",
       "      <td>55919.25</td>\n",
       "      <td>1.00</td>\n",
       "      <td>3.90</td>\n",
       "      <td>6769000000.00</td>\n",
       "      <td>10.73</td>\n",
       "      <td>65.39</td>\n",
       "      <td>4.22</td>\n",
       "      <td>45.28</td>\n",
       "      <td>23467000000.00</td>\n",
       "      <td>6.46</td>\n",
       "      <td>-35.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-12-31</th>\n",
       "      <td>811000000.00</td>\n",
       "      <td>3325000000.00</td>\n",
       "      <td>1418000000.00</td>\n",
       "      <td>26.53</td>\n",
       "      <td>529000000.00</td>\n",
       "      <td>-8757000000.00</td>\n",
       "      <td>-4556000000.00</td>\n",
       "      <td>6245000000.00</td>\n",
       "      <td>-7068000000.00</td>\n",
       "      <td>7606000000.00</td>\n",
       "      <td>3113000000.00</td>\n",
       "      <td>25.74</td>\n",
       "      <td>26913000000.00</td>\n",
       "      <td>7798000000.00</td>\n",
       "      <td>3123000000.00</td>\n",
       "      <td>10762000000.00</td>\n",
       "      <td>1124000000.00</td>\n",
       "      <td>17493000000.00</td>\n",
       "      <td>11144000000.00</td>\n",
       "      <td>407637618.00</td>\n",
       "      <td>3483000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>2820000000.00</td>\n",
       "      <td>3487000000.00</td>\n",
       "      <td>2635000000.00</td>\n",
       "      <td>50124000000.00</td>\n",
       "      <td>9107000000.00</td>\n",
       "      <td>2338000000.00</td>\n",
       "      <td>23467000000.00</td>\n",
       "      <td>50124000000.00</td>\n",
       "      <td>120000000.00</td>\n",
       "      <td>4315000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>26657000000.00</td>\n",
       "      <td>316.02</td>\n",
       "      <td>0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.00</td>\n",
       "      <td>63965.18</td>\n",
       "      <td>1.00</td>\n",
       "      <td>3.90</td>\n",
       "      <td>6769000000.00</td>\n",
       "      <td>12.28</td>\n",
       "      <td>65.39</td>\n",
       "      <td>4.83</td>\n",
       "      <td>59.33</td>\n",
       "      <td>23467000000.00</td>\n",
       "      <td>6.46</td>\n",
       "      <td>-35.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-03-31</th>\n",
       "      <td>855000000.00</td>\n",
       "      <td>3259000000.00</td>\n",
       "      <td>1418000000.00</td>\n",
       "      <td>0.78</td>\n",
       "      <td>108000000.00</td>\n",
       "      <td>10054000000.00</td>\n",
       "      <td>-10987000000.00</td>\n",
       "      <td>2322000000.00</td>\n",
       "      <td>1389000000.00</td>\n",
       "      <td>2594000000.00</td>\n",
       "      <td>146000000.00</td>\n",
       "      <td>1.12</td>\n",
       "      <td>36714000000.00</td>\n",
       "      <td>3208000000.00</td>\n",
       "      <td>304000000.00</td>\n",
       "      <td>17554000000.00</td>\n",
       "      <td>874000000.00</td>\n",
       "      <td>32798000000.00</td>\n",
       "      <td>11144000000.00</td>\n",
       "      <td>397560810.00</td>\n",
       "      <td>555000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>1289000000.00</td>\n",
       "      <td>3487000000.00</td>\n",
       "      <td>2565000000.00</td>\n",
       "      <td>67493000000.00</td>\n",
       "      <td>9917000000.00</td>\n",
       "      <td>6899000000.00</td>\n",
       "      <td>42523000000.00</td>\n",
       "      <td>67493000000.00</td>\n",
       "      <td>-4000000.00</td>\n",
       "      <td>2550000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>26657000000.00</td>\n",
       "      <td>237.10</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-0.96</td>\n",
       "      <td>108202.85</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.44</td>\n",
       "      <td>3018000000.00</td>\n",
       "      <td>211.70</td>\n",
       "      <td>67.05</td>\n",
       "      <td>3.54</td>\n",
       "      <td>748.58</td>\n",
       "      <td>40836000000.00</td>\n",
       "      <td>6.45</td>\n",
       "      <td>-77.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-30</th>\n",
       "      <td>855000000.00</td>\n",
       "      <td>3259000000.00</td>\n",
       "      <td>1418000000.00</td>\n",
       "      <td>2.91</td>\n",
       "      <td>224000000.00</td>\n",
       "      <td>11536000000.00</td>\n",
       "      <td>-15299000000.00</td>\n",
       "      <td>4799000000.00</td>\n",
       "      <td>1036000000.00</td>\n",
       "      <td>5009000000.00</td>\n",
       "      <td>285000000.00</td>\n",
       "      <td>2.77</td>\n",
       "      <td>36714000000.00</td>\n",
       "      <td>6297000000.00</td>\n",
       "      <td>935000000.00</td>\n",
       "      <td>17554000000.00</td>\n",
       "      <td>874000000.00</td>\n",
       "      <td>32798000000.00</td>\n",
       "      <td>11144000000.00</td>\n",
       "      <td>397560810.00</td>\n",
       "      <td>1525000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>2284000000.00</td>\n",
       "      <td>3487000000.00</td>\n",
       "      <td>2565000000.00</td>\n",
       "      <td>67493000000.00</td>\n",
       "      <td>9917000000.00</td>\n",
       "      <td>6899000000.00</td>\n",
       "      <td>42523000000.00</td>\n",
       "      <td>67493000000.00</td>\n",
       "      <td>131000000.00</td>\n",
       "      <td>4772000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>26657000000.00</td>\n",
       "      <td>315.61</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.47</td>\n",
       "      <td>103340.05</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.44</td>\n",
       "      <td>3018000000.00</td>\n",
       "      <td>113.94</td>\n",
       "      <td>67.05</td>\n",
       "      <td>4.71</td>\n",
       "      <td>536.31</td>\n",
       "      <td>40836000000.00</td>\n",
       "      <td>6.45</td>\n",
       "      <td>-77.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-09-30</th>\n",
       "      <td>855000000.00</td>\n",
       "      <td>3259000000.00</td>\n",
       "      <td>1418000000.00</td>\n",
       "      <td>4.70</td>\n",
       "      <td>336000000.00</td>\n",
       "      <td>9286000000.00</td>\n",
       "      <td>-15334000000.00</td>\n",
       "      <td>7218000000.00</td>\n",
       "      <td>1170000000.00</td>\n",
       "      <td>7490000000.00</td>\n",
       "      <td>426000000.00</td>\n",
       "      <td>4.47</td>\n",
       "      <td>36714000000.00</td>\n",
       "      <td>9331000000.00</td>\n",
       "      <td>1479000000.00</td>\n",
       "      <td>17554000000.00</td>\n",
       "      <td>874000000.00</td>\n",
       "      <td>30011000000.00</td>\n",
       "      <td>11144000000.00</td>\n",
       "      <td>398000000.00</td>\n",
       "      <td>2390000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>3519000000.00</td>\n",
       "      <td>3487000000.00</td>\n",
       "      <td>2565000000.00</td>\n",
       "      <td>67493000000.00</td>\n",
       "      <td>9917000000.00</td>\n",
       "      <td>6899000000.00</td>\n",
       "      <td>42523000000.00</td>\n",
       "      <td>67493000000.00</td>\n",
       "      <td>172000000.00</td>\n",
       "      <td>6941000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>26657000000.00</td>\n",
       "      <td>364.32</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.61</td>\n",
       "      <td>225081.44</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.44</td>\n",
       "      <td>3018000000.00</td>\n",
       "      <td>81.50</td>\n",
       "      <td>66.98</td>\n",
       "      <td>5.44</td>\n",
       "      <td>443.33</td>\n",
       "      <td>40836000000.00</td>\n",
       "      <td>6.44</td>\n",
       "      <td>-77.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-12-31</th>\n",
       "      <td>855000000.00</td>\n",
       "      <td>3259000000.00</td>\n",
       "      <td>1418000000.00</td>\n",
       "      <td>4.70</td>\n",
       "      <td>336000000.00</td>\n",
       "      <td>9286000000.00</td>\n",
       "      <td>-15334000000.00</td>\n",
       "      <td>7218000000.00</td>\n",
       "      <td>1170000000.00</td>\n",
       "      <td>7490000000.00</td>\n",
       "      <td>426000000.00</td>\n",
       "      <td>4.47</td>\n",
       "      <td>36714000000.00</td>\n",
       "      <td>9331000000.00</td>\n",
       "      <td>1479000000.00</td>\n",
       "      <td>17554000000.00</td>\n",
       "      <td>874000000.00</td>\n",
       "      <td>30011000000.00</td>\n",
       "      <td>11144000000.00</td>\n",
       "      <td>398000000.00</td>\n",
       "      <td>2390000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>3519000000.00</td>\n",
       "      <td>3487000000.00</td>\n",
       "      <td>2565000000.00</td>\n",
       "      <td>67493000000.00</td>\n",
       "      <td>9917000000.00</td>\n",
       "      <td>6899000000.00</td>\n",
       "      <td>42523000000.00</td>\n",
       "      <td>67493000000.00</td>\n",
       "      <td>172000000.00</td>\n",
       "      <td>6941000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>26657000000.00</td>\n",
       "      <td>437.85</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>257196.93</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.44</td>\n",
       "      <td>3018000000.00</td>\n",
       "      <td>97.95</td>\n",
       "      <td>66.98</td>\n",
       "      <td>6.54</td>\n",
       "      <td>640.35</td>\n",
       "      <td>40836000000.00</td>\n",
       "      <td>6.44</td>\n",
       "      <td>-77.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-31</th>\n",
       "      <td>836000000.00</td>\n",
       "      <td>2297000000.00</td>\n",
       "      <td>1418000000.00</td>\n",
       "      <td>3.20</td>\n",
       "      <td>114000000.00</td>\n",
       "      <td>-1057000000.00</td>\n",
       "      <td>-122000000.00</td>\n",
       "      <td>3113000000.00</td>\n",
       "      <td>1934000000.00</td>\n",
       "      <td>2703000000.00</td>\n",
       "      <td>138000000.00</td>\n",
       "      <td>3.05</td>\n",
       "      <td>43447000000.00</td>\n",
       "      <td>3952000000.00</td>\n",
       "      <td>1384000000.00</td>\n",
       "      <td>16782000000.00</td>\n",
       "      <td>1003000000.00</td>\n",
       "      <td>40994000000.00</td>\n",
       "      <td>11144000000.00</td>\n",
       "      <td>407000000.00</td>\n",
       "      <td>1837000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>1211000000.00</td>\n",
       "      <td>3487000000.00</td>\n",
       "      <td>2509000000.00</td>\n",
       "      <td>75933000000.00</td>\n",
       "      <td>11895000000.00</td>\n",
       "      <td>6371000000.00</td>\n",
       "      <td>52032000000.00</td>\n",
       "      <td>75933000000.00</td>\n",
       "      <td>117000000.00</td>\n",
       "      <td>2115000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>26657000000.00</td>\n",
       "      <td>463.66</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-0.32</td>\n",
       "      <td>811874.19</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.87</td>\n",
       "      <td>5524000000.00</td>\n",
       "      <td>152.02</td>\n",
       "      <td>65.50</td>\n",
       "      <td>7.08</td>\n",
       "      <td>1076.17</td>\n",
       "      <td>49276000000.00</td>\n",
       "      <td>6.16</td>\n",
       "      <td>-91.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-06-30</th>\n",
       "      <td>836000000.00</td>\n",
       "      <td>2297000000.00</td>\n",
       "      <td>1418000000.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>256000000.00</td>\n",
       "      <td>9580000000.00</td>\n",
       "      <td>-10963000000.00</td>\n",
       "      <td>5535000000.00</td>\n",
       "      <td>4152000000.00</td>\n",
       "      <td>5147000000.00</td>\n",
       "      <td>293000000.00</td>\n",
       "      <td>1.91</td>\n",
       "      <td>43447000000.00</td>\n",
       "      <td>6453000000.00</td>\n",
       "      <td>713000000.00</td>\n",
       "      <td>16782000000.00</td>\n",
       "      <td>1003000000.00</td>\n",
       "      <td>40994000000.00</td>\n",
       "      <td>11144000000.00</td>\n",
       "      <td>407000000.00</td>\n",
       "      <td>1480000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>2558000000.00</td>\n",
       "      <td>3487000000.00</td>\n",
       "      <td>2509000000.00</td>\n",
       "      <td>75933000000.00</td>\n",
       "      <td>11895000000.00</td>\n",
       "      <td>6371000000.00</td>\n",
       "      <td>52032000000.00</td>\n",
       "      <td>75933000000.00</td>\n",
       "      <td>126000000.00</td>\n",
       "      <td>4973000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>26657000000.00</td>\n",
       "      <td>476.84</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-0.37</td>\n",
       "      <td>162879.17</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.87</td>\n",
       "      <td>5524000000.00</td>\n",
       "      <td>249.65</td>\n",
       "      <td>65.50</td>\n",
       "      <td>7.28</td>\n",
       "      <td>1817.59</td>\n",
       "      <td>49276000000.00</td>\n",
       "      <td>6.16</td>\n",
       "      <td>-91.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-30</th>\n",
       "      <td>836000000.00</td>\n",
       "      <td>2297000000.00</td>\n",
       "      <td>1418000000.00</td>\n",
       "      <td>3.52</td>\n",
       "      <td>361000000.00</td>\n",
       "      <td>6098000000.00</td>\n",
       "      <td>-11009000000.00</td>\n",
       "      <td>8713000000.00</td>\n",
       "      <td>3802000000.00</td>\n",
       "      <td>7652000000.00</td>\n",
       "      <td>431000000.00</td>\n",
       "      <td>3.36</td>\n",
       "      <td>43447000000.00</td>\n",
       "      <td>9769000000.00</td>\n",
       "      <td>1306000000.00</td>\n",
       "      <td>16782000000.00</td>\n",
       "      <td>1003000000.00</td>\n",
       "      <td>40994000000.00</td>\n",
       "      <td>11144000000.00</td>\n",
       "      <td>407000000.00</td>\n",
       "      <td>2488000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>3786000000.00</td>\n",
       "      <td>3487000000.00</td>\n",
       "      <td>2509000000.00</td>\n",
       "      <td>75933000000.00</td>\n",
       "      <td>11895000000.00</td>\n",
       "      <td>6371000000.00</td>\n",
       "      <td>52032000000.00</td>\n",
       "      <td>75933000000.00</td>\n",
       "      <td>175000000.00</td>\n",
       "      <td>7281000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>26657000000.00</td>\n",
       "      <td>484.93</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.76</td>\n",
       "      <td>528967.52</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.87</td>\n",
       "      <td>5524000000.00</td>\n",
       "      <td>144.32</td>\n",
       "      <td>65.50</td>\n",
       "      <td>7.40</td>\n",
       "      <td>1068.57</td>\n",
       "      <td>49276000000.00</td>\n",
       "      <td>6.16</td>\n",
       "      <td>-91.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-31</th>\n",
       "      <td>836000000.00</td>\n",
       "      <td>2297000000.00</td>\n",
       "      <td>1418000000.00</td>\n",
       "      <td>3.52</td>\n",
       "      <td>361000000.00</td>\n",
       "      <td>6098000000.00</td>\n",
       "      <td>-11009000000.00</td>\n",
       "      <td>8713000000.00</td>\n",
       "      <td>3802000000.00</td>\n",
       "      <td>7652000000.00</td>\n",
       "      <td>431000000.00</td>\n",
       "      <td>3.36</td>\n",
       "      <td>43447000000.00</td>\n",
       "      <td>9769000000.00</td>\n",
       "      <td>1306000000.00</td>\n",
       "      <td>16782000000.00</td>\n",
       "      <td>1003000000.00</td>\n",
       "      <td>40994000000.00</td>\n",
       "      <td>11144000000.00</td>\n",
       "      <td>407000000.00</td>\n",
       "      <td>2488000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>3786000000.00</td>\n",
       "      <td>3487000000.00</td>\n",
       "      <td>2509000000.00</td>\n",
       "      <td>75933000000.00</td>\n",
       "      <td>11895000000.00</td>\n",
       "      <td>6371000000.00</td>\n",
       "      <td>52032000000.00</td>\n",
       "      <td>75933000000.00</td>\n",
       "      <td>175000000.00</td>\n",
       "      <td>7281000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>26657000000.00</td>\n",
       "      <td>665.41</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>380800.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.87</td>\n",
       "      <td>5524000000.00</td>\n",
       "      <td>198.04</td>\n",
       "      <td>65.50</td>\n",
       "      <td>10.16</td>\n",
       "      <td>2011.97</td>\n",
       "      <td>49276000000.00</td>\n",
       "      <td>6.16</td>\n",
       "      <td>-91.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-31</th>\n",
       "      <td>1086000000.00</td>\n",
       "      <td>2071000000.00</td>\n",
       "      <td>1453000000.00</td>\n",
       "      <td>5.82</td>\n",
       "      <td>101000000.00</td>\n",
       "      <td>-5121000000.00</td>\n",
       "      <td>-309000000.00</td>\n",
       "      <td>3486000000.00</td>\n",
       "      <td>-1944000000.00</td>\n",
       "      <td>2657000000.00</td>\n",
       "      <td>136000000.00</td>\n",
       "      <td>5.59</td>\n",
       "      <td>43450000000.00</td>\n",
       "      <td>5049000000.00</td>\n",
       "      <td>2687000000.00</td>\n",
       "      <td>11374000000.00</td>\n",
       "      <td>1297000000.00</td>\n",
       "      <td>39440000000.00</td>\n",
       "      <td>11144000000.00</td>\n",
       "      <td>413000000.00</td>\n",
       "      <td>3108000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>1206000000.00</td>\n",
       "      <td>748000000.00</td>\n",
       "      <td>2348000000.00</td>\n",
       "      <td>75570000000.00</td>\n",
       "      <td>16586000000.00</td>\n",
       "      <td>6281000000.00</td>\n",
       "      <td>50581000000.00</td>\n",
       "      <td>75570000000.00</td>\n",
       "      <td>-14000000.00</td>\n",
       "      <td>1941000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>26657000000.00</td>\n",
       "      <td>629.68</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.66</td>\n",
       "      <td>49029.26</td>\n",
       "      <td>0.99</td>\n",
       "      <td>2.64</td>\n",
       "      <td>10305000000.00</td>\n",
       "      <td>112.64</td>\n",
       "      <td>64.54</td>\n",
       "      <td>9.76</td>\n",
       "      <td>1098.92</td>\n",
       "      <td>48913000000.00</td>\n",
       "      <td>5.69</td>\n",
       "      <td>-78.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-06-30</th>\n",
       "      <td>1086000000.00</td>\n",
       "      <td>2071000000.00</td>\n",
       "      <td>1453000000.00</td>\n",
       "      <td>6.67</td>\n",
       "      <td>240000000.00</td>\n",
       "      <td>-4534000000.00</td>\n",
       "      <td>-248000000.00</td>\n",
       "      <td>6682000000.00</td>\n",
       "      <td>1900000000.00</td>\n",
       "      <td>5256000000.00</td>\n",
       "      <td>271000000.00</td>\n",
       "      <td>6.34</td>\n",
       "      <td>43450000000.00</td>\n",
       "      <td>8009000000.00</td>\n",
       "      <td>2870000000.00</td>\n",
       "      <td>11374000000.00</td>\n",
       "      <td>1297000000.00</td>\n",
       "      <td>41235000000.00</td>\n",
       "      <td>11144000000.00</td>\n",
       "      <td>413000000.00</td>\n",
       "      <td>3812000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>2449000000.00</td>\n",
       "      <td>748000000.00</td>\n",
       "      <td>2348000000.00</td>\n",
       "      <td>75570000000.00</td>\n",
       "      <td>16586000000.00</td>\n",
       "      <td>6281000000.00</td>\n",
       "      <td>50581000000.00</td>\n",
       "      <td>75570000000.00</td>\n",
       "      <td>94000000.00</td>\n",
       "      <td>4197000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>26657000000.00</td>\n",
       "      <td>485.81</td>\n",
       "      <td>0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.13</td>\n",
       "      <td>15287.59</td>\n",
       "      <td>0.97</td>\n",
       "      <td>2.64</td>\n",
       "      <td>10305000000.00</td>\n",
       "      <td>76.63</td>\n",
       "      <td>64.54</td>\n",
       "      <td>7.53</td>\n",
       "      <td>576.74</td>\n",
       "      <td>48913000000.00</td>\n",
       "      <td>5.69</td>\n",
       "      <td>-78.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-30</th>\n",
       "      <td>1086000000.00</td>\n",
       "      <td>2071000000.00</td>\n",
       "      <td>1453000000.00</td>\n",
       "      <td>11.06</td>\n",
       "      <td>355000000.00</td>\n",
       "      <td>-6441000000.00</td>\n",
       "      <td>-295000000.00</td>\n",
       "      <td>10223000000.00</td>\n",
       "      <td>3487000000.00</td>\n",
       "      <td>7837000000.00</td>\n",
       "      <td>405000000.00</td>\n",
       "      <td>10.54</td>\n",
       "      <td>43450000000.00</td>\n",
       "      <td>12206000000.00</td>\n",
       "      <td>4596000000.00</td>\n",
       "      <td>11374000000.00</td>\n",
       "      <td>1297000000.00</td>\n",
       "      <td>41235000000.00</td>\n",
       "      <td>11144000000.00</td>\n",
       "      <td>413000000.00</td>\n",
       "      <td>5938000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>3654000000.00</td>\n",
       "      <td>748000000.00</td>\n",
       "      <td>2348000000.00</td>\n",
       "      <td>75570000000.00</td>\n",
       "      <td>16586000000.00</td>\n",
       "      <td>6281000000.00</td>\n",
       "      <td>50581000000.00</td>\n",
       "      <td>75570000000.00</td>\n",
       "      <td>109000000.00</td>\n",
       "      <td>6268000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>26657000000.00</td>\n",
       "      <td>444.01</td>\n",
       "      <td>0</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0.66</td>\n",
       "      <td>14328.32</td>\n",
       "      <td>0.97</td>\n",
       "      <td>2.64</td>\n",
       "      <td>10305000000.00</td>\n",
       "      <td>42.13</td>\n",
       "      <td>64.54</td>\n",
       "      <td>6.88</td>\n",
       "      <td>289.79</td>\n",
       "      <td>48913000000.00</td>\n",
       "      <td>5.69</td>\n",
       "      <td>-78.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-31</th>\n",
       "      <td>1086000000.00</td>\n",
       "      <td>2071000000.00</td>\n",
       "      <td>1453000000.00</td>\n",
       "      <td>11.06</td>\n",
       "      <td>355000000.00</td>\n",
       "      <td>-6441000000.00</td>\n",
       "      <td>-295000000.00</td>\n",
       "      <td>10223000000.00</td>\n",
       "      <td>3487000000.00</td>\n",
       "      <td>7837000000.00</td>\n",
       "      <td>405000000.00</td>\n",
       "      <td>10.54</td>\n",
       "      <td>43450000000.00</td>\n",
       "      <td>12206000000.00</td>\n",
       "      <td>4596000000.00</td>\n",
       "      <td>11374000000.00</td>\n",
       "      <td>1297000000.00</td>\n",
       "      <td>41235000000.00</td>\n",
       "      <td>11144000000.00</td>\n",
       "      <td>413000000.00</td>\n",
       "      <td>5938000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>3654000000.00</td>\n",
       "      <td>748000000.00</td>\n",
       "      <td>2348000000.00</td>\n",
       "      <td>75570000000.00</td>\n",
       "      <td>16586000000.00</td>\n",
       "      <td>6281000000.00</td>\n",
       "      <td>50581000000.00</td>\n",
       "      <td>75570000000.00</td>\n",
       "      <td>109000000.00</td>\n",
       "      <td>6268000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>26657000000.00</td>\n",
       "      <td>559.13</td>\n",
       "      <td>0</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.00</td>\n",
       "      <td>9253.43</td>\n",
       "      <td>0.94</td>\n",
       "      <td>2.64</td>\n",
       "      <td>10305000000.00</td>\n",
       "      <td>53.05</td>\n",
       "      <td>64.54</td>\n",
       "      <td>8.66</td>\n",
       "      <td>459.54</td>\n",
       "      <td>48913000000.00</td>\n",
       "      <td>5.69</td>\n",
       "      <td>-78.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-31</th>\n",
       "      <td>998000000.00</td>\n",
       "      <td>2958000000.00</td>\n",
       "      <td>1184000000.00</td>\n",
       "      <td>9.03</td>\n",
       "      <td>103000000.00</td>\n",
       "      <td>-3702000000.00</td>\n",
       "      <td>-103000000.00</td>\n",
       "      <td>4036000000.00</td>\n",
       "      <td>231000000.00</td>\n",
       "      <td>2911000000.00</td>\n",
       "      <td>127000000.00</td>\n",
       "      <td>8.80</td>\n",
       "      <td>43614000000.00</td>\n",
       "      <td>6004000000.00</td>\n",
       "      <td>3840000000.00</td>\n",
       "      <td>7111000000.00</td>\n",
       "      <td>1925000000.00</td>\n",
       "      <td>41235000000.00</td>\n",
       "      <td>11144000000.00</td>\n",
       "      <td>418000000.00</td>\n",
       "      <td>4103000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>1195000000.00</td>\n",
       "      <td>1604000000.00</td>\n",
       "      <td>2223000000.00</td>\n",
       "      <td>73249000000.00</td>\n",
       "      <td>18504000000.00</td>\n",
       "      <td>7052000000.00</td>\n",
       "      <td>50540000000.00</td>\n",
       "      <td>73249000000.00</td>\n",
       "      <td>143000000.00</td>\n",
       "      <td>1901000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>26657000000.00</td>\n",
       "      <td>641.54</td>\n",
       "      <td>0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>-0.17</td>\n",
       "      <td>6899.36</td>\n",
       "      <td>0.91</td>\n",
       "      <td>2.62</td>\n",
       "      <td>11452000000.00</td>\n",
       "      <td>72.90</td>\n",
       "      <td>63.77</td>\n",
       "      <td>10.06</td>\n",
       "      <td>733.38</td>\n",
       "      <td>46592000000.00</td>\n",
       "      <td>5.32</td>\n",
       "      <td>-67.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-06-30</th>\n",
       "      <td>998000000.00</td>\n",
       "      <td>2958000000.00</td>\n",
       "      <td>1184000000.00</td>\n",
       "      <td>11.98</td>\n",
       "      <td>186000000.00</td>\n",
       "      <td>-10268000000.00</td>\n",
       "      <td>-619000000.00</td>\n",
       "      <td>7729000000.00</td>\n",
       "      <td>-3158000000.00</td>\n",
       "      <td>5321000000.00</td>\n",
       "      <td>271000000.00</td>\n",
       "      <td>11.53</td>\n",
       "      <td>43614000000.00</td>\n",
       "      <td>10488000000.00</td>\n",
       "      <td>5477000000.00</td>\n",
       "      <td>7111000000.00</td>\n",
       "      <td>1925000000.00</td>\n",
       "      <td>41235000000.00</td>\n",
       "      <td>11144000000.00</td>\n",
       "      <td>418000000.00</td>\n",
       "      <td>6502000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>2467000000.00</td>\n",
       "      <td>1604000000.00</td>\n",
       "      <td>2223000000.00</td>\n",
       "      <td>73249000000.00</td>\n",
       "      <td>18504000000.00</td>\n",
       "      <td>7052000000.00</td>\n",
       "      <td>50540000000.00</td>\n",
       "      <td>73249000000.00</td>\n",
       "      <td>-100000000.00</td>\n",
       "      <td>3986000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>26657000000.00</td>\n",
       "      <td>867.43</td>\n",
       "      <td>0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.31</td>\n",
       "      <td>8979.21</td>\n",
       "      <td>0.90</td>\n",
       "      <td>2.62</td>\n",
       "      <td>11452000000.00</td>\n",
       "      <td>75.23</td>\n",
       "      <td>63.77</td>\n",
       "      <td>13.60</td>\n",
       "      <td>1023.30</td>\n",
       "      <td>46592000000.00</td>\n",
       "      <td>5.32</td>\n",
       "      <td>-67.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-09-30</th>\n",
       "      <td>998000000.00</td>\n",
       "      <td>2958000000.00</td>\n",
       "      <td>1184000000.00</td>\n",
       "      <td>19.39</td>\n",
       "      <td>302000000.00</td>\n",
       "      <td>-13800000000.00</td>\n",
       "      <td>-539000000.00</td>\n",
       "      <td>12153000000.00</td>\n",
       "      <td>-2186000000.00</td>\n",
       "      <td>8104000000.00</td>\n",
       "      <td>400000000.00</td>\n",
       "      <td>18.70</td>\n",
       "      <td>43614000000.00</td>\n",
       "      <td>16169000000.00</td>\n",
       "      <td>8814000000.00</td>\n",
       "      <td>7111000000.00</td>\n",
       "      <td>1925000000.00</td>\n",
       "      <td>41235000000.00</td>\n",
       "      <td>11144000000.00</td>\n",
       "      <td>418000000.00</td>\n",
       "      <td>10239000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>3722000000.00</td>\n",
       "      <td>1604000000.00</td>\n",
       "      <td>2223000000.00</td>\n",
       "      <td>73249000000.00</td>\n",
       "      <td>18504000000.00</td>\n",
       "      <td>7052000000.00</td>\n",
       "      <td>50540000000.00</td>\n",
       "      <td>73249000000.00</td>\n",
       "      <td>-94000000.00</td>\n",
       "      <td>5930000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>26657000000.00</td>\n",
       "      <td>830.58</td>\n",
       "      <td>0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.62</td>\n",
       "      <td>15126.65</td>\n",
       "      <td>0.95</td>\n",
       "      <td>2.62</td>\n",
       "      <td>11452000000.00</td>\n",
       "      <td>44.42</td>\n",
       "      <td>63.77</td>\n",
       "      <td>13.02</td>\n",
       "      <td>578.48</td>\n",
       "      <td>46592000000.00</td>\n",
       "      <td>5.32</td>\n",
       "      <td>-67.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-12-31</th>\n",
       "      <td>998000000.00</td>\n",
       "      <td>2958000000.00</td>\n",
       "      <td>1184000000.00</td>\n",
       "      <td>19.39</td>\n",
       "      <td>302000000.00</td>\n",
       "      <td>-13800000000.00</td>\n",
       "      <td>-539000000.00</td>\n",
       "      <td>12153000000.00</td>\n",
       "      <td>-2186000000.00</td>\n",
       "      <td>8104000000.00</td>\n",
       "      <td>400000000.00</td>\n",
       "      <td>18.70</td>\n",
       "      <td>43614000000.00</td>\n",
       "      <td>16169000000.00</td>\n",
       "      <td>8814000000.00</td>\n",
       "      <td>7111000000.00</td>\n",
       "      <td>1925000000.00</td>\n",
       "      <td>41235000000.00</td>\n",
       "      <td>11144000000.00</td>\n",
       "      <td>418000000.00</td>\n",
       "      <td>10239000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>3722000000.00</td>\n",
       "      <td>1604000000.00</td>\n",
       "      <td>2223000000.00</td>\n",
       "      <td>73249000000.00</td>\n",
       "      <td>18504000000.00</td>\n",
       "      <td>7052000000.00</td>\n",
       "      <td>50540000000.00</td>\n",
       "      <td>73249000000.00</td>\n",
       "      <td>-94000000.00</td>\n",
       "      <td>5930000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>26657000000.00</td>\n",
       "      <td>1116.25</td>\n",
       "      <td>0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.00</td>\n",
       "      <td>13501.54</td>\n",
       "      <td>0.92</td>\n",
       "      <td>2.62</td>\n",
       "      <td>11452000000.00</td>\n",
       "      <td>59.69</td>\n",
       "      <td>63.77</td>\n",
       "      <td>17.50</td>\n",
       "      <td>1044.83</td>\n",
       "      <td>46592000000.00</td>\n",
       "      <td>5.32</td>\n",
       "      <td>-67.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-03-31</th>\n",
       "      <td>1210000000.00</td>\n",
       "      <td>3154000000.00</td>\n",
       "      <td>657000000.00</td>\n",
       "      <td>19.39</td>\n",
       "      <td>302000000.00</td>\n",
       "      <td>-13800000000.00</td>\n",
       "      <td>-539000000.00</td>\n",
       "      <td>12153000000.00</td>\n",
       "      <td>-2186000000.00</td>\n",
       "      <td>8104000000.00</td>\n",
       "      <td>400000000.00</td>\n",
       "      <td>18.70</td>\n",
       "      <td>43653000000.00</td>\n",
       "      <td>16169000000.00</td>\n",
       "      <td>8814000000.00</td>\n",
       "      <td>3867000000.00</td>\n",
       "      <td>1898000000.00</td>\n",
       "      <td>41235000000.00</td>\n",
       "      <td>11144000000.00</td>\n",
       "      <td>414000000.00</td>\n",
       "      <td>10239000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>3722000000.00</td>\n",
       "      <td>2682000000.00</td>\n",
       "      <td>2154000000.00</td>\n",
       "      <td>72861000000.00</td>\n",
       "      <td>20847000000.00</td>\n",
       "      <td>7405000000.00</td>\n",
       "      <td>48873000000.00</td>\n",
       "      <td>72861000000.00</td>\n",
       "      <td>-94000000.00</td>\n",
       "      <td>5930000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>26657000000.00</td>\n",
       "      <td>1325.41</td>\n",
       "      <td>0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.00</td>\n",
       "      <td>13441.86</td>\n",
       "      <td>0.90</td>\n",
       "      <td>2.82</td>\n",
       "      <td>13442000000.00</td>\n",
       "      <td>70.88</td>\n",
       "      <td>64.39</td>\n",
       "      <td>20.58</td>\n",
       "      <td>1458.98</td>\n",
       "      <td>46204000000.00</td>\n",
       "      <td>5.20</td>\n",
       "      <td>-61.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-06-30</th>\n",
       "      <td>1210000000.00</td>\n",
       "      <td>3154000000.00</td>\n",
       "      <td>657000000.00</td>\n",
       "      <td>17.40</td>\n",
       "      <td>225000000.00</td>\n",
       "      <td>-8980000000.00</td>\n",
       "      <td>-421000000.00</td>\n",
       "      <td>8538000000.00</td>\n",
       "      <td>-863000000.00</td>\n",
       "      <td>5529000000.00</td>\n",
       "      <td>256000000.00</td>\n",
       "      <td>16.95</td>\n",
       "      <td>43653000000.00</td>\n",
       "      <td>12119000000.00</td>\n",
       "      <td>7556000000.00</td>\n",
       "      <td>3867000000.00</td>\n",
       "      <td>1898000000.00</td>\n",
       "      <td>41235000000.00</td>\n",
       "      <td>11144000000.00</td>\n",
       "      <td>414000000.00</td>\n",
       "      <td>8111000000.00</td>\n",
       "      <td>545000000.00</td>\n",
       "      <td>2507000000.00</td>\n",
       "      <td>2682000000.00</td>\n",
       "      <td>2154000000.00</td>\n",
       "      <td>72861000000.00</td>\n",
       "      <td>20847000000.00</td>\n",
       "      <td>7405000000.00</td>\n",
       "      <td>48873000000.00</td>\n",
       "      <td>72861000000.00</td>\n",
       "      <td>256000000.00</td>\n",
       "      <td>4008000000.00</td>\n",
       "      <td>12792000000.00</td>\n",
       "      <td>26657000000.00</td>\n",
       "      <td>1605.53</td>\n",
       "      <td>0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>-0.09</td>\n",
       "      <td>11915.65</td>\n",
       "      <td>0.87</td>\n",
       "      <td>2.82</td>\n",
       "      <td>13442000000.00</td>\n",
       "      <td>94.72</td>\n",
       "      <td>64.39</td>\n",
       "      <td>24.93</td>\n",
       "      <td>2361.87</td>\n",
       "      <td>46204000000.00</td>\n",
       "      <td>5.20</td>\n",
       "      <td>-61.25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            accounts payable  accounts receivable  accrued expenses and other  \\\n",
       "2018-06-30     1105000000.00        2448000000.00               1418000000.00   \n",
       "2018-09-30     1105000000.00        2448000000.00               1418000000.00   \n",
       "2018-12-31     1105000000.00        2448000000.00               1418000000.00   \n",
       "2019-03-31      811000000.00        3325000000.00               1418000000.00   \n",
       "2019-06-30      811000000.00        3325000000.00               1418000000.00   \n",
       "2019-09-30      811000000.00        3325000000.00               1418000000.00   \n",
       "2019-12-31      811000000.00        3325000000.00               1418000000.00   \n",
       "2020-03-31      855000000.00        3259000000.00               1418000000.00   \n",
       "2020-06-30      855000000.00        3259000000.00               1418000000.00   \n",
       "2020-09-30      855000000.00        3259000000.00               1418000000.00   \n",
       "2020-12-31      855000000.00        3259000000.00               1418000000.00   \n",
       "2021-03-31      836000000.00        2297000000.00               1418000000.00   \n",
       "2021-06-30      836000000.00        2297000000.00               1418000000.00   \n",
       "2021-09-30      836000000.00        2297000000.00               1418000000.00   \n",
       "2021-12-31      836000000.00        2297000000.00               1418000000.00   \n",
       "2022-03-31     1086000000.00        2071000000.00               1453000000.00   \n",
       "2022-06-30     1086000000.00        2071000000.00               1453000000.00   \n",
       "2022-09-30     1086000000.00        2071000000.00               1453000000.00   \n",
       "2022-12-31     1086000000.00        2071000000.00               1453000000.00   \n",
       "2023-03-31      998000000.00        2958000000.00               1184000000.00   \n",
       "2023-06-30      998000000.00        2958000000.00               1184000000.00   \n",
       "2023-09-30      998000000.00        2958000000.00               1184000000.00   \n",
       "2023-12-31      998000000.00        2958000000.00               1184000000.00   \n",
       "2024-03-31     1210000000.00        3154000000.00                657000000.00   \n",
       "2024-06-30     1210000000.00        3154000000.00                657000000.00   \n",
       "\n",
       "            basic earnings per share        capex  cash flow from financing  \\\n",
       "2018-06-30                      1.69 581000000.00             -967000000.00   \n",
       "2018-09-30                      2.88 836000000.00            -1370000000.00   \n",
       "2018-12-31                      2.88 836000000.00            -1370000000.00   \n",
       "2019-03-31                      1.17  99000000.00            13862000000.00   \n",
       "2019-06-30                     23.97 409000000.00            -2633000000.00   \n",
       "2019-09-30                     26.53 529000000.00            -8757000000.00   \n",
       "2019-12-31                     26.53 529000000.00            -8757000000.00   \n",
       "2020-03-31                      0.78 108000000.00            10054000000.00   \n",
       "2020-06-30                      2.91 224000000.00            11536000000.00   \n",
       "2020-09-30                      4.70 336000000.00             9286000000.00   \n",
       "2020-12-31                      4.70 336000000.00             9286000000.00   \n",
       "2021-03-31                      3.20 114000000.00            -1057000000.00   \n",
       "2021-06-30                      2.00 256000000.00             9580000000.00   \n",
       "2021-09-30                      3.52 361000000.00             6098000000.00   \n",
       "2021-12-31                      3.52 361000000.00             6098000000.00   \n",
       "2022-03-31                      5.82 101000000.00            -5121000000.00   \n",
       "2022-06-30                      6.67 240000000.00            -4534000000.00   \n",
       "2022-09-30                     11.06 355000000.00            -6441000000.00   \n",
       "2022-12-31                     11.06 355000000.00            -6441000000.00   \n",
       "2023-03-31                      9.03 103000000.00            -3702000000.00   \n",
       "2023-06-30                     11.98 186000000.00           -10268000000.00   \n",
       "2023-09-30                     19.39 302000000.00           -13800000000.00   \n",
       "2023-12-31                     19.39 302000000.00           -13800000000.00   \n",
       "2024-03-31                     19.39 302000000.00           -13800000000.00   \n",
       "2024-06-30                     17.40 225000000.00            -8980000000.00   \n",
       "\n",
       "            cash flow from investing  cash flow from operations  \\\n",
       "2018-06-30             -812000000.00              2936000000.00   \n",
       "2018-09-30            -1070000000.00              4592000000.00   \n",
       "2018-12-31            -1070000000.00              4592000000.00   \n",
       "2019-03-31           -15193000000.00              2132000000.00   \n",
       "2019-06-30            -4382000000.00              3998000000.00   \n",
       "2019-09-30            -4556000000.00              6245000000.00   \n",
       "2019-12-31            -4556000000.00              6245000000.00   \n",
       "2020-03-31           -10987000000.00              2322000000.00   \n",
       "2020-06-30           -15299000000.00              4799000000.00   \n",
       "2020-09-30           -15334000000.00              7218000000.00   \n",
       "2020-12-31           -15334000000.00              7218000000.00   \n",
       "2021-03-31             -122000000.00              3113000000.00   \n",
       "2021-06-30           -10963000000.00              5535000000.00   \n",
       "2021-09-30           -11009000000.00              8713000000.00   \n",
       "2021-12-31           -11009000000.00              8713000000.00   \n",
       "2022-03-31             -309000000.00              3486000000.00   \n",
       "2022-06-30             -248000000.00              6682000000.00   \n",
       "2022-09-30             -295000000.00             10223000000.00   \n",
       "2022-12-31             -295000000.00             10223000000.00   \n",
       "2023-03-31             -103000000.00              4036000000.00   \n",
       "2023-06-30             -619000000.00              7729000000.00   \n",
       "2023-09-30             -539000000.00             12153000000.00   \n",
       "2023-12-31             -539000000.00             12153000000.00   \n",
       "2024-03-31             -539000000.00             12153000000.00   \n",
       "2024-06-30             -421000000.00              8538000000.00   \n",
       "\n",
       "            change in cash  cost of sales  depreciation and amortisation  \\\n",
       "2018-06-30   1157000000.00  4352000000.00                   882000000.00   \n",
       "2018-09-30   2152000000.00  6666000000.00                  3518000000.00   \n",
       "2018-12-31   2152000000.00  6666000000.00                  3518000000.00   \n",
       "2019-03-31   2152000000.00  2581000000.00                   143000000.00   \n",
       "2019-06-30  -3017000000.00  5162000000.00                  2148000000.00   \n",
       "2019-09-30  -7068000000.00  7606000000.00                  3113000000.00   \n",
       "2019-12-31  -7068000000.00  7606000000.00                  3113000000.00   \n",
       "2020-03-31   1389000000.00  2594000000.00                   146000000.00   \n",
       "2020-06-30   1036000000.00  5009000000.00                   285000000.00   \n",
       "2020-09-30   1170000000.00  7490000000.00                   426000000.00   \n",
       "2020-12-31   1170000000.00  7490000000.00                   426000000.00   \n",
       "2021-03-31   1934000000.00  2703000000.00                   138000000.00   \n",
       "2021-06-30   4152000000.00  5147000000.00                   293000000.00   \n",
       "2021-09-30   3802000000.00  7652000000.00                   431000000.00   \n",
       "2021-12-31   3802000000.00  7652000000.00                   431000000.00   \n",
       "2022-03-31  -1944000000.00  2657000000.00                   136000000.00   \n",
       "2022-06-30   1900000000.00  5256000000.00                   271000000.00   \n",
       "2022-09-30   3487000000.00  7837000000.00                   405000000.00   \n",
       "2022-12-31   3487000000.00  7837000000.00                   405000000.00   \n",
       "2023-03-31    231000000.00  2911000000.00                   127000000.00   \n",
       "2023-06-30  -3158000000.00  5321000000.00                   271000000.00   \n",
       "2023-09-30  -2186000000.00  8104000000.00                   400000000.00   \n",
       "2023-12-31  -2186000000.00  8104000000.00                   400000000.00   \n",
       "2024-03-31  -2186000000.00  8104000000.00                   400000000.00   \n",
       "2024-06-30   -863000000.00  5529000000.00                   256000000.00   \n",
       "\n",
       "            diluted earnings per share       goodwill   gross profit  \\\n",
       "2018-06-30                        1.63 24706000000.00  3977000000.00   \n",
       "2018-09-30                        2.77 24706000000.00  6126000000.00   \n",
       "2018-12-31                        2.77 24706000000.00  6126000000.00   \n",
       "2019-03-31                       14.62 26913000000.00  2628000000.00   \n",
       "2019-06-30                       22.99 26913000000.00  5179000000.00   \n",
       "2019-09-30                       25.74 26913000000.00  7798000000.00   \n",
       "2019-12-31                       25.74 26913000000.00  7798000000.00   \n",
       "2020-03-31                        1.12 36714000000.00  3208000000.00   \n",
       "2020-06-30                        2.77 36714000000.00  6297000000.00   \n",
       "2020-09-30                        4.47 36714000000.00  9331000000.00   \n",
       "2020-12-31                        4.47 36714000000.00  9331000000.00   \n",
       "2021-03-31                        3.05 43447000000.00  3952000000.00   \n",
       "2021-06-30                        1.91 43447000000.00  6453000000.00   \n",
       "2021-09-30                        3.36 43447000000.00  9769000000.00   \n",
       "2021-12-31                        3.36 43447000000.00  9769000000.00   \n",
       "2022-03-31                        5.59 43450000000.00  5049000000.00   \n",
       "2022-06-30                        6.34 43450000000.00  8009000000.00   \n",
       "2022-09-30                       10.54 43450000000.00 12206000000.00   \n",
       "2022-12-31                       10.54 43450000000.00 12206000000.00   \n",
       "2023-03-31                        8.80 43614000000.00  6004000000.00   \n",
       "2023-06-30                       11.53 43614000000.00 10488000000.00   \n",
       "2023-09-30                       18.70 43614000000.00 16169000000.00   \n",
       "2023-12-31                       18.70 43614000000.00 16169000000.00   \n",
       "2024-03-31                       18.70 43653000000.00 16169000000.00   \n",
       "2024-06-30                       16.95 43653000000.00 12119000000.00   \n",
       "\n",
       "            income before income taxes  intangible assets   inventories  \\\n",
       "2018-06-30                632000000.00     10832000000.00 1447000000.00   \n",
       "2018-09-30               1180000000.00     10832000000.00 1447000000.00   \n",
       "2018-12-31               1180000000.00     10832000000.00 1447000000.00   \n",
       "2019-03-31                278000000.00     10762000000.00 1124000000.00   \n",
       "2019-06-30               1894000000.00     10762000000.00 1124000000.00   \n",
       "2019-09-30               3123000000.00     10762000000.00 1124000000.00   \n",
       "2019-12-31               3123000000.00     10762000000.00 1124000000.00   \n",
       "2020-03-31                304000000.00     17554000000.00  874000000.00   \n",
       "2020-06-30                935000000.00     17554000000.00  874000000.00   \n",
       "2020-09-30               1479000000.00     17554000000.00  874000000.00   \n",
       "2020-12-31               1479000000.00     17554000000.00  874000000.00   \n",
       "2021-03-31               1384000000.00     16782000000.00 1003000000.00   \n",
       "2021-06-30                713000000.00     16782000000.00 1003000000.00   \n",
       "2021-09-30               1306000000.00     16782000000.00 1003000000.00   \n",
       "2021-12-31               1306000000.00     16782000000.00 1003000000.00   \n",
       "2022-03-31               2687000000.00     11374000000.00 1297000000.00   \n",
       "2022-06-30               2870000000.00     11374000000.00 1297000000.00   \n",
       "2022-09-30               4596000000.00     11374000000.00 1297000000.00   \n",
       "2022-12-31               4596000000.00     11374000000.00 1297000000.00   \n",
       "2023-03-31               3840000000.00      7111000000.00 1925000000.00   \n",
       "2023-06-30               5477000000.00      7111000000.00 1925000000.00   \n",
       "2023-09-30               8814000000.00      7111000000.00 1925000000.00   \n",
       "2023-12-31               8814000000.00      7111000000.00 1925000000.00   \n",
       "2024-03-31               8814000000.00      3867000000.00 1898000000.00   \n",
       "2024-06-30               7556000000.00      3867000000.00 1898000000.00   \n",
       "\n",
       "            long term debt     net income      nshares  operating income  \\\n",
       "2018-06-30  17548000000.00   679000000.00 408732155.00      980000000.00   \n",
       "2018-09-30  17548000000.00  1160000000.00 408732155.00     1628000000.00   \n",
       "2018-12-31  17548000000.00  1160000000.00 408732155.00     1628000000.00   \n",
       "2019-03-31  17493000000.00  1160000000.00 407637618.00      943000000.00   \n",
       "2019-06-30  17493000000.00  9948000000.00 407637618.00     2144000000.00   \n",
       "2019-09-30  17493000000.00 11144000000.00 407637618.00     3483000000.00   \n",
       "2019-12-31  17493000000.00 11144000000.00 407637618.00     3483000000.00   \n",
       "2020-03-31  32798000000.00 11144000000.00 397560810.00      555000000.00   \n",
       "2020-06-30  32798000000.00 11144000000.00 397560810.00     1525000000.00   \n",
       "2020-09-30  30011000000.00 11144000000.00 398000000.00     2390000000.00   \n",
       "2020-12-31  30011000000.00 11144000000.00 398000000.00     2390000000.00   \n",
       "2021-03-31  40994000000.00 11144000000.00 407000000.00     1837000000.00   \n",
       "2021-06-30  40994000000.00 11144000000.00 407000000.00     1480000000.00   \n",
       "2021-09-30  40994000000.00 11144000000.00 407000000.00     2488000000.00   \n",
       "2021-12-31  40994000000.00 11144000000.00 407000000.00     2488000000.00   \n",
       "2022-03-31  39440000000.00 11144000000.00 413000000.00     3108000000.00   \n",
       "2022-06-30  41235000000.00 11144000000.00 413000000.00     3812000000.00   \n",
       "2022-09-30  41235000000.00 11144000000.00 413000000.00     5938000000.00   \n",
       "2022-12-31  41235000000.00 11144000000.00 413000000.00     5938000000.00   \n",
       "2023-03-31  41235000000.00 11144000000.00 418000000.00     4103000000.00   \n",
       "2023-06-30  41235000000.00 11144000000.00 418000000.00     6502000000.00   \n",
       "2023-09-30  41235000000.00 11144000000.00 418000000.00    10239000000.00   \n",
       "2023-12-31  41235000000.00 11144000000.00 418000000.00    10239000000.00   \n",
       "2024-03-31  41235000000.00 11144000000.00 414000000.00    10239000000.00   \n",
       "2024-06-30  41235000000.00 11144000000.00 414000000.00     8111000000.00   \n",
       "\n",
       "            operating leases  research and development expense  \\\n",
       "2018-06-30      545000000.00                     1637000000.00   \n",
       "2018-09-30      545000000.00                     2464000000.00   \n",
       "2018-12-31      545000000.00                     2464000000.00   \n",
       "2019-03-31      545000000.00                     1133000000.00   \n",
       "2019-06-30      545000000.00                     1861000000.00   \n",
       "2019-09-30      545000000.00                     2820000000.00   \n",
       "2019-12-31      545000000.00                     2820000000.00   \n",
       "2020-03-31      545000000.00                     1289000000.00   \n",
       "2020-06-30      545000000.00                     2284000000.00   \n",
       "2020-09-30      545000000.00                     3519000000.00   \n",
       "2020-12-31      545000000.00                     3519000000.00   \n",
       "2021-03-31      545000000.00                     1211000000.00   \n",
       "2021-06-30      545000000.00                     2558000000.00   \n",
       "2021-09-30      545000000.00                     3786000000.00   \n",
       "2021-12-31      545000000.00                     3786000000.00   \n",
       "2022-03-31      545000000.00                     1206000000.00   \n",
       "2022-06-30      545000000.00                     2449000000.00   \n",
       "2022-09-30      545000000.00                     3654000000.00   \n",
       "2022-12-31      545000000.00                     3654000000.00   \n",
       "2023-03-31      545000000.00                     1195000000.00   \n",
       "2023-06-30      545000000.00                     2467000000.00   \n",
       "2023-09-30      545000000.00                     3722000000.00   \n",
       "2023-12-31      545000000.00                     3722000000.00   \n",
       "2024-03-31      545000000.00                     3722000000.00   \n",
       "2024-06-30      545000000.00                     2507000000.00   \n",
       "\n",
       "            retained earnings  tangible assets   total assets  \\\n",
       "2018-06-30      -129000000.00    2599000000.00 54418000000.00   \n",
       "2018-09-30      -129000000.00    2599000000.00 54418000000.00   \n",
       "2018-12-31      -129000000.00    2599000000.00 54418000000.00   \n",
       "2019-03-31      3487000000.00    2635000000.00 50124000000.00   \n",
       "2019-06-30      3487000000.00    2635000000.00 50124000000.00   \n",
       "2019-09-30      3487000000.00    2635000000.00 50124000000.00   \n",
       "2019-12-31      3487000000.00    2635000000.00 50124000000.00   \n",
       "2020-03-31      3487000000.00    2565000000.00 67493000000.00   \n",
       "2020-06-30      3487000000.00    2565000000.00 67493000000.00   \n",
       "2020-09-30      3487000000.00    2565000000.00 67493000000.00   \n",
       "2020-12-31      3487000000.00    2565000000.00 67493000000.00   \n",
       "2021-03-31      3487000000.00    2509000000.00 75933000000.00   \n",
       "2021-06-30      3487000000.00    2509000000.00 75933000000.00   \n",
       "2021-09-30      3487000000.00    2509000000.00 75933000000.00   \n",
       "2021-12-31      3487000000.00    2509000000.00 75933000000.00   \n",
       "2022-03-31       748000000.00    2348000000.00 75570000000.00   \n",
       "2022-06-30       748000000.00    2348000000.00 75570000000.00   \n",
       "2022-09-30       748000000.00    2348000000.00 75570000000.00   \n",
       "2022-12-31       748000000.00    2348000000.00 75570000000.00   \n",
       "2023-03-31      1604000000.00    2223000000.00 73249000000.00   \n",
       "2023-06-30      1604000000.00    2223000000.00 73249000000.00   \n",
       "2023-09-30      1604000000.00    2223000000.00 73249000000.00   \n",
       "2023-12-31      1604000000.00    2223000000.00 73249000000.00   \n",
       "2024-03-31      2682000000.00    2154000000.00 72861000000.00   \n",
       "2024-06-30      2682000000.00    2154000000.00 72861000000.00   \n",
       "\n",
       "            total current assets  total current liabilities  \\\n",
       "2018-06-30        15823000000.00              2529000000.00   \n",
       "2018-09-30        15823000000.00              2529000000.00   \n",
       "2018-12-31        15823000000.00              2529000000.00   \n",
       "2019-03-31         9107000000.00              2338000000.00   \n",
       "2019-06-30         9107000000.00              2338000000.00   \n",
       "2019-09-30         9107000000.00              2338000000.00   \n",
       "2019-12-31         9107000000.00              2338000000.00   \n",
       "2020-03-31         9917000000.00              6899000000.00   \n",
       "2020-06-30         9917000000.00              6899000000.00   \n",
       "2020-09-30         9917000000.00              6899000000.00   \n",
       "2020-12-31         9917000000.00              6899000000.00   \n",
       "2021-03-31        11895000000.00              6371000000.00   \n",
       "2021-06-30        11895000000.00              6371000000.00   \n",
       "2021-09-30        11895000000.00              6371000000.00   \n",
       "2021-12-31        11895000000.00              6371000000.00   \n",
       "2022-03-31        16586000000.00              6281000000.00   \n",
       "2022-06-30        16586000000.00              6281000000.00   \n",
       "2022-09-30        16586000000.00              6281000000.00   \n",
       "2022-12-31        16586000000.00              6281000000.00   \n",
       "2023-03-31        18504000000.00              7052000000.00   \n",
       "2023-06-30        18504000000.00              7052000000.00   \n",
       "2023-09-30        18504000000.00              7052000000.00   \n",
       "2023-12-31        18504000000.00              7052000000.00   \n",
       "2024-03-31        20847000000.00              7405000000.00   \n",
       "2024-06-30        20847000000.00              7405000000.00   \n",
       "\n",
       "            total liabilities  total liabilities and equity  \\\n",
       "2018-06-30     31232000000.00                54418000000.00   \n",
       "2018-09-30     31232000000.00                54418000000.00   \n",
       "2018-12-31     31232000000.00                54418000000.00   \n",
       "2019-03-31     23467000000.00                50124000000.00   \n",
       "2019-06-30     23467000000.00                50124000000.00   \n",
       "2019-09-30     23467000000.00                50124000000.00   \n",
       "2019-12-31     23467000000.00                50124000000.00   \n",
       "2020-03-31     42523000000.00                67493000000.00   \n",
       "2020-06-30     42523000000.00                67493000000.00   \n",
       "2020-09-30     42523000000.00                67493000000.00   \n",
       "2020-12-31     42523000000.00                67493000000.00   \n",
       "2021-03-31     52032000000.00                75933000000.00   \n",
       "2021-06-30     52032000000.00                75933000000.00   \n",
       "2021-09-30     52032000000.00                75933000000.00   \n",
       "2021-12-31     52032000000.00                75933000000.00   \n",
       "2022-03-31     50581000000.00                75570000000.00   \n",
       "2022-06-30     50581000000.00                75570000000.00   \n",
       "2022-09-30     50581000000.00                75570000000.00   \n",
       "2022-12-31     50581000000.00                75570000000.00   \n",
       "2023-03-31     50540000000.00                73249000000.00   \n",
       "2023-06-30     50540000000.00                73249000000.00   \n",
       "2023-09-30     50540000000.00                73249000000.00   \n",
       "2023-12-31     50540000000.00                73249000000.00   \n",
       "2024-03-31     48873000000.00                72861000000.00   \n",
       "2024-06-30     48873000000.00                72861000000.00   \n",
       "\n",
       "            total non operating expenses  total operating expenses  \\\n",
       "2018-06-30                   34000000.00             2997000000.00   \n",
       "2018-09-30                   46000000.00             4498000000.00   \n",
       "2018-12-31                   46000000.00             4498000000.00   \n",
       "2019-03-31                   68000000.00             2653000000.00   \n",
       "2019-06-30                   81000000.00             3035000000.00   \n",
       "2019-09-30                  120000000.00             4315000000.00   \n",
       "2019-12-31                  120000000.00             4315000000.00   \n",
       "2020-03-31                   -4000000.00             2550000000.00   \n",
       "2020-06-30                  131000000.00             4772000000.00   \n",
       "2020-09-30                  172000000.00             6941000000.00   \n",
       "2020-12-31                  172000000.00             6941000000.00   \n",
       "2021-03-31                  117000000.00             2115000000.00   \n",
       "2021-06-30                  126000000.00             4973000000.00   \n",
       "2021-09-30                  175000000.00             7281000000.00   \n",
       "2021-12-31                  175000000.00             7281000000.00   \n",
       "2022-03-31                  -14000000.00             1941000000.00   \n",
       "2022-06-30                   94000000.00             4197000000.00   \n",
       "2022-09-30                  109000000.00             6268000000.00   \n",
       "2022-12-31                  109000000.00             6268000000.00   \n",
       "2023-03-31                  143000000.00             1901000000.00   \n",
       "2023-06-30                 -100000000.00             3986000000.00   \n",
       "2023-09-30                  -94000000.00             5930000000.00   \n",
       "2023-12-31                  -94000000.00             5930000000.00   \n",
       "2024-03-31                  -94000000.00             5930000000.00   \n",
       "2024-06-30                  256000000.00             4008000000.00   \n",
       "\n",
       "            total revenues  total shareholders equity  share_price  \\\n",
       "2018-06-30   8329000000.00             20285000000.00       246.73   \n",
       "2018-09-30  12792000000.00             20285000000.00       246.73   \n",
       "2018-12-31  12792000000.00             20285000000.00       254.28   \n",
       "2019-03-31  12792000000.00             26657000000.00       300.71   \n",
       "2019-06-30  12792000000.00             26657000000.00       287.86   \n",
       "2019-09-30  12792000000.00             26657000000.00       276.07   \n",
       "2019-12-31  12792000000.00             26657000000.00       316.02   \n",
       "2020-03-31  12792000000.00             26657000000.00       237.10   \n",
       "2020-06-30  12792000000.00             26657000000.00       315.61   \n",
       "2020-09-30  12792000000.00             26657000000.00       364.32   \n",
       "2020-12-31  12792000000.00             26657000000.00       437.85   \n",
       "2021-03-31  12792000000.00             26657000000.00       463.66   \n",
       "2021-06-30  12792000000.00             26657000000.00       476.84   \n",
       "2021-09-30  12792000000.00             26657000000.00       484.93   \n",
       "2021-12-31  12792000000.00             26657000000.00       665.41   \n",
       "2022-03-31  12792000000.00             26657000000.00       629.68   \n",
       "2022-06-30  12792000000.00             26657000000.00       485.81   \n",
       "2022-09-30  12792000000.00             26657000000.00       444.01   \n",
       "2022-12-31  12792000000.00             26657000000.00       559.13   \n",
       "2023-03-31  12792000000.00             26657000000.00       641.54   \n",
       "2023-06-30  12792000000.00             26657000000.00       867.43   \n",
       "2023-09-30  12792000000.00             26657000000.00       830.58   \n",
       "2023-12-31  12792000000.00             26657000000.00      1116.25   \n",
       "2024-03-31  12792000000.00             26657000000.00      1325.41   \n",
       "2024-06-30  12792000000.00             26657000000.00      1605.53   \n",
       "\n",
       "            marketable securities  bond_yield  eps growth rate  \\\n",
       "2018-06-30                      0        0.00             0.00   \n",
       "2018-09-30                      0        0.00             0.70   \n",
       "2018-12-31                      0        0.00             0.00   \n",
       "2019-03-31                      0        0.02             4.28   \n",
       "2019-06-30                      0        0.02             0.57   \n",
       "2019-09-30                      0        0.02             0.12   \n",
       "2019-12-31                      0        0.02             0.00   \n",
       "2020-03-31                      0        0.00            -0.96   \n",
       "2020-06-30                      0        0.00             1.47   \n",
       "2020-09-30                      0        0.00             0.61   \n",
       "2020-12-31                      0        0.00             0.00   \n",
       "2021-03-31                      0        0.00            -0.32   \n",
       "2021-06-30                      0        0.00            -0.37   \n",
       "2021-09-30                      0        0.00             0.76   \n",
       "2021-12-31                      0        0.00             0.00   \n",
       "2022-03-31                      0        0.00             0.66   \n",
       "2022-06-30                      0        0.02             0.13   \n",
       "2022-09-30                      0        0.03             0.66   \n",
       "2022-12-31                      0        0.04             0.00   \n",
       "2023-03-31                      0        0.05            -0.17   \n",
       "2023-06-30                      0        0.05             0.31   \n",
       "2023-09-30                      0        0.05             0.62   \n",
       "2023-12-31                      0        0.05             0.00   \n",
       "2024-03-31                      0        0.05             0.00   \n",
       "2024-06-30                      0        0.05            -0.09   \n",
       "\n",
       "            intrinsic value  margin safety  current ratio  net current assets  \\\n",
       "2018-06-30             0.00           0.00           6.26      13294000000.00   \n",
       "2018-09-30             0.00           0.00           6.26      13294000000.00   \n",
       "2018-12-31             0.00           0.00           6.26      13294000000.00   \n",
       "2019-03-31         47129.53           0.99           3.90       6769000000.00   \n",
       "2019-06-30         47943.50           0.99           3.90       6769000000.00   \n",
       "2019-09-30         55919.25           1.00           3.90       6769000000.00   \n",
       "2019-12-31         63965.18           1.00           3.90       6769000000.00   \n",
       "2020-03-31        108202.85           1.00           1.44       3018000000.00   \n",
       "2020-06-30        103340.05           1.00           1.44       3018000000.00   \n",
       "2020-09-30        225081.44           1.00           1.44       3018000000.00   \n",
       "2020-12-31        257196.93           1.00           1.44       3018000000.00   \n",
       "2021-03-31        811874.19           1.00           1.87       5524000000.00   \n",
       "2021-06-30        162879.17           1.00           1.87       5524000000.00   \n",
       "2021-09-30        528967.52           1.00           1.87       5524000000.00   \n",
       "2021-12-31        380800.00           1.00           1.87       5524000000.00   \n",
       "2022-03-31         49029.26           0.99           2.64      10305000000.00   \n",
       "2022-06-30         15287.59           0.97           2.64      10305000000.00   \n",
       "2022-09-30         14328.32           0.97           2.64      10305000000.00   \n",
       "2022-12-31          9253.43           0.94           2.64      10305000000.00   \n",
       "2023-03-31          6899.36           0.91           2.62      11452000000.00   \n",
       "2023-06-30          8979.21           0.90           2.62      11452000000.00   \n",
       "2023-09-30         15126.65           0.95           2.62      11452000000.00   \n",
       "2023-12-31         13501.54           0.92           2.62      11452000000.00   \n",
       "2024-03-31         13441.86           0.90           2.82      13442000000.00   \n",
       "2024-06-30         11915.65           0.87           2.82      13442000000.00   \n",
       "\n",
       "            pe ratio  bvps  pb ratio  multiplier pb     total debt  tbvps  \\\n",
       "2018-06-30    151.37 49.63      4.97         752.52 34133000000.00   6.36   \n",
       "2018-09-30     89.07 49.63      4.97         442.82 34133000000.00   6.36   \n",
       "2018-12-31     91.80 49.63      5.12         470.34 34133000000.00   6.36   \n",
       "2019-03-31     20.57 65.39      4.60          94.58 23467000000.00   6.46   \n",
       "2019-06-30     12.52 65.39      4.40          55.12 23467000000.00   6.46   \n",
       "2019-09-30     10.73 65.39      4.22          45.28 23467000000.00   6.46   \n",
       "2019-12-31     12.28 65.39      4.83          59.33 23467000000.00   6.46   \n",
       "2020-03-31    211.70 67.05      3.54         748.58 40836000000.00   6.45   \n",
       "2020-06-30    113.94 67.05      4.71         536.31 40836000000.00   6.45   \n",
       "2020-09-30     81.50 66.98      5.44         443.33 40836000000.00   6.44   \n",
       "2020-12-31     97.95 66.98      6.54         640.35 40836000000.00   6.44   \n",
       "2021-03-31    152.02 65.50      7.08        1076.17 49276000000.00   6.16   \n",
       "2021-06-30    249.65 65.50      7.28        1817.59 49276000000.00   6.16   \n",
       "2021-09-30    144.32 65.50      7.40        1068.57 49276000000.00   6.16   \n",
       "2021-12-31    198.04 65.50     10.16        2011.97 49276000000.00   6.16   \n",
       "2022-03-31    112.64 64.54      9.76        1098.92 48913000000.00   5.69   \n",
       "2022-06-30     76.63 64.54      7.53         576.74 48913000000.00   5.69   \n",
       "2022-09-30     42.13 64.54      6.88         289.79 48913000000.00   5.69   \n",
       "2022-12-31     53.05 64.54      8.66         459.54 48913000000.00   5.69   \n",
       "2023-03-31     72.90 63.77     10.06         733.38 46592000000.00   5.32   \n",
       "2023-06-30     75.23 63.77     13.60        1023.30 46592000000.00   5.32   \n",
       "2023-09-30     44.42 63.77     13.02         578.48 46592000000.00   5.32   \n",
       "2023-12-31     59.69 63.77     17.50        1044.83 46592000000.00   5.32   \n",
       "2024-03-31     70.88 64.39     20.58        1458.98 46204000000.00   5.20   \n",
       "2024-06-30     94.72 64.39     24.93        2361.87 46204000000.00   5.20   \n",
       "\n",
       "             ncav  \n",
       "2018-06-30 -44.80  \n",
       "2018-09-30 -44.80  \n",
       "2018-12-31 -44.80  \n",
       "2019-03-31 -35.23  \n",
       "2019-06-30 -35.23  \n",
       "2019-09-30 -35.23  \n",
       "2019-12-31 -35.23  \n",
       "2020-03-31 -77.77  \n",
       "2020-06-30 -77.77  \n",
       "2020-09-30 -77.69  \n",
       "2020-12-31 -77.69  \n",
       "2021-03-31 -91.85  \n",
       "2021-06-30 -91.85  \n",
       "2021-09-30 -91.85  \n",
       "2021-12-31 -91.85  \n",
       "2022-03-31 -78.27  \n",
       "2022-06-30 -78.27  \n",
       "2022-09-30 -78.27  \n",
       "2022-12-31 -78.27  \n",
       "2023-03-31 -67.20  \n",
       "2023-06-30 -67.20  \n",
       "2023-09-30 -67.20  \n",
       "2023-12-31 -67.20  \n",
       "2024-03-31 -61.25  \n",
       "2024-06-30 -61.25  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "user_cik = input(\"Enter the CIK: \")\n",
    "show_ticker_from_cik(user_cik, api_df=concept_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "00a8f925",
   "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>MSFT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NVDA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>GOOGL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>TSLA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>XOM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1550</th>\n",
       "      <td>SMIT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1551</th>\n",
       "      <td>XDSL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1552</th>\n",
       "      <td>BABL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1553</th>\n",
       "      <td>LIANY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1554</th>\n",
       "      <td>ANG-PB</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1555 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Defensive Assets\n",
       "0                MSFT\n",
       "1                NVDA\n",
       "2               GOOGL\n",
       "3                TSLA\n",
       "4                 XOM\n",
       "...               ...\n",
       "1550             SMIT\n",
       "1551             XDSL\n",
       "1552             BABL\n",
       "1553            LIANY\n",
       "1554           ANG-PB\n",
       "\n",
       "[1555 rows x 1 columns]"
      ]
     },
     "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>AVGO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>META</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>V</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>UNH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>PG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1023</th>\n",
       "      <td>MDNC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1024</th>\n",
       "      <td>CEAI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1025</th>\n",
       "      <td>WLLBW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1026</th>\n",
       "      <td>SCE-PN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1027</th>\n",
       "      <td>QTZM</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1028 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Enterprising Assets\n",
       "0                   AVGO\n",
       "1                   META\n",
       "2                      V\n",
       "3                    UNH\n",
       "4                     PG\n",
       "...                  ...\n",
       "1023                MDNC\n",
       "1024                CEAI\n",
       "1025               WLLBW\n",
       "1026              SCE-PN\n",
       "1027                QTZM\n",
       "\n",
       "[1028 rows x 1 columns]"
      ]
     },
     "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",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>WGS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>STTK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CKPT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>IOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>GRYP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>NEUE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>OWLT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>CYTH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>UNCY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>BCLI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>VISL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>GVP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>ASRE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>MRAI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>ALLR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>MOBQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>MTEM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>EFOI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>VVOS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>MARK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>WAVD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>MACE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>ALZN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>LGIQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>OPGN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>AVGR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>EBET</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>BACK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>STAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>ELOX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>FUVV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>ABQQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>EDGM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>SHRG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>MCCX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>BBBT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>XFCI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>ASAPQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>HGENQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>ADXS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>FXLV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>BLPH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>BTTX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>COMS</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   NCAV Assets\n",
       "0          WGS\n",
       "1         STTK\n",
       "2         CKPT\n",
       "3          IOR\n",
       "4         GRYP\n",
       "5         NEUE\n",
       "6         OWLT\n",
       "7         CYTH\n",
       "8         UNCY\n",
       "9         BCLI\n",
       "10        VISL\n",
       "11         GVP\n",
       "12        ASRE\n",
       "13        MRAI\n",
       "14        ALLR\n",
       "15        MOBQ\n",
       "16        MTEM\n",
       "17        EFOI\n",
       "18        VVOS\n",
       "19        MARK\n",
       "20        WAVD\n",
       "21        MACE\n",
       "22        ALZN\n",
       "23        LGIQ\n",
       "24        OPGN\n",
       "25        AVGR\n",
       "26        EBET\n",
       "27        BACK\n",
       "28        STAL\n",
       "29        ELOX\n",
       "30        FUVV\n",
       "31        ABQQ\n",
       "32        EDGM\n",
       "33        SHRG\n",
       "34        MCCX\n",
       "35        BBBT\n",
       "36        XFCI\n",
       "37       ASAPQ\n",
       "38       HGENQ\n",
       "39        ADXS\n",
       "40        FXLV\n",
       "41        BLPH\n",
       "42        BTTX\n",
       "43        COMS"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "defensive_concept, enterprising_concept, ncav_concept = classify_multiple_ciks(concept_df.keys(), 'concept', api_df=concept_df)\n",
    "\n",
    "display(defensive_concept)\n",
    "display(enterprising_concept)\n",
    "display(ncav_concept)"
   ]
  }
 ],
 "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
}