yf_stock_screener.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "452af008-36b6-411f-8559-0b9330e9e3b3",
   "metadata": {},
   "source": [
    "## Imports"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "a4d98827-4e53-4236-bac3-b1473204a182",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Read stocks\n",
    "import yfinance as yf\n",
    "\n",
    "# For DataFrame\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "# For parsing finviz\n",
    "import requests\n",
    "from bs4 import BeautifulSoup\n",
    "\n",
    "# to calculate std and mean\n",
    "import statistics"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fe1e082e-6bd9-49a5-a229-5f43c215e0e8",
   "metadata": {},
   "source": [
    "## Ratio Categories"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "f9cdf99d-1774-4bf7-84b5-7fe22288ce0f",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Scores for Catgeory 1 ratios - lower the better\n",
    "CAT1_RATIOS = ['D2E', 'PEG', 'PE fwd', 'PB', 'Beta']\n",
    "\n",
    "# Scores for Catgeory 2 ratios - higher the better\n",
    "CAT2_RATIOS = ['ROCE', 'ROE', 'FCFY', 'CR', 'QR', 'Asset TR', 'EPS fwd']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4f4bff8d-2fe1-4d86-9da7-6d84f5460c38",
   "metadata": {},
   "source": [
    "## Stock Symbols"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "c186f2c7-ebf3-4da5-9629-d2c70475873d",
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_symbols():\n",
    "    req = requests.get('https://finviz.com/screener.ashx',\n",
    "        params={\n",
    "            'v': '111',\n",
    "            'f': 'cap_midover,ind_utilitiesregulatedgas',\n",
    "            'o': 'company',\n",
    "        },\n",
    "        headers={\n",
    "            'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36',\n",
    "        })\n",
    "    # Creating BeautifulSoup object\n",
    "    soup = BeautifulSoup(req.text, 'html.parser')\n",
    "    \n",
    "    # Table we are interested\n",
    "    table = soup.find('table', class_='styled-table-new is-rounded is-tabular-nums w-full screener_table')\n",
    "    # Array to collect symbols\n",
    "    symbols = []\n",
    "    for i, row in enumerate(table.find_all('tr')):\n",
    "        # Skip the header row\n",
    "        if i != 0:\n",
    "            # Loop through the row\n",
    "            for j, td in enumerate(row.find_all('td')):\n",
    "                # Symbol is in the second column\n",
    "                if j == 1:\n",
    "                    symbols.append(td.text.strip())\n",
    "                    break\n",
    "    return symbols"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1864d38d-a895-4f06-9504-592ab3163e9d",
   "metadata": {},
   "source": [
    "## Get Stock symbols"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "e1a6da8c-7867-48f9-a3db-c9b3cd419288",
   "metadata": {},
   "outputs": [],
   "source": [
    "symbols = get_symbols()\n",
    "# symbols = ['ATO', 'GOOG', 'CPK']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8321024a-51c5-4a89-95cf-03c04180de27",
   "metadata": {},
   "source": [
    "## Utility method to convert a number to human readable format\n",
    "#### https://stackoverflow.com/questions/579310/formatting-long-numbers-as-strings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "72078d5b-74dd-4dcd-8a5a-8f910635403f",
   "metadata": {},
   "outputs": [],
   "source": [
    "def human_format(num):\n",
    "    num = float('{:.3g}'.format(num))\n",
    "    magnitude = 0\n",
    "    while abs(num) >= 1000:\n",
    "        magnitude += 1\n",
    "        num /= 1000.0\n",
    "    return '{}{}'.format('{:f}'.format(num).rstrip('0.'), ['', 'K', 'M', 'B', 'T'][magnitude])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "87530791-1a15-4ef6-9def-f803bcb201d5",
   "metadata": {},
   "source": [
    "## Ratios using stock info"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "86f23ac9-5762-48cf-bc80-fcd541e13b84",
   "metadata": {},
   "outputs": [],
   "source": [
    "def populate_with_info(data, stock_info):\n",
    "    # print(stock_info)\n",
    "    data['Symbol'].append(stock_info['symbol'])\n",
    "    data['Name'].append(stock_info['longName'])\n",
    "    # Convert numbers to a human readable format\n",
    "    data['Market Cap'].append(human_format(stock_info['marketCap']))\n",
    "    data['Price'].append(stock_info['currentPrice'])\n",
    "\n",
    "    # Could be that some indicators are not available; use NaN if this is the case\n",
    "\n",
    "    # Valuation ratios\n",
    "    \n",
    "    if 'priceToBook' in stock_info:\n",
    "        data['PB'].append(stock_info['priceToBook'])\n",
    "    else:\n",
    "        data['PB'].append(np.nan)\n",
    "    \n",
    "    if 'forwardEps' in stock_info:\n",
    "        data['EPS fwd'].append(stock_info['forwardEps'])\n",
    "    else:\n",
    "        data['EPS fwd'].append(np.nan)\n",
    "        \n",
    "    if 'forwardPE' in stock_info:\n",
    "        data['PE fwd'].append(stock_info['forwardPE'])\n",
    "    else:\n",
    "        data['PE fwd'].append(np.nan)\n",
    "        \n",
    "    if 'pegRatio' in stock_info:\n",
    "        data['PEG'].append(stock_info['pegRatio'])\n",
    "    else:\n",
    "        data['PEG'].append(np.nan)\n",
    "        \n",
    "    # Solvency financial ratios\n",
    "\n",
    "    if 'debtToEquity' in stock_info:\n",
    "        data['D2E'].append(stock_info['debtToEquity'])\n",
    "    else:\n",
    "        data['D2E'].append(np.nan)\n",
    "\n",
    "    # Profitability Ratios\n",
    "    \n",
    "    if 'returnOnEquity' in stock_info:\n",
    "        data['ROE'].append(stock_info['returnOnEquity'])\n",
    "    else:\n",
    "        data['ROE'].append(np.nan)\n",
    "    \n",
    "    if ('freeCashflow' in stock_info) and ('marketCap' in stock_info):\n",
    "        fcfy = (stock_info['freeCashflow']/stock_info['marketCap']) * 100\n",
    "        data['FCFY'].append(round(fcfy, 2))\n",
    "    else:\n",
    "        data['FCFY'].append(np.nan)\n",
    "\n",
    "    # Liquidity ratios\n",
    "\n",
    "    if 'currentRatio' in stock_info:\n",
    "        data['CR'].append(stock_info['currentRatio'])\n",
    "    else:\n",
    "        data['CR'].append(np.nan)\n",
    "\n",
    "    if 'quickRatio' in stock_info:\n",
    "        data['QR'].append(stock_info['quickRatio'])\n",
    "    else:\n",
    "        data['CR'].append(np.nan)\n",
    "\n",
    "    # Other info (non ratios)\n",
    "    \n",
    "    if 'dividendYield' in stock_info:\n",
    "        data['DY'].append(stock_info['dividendYield']*100)\n",
    "    else:\n",
    "        data['DY'].append(0.0)\n",
    "\n",
    "    if 'beta' in stock_info:\n",
    "        data['Beta'].append(stock_info['beta'])\n",
    "    else:\n",
    "        data['Beta'].append(np.nan)\n",
    "\n",
    "    if 'fiftyTwoWeekLow' in stock_info:\n",
    "        data['52w Low'].append(stock_info['fiftyTwoWeekLow'])\n",
    "    else:\n",
    "        data['52w Low'].append(np.nan)\n",
    "        \n",
    "    if 'fiftyTwoWeekHigh' in stock_info:    \n",
    "        data['52w High'].append(stock_info['fiftyTwoWeekHigh'])\n",
    "    else:\n",
    "        data['52w High'].append(np.nan)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "96ce6987-5c90-4bec-8069-30f73a3349da",
   "metadata": {},
   "source": [
    "## Utility Ratio methods"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "e9b36d29-17a8-49a3-858b-776eeb3a14c6",
   "metadata": {},
   "outputs": [],
   "source": [
    "def roce(ticker):\n",
    "    income_stm = ticker.income_stmt\n",
    "    ebit = income_stm.loc['EBIT'].iloc[0]\n",
    "    bs = ticker.balance_sheet\n",
    "    return ebit/(bs.loc['Total Assets'].iloc[0]-bs.loc['Current Liabilities'].iloc[0])\n",
    "\n",
    "def asset_turnover_ratio(ticker):\n",
    "    df_bs = ticker.balance_sheet\n",
    "    y0, y1 = df_bs.loc['Total Assets'].iloc[0], df_bs.loc['Total Assets'].iloc[1]\n",
    "    avg_asset = (y0 + y1)/2\n",
    "    \n",
    "    tot_rvn_y0 = ticker.income_stmt.loc['Total Revenue'].iloc[0]/avg_asset\n",
    "\n",
    "    return tot_rvn_y0\n",
    "\n",
    "def investory_turnover_ratio(ticker):\n",
    "    df_bs = ticker.balance_sheet\n",
    "    y0, y1 = df_bs.loc['Inventory'].iloc[0], df_bs.loc['Inventory'].iloc[1]\n",
    "    avg_inventory = (y0 + y1)/2\n",
    "\n",
    "    return ticker.income_stmt.loc['Cost Of Revenue'].iloc[0]/avg_inventory"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0a70e60a-edda-4597-82c3-1376e91736bd",
   "metadata": {},
   "source": [
    "## Collect Ratios"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "291c65c0-b1a4-4717-aad3-b645547a080c",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Dictionary to collect data to create a DF later\n",
    "data = {\n",
    "    'Symbol': [],\n",
    "    'Name': [],\n",
    "    'Market Cap': [],\n",
    "    'EPS fwd': [],\n",
    "    'PE fwd': [],\n",
    "    'PEG': [],\n",
    "    'PB': [],\n",
    "    'ROE' : [],\n",
    "    'ROCE' : [],\n",
    "    'FCFY' : [],\n",
    "    'D2E' : [],\n",
    "    'CR' : [],\n",
    "    'QR' : [],\n",
    "    'Asset TR': [],\n",
    "    'DY' : [],\n",
    "    'Beta': [],\n",
    "    'Price': [],\n",
    "    '52w Low': [],\n",
    "    '52w High': []\n",
    "    }\n",
    "industry = ''\n",
    "\n",
    "for symbol in symbols:\n",
    "    ticker = yf.Ticker(symbol)\n",
    "    if not industry:\n",
    "        industry = ticker.info['industry']\n",
    "    else:\n",
    "        industry_current = ticker.info['industry'] \n",
    "        if industry_current != industry:\n",
    "            print(f'Encountred a different industry {industry_current}, previous {industry}. Quitting')\n",
    "            break        \n",
    "    populate_with_info(data, ticker.info)\n",
    "    data['ROCE'].append(roce(ticker))\n",
    "    data['Asset TR'].append(asset_turnover_ratio(ticker))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b54cae23-3a32-4127-8e65-9a7b471d623b",
   "metadata": {},
   "source": [
    "## Create DF"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "2f9b4cb6-4988-4058-bba6-774829e975c4",
   "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>Symbol</th>\n",
       "      <th>Name</th>\n",
       "      <th>Market Cap</th>\n",
       "      <th>EPS fwd</th>\n",
       "      <th>PE fwd</th>\n",
       "      <th>PEG</th>\n",
       "      <th>PB</th>\n",
       "      <th>ROE</th>\n",
       "      <th>ROCE</th>\n",
       "      <th>FCFY</th>\n",
       "      <th>D2E</th>\n",
       "      <th>CR</th>\n",
       "      <th>QR</th>\n",
       "      <th>Asset TR</th>\n",
       "      <th>DY</th>\n",
       "      <th>Beta</th>\n",
       "      <th>Price</th>\n",
       "      <th>52w Low</th>\n",
       "      <th>52w High</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BIPC</td>\n",
       "      <td>Brookfield Infrastructure Corporation</td>\n",
       "      <td>4.68B</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.96426</td>\n",
       "      <td>0.437331</td>\n",
       "      <td>-15.31</td>\n",
       "      <td>303.451</td>\n",
       "      <td>0.441</td>\n",
       "      <td>0.441</td>\n",
       "      <td>0.186143</td>\n",
       "      <td>4.31</td>\n",
       "      <td>1.392</td>\n",
       "      <td>35.50</td>\n",
       "      <td>25.48</td>\n",
       "      <td>48.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NJR</td>\n",
       "      <td>New Jersey Resources Corporation</td>\n",
       "      <td>4.1B</td>\n",
       "      <td>2.93</td>\n",
       "      <td>14.313992</td>\n",
       "      <td>2.51</td>\n",
       "      <td>2.055882</td>\n",
       "      <td>0.13904</td>\n",
       "      <td>0.075570</td>\n",
       "      <td>-2.34</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.660</td>\n",
       "      <td>0.132</td>\n",
       "      <td>0.306744</td>\n",
       "      <td>4.01</td>\n",
       "      <td>0.659</td>\n",
       "      <td>41.94</td>\n",
       "      <td>38.92</td>\n",
       "      <td>55.84</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Symbol                                   Name Market Cap  EPS fwd  \\\n",
       "1   BIPC  Brookfield Infrastructure Corporation      4.68B      NaN   \n",
       "4    NJR       New Jersey Resources Corporation       4.1B     2.93   \n",
       "\n",
       "      PE fwd   PEG        PB      ROE      ROCE   FCFY      D2E     CR     QR  \\\n",
       "1        NaN   NaN       NaN  0.96426  0.437331 -15.31  303.451  0.441  0.441   \n",
       "4  14.313992  2.51  2.055882  0.13904  0.075570  -2.34      NaN  0.660  0.132   \n",
       "\n",
       "   Asset TR    DY   Beta  Price  52w Low  52w High  \n",
       "1  0.186143  4.31  1.392  35.50    25.48     48.23  \n",
       "4  0.306744  4.01  0.659  41.94    38.92     55.84  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create a DF using the dictionary\n",
    "df = pd.DataFrame(data)\n",
    "\n",
    "# Save any stocks with NaN values\n",
    "df_exceptions = df[df.isna().any(axis=1)]\n",
    "\n",
    "# Remove any stocks with NaN values\n",
    "df=df.dropna()\n",
    "\n",
    "# Reset index after dropping rows with NaN values\n",
    "df.reset_index(drop=True, inplace=True)\n",
    "\n",
    "# Add 52 week price range\n",
    "df['52w Range'] = ((df['Price'] - df['52w Low'])/(df['52w High'] - df['52w Low']))*100\n",
    "\n",
    "df_exceptions"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7d9eb13a-6309-4be7-9101-65e9b0b51b88",
   "metadata": {},
   "source": [
    "## Score"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "b2c41045-0c5c-4e78-9802-31bc05a1fe7f",
   "metadata": {},
   "outputs": [],
   "source": [
    "def score(values, value, cat) -> int:\n",
    "    '''\n",
    "    Calculate the score using standard deviation and mean based on the category. A ratio such as PE which prefers a lower\n",
    "    value, the score is calculated the following way:\n",
    "    1. Score of 1 is returned if given PE is in between -1 std and mean\n",
    "    2. Score of 2 is returned if given PE is in between -2 std and -1 std\n",
    "    3. Score of 3 is returned if PE is outside -2 std\n",
    "    4. Score of -1 is returned if given PE is in between 1 std and mean\n",
    "    5. Score of -2 is returned if given PE is in between +1 std and +2 std\n",
    "    6. Score of -3 is given if given PE is outside +2 std\n",
    "\n",
    "    A ratio such as ROE which prefers a higher value, the score is calculated the following way:\n",
    "    1. Score of 1 is returned if given ROE is in between mean and +1 std\n",
    "    2. Score of 2 is returned if given ROE is in between +1 std and +2 std\n",
    "    3. Score of 3 is returned if ROE is outside +2 std\n",
    "    4. Score of -1 is returned if given ROE is in between -1 std and mean\n",
    "    5. Score of -2 is returned if given ROE is in between -1 std and -2 std\n",
    "    5. Score of -3 is given if given ROE is outside -2 std\n",
    "\n",
    "    Parameters\n",
    "    ----------\n",
    "    values : List of the values\n",
    "    value: The value to compare whether it's within mean, 1 std, -1 std, 2 std or -2 std\n",
    "    cat: Category type, valid value is 1 or 2.\n",
    "        \n",
    "    Returns\n",
    "    -------\n",
    "    score: the score for given 'value'\n",
    "    '''\n",
    "    \n",
    "    std = statistics.stdev(values)\n",
    "    mean = statistics.mean(values)\n",
    "\n",
    "    if cat == 1:\n",
    "        if (mean + (-1 * std)) < value <= mean:\n",
    "            return 1\n",
    "        elif (mean + (-2 * std)) < value <= (mean + (-1 * std)):\n",
    "            return 2\n",
    "        elif value <= (mean + (-2 * std)):\n",
    "            return 3\n",
    "        elif mean < value <= (mean + (1 * std)):\n",
    "            return -1\n",
    "        elif (mean + (1 * std)) < value <= (mean + (2 * std)):\n",
    "            return -2\n",
    "        else:\n",
    "            return -3\n",
    "    else:\n",
    "        if mean <= value < (mean + (1 * std)):\n",
    "            return 1\n",
    "        elif (mean + (1 * std)) <= value < (mean + (2 * std)):\n",
    "            return 2\n",
    "        elif value >= (mean + (2 * std)):\n",
    "            return 3\n",
    "        elif (mean + (-1 * std)) <= value < mean:\n",
    "            return -1\n",
    "        elif (mean + (-2 * std)) <= value < (mean + (-1 * std)):\n",
    "            return -2\n",
    "        else:\n",
    "            return -3"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1debdbec-609d-41f1-bf5a-35415bd64d12",
   "metadata": {},
   "source": [
    "## Apply scoring"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "73898b1f-0a25-477d-8f9d-fe3dbaf80413",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_score = df.copy()\n",
    "\n",
    "for col in CAT1_RATIOS:\n",
    "    for index, value in df[col].items():\n",
    "        # print(f'{col} - {index} - {value}')\n",
    "        df_score.loc[index, col] = score(df[col], value, 1)\n",
    "\n",
    "for col in CAT2_RATIOS:\n",
    "    for index, value in df[col].items():\n",
    "        # print(f'{col} - {index} - {value}')\n",
    "        df_score.loc[index, col] = score(df[col], value, 2)\n",
    "\n",
    "# Add ranking scores to get the total score\n",
    "df_score['Score'] = df_score[CAT1_RATIOS+CAT2_RATIOS].sum(axis=1)\n",
    "# df_score"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "8795ff5f-f557-4e97-8f81-96b1d1a4f172",
   "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>Symbol</th>\n",
       "      <th>Name</th>\n",
       "      <th>Market Cap</th>\n",
       "      <th>EPS fwd</th>\n",
       "      <th>PE fwd</th>\n",
       "      <th>PEG</th>\n",
       "      <th>PB</th>\n",
       "      <th>ROE</th>\n",
       "      <th>ROCE</th>\n",
       "      <th>FCFY</th>\n",
       "      <th>D2E</th>\n",
       "      <th>CR</th>\n",
       "      <th>QR</th>\n",
       "      <th>Asset TR</th>\n",
       "      <th>DY</th>\n",
       "      <th>Beta</th>\n",
       "      <th>Price</th>\n",
       "      <th>52w Low</th>\n",
       "      <th>52w High</th>\n",
       "      <th>52w Range</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ATO</td>\n",
       "      <td>Atmos Energy Corporation</td>\n",
       "      <td>17.2B</td>\n",
       "      <td>7.08</td>\n",
       "      <td>16.090395</td>\n",
       "      <td>2.31</td>\n",
       "      <td>1.556220</td>\n",
       "      <td>0.08732</td>\n",
       "      <td>0.053719</td>\n",
       "      <td>2.39</td>\n",
       "      <td>65.528</td>\n",
       "      <td>0.655</td>\n",
       "      <td>0.265</td>\n",
       "      <td>0.191249</td>\n",
       "      <td>2.83</td>\n",
       "      <td>0.667</td>\n",
       "      <td>113.92</td>\n",
       "      <td>101.00</td>\n",
       "      <td>125.28</td>\n",
       "      <td>53.212521</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CPK</td>\n",
       "      <td>Chesapeake Utilities Corporation</td>\n",
       "      <td>2.29B</td>\n",
       "      <td>5.45</td>\n",
       "      <td>18.871560</td>\n",
       "      <td>2.93</td>\n",
       "      <td>2.111953</td>\n",
       "      <td>0.10473</td>\n",
       "      <td>0.080164</td>\n",
       "      <td>1.61</td>\n",
       "      <td>91.819</td>\n",
       "      <td>0.477</td>\n",
       "      <td>0.234</td>\n",
       "      <td>0.314420</td>\n",
       "      <td>2.29</td>\n",
       "      <td>0.636</td>\n",
       "      <td>102.85</td>\n",
       "      <td>83.80</td>\n",
       "      <td>132.91</td>\n",
       "      <td>38.790470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NFE</td>\n",
       "      <td>New Fortress Energy Inc.</td>\n",
       "      <td>6.79B</td>\n",
       "      <td>5.03</td>\n",
       "      <td>6.580516</td>\n",
       "      <td>0.18</td>\n",
       "      <td>4.725871</td>\n",
       "      <td>0.22331</td>\n",
       "      <td>0.045603</td>\n",
       "      <td>-14.30</td>\n",
       "      <td>419.905</td>\n",
       "      <td>0.453</td>\n",
       "      <td>0.315</td>\n",
       "      <td>0.324831</td>\n",
       "      <td>1.21</td>\n",
       "      <td>1.544</td>\n",
       "      <td>33.10</td>\n",
       "      <td>25.06</td>\n",
       "      <td>42.17</td>\n",
       "      <td>46.990064</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NI</td>\n",
       "      <td>NiSource Inc.</td>\n",
       "      <td>10.6B</td>\n",
       "      <td>1.71</td>\n",
       "      <td>14.947368</td>\n",
       "      <td>1.94</td>\n",
       "      <td>1.743401</td>\n",
       "      <td>0.09476</td>\n",
       "      <td>0.059653</td>\n",
       "      <td>-11.27</td>\n",
       "      <td>170.646</td>\n",
       "      <td>0.413</td>\n",
       "      <td>0.151</td>\n",
       "      <td>0.229915</td>\n",
       "      <td>3.91</td>\n",
       "      <td>0.499</td>\n",
       "      <td>25.56</td>\n",
       "      <td>22.86</td>\n",
       "      <td>28.95</td>\n",
       "      <td>44.334975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>OGS</td>\n",
       "      <td>ONE Gas, Inc.</td>\n",
       "      <td>3.4B</td>\n",
       "      <td>3.87</td>\n",
       "      <td>15.821706</td>\n",
       "      <td>2.96</td>\n",
       "      <td>1.282787</td>\n",
       "      <td>0.08935</td>\n",
       "      <td>0.052494</td>\n",
       "      <td>4.88</td>\n",
       "      <td>112.968</td>\n",
       "      <td>0.359</td>\n",
       "      <td>0.119</td>\n",
       "      <td>0.318695</td>\n",
       "      <td>4.31</td>\n",
       "      <td>0.656</td>\n",
       "      <td>61.23</td>\n",
       "      <td>55.50</td>\n",
       "      <td>84.26</td>\n",
       "      <td>19.923505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>SWX</td>\n",
       "      <td>Southwest Gas Holdings, Inc.</td>\n",
       "      <td>4.28B</td>\n",
       "      <td>3.07</td>\n",
       "      <td>19.488600</td>\n",
       "      <td>4.52</td>\n",
       "      <td>1.321130</td>\n",
       "      <td>-0.05662</td>\n",
       "      <td>-0.003130</td>\n",
       "      <td>-13.97</td>\n",
       "      <td>157.669</td>\n",
       "      <td>1.899</td>\n",
       "      <td>1.004</td>\n",
       "      <td>0.382100</td>\n",
       "      <td>4.15</td>\n",
       "      <td>0.318</td>\n",
       "      <td>59.83</td>\n",
       "      <td>53.79</td>\n",
       "      <td>68.03</td>\n",
       "      <td>42.415730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>SR</td>\n",
       "      <td>Spire Inc.</td>\n",
       "      <td>3.13B</td>\n",
       "      <td>4.55</td>\n",
       "      <td>12.929670</td>\n",
       "      <td>2.14</td>\n",
       "      <td>1.169211</td>\n",
       "      <td>0.07584</td>\n",
       "      <td>0.051646</td>\n",
       "      <td>-3.99</td>\n",
       "      <td>162.585</td>\n",
       "      <td>0.613</td>\n",
       "      <td>0.180</td>\n",
       "      <td>0.261437</td>\n",
       "      <td>5.13</td>\n",
       "      <td>0.533</td>\n",
       "      <td>58.83</td>\n",
       "      <td>53.77</td>\n",
       "      <td>75.83</td>\n",
       "      <td>22.937443</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>UGI</td>\n",
       "      <td>UGI Corporation</td>\n",
       "      <td>4.81B</td>\n",
       "      <td>2.92</td>\n",
       "      <td>7.856165</td>\n",
       "      <td>1.38</td>\n",
       "      <td>1.139083</td>\n",
       "      <td>-0.28697</td>\n",
       "      <td>-0.111069</td>\n",
       "      <td>3.58</td>\n",
       "      <td>174.693</td>\n",
       "      <td>0.899</td>\n",
       "      <td>0.522</td>\n",
       "      <td>0.541485</td>\n",
       "      <td>6.54</td>\n",
       "      <td>1.153</td>\n",
       "      <td>22.94</td>\n",
       "      <td>20.19</td>\n",
       "      <td>43.19</td>\n",
       "      <td>11.956522</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Symbol                              Name Market Cap  EPS fwd     PE fwd  \\\n",
       "0    ATO          Atmos Energy Corporation      17.2B     7.08  16.090395   \n",
       "1    CPK  Chesapeake Utilities Corporation      2.29B     5.45  18.871560   \n",
       "2    NFE          New Fortress Energy Inc.      6.79B     5.03   6.580516   \n",
       "3     NI                     NiSource Inc.      10.6B     1.71  14.947368   \n",
       "4    OGS                     ONE Gas, Inc.       3.4B     3.87  15.821706   \n",
       "5    SWX      Southwest Gas Holdings, Inc.      4.28B     3.07  19.488600   \n",
       "6     SR                        Spire Inc.      3.13B     4.55  12.929670   \n",
       "7    UGI                   UGI Corporation      4.81B     2.92   7.856165   \n",
       "\n",
       "    PEG        PB      ROE      ROCE   FCFY      D2E     CR     QR  Asset TR  \\\n",
       "0  2.31  1.556220  0.08732  0.053719   2.39   65.528  0.655  0.265  0.191249   \n",
       "1  2.93  2.111953  0.10473  0.080164   1.61   91.819  0.477  0.234  0.314420   \n",
       "2  0.18  4.725871  0.22331  0.045603 -14.30  419.905  0.453  0.315  0.324831   \n",
       "3  1.94  1.743401  0.09476  0.059653 -11.27  170.646  0.413  0.151  0.229915   \n",
       "4  2.96  1.282787  0.08935  0.052494   4.88  112.968  0.359  0.119  0.318695   \n",
       "5  4.52  1.321130 -0.05662 -0.003130 -13.97  157.669  1.899  1.004  0.382100   \n",
       "6  2.14  1.169211  0.07584  0.051646  -3.99  162.585  0.613  0.180  0.261437   \n",
       "7  1.38  1.139083 -0.28697 -0.111069   3.58  174.693  0.899  0.522  0.541485   \n",
       "\n",
       "     DY   Beta   Price  52w Low  52w High  52w Range  \n",
       "0  2.83  0.667  113.92   101.00    125.28  53.212521  \n",
       "1  2.29  0.636  102.85    83.80    132.91  38.790470  \n",
       "2  1.21  1.544   33.10    25.06     42.17  46.990064  \n",
       "3  3.91  0.499   25.56    22.86     28.95  44.334975  \n",
       "4  4.31  0.656   61.23    55.50     84.26  19.923505  \n",
       "5  4.15  0.318   59.83    53.79     68.03  42.415730  \n",
       "6  5.13  0.533   58.83    53.77     75.83  22.937443  \n",
       "7  6.54  1.153   22.94    20.19     43.19  11.956522  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f45d5d15-5a55-45d3-a0ad-3e8500d0192b",
   "metadata": {},
   "source": [
    "## Add Styles"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "6841e09c-3bbe-4a05-b142-a3444bf35df9",
   "metadata": {},
   "outputs": [],
   "source": [
    "def make_pretty(styler):\n",
    "    # Column formatting\n",
    "    styler.format({'EPS fwd': '{:.0f}', 'PE fwd': '{:.0f}', 'PEG': '{:.0f}', 'FCFY': '{:.0f}', 'PB' : '{:.0f}', 'ROE' : '{:.0f}',\n",
    "                   'ROCE': '{:.0f}', 'D2E': '{:.0f}', 'CR': '{:.0f}', 'QR': '{:.0f}', 'Asset TR': '{:.0f}', 'DY': '{:.2f}%',\n",
    "                   'Beta': '{:.0f}', '52w Low': '${:.2f}', 'Price': '${:.2f}', '52w High': '${:.2f}', '52w Range': '{:.2f}%', 'Score' : '{:.0f}'\n",
    "                  })\n",
    "\n",
    "    # Set the bar visualization\n",
    "    styler.bar(subset = ['52w Range'], align = \"mid\", color = [\"salmon\", \"cornflowerblue\"])\n",
    "\n",
    "    # Grid\n",
    "    styler.set_properties(**{'border': '0.1px solid black'})\n",
    "\n",
    "    # Set background gradients\n",
    "    for ratio in CAT1_RATIOS:\n",
    "        styler.background_gradient(subset=[ratio], cmap='RdYlGn', gmap=-df[ratio])\n",
    "    for ratio in CAT2_RATIOS:\n",
    "        styler.background_gradient(subset=[ratio], cmap='RdYlGn')\n",
    "    styler.background_gradient(subset=['Score'], cmap='PiYG')\n",
    "    \n",
    "    # Hide index\n",
    "    styler.hide(axis='index')\n",
    "\n",
    "    # Left text alignment for some columns\n",
    "    styler.set_properties(subset=['Symbol', 'Name'], **{'text-align': 'left'})\n",
    "    styler.set_properties(subset=CAT1_RATIOS + CAT2_RATIOS + ['Market Cap', 'Score'], **{'text-align': 'center'})\n",
    "\n",
    "    return styler"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "731c739b-53e9-42d5-bed5-232522aa7818",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_01fd9 th.col_heading {\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9 caption {\n",
       "  text-align: center;\n",
       "  font-size: 11pt;\n",
       "  font-weight: bold;\n",
       "}\n",
       "#T_01fd9_row0_col0, #T_01fd9_row0_col1, #T_01fd9_row1_col0, #T_01fd9_row1_col1, #T_01fd9_row2_col0, #T_01fd9_row2_col1, #T_01fd9_row3_col0, #T_01fd9_row3_col1, #T_01fd9_row4_col0, #T_01fd9_row4_col1, #T_01fd9_row5_col0, #T_01fd9_row5_col1, #T_01fd9_row6_col0, #T_01fd9_row6_col1, #T_01fd9_row7_col0, #T_01fd9_row7_col1 {\n",
       "  border: 0.1px solid black;\n",
       "  text-align: left;\n",
       "}\n",
       "#T_01fd9_row0_col2, #T_01fd9_row1_col2, #T_01fd9_row2_col2, #T_01fd9_row3_col2, #T_01fd9_row4_col2, #T_01fd9_row5_col2, #T_01fd9_row6_col2, #T_01fd9_row7_col2 {\n",
       "  border: 0.1px solid black;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row0_col3, #T_01fd9_row0_col8, #T_01fd9_row0_col10, #T_01fd9_row1_col8, #T_01fd9_row2_col4, #T_01fd9_row2_col5, #T_01fd9_row2_col7, #T_01fd9_row2_col8, #T_01fd9_row3_col8, #T_01fd9_row4_col8, #T_01fd9_row4_col9, #T_01fd9_row5_col11, #T_01fd9_row5_col12, #T_01fd9_row5_col15, #T_01fd9_row6_col8, #T_01fd9_row7_col6, #T_01fd9_row7_col13 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #006837;\n",
       "  color: #f1f1f1;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row0_col4 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #fa9656;\n",
       "  color: #000000;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row0_col5, #T_01fd9_row6_col4 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #fbfdba;\n",
       "  color: #000000;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row0_col6 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #249d53;\n",
       "  color: #f1f1f1;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row0_col7, #T_01fd9_row1_col7, #T_01fd9_row3_col7, #T_01fd9_row4_col7, #T_01fd9_row6_col7 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #66bd63;\n",
       "  color: #f1f1f1;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row0_col9, #T_01fd9_row1_col3, #T_01fd9_row1_col9, #T_01fd9_row2_col3, #T_01fd9_row6_col3, #T_01fd9_row7_col9 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #84ca66;\n",
       "  color: #000000;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row0_col11, #T_01fd9_row0_col12, #T_01fd9_row0_col13, #T_01fd9_row1_col11, #T_01fd9_row1_col12, #T_01fd9_row2_col6, #T_01fd9_row2_col9, #T_01fd9_row2_col10, #T_01fd9_row2_col11, #T_01fd9_row2_col12, #T_01fd9_row2_col15, #T_01fd9_row3_col3, #T_01fd9_row3_col11, #T_01fd9_row3_col12, #T_01fd9_row4_col11, #T_01fd9_row4_col12, #T_01fd9_row5_col4, #T_01fd9_row5_col5, #T_01fd9_row5_col9, #T_01fd9_row6_col11, #T_01fd9_row6_col12, #T_01fd9_row7_col7, #T_01fd9_row7_col8 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #a50026;\n",
       "  color: #f1f1f1;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row0_col14, #T_01fd9_row0_col16, #T_01fd9_row0_col17, #T_01fd9_row0_col18, #T_01fd9_row1_col14, #T_01fd9_row1_col16, #T_01fd9_row1_col17, #T_01fd9_row1_col18, #T_01fd9_row2_col14, #T_01fd9_row2_col16, #T_01fd9_row2_col17, #T_01fd9_row2_col18, #T_01fd9_row3_col14, #T_01fd9_row3_col16, #T_01fd9_row3_col17, #T_01fd9_row3_col18, #T_01fd9_row4_col14, #T_01fd9_row4_col16, #T_01fd9_row4_col17, #T_01fd9_row4_col18, #T_01fd9_row5_col14, #T_01fd9_row5_col16, #T_01fd9_row5_col17, #T_01fd9_row5_col18, #T_01fd9_row6_col14, #T_01fd9_row6_col16, #T_01fd9_row6_col17, #T_01fd9_row6_col18, #T_01fd9_row7_col14, #T_01fd9_row7_col16, #T_01fd9_row7_col17, #T_01fd9_row7_col18 {\n",
       "  border: 0.1px solid black;\n",
       "}\n",
       "#T_01fd9_row0_col15 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #9bd469;\n",
       "  color: #000000;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row0_col19 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, cornflowerblue 100.0%, transparent 100.0%);\n",
       "  border: 0.1px solid black;\n",
       "}\n",
       "#T_01fd9_row0_col20, #T_01fd9_row5_col20 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #b0dc7d;\n",
       "  color: #000000;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row1_col4 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #bd1726;\n",
       "  color: #f1f1f1;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row1_col5 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #fece7c;\n",
       "  color: #000000;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row1_col6 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #93d168;\n",
       "  color: #000000;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row1_col10 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #128a49;\n",
       "  color: #f1f1f1;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row1_col13, #T_01fd9_row3_col13, #T_01fd9_row4_col13, #T_01fd9_row6_col13 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #f46d43;\n",
       "  color: #f1f1f1;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row1_col15, #T_01fd9_row5_col10 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #8ccd67;\n",
       "  color: #000000;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row1_col19 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, cornflowerblue 72.9%, transparent 72.9%);\n",
       "  border: 0.1px solid black;\n",
       "}\n",
       "#T_01fd9_row1_col20 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #eeadd4;\n",
       "  color: #000000;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row2_col13, #T_01fd9_row5_col13 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #d9ef8b;\n",
       "  color: #000000;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row2_col19 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, cornflowerblue 88.3%, transparent 88.3%);\n",
       "  border: 0.1px solid black;\n",
       "}\n",
       "#T_01fd9_row2_col20, #T_01fd9_row3_col20 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #8e0152;\n",
       "  color: #f1f1f1;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row3_col4 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #fec877;\n",
       "  color: #000000;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row3_col5 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #daf08d;\n",
       "  color: #000000;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row3_col6 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #4eb15d;\n",
       "  color: #f1f1f1;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row3_col9, #T_01fd9_row4_col3, #T_01fd9_row5_col3, #T_01fd9_row6_col9, #T_01fd9_row7_col3 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #f98e52;\n",
       "  color: #f1f1f1;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row3_col10 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #a2d76a;\n",
       "  color: #000000;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row3_col15 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #3ca959;\n",
       "  color: #f1f1f1;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row3_col19 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, cornflowerblue 83.3%, transparent 83.3%);\n",
       "  border: 0.1px solid black;\n",
       "}\n",
       "#T_01fd9_row4_col4 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #fba35c;\n",
       "  color: #000000;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row4_col5 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #fecc7b;\n",
       "  color: #000000;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row4_col6 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #0a7b41;\n",
       "  color: #f1f1f1;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row4_col10 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #33a456;\n",
       "  color: #f1f1f1;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row4_col15, #T_01fd9_row6_col10, #T_01fd9_row7_col5 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #96d268;\n",
       "  color: #000000;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row4_col19 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, cornflowerblue 37.4%, transparent 37.4%);\n",
       "  border: 0.1px solid black;\n",
       "}\n",
       "#T_01fd9_row4_col20 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #ebf6db;\n",
       "  color: #000000;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row5_col6 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #0c7f43;\n",
       "  color: #f1f1f1;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row5_col7 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #fee08b;\n",
       "  color: #000000;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row5_col8, #T_01fd9_row7_col11, #T_01fd9_row7_col12 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #feffbe;\n",
       "  color: #000000;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row5_col19 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, cornflowerblue 79.7%, transparent 79.7%);\n",
       "  border: 0.1px solid black;\n",
       "}\n",
       "#T_01fd9_row6_col5 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #ecf7a6;\n",
       "  color: #000000;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row6_col6 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #026c39;\n",
       "  color: #f1f1f1;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row6_col15 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #51b35e;\n",
       "  color: #f1f1f1;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row6_col19 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, cornflowerblue 43.1%, transparent 43.1%);\n",
       "  border: 0.1px solid black;\n",
       "}\n",
       "#T_01fd9_row6_col20 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #276419;\n",
       "  color: #f1f1f1;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row7_col4 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #199750;\n",
       "  color: #f1f1f1;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row7_col10 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #a9da6c;\n",
       "  color: #000000;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row7_col15 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #fdb768;\n",
       "  color: #000000;\n",
       "  text-align: center;\n",
       "}\n",
       "#T_01fd9_row7_col19 {\n",
       "  width: 10em;\n",
       "  background: linear-gradient(90deg, cornflowerblue 22.5%, transparent 22.5%);\n",
       "  border: 0.1px solid black;\n",
       "}\n",
       "#T_01fd9_row7_col20 {\n",
       "  border: 0.1px solid black;\n",
       "  background-color: #fbe6f1;\n",
       "  color: #000000;\n",
       "  text-align: center;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_01fd9\">\n",
       "  <caption>Stock Screener Utilities - Regulated Gas</caption>\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th id=\"T_01fd9_level0_col0\" class=\"col_heading level0 col0\" >Symbol</th>\n",
       "      <th id=\"T_01fd9_level0_col1\" class=\"col_heading level0 col1\" >Name</th>\n",
       "      <th id=\"T_01fd9_level0_col2\" class=\"col_heading level0 col2\" >Market Cap</th>\n",
       "      <th id=\"T_01fd9_level0_col3\" class=\"col_heading level0 col3\" >EPS fwd</th>\n",
       "      <th id=\"T_01fd9_level0_col4\" class=\"col_heading level0 col4\" >PE fwd</th>\n",
       "      <th id=\"T_01fd9_level0_col5\" class=\"col_heading level0 col5\" >PEG</th>\n",
       "      <th id=\"T_01fd9_level0_col6\" class=\"col_heading level0 col6\" >PB</th>\n",
       "      <th id=\"T_01fd9_level0_col7\" class=\"col_heading level0 col7\" >ROE</th>\n",
       "      <th id=\"T_01fd9_level0_col8\" class=\"col_heading level0 col8\" >ROCE</th>\n",
       "      <th id=\"T_01fd9_level0_col9\" class=\"col_heading level0 col9\" >FCFY</th>\n",
       "      <th id=\"T_01fd9_level0_col10\" class=\"col_heading level0 col10\" >D2E</th>\n",
       "      <th id=\"T_01fd9_level0_col11\" class=\"col_heading level0 col11\" >CR</th>\n",
       "      <th id=\"T_01fd9_level0_col12\" class=\"col_heading level0 col12\" >QR</th>\n",
       "      <th id=\"T_01fd9_level0_col13\" class=\"col_heading level0 col13\" >Asset TR</th>\n",
       "      <th id=\"T_01fd9_level0_col14\" class=\"col_heading level0 col14\" >DY</th>\n",
       "      <th id=\"T_01fd9_level0_col15\" class=\"col_heading level0 col15\" >Beta</th>\n",
       "      <th id=\"T_01fd9_level0_col16\" class=\"col_heading level0 col16\" >Price</th>\n",
       "      <th id=\"T_01fd9_level0_col17\" class=\"col_heading level0 col17\" >52w Low</th>\n",
       "      <th id=\"T_01fd9_level0_col18\" class=\"col_heading level0 col18\" >52w High</th>\n",
       "      <th id=\"T_01fd9_level0_col19\" class=\"col_heading level0 col19\" >52w Range</th>\n",
       "      <th id=\"T_01fd9_level0_col20\" class=\"col_heading level0 col20\" >Score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td id=\"T_01fd9_row0_col0\" class=\"data row0 col0\" >ATO</td>\n",
       "      <td id=\"T_01fd9_row0_col1\" class=\"data row0 col1\" >Atmos Energy Corporation</td>\n",
       "      <td id=\"T_01fd9_row0_col2\" class=\"data row0 col2\" >17.2B</td>\n",
       "      <td id=\"T_01fd9_row0_col3\" class=\"data row0 col3\" >2</td>\n",
       "      <td id=\"T_01fd9_row0_col4\" class=\"data row0 col4\" >-1</td>\n",
       "      <td id=\"T_01fd9_row0_col5\" class=\"data row0 col5\" >-1</td>\n",
       "      <td id=\"T_01fd9_row0_col6\" class=\"data row0 col6\" >1</td>\n",
       "      <td id=\"T_01fd9_row0_col7\" class=\"data row0 col7\" >1</td>\n",
       "      <td id=\"T_01fd9_row0_col8\" class=\"data row0 col8\" >1</td>\n",
       "      <td id=\"T_01fd9_row0_col9\" class=\"data row0 col9\" >1</td>\n",
       "      <td id=\"T_01fd9_row0_col10\" class=\"data row0 col10\" >1</td>\n",
       "      <td id=\"T_01fd9_row0_col11\" class=\"data row0 col11\" >-1</td>\n",
       "      <td id=\"T_01fd9_row0_col12\" class=\"data row0 col12\" >-1</td>\n",
       "      <td id=\"T_01fd9_row0_col13\" class=\"data row0 col13\" >-2</td>\n",
       "      <td id=\"T_01fd9_row0_col14\" class=\"data row0 col14\" >2.83%</td>\n",
       "      <td id=\"T_01fd9_row0_col15\" class=\"data row0 col15\" >1</td>\n",
       "      <td id=\"T_01fd9_row0_col16\" class=\"data row0 col16\" >$113.92</td>\n",
       "      <td id=\"T_01fd9_row0_col17\" class=\"data row0 col17\" >$101.00</td>\n",
       "      <td id=\"T_01fd9_row0_col18\" class=\"data row0 col18\" >$125.28</td>\n",
       "      <td id=\"T_01fd9_row0_col19\" class=\"data row0 col19\" >53.21%</td>\n",
       "      <td id=\"T_01fd9_row0_col20\" class=\"data row0 col20\" >2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_01fd9_row1_col0\" class=\"data row1 col0\" >CPK</td>\n",
       "      <td id=\"T_01fd9_row1_col1\" class=\"data row1 col1\" >Chesapeake Utilities Corporation</td>\n",
       "      <td id=\"T_01fd9_row1_col2\" class=\"data row1 col2\" >2.29B</td>\n",
       "      <td id=\"T_01fd9_row1_col3\" class=\"data row1 col3\" >1</td>\n",
       "      <td id=\"T_01fd9_row1_col4\" class=\"data row1 col4\" >-2</td>\n",
       "      <td id=\"T_01fd9_row1_col5\" class=\"data row1 col5\" >-1</td>\n",
       "      <td id=\"T_01fd9_row1_col6\" class=\"data row1 col6\" >-1</td>\n",
       "      <td id=\"T_01fd9_row1_col7\" class=\"data row1 col7\" >1</td>\n",
       "      <td id=\"T_01fd9_row1_col8\" class=\"data row1 col8\" >1</td>\n",
       "      <td id=\"T_01fd9_row1_col9\" class=\"data row1 col9\" >1</td>\n",
       "      <td id=\"T_01fd9_row1_col10\" class=\"data row1 col10\" >1</td>\n",
       "      <td id=\"T_01fd9_row1_col11\" class=\"data row1 col11\" >-1</td>\n",
       "      <td id=\"T_01fd9_row1_col12\" class=\"data row1 col12\" >-1</td>\n",
       "      <td id=\"T_01fd9_row1_col13\" class=\"data row1 col13\" >-1</td>\n",
       "      <td id=\"T_01fd9_row1_col14\" class=\"data row1 col14\" >2.29%</td>\n",
       "      <td id=\"T_01fd9_row1_col15\" class=\"data row1 col15\" >1</td>\n",
       "      <td id=\"T_01fd9_row1_col16\" class=\"data row1 col16\" >$102.85</td>\n",
       "      <td id=\"T_01fd9_row1_col17\" class=\"data row1 col17\" >$83.80</td>\n",
       "      <td id=\"T_01fd9_row1_col18\" class=\"data row1 col18\" >$132.91</td>\n",
       "      <td id=\"T_01fd9_row1_col19\" class=\"data row1 col19\" >38.79%</td>\n",
       "      <td id=\"T_01fd9_row1_col20\" class=\"data row1 col20\" >-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_01fd9_row2_col0\" class=\"data row2 col0\" >NFE</td>\n",
       "      <td id=\"T_01fd9_row2_col1\" class=\"data row2 col1\" >New Fortress Energy Inc.</td>\n",
       "      <td id=\"T_01fd9_row2_col2\" class=\"data row2 col2\" >6.79B</td>\n",
       "      <td id=\"T_01fd9_row2_col3\" class=\"data row2 col3\" >1</td>\n",
       "      <td id=\"T_01fd9_row2_col4\" class=\"data row2 col4\" >2</td>\n",
       "      <td id=\"T_01fd9_row2_col5\" class=\"data row2 col5\" >2</td>\n",
       "      <td id=\"T_01fd9_row2_col6\" class=\"data row2 col6\" >-3</td>\n",
       "      <td id=\"T_01fd9_row2_col7\" class=\"data row2 col7\" >2</td>\n",
       "      <td id=\"T_01fd9_row2_col8\" class=\"data row2 col8\" >1</td>\n",
       "      <td id=\"T_01fd9_row2_col9\" class=\"data row2 col9\" >-2</td>\n",
       "      <td id=\"T_01fd9_row2_col10\" class=\"data row2 col10\" >-3</td>\n",
       "      <td id=\"T_01fd9_row2_col11\" class=\"data row2 col11\" >-1</td>\n",
       "      <td id=\"T_01fd9_row2_col12\" class=\"data row2 col12\" >-1</td>\n",
       "      <td id=\"T_01fd9_row2_col13\" class=\"data row2 col13\" >1</td>\n",
       "      <td id=\"T_01fd9_row2_col14\" class=\"data row2 col14\" >1.21%</td>\n",
       "      <td id=\"T_01fd9_row2_col15\" class=\"data row2 col15\" >-2</td>\n",
       "      <td id=\"T_01fd9_row2_col16\" class=\"data row2 col16\" >$33.10</td>\n",
       "      <td id=\"T_01fd9_row2_col17\" class=\"data row2 col17\" >$25.06</td>\n",
       "      <td id=\"T_01fd9_row2_col18\" class=\"data row2 col18\" >$42.17</td>\n",
       "      <td id=\"T_01fd9_row2_col19\" class=\"data row2 col19\" >46.99%</td>\n",
       "      <td id=\"T_01fd9_row2_col20\" class=\"data row2 col20\" >-3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_01fd9_row3_col0\" class=\"data row3 col0\" >NI</td>\n",
       "      <td id=\"T_01fd9_row3_col1\" class=\"data row3 col1\" >NiSource Inc.</td>\n",
       "      <td id=\"T_01fd9_row3_col2\" class=\"data row3 col2\" >10.6B</td>\n",
       "      <td id=\"T_01fd9_row3_col3\" class=\"data row3 col3\" >-2</td>\n",
       "      <td id=\"T_01fd9_row3_col4\" class=\"data row3 col4\" >-1</td>\n",
       "      <td id=\"T_01fd9_row3_col5\" class=\"data row3 col5\" >1</td>\n",
       "      <td id=\"T_01fd9_row3_col6\" class=\"data row3 col6\" >1</td>\n",
       "      <td id=\"T_01fd9_row3_col7\" class=\"data row3 col7\" >1</td>\n",
       "      <td id=\"T_01fd9_row3_col8\" class=\"data row3 col8\" >1</td>\n",
       "      <td id=\"T_01fd9_row3_col9\" class=\"data row3 col9\" >-1</td>\n",
       "      <td id=\"T_01fd9_row3_col10\" class=\"data row3 col10\" >-1</td>\n",
       "      <td id=\"T_01fd9_row3_col11\" class=\"data row3 col11\" >-1</td>\n",
       "      <td id=\"T_01fd9_row3_col12\" class=\"data row3 col12\" >-1</td>\n",
       "      <td id=\"T_01fd9_row3_col13\" class=\"data row3 col13\" >-1</td>\n",
       "      <td id=\"T_01fd9_row3_col14\" class=\"data row3 col14\" >3.91%</td>\n",
       "      <td id=\"T_01fd9_row3_col15\" class=\"data row3 col15\" >1</td>\n",
       "      <td id=\"T_01fd9_row3_col16\" class=\"data row3 col16\" >$25.56</td>\n",
       "      <td id=\"T_01fd9_row3_col17\" class=\"data row3 col17\" >$22.86</td>\n",
       "      <td id=\"T_01fd9_row3_col18\" class=\"data row3 col18\" >$28.95</td>\n",
       "      <td id=\"T_01fd9_row3_col19\" class=\"data row3 col19\" >44.33%</td>\n",
       "      <td id=\"T_01fd9_row3_col20\" class=\"data row3 col20\" >-3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_01fd9_row4_col0\" class=\"data row4 col0\" >OGS</td>\n",
       "      <td id=\"T_01fd9_row4_col1\" class=\"data row4 col1\" >ONE Gas, Inc.</td>\n",
       "      <td id=\"T_01fd9_row4_col2\" class=\"data row4 col2\" >3.4B</td>\n",
       "      <td id=\"T_01fd9_row4_col3\" class=\"data row4 col3\" >-1</td>\n",
       "      <td id=\"T_01fd9_row4_col4\" class=\"data row4 col4\" >-1</td>\n",
       "      <td id=\"T_01fd9_row4_col5\" class=\"data row4 col5\" >-1</td>\n",
       "      <td id=\"T_01fd9_row4_col6\" class=\"data row4 col6\" >1</td>\n",
       "      <td id=\"T_01fd9_row4_col7\" class=\"data row4 col7\" >1</td>\n",
       "      <td id=\"T_01fd9_row4_col8\" class=\"data row4 col8\" >1</td>\n",
       "      <td id=\"T_01fd9_row4_col9\" class=\"data row4 col9\" >2</td>\n",
       "      <td id=\"T_01fd9_row4_col10\" class=\"data row4 col10\" >1</td>\n",
       "      <td id=\"T_01fd9_row4_col11\" class=\"data row4 col11\" >-1</td>\n",
       "      <td id=\"T_01fd9_row4_col12\" class=\"data row4 col12\" >-1</td>\n",
       "      <td id=\"T_01fd9_row4_col13\" class=\"data row4 col13\" >-1</td>\n",
       "      <td id=\"T_01fd9_row4_col14\" class=\"data row4 col14\" >4.31%</td>\n",
       "      <td id=\"T_01fd9_row4_col15\" class=\"data row4 col15\" >1</td>\n",
       "      <td id=\"T_01fd9_row4_col16\" class=\"data row4 col16\" >$61.23</td>\n",
       "      <td id=\"T_01fd9_row4_col17\" class=\"data row4 col17\" >$55.50</td>\n",
       "      <td id=\"T_01fd9_row4_col18\" class=\"data row4 col18\" >$84.26</td>\n",
       "      <td id=\"T_01fd9_row4_col19\" class=\"data row4 col19\" >19.92%</td>\n",
       "      <td id=\"T_01fd9_row4_col20\" class=\"data row4 col20\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_01fd9_row5_col0\" class=\"data row5 col0\" >SWX</td>\n",
       "      <td id=\"T_01fd9_row5_col1\" class=\"data row5 col1\" >Southwest Gas Holdings, Inc.</td>\n",
       "      <td id=\"T_01fd9_row5_col2\" class=\"data row5 col2\" >4.28B</td>\n",
       "      <td id=\"T_01fd9_row5_col3\" class=\"data row5 col3\" >-1</td>\n",
       "      <td id=\"T_01fd9_row5_col4\" class=\"data row5 col4\" >-2</td>\n",
       "      <td id=\"T_01fd9_row5_col5\" class=\"data row5 col5\" >-2</td>\n",
       "      <td id=\"T_01fd9_row5_col6\" class=\"data row5 col6\" >1</td>\n",
       "      <td id=\"T_01fd9_row5_col7\" class=\"data row5 col7\" >-1</td>\n",
       "      <td id=\"T_01fd9_row5_col8\" class=\"data row5 col8\" >-1</td>\n",
       "      <td id=\"T_01fd9_row5_col9\" class=\"data row5 col9\" >-2</td>\n",
       "      <td id=\"T_01fd9_row5_col10\" class=\"data row5 col10\" >1</td>\n",
       "      <td id=\"T_01fd9_row5_col11\" class=\"data row5 col11\" >3</td>\n",
       "      <td id=\"T_01fd9_row5_col12\" class=\"data row5 col12\" >3</td>\n",
       "      <td id=\"T_01fd9_row5_col13\" class=\"data row5 col13\" >1</td>\n",
       "      <td id=\"T_01fd9_row5_col14\" class=\"data row5 col14\" >4.15%</td>\n",
       "      <td id=\"T_01fd9_row5_col15\" class=\"data row5 col15\" >2</td>\n",
       "      <td id=\"T_01fd9_row5_col16\" class=\"data row5 col16\" >$59.83</td>\n",
       "      <td id=\"T_01fd9_row5_col17\" class=\"data row5 col17\" >$53.79</td>\n",
       "      <td id=\"T_01fd9_row5_col18\" class=\"data row5 col18\" >$68.03</td>\n",
       "      <td id=\"T_01fd9_row5_col19\" class=\"data row5 col19\" >42.42%</td>\n",
       "      <td id=\"T_01fd9_row5_col20\" class=\"data row5 col20\" >2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_01fd9_row6_col0\" class=\"data row6 col0\" >SR</td>\n",
       "      <td id=\"T_01fd9_row6_col1\" class=\"data row6 col1\" >Spire Inc.</td>\n",
       "      <td id=\"T_01fd9_row6_col2\" class=\"data row6 col2\" >3.13B</td>\n",
       "      <td id=\"T_01fd9_row6_col3\" class=\"data row6 col3\" >1</td>\n",
       "      <td id=\"T_01fd9_row6_col4\" class=\"data row6 col4\" >1</td>\n",
       "      <td id=\"T_01fd9_row6_col5\" class=\"data row6 col5\" >1</td>\n",
       "      <td id=\"T_01fd9_row6_col6\" class=\"data row6 col6\" >1</td>\n",
       "      <td id=\"T_01fd9_row6_col7\" class=\"data row6 col7\" >1</td>\n",
       "      <td id=\"T_01fd9_row6_col8\" class=\"data row6 col8\" >1</td>\n",
       "      <td id=\"T_01fd9_row6_col9\" class=\"data row6 col9\" >-1</td>\n",
       "      <td id=\"T_01fd9_row6_col10\" class=\"data row6 col10\" >1</td>\n",
       "      <td id=\"T_01fd9_row6_col11\" class=\"data row6 col11\" >-1</td>\n",
       "      <td id=\"T_01fd9_row6_col12\" class=\"data row6 col12\" >-1</td>\n",
       "      <td id=\"T_01fd9_row6_col13\" class=\"data row6 col13\" >-1</td>\n",
       "      <td id=\"T_01fd9_row6_col14\" class=\"data row6 col14\" >5.13%</td>\n",
       "      <td id=\"T_01fd9_row6_col15\" class=\"data row6 col15\" >1</td>\n",
       "      <td id=\"T_01fd9_row6_col16\" class=\"data row6 col16\" >$58.83</td>\n",
       "      <td id=\"T_01fd9_row6_col17\" class=\"data row6 col17\" >$53.77</td>\n",
       "      <td id=\"T_01fd9_row6_col18\" class=\"data row6 col18\" >$75.83</td>\n",
       "      <td id=\"T_01fd9_row6_col19\" class=\"data row6 col19\" >22.94%</td>\n",
       "      <td id=\"T_01fd9_row6_col20\" class=\"data row6 col20\" >4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td id=\"T_01fd9_row7_col0\" class=\"data row7 col0\" >UGI</td>\n",
       "      <td id=\"T_01fd9_row7_col1\" class=\"data row7 col1\" >UGI Corporation</td>\n",
       "      <td id=\"T_01fd9_row7_col2\" class=\"data row7 col2\" >4.81B</td>\n",
       "      <td id=\"T_01fd9_row7_col3\" class=\"data row7 col3\" >-1</td>\n",
       "      <td id=\"T_01fd9_row7_col4\" class=\"data row7 col4\" >2</td>\n",
       "      <td id=\"T_01fd9_row7_col5\" class=\"data row7 col5\" >1</td>\n",
       "      <td id=\"T_01fd9_row7_col6\" class=\"data row7 col6\" >1</td>\n",
       "      <td id=\"T_01fd9_row7_col7\" class=\"data row7 col7\" >-3</td>\n",
       "      <td id=\"T_01fd9_row7_col8\" class=\"data row7 col8\" >-3</td>\n",
       "      <td id=\"T_01fd9_row7_col9\" class=\"data row7 col9\" >1</td>\n",
       "      <td id=\"T_01fd9_row7_col10\" class=\"data row7 col10\" >-1</td>\n",
       "      <td id=\"T_01fd9_row7_col11\" class=\"data row7 col11\" >1</td>\n",
       "      <td id=\"T_01fd9_row7_col12\" class=\"data row7 col12\" >1</td>\n",
       "      <td id=\"T_01fd9_row7_col13\" class=\"data row7 col13\" >3</td>\n",
       "      <td id=\"T_01fd9_row7_col14\" class=\"data row7 col14\" >6.54%</td>\n",
       "      <td id=\"T_01fd9_row7_col15\" class=\"data row7 col15\" >-2</td>\n",
       "      <td id=\"T_01fd9_row7_col16\" class=\"data row7 col16\" >$22.94</td>\n",
       "      <td id=\"T_01fd9_row7_col17\" class=\"data row7 col17\" >$20.19</td>\n",
       "      <td id=\"T_01fd9_row7_col18\" class=\"data row7 col18\" >$43.19</td>\n",
       "      <td id=\"T_01fd9_row7_col19\" class=\"data row7 col19\" >11.96%</td>\n",
       "      <td id=\"T_01fd9_row7_col20\" class=\"data row7 col20\" >0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7fdf13f12410>"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Add table caption and styles to DF\n",
    "df_score.style.pipe(make_pretty).set_caption(f'Stock Screener {industry}').set_table_styles(\n",
    "    [{'selector': 'th.col_heading', 'props': 'text-align: center'},\n",
    "     {'selector': 'caption', 'props': [('text-align', 'center'),\n",
    "                                       ('font-size', '11pt'), ('font-weight', 'bold')]}])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d3b39298-a58f-4bc2-999b-c25733d8d5e2",
   "metadata": {},
   "source": [
    "## Description\n",
    "1. __[EPS](https://www.investopedia.com/terms/e/eps.asp)__ (Earnings Per Share): portion of a company’s profit that is assigned to each share of its stock\n",
    "2. __[PE](https://www.investopedia.com/terms/p/price-earningsratio.asp)__ (Price to Earnings): relationship between the stock price of a company and its per-share earnings. It helps investors determine if a stock is undervalued or overvalued relative to others in the same sector.\n",
    "3. __[PEG](https://www.investopedia.com/terms/p/pegratio.asp)__ (Projected Earnings Growth): - calculated by dividing a stock’s P/E by its projected 12-month forward revenue growth rate. In general, a PEG lower than 1 is a good sign, and a PEG higher than 2 indicates that a stock may be overpriced\n",
    "4. __[PB](https://www.investopedia.com/terms/p/price-to-bookratio.asp)__ (Price to Book): A ratio of 1 indicates the company's shares are trading in line with its book value. A P/B higher than 1 suggests the company is trading at a premium to book value, and lower than 1 indicates a stock that may be undervalued relative to the company's assets.\n",
    "6. __[ROE](https://www.investopedia.com/terms/r/returnonequity.asp)__ (Return on Equity): provides a way for investors to evaluate how effectively a company is using its equity to generate profits. A higher ROE indicates a more efficient use of shareholder equity, which can lead to increased demand for shares and higher stock price, as well as increase in company's profits in the future.\n",
    "7. __[ROCE](https://www.investopedia.com/terms/r/roce.asp)__ (Return on Capital Employed): measures a company’s profitability in terms of all of its capital\n",
    "8. __[FCFY](https://www.investopedia.com/articles/fundamental-analysis/09/free-cash-flow-yield.asp)__ (Free Cash Flow Yield): a financial solvency ratio that compares the free cash flow per share a company is expected to earn against its market value per share. A lower ratio indicates a less attractive investment opportunity.\n",
    "9. __[D2E](https://www.investopedia.com/terms/d/debtequityratio.asp)__ (Debtoi Equity): compares a company's total liabilities with its shareholder equity\n",
    "10. __[CR](https://www.investopedia.com/terms/c/currentratio.asp)__ (Current Ratio): measures a company's ability to pay off its current liabilities (payable within one year) with its current assets such as cash, accounts receivable, and inventories. The higher the ratio, the better the company's liquidity position.\n",
    "11. __[QR](https://www.investopedia.com/terms/q/quickratio.asp)__ (Quick Ratio): measures a company's capacity to pay its current liabilities without needing to sell its inventory or obtain additional financing.\n",
    "12. __[Asset TR](https://en.wikipedia.org/wiki/Asset_turnover)__ (Asset Turnover Ratio): measures the efficiency of a company's assets in generating revenue or sales.\n",
    "13. __[DY](https://www.investopedia.com/terms/d/dividendyield.asp)__ (Dividend Yield Ratio): ratio looks at the amount paid by a company in dividends every year relative to its share price. It is an estimate of the dividend-only return of a stock investment.\n",
    "14. __[Beta](https://www.investopedia.com/terms/b/beta.asp)__: is a measure of a stock's volatility in relation to the overall market. A stock that swings more than the market over time has a beta above 1.0. If a stock moves less than the market, the stock's beta is less than 1.0.\n",
    "15. __52w Range__: a visualization to indicate which stocks are near their 52 week low and which are near their 52 week high. For example, 90% will indicate that the current price is very close to its 52 week high\n",
    "16. __Score__: sum of ratio scores for each stock"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8897d589-ef79-4354-9e57-bd09bce32144",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}