Share_analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from pandas_datareader import data\n",
    "import numpy as np\n",
    "import matplotlib as plt\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th>Attributes</th>\n",
       "      <th colspan=\"3\" halign=\"left\">High</th>\n",
       "      <th colspan=\"3\" halign=\"left\">Low</th>\n",
       "      <th colspan=\"3\" halign=\"left\">Open</th>\n",
       "      <th colspan=\"3\" halign=\"left\">Close</th>\n",
       "      <th colspan=\"3\" halign=\"left\">Volume</th>\n",
       "      <th colspan=\"3\" halign=\"left\">Adj Close</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Symbols</th>\n",
       "      <th>AAPL</th>\n",
       "      <th>MSFT</th>\n",
       "      <th>^GSPC</th>\n",
       "      <th>AAPL</th>\n",
       "      <th>MSFT</th>\n",
       "      <th>^GSPC</th>\n",
       "      <th>AAPL</th>\n",
       "      <th>MSFT</th>\n",
       "      <th>^GSPC</th>\n",
       "      <th>AAPL</th>\n",
       "      <th>MSFT</th>\n",
       "      <th>^GSPC</th>\n",
       "      <th>AAPL</th>\n",
       "      <th>MSFT</th>\n",
       "      <th>^GSPC</th>\n",
       "      <th>AAPL</th>\n",
       "      <th>MSFT</th>\n",
       "      <th>^GSPC</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2009-12-31</th>\n",
       "      <td>30.478571</td>\n",
       "      <td>30.990000</td>\n",
       "      <td>1127.640015</td>\n",
       "      <td>30.080000</td>\n",
       "      <td>30.480000</td>\n",
       "      <td>1114.810059</td>\n",
       "      <td>30.447144</td>\n",
       "      <td>30.980000</td>\n",
       "      <td>1126.599976</td>\n",
       "      <td>30.104286</td>\n",
       "      <td>30.480000</td>\n",
       "      <td>1115.099976</td>\n",
       "      <td>88102700.0</td>\n",
       "      <td>31929700.0</td>\n",
       "      <td>2.076990e+09</td>\n",
       "      <td>19.996618</td>\n",
       "      <td>24.241983</td>\n",
       "      <td>1115.099976</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-04</th>\n",
       "      <td>30.642857</td>\n",
       "      <td>31.100000</td>\n",
       "      <td>1133.869995</td>\n",
       "      <td>30.340000</td>\n",
       "      <td>30.590000</td>\n",
       "      <td>1116.560059</td>\n",
       "      <td>30.490000</td>\n",
       "      <td>30.620001</td>\n",
       "      <td>1116.560059</td>\n",
       "      <td>30.572857</td>\n",
       "      <td>30.950001</td>\n",
       "      <td>1132.989990</td>\n",
       "      <td>123432400.0</td>\n",
       "      <td>38409100.0</td>\n",
       "      <td>3.991400e+09</td>\n",
       "      <td>20.307869</td>\n",
       "      <td>24.615801</td>\n",
       "      <td>1132.989990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-05</th>\n",
       "      <td>30.798571</td>\n",
       "      <td>31.100000</td>\n",
       "      <td>1136.630005</td>\n",
       "      <td>30.464285</td>\n",
       "      <td>30.639999</td>\n",
       "      <td>1129.660034</td>\n",
       "      <td>30.657143</td>\n",
       "      <td>30.850000</td>\n",
       "      <td>1132.660034</td>\n",
       "      <td>30.625713</td>\n",
       "      <td>30.959999</td>\n",
       "      <td>1136.520020</td>\n",
       "      <td>150476200.0</td>\n",
       "      <td>49749600.0</td>\n",
       "      <td>2.491020e+09</td>\n",
       "      <td>20.342979</td>\n",
       "      <td>24.623755</td>\n",
       "      <td>1136.520020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-06</th>\n",
       "      <td>30.747143</td>\n",
       "      <td>31.080000</td>\n",
       "      <td>1139.189941</td>\n",
       "      <td>30.107143</td>\n",
       "      <td>30.520000</td>\n",
       "      <td>1133.949951</td>\n",
       "      <td>30.625713</td>\n",
       "      <td>30.879999</td>\n",
       "      <td>1135.709961</td>\n",
       "      <td>30.138571</td>\n",
       "      <td>30.770000</td>\n",
       "      <td>1137.140015</td>\n",
       "      <td>138040000.0</td>\n",
       "      <td>58182400.0</td>\n",
       "      <td>4.972660e+09</td>\n",
       "      <td>20.019398</td>\n",
       "      <td>24.472631</td>\n",
       "      <td>1137.140015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-07</th>\n",
       "      <td>30.285715</td>\n",
       "      <td>30.700001</td>\n",
       "      <td>1142.459961</td>\n",
       "      <td>29.864286</td>\n",
       "      <td>30.190001</td>\n",
       "      <td>1131.319946</td>\n",
       "      <td>30.250000</td>\n",
       "      <td>30.629999</td>\n",
       "      <td>1136.270020</td>\n",
       "      <td>30.082857</td>\n",
       "      <td>30.450001</td>\n",
       "      <td>1141.689941</td>\n",
       "      <td>119282800.0</td>\n",
       "      <td>50559700.0</td>\n",
       "      <td>5.270680e+09</td>\n",
       "      <td>19.982389</td>\n",
       "      <td>24.218124</td>\n",
       "      <td>1141.689941</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Attributes       High                                Low             \\\n",
       "Symbols          AAPL       MSFT        ^GSPC       AAPL       MSFT   \n",
       "Date                                                                  \n",
       "2009-12-31  30.478571  30.990000  1127.640015  30.080000  30.480000   \n",
       "2010-01-04  30.642857  31.100000  1133.869995  30.340000  30.590000   \n",
       "2010-01-05  30.798571  31.100000  1136.630005  30.464285  30.639999   \n",
       "2010-01-06  30.747143  31.080000  1139.189941  30.107143  30.520000   \n",
       "2010-01-07  30.285715  30.700001  1142.459961  29.864286  30.190001   \n",
       "\n",
       "Attributes                    Open                              Close  \\\n",
       "Symbols           ^GSPC       AAPL       MSFT        ^GSPC       AAPL   \n",
       "Date                                                                    \n",
       "2009-12-31  1114.810059  30.447144  30.980000  1126.599976  30.104286   \n",
       "2010-01-04  1116.560059  30.490000  30.620001  1116.560059  30.572857   \n",
       "2010-01-05  1129.660034  30.657143  30.850000  1132.660034  30.625713   \n",
       "2010-01-06  1133.949951  30.625713  30.879999  1135.709961  30.138571   \n",
       "2010-01-07  1131.319946  30.250000  30.629999  1136.270020  30.082857   \n",
       "\n",
       "Attributes                               Volume                            \\\n",
       "Symbols          MSFT        ^GSPC         AAPL        MSFT         ^GSPC   \n",
       "Date                                                                        \n",
       "2009-12-31  30.480000  1115.099976   88102700.0  31929700.0  2.076990e+09   \n",
       "2010-01-04  30.950001  1132.989990  123432400.0  38409100.0  3.991400e+09   \n",
       "2010-01-05  30.959999  1136.520020  150476200.0  49749600.0  2.491020e+09   \n",
       "2010-01-06  30.770000  1137.140015  138040000.0  58182400.0  4.972660e+09   \n",
       "2010-01-07  30.450001  1141.689941  119282800.0  50559700.0  5.270680e+09   \n",
       "\n",
       "Attributes  Adj Close                          \n",
       "Symbols          AAPL       MSFT        ^GSPC  \n",
       "Date                                           \n",
       "2009-12-31  19.996618  24.241983  1115.099976  \n",
       "2010-01-04  20.307869  24.615801  1132.989990  \n",
       "2010-01-05  20.342979  24.623755  1136.520020  \n",
       "2010-01-06  20.019398  24.472631  1137.140015  \n",
       "2010-01-07  19.982389  24.218124  1141.689941  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tickers = ['AAPL','MSFT','^GSPC']\n",
    "start_date = '2010-01-01'\n",
    "end_date = '2016-12-31'\n",
    "dataset = data.DataReader(tickers,'yahoo',start_date,end_date)\n",
    "dataset.head()"
   ]
  },
  {
   "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.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}