{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Riskfolio-Lib Tutorial: \n",
"
\n",
"
\n",
"
\n",
"\n",
"\n",
"
\n",
"
\n",
"
\n",
"
__[Financionerioncios](https://financioneroncios.wordpress.com)__\n",
"
__[Orenji](https://www.linkedin.com/company/orenj-i)__\n",
"
__[Riskfolio-Lib](https://riskfolio-lib.readthedocs.io/en/latest/)__\n",
"
__[Dany Cajas](https://www.linkedin.com/in/dany-cajas/)__\n",
"\n",
"## Tutorial 45: Nested Clustered Optimization (NCO) Portfolio Optimization with Constraints\n",
"\n",
"## 1. Downloading the data:"
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"[*********************100%***********************] 25 of 25 completed\n"
]
}
],
"source": [
"import numpy as np\n",
"import pandas as pd\n",
"import yfinance as yf\n",
"import warnings\n",
"\n",
"warnings.filterwarnings(\"ignore\")\n",
"pd.options.display.float_format = '{:.4%}'.format\n",
"\n",
"# Date range\n",
"start = '2016-01-01'\n",
"end = '2019-12-30'\n",
"\n",
"# Tickers of assets\n",
"assets = ['JCI', 'TGT', 'CMCSA', 'CPB', 'MO', 'APA', 'MMC', 'JPM',\n",
" 'ZION', 'PSA', 'BAX', 'BMY', 'LUV', 'PCAR', 'TXT', 'TMO',\n",
" 'DE', 'MSFT', 'HPQ', 'SEE', 'VZ', 'CNP', 'NI', 'T', 'BA']\n",
"assets.sort()\n",
"\n",
"# Downloading data\n",
"data = yf.download(assets, start = start, end = end, auto_adjust=False)\n",
"data = data.loc[:,('Adj Close', slice(None))]\n",
"data.columns = assets"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"
| \n", " | APA | \n", "BA | \n", "BAX | \n", "BMY | \n", "CMCSA | \n", "CNP | \n", "CPB | \n", "DE | \n", "HPQ | \n", "JCI | \n", "... | \n", "NI | \n", "PCAR | \n", "PSA | \n", "SEE | \n", "T | \n", "TGT | \n", "TMO | \n", "TXT | \n", "VZ | \n", "ZION | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Date | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
| 2016-01-05 | \n", "-2.0257% | \n", "0.4057% | \n", "0.4036% | \n", "1.9693% | \n", "0.0180% | \n", "0.9305% | \n", "0.3678% | \n", "0.5784% | \n", "0.9483% | \n", "-1.1953% | \n", "... | \n", "1.5881% | \n", "0.0212% | \n", "2.8235% | \n", "0.9758% | \n", "0.6987% | \n", "1.7539% | \n", "-0.1730% | \n", "0.2410% | \n", "1.3735% | \n", "-1.0857% | \n", "
| 2016-01-06 | \n", "-11.4863% | \n", "-1.5879% | \n", "0.2411% | \n", "-1.7557% | \n", "-0.7727% | \n", "-1.2473% | \n", "-0.1736% | \n", "-1.1239% | \n", "-3.5867% | \n", "-0.9551% | \n", "... | \n", "0.5547% | \n", "0.0212% | \n", "0.1592% | \n", "-1.5647% | \n", "0.3108% | \n", "-1.0155% | \n", "-0.7653% | \n", "-3.0048% | \n", "-0.9034% | \n", "-2.9145% | \n", "
| 2016-01-07 | \n", "-5.1388% | \n", "-4.1922% | \n", "-1.6573% | \n", "-2.7699% | \n", "-1.1046% | \n", "-1.9769% | \n", "-1.2206% | \n", "-0.8856% | \n", "-4.6058% | \n", "-2.5394% | \n", "... | \n", "-2.2066% | \n", "-3.0310% | \n", "-1.0410% | \n", "-3.1557% | \n", "-1.6148% | \n", "-0.2700% | \n", "-2.2845% | \n", "-2.0570% | \n", "-0.5492% | \n", "-3.0019% | \n", "
| 2016-01-08 | \n", "0.2736% | \n", "-2.2705% | \n", "-1.6037% | \n", "-2.5425% | \n", "0.1098% | \n", "-0.2241% | \n", "0.5707% | \n", "-1.6402% | \n", "-1.7642% | \n", "-0.1649% | \n", "... | \n", "-0.1538% | \n", "-1.1366% | \n", "-0.7308% | \n", "-0.1448% | \n", "0.0896% | \n", "-3.3839% | \n", "-0.1117% | \n", "-1.1387% | \n", "-0.9720% | \n", "-1.1254% | \n", "
| 2016-01-11 | \n", "-4.3383% | \n", "0.1693% | \n", "-1.6851% | \n", "-1.0215% | \n", "0.0914% | \n", "-1.1791% | \n", "0.5674% | \n", "0.5287% | \n", "0.6616% | \n", "0.0330% | \n", "... | \n", "1.6436% | \n", "0.0000% | \n", "0.9869% | \n", "-0.1450% | \n", "1.2224% | \n", "1.4570% | \n", "0.5366% | \n", "-0.4607% | \n", "0.5800% | \n", "-1.9919% | \n", "
5 rows × 25 columns
\n", "| \n", " | APA | \n", "BA | \n", "BAX | \n", "BMY | \n", "CMCSA | \n", "CNP | \n", "CPB | \n", "DE | \n", "HPQ | \n", "JCI | \n", "... | \n", "NI | \n", "PCAR | \n", "PSA | \n", "SEE | \n", "T | \n", "TGT | \n", "TMO | \n", "TXT | \n", "VZ | \n", "ZION | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| weights | \n", "0.0000% | \n", "1.1729% | \n", "5.1827% | \n", "2.8237% | \n", "5.0009% | \n", "10.9741% | \n", "3.7079% | \n", "0.7664% | \n", "0.3471% | \n", "2.4531% | \n", "... | \n", "7.0048% | \n", "0.1995% | \n", "12.0255% | \n", "2.2920% | \n", "4.8849% | \n", "3.0260% | \n", "1.1106% | \n", "0.0000% | \n", "8.6249% | \n", "0.0000% | \n", "
1 rows × 25 columns
\n", "| \n", " | Disabled | \n", "Type | \n", "Set | \n", "Position | \n", "Sign | \n", "Weight | \n", "
|---|---|---|---|---|---|---|
| 0 | \n", "False | \n", "Assets | \n", "\n", " | HPQ | \n", ">= | \n", "1.0000% | \n", "
| 1 | \n", "False | \n", "Assets | \n", "\n", " | PSA | \n", "<= | \n", "5.0000% | \n", "
| 2 | \n", "False | \n", "All Assets | \n", "\n", " | \n", " | <= | \n", "6.0000% | \n", "
| 3 | \n", "False | \n", "Each asset in a class | \n", "Industry | \n", "Financials | \n", "<= | \n", "4.0000% | \n", "
| 4 | \n", "False | \n", "Each asset in a class | \n", "Industry | \n", "Information Technology | \n", "<= | \n", "2.0000% | \n", "
| \n", " | APA | \n", "BA | \n", "BAX | \n", "BMY | \n", "CMCSA | \n", "CNP | \n", "CPB | \n", "DE | \n", "HPQ | \n", "JCI | \n", "... | \n", "NI | \n", "PCAR | \n", "PSA | \n", "SEE | \n", "T | \n", "TGT | \n", "TMO | \n", "TXT | \n", "VZ | \n", "ZION | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| weights | \n", "0.0000% | \n", "3.3664% | \n", "6.0000% | \n", "6.0000% | \n", "6.0000% | \n", "6.0000% | \n", "6.0000% | \n", "2.1996% | \n", "1.0000% | \n", "6.0000% | \n", "... | \n", "6.0000% | \n", "0.5727% | \n", "4.0000% | \n", "6.0000% | \n", "6.0000% | \n", "6.0000% | \n", "3.1875% | \n", "0.0000% | \n", "6.0000% | \n", "0.0000% | \n", "
1 rows × 25 columns
\n", "