CompanyFacts.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "b4525d3f",
   "metadata": {},
   "outputs": [],
   "source": [
    "from Quantamental_functions import *\n",
    "\n",
    "%load_ext autoreload\n",
    "%autoreload 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "c80bf146",
   "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": "382fa5f9",
   "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": "454247b2",
   "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": "e6bf2970",
   "metadata": {},
   "outputs": [],
   "source": [
    "facts_info = fetch_facts(form_accno, url_facts)\n",
    "facts_data = load_pickle(facts_info)\n",
    "#facts_data = load_pickle('facts_data.pkl')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "f30ccdaf",
   "metadata": {},
   "outputs": [],
   "source": [
    "facts_df_file = dfs_facts_tickers(facts_data, bond_yield, 'facts')\n",
    "facts_df = load_pickle(facts_df_file)\n",
    "#facts_df = load_pickle('facts_df_file.pkl')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "9a6c2745",
   "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>47</th>\n",
       "      <td>858877</td>\n",
       "      <td>CSCO</td>\n",
       "      <td>CISCO SYSTEMS, INC.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>461</th>\n",
       "      <td>1050952</td>\n",
       "      <td>PUBGY</td>\n",
       "      <td>PUBLICIS GROUPE SA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2589</th>\n",
       "      <td>1013605</td>\n",
       "      <td>PDS</td>\n",
       "      <td>PRECISION DRILLING CORP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2906</th>\n",
       "      <td>1689548</td>\n",
       "      <td>PRAX</td>\n",
       "      <td>PRAXIS PRECISION MEDICINES, INC.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3397</th>\n",
       "      <td>1487952</td>\n",
       "      <td>VPG</td>\n",
       "      <td>VISHAY PRECISION GROUP, INC.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4896</th>\n",
       "      <td>1505611</td>\n",
       "      <td>DPSI</td>\n",
       "      <td>DECISIONPOINT SYSTEMS, INC.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5093</th>\n",
       "      <td>1357874</td>\n",
       "      <td>DTIL</td>\n",
       "      <td>PRECISION BIOSCIENCES INC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5532</th>\n",
       "      <td>867840</td>\n",
       "      <td>POCI</td>\n",
       "      <td>PRECISION OPTICS CORPORATION, INC.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5550</th>\n",
       "      <td>1328792</td>\n",
       "      <td>TPCS</td>\n",
       "      <td>TECHPRECISION CORP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5688</th>\n",
       "      <td>1715925</td>\n",
       "      <td>IPA</td>\n",
       "      <td>IMMUNOPRECISE ANTIBODIES LTD.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6362</th>\n",
       "      <td>1777319</td>\n",
       "      <td>CISO</td>\n",
       "      <td>CISO GLOBAL, INC.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6589</th>\n",
       "      <td>1716621</td>\n",
       "      <td>VTAK</td>\n",
       "      <td>CATHETER PRECISION, INC.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6691</th>\n",
       "      <td>930775</td>\n",
       "      <td>ECIA</td>\n",
       "      <td>ENCISION INC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6768</th>\n",
       "      <td>1611746</td>\n",
       "      <td>SPRC</td>\n",
       "      <td>SCISPARC LTD.</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      cik_str ticker                               title\n",
       "47     858877   CSCO                 CISCO SYSTEMS, INC.\n",
       "461   1050952  PUBGY                  PUBLICIS GROUPE SA\n",
       "2589  1013605    PDS             PRECISION DRILLING CORP\n",
       "2906  1689548   PRAX    PRAXIS PRECISION MEDICINES, INC.\n",
       "3397  1487952    VPG        VISHAY PRECISION GROUP, INC.\n",
       "4896  1505611   DPSI         DECISIONPOINT SYSTEMS, INC.\n",
       "5093  1357874   DTIL           PRECISION BIOSCIENCES INC\n",
       "5532   867840   POCI  PRECISION OPTICS CORPORATION, INC.\n",
       "5550  1328792   TPCS                  TECHPRECISION CORP\n",
       "5688  1715925    IPA       IMMUNOPRECISE ANTIBODIES LTD.\n",
       "6362  1777319   CISO                   CISO GLOBAL, INC.\n",
       "6589  1716621   VTAK            CATHETER PRECISION, INC.\n",
       "6691   930775   ECIA                        ENCISION INC\n",
       "6768  1611746   SPRC                       SCISPARC LTD."
      ]
     },
     "execution_count": 7,
     "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": 8,
   "id": "4df722b9",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CIK: 858877\n",
      "CSCO is classified as Defensive.\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>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>marketable securities</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>accrued expenses and other</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-03-31</th>\n",
       "      <td>1385000000.00</td>\n",
       "      <td>5146000000.00</td>\n",
       "      <td>0.46</td>\n",
       "      <td>168000000.00</td>\n",
       "      <td>-1250000000.00</td>\n",
       "      <td>-2495000000.00</td>\n",
       "      <td>3080000000.00</td>\n",
       "      <td>3267000000.00</td>\n",
       "      <td>6708000000.00</td>\n",
       "      <td>61000000.00</td>\n",
       "      <td>0.46</td>\n",
       "      <td>29766000000.00</td>\n",
       "      <td>7884000000.00</td>\n",
       "      <td>2962000000.00</td>\n",
       "      <td>2539000000.00</td>\n",
       "      <td>1616000000.00</td>\n",
       "      <td>30472000000.00</td>\n",
       "      <td>37614000000.00</td>\n",
       "      <td>2322000000.00</td>\n",
       "      <td>4983000000.00</td>\n",
       "      <td>2877000000.00</td>\n",
       "      <td>48000000.00</td>\n",
       "      <td>1567000000.00</td>\n",
       "      <td>20838000000.00</td>\n",
       "      <td>3322000000.00</td>\n",
       "      <td>129818000000.00</td>\n",
       "      <td>83703000000.00</td>\n",
       "      <td>27583000000.00</td>\n",
       "      <td>63681000000.00</td>\n",
       "      <td>129818000000.00</td>\n",
       "      <td>206000000.00</td>\n",
       "      <td>4671000000.00</td>\n",
       "      <td>23932000000.00</td>\n",
       "      <td>66137000000.00</td>\n",
       "      <td>43.03</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>3.03</td>\n",
       "      <td>56120000000.00</td>\n",
       "      <td>93.54</td>\n",
       "      <td>13.27</td>\n",
       "      <td>3.24</td>\n",
       "      <td>303.27</td>\n",
       "      <td>63681000000.00</td>\n",
       "      <td>0.67</td>\n",
       "      <td>4.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-30</th>\n",
       "      <td>1385000000.00</td>\n",
       "      <td>5146000000.00</td>\n",
       "      <td>0.93</td>\n",
       "      <td>526000000.00</td>\n",
       "      <td>1743000000.00</td>\n",
       "      <td>-4978000000.00</td>\n",
       "      <td>6502000000.00</td>\n",
       "      <td>3267000000.00</td>\n",
       "      <td>6708000000.00</td>\n",
       "      <td>142000000.00</td>\n",
       "      <td>0.92</td>\n",
       "      <td>29766000000.00</td>\n",
       "      <td>15160000000.00</td>\n",
       "      <td>5916000000.00</td>\n",
       "      <td>2539000000.00</td>\n",
       "      <td>1616000000.00</td>\n",
       "      <td>30472000000.00</td>\n",
       "      <td>37614000000.00</td>\n",
       "      <td>4670000000.00</td>\n",
       "      <td>4983000000.00</td>\n",
       "      <td>5770000000.00</td>\n",
       "      <td>48000000.00</td>\n",
       "      <td>3053000000.00</td>\n",
       "      <td>20838000000.00</td>\n",
       "      <td>3322000000.00</td>\n",
       "      <td>129818000000.00</td>\n",
       "      <td>83703000000.00</td>\n",
       "      <td>27583000000.00</td>\n",
       "      <td>63681000000.00</td>\n",
       "      <td>129818000000.00</td>\n",
       "      <td>146000000.00</td>\n",
       "      <td>9390000000.00</td>\n",
       "      <td>23932000000.00</td>\n",
       "      <td>66137000000.00</td>\n",
       "      <td>43.03</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3.03</td>\n",
       "      <td>56120000000.00</td>\n",
       "      <td>46.77</td>\n",
       "      <td>13.27</td>\n",
       "      <td>3.24</td>\n",
       "      <td>151.64</td>\n",
       "      <td>63681000000.00</td>\n",
       "      <td>0.67</td>\n",
       "      <td>4.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-30</th>\n",
       "      <td>1385000000.00</td>\n",
       "      <td>5146000000.00</td>\n",
       "      <td>1.43</td>\n",
       "      <td>756000000.00</td>\n",
       "      <td>-2702000000.00</td>\n",
       "      <td>-6688000000.00</td>\n",
       "      <td>9875000000.00</td>\n",
       "      <td>485000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>201000000.00</td>\n",
       "      <td>1.42</td>\n",
       "      <td>29766000000.00</td>\n",
       "      <td>22678000000.00</td>\n",
       "      <td>9107000000.00</td>\n",
       "      <td>2539000000.00</td>\n",
       "      <td>1616000000.00</td>\n",
       "      <td>30472000000.00</td>\n",
       "      <td>37614000000.00</td>\n",
       "      <td>7185000000.00</td>\n",
       "      <td>4983000000.00</td>\n",
       "      <td>8939000000.00</td>\n",
       "      <td>48000000.00</td>\n",
       "      <td>4560000000.00</td>\n",
       "      <td>20838000000.00</td>\n",
       "      <td>3322000000.00</td>\n",
       "      <td>129818000000.00</td>\n",
       "      <td>83703000000.00</td>\n",
       "      <td>27583000000.00</td>\n",
       "      <td>63681000000.00</td>\n",
       "      <td>129818000000.00</td>\n",
       "      <td>168000000.00</td>\n",
       "      <td>13739000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>66137000000.00</td>\n",
       "      <td>48.65</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.54</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3.03</td>\n",
       "      <td>56120000000.00</td>\n",
       "      <td>34.26</td>\n",
       "      <td>13.27</td>\n",
       "      <td>3.67</td>\n",
       "      <td>125.58</td>\n",
       "      <td>63681000000.00</td>\n",
       "      <td>0.67</td>\n",
       "      <td>4.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-12-31</th>\n",
       "      <td>1385000000.00</td>\n",
       "      <td>5146000000.00</td>\n",
       "      <td>1.43</td>\n",
       "      <td>756000000.00</td>\n",
       "      <td>-2702000000.00</td>\n",
       "      <td>-6688000000.00</td>\n",
       "      <td>9875000000.00</td>\n",
       "      <td>485000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>201000000.00</td>\n",
       "      <td>1.42</td>\n",
       "      <td>29766000000.00</td>\n",
       "      <td>22678000000.00</td>\n",
       "      <td>9107000000.00</td>\n",
       "      <td>2539000000.00</td>\n",
       "      <td>1616000000.00</td>\n",
       "      <td>30472000000.00</td>\n",
       "      <td>37614000000.00</td>\n",
       "      <td>7185000000.00</td>\n",
       "      <td>4983000000.00</td>\n",
       "      <td>8939000000.00</td>\n",
       "      <td>48000000.00</td>\n",
       "      <td>4560000000.00</td>\n",
       "      <td>20838000000.00</td>\n",
       "      <td>3322000000.00</td>\n",
       "      <td>129818000000.00</td>\n",
       "      <td>83703000000.00</td>\n",
       "      <td>27583000000.00</td>\n",
       "      <td>63681000000.00</td>\n",
       "      <td>129818000000.00</td>\n",
       "      <td>168000000.00</td>\n",
       "      <td>13739000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>66137000000.00</td>\n",
       "      <td>43.33</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>3.03</td>\n",
       "      <td>56120000000.00</td>\n",
       "      <td>30.51</td>\n",
       "      <td>13.27</td>\n",
       "      <td>3.26</td>\n",
       "      <td>99.62</td>\n",
       "      <td>63681000000.00</td>\n",
       "      <td>0.67</td>\n",
       "      <td>4.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-31</th>\n",
       "      <td>1904000000.00</td>\n",
       "      <td>5554000000.00</td>\n",
       "      <td>0.48</td>\n",
       "      <td>212000000.00</td>\n",
       "      <td>-6945000000.00</td>\n",
       "      <td>2675000000.00</td>\n",
       "      <td>3763000000.00</td>\n",
       "      <td>485000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>34000000.00</td>\n",
       "      <td>0.48</td>\n",
       "      <td>31706000000.00</td>\n",
       "      <td>7427000000.00</td>\n",
       "      <td>3909000000.00</td>\n",
       "      <td>2552000000.00</td>\n",
       "      <td>1846000000.00</td>\n",
       "      <td>25569000000.00</td>\n",
       "      <td>37614000000.00</td>\n",
       "      <td>2394000000.00</td>\n",
       "      <td>4614000000.00</td>\n",
       "      <td>2756000000.00</td>\n",
       "      <td>48000000.00</td>\n",
       "      <td>1608000000.00</td>\n",
       "      <td>1233000000.00</td>\n",
       "      <td>3006000000.00</td>\n",
       "      <td>108784000000.00</td>\n",
       "      <td>61837000000.00</td>\n",
       "      <td>27035000000.00</td>\n",
       "      <td>65580000000.00</td>\n",
       "      <td>108784000000.00</td>\n",
       "      <td>104000000.00</td>\n",
       "      <td>4341000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>43204000000.00</td>\n",
       "      <td>53.99</td>\n",
       "      <td>0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>-0.66</td>\n",
       "      <td>651.02</td>\n",
       "      <td>0.92</td>\n",
       "      <td>2.29</td>\n",
       "      <td>34802000000.00</td>\n",
       "      <td>112.48</td>\n",
       "      <td>9.36</td>\n",
       "      <td>5.77</td>\n",
       "      <td>648.54</td>\n",
       "      <td>65580000000.00</td>\n",
       "      <td>0.65</td>\n",
       "      <td>-0.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-06-30</th>\n",
       "      <td>1904000000.00</td>\n",
       "      <td>5554000000.00</td>\n",
       "      <td>-1.29</td>\n",
       "      <td>379000000.00</td>\n",
       "      <td>-2729000000.00</td>\n",
       "      <td>1485000000.00</td>\n",
       "      <td>7150000000.00</td>\n",
       "      <td>485000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>121000000.00</td>\n",
       "      <td>-1.29</td>\n",
       "      <td>31706000000.00</td>\n",
       "      <td>14925000000.00</td>\n",
       "      <td>6194000000.00</td>\n",
       "      <td>2552000000.00</td>\n",
       "      <td>1846000000.00</td>\n",
       "      <td>25569000000.00</td>\n",
       "      <td>37614000000.00</td>\n",
       "      <td>-6384000000.00</td>\n",
       "      <td>4614000000.00</td>\n",
       "      <td>5829000000.00</td>\n",
       "      <td>48000000.00</td>\n",
       "      <td>3116000000.00</td>\n",
       "      <td>1233000000.00</td>\n",
       "      <td>3006000000.00</td>\n",
       "      <td>108784000000.00</td>\n",
       "      <td>61837000000.00</td>\n",
       "      <td>27035000000.00</td>\n",
       "      <td>65580000000.00</td>\n",
       "      <td>108784000000.00</td>\n",
       "      <td>365000000.00</td>\n",
       "      <td>9096000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>43204000000.00</td>\n",
       "      <td>54.73</td>\n",
       "      <td>0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>-3.69</td>\n",
       "      <td>-313.78</td>\n",
       "      <td>1.17</td>\n",
       "      <td>2.29</td>\n",
       "      <td>34802000000.00</td>\n",
       "      <td>-42.43</td>\n",
       "      <td>9.36</td>\n",
       "      <td>5.84</td>\n",
       "      <td>-247.98</td>\n",
       "      <td>65580000000.00</td>\n",
       "      <td>0.65</td>\n",
       "      <td>-0.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-09-30</th>\n",
       "      <td>1904000000.00</td>\n",
       "      <td>5554000000.00</td>\n",
       "      <td>-0.76</td>\n",
       "      <td>620000000.00</td>\n",
       "      <td>-21810000000.00</td>\n",
       "      <td>7242000000.00</td>\n",
       "      <td>9566000000.00</td>\n",
       "      <td>485000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>188000000.00</td>\n",
       "      <td>-0.76</td>\n",
       "      <td>31706000000.00</td>\n",
       "      <td>22684000000.00</td>\n",
       "      <td>9447000000.00</td>\n",
       "      <td>2552000000.00</td>\n",
       "      <td>1846000000.00</td>\n",
       "      <td>25569000000.00</td>\n",
       "      <td>37614000000.00</td>\n",
       "      <td>-3693000000.00</td>\n",
       "      <td>4614000000.00</td>\n",
       "      <td>8963000000.00</td>\n",
       "      <td>48000000.00</td>\n",
       "      <td>4706000000.00</td>\n",
       "      <td>1233000000.00</td>\n",
       "      <td>3006000000.00</td>\n",
       "      <td>108784000000.00</td>\n",
       "      <td>61837000000.00</td>\n",
       "      <td>27035000000.00</td>\n",
       "      <td>65580000000.00</td>\n",
       "      <td>108784000000.00</td>\n",
       "      <td>484000000.00</td>\n",
       "      <td>13721000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>43204000000.00</td>\n",
       "      <td>49.41</td>\n",
       "      <td>0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>-0.41</td>\n",
       "      <td>-1450.63</td>\n",
       "      <td>1.03</td>\n",
       "      <td>2.29</td>\n",
       "      <td>34802000000.00</td>\n",
       "      <td>-65.01</td>\n",
       "      <td>9.36</td>\n",
       "      <td>5.28</td>\n",
       "      <td>-343.06</td>\n",
       "      <td>65580000000.00</td>\n",
       "      <td>0.65</td>\n",
       "      <td>-0.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-12-31</th>\n",
       "      <td>1904000000.00</td>\n",
       "      <td>5554000000.00</td>\n",
       "      <td>-0.76</td>\n",
       "      <td>620000000.00</td>\n",
       "      <td>-21810000000.00</td>\n",
       "      <td>7242000000.00</td>\n",
       "      <td>9566000000.00</td>\n",
       "      <td>485000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>188000000.00</td>\n",
       "      <td>-0.76</td>\n",
       "      <td>31706000000.00</td>\n",
       "      <td>22684000000.00</td>\n",
       "      <td>9447000000.00</td>\n",
       "      <td>2552000000.00</td>\n",
       "      <td>1846000000.00</td>\n",
       "      <td>25569000000.00</td>\n",
       "      <td>37614000000.00</td>\n",
       "      <td>-3693000000.00</td>\n",
       "      <td>4614000000.00</td>\n",
       "      <td>8963000000.00</td>\n",
       "      <td>48000000.00</td>\n",
       "      <td>4706000000.00</td>\n",
       "      <td>1233000000.00</td>\n",
       "      <td>3006000000.00</td>\n",
       "      <td>108784000000.00</td>\n",
       "      <td>61837000000.00</td>\n",
       "      <td>27035000000.00</td>\n",
       "      <td>65580000000.00</td>\n",
       "      <td>108784000000.00</td>\n",
       "      <td>484000000.00</td>\n",
       "      <td>13721000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>43204000000.00</td>\n",
       "      <td>47.96</td>\n",
       "      <td>0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-1888.64</td>\n",
       "      <td>1.03</td>\n",
       "      <td>2.29</td>\n",
       "      <td>34802000000.00</td>\n",
       "      <td>-63.11</td>\n",
       "      <td>9.36</td>\n",
       "      <td>5.12</td>\n",
       "      <td>-323.22</td>\n",
       "      <td>65580000000.00</td>\n",
       "      <td>0.65</td>\n",
       "      <td>-0.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-03-31</th>\n",
       "      <td>2059000000.00</td>\n",
       "      <td>5491000000.00</td>\n",
       "      <td>0.78</td>\n",
       "      <td>202000000.00</td>\n",
       "      <td>-8668000000.00</td>\n",
       "      <td>1922000000.00</td>\n",
       "      <td>3587000000.00</td>\n",
       "      <td>-3159000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>36000000.00</td>\n",
       "      <td>0.77</td>\n",
       "      <td>33529000000.00</td>\n",
       "      <td>8146000000.00</td>\n",
       "      <td>3686000000.00</td>\n",
       "      <td>2201000000.00</td>\n",
       "      <td>1383000000.00</td>\n",
       "      <td>20473000000.00</td>\n",
       "      <td>21663000000.00</td>\n",
       "      <td>3549000000.00</td>\n",
       "      <td>4250000000.00</td>\n",
       "      <td>3805000000.00</td>\n",
       "      <td>48000000.00</td>\n",
       "      <td>1666000000.00</td>\n",
       "      <td>-5903000000.00</td>\n",
       "      <td>2789000000.00</td>\n",
       "      <td>97793000000.00</td>\n",
       "      <td>47755000000.00</td>\n",
       "      <td>31712000000.00</td>\n",
       "      <td>64222000000.00</td>\n",
       "      <td>97793000000.00</td>\n",
       "      <td>107000000.00</td>\n",
       "      <td>4885000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>33571000000.00</td>\n",
       "      <td>39.31</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-2.01</td>\n",
       "      <td>50522.81</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.51</td>\n",
       "      <td>16043000000.00</td>\n",
       "      <td>51.05</td>\n",
       "      <td>7.90</td>\n",
       "      <td>4.98</td>\n",
       "      <td>254.06</td>\n",
       "      <td>64222000000.00</td>\n",
       "      <td>0.66</td>\n",
       "      <td>-3.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-30</th>\n",
       "      <td>2059000000.00</td>\n",
       "      <td>5491000000.00</td>\n",
       "      <td>1.41</td>\n",
       "      <td>473000000.00</td>\n",
       "      <td>-13216000000.00</td>\n",
       "      <td>6542000000.00</td>\n",
       "      <td>7560000000.00</td>\n",
       "      <td>886000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>73000000.00</td>\n",
       "      <td>1.40</td>\n",
       "      <td>33529000000.00</td>\n",
       "      <td>15919000000.00</td>\n",
       "      <td>7252000000.00</td>\n",
       "      <td>2201000000.00</td>\n",
       "      <td>1383000000.00</td>\n",
       "      <td>20473000000.00</td>\n",
       "      <td>21663000000.00</td>\n",
       "      <td>6371000000.00</td>\n",
       "      <td>4250000000.00</td>\n",
       "      <td>7016000000.00</td>\n",
       "      <td>77000000.00</td>\n",
       "      <td>3165000000.00</td>\n",
       "      <td>-5903000000.00</td>\n",
       "      <td>2789000000.00</td>\n",
       "      <td>97793000000.00</td>\n",
       "      <td>47755000000.00</td>\n",
       "      <td>31712000000.00</td>\n",
       "      <td>64222000000.00</td>\n",
       "      <td>97793000000.00</td>\n",
       "      <td>236000000.00</td>\n",
       "      <td>8903000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>33571000000.00</td>\n",
       "      <td>46.64</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.82</td>\n",
       "      <td>46251.85</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.51</td>\n",
       "      <td>16043000000.00</td>\n",
       "      <td>33.31</td>\n",
       "      <td>7.90</td>\n",
       "      <td>5.90</td>\n",
       "      <td>196.70</td>\n",
       "      <td>64222000000.00</td>\n",
       "      <td>0.66</td>\n",
       "      <td>-3.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-09-30</th>\n",
       "      <td>2059000000.00</td>\n",
       "      <td>5491000000.00</td>\n",
       "      <td>2.11</td>\n",
       "      <td>701000000.00</td>\n",
       "      <td>-22757000000.00</td>\n",
       "      <td>12148000000.00</td>\n",
       "      <td>11889000000.00</td>\n",
       "      <td>1280000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>112000000.00</td>\n",
       "      <td>2.09</td>\n",
       "      <td>33529000000.00</td>\n",
       "      <td>24092000000.00</td>\n",
       "      <td>10867000000.00</td>\n",
       "      <td>2201000000.00</td>\n",
       "      <td>1383000000.00</td>\n",
       "      <td>20473000000.00</td>\n",
       "      <td>21663000000.00</td>\n",
       "      <td>9415000000.00</td>\n",
       "      <td>4250000000.00</td>\n",
       "      <td>10529000000.00</td>\n",
       "      <td>120000000.00</td>\n",
       "      <td>4824000000.00</td>\n",
       "      <td>-5903000000.00</td>\n",
       "      <td>2789000000.00</td>\n",
       "      <td>97793000000.00</td>\n",
       "      <td>47755000000.00</td>\n",
       "      <td>31712000000.00</td>\n",
       "      <td>64222000000.00</td>\n",
       "      <td>97793000000.00</td>\n",
       "      <td>338000000.00</td>\n",
       "      <td>13563000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>43204000000.00</td>\n",
       "      <td>39.39</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.49</td>\n",
       "      <td>102624.27</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.51</td>\n",
       "      <td>16043000000.00</td>\n",
       "      <td>18.85</td>\n",
       "      <td>10.17</td>\n",
       "      <td>3.87</td>\n",
       "      <td>73.03</td>\n",
       "      <td>54589000000.00</td>\n",
       "      <td>0.66</td>\n",
       "      <td>-1.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-12-31</th>\n",
       "      <td>2059000000.00</td>\n",
       "      <td>5491000000.00</td>\n",
       "      <td>2.11</td>\n",
       "      <td>701000000.00</td>\n",
       "      <td>-22757000000.00</td>\n",
       "      <td>12148000000.00</td>\n",
       "      <td>11889000000.00</td>\n",
       "      <td>1280000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>112000000.00</td>\n",
       "      <td>2.09</td>\n",
       "      <td>33529000000.00</td>\n",
       "      <td>24092000000.00</td>\n",
       "      <td>10867000000.00</td>\n",
       "      <td>2201000000.00</td>\n",
       "      <td>1383000000.00</td>\n",
       "      <td>20473000000.00</td>\n",
       "      <td>21663000000.00</td>\n",
       "      <td>9415000000.00</td>\n",
       "      <td>4250000000.00</td>\n",
       "      <td>10529000000.00</td>\n",
       "      <td>120000000.00</td>\n",
       "      <td>4824000000.00</td>\n",
       "      <td>-5903000000.00</td>\n",
       "      <td>2789000000.00</td>\n",
       "      <td>97793000000.00</td>\n",
       "      <td>47755000000.00</td>\n",
       "      <td>31712000000.00</td>\n",
       "      <td>64222000000.00</td>\n",
       "      <td>97793000000.00</td>\n",
       "      <td>338000000.00</td>\n",
       "      <td>13563000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>43204000000.00</td>\n",
       "      <td>44.75</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>120255.39</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.51</td>\n",
       "      <td>16043000000.00</td>\n",
       "      <td>21.41</td>\n",
       "      <td>10.17</td>\n",
       "      <td>4.40</td>\n",
       "      <td>94.26</td>\n",
       "      <td>54589000000.00</td>\n",
       "      <td>0.66</td>\n",
       "      <td>-1.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-31</th>\n",
       "      <td>2218000000.00</td>\n",
       "      <td>5472000000.00</td>\n",
       "      <td>0.51</td>\n",
       "      <td>171000000.00</td>\n",
       "      <td>-2373000000.00</td>\n",
       "      <td>-2710000000.00</td>\n",
       "      <td>4096000000.00</td>\n",
       "      <td>-987000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>36000000.00</td>\n",
       "      <td>0.51</td>\n",
       "      <td>33806000000.00</td>\n",
       "      <td>7581000000.00</td>\n",
       "      <td>2681000000.00</td>\n",
       "      <td>1576000000.00</td>\n",
       "      <td>1282000000.00</td>\n",
       "      <td>14583000000.00</td>\n",
       "      <td>17610000000.00</td>\n",
       "      <td>2174000000.00</td>\n",
       "      <td>4237000000.00</td>\n",
       "      <td>2570000000.00</td>\n",
       "      <td>921000000.00</td>\n",
       "      <td>1612000000.00</td>\n",
       "      <td>-2763000000.00</td>\n",
       "      <td>2453000000.00</td>\n",
       "      <td>94853000000.00</td>\n",
       "      <td>43573000000.00</td>\n",
       "      <td>25331000000.00</td>\n",
       "      <td>56933000000.00</td>\n",
       "      <td>94853000000.00</td>\n",
       "      <td>111000000.00</td>\n",
       "      <td>5011000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>33571000000.00</td>\n",
       "      <td>51.71</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-0.76</td>\n",
       "      <td>120624.29</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.72</td>\n",
       "      <td>18242000000.00</td>\n",
       "      <td>101.39</td>\n",
       "      <td>7.92</td>\n",
       "      <td>6.53</td>\n",
       "      <td>661.72</td>\n",
       "      <td>61282000000.00</td>\n",
       "      <td>0.58</td>\n",
       "      <td>-4.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-06-30</th>\n",
       "      <td>2218000000.00</td>\n",
       "      <td>5472000000.00</td>\n",
       "      <td>1.37</td>\n",
       "      <td>391000000.00</td>\n",
       "      <td>-13425000000.00</td>\n",
       "      <td>2765000000.00</td>\n",
       "      <td>7387000000.00</td>\n",
       "      <td>-3273000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>74000000.00</td>\n",
       "      <td>1.36</td>\n",
       "      <td>33806000000.00</td>\n",
       "      <td>16228000000.00</td>\n",
       "      <td>7220000000.00</td>\n",
       "      <td>1576000000.00</td>\n",
       "      <td>1282000000.00</td>\n",
       "      <td>14583000000.00</td>\n",
       "      <td>17610000000.00</td>\n",
       "      <td>5804000000.00</td>\n",
       "      <td>4237000000.00</td>\n",
       "      <td>6959000000.00</td>\n",
       "      <td>921000000.00</td>\n",
       "      <td>3236000000.00</td>\n",
       "      <td>-2763000000.00</td>\n",
       "      <td>2453000000.00</td>\n",
       "      <td>94853000000.00</td>\n",
       "      <td>43573000000.00</td>\n",
       "      <td>25331000000.00</td>\n",
       "      <td>56933000000.00</td>\n",
       "      <td>94853000000.00</td>\n",
       "      <td>261000000.00</td>\n",
       "      <td>9269000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>33571000000.00</td>\n",
       "      <td>53.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.67</td>\n",
       "      <td>177026.67</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.72</td>\n",
       "      <td>18242000000.00</td>\n",
       "      <td>38.97</td>\n",
       "      <td>7.92</td>\n",
       "      <td>6.69</td>\n",
       "      <td>260.68</td>\n",
       "      <td>61282000000.00</td>\n",
       "      <td>0.58</td>\n",
       "      <td>-4.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-30</th>\n",
       "      <td>2218000000.00</td>\n",
       "      <td>5472000000.00</td>\n",
       "      <td>2.02</td>\n",
       "      <td>562000000.00</td>\n",
       "      <td>-16027000000.00</td>\n",
       "      <td>3001000000.00</td>\n",
       "      <td>11624000000.00</td>\n",
       "      <td>-1402000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>108000000.00</td>\n",
       "      <td>2.01</td>\n",
       "      <td>33806000000.00</td>\n",
       "      <td>23999000000.00</td>\n",
       "      <td>10664000000.00</td>\n",
       "      <td>1576000000.00</td>\n",
       "      <td>1282000000.00</td>\n",
       "      <td>14583000000.00</td>\n",
       "      <td>17610000000.00</td>\n",
       "      <td>8578000000.00</td>\n",
       "      <td>4237000000.00</td>\n",
       "      <td>10373000000.00</td>\n",
       "      <td>921000000.00</td>\n",
       "      <td>4782000000.00</td>\n",
       "      <td>-2763000000.00</td>\n",
       "      <td>2453000000.00</td>\n",
       "      <td>94853000000.00</td>\n",
       "      <td>43573000000.00</td>\n",
       "      <td>25331000000.00</td>\n",
       "      <td>56933000000.00</td>\n",
       "      <td>94853000000.00</td>\n",
       "      <td>291000000.00</td>\n",
       "      <td>13626000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>33571000000.00</td>\n",
       "      <td>54.43</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.48</td>\n",
       "      <td>298670.79</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.72</td>\n",
       "      <td>18242000000.00</td>\n",
       "      <td>27.08</td>\n",
       "      <td>7.92</td>\n",
       "      <td>6.87</td>\n",
       "      <td>186.03</td>\n",
       "      <td>61282000000.00</td>\n",
       "      <td>0.58</td>\n",
       "      <td>-4.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-31</th>\n",
       "      <td>2218000000.00</td>\n",
       "      <td>5472000000.00</td>\n",
       "      <td>2.02</td>\n",
       "      <td>562000000.00</td>\n",
       "      <td>-16027000000.00</td>\n",
       "      <td>3001000000.00</td>\n",
       "      <td>11624000000.00</td>\n",
       "      <td>-1402000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>108000000.00</td>\n",
       "      <td>2.01</td>\n",
       "      <td>33806000000.00</td>\n",
       "      <td>23999000000.00</td>\n",
       "      <td>10664000000.00</td>\n",
       "      <td>1576000000.00</td>\n",
       "      <td>1282000000.00</td>\n",
       "      <td>14583000000.00</td>\n",
       "      <td>17610000000.00</td>\n",
       "      <td>8578000000.00</td>\n",
       "      <td>4237000000.00</td>\n",
       "      <td>10373000000.00</td>\n",
       "      <td>921000000.00</td>\n",
       "      <td>4782000000.00</td>\n",
       "      <td>-2763000000.00</td>\n",
       "      <td>2453000000.00</td>\n",
       "      <td>94853000000.00</td>\n",
       "      <td>43573000000.00</td>\n",
       "      <td>25331000000.00</td>\n",
       "      <td>56933000000.00</td>\n",
       "      <td>94853000000.00</td>\n",
       "      <td>291000000.00</td>\n",
       "      <td>13626000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>33571000000.00</td>\n",
       "      <td>63.37</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>227800.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.72</td>\n",
       "      <td>18242000000.00</td>\n",
       "      <td>31.53</td>\n",
       "      <td>7.92</td>\n",
       "      <td>8.00</td>\n",
       "      <td>252.15</td>\n",
       "      <td>61282000000.00</td>\n",
       "      <td>0.58</td>\n",
       "      <td>-4.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-31</th>\n",
       "      <td>2362000000.00</td>\n",
       "      <td>5766000000.00</td>\n",
       "      <td>0.71</td>\n",
       "      <td>122000000.00</td>\n",
       "      <td>-3970000000.00</td>\n",
       "      <td>-1020000000.00</td>\n",
       "      <td>3427000000.00</td>\n",
       "      <td>-1563000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>84000000.00</td>\n",
       "      <td>0.70</td>\n",
       "      <td>38168000000.00</td>\n",
       "      <td>8053000000.00</td>\n",
       "      <td>3657000000.00</td>\n",
       "      <td>3619000000.00</td>\n",
       "      <td>1559000000.00</td>\n",
       "      <td>11526000000.00</td>\n",
       "      <td>15343000000.00</td>\n",
       "      <td>2980000000.00</td>\n",
       "      <td>4217000000.00</td>\n",
       "      <td>3438000000.00</td>\n",
       "      <td>1095000000.00</td>\n",
       "      <td>1714000000.00</td>\n",
       "      <td>-654000000.00</td>\n",
       "      <td>2338000000.00</td>\n",
       "      <td>97497000000.00</td>\n",
       "      <td>39112000000.00</td>\n",
       "      <td>26257000000.00</td>\n",
       "      <td>56222000000.00</td>\n",
       "      <td>97497000000.00</td>\n",
       "      <td>219000000.00</td>\n",
       "      <td>4615000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>37920000000.00</td>\n",
       "      <td>55.76</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-0.65</td>\n",
       "      <td>4496.00</td>\n",
       "      <td>0.99</td>\n",
       "      <td>1.49</td>\n",
       "      <td>12855000000.00</td>\n",
       "      <td>79.66</td>\n",
       "      <td>8.99</td>\n",
       "      <td>6.20</td>\n",
       "      <td>493.95</td>\n",
       "      <td>59577000000.00</td>\n",
       "      <td>0.55</td>\n",
       "      <td>-4.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-06-30</th>\n",
       "      <td>2362000000.00</td>\n",
       "      <td>5766000000.00</td>\n",
       "      <td>1.12</td>\n",
       "      <td>358000000.00</td>\n",
       "      <td>-4551000000.00</td>\n",
       "      <td>-2528000000.00</td>\n",
       "      <td>7070000000.00</td>\n",
       "      <td>-9000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>75000000.00</td>\n",
       "      <td>1.11</td>\n",
       "      <td>38168000000.00</td>\n",
       "      <td>15365000000.00</td>\n",
       "      <td>5936000000.00</td>\n",
       "      <td>3619000000.00</td>\n",
       "      <td>1559000000.00</td>\n",
       "      <td>11526000000.00</td>\n",
       "      <td>15343000000.00</td>\n",
       "      <td>4719000000.00</td>\n",
       "      <td>4217000000.00</td>\n",
       "      <td>5793000000.00</td>\n",
       "      <td>1095000000.00</td>\n",
       "      <td>3139000000.00</td>\n",
       "      <td>-654000000.00</td>\n",
       "      <td>2338000000.00</td>\n",
       "      <td>97497000000.00</td>\n",
       "      <td>39112000000.00</td>\n",
       "      <td>26257000000.00</td>\n",
       "      <td>56222000000.00</td>\n",
       "      <td>97497000000.00</td>\n",
       "      <td>143000000.00</td>\n",
       "      <td>9572000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>37920000000.00</td>\n",
       "      <td>42.64</td>\n",
       "      <td>0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.59</td>\n",
       "      <td>2952.20</td>\n",
       "      <td>0.99</td>\n",
       "      <td>1.49</td>\n",
       "      <td>12855000000.00</td>\n",
       "      <td>38.41</td>\n",
       "      <td>8.99</td>\n",
       "      <td>4.74</td>\n",
       "      <td>182.16</td>\n",
       "      <td>59577000000.00</td>\n",
       "      <td>0.55</td>\n",
       "      <td>-4.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-30</th>\n",
       "      <td>2362000000.00</td>\n",
       "      <td>5766000000.00</td>\n",
       "      <td>1.79</td>\n",
       "      <td>530000000.00</td>\n",
       "      <td>-9770000000.00</td>\n",
       "      <td>-5633000000.00</td>\n",
       "      <td>10950000000.00</td>\n",
       "      <td>-4453000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>136000000.00</td>\n",
       "      <td>1.79</td>\n",
       "      <td>38168000000.00</td>\n",
       "      <td>23550000000.00</td>\n",
       "      <td>9527000000.00</td>\n",
       "      <td>3619000000.00</td>\n",
       "      <td>1559000000.00</td>\n",
       "      <td>11526000000.00</td>\n",
       "      <td>15343000000.00</td>\n",
       "      <td>7582000000.00</td>\n",
       "      <td>4217000000.00</td>\n",
       "      <td>9258000000.00</td>\n",
       "      <td>1095000000.00</td>\n",
       "      <td>4836000000.00</td>\n",
       "      <td>-654000000.00</td>\n",
       "      <td>2338000000.00</td>\n",
       "      <td>97497000000.00</td>\n",
       "      <td>39112000000.00</td>\n",
       "      <td>26257000000.00</td>\n",
       "      <td>56222000000.00</td>\n",
       "      <td>97497000000.00</td>\n",
       "      <td>269000000.00</td>\n",
       "      <td>14292000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>37920000000.00</td>\n",
       "      <td>40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0.61</td>\n",
       "      <td>2408.68</td>\n",
       "      <td>0.98</td>\n",
       "      <td>1.49</td>\n",
       "      <td>12855000000.00</td>\n",
       "      <td>22.35</td>\n",
       "      <td>8.99</td>\n",
       "      <td>4.45</td>\n",
       "      <td>99.40</td>\n",
       "      <td>59577000000.00</td>\n",
       "      <td>0.55</td>\n",
       "      <td>-4.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-31</th>\n",
       "      <td>2362000000.00</td>\n",
       "      <td>5766000000.00</td>\n",
       "      <td>1.79</td>\n",
       "      <td>530000000.00</td>\n",
       "      <td>-9770000000.00</td>\n",
       "      <td>-5633000000.00</td>\n",
       "      <td>10950000000.00</td>\n",
       "      <td>-4453000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>136000000.00</td>\n",
       "      <td>1.79</td>\n",
       "      <td>38168000000.00</td>\n",
       "      <td>23550000000.00</td>\n",
       "      <td>9527000000.00</td>\n",
       "      <td>3619000000.00</td>\n",
       "      <td>1559000000.00</td>\n",
       "      <td>11526000000.00</td>\n",
       "      <td>15343000000.00</td>\n",
       "      <td>7582000000.00</td>\n",
       "      <td>4217000000.00</td>\n",
       "      <td>9258000000.00</td>\n",
       "      <td>1095000000.00</td>\n",
       "      <td>4836000000.00</td>\n",
       "      <td>-654000000.00</td>\n",
       "      <td>2338000000.00</td>\n",
       "      <td>97497000000.00</td>\n",
       "      <td>39112000000.00</td>\n",
       "      <td>26257000000.00</td>\n",
       "      <td>56222000000.00</td>\n",
       "      <td>97497000000.00</td>\n",
       "      <td>269000000.00</td>\n",
       "      <td>14292000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>37920000000.00</td>\n",
       "      <td>47.64</td>\n",
       "      <td>0</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1571.50</td>\n",
       "      <td>0.97</td>\n",
       "      <td>1.49</td>\n",
       "      <td>12855000000.00</td>\n",
       "      <td>26.61</td>\n",
       "      <td>8.99</td>\n",
       "      <td>5.30</td>\n",
       "      <td>141.00</td>\n",
       "      <td>59577000000.00</td>\n",
       "      <td>0.55</td>\n",
       "      <td>-4.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-31</th>\n",
       "      <td>2281000000.00</td>\n",
       "      <td>6622000000.00</td>\n",
       "      <td>0.65</td>\n",
       "      <td>176000000.00</td>\n",
       "      <td>-2855000000.00</td>\n",
       "      <td>-799000000.00</td>\n",
       "      <td>3962000000.00</td>\n",
       "      <td>213000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>71000000.00</td>\n",
       "      <td>0.65</td>\n",
       "      <td>38304000000.00</td>\n",
       "      <td>8346000000.00</td>\n",
       "      <td>3475000000.00</td>\n",
       "      <td>2569000000.00</td>\n",
       "      <td>2568000000.00</td>\n",
       "      <td>8915000000.00</td>\n",
       "      <td>12188000000.00</td>\n",
       "      <td>2670000000.00</td>\n",
       "      <td>4110000000.00</td>\n",
       "      <td>3540000000.00</td>\n",
       "      <td>1003000000.00</td>\n",
       "      <td>1781000000.00</td>\n",
       "      <td>-1319000000.00</td>\n",
       "      <td>1997000000.00</td>\n",
       "      <td>94002000000.00</td>\n",
       "      <td>36717000000.00</td>\n",
       "      <td>25640000000.00</td>\n",
       "      <td>54229000000.00</td>\n",
       "      <td>94002000000.00</td>\n",
       "      <td>-65000000.00</td>\n",
       "      <td>4806000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>41275000000.00</td>\n",
       "      <td>52.28</td>\n",
       "      <td>0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>-0.64</td>\n",
       "      <td>450.75</td>\n",
       "      <td>0.88</td>\n",
       "      <td>1.43</td>\n",
       "      <td>11077000000.00</td>\n",
       "      <td>80.43</td>\n",
       "      <td>10.04</td>\n",
       "      <td>5.21</td>\n",
       "      <td>418.71</td>\n",
       "      <td>52727000000.00</td>\n",
       "      <td>0.49</td>\n",
       "      <td>-3.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-06-30</th>\n",
       "      <td>2281000000.00</td>\n",
       "      <td>6622000000.00</td>\n",
       "      <td>1.42</td>\n",
       "      <td>232000000.00</td>\n",
       "      <td>-8344000000.00</td>\n",
       "      <td>31000000.00</td>\n",
       "      <td>5888000000.00</td>\n",
       "      <td>-2450000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>163000000.00</td>\n",
       "      <td>1.41</td>\n",
       "      <td>38304000000.00</td>\n",
       "      <td>16102000000.00</td>\n",
       "      <td>7260000000.00</td>\n",
       "      <td>2569000000.00</td>\n",
       "      <td>2568000000.00</td>\n",
       "      <td>8915000000.00</td>\n",
       "      <td>12188000000.00</td>\n",
       "      <td>5953000000.00</td>\n",
       "      <td>4110000000.00</td>\n",
       "      <td>6925000000.00</td>\n",
       "      <td>1003000000.00</td>\n",
       "      <td>3384000000.00</td>\n",
       "      <td>-1319000000.00</td>\n",
       "      <td>1997000000.00</td>\n",
       "      <td>94002000000.00</td>\n",
       "      <td>36717000000.00</td>\n",
       "      <td>25640000000.00</td>\n",
       "      <td>54229000000.00</td>\n",
       "      <td>94002000000.00</td>\n",
       "      <td>335000000.00</td>\n",
       "      <td>9177000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>41275000000.00</td>\n",
       "      <td>51.74</td>\n",
       "      <td>0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1.17</td>\n",
       "      <td>1304.91</td>\n",
       "      <td>0.96</td>\n",
       "      <td>1.43</td>\n",
       "      <td>11077000000.00</td>\n",
       "      <td>36.70</td>\n",
       "      <td>10.04</td>\n",
       "      <td>5.15</td>\n",
       "      <td>189.06</td>\n",
       "      <td>52727000000.00</td>\n",
       "      <td>0.49</td>\n",
       "      <td>-3.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-09-30</th>\n",
       "      <td>2281000000.00</td>\n",
       "      <td>6622000000.00</td>\n",
       "      <td>2.15</td>\n",
       "      <td>338000000.00</td>\n",
       "      <td>-12344000000.00</td>\n",
       "      <td>684000000.00</td>\n",
       "      <td>9549000000.00</td>\n",
       "      <td>-2233000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>240000000.00</td>\n",
       "      <td>2.14</td>\n",
       "      <td>38304000000.00</td>\n",
       "      <td>24223000000.00</td>\n",
       "      <td>11061000000.00</td>\n",
       "      <td>2569000000.00</td>\n",
       "      <td>2568000000.00</td>\n",
       "      <td>8915000000.00</td>\n",
       "      <td>12188000000.00</td>\n",
       "      <td>8997000000.00</td>\n",
       "      <td>4110000000.00</td>\n",
       "      <td>10535000000.00</td>\n",
       "      <td>1003000000.00</td>\n",
       "      <td>5092000000.00</td>\n",
       "      <td>-1319000000.00</td>\n",
       "      <td>1997000000.00</td>\n",
       "      <td>94002000000.00</td>\n",
       "      <td>36717000000.00</td>\n",
       "      <td>25640000000.00</td>\n",
       "      <td>54229000000.00</td>\n",
       "      <td>94002000000.00</td>\n",
       "      <td>526000000.00</td>\n",
       "      <td>13688000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>41275000000.00</td>\n",
       "      <td>53.76</td>\n",
       "      <td>0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.52</td>\n",
       "      <td>1694.07</td>\n",
       "      <td>0.97</td>\n",
       "      <td>1.43</td>\n",
       "      <td>11077000000.00</td>\n",
       "      <td>25.12</td>\n",
       "      <td>10.04</td>\n",
       "      <td>5.35</td>\n",
       "      <td>134.48</td>\n",
       "      <td>52727000000.00</td>\n",
       "      <td>0.49</td>\n",
       "      <td>-3.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-12-31</th>\n",
       "      <td>2281000000.00</td>\n",
       "      <td>6622000000.00</td>\n",
       "      <td>2.15</td>\n",
       "      <td>338000000.00</td>\n",
       "      <td>-12344000000.00</td>\n",
       "      <td>684000000.00</td>\n",
       "      <td>9549000000.00</td>\n",
       "      <td>-2233000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>240000000.00</td>\n",
       "      <td>2.14</td>\n",
       "      <td>38304000000.00</td>\n",
       "      <td>24223000000.00</td>\n",
       "      <td>11061000000.00</td>\n",
       "      <td>2569000000.00</td>\n",
       "      <td>2568000000.00</td>\n",
       "      <td>8915000000.00</td>\n",
       "      <td>12188000000.00</td>\n",
       "      <td>8997000000.00</td>\n",
       "      <td>4110000000.00</td>\n",
       "      <td>10535000000.00</td>\n",
       "      <td>1003000000.00</td>\n",
       "      <td>5092000000.00</td>\n",
       "      <td>-1319000000.00</td>\n",
       "      <td>1997000000.00</td>\n",
       "      <td>94002000000.00</td>\n",
       "      <td>36717000000.00</td>\n",
       "      <td>25640000000.00</td>\n",
       "      <td>54229000000.00</td>\n",
       "      <td>94002000000.00</td>\n",
       "      <td>526000000.00</td>\n",
       "      <td>13688000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>41275000000.00</td>\n",
       "      <td>50.52</td>\n",
       "      <td>0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1545.10</td>\n",
       "      <td>0.97</td>\n",
       "      <td>1.43</td>\n",
       "      <td>11077000000.00</td>\n",
       "      <td>23.61</td>\n",
       "      <td>10.04</td>\n",
       "      <td>5.03</td>\n",
       "      <td>118.76</td>\n",
       "      <td>52727000000.00</td>\n",
       "      <td>0.49</td>\n",
       "      <td>-3.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-03-31</th>\n",
       "      <td>2313000000.00</td>\n",
       "      <td>5854000000.00</td>\n",
       "      <td>2.15</td>\n",
       "      <td>338000000.00</td>\n",
       "      <td>-12344000000.00</td>\n",
       "      <td>684000000.00</td>\n",
       "      <td>9549000000.00</td>\n",
       "      <td>-2233000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>240000000.00</td>\n",
       "      <td>2.14</td>\n",
       "      <td>38535000000.00</td>\n",
       "      <td>24223000000.00</td>\n",
       "      <td>11061000000.00</td>\n",
       "      <td>1818000000.00</td>\n",
       "      <td>3644000000.00</td>\n",
       "      <td>8391000000.00</td>\n",
       "      <td>16023000000.00</td>\n",
       "      <td>8997000000.00</td>\n",
       "      <td>4066000000.00</td>\n",
       "      <td>10535000000.00</td>\n",
       "      <td>971000000.00</td>\n",
       "      <td>5092000000.00</td>\n",
       "      <td>1639000000.00</td>\n",
       "      <td>2085000000.00</td>\n",
       "      <td>101852000000.00</td>\n",
       "      <td>43348000000.00</td>\n",
       "      <td>31309000000.00</td>\n",
       "      <td>57499000000.00</td>\n",
       "      <td>101852000000.00</td>\n",
       "      <td>526000000.00</td>\n",
       "      <td>13688000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>39773000000.00</td>\n",
       "      <td>49.91</td>\n",
       "      <td>0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1538.27</td>\n",
       "      <td>0.97</td>\n",
       "      <td>1.38</td>\n",
       "      <td>12039000000.00</td>\n",
       "      <td>23.32</td>\n",
       "      <td>9.78</td>\n",
       "      <td>5.10</td>\n",
       "      <td>119.00</td>\n",
       "      <td>62079000000.00</td>\n",
       "      <td>0.51</td>\n",
       "      <td>-4.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-06-30</th>\n",
       "      <td>2313000000.00</td>\n",
       "      <td>5854000000.00</td>\n",
       "      <td>1.33</td>\n",
       "      <td>346000000.00</td>\n",
       "      <td>-5481000000.00</td>\n",
       "      <td>-1293000000.00</td>\n",
       "      <td>8701000000.00</td>\n",
       "      <td>1930000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>142000000.00</td>\n",
       "      <td>1.32</td>\n",
       "      <td>38535000000.00</td>\n",
       "      <td>16773000000.00</td>\n",
       "      <td>6890000000.00</td>\n",
       "      <td>1818000000.00</td>\n",
       "      <td>3644000000.00</td>\n",
       "      <td>8391000000.00</td>\n",
       "      <td>16023000000.00</td>\n",
       "      <td>5443000000.00</td>\n",
       "      <td>4066000000.00</td>\n",
       "      <td>6832000000.00</td>\n",
       "      <td>971000000.00</td>\n",
       "      <td>3636000000.00</td>\n",
       "      <td>1639000000.00</td>\n",
       "      <td>2085000000.00</td>\n",
       "      <td>101852000000.00</td>\n",
       "      <td>43348000000.00</td>\n",
       "      <td>31309000000.00</td>\n",
       "      <td>57499000000.00</td>\n",
       "      <td>101852000000.00</td>\n",
       "      <td>58000000.00</td>\n",
       "      <td>9941000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>39773000000.00</td>\n",
       "      <td>47.29</td>\n",
       "      <td>0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>-0.38</td>\n",
       "      <td>863.29</td>\n",
       "      <td>0.95</td>\n",
       "      <td>1.38</td>\n",
       "      <td>12039000000.00</td>\n",
       "      <td>35.83</td>\n",
       "      <td>9.78</td>\n",
       "      <td>4.83</td>\n",
       "      <td>173.20</td>\n",
       "      <td>62079000000.00</td>\n",
       "      <td>0.51</td>\n",
       "      <td>-4.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-09-30</th>\n",
       "      <td>2313000000.00</td>\n",
       "      <td>5854000000.00</td>\n",
       "      <td>2.11</td>\n",
       "      <td>616000000.00</td>\n",
       "      <td>-8976000000.00</td>\n",
       "      <td>-3887000000.00</td>\n",
       "      <td>13920000000.00</td>\n",
       "      <td>967000000.00</td>\n",
       "      <td>10113000000.00</td>\n",
       "      <td>212000000.00</td>\n",
       "      <td>2.11</td>\n",
       "      <td>38535000000.00</td>\n",
       "      <td>26005000000.00</td>\n",
       "      <td>10847000000.00</td>\n",
       "      <td>1818000000.00</td>\n",
       "      <td>3644000000.00</td>\n",
       "      <td>8391000000.00</td>\n",
       "      <td>16023000000.00</td>\n",
       "      <td>8655000000.00</td>\n",
       "      <td>4066000000.00</td>\n",
       "      <td>10778000000.00</td>\n",
       "      <td>278000000.00</td>\n",
       "      <td>5598000000.00</td>\n",
       "      <td>1639000000.00</td>\n",
       "      <td>2085000000.00</td>\n",
       "      <td>101852000000.00</td>\n",
       "      <td>43348000000.00</td>\n",
       "      <td>31309000000.00</td>\n",
       "      <td>57499000000.00</td>\n",
       "      <td>101852000000.00</td>\n",
       "      <td>69000000.00</td>\n",
       "      <td>15227000000.00</td>\n",
       "      <td>35872000000.00</td>\n",
       "      <td>39773000000.00</td>\n",
       "      <td>47.29</td>\n",
       "      <td>0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.60</td>\n",
       "      <td>1730.28</td>\n",
       "      <td>0.97</td>\n",
       "      <td>1.38</td>\n",
       "      <td>12039000000.00</td>\n",
       "      <td>22.41</td>\n",
       "      <td>9.78</td>\n",
       "      <td>4.83</td>\n",
       "      <td>108.35</td>\n",
       "      <td>62079000000.00</td>\n",
       "      <td>0.51</td>\n",
       "      <td>-4.61</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            accounts payable  accounts receivable  basic earnings per share  \\\n",
       "2018-03-31     1385000000.00        5146000000.00                      0.46   \n",
       "2018-06-30     1385000000.00        5146000000.00                      0.93   \n",
       "2018-09-30     1385000000.00        5146000000.00                      1.43   \n",
       "2018-12-31     1385000000.00        5146000000.00                      1.43   \n",
       "2019-03-31     1904000000.00        5554000000.00                      0.48   \n",
       "2019-06-30     1904000000.00        5554000000.00                     -1.29   \n",
       "2019-09-30     1904000000.00        5554000000.00                     -0.76   \n",
       "2019-12-31     1904000000.00        5554000000.00                     -0.76   \n",
       "2020-03-31     2059000000.00        5491000000.00                      0.78   \n",
       "2020-06-30     2059000000.00        5491000000.00                      1.41   \n",
       "2020-09-30     2059000000.00        5491000000.00                      2.11   \n",
       "2020-12-31     2059000000.00        5491000000.00                      2.11   \n",
       "2021-03-31     2218000000.00        5472000000.00                      0.51   \n",
       "2021-06-30     2218000000.00        5472000000.00                      1.37   \n",
       "2021-09-30     2218000000.00        5472000000.00                      2.02   \n",
       "2021-12-31     2218000000.00        5472000000.00                      2.02   \n",
       "2022-03-31     2362000000.00        5766000000.00                      0.71   \n",
       "2022-06-30     2362000000.00        5766000000.00                      1.12   \n",
       "2022-09-30     2362000000.00        5766000000.00                      1.79   \n",
       "2022-12-31     2362000000.00        5766000000.00                      1.79   \n",
       "2023-03-31     2281000000.00        6622000000.00                      0.65   \n",
       "2023-06-30     2281000000.00        6622000000.00                      1.42   \n",
       "2023-09-30     2281000000.00        6622000000.00                      2.15   \n",
       "2023-12-31     2281000000.00        6622000000.00                      2.15   \n",
       "2024-03-31     2313000000.00        5854000000.00                      2.15   \n",
       "2024-06-30     2313000000.00        5854000000.00                      1.33   \n",
       "2024-09-30     2313000000.00        5854000000.00                      2.11   \n",
       "\n",
       "                  capex  cash flow from financing  cash flow from investing  \\\n",
       "2018-03-31 168000000.00            -1250000000.00            -2495000000.00   \n",
       "2018-06-30 526000000.00             1743000000.00            -4978000000.00   \n",
       "2018-09-30 756000000.00            -2702000000.00            -6688000000.00   \n",
       "2018-12-31 756000000.00            -2702000000.00            -6688000000.00   \n",
       "2019-03-31 212000000.00            -6945000000.00             2675000000.00   \n",
       "2019-06-30 379000000.00            -2729000000.00             1485000000.00   \n",
       "2019-09-30 620000000.00           -21810000000.00             7242000000.00   \n",
       "2019-12-31 620000000.00           -21810000000.00             7242000000.00   \n",
       "2020-03-31 202000000.00            -8668000000.00             1922000000.00   \n",
       "2020-06-30 473000000.00           -13216000000.00             6542000000.00   \n",
       "2020-09-30 701000000.00           -22757000000.00            12148000000.00   \n",
       "2020-12-31 701000000.00           -22757000000.00            12148000000.00   \n",
       "2021-03-31 171000000.00            -2373000000.00            -2710000000.00   \n",
       "2021-06-30 391000000.00           -13425000000.00             2765000000.00   \n",
       "2021-09-30 562000000.00           -16027000000.00             3001000000.00   \n",
       "2021-12-31 562000000.00           -16027000000.00             3001000000.00   \n",
       "2022-03-31 122000000.00            -3970000000.00            -1020000000.00   \n",
       "2022-06-30 358000000.00            -4551000000.00            -2528000000.00   \n",
       "2022-09-30 530000000.00            -9770000000.00            -5633000000.00   \n",
       "2022-12-31 530000000.00            -9770000000.00            -5633000000.00   \n",
       "2023-03-31 176000000.00            -2855000000.00             -799000000.00   \n",
       "2023-06-30 232000000.00            -8344000000.00               31000000.00   \n",
       "2023-09-30 338000000.00           -12344000000.00              684000000.00   \n",
       "2023-12-31 338000000.00           -12344000000.00              684000000.00   \n",
       "2024-03-31 338000000.00           -12344000000.00              684000000.00   \n",
       "2024-06-30 346000000.00            -5481000000.00            -1293000000.00   \n",
       "2024-09-30 616000000.00            -8976000000.00            -3887000000.00   \n",
       "\n",
       "            cash flow from operations  change in cash  cost of sales  \\\n",
       "2018-03-31              3080000000.00   3267000000.00  6708000000.00   \n",
       "2018-06-30              6502000000.00   3267000000.00  6708000000.00   \n",
       "2018-09-30              9875000000.00    485000000.00 10113000000.00   \n",
       "2018-12-31              9875000000.00    485000000.00 10113000000.00   \n",
       "2019-03-31              3763000000.00    485000000.00 10113000000.00   \n",
       "2019-06-30              7150000000.00    485000000.00 10113000000.00   \n",
       "2019-09-30              9566000000.00    485000000.00 10113000000.00   \n",
       "2019-12-31              9566000000.00    485000000.00 10113000000.00   \n",
       "2020-03-31              3587000000.00  -3159000000.00 10113000000.00   \n",
       "2020-06-30              7560000000.00    886000000.00 10113000000.00   \n",
       "2020-09-30             11889000000.00   1280000000.00 10113000000.00   \n",
       "2020-12-31             11889000000.00   1280000000.00 10113000000.00   \n",
       "2021-03-31              4096000000.00   -987000000.00 10113000000.00   \n",
       "2021-06-30              7387000000.00  -3273000000.00 10113000000.00   \n",
       "2021-09-30             11624000000.00  -1402000000.00 10113000000.00   \n",
       "2021-12-31             11624000000.00  -1402000000.00 10113000000.00   \n",
       "2022-03-31              3427000000.00  -1563000000.00 10113000000.00   \n",
       "2022-06-30              7070000000.00     -9000000.00 10113000000.00   \n",
       "2022-09-30             10950000000.00  -4453000000.00 10113000000.00   \n",
       "2022-12-31             10950000000.00  -4453000000.00 10113000000.00   \n",
       "2023-03-31              3962000000.00    213000000.00 10113000000.00   \n",
       "2023-06-30              5888000000.00  -2450000000.00 10113000000.00   \n",
       "2023-09-30              9549000000.00  -2233000000.00 10113000000.00   \n",
       "2023-12-31              9549000000.00  -2233000000.00 10113000000.00   \n",
       "2024-03-31              9549000000.00  -2233000000.00 10113000000.00   \n",
       "2024-06-30              8701000000.00   1930000000.00 10113000000.00   \n",
       "2024-09-30             13920000000.00    967000000.00 10113000000.00   \n",
       "\n",
       "            depreciation and amortisation  diluted earnings per share  \\\n",
       "2018-03-31                    61000000.00                        0.46   \n",
       "2018-06-30                   142000000.00                        0.92   \n",
       "2018-09-30                   201000000.00                        1.42   \n",
       "2018-12-31                   201000000.00                        1.42   \n",
       "2019-03-31                    34000000.00                        0.48   \n",
       "2019-06-30                   121000000.00                       -1.29   \n",
       "2019-09-30                   188000000.00                       -0.76   \n",
       "2019-12-31                   188000000.00                       -0.76   \n",
       "2020-03-31                    36000000.00                        0.77   \n",
       "2020-06-30                    73000000.00                        1.40   \n",
       "2020-09-30                   112000000.00                        2.09   \n",
       "2020-12-31                   112000000.00                        2.09   \n",
       "2021-03-31                    36000000.00                        0.51   \n",
       "2021-06-30                    74000000.00                        1.36   \n",
       "2021-09-30                   108000000.00                        2.01   \n",
       "2021-12-31                   108000000.00                        2.01   \n",
       "2022-03-31                    84000000.00                        0.70   \n",
       "2022-06-30                    75000000.00                        1.11   \n",
       "2022-09-30                   136000000.00                        1.79   \n",
       "2022-12-31                   136000000.00                        1.79   \n",
       "2023-03-31                    71000000.00                        0.65   \n",
       "2023-06-30                   163000000.00                        1.41   \n",
       "2023-09-30                   240000000.00                        2.14   \n",
       "2023-12-31                   240000000.00                        2.14   \n",
       "2024-03-31                   240000000.00                        2.14   \n",
       "2024-06-30                   142000000.00                        1.32   \n",
       "2024-09-30                   212000000.00                        2.11   \n",
       "\n",
       "                 goodwill   gross profit  income before income taxes  \\\n",
       "2018-03-31 29766000000.00  7884000000.00               2962000000.00   \n",
       "2018-06-30 29766000000.00 15160000000.00               5916000000.00   \n",
       "2018-09-30 29766000000.00 22678000000.00               9107000000.00   \n",
       "2018-12-31 29766000000.00 22678000000.00               9107000000.00   \n",
       "2019-03-31 31706000000.00  7427000000.00               3909000000.00   \n",
       "2019-06-30 31706000000.00 14925000000.00               6194000000.00   \n",
       "2019-09-30 31706000000.00 22684000000.00               9447000000.00   \n",
       "2019-12-31 31706000000.00 22684000000.00               9447000000.00   \n",
       "2020-03-31 33529000000.00  8146000000.00               3686000000.00   \n",
       "2020-06-30 33529000000.00 15919000000.00               7252000000.00   \n",
       "2020-09-30 33529000000.00 24092000000.00              10867000000.00   \n",
       "2020-12-31 33529000000.00 24092000000.00              10867000000.00   \n",
       "2021-03-31 33806000000.00  7581000000.00               2681000000.00   \n",
       "2021-06-30 33806000000.00 16228000000.00               7220000000.00   \n",
       "2021-09-30 33806000000.00 23999000000.00              10664000000.00   \n",
       "2021-12-31 33806000000.00 23999000000.00              10664000000.00   \n",
       "2022-03-31 38168000000.00  8053000000.00               3657000000.00   \n",
       "2022-06-30 38168000000.00 15365000000.00               5936000000.00   \n",
       "2022-09-30 38168000000.00 23550000000.00               9527000000.00   \n",
       "2022-12-31 38168000000.00 23550000000.00               9527000000.00   \n",
       "2023-03-31 38304000000.00  8346000000.00               3475000000.00   \n",
       "2023-06-30 38304000000.00 16102000000.00               7260000000.00   \n",
       "2023-09-30 38304000000.00 24223000000.00              11061000000.00   \n",
       "2023-12-31 38304000000.00 24223000000.00              11061000000.00   \n",
       "2024-03-31 38535000000.00 24223000000.00              11061000000.00   \n",
       "2024-06-30 38535000000.00 16773000000.00               6890000000.00   \n",
       "2024-09-30 38535000000.00 26005000000.00              10847000000.00   \n",
       "\n",
       "            intangible assets   inventories  long term debt  \\\n",
       "2018-03-31      2539000000.00 1616000000.00  30472000000.00   \n",
       "2018-06-30      2539000000.00 1616000000.00  30472000000.00   \n",
       "2018-09-30      2539000000.00 1616000000.00  30472000000.00   \n",
       "2018-12-31      2539000000.00 1616000000.00  30472000000.00   \n",
       "2019-03-31      2552000000.00 1846000000.00  25569000000.00   \n",
       "2019-06-30      2552000000.00 1846000000.00  25569000000.00   \n",
       "2019-09-30      2552000000.00 1846000000.00  25569000000.00   \n",
       "2019-12-31      2552000000.00 1846000000.00  25569000000.00   \n",
       "2020-03-31      2201000000.00 1383000000.00  20473000000.00   \n",
       "2020-06-30      2201000000.00 1383000000.00  20473000000.00   \n",
       "2020-09-30      2201000000.00 1383000000.00  20473000000.00   \n",
       "2020-12-31      2201000000.00 1383000000.00  20473000000.00   \n",
       "2021-03-31      1576000000.00 1282000000.00  14583000000.00   \n",
       "2021-06-30      1576000000.00 1282000000.00  14583000000.00   \n",
       "2021-09-30      1576000000.00 1282000000.00  14583000000.00   \n",
       "2021-12-31      1576000000.00 1282000000.00  14583000000.00   \n",
       "2022-03-31      3619000000.00 1559000000.00  11526000000.00   \n",
       "2022-06-30      3619000000.00 1559000000.00  11526000000.00   \n",
       "2022-09-30      3619000000.00 1559000000.00  11526000000.00   \n",
       "2022-12-31      3619000000.00 1559000000.00  11526000000.00   \n",
       "2023-03-31      2569000000.00 2568000000.00   8915000000.00   \n",
       "2023-06-30      2569000000.00 2568000000.00   8915000000.00   \n",
       "2023-09-30      2569000000.00 2568000000.00   8915000000.00   \n",
       "2023-12-31      2569000000.00 2568000000.00   8915000000.00   \n",
       "2024-03-31      1818000000.00 3644000000.00   8391000000.00   \n",
       "2024-06-30      1818000000.00 3644000000.00   8391000000.00   \n",
       "2024-09-30      1818000000.00 3644000000.00   8391000000.00   \n",
       "\n",
       "            marketable securities     net income       nshares  \\\n",
       "2018-03-31         37614000000.00  2322000000.00 4983000000.00   \n",
       "2018-06-30         37614000000.00  4670000000.00 4983000000.00   \n",
       "2018-09-30         37614000000.00  7185000000.00 4983000000.00   \n",
       "2018-12-31         37614000000.00  7185000000.00 4983000000.00   \n",
       "2019-03-31         37614000000.00  2394000000.00 4614000000.00   \n",
       "2019-06-30         37614000000.00 -6384000000.00 4614000000.00   \n",
       "2019-09-30         37614000000.00 -3693000000.00 4614000000.00   \n",
       "2019-12-31         37614000000.00 -3693000000.00 4614000000.00   \n",
       "2020-03-31         21663000000.00  3549000000.00 4250000000.00   \n",
       "2020-06-30         21663000000.00  6371000000.00 4250000000.00   \n",
       "2020-09-30         21663000000.00  9415000000.00 4250000000.00   \n",
       "2020-12-31         21663000000.00  9415000000.00 4250000000.00   \n",
       "2021-03-31         17610000000.00  2174000000.00 4237000000.00   \n",
       "2021-06-30         17610000000.00  5804000000.00 4237000000.00   \n",
       "2021-09-30         17610000000.00  8578000000.00 4237000000.00   \n",
       "2021-12-31         17610000000.00  8578000000.00 4237000000.00   \n",
       "2022-03-31         15343000000.00  2980000000.00 4217000000.00   \n",
       "2022-06-30         15343000000.00  4719000000.00 4217000000.00   \n",
       "2022-09-30         15343000000.00  7582000000.00 4217000000.00   \n",
       "2022-12-31         15343000000.00  7582000000.00 4217000000.00   \n",
       "2023-03-31         12188000000.00  2670000000.00 4110000000.00   \n",
       "2023-06-30         12188000000.00  5953000000.00 4110000000.00   \n",
       "2023-09-30         12188000000.00  8997000000.00 4110000000.00   \n",
       "2023-12-31         12188000000.00  8997000000.00 4110000000.00   \n",
       "2024-03-31         16023000000.00  8997000000.00 4066000000.00   \n",
       "2024-06-30         16023000000.00  5443000000.00 4066000000.00   \n",
       "2024-09-30         16023000000.00  8655000000.00 4066000000.00   \n",
       "\n",
       "            operating income  operating leases  \\\n",
       "2018-03-31     2877000000.00       48000000.00   \n",
       "2018-06-30     5770000000.00       48000000.00   \n",
       "2018-09-30     8939000000.00       48000000.00   \n",
       "2018-12-31     8939000000.00       48000000.00   \n",
       "2019-03-31     2756000000.00       48000000.00   \n",
       "2019-06-30     5829000000.00       48000000.00   \n",
       "2019-09-30     8963000000.00       48000000.00   \n",
       "2019-12-31     8963000000.00       48000000.00   \n",
       "2020-03-31     3805000000.00       48000000.00   \n",
       "2020-06-30     7016000000.00       77000000.00   \n",
       "2020-09-30    10529000000.00      120000000.00   \n",
       "2020-12-31    10529000000.00      120000000.00   \n",
       "2021-03-31     2570000000.00      921000000.00   \n",
       "2021-06-30     6959000000.00      921000000.00   \n",
       "2021-09-30    10373000000.00      921000000.00   \n",
       "2021-12-31    10373000000.00      921000000.00   \n",
       "2022-03-31     3438000000.00     1095000000.00   \n",
       "2022-06-30     5793000000.00     1095000000.00   \n",
       "2022-09-30     9258000000.00     1095000000.00   \n",
       "2022-12-31     9258000000.00     1095000000.00   \n",
       "2023-03-31     3540000000.00     1003000000.00   \n",
       "2023-06-30     6925000000.00     1003000000.00   \n",
       "2023-09-30    10535000000.00     1003000000.00   \n",
       "2023-12-31    10535000000.00     1003000000.00   \n",
       "2024-03-31    10535000000.00      971000000.00   \n",
       "2024-06-30     6832000000.00      971000000.00   \n",
       "2024-09-30    10778000000.00      278000000.00   \n",
       "\n",
       "            research and development expense  retained earnings  \\\n",
       "2018-03-31                     1567000000.00     20838000000.00   \n",
       "2018-06-30                     3053000000.00     20838000000.00   \n",
       "2018-09-30                     4560000000.00     20838000000.00   \n",
       "2018-12-31                     4560000000.00     20838000000.00   \n",
       "2019-03-31                     1608000000.00      1233000000.00   \n",
       "2019-06-30                     3116000000.00      1233000000.00   \n",
       "2019-09-30                     4706000000.00      1233000000.00   \n",
       "2019-12-31                     4706000000.00      1233000000.00   \n",
       "2020-03-31                     1666000000.00     -5903000000.00   \n",
       "2020-06-30                     3165000000.00     -5903000000.00   \n",
       "2020-09-30                     4824000000.00     -5903000000.00   \n",
       "2020-12-31                     4824000000.00     -5903000000.00   \n",
       "2021-03-31                     1612000000.00     -2763000000.00   \n",
       "2021-06-30                     3236000000.00     -2763000000.00   \n",
       "2021-09-30                     4782000000.00     -2763000000.00   \n",
       "2021-12-31                     4782000000.00     -2763000000.00   \n",
       "2022-03-31                     1714000000.00      -654000000.00   \n",
       "2022-06-30                     3139000000.00      -654000000.00   \n",
       "2022-09-30                     4836000000.00      -654000000.00   \n",
       "2022-12-31                     4836000000.00      -654000000.00   \n",
       "2023-03-31                     1781000000.00     -1319000000.00   \n",
       "2023-06-30                     3384000000.00     -1319000000.00   \n",
       "2023-09-30                     5092000000.00     -1319000000.00   \n",
       "2023-12-31                     5092000000.00     -1319000000.00   \n",
       "2024-03-31                     5092000000.00      1639000000.00   \n",
       "2024-06-30                     3636000000.00      1639000000.00   \n",
       "2024-09-30                     5598000000.00      1639000000.00   \n",
       "\n",
       "            tangible assets    total assets  total current assets  \\\n",
       "2018-03-31    3322000000.00 129818000000.00        83703000000.00   \n",
       "2018-06-30    3322000000.00 129818000000.00        83703000000.00   \n",
       "2018-09-30    3322000000.00 129818000000.00        83703000000.00   \n",
       "2018-12-31    3322000000.00 129818000000.00        83703000000.00   \n",
       "2019-03-31    3006000000.00 108784000000.00        61837000000.00   \n",
       "2019-06-30    3006000000.00 108784000000.00        61837000000.00   \n",
       "2019-09-30    3006000000.00 108784000000.00        61837000000.00   \n",
       "2019-12-31    3006000000.00 108784000000.00        61837000000.00   \n",
       "2020-03-31    2789000000.00  97793000000.00        47755000000.00   \n",
       "2020-06-30    2789000000.00  97793000000.00        47755000000.00   \n",
       "2020-09-30    2789000000.00  97793000000.00        47755000000.00   \n",
       "2020-12-31    2789000000.00  97793000000.00        47755000000.00   \n",
       "2021-03-31    2453000000.00  94853000000.00        43573000000.00   \n",
       "2021-06-30    2453000000.00  94853000000.00        43573000000.00   \n",
       "2021-09-30    2453000000.00  94853000000.00        43573000000.00   \n",
       "2021-12-31    2453000000.00  94853000000.00        43573000000.00   \n",
       "2022-03-31    2338000000.00  97497000000.00        39112000000.00   \n",
       "2022-06-30    2338000000.00  97497000000.00        39112000000.00   \n",
       "2022-09-30    2338000000.00  97497000000.00        39112000000.00   \n",
       "2022-12-31    2338000000.00  97497000000.00        39112000000.00   \n",
       "2023-03-31    1997000000.00  94002000000.00        36717000000.00   \n",
       "2023-06-30    1997000000.00  94002000000.00        36717000000.00   \n",
       "2023-09-30    1997000000.00  94002000000.00        36717000000.00   \n",
       "2023-12-31    1997000000.00  94002000000.00        36717000000.00   \n",
       "2024-03-31    2085000000.00 101852000000.00        43348000000.00   \n",
       "2024-06-30    2085000000.00 101852000000.00        43348000000.00   \n",
       "2024-09-30    2085000000.00 101852000000.00        43348000000.00   \n",
       "\n",
       "            total current liabilities  total liabilities  \\\n",
       "2018-03-31             27583000000.00     63681000000.00   \n",
       "2018-06-30             27583000000.00     63681000000.00   \n",
       "2018-09-30             27583000000.00     63681000000.00   \n",
       "2018-12-31             27583000000.00     63681000000.00   \n",
       "2019-03-31             27035000000.00     65580000000.00   \n",
       "2019-06-30             27035000000.00     65580000000.00   \n",
       "2019-09-30             27035000000.00     65580000000.00   \n",
       "2019-12-31             27035000000.00     65580000000.00   \n",
       "2020-03-31             31712000000.00     64222000000.00   \n",
       "2020-06-30             31712000000.00     64222000000.00   \n",
       "2020-09-30             31712000000.00     64222000000.00   \n",
       "2020-12-31             31712000000.00     64222000000.00   \n",
       "2021-03-31             25331000000.00     56933000000.00   \n",
       "2021-06-30             25331000000.00     56933000000.00   \n",
       "2021-09-30             25331000000.00     56933000000.00   \n",
       "2021-12-31             25331000000.00     56933000000.00   \n",
       "2022-03-31             26257000000.00     56222000000.00   \n",
       "2022-06-30             26257000000.00     56222000000.00   \n",
       "2022-09-30             26257000000.00     56222000000.00   \n",
       "2022-12-31             26257000000.00     56222000000.00   \n",
       "2023-03-31             25640000000.00     54229000000.00   \n",
       "2023-06-30             25640000000.00     54229000000.00   \n",
       "2023-09-30             25640000000.00     54229000000.00   \n",
       "2023-12-31             25640000000.00     54229000000.00   \n",
       "2024-03-31             31309000000.00     57499000000.00   \n",
       "2024-06-30             31309000000.00     57499000000.00   \n",
       "2024-09-30             31309000000.00     57499000000.00   \n",
       "\n",
       "            total liabilities and equity  total non operating expenses  \\\n",
       "2018-03-31               129818000000.00                  206000000.00   \n",
       "2018-06-30               129818000000.00                  146000000.00   \n",
       "2018-09-30               129818000000.00                  168000000.00   \n",
       "2018-12-31               129818000000.00                  168000000.00   \n",
       "2019-03-31               108784000000.00                  104000000.00   \n",
       "2019-06-30               108784000000.00                  365000000.00   \n",
       "2019-09-30               108784000000.00                  484000000.00   \n",
       "2019-12-31               108784000000.00                  484000000.00   \n",
       "2020-03-31                97793000000.00                  107000000.00   \n",
       "2020-06-30                97793000000.00                  236000000.00   \n",
       "2020-09-30                97793000000.00                  338000000.00   \n",
       "2020-12-31                97793000000.00                  338000000.00   \n",
       "2021-03-31                94853000000.00                  111000000.00   \n",
       "2021-06-30                94853000000.00                  261000000.00   \n",
       "2021-09-30                94853000000.00                  291000000.00   \n",
       "2021-12-31                94853000000.00                  291000000.00   \n",
       "2022-03-31                97497000000.00                  219000000.00   \n",
       "2022-06-30                97497000000.00                  143000000.00   \n",
       "2022-09-30                97497000000.00                  269000000.00   \n",
       "2022-12-31                97497000000.00                  269000000.00   \n",
       "2023-03-31                94002000000.00                  -65000000.00   \n",
       "2023-06-30                94002000000.00                  335000000.00   \n",
       "2023-09-30                94002000000.00                  526000000.00   \n",
       "2023-12-31                94002000000.00                  526000000.00   \n",
       "2024-03-31               101852000000.00                  526000000.00   \n",
       "2024-06-30               101852000000.00                   58000000.00   \n",
       "2024-09-30               101852000000.00                   69000000.00   \n",
       "\n",
       "            total operating expenses  total revenues  \\\n",
       "2018-03-31             4671000000.00  23932000000.00   \n",
       "2018-06-30             9390000000.00  23932000000.00   \n",
       "2018-09-30            13739000000.00  35872000000.00   \n",
       "2018-12-31            13739000000.00  35872000000.00   \n",
       "2019-03-31             4341000000.00  35872000000.00   \n",
       "2019-06-30             9096000000.00  35872000000.00   \n",
       "2019-09-30            13721000000.00  35872000000.00   \n",
       "2019-12-31            13721000000.00  35872000000.00   \n",
       "2020-03-31             4885000000.00  35872000000.00   \n",
       "2020-06-30             8903000000.00  35872000000.00   \n",
       "2020-09-30            13563000000.00  35872000000.00   \n",
       "2020-12-31            13563000000.00  35872000000.00   \n",
       "2021-03-31             5011000000.00  35872000000.00   \n",
       "2021-06-30             9269000000.00  35872000000.00   \n",
       "2021-09-30            13626000000.00  35872000000.00   \n",
       "2021-12-31            13626000000.00  35872000000.00   \n",
       "2022-03-31             4615000000.00  35872000000.00   \n",
       "2022-06-30             9572000000.00  35872000000.00   \n",
       "2022-09-30            14292000000.00  35872000000.00   \n",
       "2022-12-31            14292000000.00  35872000000.00   \n",
       "2023-03-31             4806000000.00  35872000000.00   \n",
       "2023-06-30             9177000000.00  35872000000.00   \n",
       "2023-09-30            13688000000.00  35872000000.00   \n",
       "2023-12-31            13688000000.00  35872000000.00   \n",
       "2024-03-31            13688000000.00  35872000000.00   \n",
       "2024-06-30             9941000000.00  35872000000.00   \n",
       "2024-09-30            15227000000.00  35872000000.00   \n",
       "\n",
       "            total shareholders equity  share_price  \\\n",
       "2018-03-31             66137000000.00        43.03   \n",
       "2018-06-30             66137000000.00        43.03   \n",
       "2018-09-30             66137000000.00        48.65   \n",
       "2018-12-31             66137000000.00        43.33   \n",
       "2019-03-31             43204000000.00        53.99   \n",
       "2019-06-30             43204000000.00        54.73   \n",
       "2019-09-30             43204000000.00        49.41   \n",
       "2019-12-31             43204000000.00        47.96   \n",
       "2020-03-31             33571000000.00        39.31   \n",
       "2020-06-30             33571000000.00        46.64   \n",
       "2020-09-30             43204000000.00        39.39   \n",
       "2020-12-31             43204000000.00        44.75   \n",
       "2021-03-31             33571000000.00        51.71   \n",
       "2021-06-30             33571000000.00        53.00   \n",
       "2021-09-30             33571000000.00        54.43   \n",
       "2021-12-31             33571000000.00        63.37   \n",
       "2022-03-31             37920000000.00        55.76   \n",
       "2022-06-30             37920000000.00        42.64   \n",
       "2022-09-30             37920000000.00        40.00   \n",
       "2022-12-31             37920000000.00        47.64   \n",
       "2023-03-31             41275000000.00        52.28   \n",
       "2023-06-30             41275000000.00        51.74   \n",
       "2023-09-30             41275000000.00        53.76   \n",
       "2023-12-31             41275000000.00        50.52   \n",
       "2024-03-31             39773000000.00        49.91   \n",
       "2024-06-30             39773000000.00        47.29   \n",
       "2024-09-30             39773000000.00        47.29   \n",
       "\n",
       "            accrued expenses and other  bond_yield  eps growth rate  \\\n",
       "2018-03-31                           0        0.00             0.00   \n",
       "2018-06-30                           0        0.00             1.00   \n",
       "2018-09-30                           0        0.00             0.54   \n",
       "2018-12-31                           0        0.00             0.00   \n",
       "2019-03-31                           0        0.02            -0.66   \n",
       "2019-06-30                           0        0.02            -3.69   \n",
       "2019-09-30                           0        0.02            -0.41   \n",
       "2019-12-31                           0        0.02             0.00   \n",
       "2020-03-31                           0        0.00            -2.01   \n",
       "2020-06-30                           0        0.00             0.82   \n",
       "2020-09-30                           0        0.00             0.49   \n",
       "2020-12-31                           0        0.00             0.00   \n",
       "2021-03-31                           0        0.00            -0.76   \n",
       "2021-06-30                           0        0.00             1.67   \n",
       "2021-09-30                           0        0.00             0.48   \n",
       "2021-12-31                           0        0.00             0.00   \n",
       "2022-03-31                           0        0.00            -0.65   \n",
       "2022-06-30                           0        0.02             0.59   \n",
       "2022-09-30                           0        0.03             0.61   \n",
       "2022-12-31                           0        0.04             0.00   \n",
       "2023-03-31                           0        0.05            -0.64   \n",
       "2023-06-30                           0        0.05             1.17   \n",
       "2023-09-30                           0        0.05             0.52   \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.38   \n",
       "2024-09-30                           0        0.05             0.60   \n",
       "\n",
       "            intrinsic value  margin safety  current ratio  net current assets  \\\n",
       "2018-03-31             0.00           0.00           3.03      56120000000.00   \n",
       "2018-06-30             0.00           0.00           3.03      56120000000.00   \n",
       "2018-09-30             0.00           0.00           3.03      56120000000.00   \n",
       "2018-12-31             0.00           0.00           3.03      56120000000.00   \n",
       "2019-03-31           651.02           0.92           2.29      34802000000.00   \n",
       "2019-06-30          -313.78           1.17           2.29      34802000000.00   \n",
       "2019-09-30         -1450.63           1.03           2.29      34802000000.00   \n",
       "2019-12-31         -1888.64           1.03           2.29      34802000000.00   \n",
       "2020-03-31         50522.81           1.00           1.51      16043000000.00   \n",
       "2020-06-30         46251.85           1.00           1.51      16043000000.00   \n",
       "2020-09-30        102624.27           1.00           1.51      16043000000.00   \n",
       "2020-12-31        120255.39           1.00           1.51      16043000000.00   \n",
       "2021-03-31        120624.29           1.00           1.72      18242000000.00   \n",
       "2021-06-30        177026.67           1.00           1.72      18242000000.00   \n",
       "2021-09-30        298670.79           1.00           1.72      18242000000.00   \n",
       "2021-12-31        227800.00           1.00           1.72      18242000000.00   \n",
       "2022-03-31          4496.00           0.99           1.49      12855000000.00   \n",
       "2022-06-30          2952.20           0.99           1.49      12855000000.00   \n",
       "2022-09-30          2408.68           0.98           1.49      12855000000.00   \n",
       "2022-12-31          1571.50           0.97           1.49      12855000000.00   \n",
       "2023-03-31           450.75           0.88           1.43      11077000000.00   \n",
       "2023-06-30          1304.91           0.96           1.43      11077000000.00   \n",
       "2023-09-30          1694.07           0.97           1.43      11077000000.00   \n",
       "2023-12-31          1545.10           0.97           1.43      11077000000.00   \n",
       "2024-03-31          1538.27           0.97           1.38      12039000000.00   \n",
       "2024-06-30           863.29           0.95           1.38      12039000000.00   \n",
       "2024-09-30          1730.28           0.97           1.38      12039000000.00   \n",
       "\n",
       "            pe ratio  bvps  pb ratio  multiplier pb     total debt  tbvps  \\\n",
       "2018-03-31     93.54 13.27      3.24         303.27 63681000000.00   0.67   \n",
       "2018-06-30     46.77 13.27      3.24         151.64 63681000000.00   0.67   \n",
       "2018-09-30     34.26 13.27      3.67         125.58 63681000000.00   0.67   \n",
       "2018-12-31     30.51 13.27      3.26          99.62 63681000000.00   0.67   \n",
       "2019-03-31    112.48  9.36      5.77         648.54 65580000000.00   0.65   \n",
       "2019-06-30    -42.43  9.36      5.84        -247.98 65580000000.00   0.65   \n",
       "2019-09-30    -65.01  9.36      5.28        -343.06 65580000000.00   0.65   \n",
       "2019-12-31    -63.11  9.36      5.12        -323.22 65580000000.00   0.65   \n",
       "2020-03-31     51.05  7.90      4.98         254.06 64222000000.00   0.66   \n",
       "2020-06-30     33.31  7.90      5.90         196.70 64222000000.00   0.66   \n",
       "2020-09-30     18.85 10.17      3.87          73.03 54589000000.00   0.66   \n",
       "2020-12-31     21.41 10.17      4.40          94.26 54589000000.00   0.66   \n",
       "2021-03-31    101.39  7.92      6.53         661.72 61282000000.00   0.58   \n",
       "2021-06-30     38.97  7.92      6.69         260.68 61282000000.00   0.58   \n",
       "2021-09-30     27.08  7.92      6.87         186.03 61282000000.00   0.58   \n",
       "2021-12-31     31.53  7.92      8.00         252.15 61282000000.00   0.58   \n",
       "2022-03-31     79.66  8.99      6.20         493.95 59577000000.00   0.55   \n",
       "2022-06-30     38.41  8.99      4.74         182.16 59577000000.00   0.55   \n",
       "2022-09-30     22.35  8.99      4.45          99.40 59577000000.00   0.55   \n",
       "2022-12-31     26.61  8.99      5.30         141.00 59577000000.00   0.55   \n",
       "2023-03-31     80.43 10.04      5.21         418.71 52727000000.00   0.49   \n",
       "2023-06-30     36.70 10.04      5.15         189.06 52727000000.00   0.49   \n",
       "2023-09-30     25.12 10.04      5.35         134.48 52727000000.00   0.49   \n",
       "2023-12-31     23.61 10.04      5.03         118.76 52727000000.00   0.49   \n",
       "2024-03-31     23.32  9.78      5.10         119.00 62079000000.00   0.51   \n",
       "2024-06-30     35.83  9.78      4.83         173.20 62079000000.00   0.51   \n",
       "2024-09-30     22.41  9.78      4.83         108.35 62079000000.00   0.51   \n",
       "\n",
       "            ncav  \n",
       "2018-03-31  4.02  \n",
       "2018-06-30  4.02  \n",
       "2018-09-30  4.02  \n",
       "2018-12-31  4.02  \n",
       "2019-03-31 -0.81  \n",
       "2019-06-30 -0.81  \n",
       "2019-09-30 -0.81  \n",
       "2019-12-31 -0.81  \n",
       "2020-03-31 -3.87  \n",
       "2020-06-30 -3.87  \n",
       "2020-09-30 -1.61  \n",
       "2020-12-31 -1.61  \n",
       "2021-03-31 -4.18  \n",
       "2021-06-30 -4.18  \n",
       "2021-09-30 -4.18  \n",
       "2021-12-31 -4.18  \n",
       "2022-03-31 -4.85  \n",
       "2022-06-30 -4.85  \n",
       "2022-09-30 -4.85  \n",
       "2022-12-31 -4.85  \n",
       "2023-03-31 -3.90  \n",
       "2023-06-30 -3.90  \n",
       "2023-09-30 -3.90  \n",
       "2023-12-31 -3.90  \n",
       "2024-03-31 -4.61  \n",
       "2024-06-30 -4.61  \n",
       "2024-09-30 -4.61  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "user_cik = input(\"Enter the CIK: \")\n",
    "show_ticker_from_cik(user_cik, api_df=facts_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "ac466944",
   "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>1767</th>\n",
       "      <td>AMPE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1768</th>\n",
       "      <td>SMIT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1769</th>\n",
       "      <td>XDSL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1770</th>\n",
       "      <td>BABL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1771</th>\n",
       "      <td>LIANY</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1772 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",
       "1767             AMPE\n",
       "1768             SMIT\n",
       "1769             XDSL\n",
       "1770             BABL\n",
       "1771            LIANY\n",
       "\n",
       "[1772 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>913</th>\n",
       "      <td>MACT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>914</th>\n",
       "      <td>MDNC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>915</th>\n",
       "      <td>CEAI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>916</th>\n",
       "      <td>WLLBW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>917</th>\n",
       "      <td>QTZM</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>918 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",
       "913                MACT\n",
       "914                MDNC\n",
       "915                CEAI\n",
       "916               WLLBW\n",
       "917                QTZM\n",
       "\n",
       "[918 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>CKPT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>IOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>OWLT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ASRE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>MOBQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>MTEM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>VVOS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>MRZM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>MARK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>WAVD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>CING</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>LGIQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>OPGN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>AVGR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>EBET</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>BACK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>STAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>ELOX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>FUVV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>ABQQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>RIBT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>EDGM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>SHRG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>BRGO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>MCCX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>BBBT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>XFCI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>ASAPQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>HGENQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>CHEV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>ADXS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>FXLV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>BLPH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>BTTX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>COMS</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   NCAV Assets\n",
       "0          WGS\n",
       "1         CKPT\n",
       "2          IOR\n",
       "3         OWLT\n",
       "4         ASRE\n",
       "5         MOBQ\n",
       "6         MTEM\n",
       "7         VVOS\n",
       "8         MRZM\n",
       "9         MARK\n",
       "10        WAVD\n",
       "11        CING\n",
       "12        LGIQ\n",
       "13        OPGN\n",
       "14        AVGR\n",
       "15        EBET\n",
       "16        BACK\n",
       "17        STAL\n",
       "18        ELOX\n",
       "19        FUVV\n",
       "20        ABQQ\n",
       "21        RIBT\n",
       "22        EDGM\n",
       "23        SHRG\n",
       "24        BRGO\n",
       "25        MCCX\n",
       "26        BBBT\n",
       "27        XFCI\n",
       "28       ASAPQ\n",
       "29       HGENQ\n",
       "30        CHEV\n",
       "31        ADXS\n",
       "32        FXLV\n",
       "33        BLPH\n",
       "34        BTTX\n",
       "35        COMS"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "defensive_facts, enterprising_facts, ncav_facts = classify_multiple_ciks(facts_df.keys(), 'facts', api_df=facts_df)\n",
    "\n",
    "display(defensive_facts)\n",
    "display(enterprising_facts)\n",
    "display(ncav_facts)"
   ]
  }
 ],
 "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
}