stock_analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "aceb2a5e",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import yfinance as yf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "d843c738",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n",
      "[*********************100%***********************]  1 of 1 completed\n"
     ]
    }
   ],
   "source": [
    "import yfinance as yf\n",
    "\n",
    "# Define the ticker symbols\n",
    "tickers = ['AAPL', 'AMGN', 'AXP', 'BA', 'CAT', 'CRM', 'CSCO', 'CVX', 'DIS',\n",
    "    'DOW', 'GS', 'HD', 'HON', 'IBM', 'INTC', 'JNJ', 'JPM', 'KO',\n",
    "    'MCD', 'MMM', 'MRK', 'MSFT', 'NKE', 'PG', 'TRV', 'UNH', 'V',\n",
    "    'VZ', 'WBA', 'WMT', 'DJI'\n",
    "]\n",
    "\n",
    "# Create a dictionary to hold dataframes\n",
    "dataframes = {}\n",
    "\n",
    "# Fetch data for each ticker\n",
    "for ticker in tickers:\n",
    "    data = yf.download(ticker)\n",
    "    dataframes[ticker] = data\n",
    "\n",
    "# set up params: \n",
    "def create_ticker_variables(dataframes):\n",
    "    for ticker, data in dataframes.items():\n",
    "        globals()[ticker.lower()] = data\n",
    "        \n",
    "create_ticker_variables(dataframes)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "2cbd303d",
   "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>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1962-01-02</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.250000</td>\n",
       "      <td>4.125000</td>\n",
       "      <td>4.156250</td>\n",
       "      <td>0.724556</td>\n",
       "      <td>212800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-03</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>4.085938</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.730004</td>\n",
       "      <td>422400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-04</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.257813</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.730004</td>\n",
       "      <td>212800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-05</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.171875</td>\n",
       "      <td>4.062500</td>\n",
       "      <td>4.078125</td>\n",
       "      <td>0.710936</td>\n",
       "      <td>315200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-08</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.085938</td>\n",
       "      <td>4.031250</td>\n",
       "      <td>4.054688</td>\n",
       "      <td>0.706851</td>\n",
       "      <td>334400</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Open      High       Low     Close  Adj Close  Volume\n",
       "Date                                                             \n",
       "1962-01-02   0.0  4.250000  4.125000  4.156250   0.724556  212800\n",
       "1962-01-03   0.0  4.187500  4.085938  4.187500   0.730004  422400\n",
       "1962-01-04   0.0  4.257813  4.187500  4.187500   0.730004  212800\n",
       "1962-01-05   0.0  4.171875  4.062500  4.078125   0.710936  315200\n",
       "1962-01-08   0.0  4.085938  4.031250  4.054688   0.706851  334400"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mmm.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "f2c53170",
   "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>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2023-07-20</th>\n",
       "      <td>103.169998</td>\n",
       "      <td>104.730003</td>\n",
       "      <td>102.510002</td>\n",
       "      <td>104.290001</td>\n",
       "      <td>104.290001</td>\n",
       "      <td>2866300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-07-21</th>\n",
       "      <td>104.169998</td>\n",
       "      <td>104.540001</td>\n",
       "      <td>103.220001</td>\n",
       "      <td>104.330002</td>\n",
       "      <td>104.330002</td>\n",
       "      <td>2498700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-07-24</th>\n",
       "      <td>104.529999</td>\n",
       "      <td>105.599998</td>\n",
       "      <td>103.980003</td>\n",
       "      <td>104.269997</td>\n",
       "      <td>104.269997</td>\n",
       "      <td>3333400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-07-25</th>\n",
       "      <td>107.550003</td>\n",
       "      <td>110.849998</td>\n",
       "      <td>107.010002</td>\n",
       "      <td>109.830002</td>\n",
       "      <td>109.830002</td>\n",
       "      <td>8773000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-07-26</th>\n",
       "      <td>109.839996</td>\n",
       "      <td>111.919998</td>\n",
       "      <td>109.870003</td>\n",
       "      <td>111.580002</td>\n",
       "      <td>111.580002</td>\n",
       "      <td>880552</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Open        High         Low       Close   Adj Close  \\\n",
       "Date                                                                     \n",
       "2023-07-20  103.169998  104.730003  102.510002  104.290001  104.290001   \n",
       "2023-07-21  104.169998  104.540001  103.220001  104.330002  104.330002   \n",
       "2023-07-24  104.529999  105.599998  103.980003  104.269997  104.269997   \n",
       "2023-07-25  107.550003  110.849998  107.010002  109.830002  109.830002   \n",
       "2023-07-26  109.839996  111.919998  109.870003  111.580002  111.580002   \n",
       "\n",
       "             Volume  \n",
       "Date                 \n",
       "2023-07-20  2866300  \n",
       "2023-07-21  2498700  \n",
       "2023-07-24  3333400  \n",
       "2023-07-25  8773000  \n",
       "2023-07-26   880552  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mmm.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "5334a8db",
   "metadata": {},
   "outputs": [],
   "source": [
    "for df in dataframes.values():\n",
    "    df['MA50'] = df.Close.rolling(50).mean()\n",
    "    df['MA200'] = df.Close.rolling(200).mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "8005a98d",
   "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>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>MA50</th>\n",
       "      <th>MA200</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1962-01-02</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.250000</td>\n",
       "      <td>4.125000</td>\n",
       "      <td>4.156250</td>\n",
       "      <td>0.724556</td>\n",
       "      <td>212800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-03</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>4.085938</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.730004</td>\n",
       "      <td>422400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-04</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.257813</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.730004</td>\n",
       "      <td>212800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-05</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.171875</td>\n",
       "      <td>4.062500</td>\n",
       "      <td>4.078125</td>\n",
       "      <td>0.710936</td>\n",
       "      <td>315200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-08</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.085938</td>\n",
       "      <td>4.031250</td>\n",
       "      <td>4.054688</td>\n",
       "      <td>0.706851</td>\n",
       "      <td>334400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-10-09</th>\n",
       "      <td>0.0</td>\n",
       "      <td>3.085938</td>\n",
       "      <td>3.054688</td>\n",
       "      <td>3.078125</td>\n",
       "      <td>0.540228</td>\n",
       "      <td>70400</td>\n",
       "      <td>3.190781</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-10-10</th>\n",
       "      <td>0.0</td>\n",
       "      <td>3.132813</td>\n",
       "      <td>3.070313</td>\n",
       "      <td>3.070313</td>\n",
       "      <td>0.538857</td>\n",
       "      <td>193600</td>\n",
       "      <td>3.188594</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-10-11</th>\n",
       "      <td>0.0</td>\n",
       "      <td>3.070313</td>\n",
       "      <td>3.039063</td>\n",
       "      <td>3.046875</td>\n",
       "      <td>0.534744</td>\n",
       "      <td>86400</td>\n",
       "      <td>3.187344</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-10-12</th>\n",
       "      <td>0.0</td>\n",
       "      <td>3.046875</td>\n",
       "      <td>3.015625</td>\n",
       "      <td>3.023438</td>\n",
       "      <td>0.530631</td>\n",
       "      <td>84800</td>\n",
       "      <td>3.184375</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-10-15</th>\n",
       "      <td>0.0</td>\n",
       "      <td>3.101563</td>\n",
       "      <td>3.015625</td>\n",
       "      <td>3.085938</td>\n",
       "      <td>0.541600</td>\n",
       "      <td>94400</td>\n",
       "      <td>3.183906</td>\n",
       "      <td>3.652578</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>200 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Open      High       Low     Close  Adj Close  Volume      MA50  \\\n",
       "Date                                                                          \n",
       "1962-01-02   0.0  4.250000  4.125000  4.156250   0.724556  212800       NaN   \n",
       "1962-01-03   0.0  4.187500  4.085938  4.187500   0.730004  422400       NaN   \n",
       "1962-01-04   0.0  4.257813  4.187500  4.187500   0.730004  212800       NaN   \n",
       "1962-01-05   0.0  4.171875  4.062500  4.078125   0.710936  315200       NaN   \n",
       "1962-01-08   0.0  4.085938  4.031250  4.054688   0.706851  334400       NaN   \n",
       "...          ...       ...       ...       ...        ...     ...       ...   \n",
       "1962-10-09   0.0  3.085938  3.054688  3.078125   0.540228   70400  3.190781   \n",
       "1962-10-10   0.0  3.132813  3.070313  3.070313   0.538857  193600  3.188594   \n",
       "1962-10-11   0.0  3.070313  3.039063  3.046875   0.534744   86400  3.187344   \n",
       "1962-10-12   0.0  3.046875  3.015625  3.023438   0.530631   84800  3.184375   \n",
       "1962-10-15   0.0  3.101563  3.015625  3.085938   0.541600   94400  3.183906   \n",
       "\n",
       "               MA200  \n",
       "Date                  \n",
       "1962-01-02       NaN  \n",
       "1962-01-03       NaN  \n",
       "1962-01-04       NaN  \n",
       "1962-01-05       NaN  \n",
       "1962-01-08       NaN  \n",
       "...              ...  \n",
       "1962-10-09       NaN  \n",
       "1962-10-10       NaN  \n",
       "1962-10-11       NaN  \n",
       "1962-10-12       NaN  \n",
       "1962-10-15  3.652578  \n",
       "\n",
       "[200 rows x 8 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mmm.head(200)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "30a68b0b",
   "metadata": {},
   "outputs": [],
   "source": [
    "for df in dataframes.values():\n",
    "    df['Previous day close price'] = df.Close.shift(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "81a2dd54",
   "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>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>MA50</th>\n",
       "      <th>MA200</th>\n",
       "      <th>Previous day close price</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1962-01-02</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.250000</td>\n",
       "      <td>4.125000</td>\n",
       "      <td>4.156250</td>\n",
       "      <td>0.724556</td>\n",
       "      <td>212800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-03</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>4.085938</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.730004</td>\n",
       "      <td>422400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.156250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-04</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.257813</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.730004</td>\n",
       "      <td>212800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.187500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-05</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.171875</td>\n",
       "      <td>4.062500</td>\n",
       "      <td>4.078125</td>\n",
       "      <td>0.710936</td>\n",
       "      <td>315200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.187500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-08</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.085938</td>\n",
       "      <td>4.031250</td>\n",
       "      <td>4.054688</td>\n",
       "      <td>0.706851</td>\n",
       "      <td>334400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.078125</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Open      High       Low     Close  Adj Close  Volume  MA50  \\\n",
       "Date                                                                      \n",
       "1962-01-02   0.0  4.250000  4.125000  4.156250   0.724556  212800   NaN   \n",
       "1962-01-03   0.0  4.187500  4.085938  4.187500   0.730004  422400   NaN   \n",
       "1962-01-04   0.0  4.257813  4.187500  4.187500   0.730004  212800   NaN   \n",
       "1962-01-05   0.0  4.171875  4.062500  4.078125   0.710936  315200   NaN   \n",
       "1962-01-08   0.0  4.085938  4.031250  4.054688   0.706851  334400   NaN   \n",
       "\n",
       "            MA200  Previous day close price  \n",
       "Date                                         \n",
       "1962-01-02    NaN                       NaN  \n",
       "1962-01-03    NaN                  4.156250  \n",
       "1962-01-04    NaN                  4.187500  \n",
       "1962-01-05    NaN                  4.187500  \n",
       "1962-01-08    NaN                  4.078125  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mmm.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "33bb8e39",
   "metadata": {},
   "outputs": [],
   "source": [
    "for df in dataframes.values():\n",
    "    df['Change in price'] = df['Close'] - df['Previous day close price']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "66301043",
   "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>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>MA50</th>\n",
       "      <th>MA200</th>\n",
       "      <th>Previous day close price</th>\n",
       "      <th>Change in price</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1962-01-02</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.250000</td>\n",
       "      <td>4.125000</td>\n",
       "      <td>4.156250</td>\n",
       "      <td>0.724556</td>\n",
       "      <td>212800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-03</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>4.085938</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.730004</td>\n",
       "      <td>422400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.156250</td>\n",
       "      <td>0.031250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-04</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.257813</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.730004</td>\n",
       "      <td>212800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-05</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.171875</td>\n",
       "      <td>4.062500</td>\n",
       "      <td>4.078125</td>\n",
       "      <td>0.710936</td>\n",
       "      <td>315200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>-0.109375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-08</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.085938</td>\n",
       "      <td>4.031250</td>\n",
       "      <td>4.054688</td>\n",
       "      <td>0.706851</td>\n",
       "      <td>334400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.078125</td>\n",
       "      <td>-0.023437</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Open      High       Low     Close  Adj Close  Volume  MA50  \\\n",
       "Date                                                                      \n",
       "1962-01-02   0.0  4.250000  4.125000  4.156250   0.724556  212800   NaN   \n",
       "1962-01-03   0.0  4.187500  4.085938  4.187500   0.730004  422400   NaN   \n",
       "1962-01-04   0.0  4.257813  4.187500  4.187500   0.730004  212800   NaN   \n",
       "1962-01-05   0.0  4.171875  4.062500  4.078125   0.710936  315200   NaN   \n",
       "1962-01-08   0.0  4.085938  4.031250  4.054688   0.706851  334400   NaN   \n",
       "\n",
       "            MA200  Previous day close price  Change in price  \n",
       "Date                                                          \n",
       "1962-01-02    NaN                       NaN              NaN  \n",
       "1962-01-03    NaN                  4.156250         0.031250  \n",
       "1962-01-04    NaN                  4.187500         0.000000  \n",
       "1962-01-05    NaN                  4.187500        -0.109375  \n",
       "1962-01-08    NaN                  4.078125        -0.023437  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mmm.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "18a6f229",
   "metadata": {},
   "outputs": [],
   "source": [
    "for df in dataframes.values():\n",
    "    df['Percent change in price'] = df.Close.pct_change()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "89fa8c4a",
   "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>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>MA50</th>\n",
       "      <th>MA200</th>\n",
       "      <th>Previous day close price</th>\n",
       "      <th>Change in price</th>\n",
       "      <th>Percent change in price</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1962-01-02</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.250000</td>\n",
       "      <td>4.125000</td>\n",
       "      <td>4.156250</td>\n",
       "      <td>0.724556</td>\n",
       "      <td>212800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-03</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>4.085938</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.730004</td>\n",
       "      <td>422400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.156250</td>\n",
       "      <td>0.031250</td>\n",
       "      <td>0.007519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-04</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.257813</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.730004</td>\n",
       "      <td>212800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-05</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.171875</td>\n",
       "      <td>4.062500</td>\n",
       "      <td>4.078125</td>\n",
       "      <td>0.710936</td>\n",
       "      <td>315200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>-0.109375</td>\n",
       "      <td>-0.026119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-08</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.085938</td>\n",
       "      <td>4.031250</td>\n",
       "      <td>4.054688</td>\n",
       "      <td>0.706851</td>\n",
       "      <td>334400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.078125</td>\n",
       "      <td>-0.023437</td>\n",
       "      <td>-0.005747</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Open      High       Low     Close  Adj Close  Volume  MA50  \\\n",
       "Date                                                                      \n",
       "1962-01-02   0.0  4.250000  4.125000  4.156250   0.724556  212800   NaN   \n",
       "1962-01-03   0.0  4.187500  4.085938  4.187500   0.730004  422400   NaN   \n",
       "1962-01-04   0.0  4.257813  4.187500  4.187500   0.730004  212800   NaN   \n",
       "1962-01-05   0.0  4.171875  4.062500  4.078125   0.710936  315200   NaN   \n",
       "1962-01-08   0.0  4.085938  4.031250  4.054688   0.706851  334400   NaN   \n",
       "\n",
       "            MA200  Previous day close price  Change in price  \\\n",
       "Date                                                           \n",
       "1962-01-02    NaN                       NaN              NaN   \n",
       "1962-01-03    NaN                  4.156250         0.031250   \n",
       "1962-01-04    NaN                  4.187500         0.000000   \n",
       "1962-01-05    NaN                  4.187500        -0.109375   \n",
       "1962-01-08    NaN                  4.078125        -0.023437   \n",
       "\n",
       "            Percent change in price  \n",
       "Date                                 \n",
       "1962-01-02                      NaN  \n",
       "1962-01-03                 0.007519  \n",
       "1962-01-04                 0.000000  \n",
       "1962-01-05                -0.026119  \n",
       "1962-01-08                -0.005747  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mmm.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "4ac30a9f",
   "metadata": {},
   "outputs": [],
   "source": [
    "for df in dataframes.values():\n",
    "    df['Previous day volume'] = df.Volume.shift(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "909e1672",
   "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>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>MA50</th>\n",
       "      <th>MA200</th>\n",
       "      <th>Previous day close price</th>\n",
       "      <th>Change in price</th>\n",
       "      <th>Percent change in price</th>\n",
       "      <th>Previous day volume</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1962-01-02</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.250000</td>\n",
       "      <td>4.125000</td>\n",
       "      <td>4.156250</td>\n",
       "      <td>0.724556</td>\n",
       "      <td>212800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-03</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>4.085938</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.730004</td>\n",
       "      <td>422400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.156250</td>\n",
       "      <td>0.031250</td>\n",
       "      <td>0.007519</td>\n",
       "      <td>212800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-04</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.257813</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.730004</td>\n",
       "      <td>212800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>422400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-05</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.171875</td>\n",
       "      <td>4.062500</td>\n",
       "      <td>4.078125</td>\n",
       "      <td>0.710936</td>\n",
       "      <td>315200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>-0.109375</td>\n",
       "      <td>-0.026119</td>\n",
       "      <td>212800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-08</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.085938</td>\n",
       "      <td>4.031250</td>\n",
       "      <td>4.054688</td>\n",
       "      <td>0.706851</td>\n",
       "      <td>334400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.078125</td>\n",
       "      <td>-0.023437</td>\n",
       "      <td>-0.005747</td>\n",
       "      <td>315200.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Open      High       Low     Close  Adj Close  Volume  MA50  \\\n",
       "Date                                                                      \n",
       "1962-01-02   0.0  4.250000  4.125000  4.156250   0.724556  212800   NaN   \n",
       "1962-01-03   0.0  4.187500  4.085938  4.187500   0.730004  422400   NaN   \n",
       "1962-01-04   0.0  4.257813  4.187500  4.187500   0.730004  212800   NaN   \n",
       "1962-01-05   0.0  4.171875  4.062500  4.078125   0.710936  315200   NaN   \n",
       "1962-01-08   0.0  4.085938  4.031250  4.054688   0.706851  334400   NaN   \n",
       "\n",
       "            MA200  Previous day close price  Change in price  \\\n",
       "Date                                                           \n",
       "1962-01-02    NaN                       NaN              NaN   \n",
       "1962-01-03    NaN                  4.156250         0.031250   \n",
       "1962-01-04    NaN                  4.187500         0.000000   \n",
       "1962-01-05    NaN                  4.187500        -0.109375   \n",
       "1962-01-08    NaN                  4.078125        -0.023437   \n",
       "\n",
       "            Percent change in price  Previous day volume  \n",
       "Date                                                      \n",
       "1962-01-02                      NaN                  NaN  \n",
       "1962-01-03                 0.007519             212800.0  \n",
       "1962-01-04                 0.000000             422400.0  \n",
       "1962-01-05                -0.026119             212800.0  \n",
       "1962-01-08                -0.005747             315200.0  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mmm.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "a5364fb0",
   "metadata": {},
   "outputs": [],
   "source": [
    "for df in dataframes.values():\n",
    "    df['Change in volume'] = df['Volume'] - df['Previous day volume']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "e43e8c66",
   "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>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>MA50</th>\n",
       "      <th>MA200</th>\n",
       "      <th>Previous day close price</th>\n",
       "      <th>Change in price</th>\n",
       "      <th>Percent change in price</th>\n",
       "      <th>Previous day volume</th>\n",
       "      <th>Change in volume</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1962-01-02</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.250000</td>\n",
       "      <td>4.125000</td>\n",
       "      <td>4.156250</td>\n",
       "      <td>0.724556</td>\n",
       "      <td>212800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-03</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>4.085938</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.730004</td>\n",
       "      <td>422400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.156250</td>\n",
       "      <td>0.031250</td>\n",
       "      <td>0.007519</td>\n",
       "      <td>212800.0</td>\n",
       "      <td>209600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-04</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.257813</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.730004</td>\n",
       "      <td>212800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>422400.0</td>\n",
       "      <td>-209600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-05</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.171875</td>\n",
       "      <td>4.062500</td>\n",
       "      <td>4.078125</td>\n",
       "      <td>0.710936</td>\n",
       "      <td>315200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>-0.109375</td>\n",
       "      <td>-0.026119</td>\n",
       "      <td>212800.0</td>\n",
       "      <td>102400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-08</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.085938</td>\n",
       "      <td>4.031250</td>\n",
       "      <td>4.054688</td>\n",
       "      <td>0.706851</td>\n",
       "      <td>334400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.078125</td>\n",
       "      <td>-0.023437</td>\n",
       "      <td>-0.005747</td>\n",
       "      <td>315200.0</td>\n",
       "      <td>19200.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Open      High       Low     Close  Adj Close  Volume  MA50  \\\n",
       "Date                                                                      \n",
       "1962-01-02   0.0  4.250000  4.125000  4.156250   0.724556  212800   NaN   \n",
       "1962-01-03   0.0  4.187500  4.085938  4.187500   0.730004  422400   NaN   \n",
       "1962-01-04   0.0  4.257813  4.187500  4.187500   0.730004  212800   NaN   \n",
       "1962-01-05   0.0  4.171875  4.062500  4.078125   0.710936  315200   NaN   \n",
       "1962-01-08   0.0  4.085938  4.031250  4.054688   0.706851  334400   NaN   \n",
       "\n",
       "            MA200  Previous day close price  Change in price  \\\n",
       "Date                                                           \n",
       "1962-01-02    NaN                       NaN              NaN   \n",
       "1962-01-03    NaN                  4.156250         0.031250   \n",
       "1962-01-04    NaN                  4.187500         0.000000   \n",
       "1962-01-05    NaN                  4.187500        -0.109375   \n",
       "1962-01-08    NaN                  4.078125        -0.023437   \n",
       "\n",
       "            Percent change in price  Previous day volume  Change in volume  \n",
       "Date                                                                        \n",
       "1962-01-02                      NaN                  NaN               NaN  \n",
       "1962-01-03                 0.007519             212800.0          209600.0  \n",
       "1962-01-04                 0.000000             422400.0         -209600.0  \n",
       "1962-01-05                -0.026119             212800.0          102400.0  \n",
       "1962-01-08                -0.005747             315200.0           19200.0  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mmm.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "18c8b317",
   "metadata": {},
   "outputs": [],
   "source": [
    "for df in dataframes.values():\n",
    "    df['Percent change in volume'] = df.Volume.pct_change()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "56750b0c",
   "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>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>MA50</th>\n",
       "      <th>MA200</th>\n",
       "      <th>Previous day close price</th>\n",
       "      <th>Change in price</th>\n",
       "      <th>Percent change in price</th>\n",
       "      <th>Previous day volume</th>\n",
       "      <th>Change in volume</th>\n",
       "      <th>Percent change in volume</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1962-01-02</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.250000</td>\n",
       "      <td>4.125000</td>\n",
       "      <td>4.156250</td>\n",
       "      <td>0.724556</td>\n",
       "      <td>212800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-03</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>4.085938</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.730004</td>\n",
       "      <td>422400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.156250</td>\n",
       "      <td>0.031250</td>\n",
       "      <td>0.007519</td>\n",
       "      <td>212800.0</td>\n",
       "      <td>209600.0</td>\n",
       "      <td>0.984962</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-04</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.257813</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.730004</td>\n",
       "      <td>212800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>422400.0</td>\n",
       "      <td>-209600.0</td>\n",
       "      <td>-0.496212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-05</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.171875</td>\n",
       "      <td>4.062500</td>\n",
       "      <td>4.078125</td>\n",
       "      <td>0.710936</td>\n",
       "      <td>315200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>-0.109375</td>\n",
       "      <td>-0.026119</td>\n",
       "      <td>212800.0</td>\n",
       "      <td>102400.0</td>\n",
       "      <td>0.481203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-08</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.085938</td>\n",
       "      <td>4.031250</td>\n",
       "      <td>4.054688</td>\n",
       "      <td>0.706851</td>\n",
       "      <td>334400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.078125</td>\n",
       "      <td>-0.023437</td>\n",
       "      <td>-0.005747</td>\n",
       "      <td>315200.0</td>\n",
       "      <td>19200.0</td>\n",
       "      <td>0.060914</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Open      High       Low     Close  Adj Close  Volume  MA50  \\\n",
       "Date                                                                      \n",
       "1962-01-02   0.0  4.250000  4.125000  4.156250   0.724556  212800   NaN   \n",
       "1962-01-03   0.0  4.187500  4.085938  4.187500   0.730004  422400   NaN   \n",
       "1962-01-04   0.0  4.257813  4.187500  4.187500   0.730004  212800   NaN   \n",
       "1962-01-05   0.0  4.171875  4.062500  4.078125   0.710936  315200   NaN   \n",
       "1962-01-08   0.0  4.085938  4.031250  4.054688   0.706851  334400   NaN   \n",
       "\n",
       "            MA200  Previous day close price  Change in price  \\\n",
       "Date                                                           \n",
       "1962-01-02    NaN                       NaN              NaN   \n",
       "1962-01-03    NaN                  4.156250         0.031250   \n",
       "1962-01-04    NaN                  4.187500         0.000000   \n",
       "1962-01-05    NaN                  4.187500        -0.109375   \n",
       "1962-01-08    NaN                  4.078125        -0.023437   \n",
       "\n",
       "            Percent change in price  Previous day volume  Change in volume  \\\n",
       "Date                                                                         \n",
       "1962-01-02                      NaN                  NaN               NaN   \n",
       "1962-01-03                 0.007519             212800.0          209600.0   \n",
       "1962-01-04                 0.000000             422400.0         -209600.0   \n",
       "1962-01-05                -0.026119             212800.0          102400.0   \n",
       "1962-01-08                -0.005747             315200.0           19200.0   \n",
       "\n",
       "            Percent change in volume  \n",
       "Date                                  \n",
       "1962-01-02                       NaN  \n",
       "1962-01-03                  0.984962  \n",
       "1962-01-04                 -0.496212  \n",
       "1962-01-05                  0.481203  \n",
       "1962-01-08                  0.060914  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mmm.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ea11b5f2",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Speed it up and more!\n",
    "for df in dataframes.values():\n",
    "    # Relative Strength Index (RSI)\n",
    "    delta = df['Adj Close'].diff()\n",
    "    gain = (delta.where(delta > 0, 0)).fillna(0)\n",
    "    loss = (-delta.where(delta < 0, 0)).fillna(0)\n",
    "    avg_gain = gain.rolling(window=14).mean()\n",
    "    avg_loss = loss.rolling(window=14).mean()\n",
    "    rs = avg_gain / avg_loss\n",
    "    df['RSI'] = 100 - (100 / (1 + rs))\n",
    "    # Bollinger Bands\n",
    "    rolling_mean = df['Adj Close'].rolling(window=20).mean()\n",
    "    rolling_std = df['Adj Close'].rolling(window=20).std()\n",
    "    df['Bollinger Upper Band'] = rolling_mean + (rolling_std * 2)\n",
    "    df['Bollinger Lower Band'] = rolling_mean - (rolling_std * 2)\n",
    "    \n",
    "    #  Daily Return\n",
    "    df['Daily Return'] = df['Adj Close'].pct_change()\n",
    "    \n",
    "    # Cumulative Return\n",
    "    df['Cumulative Return'] = (1 + df['Daily Return']).cumprod()\n",
    "    \n",
    "    # 20-Day Volatility\n",
    "    df['20-Day Volatility'] = df['Daily Return'].rolling(window=20).std()\n",
    "    \n",
    "    # Price Volatility\n",
    "    df['Price Volatility'] = df['Adj Close'].rolling(window=10).std()\n",
    "    \n",
    "    # MACD - Moving Average Convergence Divergence\n",
    "    df['EMA12'] = df['Adj Close'].ewm(span=12, adjust=False).mean()\n",
    "    df['EMA26'] = df['Adj Close'].ewm(span=26, adjust=False).mean()\n",
    "    df['MACD'] = df['EMA12'] - df['EMA26']\n",
    "    df['Signal'] = df['MACD'].ewm(span=9, adjust=False).mean()\n",
    "    df['MACD_Histogram'] = df['MACD'] - df['Signal']\n",
    "    \n",
    "    # On Balance Volume (OBV)\n",
    "    df['Daily Returns'] = df['Adj Close'].pct_change()\n",
    "    df['Direction'] = [1 if x >= 0 else -1 for x in df['Daily Returns']]\n",
    "    df['Direction'][0] = 0\n",
    "    df['OBV'] = (df['Volume'] * df['Direction']).cumsum()\n",
    "    \n",
    "    # Price Rate of Change\n",
    "    df['ROC'] = df['Close'].pct_change(periods=12)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "e8de0a27",
   "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>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>MA50</th>\n",
       "      <th>MA200</th>\n",
       "      <th>Previous day close price</th>\n",
       "      <th>Change in price</th>\n",
       "      <th>...</th>\n",
       "      <th>Price Volatility</th>\n",
       "      <th>EMA12</th>\n",
       "      <th>EMA26</th>\n",
       "      <th>MACD</th>\n",
       "      <th>Signal</th>\n",
       "      <th>MACD_Histogram</th>\n",
       "      <th>Daily Returns</th>\n",
       "      <th>Direction</th>\n",
       "      <th>OBV</th>\n",
       "      <th>ROC</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>1962-01-02</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.250000</td>\n",
       "      <td>4.125000</td>\n",
       "      <td>4.156250</td>\n",
       "      <td>0.724556</td>\n",
       "      <td>212800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.724556</td>\n",
       "      <td>0.724556</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-03</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>4.085938</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.730004</td>\n",
       "      <td>422400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.156250</td>\n",
       "      <td>0.031250</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.725394</td>\n",
       "      <td>0.724959</td>\n",
       "      <td>0.000435</td>\n",
       "      <td>0.000087</td>\n",
       "      <td>0.000348</td>\n",
       "      <td>0.007519</td>\n",
       "      <td>1</td>\n",
       "      <td>422400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-04</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.257813</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.730004</td>\n",
       "      <td>212800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.726103</td>\n",
       "      <td>0.725333</td>\n",
       "      <td>0.000770</td>\n",
       "      <td>0.000224</td>\n",
       "      <td>0.000547</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>635200</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-05</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.171875</td>\n",
       "      <td>4.062500</td>\n",
       "      <td>4.078125</td>\n",
       "      <td>0.710936</td>\n",
       "      <td>315200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.187500</td>\n",
       "      <td>-0.109375</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.723770</td>\n",
       "      <td>0.724267</td>\n",
       "      <td>-0.000497</td>\n",
       "      <td>0.000079</td>\n",
       "      <td>-0.000576</td>\n",
       "      <td>-0.026120</td>\n",
       "      <td>-1</td>\n",
       "      <td>320000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-08</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.085938</td>\n",
       "      <td>4.031250</td>\n",
       "      <td>4.054688</td>\n",
       "      <td>0.706851</td>\n",
       "      <td>334400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.078125</td>\n",
       "      <td>-0.023437</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.721167</td>\n",
       "      <td>0.722977</td>\n",
       "      <td>-0.001810</td>\n",
       "      <td>-0.000298</td>\n",
       "      <td>-0.001511</td>\n",
       "      <td>-0.005747</td>\n",
       "      <td>-1</td>\n",
       "      <td>-14400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-09</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.085938</td>\n",
       "      <td>4.039063</td>\n",
       "      <td>4.054688</td>\n",
       "      <td>0.706851</td>\n",
       "      <td>315200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.054688</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.718964</td>\n",
       "      <td>0.721782</td>\n",
       "      <td>-0.002818</td>\n",
       "      <td>-0.000802</td>\n",
       "      <td>-0.002015</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>300800</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-10</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.046875</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>4.007813</td>\n",
       "      <td>0.698679</td>\n",
       "      <td>254400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.054688</td>\n",
       "      <td>-0.046875</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.715844</td>\n",
       "      <td>0.720071</td>\n",
       "      <td>-0.004227</td>\n",
       "      <td>-0.001487</td>\n",
       "      <td>-0.002740</td>\n",
       "      <td>-0.011561</td>\n",
       "      <td>-1</td>\n",
       "      <td>46400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-11</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.031250</td>\n",
       "      <td>3.898438</td>\n",
       "      <td>3.992188</td>\n",
       "      <td>0.695955</td>\n",
       "      <td>225600</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.007813</td>\n",
       "      <td>-0.015625</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.712784</td>\n",
       "      <td>0.718284</td>\n",
       "      <td>-0.005501</td>\n",
       "      <td>-0.002290</td>\n",
       "      <td>-0.003211</td>\n",
       "      <td>-0.003899</td>\n",
       "      <td>-1</td>\n",
       "      <td>-179200</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-12</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.046875</td>\n",
       "      <td>3.914063</td>\n",
       "      <td>3.914063</td>\n",
       "      <td>0.682336</td>\n",
       "      <td>579200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.992188</td>\n",
       "      <td>-0.078125</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.708099</td>\n",
       "      <td>0.715622</td>\n",
       "      <td>-0.007522</td>\n",
       "      <td>-0.003336</td>\n",
       "      <td>-0.004186</td>\n",
       "      <td>-0.019569</td>\n",
       "      <td>-1</td>\n",
       "      <td>-758400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-15</th>\n",
       "      <td>0.0</td>\n",
       "      <td>3.960938</td>\n",
       "      <td>3.914063</td>\n",
       "      <td>3.953125</td>\n",
       "      <td>0.689145</td>\n",
       "      <td>211200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.914063</td>\n",
       "      <td>0.039062</td>\n",
       "      <td>...</td>\n",
       "      <td>0.016659</td>\n",
       "      <td>0.705183</td>\n",
       "      <td>0.713660</td>\n",
       "      <td>-0.008477</td>\n",
       "      <td>-0.004364</td>\n",
       "      <td>-0.004112</td>\n",
       "      <td>0.009980</td>\n",
       "      <td>1</td>\n",
       "      <td>-547200</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-16</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.023438</td>\n",
       "      <td>3.937500</td>\n",
       "      <td>4.023438</td>\n",
       "      <td>0.701402</td>\n",
       "      <td>200000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.953125</td>\n",
       "      <td>0.070313</td>\n",
       "      <td>...</td>\n",
       "      <td>0.015605</td>\n",
       "      <td>0.704602</td>\n",
       "      <td>0.712752</td>\n",
       "      <td>-0.008151</td>\n",
       "      <td>-0.005122</td>\n",
       "      <td>-0.003029</td>\n",
       "      <td>0.017786</td>\n",
       "      <td>1</td>\n",
       "      <td>-347200</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-17</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.031250</td>\n",
       "      <td>3.968750</td>\n",
       "      <td>3.992188</td>\n",
       "      <td>0.695955</td>\n",
       "      <td>113600</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.023438</td>\n",
       "      <td>-0.031250</td>\n",
       "      <td>...</td>\n",
       "      <td>0.013111</td>\n",
       "      <td>0.703271</td>\n",
       "      <td>0.711508</td>\n",
       "      <td>-0.008237</td>\n",
       "      <td>-0.005745</td>\n",
       "      <td>-0.002492</td>\n",
       "      <td>-0.007767</td>\n",
       "      <td>-1</td>\n",
       "      <td>-460800</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-18</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.031250</td>\n",
       "      <td>3.976563</td>\n",
       "      <td>4.023438</td>\n",
       "      <td>0.701402</td>\n",
       "      <td>256000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.992188</td>\n",
       "      <td>0.031250</td>\n",
       "      <td>...</td>\n",
       "      <td>0.008633</td>\n",
       "      <td>0.702984</td>\n",
       "      <td>0.710760</td>\n",
       "      <td>-0.007776</td>\n",
       "      <td>-0.006151</td>\n",
       "      <td>-0.001625</td>\n",
       "      <td>0.007827</td>\n",
       "      <td>1</td>\n",
       "      <td>-204800</td>\n",
       "      <td>-0.031955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-19</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.015625</td>\n",
       "      <td>3.945313</td>\n",
       "      <td>3.976563</td>\n",
       "      <td>0.693232</td>\n",
       "      <td>142400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.023438</td>\n",
       "      <td>-0.046875</td>\n",
       "      <td>...</td>\n",
       "      <td>0.007663</td>\n",
       "      <td>0.701484</td>\n",
       "      <td>0.709461</td>\n",
       "      <td>-0.007978</td>\n",
       "      <td>-0.006516</td>\n",
       "      <td>-0.001461</td>\n",
       "      <td>-0.011649</td>\n",
       "      <td>-1</td>\n",
       "      <td>-347200</td>\n",
       "      <td>-0.050373</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-22</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.015625</td>\n",
       "      <td>3.953125</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>0.697317</td>\n",
       "      <td>206400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.976563</td>\n",
       "      <td>0.023437</td>\n",
       "      <td>...</td>\n",
       "      <td>0.006879</td>\n",
       "      <td>0.700843</td>\n",
       "      <td>0.708562</td>\n",
       "      <td>-0.007719</td>\n",
       "      <td>-0.006757</td>\n",
       "      <td>-0.000962</td>\n",
       "      <td>0.005893</td>\n",
       "      <td>1</td>\n",
       "      <td>-140800</td>\n",
       "      <td>-0.044776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-23</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.039063</td>\n",
       "      <td>3.984375</td>\n",
       "      <td>3.984375</td>\n",
       "      <td>0.694593</td>\n",
       "      <td>137600</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>-0.015625</td>\n",
       "      <td>...</td>\n",
       "      <td>0.005780</td>\n",
       "      <td>0.699881</td>\n",
       "      <td>0.707527</td>\n",
       "      <td>-0.007646</td>\n",
       "      <td>-0.006935</td>\n",
       "      <td>-0.000711</td>\n",
       "      <td>-0.003907</td>\n",
       "      <td>-1</td>\n",
       "      <td>-278400</td>\n",
       "      <td>-0.022989</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-24</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.015625</td>\n",
       "      <td>3.968750</td>\n",
       "      <td>4.015625</td>\n",
       "      <td>0.700041</td>\n",
       "      <td>116800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.984375</td>\n",
       "      <td>0.031250</td>\n",
       "      <td>...</td>\n",
       "      <td>0.005891</td>\n",
       "      <td>0.699906</td>\n",
       "      <td>0.706972</td>\n",
       "      <td>-0.007067</td>\n",
       "      <td>-0.006961</td>\n",
       "      <td>-0.000106</td>\n",
       "      <td>0.007844</td>\n",
       "      <td>1</td>\n",
       "      <td>-161600</td>\n",
       "      <td>-0.009634</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-25</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.031250</td>\n",
       "      <td>3.976563</td>\n",
       "      <td>3.992188</td>\n",
       "      <td>0.695955</td>\n",
       "      <td>347200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.015625</td>\n",
       "      <td>-0.023437</td>\n",
       "      <td>...</td>\n",
       "      <td>0.005891</td>\n",
       "      <td>0.699298</td>\n",
       "      <td>0.706156</td>\n",
       "      <td>-0.006858</td>\n",
       "      <td>-0.006940</td>\n",
       "      <td>0.000082</td>\n",
       "      <td>-0.005837</td>\n",
       "      <td>-1</td>\n",
       "      <td>-508800</td>\n",
       "      <td>-0.015414</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-26</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.015625</td>\n",
       "      <td>3.976563</td>\n",
       "      <td>4.007813</td>\n",
       "      <td>0.698679</td>\n",
       "      <td>99200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.992188</td>\n",
       "      <td>0.015625</td>\n",
       "      <td>...</td>\n",
       "      <td>0.003863</td>\n",
       "      <td>0.699203</td>\n",
       "      <td>0.705602</td>\n",
       "      <td>-0.006400</td>\n",
       "      <td>-0.006832</td>\n",
       "      <td>0.000433</td>\n",
       "      <td>0.003914</td>\n",
       "      <td>1</td>\n",
       "      <td>-409600</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1962-01-29</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.023438</td>\n",
       "      <td>3.945313</td>\n",
       "      <td>3.945313</td>\n",
       "      <td>0.687783</td>\n",
       "      <td>180800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.007813</td>\n",
       "      <td>-0.062500</td>\n",
       "      <td>...</td>\n",
       "      <td>0.004173</td>\n",
       "      <td>0.697446</td>\n",
       "      <td>0.704282</td>\n",
       "      <td>-0.006837</td>\n",
       "      <td>-0.006833</td>\n",
       "      <td>-0.000003</td>\n",
       "      <td>-0.015594</td>\n",
       "      <td>-1</td>\n",
       "      <td>-590400</td>\n",
       "      <td>-0.011742</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Open      High       Low     Close  Adj Close  Volume  MA50  \\\n",
       "Date                                                                      \n",
       "1962-01-02   0.0  4.250000  4.125000  4.156250   0.724556  212800   NaN   \n",
       "1962-01-03   0.0  4.187500  4.085938  4.187500   0.730004  422400   NaN   \n",
       "1962-01-04   0.0  4.257813  4.187500  4.187500   0.730004  212800   NaN   \n",
       "1962-01-05   0.0  4.171875  4.062500  4.078125   0.710936  315200   NaN   \n",
       "1962-01-08   0.0  4.085938  4.031250  4.054688   0.706851  334400   NaN   \n",
       "1962-01-09   0.0  4.085938  4.039063  4.054688   0.706851  315200   NaN   \n",
       "1962-01-10   0.0  4.046875  4.000000  4.007813   0.698679  254400   NaN   \n",
       "1962-01-11   0.0  4.031250  3.898438  3.992188   0.695955  225600   NaN   \n",
       "1962-01-12   0.0  4.046875  3.914063  3.914063   0.682336  579200   NaN   \n",
       "1962-01-15   0.0  3.960938  3.914063  3.953125   0.689145  211200   NaN   \n",
       "1962-01-16   0.0  4.023438  3.937500  4.023438   0.701402  200000   NaN   \n",
       "1962-01-17   0.0  4.031250  3.968750  3.992188   0.695955  113600   NaN   \n",
       "1962-01-18   0.0  4.031250  3.976563  4.023438   0.701402  256000   NaN   \n",
       "1962-01-19   0.0  4.015625  3.945313  3.976563   0.693232  142400   NaN   \n",
       "1962-01-22   0.0  4.015625  3.953125  4.000000   0.697317  206400   NaN   \n",
       "1962-01-23   0.0  4.039063  3.984375  3.984375   0.694593  137600   NaN   \n",
       "1962-01-24   0.0  4.015625  3.968750  4.015625   0.700041  116800   NaN   \n",
       "1962-01-25   0.0  4.031250  3.976563  3.992188   0.695955  347200   NaN   \n",
       "1962-01-26   0.0  4.015625  3.976563  4.007813   0.698679   99200   NaN   \n",
       "1962-01-29   0.0  4.023438  3.945313  3.945313   0.687783  180800   NaN   \n",
       "\n",
       "            MA200  Previous day close price  Change in price  ...  \\\n",
       "Date                                                          ...   \n",
       "1962-01-02    NaN                       NaN              NaN  ...   \n",
       "1962-01-03    NaN                  4.156250         0.031250  ...   \n",
       "1962-01-04    NaN                  4.187500         0.000000  ...   \n",
       "1962-01-05    NaN                  4.187500        -0.109375  ...   \n",
       "1962-01-08    NaN                  4.078125        -0.023437  ...   \n",
       "1962-01-09    NaN                  4.054688         0.000000  ...   \n",
       "1962-01-10    NaN                  4.054688        -0.046875  ...   \n",
       "1962-01-11    NaN                  4.007813        -0.015625  ...   \n",
       "1962-01-12    NaN                  3.992188        -0.078125  ...   \n",
       "1962-01-15    NaN                  3.914063         0.039062  ...   \n",
       "1962-01-16    NaN                  3.953125         0.070313  ...   \n",
       "1962-01-17    NaN                  4.023438        -0.031250  ...   \n",
       "1962-01-18    NaN                  3.992188         0.031250  ...   \n",
       "1962-01-19    NaN                  4.023438        -0.046875  ...   \n",
       "1962-01-22    NaN                  3.976563         0.023437  ...   \n",
       "1962-01-23    NaN                  4.000000        -0.015625  ...   \n",
       "1962-01-24    NaN                  3.984375         0.031250  ...   \n",
       "1962-01-25    NaN                  4.015625        -0.023437  ...   \n",
       "1962-01-26    NaN                  3.992188         0.015625  ...   \n",
       "1962-01-29    NaN                  4.007813        -0.062500  ...   \n",
       "\n",
       "            Price Volatility     EMA12     EMA26      MACD    Signal  \\\n",
       "Date                                                                   \n",
       "1962-01-02               NaN  0.724556  0.724556  0.000000  0.000000   \n",
       "1962-01-03               NaN  0.725394  0.724959  0.000435  0.000087   \n",
       "1962-01-04               NaN  0.726103  0.725333  0.000770  0.000224   \n",
       "1962-01-05               NaN  0.723770  0.724267 -0.000497  0.000079   \n",
       "1962-01-08               NaN  0.721167  0.722977 -0.001810 -0.000298   \n",
       "1962-01-09               NaN  0.718964  0.721782 -0.002818 -0.000802   \n",
       "1962-01-10               NaN  0.715844  0.720071 -0.004227 -0.001487   \n",
       "1962-01-11               NaN  0.712784  0.718284 -0.005501 -0.002290   \n",
       "1962-01-12               NaN  0.708099  0.715622 -0.007522 -0.003336   \n",
       "1962-01-15          0.016659  0.705183  0.713660 -0.008477 -0.004364   \n",
       "1962-01-16          0.015605  0.704602  0.712752 -0.008151 -0.005122   \n",
       "1962-01-17          0.013111  0.703271  0.711508 -0.008237 -0.005745   \n",
       "1962-01-18          0.008633  0.702984  0.710760 -0.007776 -0.006151   \n",
       "1962-01-19          0.007663  0.701484  0.709461 -0.007978 -0.006516   \n",
       "1962-01-22          0.006879  0.700843  0.708562 -0.007719 -0.006757   \n",
       "1962-01-23          0.005780  0.699881  0.707527 -0.007646 -0.006935   \n",
       "1962-01-24          0.005891  0.699906  0.706972 -0.007067 -0.006961   \n",
       "1962-01-25          0.005891  0.699298  0.706156 -0.006858 -0.006940   \n",
       "1962-01-26          0.003863  0.699203  0.705602 -0.006400 -0.006832   \n",
       "1962-01-29          0.004173  0.697446  0.704282 -0.006837 -0.006833   \n",
       "\n",
       "            MACD_Histogram  Daily Returns  Direction     OBV       ROC  \n",
       "Date                                                                    \n",
       "1962-01-02        0.000000            NaN          0       0       NaN  \n",
       "1962-01-03        0.000348       0.007519          1  422400       NaN  \n",
       "1962-01-04        0.000547       0.000000          1  635200       NaN  \n",
       "1962-01-05       -0.000576      -0.026120         -1  320000       NaN  \n",
       "1962-01-08       -0.001511      -0.005747         -1  -14400       NaN  \n",
       "1962-01-09       -0.002015       0.000000          1  300800       NaN  \n",
       "1962-01-10       -0.002740      -0.011561         -1   46400       NaN  \n",
       "1962-01-11       -0.003211      -0.003899         -1 -179200       NaN  \n",
       "1962-01-12       -0.004186      -0.019569         -1 -758400       NaN  \n",
       "1962-01-15       -0.004112       0.009980          1 -547200       NaN  \n",
       "1962-01-16       -0.003029       0.017786          1 -347200       NaN  \n",
       "1962-01-17       -0.002492      -0.007767         -1 -460800       NaN  \n",
       "1962-01-18       -0.001625       0.007827          1 -204800 -0.031955  \n",
       "1962-01-19       -0.001461      -0.011649         -1 -347200 -0.050373  \n",
       "1962-01-22       -0.000962       0.005893          1 -140800 -0.044776  \n",
       "1962-01-23       -0.000711      -0.003907         -1 -278400 -0.022989  \n",
       "1962-01-24       -0.000106       0.007844          1 -161600 -0.009634  \n",
       "1962-01-25        0.000082      -0.005837         -1 -508800 -0.015414  \n",
       "1962-01-26        0.000433       0.003914          1 -409600  0.000000  \n",
       "1962-01-29       -0.000003      -0.015594         -1 -590400 -0.011742  \n",
       "\n",
       "[20 rows x 30 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mmm.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "f3bea3ea",
   "metadata": {},
   "outputs": [],
   "source": [
    "for ticker, data in dataframes.items():\n",
    "    # Save dataframe to csv\n",
    "    data.to_csv(f'{ticker}.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "91e00cd3",
   "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.10.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}