Portfolio-Builder-v.1.0.3.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"provenance":[{"file_id":"1dSPBLa2nB4PBudoCawJw_tCaUhxeZZOJ","timestamp":1670503818522},{"file_id":"1CS-S6qVH4cbdxkamvxBbKxlDAY869Dy3","timestamp":1670496352084}],"authorship_tag":"ABX9TyPYU1wqnX8zwgNUjtMkIEjf"},"kernelspec":{"name":"python3","display_name":"Python 3"},"language_info":{"name":"python"}},"cells":[{"cell_type":"code","source":["# !pip install PyPortfolioOpt"],"metadata":{"id":"xmheWrB9WGpB","executionInfo":{"status":"ok","timestamp":1671018669686,"user_tz":-60,"elapsed":7,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}}},"execution_count":1,"outputs":[]},{"cell_type":"code","execution_count":2,"metadata":{"id":"OPlg3m_oR-EA","executionInfo":{"status":"ok","timestamp":1671018670420,"user_tz":-60,"elapsed":740,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}}},"outputs":[],"source":["import requests\n","import pandas as pd\n","from datetime import datetime as dt\n","from pypfopt import expected_returns, risk_models, EfficientFrontier\n","from pypfopt.discrete_allocation import get_latest_prices, DiscreteAllocation"]},{"cell_type":"code","source":["data = pd.read_csv(\"stock-eight-pillars-202212141141.csv\", index_col=0)"],"metadata":{"id":"41QycoMBSJkD","executionInfo":{"status":"ok","timestamp":1671018670688,"user_tz":-60,"elapsed":272,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}}},"execution_count":3,"outputs":[]},{"cell_type":"code","source":["pillars_to_count = 7"],"metadata":{"id":"8OE9CDp0qWvw","executionInfo":{"status":"ok","timestamp":1671018670689,"user_tz":-60,"elapsed":10,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}}},"execution_count":4,"outputs":[]},{"cell_type":"code","source":["mask = data.apply(lambda x: x.value_counts()).apply(lambda y: y['✔️'] >= pillars_to_count)\n","df = data.T.where(mask).dropna()\n","df"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":485},"id":"UuP436VQSiD0","executionInfo":{"status":"ok","timestamp":1671018671152,"user_tz":-60,"elapsed":472,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}},"outputId":"0528e355-b14c-4864-beff-5dc32c31451b"},"execution_count":5,"outputs":[{"output_type":"execute_result","data":{"text/plain":["     5-Year P/E Ratio < 22.5 5-Year ROIC > 9% 5-Year Revenue Growth (Mil)  \\\n","MMM                       ✔️               ✔️                          ✔️   \n","AOS                       ✔️               ✔️                          ✔️   \n","ABBV                      ✔️               ✔️                          ✔️   \n","ACN                        ❌               ✔️                          ✔️   \n","ADM                       ✔️                ❌                          ✔️   \n","...                      ...              ...                         ...   \n","TRV                       ✔️                ❌                          ✔️   \n","URI                       ✔️               ✔️                          ✔️   \n","UNH                       ✔️               ✔️                          ✔️   \n","WY                        ✔️               ✔️                          ✔️   \n","WHR                       ✔️                ❌                          ✔️   \n","\n","     5-Year Net Income Growth (Mil) 5-Year Shares Outstanding Growth (%)  \\\n","MMM                              ✔️                                   ✔️   \n","AOS                              ✔️                                   ✔️   \n","ABBV                             ✔️                                    ❌   \n","ACN                              ✔️                                   ✔️   \n","ADM                              ✔️                                   ✔️   \n","...                             ...                                  ...   \n","TRV                              ✔️                                   ✔️   \n","URI                              ✔️                                   ✔️   \n","UNH                              ✔️                                   ✔️   \n","WY                               ✔️                                   ✔️   \n","WHR                              ✔️                                   ✔️   \n","\n","     5-Year LTL to FCF < 5 5-Year Free Cash Flow Growth (Mil)  \\\n","MMM                     ✔️                                 ✔️   \n","AOS                     ✔️                                 ✔️   \n","ABBV                    ✔️                                 ✔️   \n","ACN                     ✔️                                 ✔️   \n","ADM                     ✔️                                 ✔️   \n","...                    ...                                ...   \n","TRV                     ✔️                                 ✔️   \n","URI                      ❌                                 ✔️   \n","UNH                     ✔️                                 ✔️   \n","WY                      ✔️                                 ✔️   \n","WHR                     ✔️                                 ✔️   \n","\n","     5-Year Price to FCF < 22.5  \n","MMM                           ❌  \n","AOS                          ✔️  \n","ABBV                         ✔️  \n","ACN                          ✔️  \n","ADM                          ✔️  \n","...                         ...  \n","TRV                          ✔️  \n","URI                          ✔️  \n","UNH                          ✔️  \n","WY                           ✔️  \n","WHR                          ✔️  \n","\n","[76 rows x 8 columns]"],"text/html":["\n","  <div id=\"df-ab86b229-80f2-49bc-b0aa-863c2e45b912\">\n","    <div class=\"colab-df-container\">\n","      <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>5-Year P/E Ratio &lt; 22.5</th>\n","      <th>5-Year ROIC &gt; 9%</th>\n","      <th>5-Year Revenue Growth (Mil)</th>\n","      <th>5-Year Net Income Growth (Mil)</th>\n","      <th>5-Year Shares Outstanding Growth (%)</th>\n","      <th>5-Year LTL to FCF &lt; 5</th>\n","      <th>5-Year Free Cash Flow Growth (Mil)</th>\n","      <th>5-Year Price to FCF &lt; 22.5</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>MMM</th>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>❌</td>\n","    </tr>\n","    <tr>\n","      <th>AOS</th>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","    </tr>\n","    <tr>\n","      <th>ABBV</th>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>❌</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","    </tr>\n","    <tr>\n","      <th>ACN</th>\n","      <td>❌</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","    </tr>\n","    <tr>\n","      <th>ADM</th>\n","      <td>✔️</td>\n","      <td>❌</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>TRV</th>\n","      <td>✔️</td>\n","      <td>❌</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","    </tr>\n","    <tr>\n","      <th>URI</th>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>❌</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","    </tr>\n","    <tr>\n","      <th>UNH</th>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","    </tr>\n","    <tr>\n","      <th>WY</th>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","    </tr>\n","    <tr>\n","      <th>WHR</th>\n","      <td>✔️</td>\n","      <td>❌</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","      <td>✔️</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>76 rows × 8 columns</p>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-ab86b229-80f2-49bc-b0aa-863c2e45b912')\"\n","              title=\"Convert this dataframe to an interactive table.\"\n","              style=\"display:none;\">\n","        \n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","       width=\"24px\">\n","    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n","    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n","  </svg>\n","      </button>\n","      \n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      flex-wrap:wrap;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","      <script>\n","        const buttonEl =\n","          document.querySelector('#df-ab86b229-80f2-49bc-b0aa-863c2e45b912 button.colab-df-convert');\n","        buttonEl.style.display =\n","          google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","        async function convertToInteractive(key) {\n","          const element = document.querySelector('#df-ab86b229-80f2-49bc-b0aa-863c2e45b912');\n","          const dataTable =\n","            await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                     [key], {});\n","          if (!dataTable) return;\n","\n","          const docLinkHtml = 'Like what you see? Visit the ' +\n","            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","            + ' to learn more about interactive tables.';\n","          element.innerHTML = '';\n","          dataTable['output_type'] = 'display_data';\n","          await google.colab.output.renderOutput(dataTable, element);\n","          const docLink = document.createElement('div');\n","          docLink.innerHTML = docLinkHtml;\n","          element.appendChild(docLink);\n","        }\n","      </script>\n","    </div>\n","  </div>\n","  "]},"metadata":{},"execution_count":5}]},{"cell_type":"code","source":["tickers = df.index.to_list()"],"metadata":{"id":"eRhwYerGz9qK","executionInfo":{"status":"ok","timestamp":1671018671153,"user_tz":-60,"elapsed":22,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}}},"execution_count":6,"outputs":[]},{"cell_type":"code","source":["import aiohttp\n","import asyncio\n","\n","\n","headers = {\n","           \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) \\\n","                          AppleWebKit/605.1.15 (KHTML, like Gecko) \\\n","                          Chrome/100.0.4896.127 Safari/605.1.15 Firefox/100.0\"\n","          }\n","\n","\n","def get_price_history(ticker, data):\n","    try:\n","        data = data[\"chart\"][\"result\"][0]\n","        lbls = [dt.fromtimestamp(i).date() for i in data[\"timestamp\"]]\n","        rows = data[\"indicators\"][\"quote\"][0][\"close\"]\n","        df = pd.DataFrame(data=rows, index=lbls, columns=[ticker])\n","    except:\n","        return\n","    return df\n","\n","\n","async def get_response(ticker, session):\n","    url = f\"https://query1.finance.yahoo.com/v8/finance/chart/{ticker}?range=30y&interval=1d\"\n","    async with session.get(url, headers=headers) as response:\n","        data = await response.json()\n","        return get_price_history(ticker, data)\n","\n","\n","async def main(tickers):\n","    async with aiohttp.ClientSession() as session:\n","        return pd.concat(\n","            await asyncio.gather(*[asyncio.create_task(get_response(ticker, session)) for ticker in tickers]),\n","            axis=1\n","        )\n","\n","\n","prices = await main(tickers)\n","prices.dropna(inplace=True)\n","prices"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":488},"id":"9vTEPxesY3FM","executionInfo":{"status":"ok","timestamp":1671018675191,"user_tz":-60,"elapsed":4058,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}},"outputId":"aead7ff3-41e0-4ccc-8158-15eff06076b7"},"execution_count":7,"outputs":[{"output_type":"execute_result","data":{"text/plain":["                   MMM        AOS        ABBV         ACN        ADM  \\\n","2014-09-24  144.880005  24.295000   59.049999   80.199997  51.459999   \n","2014-09-25  142.479996  24.209999   58.000000   78.980003  50.480000   \n","2014-09-26  142.419998  24.250000   59.189999   79.290001  50.869999   \n","2014-09-29  142.190002  24.025000   58.520000   79.919998  51.299999   \n","2014-09-30  141.679993  23.639999   57.759998   81.320000  51.099998   \n","...                ...        ...         ...         ...        ...   \n","2022-12-07  126.349998  59.270000  165.399994  286.690002  93.169998   \n","2022-12-08  126.000000  58.419998  165.990005  292.149994  92.400002   \n","2022-12-09  125.760002  58.299999  163.059998  288.410004  91.879997   \n","2022-12-12  126.849998  58.509998  165.320007  292.339996  93.330002   \n","2022-12-13  127.290001  59.369999  164.789993  295.350006  93.230003   \n","\n","                   AAP        AAPL        AMAT       ACGL          AZO  ...  \\\n","2014-09-24  130.619995   25.437500   21.959999  18.176666   508.630005  ...   \n","2014-09-25  128.199997   24.467501   21.510000  18.056667   504.619995  ...   \n","2014-09-26  130.100006   25.187500   21.740000  18.226667   508.380005  ...   \n","2014-09-29  130.639999   25.027500   21.750000  18.240000   507.839996  ...   \n","2014-09-30  130.300003   25.187500   21.610001  18.240000   509.660004  ...   \n","...                ...         ...         ...        ...          ...  ...   \n","2022-12-07  146.649994  140.940002  106.110001  60.150002  2455.260010  ...   \n","2022-12-08  146.589996  142.649994  108.610001  60.560001  2488.899902  ...   \n","2022-12-09  145.899994  142.160004  107.339996  60.040001  2454.989990  ...   \n","2022-12-12  145.929993  144.490005  109.370003  60.000000  2451.949951  ...   \n","2022-12-13  145.679993  145.470001  111.870003  59.900002  2393.459961  ...   \n","\n","                  TROW        TPR         TGT         TXN        TSCO  \\\n","2014-09-24   79.690002  37.080002   63.880001   48.810001   61.619999   \n","2014-09-25   78.720001  36.279999   62.880001   48.139999   60.650002   \n","2014-09-26   79.199997  36.330002   63.150002   48.330002   61.860001   \n","2014-09-29   78.519997  36.160000   63.040001   48.259998   61.430000   \n","2014-09-30   78.400002  35.610001   62.680000   47.689999   61.509998   \n","...                ...        ...         ...         ...         ...   \n","2022-12-07  121.250000  36.750000  153.759995  173.750000  217.339996   \n","2022-12-08  122.260002  36.930000  154.210007  176.360001  219.520004   \n","2022-12-09  119.830002  36.389999  152.279999  174.259995  218.320007   \n","2022-12-12  120.989998  37.330002  150.029999  177.479996  214.470001   \n","2022-12-13  123.470001  38.360001  150.869995  177.500000  214.199997   \n","\n","                   TRV         URI         UNH         WY         WHR  \n","2014-09-24   94.790001  114.139999   88.209999  32.169998  153.820007  \n","2014-09-25   93.699997  110.980003   86.180000  31.959999  150.529999  \n","2014-09-26   94.400002  112.500000   86.599998  32.320000  150.789993  \n","2014-09-29   93.769997  112.519997   86.510002  32.250000  148.880005  \n","2014-09-30   93.940002  111.099998   86.250000  31.860001  145.649994  \n","...                ...         ...         ...        ...         ...  \n","2022-12-07  188.050003  351.519989  542.909973  31.690001  142.759995  \n","2022-12-08  187.720001  361.640015  547.919983  31.670000  145.360001  \n","2022-12-09  185.649994  352.630005  539.200012  31.480000  143.809998  \n","2022-12-12  187.110001  360.450012  545.859985  32.320000  147.449997  \n","2022-12-13  187.050003  367.019989  538.219971  32.889999  147.470001  \n","\n","[2071 rows x 76 columns]"],"text/html":["\n","  <div id=\"df-0af65edd-e3a0-492c-88b7-05fc694a8919\">\n","    <div class=\"colab-df-container\">\n","      <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>MMM</th>\n","      <th>AOS</th>\n","      <th>ABBV</th>\n","      <th>ACN</th>\n","      <th>ADM</th>\n","      <th>AAP</th>\n","      <th>AAPL</th>\n","      <th>AMAT</th>\n","      <th>ACGL</th>\n","      <th>AZO</th>\n","      <th>...</th>\n","      <th>TROW</th>\n","      <th>TPR</th>\n","      <th>TGT</th>\n","      <th>TXN</th>\n","      <th>TSCO</th>\n","      <th>TRV</th>\n","      <th>URI</th>\n","      <th>UNH</th>\n","      <th>WY</th>\n","      <th>WHR</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>2014-09-24</th>\n","      <td>144.880005</td>\n","      <td>24.295000</td>\n","      <td>59.049999</td>\n","      <td>80.199997</td>\n","      <td>51.459999</td>\n","      <td>130.619995</td>\n","      <td>25.437500</td>\n","      <td>21.959999</td>\n","      <td>18.176666</td>\n","      <td>508.630005</td>\n","      <td>...</td>\n","      <td>79.690002</td>\n","      <td>37.080002</td>\n","      <td>63.880001</td>\n","      <td>48.810001</td>\n","      <td>61.619999</td>\n","      <td>94.790001</td>\n","      <td>114.139999</td>\n","      <td>88.209999</td>\n","      <td>32.169998</td>\n","      <td>153.820007</td>\n","    </tr>\n","    <tr>\n","      <th>2014-09-25</th>\n","      <td>142.479996</td>\n","      <td>24.209999</td>\n","      <td>58.000000</td>\n","      <td>78.980003</td>\n","      <td>50.480000</td>\n","      <td>128.199997</td>\n","      <td>24.467501</td>\n","      <td>21.510000</td>\n","      <td>18.056667</td>\n","      <td>504.619995</td>\n","      <td>...</td>\n","      <td>78.720001</td>\n","      <td>36.279999</td>\n","      <td>62.880001</td>\n","      <td>48.139999</td>\n","      <td>60.650002</td>\n","      <td>93.699997</td>\n","      <td>110.980003</td>\n","      <td>86.180000</td>\n","      <td>31.959999</td>\n","      <td>150.529999</td>\n","    </tr>\n","    <tr>\n","      <th>2014-09-26</th>\n","      <td>142.419998</td>\n","      <td>24.250000</td>\n","      <td>59.189999</td>\n","      <td>79.290001</td>\n","      <td>50.869999</td>\n","      <td>130.100006</td>\n","      <td>25.187500</td>\n","      <td>21.740000</td>\n","      <td>18.226667</td>\n","      <td>508.380005</td>\n","      <td>...</td>\n","      <td>79.199997</td>\n","      <td>36.330002</td>\n","      <td>63.150002</td>\n","      <td>48.330002</td>\n","      <td>61.860001</td>\n","      <td>94.400002</td>\n","      <td>112.500000</td>\n","      <td>86.599998</td>\n","      <td>32.320000</td>\n","      <td>150.789993</td>\n","    </tr>\n","    <tr>\n","      <th>2014-09-29</th>\n","      <td>142.190002</td>\n","      <td>24.025000</td>\n","      <td>58.520000</td>\n","      <td>79.919998</td>\n","      <td>51.299999</td>\n","      <td>130.639999</td>\n","      <td>25.027500</td>\n","      <td>21.750000</td>\n","      <td>18.240000</td>\n","      <td>507.839996</td>\n","      <td>...</td>\n","      <td>78.519997</td>\n","      <td>36.160000</td>\n","      <td>63.040001</td>\n","      <td>48.259998</td>\n","      <td>61.430000</td>\n","      <td>93.769997</td>\n","      <td>112.519997</td>\n","      <td>86.510002</td>\n","      <td>32.250000</td>\n","      <td>148.880005</td>\n","    </tr>\n","    <tr>\n","      <th>2014-09-30</th>\n","      <td>141.679993</td>\n","      <td>23.639999</td>\n","      <td>57.759998</td>\n","      <td>81.320000</td>\n","      <td>51.099998</td>\n","      <td>130.300003</td>\n","      <td>25.187500</td>\n","      <td>21.610001</td>\n","      <td>18.240000</td>\n","      <td>509.660004</td>\n","      <td>...</td>\n","      <td>78.400002</td>\n","      <td>35.610001</td>\n","      <td>62.680000</td>\n","      <td>47.689999</td>\n","      <td>61.509998</td>\n","      <td>93.940002</td>\n","      <td>111.099998</td>\n","      <td>86.250000</td>\n","      <td>31.860001</td>\n","      <td>145.649994</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>2022-12-07</th>\n","      <td>126.349998</td>\n","      <td>59.270000</td>\n","      <td>165.399994</td>\n","      <td>286.690002</td>\n","      <td>93.169998</td>\n","      <td>146.649994</td>\n","      <td>140.940002</td>\n","      <td>106.110001</td>\n","      <td>60.150002</td>\n","      <td>2455.260010</td>\n","      <td>...</td>\n","      <td>121.250000</td>\n","      <td>36.750000</td>\n","      <td>153.759995</td>\n","      <td>173.750000</td>\n","      <td>217.339996</td>\n","      <td>188.050003</td>\n","      <td>351.519989</td>\n","      <td>542.909973</td>\n","      <td>31.690001</td>\n","      <td>142.759995</td>\n","    </tr>\n","    <tr>\n","      <th>2022-12-08</th>\n","      <td>126.000000</td>\n","      <td>58.419998</td>\n","      <td>165.990005</td>\n","      <td>292.149994</td>\n","      <td>92.400002</td>\n","      <td>146.589996</td>\n","      <td>142.649994</td>\n","      <td>108.610001</td>\n","      <td>60.560001</td>\n","      <td>2488.899902</td>\n","      <td>...</td>\n","      <td>122.260002</td>\n","      <td>36.930000</td>\n","      <td>154.210007</td>\n","      <td>176.360001</td>\n","      <td>219.520004</td>\n","      <td>187.720001</td>\n","      <td>361.640015</td>\n","      <td>547.919983</td>\n","      <td>31.670000</td>\n","      <td>145.360001</td>\n","    </tr>\n","    <tr>\n","      <th>2022-12-09</th>\n","      <td>125.760002</td>\n","      <td>58.299999</td>\n","      <td>163.059998</td>\n","      <td>288.410004</td>\n","      <td>91.879997</td>\n","      <td>145.899994</td>\n","      <td>142.160004</td>\n","      <td>107.339996</td>\n","      <td>60.040001</td>\n","      <td>2454.989990</td>\n","      <td>...</td>\n","      <td>119.830002</td>\n","      <td>36.389999</td>\n","      <td>152.279999</td>\n","      <td>174.259995</td>\n","      <td>218.320007</td>\n","      <td>185.649994</td>\n","      <td>352.630005</td>\n","      <td>539.200012</td>\n","      <td>31.480000</td>\n","      <td>143.809998</td>\n","    </tr>\n","    <tr>\n","      <th>2022-12-12</th>\n","      <td>126.849998</td>\n","      <td>58.509998</td>\n","      <td>165.320007</td>\n","      <td>292.339996</td>\n","      <td>93.330002</td>\n","      <td>145.929993</td>\n","      <td>144.490005</td>\n","      <td>109.370003</td>\n","      <td>60.000000</td>\n","      <td>2451.949951</td>\n","      <td>...</td>\n","      <td>120.989998</td>\n","      <td>37.330002</td>\n","      <td>150.029999</td>\n","      <td>177.479996</td>\n","      <td>214.470001</td>\n","      <td>187.110001</td>\n","      <td>360.450012</td>\n","      <td>545.859985</td>\n","      <td>32.320000</td>\n","      <td>147.449997</td>\n","    </tr>\n","    <tr>\n","      <th>2022-12-13</th>\n","      <td>127.290001</td>\n","      <td>59.369999</td>\n","      <td>164.789993</td>\n","      <td>295.350006</td>\n","      <td>93.230003</td>\n","      <td>145.679993</td>\n","      <td>145.470001</td>\n","      <td>111.870003</td>\n","      <td>59.900002</td>\n","      <td>2393.459961</td>\n","      <td>...</td>\n","      <td>123.470001</td>\n","      <td>38.360001</td>\n","      <td>150.869995</td>\n","      <td>177.500000</td>\n","      <td>214.199997</td>\n","      <td>187.050003</td>\n","      <td>367.019989</td>\n","      <td>538.219971</td>\n","      <td>32.889999</td>\n","      <td>147.470001</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>2071 rows × 76 columns</p>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-0af65edd-e3a0-492c-88b7-05fc694a8919')\"\n","              title=\"Convert this dataframe to an interactive table.\"\n","              style=\"display:none;\">\n","        \n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","       width=\"24px\">\n","    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n","    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n","  </svg>\n","      </button>\n","      \n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      flex-wrap:wrap;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","      <script>\n","        const buttonEl =\n","          document.querySelector('#df-0af65edd-e3a0-492c-88b7-05fc694a8919 button.colab-df-convert');\n","        buttonEl.style.display =\n","          google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","        async function convertToInteractive(key) {\n","          const element = document.querySelector('#df-0af65edd-e3a0-492c-88b7-05fc694a8919');\n","          const dataTable =\n","            await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                     [key], {});\n","          if (!dataTable) return;\n","\n","          const docLinkHtml = 'Like what you see? Visit the ' +\n","            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","            + ' to learn more about interactive tables.';\n","          element.innerHTML = '';\n","          dataTable['output_type'] = 'display_data';\n","          await google.colab.output.renderOutput(dataTable, element);\n","          const docLink = document.createElement('div');\n","          docLink.innerHTML = docLinkHtml;\n","          element.appendChild(docLink);\n","        }\n","      </script>\n","    </div>\n","  </div>\n","  "]},"metadata":{},"execution_count":7}]},{"cell_type":"code","source":["mu = expected_returns.mean_historical_return(prices)\n","S = risk_models.sample_cov(prices)\n","\n","ef = EfficientFrontier(mu, S)\n","weights = ef.max_sharpe()\n","cleaned_weights = ef.clean_weights()\n","ef.save_weights_to_file(\"weights.csv\")  # saves to file\n","# print(cleaned_weights)\n","ef.portfolio_performance(verbose=True)"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"QFx5CFBih6bw","executionInfo":{"status":"ok","timestamp":1671018675581,"user_tz":-60,"elapsed":399,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}},"outputId":"5c640549-993b-47cd-b114-d0844bb44052"},"execution_count":8,"outputs":[{"output_type":"stream","name":"stdout","text":["Expected annual return: 22.8%\n","Annual volatility: 20.8%\n","Sharpe Ratio: 1.00\n"]},{"output_type":"execute_result","data":{"text/plain":["(0.22845135597925526, 0.2075331308042113, 1.0044244751259028)"]},"metadata":{},"execution_count":8}]},{"cell_type":"code","source":["latest_prices = get_latest_prices(prices)\n","\n","da = DiscreteAllocation(weights, latest_prices, total_portfolio_value=10000)\n","allocation, leftover = da.greedy_portfolio()\n","print(\"Discrete allocation:\", allocation)\n","print(\"Funds remaining: ${:.2f}\".format(leftover))"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"SWrncxBriLNf","executionInfo":{"status":"ok","timestamp":1671018675581,"user_tz":-60,"elapsed":5,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}},"outputId":"2f54324a-5292-4454-d479-b4a45375c2c1"},"execution_count":9,"outputs":[{"output_type":"stream","name":"stdout","text":["Discrete allocation: {'UNH': 6, 'AAPL': 14, 'ORLY': 2, 'AZO': 1, 'TECH': 4, 'WRB': 4}\n","Funds remaining: $62.88\n"]}]}]}