StockFundamentals_Scraper.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-19-ff73683528d1>:97: RuntimeWarning: divide by zero encountered in true_divide\n",
      "  NPM = NP/sales*100\n",
      "<ipython-input-19-ff73683528d1>:97: RuntimeWarning: invalid value encountered in true_divide\n",
      "  NPM = NP/sales*100\n",
      "<ipython-input-19-ff73683528d1>:127: RuntimeWarning: invalid value encountered in true_divide\n",
      "  Reinv_rate = AssetPur/ CFoperating * 100\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-19-ff73683528d1>:97: RuntimeWarning: divide by zero encountered in true_divide\n",
      "  NPM = NP/sales*100\n",
      "<ipython-input-19-ff73683528d1>:97: RuntimeWarning: invalid value encountered in true_divide\n",
      "  NPM = NP/sales*100\n",
      "<ipython-input-19-ff73683528d1>:127: RuntimeWarning: divide by zero encountered in true_divide\n",
      "  Reinv_rate = AssetPur/ CFoperating * 100\n",
      "<ipython-input-19-ff73683528d1>:127: RuntimeWarning: invalid value encountered in true_divide\n",
      "  Reinv_rate = AssetPur/ CFoperating * 100\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "3\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-19-ff73683528d1>:127: RuntimeWarning: divide by zero encountered in true_divide\n",
      "  Reinv_rate = AssetPur/ CFoperating * 100\n",
      "<ipython-input-19-ff73683528d1>:97: RuntimeWarning: invalid value encountered in true_divide\n",
      "  NPM = NP/sales*100\n"
     ]
    },
    {
     "ename": "WebDriverException",
     "evalue": "Message: chrome not reachable\n  (Session info: chrome=83.0.4103.116)\n",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mWebDriverException\u001b[0m                        Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-19-ff73683528d1>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m    122\u001b[0m         \u001b[0mAssetSold\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mcss2np\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mAssetSold_css\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0myears\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    123\u001b[0m         \u001b[0mtime\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msleep\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;36m0.5\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 124\u001b[0;31m         \u001b[0mdr\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mfind_element_by_css_selector\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'#cash-flow > div.responsive-holder.fill-card-width > table > tbody > tr.stripe.highlight.strong > td.text > button'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mclick\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    125\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    126\u001b[0m         \u001b[0;31m# Reinvestment into bussiness\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/miniconda3/envs/AutoScrape/lib/python3.8/site-packages/selenium/webdriver/remote/webdriver.py\u001b[0m in \u001b[0;36mfind_element_by_css_selector\u001b[0;34m(self, css_selector)\u001b[0m\n\u001b[1;32m    596\u001b[0m             \u001b[0melement\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mdriver\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mfind_element_by_css_selector\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'#foo'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    597\u001b[0m         \"\"\"\n\u001b[0;32m--> 598\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mfind_element\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mby\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mBy\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mCSS_SELECTOR\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mcss_selector\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    599\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    600\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mfind_elements_by_css_selector\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mcss_selector\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/miniconda3/envs/AutoScrape/lib/python3.8/site-packages/selenium/webdriver/remote/webdriver.py\u001b[0m in \u001b[0;36mfind_element\u001b[0;34m(self, by, value)\u001b[0m\n\u001b[1;32m    974\u001b[0m                 \u001b[0mby\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mBy\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mCSS_SELECTOR\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    975\u001b[0m                 \u001b[0mvalue\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m'[name=\"%s\"]'\u001b[0m \u001b[0;34m%\u001b[0m \u001b[0mvalue\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 976\u001b[0;31m         return self.execute(Command.FIND_ELEMENT, {\n\u001b[0m\u001b[1;32m    977\u001b[0m             \u001b[0;34m'using'\u001b[0m\u001b[0;34m:\u001b[0m \u001b[0mby\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    978\u001b[0m             'value': value})['value']\n",
      "\u001b[0;32m~/miniconda3/envs/AutoScrape/lib/python3.8/site-packages/selenium/webdriver/remote/webdriver.py\u001b[0m in \u001b[0;36mexecute\u001b[0;34m(self, driver_command, params)\u001b[0m\n\u001b[1;32m    319\u001b[0m         \u001b[0mresponse\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcommand_executor\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mexecute\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdriver_command\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mparams\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    320\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mresponse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 321\u001b[0;31m             \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0merror_handler\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcheck_response\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mresponse\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    322\u001b[0m             response['value'] = self._unwrap_value(\n\u001b[1;32m    323\u001b[0m                 response.get('value', None))\n",
      "\u001b[0;32m~/miniconda3/envs/AutoScrape/lib/python3.8/site-packages/selenium/webdriver/remote/errorhandler.py\u001b[0m in \u001b[0;36mcheck_response\u001b[0;34m(self, response)\u001b[0m\n\u001b[1;32m    240\u001b[0m                 \u001b[0malert_text\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mvalue\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'alert'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'text'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    241\u001b[0m             \u001b[0;32mraise\u001b[0m \u001b[0mexception_class\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mmessage\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mscreen\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mstacktrace\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0malert_text\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 242\u001b[0;31m         \u001b[0;32mraise\u001b[0m \u001b[0mexception_class\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mmessage\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mscreen\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mstacktrace\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    243\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    244\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m_value_or_default\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mobj\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkey\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mdefault\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mWebDriverException\u001b[0m: Message: chrome not reachable\n  (Session info: chrome=83.0.4103.116)\n"
     ]
    }
   ],
   "source": [
    "# plotting Trends\n",
    "import re, os\n",
    "from dotenv import load_dotenv\n",
    "import numpy as np\n",
    "from numpy import inf\n",
    "import matplotlib\n",
    "matplotlib.use('Agg')\n",
    "import matplotlib.pyplot as plt\n",
    "from selenium import webdriver\n",
    "#from selenium.webdriver.chrome.options import Options\n",
    "from webdriver_manager.chrome import ChromeDriverManager\n",
    "from bs4 import BeautifulSoup as bs\n",
    "import pandas as pd\n",
    "import time\n",
    "import seaborn as sns\n",
    "sns.set() # setting seaborn default for plots\n",
    "from pdb import set_trace\n",
    "\n",
    "\n",
    "load_dotenv()\n",
    "\n",
    "dr = webdriver.Chrome(\"/usr/lib/chromium-browser/chromedriver\") #chrome_options=chrome_options)\n",
    "dr.get(\"https://www.screener.in/login/\")\n",
    "\n",
    "username = dr.find_element_by_id(\"id_username\")\n",
    "username.clear()\n",
    "username.send_keys(os.environ.get('SCRUSER'))\n",
    "\n",
    "password = dr.find_element_by_id(\"id_password\")\n",
    "password.clear()\n",
    "password.send_keys(os.environ.get('SCRPASSWORD'))\n",
    "\n",
    "dr.find_element_by_css_selector('body > main > div > div > div:nth-child(2) > form > button').click()\n",
    "i=1\n",
    "\n",
    "\n",
    "matplotlib.rc('xtick', labelsize=15)\n",
    "matplotlib.rc('ytick', labelsize=15)\n",
    "\n",
    "def css2np(css,years):\n",
    "    ls = []\n",
    "    for i in range(2,len(years)+2):\n",
    "        ls.append(dr.find_element_by_css_selector(css+' > td:nth-child('+str(i)+')').text.replace('%','').replace(',',''))\n",
    "    return pd.to_numeric(np.array(ls), errors='coerce')\n",
    "\n",
    "\n",
    "#### for loop\n",
    "\n",
    "dr.get(\n",
    "    'https://www.screener.in/screen/raw/?sort=&order=&source=&query=Market+Capitalization%3E0'\n",
    ")   # filtered or screened link from screener \n",
    "lastpage = int(\n",
    "    dr.find_element_by_css_selector(\n",
    "        'body > main > div > div.card.card-large > div.flex-row.flex-gap-8.flex-space-between.flex-align-center > div.sub').text.split(' ')[-1])\n",
    "\n",
    "for i in list(range(1,4)):  #lastpage+1\n",
    "    print(i)\n",
    "    url = f'https://www.screener.in/screen/raw/?sort=&source=&page={i}&query=Market+Capitalization>0'\n",
    "    dr.get(url)\n",
    "    time.sleep(1)\n",
    "    html = dr.page_source\n",
    "    soup = bs(html)\n",
    "    pageLinks = list(\n",
    "        map(lambda x: x.get('href'),\n",
    "            soup.findAll('a', attrs={'href': re.compile(\"/company/\")}))) \n",
    "    \n",
    "    for j in pageLinks[:3]: #[pageLinks.index(j):]\n",
    "        # Stock url\n",
    "        #j=pageLinks[1]\n",
    "        stockUrl = 'https://www.screener.in' + j\n",
    "        dr.get(stockUrl)\n",
    "        time.sleep(2)\n",
    "        scrnid = dr.find_element_by_css_selector('#company-info').get_attribute('data-company-id')\n",
    "        \n",
    "        years = np.asarray([\n",
    "                    x for x in dr.find_element_by_css_selector(\n",
    "                        '#profit-loss > div.responsive-holder > table > thead').text.\n",
    "                    split(' ') if '20' in x\n",
    "                ]).astype(int)\n",
    "        \n",
    "        Sector = dr.find_element_by_css_selector('#peers > div.flex.flex-space-between > div:nth-child(1) > p > a:nth-child(1)').text.replace('\\n', \"\")\n",
    "        \n",
    "        ####-------------Fundamentals\n",
    "        # SalesGrowth ratio\n",
    "        salesCss = '#profit-loss > div.responsive-holder > table > tbody > tr:nth-child(1)'\n",
    "        sales = css2np(salesCss,years)\n",
    "        dr.find_element_by_css_selector('#profit-loss > div.responsive-holder.fill-card-width > table > tbody > tr:nth-child(1) > td.text > button').click()        \n",
    "        \n",
    "        SalesGcss = '#profit-loss > div.responsive-holder > table > tbody > tr:nth-child(2)'\n",
    "        SalesG = css2np(SalesGcss,years)\n",
    "        time.sleep(0.5)\n",
    "        dr.find_element_by_css_selector('#profit-loss > div.responsive-holder.fill-card-width > table > tbody > tr:nth-child(1) > td.text > button').click()        \n",
    "        \n",
    "        # Operating Profit margin\n",
    "        OPMcss = '#profit-loss > div.responsive-holder > table > tbody > tr:nth-child(4)'\n",
    "        OPM = css2np(OPMcss,years)\n",
    "        \n",
    "        # Net Profit Margin\n",
    "        NPMcss = '#profit-loss > div.responsive-holder > table > tbody > tr:nth-child(10)'\n",
    "        NP = css2np(NPMcss,years)\n",
    "        NPM = NP/sales*100\n",
    "        NPM[NPM == -inf] = np.nan\n",
    "        \n",
    "        #Earnings Per Share\n",
    "        EPScss = '#profit-loss > div.responsive-holder > table > tbody > tr:nth-child(11)'\n",
    "        EPS = css2np(EPScss,years)\n",
    "        \n",
    "        #Debt\n",
    "        Debtcss = '#balance-sheet > div > table > tbody > tr:nth-child(3)'\n",
    "        Debt = css2np(Debtcss,years)\n",
    "        \n",
    "        # ROCE \n",
    "        ROCEcss = '#ratios > div > table > tbody > tr:nth-child(1)'\n",
    "        ROCE = css2np(ROCEcss,years)\n",
    "        \n",
    "        #Operating and Investing CashFlows\n",
    "        CFoperating_css = '#cash-flow > div > table > tbody > tr:nth-child(1)'\n",
    "        CFoperating = css2np(CFoperating_css,years)\n",
    "        \n",
    "        \n",
    "        # Assets purchased \n",
    "        dr.find_element_by_css_selector('#cash-flow > div.responsive-holder.fill-card-width > table > tbody > tr:nth-child(1) > td.text > button').click()\n",
    "        AssetPur_css = '#cash-flow > div > table > tbody > tr:nth-child(3)'\n",
    "        AssetPur = css2np(AssetPur_css,years)*-1\n",
    "        AssetSold_css = '#cash-flow > div > table > tbody > tr:nth-child(4)'\n",
    "        AssetSold = css2np(AssetSold_css,years)\n",
    "        time.sleep(0.5)\n",
    "        dr.find_element_by_css_selector('#cash-flow > div.responsive-holder.fill-card-width > table > tbody > tr.stripe.highlight.strong > td.text > button').click()\n",
    "        \n",
    "        # Reinvestment into bussiness\n",
    "        Reinv_rate = AssetPur/ CFoperating * 100\n",
    "        Reinv_rate[Reinv_rate<0] = 0\n",
    "        \n",
    "        # Free CashFlows\n",
    "        FreeCashFlows = CFoperating-AssetPur+AssetSold\n",
    "        \n",
    "        #--------Fundamentals\n",
    "        \n",
    "        company = dr.find_element_by_css_selector(\n",
    "            '#top > div.flex-row.flex-space-between.flex-gap-8 > h1').text.replace(' ', '_')\n",
    "        Sector = dr.find_element_by_css_selector(\n",
    "            '#peers > div.flex.flex-space-between > div:nth-child(1) > p').text.replace(' Industry:', \"* Industry:\").split('*')\n",
    "        MarCap = dr.find_element_by_css_selector(\n",
    "            '#top-ratios > li:nth-child(1)').text.replace(\"\\n\",\" \")\n",
    "        year = years[0] - 1 if len(years) > 0 else 'NA'\n",
    "        \n",
    "        # a = dr.find_element_by_css_selector(\n",
    "        #     '#top > div.company-info > div.company-ratios').text.split('\\n')\n",
    "        #PC = [x for x in a if 'Price to Free Cash Flow:' in x][0]\n",
    "        \n",
    "        # Plotting Trends\n",
    "        plt.style.use('ggplot')\n",
    "        fig, ax = plt.subplots(nrows=3, ncols=3,sharex=True)  #sharex=True\n",
    "        fig.set_size_inches((30, 20))\n",
    "        #fig.suptitle(\"Trends for \"+company, fontsize=18)\n",
    "        \n",
    "        txt = company + '\\n\\n    ' + Sector[0] + '    ' + Sector[\n",
    "            1] + '    ' + MarCap + '    ' + 'Start Year: ' + str(year)\n",
    "\n",
    "        fig.suptitle(txt, fontsize=18)\n",
    "        \n",
    "        # -------- Row 1\n",
    "        \n",
    "        # Sales Growth\n",
    "        ax[0, 0].plot(years,SalesG, color='green')\n",
    "        ax[0, 0].set_title('Sales growth %', fontsize=16)\n",
    "        ax[0, 0].set_ylim(bottom=-20)\n",
    "            \n",
    "        # Operating profit margin\n",
    "        ax[0, 1].plot( years,OPM, color='green')\n",
    "        ax[0, 1].set_title('Operating Profit Margin in %', fontsize=16)\n",
    "        ax[0, 1].set_ylim(bottom=-20)\n",
    "               \n",
    "        # Net- Profit Growth\n",
    "        ax[0, 2].plot(years,NPM, color='green')\n",
    "        ax[0, 2].set_title('Net profit growth %', fontsize=16)\n",
    "        ax[0, 2].set_ylim(bottom=-20)\n",
    "                \n",
    "        \n",
    "        # -------- Row 2\n",
    "        \n",
    "        # Asset Purchased\n",
    "        ax[1, 0].plot(years, AssetPur, color='green')\n",
    "        ax[1, 0].set_title('Asset Purchased in cr', fontsize=16)\n",
    "        ax[1, 0].set_ylim(bottom=-20)        \n",
    "        \n",
    "        # Reinvestment rate\n",
    "        ax[1, 1].plot(years, Reinv_rate, color='green') #dic2array(Asset_pur.keys())\n",
    "        ax[1, 1].set_title('Reinvestment into Business in %', fontsize=16)\n",
    "        ax[1, 1].set_ylim(bottom=0)\n",
    "        \n",
    "        \n",
    "        # Return on capital invested\n",
    "        ax[1, 2].plot(years, ROCE, color='green') #years,\n",
    "        ax[1, 2].set_title('Return on Cap Employed in %', fontsize=16)\n",
    "        ax[1, 2].set_ylim(bottom=-20)\n",
    "            \n",
    "        # -------- Row 3\n",
    "        \n",
    "        # Free Cash Flows\n",
    "        ax[2, 0].plot(years,FreeCashFlows , color='green')\n",
    "        ax[2, 0].set_title('Free Cash Flows', fontsize=16)\n",
    "        ax[2, 0].set_ylim(bottom=-20)\n",
    "        #ax[2, 0].set_ylim(-20,np.max(FreeCashFlows))\n",
    "        \n",
    "        # Debt\n",
    "        ax[2, 1].plot(years, Debt, color='red')\n",
    "        ax[2, 1].set_title('Debt in Cr', fontsize=16)\n",
    "        \n",
    "        \n",
    "        # Earnings Per Sahre\n",
    "        ax[2, 2].plot(years, EPS, color='green')\n",
    "        ax[2, 2].set_title('EPS', fontsize=16)\n",
    "        ax[2, 2].set_ylim(bottom=-20)\n",
    "        #ax[2, 2].set_ylim(-20,np.max(EPS))\n",
    "        \n",
    "        plt.xticks(fontsize=12)\n",
    "        plt.subplots_adjust(top=0.91)\n",
    "        #plt.text(1, 1, txt, fontsize=16,transform=ax[1].transAxes)\n",
    "        sec = Sector[0].replace('/', '~').split(':')[1].strip().replace(' ', '')\n",
    "        plt.savefig('./TrendPlots/' + sec + '_' + company + '.png',\n",
    "                    pad_inches=0.1,bbox_inches=\"tight\")\n",
    "        plt.close(fig)\n",
    "\n",
    "dr.find_element_by_css_selector('#nav-user-menu > form > button').click()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "dr.find_element_by_css_selector('#profit-loss > div.responsive-holder.fill-card-width > table > tbody > tr:nth-child(1) > td.text > button').click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "AutoScrape",
   "language": "python",
   "name": "autoscrape"
  },
  "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.8.5"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}