Team_4_Assignment(1)-Copy1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "from IPython.display import display, Math, Latex\n",
    "\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import numpy_financial as npf\n",
    "import yfinance as yf\n",
    "import matplotlib.pyplot as plt\n",
    "from datetime import datetime\n",
    "import concurrent.futures"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "问题：\n",
    "1. current price 换成 2021-11-26\n",
    "2. threads\n",
    "3. weights? treat pos and neg as two portfolios, and use combine portfolio to get the optimal weight\n",
    "4. monthly return or weekly return?\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Group Assignment\n",
    "### Team Number: 4\n",
    "### Team Member Names: Jacky Xu, Esha Kumar, Jingyi Fang\n",
    "### Team Strategy Chosen: SAFE"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# read the ticker file\n",
    "tickers = pd.read_csv(\"Tickers.csv\",header=None)\n",
    "# rename the column as \"ticker\"\n",
    "tickers.columns=['ticker']\n",
    "# create a list that contains all the tickers\n",
    "ticker_lst = tickers['ticker'].tolist()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "161.41000366210938"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "yf.Ticker(\"AAPL\").history(start = '2021-11-23', end = '2021-11-24',interval='1d')['Close'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# call_tickers takes a list of tickers and return a list of called tickers\n",
    "def call_tickers(lst):\n",
    "    # create an empty list to store the called tickers\n",
    "    called_tickers= []\n",
    "    # iterate the ticker list\n",
    "    for i in lst:\n",
    "        # call each ticker and append it to the called ticker list\n",
    "        called_tickers.append(yf.Ticker(i))\n",
    "    # return the called ticker list when finish\n",
    "    return called_tickers\n",
    "\n",
    "# get_ticker_info takes a called tickers, an empty dataframe, an empty list \n",
    "# and store the currency and current price into the dataframe, append the called ticker into the list\n",
    "def get_ticker_info(i):\n",
    "    ticker_name = str(i)[24:-1]\n",
    "    #return ticker_name\n",
    "    # use try and except to ignorethe delisted stocks\n",
    "    try:\n",
    "        # extract currency and current price from the info dictionary and store then into the dataframe\n",
    "        currency =  i.info['currency']\n",
    "        avg_daily_volumn = i.history(start = \"2021-07-02\", end = \"2021-10-22\" ,interval='1d')['Volume'].mean()\n",
    "        price1126 = i.history(start = '2021-11-24', end = '2021-11-25',interval='1d')['Close'][0]\n",
    "        return [ticker_name,currency,avg_daily_volumn,price1126]\n",
    "        #print(ticker_name)\n",
    "        # append the ticker into the ticker list\n",
    "        #lst.append(i)\n",
    "    except:\n",
    "        pass\n",
    "\n",
    "\n",
    "# get_prices takes a list of called tickers, start date adn end date, returns the historical prices in the given time period\n",
    "def get_prices(lst,start,end):\n",
    "    # open an empty dataframe\n",
    "    prices = pd.DataFrame()\n",
    "    # iterate the ticker list\n",
    "    for i in lst:\n",
    "        # extract the historical closing prices and store into the dataframe\n",
    "        prices[str(i)[24:-1]] = i.history(start = start,end=end,interval = '1d')['Close']\n",
    "    # return the prices\n",
    "    return prices\n",
    "\n",
    "# get_weekly_returns takes the historical prices(or portfolio value) and returns the weekly returns\n",
    "# usually we use monthly returns but since the competition only lasts for 6 days, we decided to use the weekly returns\n",
    "def get_weekly_returns(prices):\n",
    "    weekly_returns = prices.resample('W').first().pct_change()\n",
    "    weekly_returns = weekly_returns.iloc[1:]\n",
    "    return weekly_returns\n",
    "\n",
    "# we still use monthly returns to calculate the beta and others\n",
    "def get_monthly_returns(prices):\n",
    "    monthly_returns = prices.resample('MS').first().pct_change()\n",
    "    #monthly_returns = monthly_returns.iloc[1:]\n",
    "    return monthly_returns\n",
    "    \n",
    "# get_std takes the prices of the stock and returns the std of the prices\n",
    "def get_std(prices):\n",
    "    # open an empty dataframe with column names set up\n",
    "    std = pd.DataFrame(columns = ('ticker','std'))\n",
    "    # set the index\n",
    "    index = 0\n",
    "    # iterate through the ticker names\n",
    "    for i in prices.columns:\n",
    "        # store the ticker name and the std of prices\n",
    "        std.loc[index] = [i, prices[i].std()]\n",
    "        # add 1 to the index\n",
    "        index += 1\n",
    "    # return the std\n",
    "    return std\n",
    "\n",
    "\n",
    "# rank takes a dataframe, column name and method and rank the dataframe by the given column using the given method\n",
    "def get_rank(df,column_name,method):\n",
    "    # use the build-in rank function to rank the dataframe, store the rankings in a new column\n",
    "    df[column_name+'_rank'] = df[column_name].rank(method=method)\n",
    "    # return the ranked dataframe\n",
    "    return df\n",
    "\n",
    "# get_std_beta_rank takes the ranked std dataframe and the ranked beta dataframe, rank the dataframe by both and return the top 40 stocks\n",
    "def get_std_beta_rank(std,beta):\n",
    "    # combine the std dataframe and the beta dataframe\n",
    "    rank = pd.concat([std,beta['beta'],beta['beta_rank']],join='inner',axis=1)\n",
    "    # add up the ranks to get the final rank\n",
    "    rank['final_rank'] = rank['std_rank']*8 + rank['beta_rank']\n",
    "    # rank by the final rank\n",
    "    rank = rank.sort_values(by='final_rank')\n",
    "    # takes the top 40 stocks\n",
    "    rank = rank[:40]\n",
    "    # return the dataframe\n",
    "    return rank\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# set up the start date and the end date\n",
    "start_date = \"2021-07-02\"\n",
    "end_date = \"2021-10-22\"\n",
    "\n",
    "# call the tickers\n",
    "called_tickers = call_tickers(ticker_lst)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# open an empty dataframe and a list to store the ticker info and the tickers\n",
    "ticker_info = pd.DataFrame()\n",
    "tickers = []\n",
    "with concurrent.futures.ThreadPoolExecutor() as executor:\n",
    "    result = executor.map(get_ticker_info, called_tickers)\n",
    "for i in result:\n",
    "    try:\n",
    "        if i[1] == 'USD':\n",
    "            if i[2] > 10000:\n",
    "                ticker_info[i[0]] = [i[3]]\n",
    "    except:\n",
    "        pass\n",
    "ticker_info = ticker_info.T\n",
    "ticker_info.columns = ['11-26_price']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "55"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(ticker_info)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "good_tickers = call_tickers(ticker_info.index)\n",
    "# extract the closing prices for the good tickers\n",
    "prices = get_prices(good_tickers, start_date, end_date)\n",
    "\n",
    "# Get a list of Ticker Symbols (list of Strings)\n",
    "ticker_symbols = prices.columns\n",
    "\n",
    "# calculate the std according to the closing prices\n",
    "std = get_std(prices)\n",
    "\n",
    "# rank them in ascending order\n",
    "std = get_rank(std,'std','min')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "55"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(good_tickers)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# calculate the std according to the closing prices\n",
    "std = get_std(prices)\n",
    "\n",
    "# rank them in ascending order\n",
    "std = get_rank(std,'std','min')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Calculating Beta\n",
    "def get_beta(good_tickers, prices, start_date, end_date, ticker_symbols):\n",
    "    Ticker = '^GSPC'\n",
    "    MarketIndex = yf.Ticker(Ticker) # The symbol yfinance uses for the S&P 500\n",
    "\n",
    "    MarketIndex_hist = MarketIndex.history(start=start_date, end=end_date)\n",
    "\n",
    "    # DataFrame for Market Index\n",
    "    marketDF = pd.DataFrame(MarketIndex_hist['Close'])\n",
    "    marketDF.columns = [Ticker]\n",
    "    \n",
    "\n",
    "    # Loop iterates through the column of prices\n",
    "    betaList = []\n",
    "    for i in range(len(ticker_symbols)):\n",
    "        currentStockPrice = prices[ticker_symbols[i]]\n",
    "        currentStockPrice = pd.concat([currentStockPrice, marketDF], join = 'inner', axis=1)\n",
    "        \n",
    "        # Getting the Monthly Return of each stock\n",
    "        monthly_returns = currentStockPrice.resample('MS').first().pct_change()  # Dropping the first entry (since it's N/A)\n",
    "        monthly_returns.drop(index=monthly_returns.index[0], inplace=True)\n",
    "        \n",
    "        \n",
    "        # Calculate the market variance (you will need to reference the column correponding to the market)\n",
    "        MarketVar = monthly_returns[Ticker].var()\n",
    "        \n",
    "        betaList.append(monthly_returns.cov() / MarketVar)\n",
    "        \n",
    "    # Filter through betaList and extract the beta for each stock\n",
    "    for i in range(len(betaList)):\n",
    "        betaList[i] = betaList[i].iat[0,1]\n",
    "    \n",
    "    # Creating a DataFrame for Tickers and their Beta value\n",
    "    beta = pd.DataFrame(columns = ('ticker','beta'))\n",
    "    for i in range(len(good_tickers)):\n",
    "        beta.loc[i] = [str(good_tickers[i])[24:-1], betaList[i]]\n",
    "\n",
    "    return beta"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "# get_correlation takes a ticker(self) and return \n",
    "def get_correlation(self,std_rank,prices,length):\n",
    "    rank = pd.DataFrame()\n",
    "    self_weekly_returns = pd.DataFrame(get_weekly_returns(prices[self]))\n",
    "    for i in range(1,length):\n",
    "        candidate = std_rank.index[i]\n",
    "        candidate_weekly_returns = pd.DataFrame(get_weekly_returns(prices[candidate]))\n",
    "        corr = self_weekly_returns[self].corr(candidate_weekly_returns[candidate])  \n",
    "        rank[candidate] = [corr]\n",
    "    return rank.T\n",
    "\n",
    "# pair_by_corr takes the ranked dataframe and the prices of the stocks, \n",
    "# returns 10 portfoliois in one dataframe, each with a pair of stocks with the lowest correlation\n",
    "def pair_by_corr(rank, prices):\n",
    "    # open an empty dataframe\n",
    "    pairs = pd.DataFrame()\n",
    "    # counter is the number of pairs\n",
    "    counter = 0\n",
    "    # loop until we have 10 pairs\n",
    "    while counter < 10:\n",
    "        # self is the stock that has lowest std and beta(which is the safest one)\n",
    "        self = rank.index[0]\n",
    "        # get the weekly_returns for self\n",
    "        self_weekly_returns = pd.DataFrame(get_weekly_returns(prices[self]))\n",
    "        # for all other stocks in the ranked dataframe\n",
    "        corrs = get_correlation(self,rank,prices,len(rank)-1)\n",
    "        corrs.columns = ['corr']\n",
    "        corrs = corrs.sort_values(by='corr')\n",
    "        champion = corrs.index[0]\n",
    "        champion_weekly_returns = pd.DataFrame(get_weekly_returns(prices[champion]))\n",
    "        # get current price from the ticker info dataframe\n",
    "        self_price = prices[self][0]\n",
    "        champion_price = prices[champion][0]\n",
    "        # calculate the number of shares we could purchase using the current price\n",
    "        self_shares = 100000 /  self_price\n",
    "        champion_shares = 100000 /  champion_price\n",
    "        # get weekly price, portfolio value, and portfolio return for self and champion\n",
    "        pairs[self+'_price'] = prices[self].resample('W').first()\n",
    "        pairs[self+'_value'] =  pairs[self+'_price']*self_shares\n",
    "        pairs[self+'_return'] = pd.DataFrame(get_weekly_returns(pairs[self+'_value']))\n",
    "        pairs[champion+'_price'] = prices[champion].resample('W').first()\n",
    "        pairs[champion+'_value'] =  pairs[champion+'_price']*champion_shares\n",
    "        pairs[champion+'_return'] = pd.DataFrame(get_weekly_returns(pairs[champion+'_value']))\n",
    "        # remove self and champion from the ranked dataframe to prepare for the next iteration\n",
    "        rank = rank[1:]\n",
    "        rank = rank[rank.index != str(champion)]\n",
    "        # add 1 to the counter for each finished pair\n",
    "        counter += 1\n",
    "    # return the pairs\n",
    "    return pairs\n",
    "\n",
    "\n",
    "def get_difference(df): \n",
    "    return max(abs(df['value'].max()-100000) , abs(df['value'].min()-100000))\n",
    "\n",
    "# when 'stock' is True, create_portfolio takes two stocks and the pairs dataframe, \n",
    "# returns a weight and the weighted portfolio with the lowest sharpe ratio\n",
    "# when 'stock' is False, create_portfolio takes two portfolio(old and new), the min and max range for the sharpe ratio,\n",
    "# returns a weight and the weighted portfolio with the lowest sharpe ratio\n",
    "def create_portfolio(old,new,range_min,range_max,stock,stock1,stock2,pairs):\n",
    "    # open an empty portfolio \n",
    "    candidate = pd.DataFrame()\n",
    "    champion = 0\n",
    "    # min_ratio stores the lowest sharpe ratio\n",
    "    min_difference = ['+' , 100000]\n",
    "    # weight_1 is the weight of stock1 or the portfolio weight for old\n",
    "    weight_1 = 0\n",
    "    # iterates the given range\n",
    "    for i in range(range_min,range_max+1):\n",
    "        if stock:\n",
    "            # for the stock version, the porfolio value is taken from the pairs dataframe\n",
    "            # multiply the weight i with the value of each stock\n",
    "            # add them up and double the result(since each stock value starts from 500000 and the required amount is 1 million)\n",
    "            candidate['value'] = pairs[stock1+'_value']*(i/100)+pairs[stock2+'_value']* (1-i/100)\n",
    "        else:\n",
    "            # for the portfolio version, just multiply the portfolio values by the weights and add them up\n",
    "            candidate['value'] = old['value']*(i/100)+new['value']* (1-i/100)\n",
    "        # get the monthly returns \n",
    "        # get the sharpe ratio \n",
    "        difference = get_difference(candidate)\n",
    "        #print(difference)\n",
    "        # if the absolute value of the sharpe ratio(since the ratio could be negative too) is less than the min_ratio\n",
    "        if abs(difference) <= min_difference[1]:\n",
    "            if candidate['value'].median() > 100000:\n",
    "                 min_difference = ['+',abs(difference)]\n",
    "            # replace the min_ratio by the the absolute value of the current sharpe ratio \n",
    "            else:\n",
    "                min_difference = ['-',abs(difference)]\n",
    "            # update the champion and the weight\n",
    "            champion = candidate\n",
    "            weight_1 = i\n",
    "    # return the optimal weight and the portfolio with the optimal weight\n",
    "    return weight_1, min_difference, champion\n",
    "\n",
    "# get_range takes the optimal weight for stock1 and returns the range for the portfolio weight\n",
    "def get_range(stock1_weight):\n",
    "    if (stock1_weight < 1 or stock1_weight > 99):\n",
    "        range_max = 1\n",
    "        range_min = 0\n",
    "    # if stock1 has a greater weight, the max portfolio weight would be 35/stock1_weight\n",
    "    # since 35 is the max weight, and the weight of each stock is given by the product of stock1_weight * portfolio weight\n",
    "    # so the max portfolio weight is 35/stock1_weight. Same logic for the min portfolio weight\n",
    "    else:\n",
    "        if stock1_weight >= 50:\n",
    "            range_max = 35/stock1_weight\n",
    "            range_min = 2.5/(100-stock1_weight)\n",
    "            # if stock1 has a lower weight, just flip the stock1 and the other stock\n",
    "        else:\n",
    "            range_max = 35/(100-stock1_weight) \n",
    "            range_min = 2.5/stock1_weight\n",
    "    \n",
    "    if range_min < range_max:\n",
    "        return math.ceil(range_min*100),math.floor(range_max*100)\n",
    "    else:\n",
    "        return math.floor(range_max*100),math.ceil(range_min*100)\n",
    "\n",
    "\n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>std</th>\n",
       "      <th>std_rank</th>\n",
       "      <th>beta</th>\n",
       "      <th>beta_rank</th>\n",
       "      <th>final_rank</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ticker</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>MON</th>\n",
       "      <td>0.046874</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-0.146849</td>\n",
       "      <td>13.0</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>T</th>\n",
       "      <td>0.663311</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.460408</td>\n",
       "      <td>11.0</td>\n",
       "      <td>27.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KMI</th>\n",
       "      <td>0.760351</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-1.738541</td>\n",
       "      <td>5.0</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KO</th>\n",
       "      <td>1.205896</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.013712</td>\n",
       "      <td>28.0</td>\n",
       "      <td>68.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MO</th>\n",
       "      <td>1.189154</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.697517</td>\n",
       "      <td>42.0</td>\n",
       "      <td>74.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             std  std_rank      beta  beta_rank  final_rank\n",
       "ticker                                                     \n",
       "MON     0.046874       1.0 -0.146849       13.0        21.0\n",
       "T       0.663311       2.0 -0.460408       11.0        27.0\n",
       "KMI     0.760351       3.0 -1.738541        5.0        29.0\n",
       "KO      1.205896       5.0  1.013712       28.0        68.0\n",
       "MO      1.189154       4.0  1.697517       42.0        74.0"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# calculate the beta according to the closing prices\n",
    "beta = get_beta(good_tickers, prices, start_date, end_date, ticker_symbols)\n",
    "\n",
    "# rank them in ascending order\n",
    "beta = get_rank(beta,'beta','min')\n",
    "\n",
    "# combine the rank of std and beta, then rank the combined rank\n",
    "std_beta_rank = get_std_beta_rank(std,beta)\n",
    "std_beta_rank.set_index('ticker',inplace=True)\n",
    "std_beta_rank.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "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>MON_price</th>\n",
       "      <th>MON_value</th>\n",
       "      <th>MON_return</th>\n",
       "      <th>PFE_price</th>\n",
       "      <th>PFE_value</th>\n",
       "      <th>PFE_return</th>\n",
       "      <th>T_price</th>\n",
       "      <th>T_value</th>\n",
       "      <th>T_return</th>\n",
       "      <th>PEP_price</th>\n",
       "      <th>...</th>\n",
       "      <th>USB_return</th>\n",
       "      <th>SO_price</th>\n",
       "      <th>SO_value</th>\n",
       "      <th>SO_return</th>\n",
       "      <th>C_price</th>\n",
       "      <th>C_value</th>\n",
       "      <th>C_return</th>\n",
       "      <th>CL_price</th>\n",
       "      <th>CL_value</th>\n",
       "      <th>CL_return</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-07-04</th>\n",
       "      <td>9.655</td>\n",
       "      <td>100000.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>39.030785</td>\n",
       "      <td>100000.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.158052</td>\n",
       "      <td>100000.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>147.896271</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60.274460</td>\n",
       "      <td>100000.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>69.385284</td>\n",
       "      <td>100000.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80.773155</td>\n",
       "      <td>100000.000000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-07-11</th>\n",
       "      <td>9.730</td>\n",
       "      <td>100776.797632</td>\n",
       "      <td>0.007768</td>\n",
       "      <td>38.598526</td>\n",
       "      <td>98892.518789</td>\n",
       "      <td>-0.011075</td>\n",
       "      <td>27.955755</td>\n",
       "      <td>99281.565332</td>\n",
       "      <td>-0.007184</td>\n",
       "      <td>148.114777</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.027098</td>\n",
       "      <td>60.382214</td>\n",
       "      <td>100178.771828</td>\n",
       "      <td>0.001788</td>\n",
       "      <td>67.217300</td>\n",
       "      <td>96875.441202</td>\n",
       "      <td>-0.031246</td>\n",
       "      <td>81.040092</td>\n",
       "      <td>100330.477688</td>\n",
       "      <td>0.003305</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-07-18</th>\n",
       "      <td>9.700</td>\n",
       "      <td>100466.080555</td>\n",
       "      <td>-0.003083</td>\n",
       "      <td>39.060253</td>\n",
       "      <td>100075.500753</td>\n",
       "      <td>0.011962</td>\n",
       "      <td>27.937721</td>\n",
       "      <td>99217.519775</td>\n",
       "      <td>-0.000645</td>\n",
       "      <td>148.492172</td>\n",
       "      <td>...</td>\n",
       "      <td>0.028031</td>\n",
       "      <td>60.538948</td>\n",
       "      <td>100438.806455</td>\n",
       "      <td>0.002596</td>\n",
       "      <td>68.429405</td>\n",
       "      <td>98622.360318</td>\n",
       "      <td>0.018033</td>\n",
       "      <td>81.989204</td>\n",
       "      <td>101505.511566</td>\n",
       "      <td>0.011712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-07-25</th>\n",
       "      <td>9.670</td>\n",
       "      <td>100155.363477</td>\n",
       "      <td>-0.003093</td>\n",
       "      <td>39.443394</td>\n",
       "      <td>101057.137602</td>\n",
       "      <td>0.009809</td>\n",
       "      <td>27.260860</td>\n",
       "      <td>96813.728495</td>\n",
       "      <td>-0.024227</td>\n",
       "      <td>154.739365</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.053317</td>\n",
       "      <td>61.508747</td>\n",
       "      <td>102047.778222</td>\n",
       "      <td>0.016019</td>\n",
       "      <td>64.132851</td>\n",
       "      <td>92430.046485</td>\n",
       "      <td>-0.062788</td>\n",
       "      <td>83.017410</td>\n",
       "      <td>102778.466509</td>\n",
       "      <td>0.012541</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-08-01</th>\n",
       "      <td>9.675</td>\n",
       "      <td>100207.151303</td>\n",
       "      <td>0.000517</td>\n",
       "      <td>41.074177</td>\n",
       "      <td>105235.334626</td>\n",
       "      <td>0.041345</td>\n",
       "      <td>27.643435</td>\n",
       "      <td>98172.395193</td>\n",
       "      <td>0.014034</td>\n",
       "      <td>156.000717</td>\n",
       "      <td>...</td>\n",
       "      <td>0.030637</td>\n",
       "      <td>62.429565</td>\n",
       "      <td>103575.487191</td>\n",
       "      <td>0.014971</td>\n",
       "      <td>66.783699</td>\n",
       "      <td>96250.522845</td>\n",
       "      <td>0.041334</td>\n",
       "      <td>83.583977</td>\n",
       "      <td>103479.895673</td>\n",
       "      <td>0.006825</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 60 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            MON_price      MON_value  MON_return  PFE_price      PFE_value  \\\n",
       "Date                                                                         \n",
       "2021-07-04      9.655  100000.000000         NaN  39.030785  100000.000000   \n",
       "2021-07-11      9.730  100776.797632    0.007768  38.598526   98892.518789   \n",
       "2021-07-18      9.700  100466.080555   -0.003083  39.060253  100075.500753   \n",
       "2021-07-25      9.670  100155.363477   -0.003093  39.443394  101057.137602   \n",
       "2021-08-01      9.675  100207.151303    0.000517  41.074177  105235.334626   \n",
       "\n",
       "            PFE_return    T_price        T_value  T_return   PEP_price  ...  \\\n",
       "Date                                                                    ...   \n",
       "2021-07-04         NaN  28.158052  100000.000000       NaN  147.896271  ...   \n",
       "2021-07-11   -0.011075  27.955755   99281.565332 -0.007184  148.114777  ...   \n",
       "2021-07-18    0.011962  27.937721   99217.519775 -0.000645  148.492172  ...   \n",
       "2021-07-25    0.009809  27.260860   96813.728495 -0.024227  154.739365  ...   \n",
       "2021-08-01    0.041345  27.643435   98172.395193  0.014034  156.000717  ...   \n",
       "\n",
       "            USB_return   SO_price       SO_value  SO_return    C_price  \\\n",
       "Date                                                                     \n",
       "2021-07-04         NaN  60.274460  100000.000000        NaN  69.385284   \n",
       "2021-07-11   -0.027098  60.382214  100178.771828   0.001788  67.217300   \n",
       "2021-07-18    0.028031  60.538948  100438.806455   0.002596  68.429405   \n",
       "2021-07-25   -0.053317  61.508747  102047.778222   0.016019  64.132851   \n",
       "2021-08-01    0.030637  62.429565  103575.487191   0.014971  66.783699   \n",
       "\n",
       "                  C_value  C_return   CL_price       CL_value  CL_return  \n",
       "Date                                                                      \n",
       "2021-07-04  100000.000000       NaN  80.773155  100000.000000        NaN  \n",
       "2021-07-11   96875.441202 -0.031246  81.040092  100330.477688   0.003305  \n",
       "2021-07-18   98622.360318  0.018033  81.989204  101505.511566   0.011712  \n",
       "2021-07-25   92430.046485 -0.062788  83.017410  102778.466509   0.012541  \n",
       "2021-08-01   96250.522845  0.041334  83.583977  103479.895673   0.006825  \n",
       "\n",
       "[5 rows x 60 columns]"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# get the portfolio of pairs \n",
    "pairs = pair_by_corr(std_beta_rank,prices)\n",
    "pairs.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n",
      "<ipython-input-149-6be532b52d8a>:86: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock2_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:87: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pos['stock1_weight']*= pos_weight/len(pos)\n",
      "<ipython-input-149-6be532b52d8a>:88: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock2_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:89: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  neg['stock1_weight'] *= neg_weight/len(neg)\n",
      "<ipython-input-149-6be532b52d8a>:119: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
      "<ipython-input-149-6be532b52d8a>:121: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  price['final'] = price.sum(axis = 1)\n"
     ]
    }
   ],
   "source": [
    "bigNum = []\n",
    "for i in range (len(pairs)):\n",
    "    bigNum.append(1230918230)\n",
    "lowest = pd.DataFrame({\"final\": bigNum})\n",
    "for w in range(49):\n",
    "    # open empty lists for the protfolio weights, differences and symbols\n",
    "    portfolio_weights = []\n",
    "    diffs = []\n",
    "    stock1_symbols = []\n",
    "    stock2_symbols = []\n",
    "    # extract the column names for prices in the pairs dataframe( 'tickername_price')\n",
    "    symbols = pairs.filter(like='_price', axis=1).columns\n",
    "    # get number of pairs as the number of for loop\n",
    "    num_of_pairs = round(len(symbols)/2)\n",
    "\n",
    "    # then iterates the stocks in paris\n",
    "    for i in range(num_of_pairs):\n",
    "        # get the ticker names for the pair of stocks, and append to the corresponding symbol lists\n",
    "        stock1 = symbols[0][:-6]\n",
    "        stock1_symbols.append(stock1)\n",
    "        stock2 = symbols[1][:-6]\n",
    "        stock2_symbols.append(stock2)\n",
    "\n",
    "        # combine the pair of stock, store the optimal stock weight, difference, and the portfolio with optimal weight\n",
    "        w1, diff, champion = create_portfolio(0,0,1+w,99-w,True,stock1,stock2,pairs)\n",
    "        # append the result to their corresponding lists\n",
    "        portfolio_weights.append(w1)\n",
    "        diffs.append(diff)\n",
    "        # remove the finished pair\n",
    "        symbols = symbols[2:]\n",
    "\n",
    "        # format the differences with signs\n",
    "    for i in range(num_of_pairs):\n",
    "        if diffs[i][0] == '+':\n",
    "            diffs[i] = diffs[i][1]\n",
    "        else:\n",
    "            diffs[i] = (diffs[i][1])*-1\n",
    "\n",
    "    # create a dataframe with the weights and the differences\n",
    "    weights = pd.DataFrame(portfolio_weights, diffs)\n",
    "    # format the dataframe, calculate the stock 2 weight and add the symbols in\n",
    "    weights.reset_index(inplace=True)\n",
    "    weights.columns = ['diff','stock1_weight']\n",
    "    weights['stock1_symbol'] = stock1_symbols\n",
    "    weights['stock2_weight'] = 100 - weights['stock1_weight']\n",
    "    weights['stock2_symbol'] = stock2_symbols\n",
    "    weights\n",
    "    # separate the weights dataframe by signs\n",
    "\n",
    "    pos = weights[weights['diff'] > 0]\n",
    "    neg = weights[weights['diff'] < 0]\n",
    "    # calculate the sum of positive differences and negative diffrences\n",
    "    pos_diff = pos['diff'].sum()\n",
    "    neg_diff = neg['diff'].sum()\n",
    "    # calculate the total differences\n",
    "    total_diff = pos_diff - neg_diff\n",
    "    # calculate the weights of positve and negative diffserences\n",
    "    pos_weight = pos_diff/total_diff\n",
    "    neg_weight = (neg_diff/total_diff)*-1\n",
    "    #print(pos_weight, neg_weight)\n",
    "    # each stock must make up a minimum of (100/(2n))% of the portfolio , add/subtract 0.01 just in case\n",
    "    min_weight = ((100/(len(weights)*4))+0.01)/(1+w)\n",
    "    max_weight = (35-0.01)/(99-w)\n",
    "    #print(min_weight,max_weight)\n",
    "    pos_weight/len(pos)\n",
    "\n",
    "    # the minimal weight for the entire pos/neg differences is given multiplying the minimal weight of each stock \n",
    "    # and the number of stocks that has pos/neg differences, then divided by 30, since \n",
    "    # 30 is the minimal weight of how each stock is weighted in its local portfolio\n",
    "    # use 0.5 since we wish both positive and negative differences make up of 50% of the total differences\n",
    "    # so that they can cancel each other\n",
    "    if pos_weight < neg_weight:\n",
    "        # make sure that the weights is greater than the min weight\n",
    "        neg_weight = min(min_weight*len(neg),0.5-0.5/pos_weight)\n",
    "        #pos_weight = min(0.5/pos_weight,min_pos_weight)\n",
    "        pos_weight = 1 - neg_weight\n",
    "    else:\n",
    "        pos_weight = min_weight*len(pos)\n",
    "        neg_weight = 1 - pos_weight\n",
    "\n",
    "\n",
    "    pos_weight, neg_weight\n",
    "    max_weight,min_weight\n",
    "\n",
    "    # calculate the final weight of each stock\n",
    "    pos['stock2_weight']*= pos_weight/len(pos)\n",
    "    pos['stock1_weight']*= pos_weight/len(pos)\n",
    "    neg['stock2_weight'] *= neg_weight/len(neg)\n",
    "    neg['stock1_weight'] *= neg_weight/len(neg)\n",
    "\n",
    "    # combine the pos and neg, as well as stock1 and stock2\n",
    "    weights = pd.concat([pos,neg],join='inner',axis=0)\n",
    "    weights_1 = weights[['stock1_weight','stock1_symbol']]\n",
    "    weights_2 = weights[['stock2_weight','stock2_symbol']]\n",
    "    weights_1.columns = ['weight','symbol']\n",
    "    weights_2.columns = ['weight','symbol']\n",
    "    weights = pd.concat([weights_1,weights_2],join = 'inner',axis = 0)\n",
    "    weights.reset_index(inplace = True)\n",
    "    weights.drop('index',axis = 1)\n",
    "\n",
    "    # initialize the final portfolio\n",
    "    final_portfolio = pd.DataFrame(columns = ['Ticker', 'Price', 'Shares', 'Value', 'Weight'])\n",
    "    # fill in the required information\n",
    "    for i in range(len(weights)):\n",
    "        ticker = weights['symbol'][i]\n",
    "        price = pairs[ticker+\"_price\"][0]\n",
    "        weight = weights['weight'][i]\n",
    "        value = weight/100*100000\n",
    "        shares = value/price\n",
    "        final_portfolio.loc[i+1] = [ticker,price,shares,value,weight]\n",
    "\n",
    "    ### Check the final portfolio, using the price of start date to buy shares\n",
    "    ticker = final_portfolio['Ticker']\n",
    "    ticker_lst = ticker.tolist()\n",
    "    shares = final_portfolio['Shares']\n",
    "    price = pairs[ticker+'_price']\n",
    "    for i in range(len(ticker_lst)):\n",
    "        ticker_name = ticker_lst[i]\n",
    "        price[ticker_name+'_price'] *= final_portfolio.loc[i+1,'Shares']\n",
    "\n",
    "    price['final'] = price.sum(axis = 1)\n",
    "    price.tail()\n",
    "    if price['final'].iloc[len(price)-1] < lowest['final'].iloc[len(price)-1]:\n",
    "        lowest = price.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 150,
   "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>diff</th>\n",
       "      <th>stock1_weight</th>\n",
       "      <th>stock1_symbol</th>\n",
       "      <th>stock2_weight</th>\n",
       "      <th>stock2_symbol</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>13058.421465</td>\n",
       "      <td>2.612449</td>\n",
       "      <td>MON</td>\n",
       "      <td>2.510000</td>\n",
       "      <td>PFE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5173.015366</td>\n",
       "      <td>2.612449</td>\n",
       "      <td>KMI</td>\n",
       "      <td>2.510000</td>\n",
       "      <td>NEE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3485.179895</td>\n",
       "      <td>2.612449</td>\n",
       "      <td>KO</td>\n",
       "      <td>2.510000</td>\n",
       "      <td>MRK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5961.340797</td>\n",
       "      <td>2.612449</td>\n",
       "      <td>CVS</td>\n",
       "      <td>2.510000</td>\n",
       "      <td>PG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>4890.634749</td>\n",
       "      <td>2.510000</td>\n",
       "      <td>USB</td>\n",
       "      <td>2.612449</td>\n",
       "      <td>SO</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           diff  stock1_weight stock1_symbol  stock2_weight stock2_symbol\n",
       "0  13058.421465       2.612449           MON       2.510000           PFE\n",
       "2   5173.015366       2.612449           KMI       2.510000           NEE\n",
       "3   3485.179895       2.612449            KO       2.510000           MRK\n",
       "5   5961.340797       2.612449           CVS       2.510000            PG\n",
       "8   4890.634749       2.510000           USB       2.612449            SO"
      ]
     },
     "execution_count": 150,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 153,
   "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>diff</th>\n",
       "      <th>stock1_weight</th>\n",
       "      <th>stock1_symbol</th>\n",
       "      <th>stock2_weight</th>\n",
       "      <th>stock2_symbol</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-2111.046192</td>\n",
       "      <td>7.587551</td>\n",
       "      <td>T</td>\n",
       "      <td>7.290000</td>\n",
       "      <td>PEP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>-5197.777411</td>\n",
       "      <td>7.587551</td>\n",
       "      <td>MO</td>\n",
       "      <td>7.290000</td>\n",
       "      <td>ABBV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>-8655.922277</td>\n",
       "      <td>7.290000</td>\n",
       "      <td>SLB</td>\n",
       "      <td>7.587551</td>\n",
       "      <td>ABT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>-5731.465417</td>\n",
       "      <td>7.587551</td>\n",
       "      <td>CSCO</td>\n",
       "      <td>7.290000</td>\n",
       "      <td>GM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>-4959.167479</td>\n",
       "      <td>7.587551</td>\n",
       "      <td>C</td>\n",
       "      <td>7.290000</td>\n",
       "      <td>CL</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          diff  stock1_weight stock1_symbol  stock2_weight stock2_symbol\n",
       "1 -2111.046192       7.587551             T       7.290000           PEP\n",
       "4 -5197.777411       7.587551            MO       7.290000          ABBV\n",
       "6 -8655.922277       7.290000           SLB       7.587551           ABT\n",
       "7 -5731.465417       7.587551          CSCO       7.290000            GM\n",
       "9 -4959.167479       7.587551             C       7.290000            CL"
      ]
     },
     "execution_count": 153,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "neg"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Contribution Declaration\n",
    "\n",
    "The following team members made a meaningful contribution to this assignment:\n",
    "\n",
    "Insert Names Here."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 155,
   "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>MON_price</th>\n",
       "      <th>KMI_price</th>\n",
       "      <th>KO_price</th>\n",
       "      <th>CVS_price</th>\n",
       "      <th>USB_price</th>\n",
       "      <th>T_price</th>\n",
       "      <th>MO_price</th>\n",
       "      <th>SLB_price</th>\n",
       "      <th>CSCO_price</th>\n",
       "      <th>C_price</th>\n",
       "      <th>...</th>\n",
       "      <th>NEE_price</th>\n",
       "      <th>MRK_price</th>\n",
       "      <th>PG_price</th>\n",
       "      <th>SO_price</th>\n",
       "      <th>PEP_price</th>\n",
       "      <th>ABBV_price</th>\n",
       "      <th>ABT_price</th>\n",
       "      <th>GM_price</th>\n",
       "      <th>CL_price</th>\n",
       "      <th>final</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-07-04</th>\n",
       "      <td>2612.448980</td>\n",
       "      <td>2612.448980</td>\n",
       "      <td>2612.448980</td>\n",
       "      <td>2612.448980</td>\n",
       "      <td>2510.000000</td>\n",
       "      <td>7587.551020</td>\n",
       "      <td>7587.551020</td>\n",
       "      <td>7290.000000</td>\n",
       "      <td>7587.551020</td>\n",
       "      <td>7587.551020</td>\n",
       "      <td>...</td>\n",
       "      <td>2510.000000</td>\n",
       "      <td>2510.000000</td>\n",
       "      <td>2510.000000</td>\n",
       "      <td>2612.448980</td>\n",
       "      <td>7290.000000</td>\n",
       "      <td>7290.000000</td>\n",
       "      <td>7587.551020</td>\n",
       "      <td>7290.000000</td>\n",
       "      <td>7290.000000</td>\n",
       "      <td>100000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-07-11</th>\n",
       "      <td>2632.742421</td>\n",
       "      <td>2594.160625</td>\n",
       "      <td>2597.983613</td>\n",
       "      <td>2572.832784</td>\n",
       "      <td>2441.985274</td>\n",
       "      <td>7533.039423</td>\n",
       "      <td>7450.262708</td>\n",
       "      <td>6929.835049</td>\n",
       "      <td>7508.189577</td>\n",
       "      <td>7350.473527</td>\n",
       "      <td>...</td>\n",
       "      <td>2538.722473</td>\n",
       "      <td>2494.352372</td>\n",
       "      <td>2511.477554</td>\n",
       "      <td>2617.119302</td>\n",
       "      <td>7300.770439</td>\n",
       "      <td>7325.446959</td>\n",
       "      <td>7637.688682</td>\n",
       "      <td>7104.535275</td>\n",
       "      <td>7314.091823</td>\n",
       "      <td>98937.912104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-07-18</th>\n",
       "      <td>2624.625096</td>\n",
       "      <td>2605.414976</td>\n",
       "      <td>2626.914346</td>\n",
       "      <td>2593.116409</td>\n",
       "      <td>2510.436078</td>\n",
       "      <td>7528.179934</td>\n",
       "      <td>7581.165734</td>\n",
       "      <td>6940.951443</td>\n",
       "      <td>7543.618803</td>\n",
       "      <td>7483.021907</td>\n",
       "      <td>...</td>\n",
       "      <td>2537.370827</td>\n",
       "      <td>2476.469509</td>\n",
       "      <td>2532.902081</td>\n",
       "      <td>2623.912574</td>\n",
       "      <td>7319.372761</td>\n",
       "      <td>7445.712190</td>\n",
       "      <td>7637.045752</td>\n",
       "      <td>7291.236696</td>\n",
       "      <td>7399.751793</td>\n",
       "      <td>99813.113977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-07-25</th>\n",
       "      <td>2616.507771</td>\n",
       "      <td>2416.902180</td>\n",
       "      <td>2687.186706</td>\n",
       "      <td>2556.669255</td>\n",
       "      <td>2376.586680</td>\n",
       "      <td>7345.791044</td>\n",
       "      <td>7469.419808</td>\n",
       "      <td>5924.931164</td>\n",
       "      <td>7519.527082</td>\n",
       "      <td>7013.176935</td>\n",
       "      <td>...</td>\n",
       "      <td>2601.573743</td>\n",
       "      <td>2460.502807</td>\n",
       "      <td>2593.851594</td>\n",
       "      <td>2665.946141</td>\n",
       "      <td>7627.305018</td>\n",
       "      <td>7387.271808</td>\n",
       "      <td>7664.830604</td>\n",
       "      <td>6698.985895</td>\n",
       "      <td>7492.550209</td>\n",
       "      <td>97656.050597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-08-01</th>\n",
       "      <td>2617.860702</td>\n",
       "      <td>2508.344783</td>\n",
       "      <td>2751.316793</td>\n",
       "      <td>2642.300163</td>\n",
       "      <td>2449.397256</td>\n",
       "      <td>7448.880573</td>\n",
       "      <td>7600.322214</td>\n",
       "      <td>6549.661099</td>\n",
       "      <td>7861.066208</td>\n",
       "      <td>7303.057528</td>\n",
       "      <td>...</td>\n",
       "      <td>2598.870711</td>\n",
       "      <td>2466.569874</td>\n",
       "      <td>2607.191238</td>\n",
       "      <td>2705.856758</td>\n",
       "      <td>7689.478729</td>\n",
       "      <td>7538.960000</td>\n",
       "      <td>7711.933003</td>\n",
       "      <td>6895.578522</td>\n",
       "      <td>7543.684395</td>\n",
       "      <td>100131.737449</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-08-08</th>\n",
       "      <td>2625.978027</td>\n",
       "      <td>2473.913394</td>\n",
       "      <td>2742.637462</td>\n",
       "      <td>2627.633072</td>\n",
       "      <td>2403.618307</td>\n",
       "      <td>7430.377509</td>\n",
       "      <td>7619.478694</td>\n",
       "      <td>6336.230506</td>\n",
       "      <td>7858.231696</td>\n",
       "      <td>7353.247588</td>\n",
       "      <td>...</td>\n",
       "      <td>2663.073626</td>\n",
       "      <td>2432.720063</td>\n",
       "      <td>2636.928359</td>\n",
       "      <td>2720.717072</td>\n",
       "      <td>7652.762214</td>\n",
       "      <td>7389.191880</td>\n",
       "      <td>7802.266881</td>\n",
       "      <td>7051.368683</td>\n",
       "      <td>7135.505364</td>\n",
       "      <td>99758.270515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-08-15</th>\n",
       "      <td>2632.742421</td>\n",
       "      <td>2433.919726</td>\n",
       "      <td>2731.547422</td>\n",
       "      <td>2603.400378</td>\n",
       "      <td>2486.892570</td>\n",
       "      <td>7361.651328</td>\n",
       "      <td>7579.568947</td>\n",
       "      <td>6222.845330</td>\n",
       "      <td>7861.066208</td>\n",
       "      <td>7764.716309</td>\n",
       "      <td>...</td>\n",
       "      <td>2722.208130</td>\n",
       "      <td>2405.257130</td>\n",
       "      <td>2642.503855</td>\n",
       "      <td>2753.409993</td>\n",
       "      <td>7556.319404</td>\n",
       "      <td>7300.227042</td>\n",
       "      <td>7946.801579</td>\n",
       "      <td>6670.548027</td>\n",
       "      <td>7027.853721</td>\n",
       "      <td>99634.641842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-08-22</th>\n",
       "      <td>2621.919235</td>\n",
       "      <td>2428.206068</td>\n",
       "      <td>2771.568195</td>\n",
       "      <td>2722.649745</td>\n",
       "      <td>2510.000000</td>\n",
       "      <td>7454.167677</td>\n",
       "      <td>7724.838713</td>\n",
       "      <td>6176.157242</td>\n",
       "      <td>7975.856877</td>\n",
       "      <td>7827.685403</td>\n",
       "      <td>...</td>\n",
       "      <td>2836.759851</td>\n",
       "      <td>2488.604379</td>\n",
       "      <td>2688.224693</td>\n",
       "      <td>2846.961781</td>\n",
       "      <td>7737.455318</td>\n",
       "      <td>7578.641991</td>\n",
       "      <td>8043.587982</td>\n",
       "      <td>6546.904877</td>\n",
       "      <td>7157.035692</td>\n",
       "      <td>101255.171674</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-08-29</th>\n",
       "      <td>2608.390446</td>\n",
       "      <td>2325.364378</td>\n",
       "      <td>2721.421443</td>\n",
       "      <td>2697.460859</td>\n",
       "      <td>2448.961178</td>\n",
       "      <td>7274.421568</td>\n",
       "      <td>7739.206072</td>\n",
       "      <td>6111.683519</td>\n",
       "      <td>8296.138250</td>\n",
       "      <td>7696.319233</td>\n",
       "      <td>...</td>\n",
       "      <td>2851.965606</td>\n",
       "      <td>2502.974484</td>\n",
       "      <td>2682.834961</td>\n",
       "      <td>2859.399552</td>\n",
       "      <td>7727.664147</td>\n",
       "      <td>7639.445273</td>\n",
       "      <td>8119.726006</td>\n",
       "      <td>5957.126996</td>\n",
       "      <td>7031.441879</td>\n",
       "      <td>100474.915360</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-05</th>\n",
       "      <td>2635.448282</td>\n",
       "      <td>2333.934588</td>\n",
       "      <td>2708.884941</td>\n",
       "      <td>2697.460859</td>\n",
       "      <td>2488.636546</td>\n",
       "      <td>7197.764988</td>\n",
       "      <td>7933.963824</td>\n",
       "      <td>6287.319479</td>\n",
       "      <td>8379.751461</td>\n",
       "      <td>7781.001089</td>\n",
       "      <td>...</td>\n",
       "      <td>2849.739136</td>\n",
       "      <td>2442.939018</td>\n",
       "      <td>2656.443024</td>\n",
       "      <td>2819.941797</td>\n",
       "      <td>7637.096190</td>\n",
       "      <td>7716.889183</td>\n",
       "      <td>8126.178532</td>\n",
       "      <td>6079.533450</td>\n",
       "      <td>6965.954371</td>\n",
       "      <td>100719.766988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-12</th>\n",
       "      <td>2624.625096</td>\n",
       "      <td>2308.224096</td>\n",
       "      <td>2684.293595</td>\n",
       "      <td>2760.592847</td>\n",
       "      <td>2434.137718</td>\n",
       "      <td>7247.988105</td>\n",
       "      <td>8107.968309</td>\n",
       "      <td>6214.743255</td>\n",
       "      <td>8344.322236</td>\n",
       "      <td>7688.719558</td>\n",
       "      <td>...</td>\n",
       "      <td>2886.400317</td>\n",
       "      <td>2426.333432</td>\n",
       "      <td>2667.222773</td>\n",
       "      <td>2838.812897</td>\n",
       "      <td>7616.985103</td>\n",
       "      <td>6978.289957</td>\n",
       "      <td>8284.262693</td>\n",
       "      <td>6023.894410</td>\n",
       "      <td>6898.672438</td>\n",
       "      <td>100016.737737</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-19</th>\n",
       "      <td>2627.330957</td>\n",
       "      <td>2305.367406</td>\n",
       "      <td>2703.580936</td>\n",
       "      <td>2694.591301</td>\n",
       "      <td>2465.093039</td>\n",
       "      <td>7274.421568</td>\n",
       "      <td>7994.626217</td>\n",
       "      <td>6277.270470</td>\n",
       "      <td>8233.782247</td>\n",
       "      <td>7656.149164</td>\n",
       "      <td>...</td>\n",
       "      <td>2871.124847</td>\n",
       "      <td>2336.918625</td>\n",
       "      <td>2707.553594</td>\n",
       "      <td>2844.817338</td>\n",
       "      <td>7677.613196</td>\n",
       "      <td>6879.085227</td>\n",
       "      <td>8170.055410</td>\n",
       "      <td>6283.544836</td>\n",
       "      <td>6941.732407</td>\n",
       "      <td>99786.573295</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-26</th>\n",
       "      <td>2630.036818</td>\n",
       "      <td>2239.663108</td>\n",
       "      <td>2626.335761</td>\n",
       "      <td>2696.823234</td>\n",
       "      <td>2427.597724</td>\n",
       "      <td>7192.478398</td>\n",
       "      <td>7825.564639</td>\n",
       "      <td>6085.222931</td>\n",
       "      <td>7920.587154</td>\n",
       "      <td>7306.564108</td>\n",
       "      <td>...</td>\n",
       "      <td>2773.022052</td>\n",
       "      <td>2317.586657</td>\n",
       "      <td>2655.699681</td>\n",
       "      <td>2743.170731</td>\n",
       "      <td>7571.637194</td>\n",
       "      <td>6809.961137</td>\n",
       "      <td>8057.137940</td>\n",
       "      <td>6104.262174</td>\n",
       "      <td>6833.184241</td>\n",
       "      <td>97634.225449</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-03</th>\n",
       "      <td>2632.742421</td>\n",
       "      <td>2425.349239</td>\n",
       "      <td>2604.473884</td>\n",
       "      <td>2733.809409</td>\n",
       "      <td>2663.904786</td>\n",
       "      <td>7242.701515</td>\n",
       "      <td>7923.100093</td>\n",
       "      <td>6741.757194</td>\n",
       "      <td>7967.353884</td>\n",
       "      <td>7845.056447</td>\n",
       "      <td>...</td>\n",
       "      <td>2673.561107</td>\n",
       "      <td>2363.661307</td>\n",
       "      <td>2632.839547</td>\n",
       "      <td>2677.979658</td>\n",
       "      <td>7527.767964</td>\n",
       "      <td>6894.445806</td>\n",
       "      <td>7780.329183</td>\n",
       "      <td>6582.761504</td>\n",
       "      <td>6818.830918</td>\n",
       "      <td>99509.953911</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-10</th>\n",
       "      <td>2635.448282</td>\n",
       "      <td>2419.636135</td>\n",
       "      <td>2574.353179</td>\n",
       "      <td>2672.271728</td>\n",
       "      <td>2659.299489</td>\n",
       "      <td>7203.051578</td>\n",
       "      <td>7558.968848</td>\n",
       "      <td>6895.841431</td>\n",
       "      <td>7737.254411</td>\n",
       "      <td>7739.746424</td>\n",
       "      <td>...</td>\n",
       "      <td>2693.928401</td>\n",
       "      <td>2677.484316</td>\n",
       "      <td>2579.498665</td>\n",
       "      <td>2677.550770</td>\n",
       "      <td>7403.553668</td>\n",
       "      <td>6959.089233</td>\n",
       "      <td>7454.481329</td>\n",
       "      <td>6674.257171</td>\n",
       "      <td>6733.606127</td>\n",
       "      <td>98653.538394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-17</th>\n",
       "      <td>2640.860005</td>\n",
       "      <td>2533.904311</td>\n",
       "      <td>2634.594589</td>\n",
       "      <td>2687.257632</td>\n",
       "      <td>2717.291800</td>\n",
       "      <td>7014.119981</td>\n",
       "      <td>7593.105978</td>\n",
       "      <td>7248.672689</td>\n",
       "      <td>7837.126880</td>\n",
       "      <td>7782.087352</td>\n",
       "      <td>...</td>\n",
       "      <td>2641.991750</td>\n",
       "      <td>2575.346884</td>\n",
       "      <td>2645.106267</td>\n",
       "      <td>2655.677449</td>\n",
       "      <td>7701.273563</td>\n",
       "      <td>7062.134108</td>\n",
       "      <td>7541.589191</td>\n",
       "      <td>7182.430592</td>\n",
       "      <td>6799.991536</td>\n",
       "      <td>100175.830422</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-24</th>\n",
       "      <td>2646.271469</td>\n",
       "      <td>2638.174277</td>\n",
       "      <td>2620.505804</td>\n",
       "      <td>2693.634618</td>\n",
       "      <td>2661.496302</td>\n",
       "      <td>6825.495732</td>\n",
       "      <td>7823.939328</td>\n",
       "      <td>7628.301446</td>\n",
       "      <td>7874.222089</td>\n",
       "      <td>7774.487677</td>\n",
       "      <td>...</td>\n",
       "      <td>2749.259775</td>\n",
       "      <td>2485.775245</td>\n",
       "      <td>2645.477510</td>\n",
       "      <td>2678.408547</td>\n",
       "      <td>7792.462024</td>\n",
       "      <td>6959.244420</td>\n",
       "      <td>7566.821102</td>\n",
       "      <td>7034.058718</td>\n",
       "      <td>6753.342032</td>\n",
       "      <td>100485.471886</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              MON_price    KMI_price     KO_price    CVS_price    USB_price  \\\n",
       "Date                                                                          \n",
       "2021-07-04  2612.448980  2612.448980  2612.448980  2612.448980  2510.000000   \n",
       "2021-07-11  2632.742421  2594.160625  2597.983613  2572.832784  2441.985274   \n",
       "2021-07-18  2624.625096  2605.414976  2626.914346  2593.116409  2510.436078   \n",
       "2021-07-25  2616.507771  2416.902180  2687.186706  2556.669255  2376.586680   \n",
       "2021-08-01  2617.860702  2508.344783  2751.316793  2642.300163  2449.397256   \n",
       "2021-08-08  2625.978027  2473.913394  2742.637462  2627.633072  2403.618307   \n",
       "2021-08-15  2632.742421  2433.919726  2731.547422  2603.400378  2486.892570   \n",
       "2021-08-22  2621.919235  2428.206068  2771.568195  2722.649745  2510.000000   \n",
       "2021-08-29  2608.390446  2325.364378  2721.421443  2697.460859  2448.961178   \n",
       "2021-09-05  2635.448282  2333.934588  2708.884941  2697.460859  2488.636546   \n",
       "2021-09-12  2624.625096  2308.224096  2684.293595  2760.592847  2434.137718   \n",
       "2021-09-19  2627.330957  2305.367406  2703.580936  2694.591301  2465.093039   \n",
       "2021-09-26  2630.036818  2239.663108  2626.335761  2696.823234  2427.597724   \n",
       "2021-10-03  2632.742421  2425.349239  2604.473884  2733.809409  2663.904786   \n",
       "2021-10-10  2635.448282  2419.636135  2574.353179  2672.271728  2659.299489   \n",
       "2021-10-17  2640.860005  2533.904311  2634.594589  2687.257632  2717.291800   \n",
       "2021-10-24  2646.271469  2638.174277  2620.505804  2693.634618  2661.496302   \n",
       "\n",
       "                T_price     MO_price    SLB_price   CSCO_price      C_price  \\\n",
       "Date                                                                          \n",
       "2021-07-04  7587.551020  7587.551020  7290.000000  7587.551020  7587.551020   \n",
       "2021-07-11  7533.039423  7450.262708  6929.835049  7508.189577  7350.473527   \n",
       "2021-07-18  7528.179934  7581.165734  6940.951443  7543.618803  7483.021907   \n",
       "2021-07-25  7345.791044  7469.419808  5924.931164  7519.527082  7013.176935   \n",
       "2021-08-01  7448.880573  7600.322214  6549.661099  7861.066208  7303.057528   \n",
       "2021-08-08  7430.377509  7619.478694  6336.230506  7858.231696  7353.247588   \n",
       "2021-08-15  7361.651328  7579.568947  6222.845330  7861.066208  7764.716309   \n",
       "2021-08-22  7454.167677  7724.838713  6176.157242  7975.856877  7827.685403   \n",
       "2021-08-29  7274.421568  7739.206072  6111.683519  8296.138250  7696.319233   \n",
       "2021-09-05  7197.764988  7933.963824  6287.319479  8379.751461  7781.001089   \n",
       "2021-09-12  7247.988105  8107.968309  6214.743255  8344.322236  7688.719558   \n",
       "2021-09-19  7274.421568  7994.626217  6277.270470  8233.782247  7656.149164   \n",
       "2021-09-26  7192.478398  7825.564639  6085.222931  7920.587154  7306.564108   \n",
       "2021-10-03  7242.701515  7923.100093  6741.757194  7967.353884  7845.056447   \n",
       "2021-10-10  7203.051578  7558.968848  6895.841431  7737.254411  7739.746424   \n",
       "2021-10-17  7014.119981  7593.105978  7248.672689  7837.126880  7782.087352   \n",
       "2021-10-24  6825.495732  7823.939328  7628.301446  7874.222089  7774.487677   \n",
       "\n",
       "            ...    NEE_price    MRK_price     PG_price     SO_price  \\\n",
       "Date        ...                                                       \n",
       "2021-07-04  ...  2510.000000  2510.000000  2510.000000  2612.448980   \n",
       "2021-07-11  ...  2538.722473  2494.352372  2511.477554  2617.119302   \n",
       "2021-07-18  ...  2537.370827  2476.469509  2532.902081  2623.912574   \n",
       "2021-07-25  ...  2601.573743  2460.502807  2593.851594  2665.946141   \n",
       "2021-08-01  ...  2598.870711  2466.569874  2607.191238  2705.856758   \n",
       "2021-08-08  ...  2663.073626  2432.720063  2636.928359  2720.717072   \n",
       "2021-08-15  ...  2722.208130  2405.257130  2642.503855  2753.409993   \n",
       "2021-08-22  ...  2836.759851  2488.604379  2688.224693  2846.961781   \n",
       "2021-08-29  ...  2851.965606  2502.974484  2682.834961  2859.399552   \n",
       "2021-09-05  ...  2849.739136  2442.939018  2656.443024  2819.941797   \n",
       "2021-09-12  ...  2886.400317  2426.333432  2667.222773  2838.812897   \n",
       "2021-09-19  ...  2871.124847  2336.918625  2707.553594  2844.817338   \n",
       "2021-09-26  ...  2773.022052  2317.586657  2655.699681  2743.170731   \n",
       "2021-10-03  ...  2673.561107  2363.661307  2632.839547  2677.979658   \n",
       "2021-10-10  ...  2693.928401  2677.484316  2579.498665  2677.550770   \n",
       "2021-10-17  ...  2641.991750  2575.346884  2645.106267  2655.677449   \n",
       "2021-10-24  ...  2749.259775  2485.775245  2645.477510  2678.408547   \n",
       "\n",
       "              PEP_price   ABBV_price    ABT_price     GM_price     CL_price  \\\n",
       "Date                                                                          \n",
       "2021-07-04  7290.000000  7290.000000  7587.551020  7290.000000  7290.000000   \n",
       "2021-07-11  7300.770439  7325.446959  7637.688682  7104.535275  7314.091823   \n",
       "2021-07-18  7319.372761  7445.712190  7637.045752  7291.236696  7399.751793   \n",
       "2021-07-25  7627.305018  7387.271808  7664.830604  6698.985895  7492.550209   \n",
       "2021-08-01  7689.478729  7538.960000  7711.933003  6895.578522  7543.684395   \n",
       "2021-08-08  7652.762214  7389.191880  7802.266881  7051.368683  7135.505364   \n",
       "2021-08-15  7556.319404  7300.227042  7946.801579  6670.548027  7027.853721   \n",
       "2021-08-22  7737.455318  7578.641991  8043.587982  6546.904877  7157.035692   \n",
       "2021-08-29  7727.664147  7639.445273  8119.726006  5957.126996  7031.441879   \n",
       "2021-09-05  7637.096190  7716.889183  8126.178532  6079.533450  6965.954371   \n",
       "2021-09-12  7616.985103  6978.289957  8284.262693  6023.894410  6898.672438   \n",
       "2021-09-19  7677.613196  6879.085227  8170.055410  6283.544836  6941.732407   \n",
       "2021-09-26  7571.637194  6809.961137  8057.137940  6104.262174  6833.184241   \n",
       "2021-10-03  7527.767964  6894.445806  7780.329183  6582.761504  6818.830918   \n",
       "2021-10-10  7403.553668  6959.089233  7454.481329  6674.257171  6733.606127   \n",
       "2021-10-17  7701.273563  7062.134108  7541.589191  7182.430592  6799.991536   \n",
       "2021-10-24  7792.462024  6959.244420  7566.821102  7034.058718  6753.342032   \n",
       "\n",
       "                    final  \n",
       "Date                       \n",
       "2021-07-04  100000.000000  \n",
       "2021-07-11   98937.912104  \n",
       "2021-07-18   99813.113977  \n",
       "2021-07-25   97656.050597  \n",
       "2021-08-01  100131.737449  \n",
       "2021-08-08   99758.270515  \n",
       "2021-08-15   99634.641842  \n",
       "2021-08-22  101255.171674  \n",
       "2021-08-29  100474.915360  \n",
       "2021-09-05  100719.766988  \n",
       "2021-09-12  100016.737737  \n",
       "2021-09-19   99786.573295  \n",
       "2021-09-26   97634.225449  \n",
       "2021-10-03   99509.953911  \n",
       "2021-10-10   98653.538394  \n",
       "2021-10-17  100175.830422  \n",
       "2021-10-24  100485.471886  \n",
       "\n",
       "[17 rows x 21 columns]"
      ]
     },
     "execution_count": 155,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "lowest"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}