obb_01-03_basics_screener.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 02.01 Functions\n",
    "\n",
    "> https://docs.openbb.co/sdk/guides/basics#passing-results-to-another-function"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Iterate list\n",
    "\n",
    "> Pass a list of items from one function to a different function."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "from openbb_terminal.sdk import openbb\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Option 1: Manually"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>Ticker</th>\n",
       "      <th>Market Cap</th>\n",
       "      <th>P/E</th>\n",
       "      <th>Fwd P/E</th>\n",
       "      <th>PEG</th>\n",
       "      <th>P/S</th>\n",
       "      <th>P/B</th>\n",
       "      <th>P/C</th>\n",
       "      <th>P/FCF</th>\n",
       "      <th>EPS this Y</th>\n",
       "      <th>EPS next Y</th>\n",
       "      <th>EPS past 5Y</th>\n",
       "      <th>EPS next 5Y</th>\n",
       "      <th>Sales past 5Y</th>\n",
       "      <th>Price</th>\n",
       "      <th>Change</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AAPL</td>\n",
       "      <td>2.341010e+12</td>\n",
       "      <td>24.26</td>\n",
       "      <td>21.74</td>\n",
       "      <td>2.73</td>\n",
       "      <td>5.94</td>\n",
       "      <td>46.84</td>\n",
       "      <td>48.46</td>\n",
       "      <td>24.23</td>\n",
       "      <td>0.089</td>\n",
       "      <td>0.0898</td>\n",
       "      <td>0.216</td>\n",
       "      <td>0.0889</td>\n",
       "      <td>0.115</td>\n",
       "      <td>148.56</td>\n",
       "      <td>0.0036</td>\n",
       "      <td>11088322.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AMZN</td>\n",
       "      <td>9.751400e+11</td>\n",
       "      <td>89.06</td>\n",
       "      <td>57.53</td>\n",
       "      <td>3.43</td>\n",
       "      <td>1.94</td>\n",
       "      <td>7.16</td>\n",
       "      <td>16.62</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.549</td>\n",
       "      <td>0.8239</td>\n",
       "      <td>0.676</td>\n",
       "      <td>0.2600</td>\n",
       "      <td>0.281</td>\n",
       "      <td>96.86</td>\n",
       "      <td>0.0033</td>\n",
       "      <td>11134328.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>DIS</td>\n",
       "      <td>1.736000e+11</td>\n",
       "      <td>55.99</td>\n",
       "      <td>18.29</td>\n",
       "      <td>2.21</td>\n",
       "      <td>2.10</td>\n",
       "      <td>1.93</td>\n",
       "      <td>13.40</td>\n",
       "      <td>111.93</td>\n",
       "      <td>1.707</td>\n",
       "      <td>0.2928</td>\n",
       "      <td>-0.280</td>\n",
       "      <td>0.2534</td>\n",
       "      <td>0.039</td>\n",
       "      <td>97.77</td>\n",
       "      <td>-0.0010</td>\n",
       "      <td>1753659.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>GOOGL</td>\n",
       "      <td>1.290140e+12</td>\n",
       "      <td>20.70</td>\n",
       "      <td>19.23</td>\n",
       "      <td>2.31</td>\n",
       "      <td>4.57</td>\n",
       "      <td>5.18</td>\n",
       "      <td>11.10</td>\n",
       "      <td>20.63</td>\n",
       "      <td>0.914</td>\n",
       "      <td>0.1139</td>\n",
       "      <td>0.321</td>\n",
       "      <td>0.0895</td>\n",
       "      <td>0.233</td>\n",
       "      <td>102.04</td>\n",
       "      <td>0.0104</td>\n",
       "      <td>3997221.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>META</td>\n",
       "      <td>3.109200e+11</td>\n",
       "      <td>11.26</td>\n",
       "      <td>15.11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.63</td>\n",
       "      <td>2.55</td>\n",
       "      <td>7.44</td>\n",
       "      <td>11.82</td>\n",
       "      <td>0.364</td>\n",
       "      <td>-0.1407</td>\n",
       "      <td>0.316</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.337</td>\n",
       "      <td>119.93</td>\n",
       "      <td>0.0155</td>\n",
       "      <td>7345897.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>MSFT</td>\n",
       "      <td>1.882350e+12</td>\n",
       "      <td>27.49</td>\n",
       "      <td>22.82</td>\n",
       "      <td>2.11</td>\n",
       "      <td>9.27</td>\n",
       "      <td>10.96</td>\n",
       "      <td>17.55</td>\n",
       "      <td>42.03</td>\n",
       "      <td>0.198</td>\n",
       "      <td>0.1709</td>\n",
       "      <td>0.243</td>\n",
       "      <td>0.1301</td>\n",
       "      <td>0.155</td>\n",
       "      <td>255.29</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>3686377.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>NFLX</td>\n",
       "      <td>1.337200e+11</td>\n",
       "      <td>28.81</td>\n",
       "      <td>29.11</td>\n",
       "      <td>4.95</td>\n",
       "      <td>4.25</td>\n",
       "      <td>6.62</td>\n",
       "      <td>21.87</td>\n",
       "      <td>186.51</td>\n",
       "      <td>0.813</td>\n",
       "      <td>0.0170</td>\n",
       "      <td>0.905</td>\n",
       "      <td>0.0582</td>\n",
       "      <td>0.275</td>\n",
       "      <td>317.95</td>\n",
       "      <td>0.0406</td>\n",
       "      <td>2564674.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>TSLA</td>\n",
       "      <td>5.702100e+11</td>\n",
       "      <td>59.98</td>\n",
       "      <td>34.54</td>\n",
       "      <td>1.25</td>\n",
       "      <td>7.62</td>\n",
       "      <td>15.37</td>\n",
       "      <td>27.02</td>\n",
       "      <td>35.59</td>\n",
       "      <td>6.692</td>\n",
       "      <td>0.3729</td>\n",
       "      <td>0.486</td>\n",
       "      <td>0.4809</td>\n",
       "      <td>0.504</td>\n",
       "      <td>195.87</td>\n",
       "      <td>0.0060</td>\n",
       "      <td>18915611.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Ticker    Market Cap    P/E  Fwd P/E   PEG   P/S    P/B    P/C   P/FCF  \\\n",
       "0   AAPL  2.341010e+12  24.26    21.74  2.73  5.94  46.84  48.46   24.23   \n",
       "1   AMZN  9.751400e+11  89.06    57.53  3.43  1.94   7.16  16.62     NaN   \n",
       "2    DIS  1.736000e+11  55.99    18.29  2.21  2.10   1.93  13.40  111.93   \n",
       "3  GOOGL  1.290140e+12  20.70    19.23  2.31  4.57   5.18  11.10   20.63   \n",
       "4   META  3.109200e+11  11.26    15.11   NaN  2.63   2.55   7.44   11.82   \n",
       "5   MSFT  1.882350e+12  27.49    22.82  2.11  9.27  10.96  17.55   42.03   \n",
       "6   NFLX  1.337200e+11  28.81    29.11  4.95  4.25   6.62  21.87  186.51   \n",
       "7   TSLA  5.702100e+11  59.98    34.54  1.25  7.62  15.37  27.02   35.59   \n",
       "\n",
       "   EPS this Y  EPS next Y  EPS past 5Y  EPS next 5Y  Sales past 5Y   Price  \\\n",
       "0       0.089      0.0898        0.216       0.0889          0.115  148.56   \n",
       "1       0.549      0.8239        0.676       0.2600          0.281   96.86   \n",
       "2       1.707      0.2928       -0.280       0.2534          0.039   97.77   \n",
       "3       0.914      0.1139        0.321       0.0895          0.233  102.04   \n",
       "4       0.364     -0.1407        0.316          NaN          0.337  119.93   \n",
       "5       0.198      0.1709        0.243       0.1301          0.155  255.29   \n",
       "6       0.813      0.0170        0.905       0.0582          0.275  317.95   \n",
       "7       6.692      0.3729        0.486       0.4809          0.504  195.87   \n",
       "\n",
       "   Change      Volume  \n",
       "0  0.0036  11088322.0  \n",
       "1  0.0033  11134328.0  \n",
       "2 -0.0010   1753659.0  \n",
       "3  0.0104   3997221.0  \n",
       "4  0.0155   7345897.0  \n",
       "5  0.0006   3686377.0  \n",
       "6  0.0406   2564674.0  \n",
       "7  0.0060  18915611.0  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "openbb.stocks.ca.screener(similar = ['AAPL', 'NFLX', 'META', 'AMZN', 'MSFT', 'GOOGL', 'DIS', 'TSLA'], data_type = 'valuation')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Option 2: Programatiacally"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>Name</th>\n",
       "      <th>% Of Etf</th>\n",
       "      <th>Shares</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Symbol</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>AAPL</th>\n",
       "      <td>Apple Inc.</td>\n",
       "      <td>6.40%</td>\n",
       "      <td>169769054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MSFT</th>\n",
       "      <td>Microsoft Corporation</td>\n",
       "      <td>5.38%</td>\n",
       "      <td>83812577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMZN</th>\n",
       "      <td>Amazon.com, Inc.</td>\n",
       "      <td>2.46%</td>\n",
       "      <td>99627185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GOOGL</th>\n",
       "      <td>Alphabet, Inc.</td>\n",
       "      <td>1.71%</td>\n",
       "      <td>67398715</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BRK.B</th>\n",
       "      <td>Berkshire Hathaway Inc.</td>\n",
       "      <td>1.71%</td>\n",
       "      <td>20282728</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>COF</th>\n",
       "      <td>Capital One Financial Corporation</td>\n",
       "      <td>0.12%</td>\n",
       "      <td>4318900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CTAS</th>\n",
       "      <td>Cintas Corporation</td>\n",
       "      <td>0.12%</td>\n",
       "      <td>967820</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NUE</th>\n",
       "      <td>Nucor Corporation</td>\n",
       "      <td>0.12%</td>\n",
       "      <td>2946140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>O</th>\n",
       "      <td>Realty Income Corporation</td>\n",
       "      <td>0.12%</td>\n",
       "      <td>6949177</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MNST</th>\n",
       "      <td>Monster Beverage Corporation</td>\n",
       "      <td>0.12%</td>\n",
       "      <td>4328003</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>200 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     Name % Of Etf     Shares\n",
       "Symbol                                                       \n",
       "AAPL                           Apple Inc.    6.40%  169769054\n",
       "MSFT                Microsoft Corporation    5.38%   83812577\n",
       "AMZN                     Amazon.com, Inc.    2.46%   99627185\n",
       "GOOGL                      Alphabet, Inc.    1.71%   67398715\n",
       "BRK.B             Berkshire Hathaway Inc.    1.71%   20282728\n",
       "...                                   ...      ...        ...\n",
       "COF     Capital One Financial Corporation    0.12%    4318900\n",
       "CTAS                   Cintas Corporation    0.12%     967820\n",
       "NUE                     Nucor Corporation    0.12%    2946140\n",
       "O               Realty Income Corporation    0.12%    6949177\n",
       "MNST         Monster Beverage Corporation    0.12%    4328003\n",
       "\n",
       "[200 rows x 3 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get all symbols from SPY ETF\n",
    "symbols = openbb.etf.holdings('SPY')\n",
    "symbols"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>Tickers</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>MSFT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AMZN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>GOOGL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BRK.B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>GOOG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>UNH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>TSLA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>JNJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>XOM</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Tickers\n",
       "0    AAPL\n",
       "1    MSFT\n",
       "2    AMZN\n",
       "3   GOOGL\n",
       "4   BRK.B\n",
       "5    GOOG\n",
       "6     UNH\n",
       "7    TSLA\n",
       "8     JNJ\n",
       "9     XOM"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get Symbol tickers and display the top 10 items\n",
    "dia_symbols = list(symbols.index.drop(['N/A']))\n",
    "pd.DataFrame(dia_symbols, columns=['Tickers']).head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>Ticker</th>\n",
       "      <th>Market Cap</th>\n",
       "      <th>P/E</th>\n",
       "      <th>Fwd P/E</th>\n",
       "      <th>PEG</th>\n",
       "      <th>P/S</th>\n",
       "      <th>P/B</th>\n",
       "      <th>P/C</th>\n",
       "      <th>P/FCF</th>\n",
       "      <th>EPS this Y</th>\n",
       "      <th>EPS next Y</th>\n",
       "      <th>EPS past 5Y</th>\n",
       "      <th>EPS next 5Y</th>\n",
       "      <th>Sales past 5Y</th>\n",
       "      <th>Price</th>\n",
       "      <th>Change</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A</td>\n",
       "      <td>4.633000e+10</td>\n",
       "      <td>37.08</td>\n",
       "      <td>24.95</td>\n",
       "      <td>3.10</td>\n",
       "      <td>6.76</td>\n",
       "      <td>9.07</td>\n",
       "      <td>43.01</td>\n",
       "      <td>56.91</td>\n",
       "      <td>0.710</td>\n",
       "      <td>0.1083</td>\n",
       "      <td>0.229</td>\n",
       "      <td>0.1197</td>\n",
       "      <td>0.085</td>\n",
       "      <td>155.39</td>\n",
       "      <td>0.0026</td>\n",
       "      <td>155427.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AAPL</td>\n",
       "      <td>2.341010e+12</td>\n",
       "      <td>24.26</td>\n",
       "      <td>21.74</td>\n",
       "      <td>2.73</td>\n",
       "      <td>5.94</td>\n",
       "      <td>46.84</td>\n",
       "      <td>48.46</td>\n",
       "      <td>24.23</td>\n",
       "      <td>0.089</td>\n",
       "      <td>0.0898</td>\n",
       "      <td>0.216</td>\n",
       "      <td>0.0889</td>\n",
       "      <td>0.115</td>\n",
       "      <td>147.25</td>\n",
       "      <td>-0.0053</td>\n",
       "      <td>13852335.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ABBV</td>\n",
       "      <td>2.857600e+11</td>\n",
       "      <td>21.47</td>\n",
       "      <td>13.95</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.94</td>\n",
       "      <td>17.85</td>\n",
       "      <td>24.06</td>\n",
       "      <td>23.68</td>\n",
       "      <td>1.370</td>\n",
       "      <td>-0.1673</td>\n",
       "      <td>0.122</td>\n",
       "      <td>-0.0040</td>\n",
       "      <td>0.170</td>\n",
       "      <td>161.74</td>\n",
       "      <td>0.0034</td>\n",
       "      <td>760927.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ABT</td>\n",
       "      <td>1.855400e+11</td>\n",
       "      <td>24.16</td>\n",
       "      <td>24.53</td>\n",
       "      <td>2.91</td>\n",
       "      <td>4.12</td>\n",
       "      <td>5.29</td>\n",
       "      <td>18.73</td>\n",
       "      <td>35.29</td>\n",
       "      <td>0.570</td>\n",
       "      <td>-0.1606</td>\n",
       "      <td>0.407</td>\n",
       "      <td>0.0830</td>\n",
       "      <td>0.156</td>\n",
       "      <td>108.19</td>\n",
       "      <td>0.0057</td>\n",
       "      <td>525687.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ACN</td>\n",
       "      <td>1.989400e+11</td>\n",
       "      <td>28.09</td>\n",
       "      <td>23.89</td>\n",
       "      <td>2.52</td>\n",
       "      <td>3.23</td>\n",
       "      <td>8.61</td>\n",
       "      <td>25.20</td>\n",
       "      <td>31.24</td>\n",
       "      <td>0.170</td>\n",
       "      <td>0.1090</td>\n",
       "      <td>0.145</td>\n",
       "      <td>0.1116</td>\n",
       "      <td>0.112</td>\n",
       "      <td>303.30</td>\n",
       "      <td>0.0079</td>\n",
       "      <td>208546.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>ADBE</td>\n",
       "      <td>1.580200e+11</td>\n",
       "      <td>34.01</td>\n",
       "      <td>22.68</td>\n",
       "      <td>2.58</td>\n",
       "      <td>9.19</td>\n",
       "      <td>11.25</td>\n",
       "      <td>27.41</td>\n",
       "      <td>22.17</td>\n",
       "      <td>-0.076</td>\n",
       "      <td>0.1157</td>\n",
       "      <td>0.340</td>\n",
       "      <td>0.1319</td>\n",
       "      <td>0.219</td>\n",
       "      <td>347.35</td>\n",
       "      <td>0.0070</td>\n",
       "      <td>495649.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>ADI</td>\n",
       "      <td>8.802000e+10</td>\n",
       "      <td>47.61</td>\n",
       "      <td>16.14</td>\n",
       "      <td>3.20</td>\n",
       "      <td>7.93</td>\n",
       "      <td>2.41</td>\n",
       "      <td>59.85</td>\n",
       "      <td>39.44</td>\n",
       "      <td>0.516</td>\n",
       "      <td>0.0739</td>\n",
       "      <td>0.181</td>\n",
       "      <td>0.1487</td>\n",
       "      <td>0.180</td>\n",
       "      <td>170.99</td>\n",
       "      <td>-0.0054</td>\n",
       "      <td>396328.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>ADM</td>\n",
       "      <td>5.405000e+10</td>\n",
       "      <td>13.46</td>\n",
       "      <td>14.64</td>\n",
       "      <td>1.51</td>\n",
       "      <td>0.55</td>\n",
       "      <td>2.28</td>\n",
       "      <td>49.18</td>\n",
       "      <td>28.31</td>\n",
       "      <td>0.525</td>\n",
       "      <td>-0.1163</td>\n",
       "      <td>0.172</td>\n",
       "      <td>0.0890</td>\n",
       "      <td>0.065</td>\n",
       "      <td>93.81</td>\n",
       "      <td>-0.0378</td>\n",
       "      <td>536020.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>ADP</td>\n",
       "      <td>1.093200e+11</td>\n",
       "      <td>36.59</td>\n",
       "      <td>29.30</td>\n",
       "      <td>2.45</td>\n",
       "      <td>6.48</td>\n",
       "      <td>42.53</td>\n",
       "      <td>88.72</td>\n",
       "      <td>60.29</td>\n",
       "      <td>0.154</td>\n",
       "      <td>0.1108</td>\n",
       "      <td>0.120</td>\n",
       "      <td>0.1496</td>\n",
       "      <td>0.059</td>\n",
       "      <td>268.40</td>\n",
       "      <td>0.0161</td>\n",
       "      <td>193433.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>ADSK</td>\n",
       "      <td>4.621000e+10</td>\n",
       "      <td>71.23</td>\n",
       "      <td>27.30</td>\n",
       "      <td>3.46</td>\n",
       "      <td>9.43</td>\n",
       "      <td>59.22</td>\n",
       "      <td>30.30</td>\n",
       "      <td>29.22</td>\n",
       "      <td>-0.588</td>\n",
       "      <td>0.1206</td>\n",
       "      <td>0.234</td>\n",
       "      <td>0.2057</td>\n",
       "      <td>0.166</td>\n",
       "      <td>206.43</td>\n",
       "      <td>0.0222</td>\n",
       "      <td>255772.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Ticker    Market Cap    P/E  Fwd P/E   PEG   P/S    P/B    P/C  P/FCF  \\\n",
       "0      A  4.633000e+10  37.08    24.95  3.10  6.76   9.07  43.01  56.91   \n",
       "1   AAPL  2.341010e+12  24.26    21.74  2.73  5.94  46.84  48.46  24.23   \n",
       "2   ABBV  2.857600e+11  21.47    13.95   NaN  4.94  17.85  24.06  23.68   \n",
       "3    ABT  1.855400e+11  24.16    24.53  2.91  4.12   5.29  18.73  35.29   \n",
       "4    ACN  1.989400e+11  28.09    23.89  2.52  3.23   8.61  25.20  31.24   \n",
       "5   ADBE  1.580200e+11  34.01    22.68  2.58  9.19  11.25  27.41  22.17   \n",
       "6    ADI  8.802000e+10  47.61    16.14  3.20  7.93   2.41  59.85  39.44   \n",
       "7    ADM  5.405000e+10  13.46    14.64  1.51  0.55   2.28  49.18  28.31   \n",
       "8    ADP  1.093200e+11  36.59    29.30  2.45  6.48  42.53  88.72  60.29   \n",
       "9   ADSK  4.621000e+10  71.23    27.30  3.46  9.43  59.22  30.30  29.22   \n",
       "\n",
       "   EPS this Y  EPS next Y  EPS past 5Y  EPS next 5Y  Sales past 5Y   Price  \\\n",
       "0       0.710      0.1083        0.229       0.1197          0.085  155.39   \n",
       "1       0.089      0.0898        0.216       0.0889          0.115  147.25   \n",
       "2       1.370     -0.1673        0.122      -0.0040          0.170  161.74   \n",
       "3       0.570     -0.1606        0.407       0.0830          0.156  108.19   \n",
       "4       0.170      0.1090        0.145       0.1116          0.112  303.30   \n",
       "5      -0.076      0.1157        0.340       0.1319          0.219  347.35   \n",
       "6       0.516      0.0739        0.181       0.1487          0.180  170.99   \n",
       "7       0.525     -0.1163        0.172       0.0890          0.065   93.81   \n",
       "8       0.154      0.1108        0.120       0.1496          0.059  268.40   \n",
       "9      -0.588      0.1206        0.234       0.2057          0.166  206.43   \n",
       "\n",
       "   Change      Volume  \n",
       "0  0.0026    155427.0  \n",
       "1 -0.0053  13852335.0  \n",
       "2  0.0034    760927.0  \n",
       "3  0.0057    525687.0  \n",
       "4  0.0079    208546.0  \n",
       "5  0.0070    495649.0  \n",
       "6 -0.0054    396328.0  \n",
       "7 -0.0378    536020.0  \n",
       "8  0.0161    193433.0  \n",
       "9  0.0222    255772.0  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Pass list from step above as input to screener and display the top 10 items\n",
    "dia_valuation = openbb.stocks.ca.screener(similar = dia_symbols, data_type = 'valuation')\n",
    "dia_valuation.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>Ticker</th>\n",
       "      <th>Market Cap</th>\n",
       "      <th>P/E</th>\n",
       "      <th>Fwd P/E</th>\n",
       "      <th>PEG</th>\n",
       "      <th>P/S</th>\n",
       "      <th>P/B</th>\n",
       "      <th>P/C</th>\n",
       "      <th>P/FCF</th>\n",
       "      <th>EPS this Y</th>\n",
       "      <th>EPS next Y</th>\n",
       "      <th>EPS past 5Y</th>\n",
       "      <th>EPS next 5Y</th>\n",
       "      <th>Sales past 5Y</th>\n",
       "      <th>Price</th>\n",
       "      <th>Change</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>AZO</td>\n",
       "      <td>49180000000.0</td>\n",
       "      <td>21.85</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.65</td>\n",
       "      <td>3.03</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>186.01</td>\n",
       "      <td>19.37</td>\n",
       "      <td>0.231</td>\n",
       "      <td>0.1564</td>\n",
       "      <td>0.216</td>\n",
       "      <td>0.1325</td>\n",
       "      <td>0.083</td>\n",
       "      <td>2573.88</td>\n",
       "      <td>-0.002</td>\n",
       "      <td>18179</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>BKNG</td>\n",
       "      <td>79750000000.0</td>\n",
       "      <td>34.14</td>\n",
       "      <td>17.11</td>\n",
       "      <td>0.67</td>\n",
       "      <td>4.98</td>\n",
       "      <td>22.42</td>\n",
       "      <td>8.73</td>\n",
       "      <td>18.69</td>\n",
       "      <td>1.131</td>\n",
       "      <td>0.246</td>\n",
       "      <td>-0.08</td>\n",
       "      <td>0.5095</td>\n",
       "      <td>0.004</td>\n",
       "      <td>2091.74</td>\n",
       "      <td>0.0059</td>\n",
       "      <td>48155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>CMG</td>\n",
       "      <td>45020000000.0</td>\n",
       "      <td>56.63</td>\n",
       "      <td>37.77</td>\n",
       "      <td>2.07</td>\n",
       "      <td>5.35</td>\n",
       "      <td>19.41</td>\n",
       "      <td>57.43</td>\n",
       "      <td>49.88</td>\n",
       "      <td>0.829</td>\n",
       "      <td>0.2894</td>\n",
       "      <td>0.971</td>\n",
       "      <td>0.274</td>\n",
       "      <td>0.141</td>\n",
       "      <td>1625.23</td>\n",
       "      <td>-0.0011</td>\n",
       "      <td>51446</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>ORLY</td>\n",
       "      <td>54180000000.0</td>\n",
       "      <td>26.39</td>\n",
       "      <td>23.32</td>\n",
       "      <td>2.42</td>\n",
       "      <td>3.85</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>807.46</td>\n",
       "      <td>21.64</td>\n",
       "      <td>0.321</td>\n",
       "      <td>0.131</td>\n",
       "      <td>0.237</td>\n",
       "      <td>0.109</td>\n",
       "      <td>0.092</td>\n",
       "      <td>859.44</td>\n",
       "      <td>-0.0059</td>\n",
       "      <td>34454</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>REGN</td>\n",
       "      <td>83410000000.0</td>\n",
       "      <td>15.86</td>\n",
       "      <td>17.96</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>6.08</td>\n",
       "      <td>3.75</td>\n",
       "      <td>11.88</td>\n",
       "      <td>16.44</td>\n",
       "      <td>1.358</td>\n",
       "      <td>-0.0274</td>\n",
       "      <td>0.564</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>0.27</td>\n",
       "      <td>753.66</td>\n",
       "      <td>0.0026</td>\n",
       "      <td>47625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>BLK</td>\n",
       "      <td>107120000000.0</td>\n",
       "      <td>19.73</td>\n",
       "      <td>21.3</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>5.75</td>\n",
       "      <td>2.9</td>\n",
       "      <td>15.76</td>\n",
       "      <td>71.94</td>\n",
       "      <td>0.2</td>\n",
       "      <td>-0.0156</td>\n",
       "      <td>0.15</td>\n",
       "      <td>-0.0084</td>\n",
       "      <td>0.096</td>\n",
       "      <td>719.84</td>\n",
       "      <td>0.0054</td>\n",
       "      <td>90205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>EQIX</td>\n",
       "      <td>62420000000.0</td>\n",
       "      <td>90.39</td>\n",
       "      <td>77.21</td>\n",
       "      <td>3.48</td>\n",
       "      <td>8.79</td>\n",
       "      <td>5.69</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>0.323</td>\n",
       "      <td>0.125</td>\n",
       "      <td>0.279</td>\n",
       "      <td>0.26</td>\n",
       "      <td>0.129</td>\n",
       "      <td>704.78</td>\n",
       "      <td>0.0205</td>\n",
       "      <td>60304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>TMO</td>\n",
       "      <td>218700000000.0</td>\n",
       "      <td>31.49</td>\n",
       "      <td>24.09</td>\n",
       "      <td>7.02</td>\n",
       "      <td>4.95</td>\n",
       "      <td>5.04</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>42.39</td>\n",
       "      <td>0.218</td>\n",
       "      <td>0.0099</td>\n",
       "      <td>0.307</td>\n",
       "      <td>0.0449</td>\n",
       "      <td>0.165</td>\n",
       "      <td>563.09</td>\n",
       "      <td>0.0051</td>\n",
       "      <td>137131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>AVGO</td>\n",
       "      <td>232330000000.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>13.6</td>\n",
       "      <td>1.58</td>\n",
       "      <td>7.33</td>\n",
       "      <td>10.69</td>\n",
       "      <td>23.29</td>\n",
       "      <td>27.35</td>\n",
       "      <td>1.371</td>\n",
       "      <td>0.0821</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.152</td>\n",
       "      <td>0.157</td>\n",
       "      <td>549.41</td>\n",
       "      <td>-0.0029</td>\n",
       "      <td>193592</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>HUM</td>\n",
       "      <td>68650000000.000008</td>\n",
       "      <td>24.94</td>\n",
       "      <td>19.61</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0.75</td>\n",
       "      <td>4.28</td>\n",
       "      <td>5.06</td>\n",
       "      <td>8.58</td>\n",
       "      <td>-0.105</td>\n",
       "      <td>0.1185</td>\n",
       "      <td>0.41</td>\n",
       "      <td>0.1471</td>\n",
       "      <td>0.088</td>\n",
       "      <td>545.96</td>\n",
       "      <td>-0.0072</td>\n",
       "      <td>183838</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Ticker          Market Cap    P/E  Fwd P/E   PEG   P/S    P/B     P/C  \\\n",
       "25     AZO       49180000000.0  21.85     18.0  1.65  3.03   <NA>  186.01   \n",
       "30    BKNG       79750000000.0  34.14    17.11  0.67  4.98  22.42    8.73   \n",
       "44     CMG       45020000000.0  56.63    37.77  2.07  5.35  19.41   57.43   \n",
       "143   ORLY       54180000000.0  26.39    23.32  2.42  3.85   <NA>  807.46   \n",
       "158   REGN       83410000000.0  15.86    17.96  <NA>  6.08   3.75   11.88   \n",
       "31     BLK      107120000000.0  19.73     21.3  <NA>  5.75    2.9   15.76   \n",
       "69    EQIX       62420000000.0  90.39    77.21  3.48  8.79   5.69    <NA>   \n",
       "178    TMO      218700000000.0  31.49    24.09  7.02  4.95   5.04    <NA>   \n",
       "23    AVGO      232330000000.0   24.0     13.6  1.58  7.33  10.69   23.29   \n",
       "90     HUM  68650000000.000008  24.94    19.61   1.7  0.75   4.28    5.06   \n",
       "\n",
       "     P/FCF  EPS this Y  EPS next Y  EPS past 5Y  EPS next 5Y  Sales past 5Y  \\\n",
       "25   19.37       0.231      0.1564        0.216       0.1325          0.083   \n",
       "30   18.69       1.131       0.246        -0.08       0.5095          0.004   \n",
       "44   49.88       0.829      0.2894        0.971        0.274          0.141   \n",
       "143  21.64       0.321       0.131        0.237        0.109          0.092   \n",
       "158  16.44       1.358     -0.0274        0.564         <NA>           0.27   \n",
       "31   71.94         0.2     -0.0156         0.15      -0.0084          0.096   \n",
       "69    <NA>       0.323       0.125        0.279         0.26          0.129   \n",
       "178  42.39       0.218      0.0099        0.307       0.0449          0.165   \n",
       "23   27.35       1.371      0.0821          0.4        0.152          0.157   \n",
       "90    8.58      -0.105      0.1185         0.41       0.1471          0.088   \n",
       "\n",
       "       Price  Change  Volume  \n",
       "25   2573.88  -0.002   18179  \n",
       "30   2091.74  0.0059   48155  \n",
       "44   1625.23 -0.0011   51446  \n",
       "143   859.44 -0.0059   34454  \n",
       "158   753.66  0.0026   47625  \n",
       "31    719.84  0.0054   90205  \n",
       "69    704.78  0.0205   60304  \n",
       "178   563.09  0.0051  137131  \n",
       "23    549.41 -0.0029  193592  \n",
       "90    545.96 -0.0072  183838  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Sort dataframe from screener based on Price and display the top 10 items\n",
    "dia_valuation_price = dia_valuation.sort_values(by = ['Price'], ascending = False).convert_dtypes()\n",
    "dia_valuation_price.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>Ticker</th>\n",
       "      <th>Market Cap</th>\n",
       "      <th>P/E</th>\n",
       "      <th>Fwd P/E</th>\n",
       "      <th>PEG</th>\n",
       "      <th>P/S</th>\n",
       "      <th>P/B</th>\n",
       "      <th>P/C</th>\n",
       "      <th>P/FCF</th>\n",
       "      <th>EPS this Y</th>\n",
       "      <th>EPS next Y</th>\n",
       "      <th>EPS past 5Y</th>\n",
       "      <th>EPS next 5Y</th>\n",
       "      <th>Sales past 5Y</th>\n",
       "      <th>Price</th>\n",
       "      <th>Change</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AAPL</td>\n",
       "      <td>2341010000000.0</td>\n",
       "      <td>24.26</td>\n",
       "      <td>21.74</td>\n",
       "      <td>2.73</td>\n",
       "      <td>5.94</td>\n",
       "      <td>46.84</td>\n",
       "      <td>48.46</td>\n",
       "      <td>24.23</td>\n",
       "      <td>0.089</td>\n",
       "      <td>0.0898</td>\n",
       "      <td>0.216</td>\n",
       "      <td>0.0889</td>\n",
       "      <td>0.115</td>\n",
       "      <td>147.81</td>\n",
       "      <td>-0.0015</td>\n",
       "      <td>12356102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>MSFT</td>\n",
       "      <td>1882350000000.0</td>\n",
       "      <td>27.49</td>\n",
       "      <td>22.82</td>\n",
       "      <td>2.11</td>\n",
       "      <td>9.27</td>\n",
       "      <td>10.96</td>\n",
       "      <td>17.55</td>\n",
       "      <td>42.03</td>\n",
       "      <td>0.198</td>\n",
       "      <td>0.1709</td>\n",
       "      <td>0.243</td>\n",
       "      <td>0.1301</td>\n",
       "      <td>0.155</td>\n",
       "      <td>254.23</td>\n",
       "      <td>-0.0036</td>\n",
       "      <td>4031850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>GOOG</td>\n",
       "      <td>1312070000000.0</td>\n",
       "      <td>19.85</td>\n",
       "      <td>19.18</td>\n",
       "      <td>2.22</td>\n",
       "      <td>4.65</td>\n",
       "      <td>5.19</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>-0.159</td>\n",
       "      <td>0.121</td>\n",
       "      <td>0.2848</td>\n",
       "      <td>0.0895</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>101.9</td>\n",
       "      <td>0.0044</td>\n",
       "      <td>3555759</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>GOOGL</td>\n",
       "      <td>1290140000000.0</td>\n",
       "      <td>20.7</td>\n",
       "      <td>19.23</td>\n",
       "      <td>2.31</td>\n",
       "      <td>4.57</td>\n",
       "      <td>5.18</td>\n",
       "      <td>11.1</td>\n",
       "      <td>20.63</td>\n",
       "      <td>0.914</td>\n",
       "      <td>0.1139</td>\n",
       "      <td>0.321</td>\n",
       "      <td>0.0895</td>\n",
       "      <td>0.233</td>\n",
       "      <td>101.54</td>\n",
       "      <td>0.0054</td>\n",
       "      <td>4397398</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>AMZN</td>\n",
       "      <td>975140000000.0</td>\n",
       "      <td>89.06</td>\n",
       "      <td>57.53</td>\n",
       "      <td>3.43</td>\n",
       "      <td>1.94</td>\n",
       "      <td>7.16</td>\n",
       "      <td>16.62</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>0.549</td>\n",
       "      <td>0.8239</td>\n",
       "      <td>0.676</td>\n",
       "      <td>0.26</td>\n",
       "      <td>0.281</td>\n",
       "      <td>96.76</td>\n",
       "      <td>0.0023</td>\n",
       "      <td>12082437</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>TSLA</td>\n",
       "      <td>570210000000.0</td>\n",
       "      <td>59.98</td>\n",
       "      <td>34.54</td>\n",
       "      <td>1.25</td>\n",
       "      <td>7.62</td>\n",
       "      <td>15.37</td>\n",
       "      <td>27.02</td>\n",
       "      <td>35.59</td>\n",
       "      <td>6.692</td>\n",
       "      <td>0.3729</td>\n",
       "      <td>0.486</td>\n",
       "      <td>0.4809</td>\n",
       "      <td>0.504</td>\n",
       "      <td>195.54</td>\n",
       "      <td>0.0043</td>\n",
       "      <td>20034869</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>UNH</td>\n",
       "      <td>505400000000.0</td>\n",
       "      <td>26.83</td>\n",
       "      <td>21.96</td>\n",
       "      <td>1.89</td>\n",
       "      <td>1.6</td>\n",
       "      <td>6.86</td>\n",
       "      <td>13.01</td>\n",
       "      <td>19.81</td>\n",
       "      <td>0.128</td>\n",
       "      <td>0.1321</td>\n",
       "      <td>0.201</td>\n",
       "      <td>0.1422</td>\n",
       "      <td>0.092</td>\n",
       "      <td>542.56</td>\n",
       "      <td>-0.0095</td>\n",
       "      <td>398103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>JNJ</td>\n",
       "      <td>464880000000.0</td>\n",
       "      <td>24.78</td>\n",
       "      <td>17.17</td>\n",
       "      <td>6.79</td>\n",
       "      <td>4.84</td>\n",
       "      <td>6.27</td>\n",
       "      <td>13.64</td>\n",
       "      <td>74.74</td>\n",
       "      <td>0.447</td>\n",
       "      <td>0.0319</td>\n",
       "      <td>0.057</td>\n",
       "      <td>0.0365</td>\n",
       "      <td>0.055</td>\n",
       "      <td>178.21</td>\n",
       "      <td>0.0012</td>\n",
       "      <td>890952</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>XOM</td>\n",
       "      <td>460800000000.0</td>\n",
       "      <td>9.08</td>\n",
       "      <td>9.74</td>\n",
       "      <td>0.35</td>\n",
       "      <td>1.19</td>\n",
       "      <td>2.5</td>\n",
       "      <td>15.15</td>\n",
       "      <td>10.32</td>\n",
       "      <td>2.022</td>\n",
       "      <td>-0.1786</td>\n",
       "      <td>0.234</td>\n",
       "      <td>0.258</td>\n",
       "      <td>0.066</td>\n",
       "      <td>111.3</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>1910321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>WMT</td>\n",
       "      <td>411720000000.0</td>\n",
       "      <td>47.1</td>\n",
       "      <td>23.16</td>\n",
       "      <td>10.84</td>\n",
       "      <td>0.69</td>\n",
       "      <td>5.38</td>\n",
       "      <td>29.57</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>0.027</td>\n",
       "      <td>0.0844</td>\n",
       "      <td>0.021</td>\n",
       "      <td>0.0434</td>\n",
       "      <td>0.033</td>\n",
       "      <td>151.15</td>\n",
       "      <td>-0.0083</td>\n",
       "      <td>1108588</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Ticker       Market Cap    P/E  Fwd P/E    PEG   P/S    P/B    P/C  P/FCF  \\\n",
       "1     AAPL  2341010000000.0  24.26    21.74   2.73  5.94  46.84  48.46  24.23   \n",
       "129   MSFT  1882350000000.0  27.49    22.82   2.11  9.27  10.96  17.55  42.03   \n",
       "83    GOOG  1312070000000.0  19.85    19.18   2.22  4.65   5.19   <NA>   <NA>   \n",
       "84   GOOGL  1290140000000.0   20.7    19.23   2.31  4.57   5.18   11.1  20.63   \n",
       "18    AMZN   975140000000.0  89.06    57.53   3.43  1.94   7.16  16.62   <NA>   \n",
       "181   TSLA   570210000000.0  59.98    34.54   1.25  7.62  15.37  27.02  35.59   \n",
       "184    UNH   505400000000.0  26.83    21.96   1.89   1.6   6.86  13.01  19.81   \n",
       "99     JNJ   464880000000.0  24.78    17.17   6.79  4.84   6.27  13.64  74.74   \n",
       "196    XOM   460800000000.0   9.08     9.74   0.35  1.19    2.5  15.15  10.32   \n",
       "195    WMT   411720000000.0   47.1    23.16  10.84  0.69   5.38  29.57   <NA>   \n",
       "\n",
       "     EPS this Y  EPS next Y  EPS past 5Y  EPS next 5Y  Sales past 5Y   Price  \\\n",
       "1         0.089      0.0898        0.216       0.0889          0.115  147.81   \n",
       "129       0.198      0.1709        0.243       0.1301          0.155  254.23   \n",
       "83       -0.159       0.121       0.2848       0.0895           <NA>   101.9   \n",
       "84        0.914      0.1139        0.321       0.0895          0.233  101.54   \n",
       "18        0.549      0.8239        0.676         0.26          0.281   96.76   \n",
       "181       6.692      0.3729        0.486       0.4809          0.504  195.54   \n",
       "184       0.128      0.1321        0.201       0.1422          0.092  542.56   \n",
       "99        0.447      0.0319        0.057       0.0365          0.055  178.21   \n",
       "196       2.022     -0.1786        0.234        0.258          0.066   111.3   \n",
       "195       0.027      0.0844        0.021       0.0434          0.033  151.15   \n",
       "\n",
       "     Change    Volume  \n",
       "1   -0.0015  12356102  \n",
       "129 -0.0036   4031850  \n",
       "83   0.0044   3555759  \n",
       "84   0.0054   4397398  \n",
       "18   0.0023  12082437  \n",
       "181  0.0043  20034869  \n",
       "184 -0.0095    398103  \n",
       "99   0.0012    890952  \n",
       "196 -0.0004   1910321  \n",
       "195 -0.0083   1108588  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Sort dataframe from screener based on Market Cap and display the top 10 items\n",
    "dia_valuation_cap = dia_valuation.sort_values(by = ['Market Cap'], ascending = False).convert_dtypes()\n",
    "dia_valuation_cap.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>Ticker</th>\n",
       "      <th>Market Cap</th>\n",
       "      <th>P/E</th>\n",
       "      <th>Fwd P/E</th>\n",
       "      <th>PEG</th>\n",
       "      <th>P/S</th>\n",
       "      <th>P/B</th>\n",
       "      <th>P/C</th>\n",
       "      <th>P/FCF</th>\n",
       "      <th>EPS this Y</th>\n",
       "      <th>EPS next Y</th>\n",
       "      <th>EPS past 5Y</th>\n",
       "      <th>EPS next 5Y</th>\n",
       "      <th>Sales past 5Y</th>\n",
       "      <th>Price</th>\n",
       "      <th>Change</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>TSLA</td>\n",
       "      <td>570210000000.0</td>\n",
       "      <td>59.98</td>\n",
       "      <td>34.54</td>\n",
       "      <td>1.25</td>\n",
       "      <td>7.62</td>\n",
       "      <td>15.37</td>\n",
       "      <td>27.02</td>\n",
       "      <td>35.59</td>\n",
       "      <td>6.692</td>\n",
       "      <td>0.3729</td>\n",
       "      <td>0.486</td>\n",
       "      <td>0.4809</td>\n",
       "      <td>0.504</td>\n",
       "      <td>195.54</td>\n",
       "      <td>0.0043</td>\n",
       "      <td>20034869</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AAPL</td>\n",
       "      <td>2341010000000.0</td>\n",
       "      <td>24.26</td>\n",
       "      <td>21.74</td>\n",
       "      <td>2.73</td>\n",
       "      <td>5.94</td>\n",
       "      <td>46.84</td>\n",
       "      <td>48.46</td>\n",
       "      <td>24.23</td>\n",
       "      <td>0.089</td>\n",
       "      <td>0.0898</td>\n",
       "      <td>0.216</td>\n",
       "      <td>0.0889</td>\n",
       "      <td>0.115</td>\n",
       "      <td>147.81</td>\n",
       "      <td>-0.0015</td>\n",
       "      <td>12356102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>AMZN</td>\n",
       "      <td>975140000000.0</td>\n",
       "      <td>89.06</td>\n",
       "      <td>57.53</td>\n",
       "      <td>3.43</td>\n",
       "      <td>1.94</td>\n",
       "      <td>7.16</td>\n",
       "      <td>16.62</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>0.549</td>\n",
       "      <td>0.8239</td>\n",
       "      <td>0.676</td>\n",
       "      <td>0.26</td>\n",
       "      <td>0.281</td>\n",
       "      <td>96.76</td>\n",
       "      <td>0.0023</td>\n",
       "      <td>12082437</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>AMD</td>\n",
       "      <td>123280000000.0</td>\n",
       "      <td>46.54</td>\n",
       "      <td>21.25</td>\n",
       "      <td>3.15</td>\n",
       "      <td>5.4</td>\n",
       "      <td>2.3</td>\n",
       "      <td>22.05</td>\n",
       "      <td>36.17</td>\n",
       "      <td>0.247</td>\n",
       "      <td>0.0387</td>\n",
       "      <td>0.446</td>\n",
       "      <td>0.1479</td>\n",
       "      <td>0.309</td>\n",
       "      <td>78.29</td>\n",
       "      <td>0.0085</td>\n",
       "      <td>11421805</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>F</td>\n",
       "      <td>56040000000.0</td>\n",
       "      <td>6.28</td>\n",
       "      <td>8.13</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0.37</td>\n",
       "      <td>1.33</td>\n",
       "      <td>1.4</td>\n",
       "      <td>68.1</td>\n",
       "      <td>0.252</td>\n",
       "      <td>-0.1416</td>\n",
       "      <td>0.311</td>\n",
       "      <td>0.0833</td>\n",
       "      <td>-0.021</td>\n",
       "      <td>14.3</td>\n",
       "      <td>0.0284</td>\n",
       "      <td>9781768</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>CRM</td>\n",
       "      <td>157100000000.0</td>\n",
       "      <td>299.53</td>\n",
       "      <td>28.54</td>\n",
       "      <td>19.9</td>\n",
       "      <td>5.36</td>\n",
       "      <td>2.66</td>\n",
       "      <td>11.61</td>\n",
       "      <td>27.65</td>\n",
       "      <td>-0.663</td>\n",
       "      <td>0.1866</td>\n",
       "      <td>0.263</td>\n",
       "      <td>0.1505</td>\n",
       "      <td>0.257</td>\n",
       "      <td>143.93</td>\n",
       "      <td>-0.1018</td>\n",
       "      <td>9626199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>NVDA</td>\n",
       "      <td>404180000000.0</td>\n",
       "      <td>71.98</td>\n",
       "      <td>39.0</td>\n",
       "      <td>3.38</td>\n",
       "      <td>14.15</td>\n",
       "      <td>19.68</td>\n",
       "      <td>30.75</td>\n",
       "      <td>91.28</td>\n",
       "      <td>1.231</td>\n",
       "      <td>0.331</td>\n",
       "      <td>0.431</td>\n",
       "      <td>0.213</td>\n",
       "      <td>0.313</td>\n",
       "      <td>170.56</td>\n",
       "      <td>0.0079</td>\n",
       "      <td>8678032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>META</td>\n",
       "      <td>310920000000.0</td>\n",
       "      <td>11.26</td>\n",
       "      <td>15.11</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2.63</td>\n",
       "      <td>2.55</td>\n",
       "      <td>7.44</td>\n",
       "      <td>11.82</td>\n",
       "      <td>0.364</td>\n",
       "      <td>-0.1407</td>\n",
       "      <td>0.316</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>0.337</td>\n",
       "      <td>119.89</td>\n",
       "      <td>0.0152</td>\n",
       "      <td>7837281</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>BAC</td>\n",
       "      <td>302680000000.0</td>\n",
       "      <td>11.97</td>\n",
       "      <td>10.18</td>\n",
       "      <td>2.02</td>\n",
       "      <td>5.04</td>\n",
       "      <td>1.28</td>\n",
       "      <td>0.35</td>\n",
       "      <td>729.35</td>\n",
       "      <td>0.907</td>\n",
       "      <td>0.1629</td>\n",
       "      <td>0.191</td>\n",
       "      <td>0.0593</td>\n",
       "      <td>-0.014</td>\n",
       "      <td>36.94</td>\n",
       "      <td>-0.024</td>\n",
       "      <td>5169290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>INTC</td>\n",
       "      <td>124730000000.0</td>\n",
       "      <td>9.28</td>\n",
       "      <td>16.02</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>1.79</td>\n",
       "      <td>1.24</td>\n",
       "      <td>5.53</td>\n",
       "      <td>17.97</td>\n",
       "      <td>-0.016</td>\n",
       "      <td>-0.0404</td>\n",
       "      <td>0.181</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>0.059</td>\n",
       "      <td>30.02</td>\n",
       "      <td>-0.0017</td>\n",
       "      <td>4888871</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Ticker       Market Cap     P/E  Fwd P/E   PEG    P/S    P/B    P/C  \\\n",
       "181   TSLA   570210000000.0   59.98    34.54  1.25   7.62  15.37  27.02   \n",
       "1     AAPL  2341010000000.0   24.26    21.74  2.73   5.94  46.84  48.46   \n",
       "18    AMZN   975140000000.0   89.06    57.53  3.43   1.94   7.16  16.62   \n",
       "15     AMD   123280000000.0   46.54    21.25  3.15    5.4    2.3  22.05   \n",
       "73       F    56040000000.0    6.28     8.13  0.75   0.37   1.33    1.4   \n",
       "49     CRM   157100000000.0  299.53    28.54  19.9   5.36   2.66  11.61   \n",
       "139   NVDA   404180000000.0   71.98     39.0  3.38  14.15  19.68  30.75   \n",
       "119   META   310920000000.0   11.26    15.11  <NA>   2.63   2.55   7.44   \n",
       "27     BAC   302680000000.0   11.97    10.18  2.02   5.04   1.28   0.35   \n",
       "93    INTC   124730000000.0    9.28    16.02  <NA>   1.79   1.24   5.53   \n",
       "\n",
       "      P/FCF  EPS this Y  EPS next Y  EPS past 5Y  EPS next 5Y  Sales past 5Y  \\\n",
       "181   35.59       6.692      0.3729        0.486       0.4809          0.504   \n",
       "1     24.23       0.089      0.0898        0.216       0.0889          0.115   \n",
       "18     <NA>       0.549      0.8239        0.676         0.26          0.281   \n",
       "15    36.17       0.247      0.0387        0.446       0.1479          0.309   \n",
       "73     68.1       0.252     -0.1416        0.311       0.0833         -0.021   \n",
       "49    27.65      -0.663      0.1866        0.263       0.1505          0.257   \n",
       "139   91.28       1.231       0.331        0.431        0.213          0.313   \n",
       "119   11.82       0.364     -0.1407        0.316         <NA>          0.337   \n",
       "27   729.35       0.907      0.1629        0.191       0.0593         -0.014   \n",
       "93    17.97      -0.016     -0.0404        0.181         <NA>          0.059   \n",
       "\n",
       "      Price  Change    Volume  \n",
       "181  195.54  0.0043  20034869  \n",
       "1    147.81 -0.0015  12356102  \n",
       "18    96.76  0.0023  12082437  \n",
       "15    78.29  0.0085  11421805  \n",
       "73     14.3  0.0284   9781768  \n",
       "49   143.93 -0.1018   9626199  \n",
       "139  170.56  0.0079   8678032  \n",
       "119  119.89  0.0152   7837281  \n",
       "27    36.94  -0.024   5169290  \n",
       "93    30.02 -0.0017   4888871  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Sort dataframe from screener based on Change in Volume and display the top 10 items\n",
    "dia_valuation_cap = dia_valuation.sort_values(by = ['Volume'], ascending = False).convert_dtypes()\n",
    "dia_valuation_cap.head(10)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.9.6 (default, Aug 18 2021, 19:38:01) \n[GCC 7.5.0]"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "da68105485710cf10a6d49297648d33d812a8aaee3ebc1423327d3127c586267"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}