Acquiring the data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import requests\n",
    "import datetime \n",
    "import pandas_datareader.data as web\n",
    "from yahoo_fin import stock_info as si"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "start = datetime.datetime(2019,12,30)\n",
    "end = datetime.datetime(2020,4,21)\n",
    "companies = ['AEF.MI','MONC.MI','BC.MI','SFER.MI','TOD.MI','MC.PA','CDI.PA','KER.PA']\n",
    "data = web.DataReader(companies,'yahoo',start,end)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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=\"8\" halign=\"left\">Adj Close</th>\n",
       "      <th colspan=\"2\" halign=\"left\">Close</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"2\" halign=\"left\">Open</th>\n",
       "      <th colspan=\"8\" halign=\"left\">Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Symbols</th>\n",
       "      <th>AEF.MI</th>\n",
       "      <th>MONC.MI</th>\n",
       "      <th>BC.MI</th>\n",
       "      <th>SFER.MI</th>\n",
       "      <th>TOD.MI</th>\n",
       "      <th>MC.PA</th>\n",
       "      <th>CDI.PA</th>\n",
       "      <th>KER.PA</th>\n",
       "      <th>AEF.MI</th>\n",
       "      <th>MONC.MI</th>\n",
       "      <th>...</th>\n",
       "      <th>CDI.PA</th>\n",
       "      <th>KER.PA</th>\n",
       "      <th>AEF.MI</th>\n",
       "      <th>MONC.MI</th>\n",
       "      <th>BC.MI</th>\n",
       "      <th>SFER.MI</th>\n",
       "      <th>TOD.MI</th>\n",
       "      <th>MC.PA</th>\n",
       "      <th>CDI.PA</th>\n",
       "      <th>KER.PA</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",
       "      <td>2019-12-30</td>\n",
       "      <td>1.994</td>\n",
       "      <td>40.070000</td>\n",
       "      <td>31.559999</td>\n",
       "      <td>18.750</td>\n",
       "      <td>41.220001</td>\n",
       "      <td>409.308960</td>\n",
       "      <td>453.052399</td>\n",
       "      <td>582.844177</td>\n",
       "      <td>1.994</td>\n",
       "      <td>40.070000</td>\n",
       "      <td>...</td>\n",
       "      <td>466.799988</td>\n",
       "      <td>591.299988</td>\n",
       "      <td>232038.0</td>\n",
       "      <td>736786.0</td>\n",
       "      <td>38656.0</td>\n",
       "      <td>216874.0</td>\n",
       "      <td>44792.0</td>\n",
       "      <td>226651.0</td>\n",
       "      <td>11640.0</td>\n",
       "      <td>144847.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2019-12-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>408.914062</td>\n",
       "      <td>450.880890</td>\n",
       "      <td>581.750671</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>459.000000</td>\n",
       "      <td>585.700012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>102945.0</td>\n",
       "      <td>4432.0</td>\n",
       "      <td>45380.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-01-02</td>\n",
       "      <td>2.030</td>\n",
       "      <td>40.590000</td>\n",
       "      <td>32.340000</td>\n",
       "      <td>18.955</td>\n",
       "      <td>42.000000</td>\n",
       "      <td>413.800873</td>\n",
       "      <td>455.816101</td>\n",
       "      <td>594.475220</td>\n",
       "      <td>2.030</td>\n",
       "      <td>40.590000</td>\n",
       "      <td>...</td>\n",
       "      <td>461.600006</td>\n",
       "      <td>592.700012</td>\n",
       "      <td>161368.0</td>\n",
       "      <td>472094.0</td>\n",
       "      <td>48975.0</td>\n",
       "      <td>252759.0</td>\n",
       "      <td>54621.0</td>\n",
       "      <td>347226.0</td>\n",
       "      <td>14531.0</td>\n",
       "      <td>178651.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-01-03</td>\n",
       "      <td>2.000</td>\n",
       "      <td>40.090000</td>\n",
       "      <td>32.119999</td>\n",
       "      <td>18.605</td>\n",
       "      <td>40.639999</td>\n",
       "      <td>413.751526</td>\n",
       "      <td>456.803131</td>\n",
       "      <td>597.358154</td>\n",
       "      <td>2.000</td>\n",
       "      <td>40.090000</td>\n",
       "      <td>...</td>\n",
       "      <td>461.000000</td>\n",
       "      <td>595.000000</td>\n",
       "      <td>131594.0</td>\n",
       "      <td>616330.0</td>\n",
       "      <td>52807.0</td>\n",
       "      <td>345428.0</td>\n",
       "      <td>100580.0</td>\n",
       "      <td>291716.0</td>\n",
       "      <td>7986.0</td>\n",
       "      <td>159019.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-01-06</td>\n",
       "      <td>1.942</td>\n",
       "      <td>40.070000</td>\n",
       "      <td>31.799999</td>\n",
       "      <td>18.555</td>\n",
       "      <td>39.599998</td>\n",
       "      <td>409.851929</td>\n",
       "      <td>455.223907</td>\n",
       "      <td>587.317688</td>\n",
       "      <td>1.942</td>\n",
       "      <td>40.070000</td>\n",
       "      <td>...</td>\n",
       "      <td>461.200012</td>\n",
       "      <td>595.700012</td>\n",
       "      <td>529221.0</td>\n",
       "      <td>918334.0</td>\n",
       "      <td>48714.0</td>\n",
       "      <td>319106.0</td>\n",
       "      <td>186368.0</td>\n",
       "      <td>363953.0</td>\n",
       "      <td>18007.0</td>\n",
       "      <td>176511.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-04-15</td>\n",
       "      <td>1.058</td>\n",
       "      <td>33.209999</td>\n",
       "      <td>25.940001</td>\n",
       "      <td>12.060</td>\n",
       "      <td>28.100000</td>\n",
       "      <td>337.635468</td>\n",
       "      <td>322.170593</td>\n",
       "      <td>475.000000</td>\n",
       "      <td>1.058</td>\n",
       "      <td>33.209999</td>\n",
       "      <td>...</td>\n",
       "      <td>344.799988</td>\n",
       "      <td>489.000000</td>\n",
       "      <td>262898.0</td>\n",
       "      <td>1565453.0</td>\n",
       "      <td>117443.0</td>\n",
       "      <td>536555.0</td>\n",
       "      <td>24012.0</td>\n",
       "      <td>743853.0</td>\n",
       "      <td>7661.0</td>\n",
       "      <td>165887.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-04-16</td>\n",
       "      <td>1.034</td>\n",
       "      <td>32.849998</td>\n",
       "      <td>26.540001</td>\n",
       "      <td>11.890</td>\n",
       "      <td>27.760000</td>\n",
       "      <td>338.425232</td>\n",
       "      <td>322.960236</td>\n",
       "      <td>477.250000</td>\n",
       "      <td>1.034</td>\n",
       "      <td>32.849998</td>\n",
       "      <td>...</td>\n",
       "      <td>324.200012</td>\n",
       "      <td>475.250000</td>\n",
       "      <td>124958.0</td>\n",
       "      <td>854571.0</td>\n",
       "      <td>64538.0</td>\n",
       "      <td>285689.0</td>\n",
       "      <td>20257.0</td>\n",
       "      <td>698898.0</td>\n",
       "      <td>11915.0</td>\n",
       "      <td>188754.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-04-17</td>\n",
       "      <td>1.054</td>\n",
       "      <td>34.520000</td>\n",
       "      <td>27.340000</td>\n",
       "      <td>12.150</td>\n",
       "      <td>28.340000</td>\n",
       "      <td>353.431274</td>\n",
       "      <td>343.688110</td>\n",
       "      <td>503.399994</td>\n",
       "      <td>1.054</td>\n",
       "      <td>34.520000</td>\n",
       "      <td>...</td>\n",
       "      <td>345.799988</td>\n",
       "      <td>493.950012</td>\n",
       "      <td>85964.0</td>\n",
       "      <td>943023.0</td>\n",
       "      <td>64848.0</td>\n",
       "      <td>351112.0</td>\n",
       "      <td>18670.0</td>\n",
       "      <td>1230602.0</td>\n",
       "      <td>23739.0</td>\n",
       "      <td>351155.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-04-20</td>\n",
       "      <td>1.054</td>\n",
       "      <td>35.250000</td>\n",
       "      <td>28.400000</td>\n",
       "      <td>12.100</td>\n",
       "      <td>28.920000</td>\n",
       "      <td>355.850006</td>\n",
       "      <td>350.399994</td>\n",
       "      <td>508.899994</td>\n",
       "      <td>1.054</td>\n",
       "      <td>35.250000</td>\n",
       "      <td>...</td>\n",
       "      <td>351.200012</td>\n",
       "      <td>508.600006</td>\n",
       "      <td>85625.0</td>\n",
       "      <td>660267.0</td>\n",
       "      <td>63854.0</td>\n",
       "      <td>107426.0</td>\n",
       "      <td>44767.0</td>\n",
       "      <td>688269.0</td>\n",
       "      <td>9957.0</td>\n",
       "      <td>144653.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-04-21</td>\n",
       "      <td>1.054</td>\n",
       "      <td>34.000000</td>\n",
       "      <td>28.799999</td>\n",
       "      <td>11.390</td>\n",
       "      <td>28.000000</td>\n",
       "      <td>350.000000</td>\n",
       "      <td>339.600006</td>\n",
       "      <td>489.000000</td>\n",
       "      <td>1.054</td>\n",
       "      <td>34.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>350.799988</td>\n",
       "      <td>505.500000</td>\n",
       "      <td>90110.0</td>\n",
       "      <td>795448.0</td>\n",
       "      <td>75081.0</td>\n",
       "      <td>475581.0</td>\n",
       "      <td>13722.0</td>\n",
       "      <td>661016.0</td>\n",
       "      <td>8353.0</td>\n",
       "      <td>156267.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>79 rows × 48 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Attributes Adj Close                                                       \\\n",
       "Symbols       AEF.MI    MONC.MI      BC.MI SFER.MI     TOD.MI       MC.PA   \n",
       "Date                                                                        \n",
       "2019-12-30     1.994  40.070000  31.559999  18.750  41.220001  409.308960   \n",
       "2019-12-31       NaN        NaN        NaN     NaN        NaN  408.914062   \n",
       "2020-01-02     2.030  40.590000  32.340000  18.955  42.000000  413.800873   \n",
       "2020-01-03     2.000  40.090000  32.119999  18.605  40.639999  413.751526   \n",
       "2020-01-06     1.942  40.070000  31.799999  18.555  39.599998  409.851929   \n",
       "...              ...        ...        ...     ...        ...         ...   \n",
       "2020-04-15     1.058  33.209999  25.940001  12.060  28.100000  337.635468   \n",
       "2020-04-16     1.034  32.849998  26.540001  11.890  27.760000  338.425232   \n",
       "2020-04-17     1.054  34.520000  27.340000  12.150  28.340000  353.431274   \n",
       "2020-04-20     1.054  35.250000  28.400000  12.100  28.920000  355.850006   \n",
       "2020-04-21     1.054  34.000000  28.799999  11.390  28.000000  350.000000   \n",
       "\n",
       "Attributes                          Close             ...        Open  \\\n",
       "Symbols         CDI.PA      KER.PA AEF.MI    MONC.MI  ...      CDI.PA   \n",
       "Date                                                  ...               \n",
       "2019-12-30  453.052399  582.844177  1.994  40.070000  ...  466.799988   \n",
       "2019-12-31  450.880890  581.750671    NaN        NaN  ...  459.000000   \n",
       "2020-01-02  455.816101  594.475220  2.030  40.590000  ...  461.600006   \n",
       "2020-01-03  456.803131  597.358154  2.000  40.090000  ...  461.000000   \n",
       "2020-01-06  455.223907  587.317688  1.942  40.070000  ...  461.200012   \n",
       "...                ...         ...    ...        ...  ...         ...   \n",
       "2020-04-15  322.170593  475.000000  1.058  33.209999  ...  344.799988   \n",
       "2020-04-16  322.960236  477.250000  1.034  32.849998  ...  324.200012   \n",
       "2020-04-17  343.688110  503.399994  1.054  34.520000  ...  345.799988   \n",
       "2020-04-20  350.399994  508.899994  1.054  35.250000  ...  351.200012   \n",
       "2020-04-21  339.600006  489.000000  1.054  34.000000  ...  350.799988   \n",
       "\n",
       "Attributes                Volume                                           \\\n",
       "Symbols         KER.PA    AEF.MI    MONC.MI     BC.MI   SFER.MI    TOD.MI   \n",
       "Date                                                                        \n",
       "2019-12-30  591.299988  232038.0   736786.0   38656.0  216874.0   44792.0   \n",
       "2019-12-31  585.700012       NaN        NaN       NaN       NaN       NaN   \n",
       "2020-01-02  592.700012  161368.0   472094.0   48975.0  252759.0   54621.0   \n",
       "2020-01-03  595.000000  131594.0   616330.0   52807.0  345428.0  100580.0   \n",
       "2020-01-06  595.700012  529221.0   918334.0   48714.0  319106.0  186368.0   \n",
       "...                ...       ...        ...       ...       ...       ...   \n",
       "2020-04-15  489.000000  262898.0  1565453.0  117443.0  536555.0   24012.0   \n",
       "2020-04-16  475.250000  124958.0   854571.0   64538.0  285689.0   20257.0   \n",
       "2020-04-17  493.950012   85964.0   943023.0   64848.0  351112.0   18670.0   \n",
       "2020-04-20  508.600006   85625.0   660267.0   63854.0  107426.0   44767.0   \n",
       "2020-04-21  505.500000   90110.0   795448.0   75081.0  475581.0   13722.0   \n",
       "\n",
       "Attributes                                \n",
       "Symbols         MC.PA   CDI.PA    KER.PA  \n",
       "Date                                      \n",
       "2019-12-30   226651.0  11640.0  144847.0  \n",
       "2019-12-31   102945.0   4432.0   45380.0  \n",
       "2020-01-02   347226.0  14531.0  178651.0  \n",
       "2020-01-03   291716.0   7986.0  159019.0  \n",
       "2020-01-06   363953.0  18007.0  176511.0  \n",
       "...               ...      ...       ...  \n",
       "2020-04-15   743853.0   7661.0  165887.0  \n",
       "2020-04-16   698898.0  11915.0  188754.0  \n",
       "2020-04-17  1230602.0  23739.0  351155.0  \n",
       "2020-04-20   688269.0   9957.0  144653.0  \n",
       "2020-04-21   661016.0   8353.0  156267.0  \n",
       "\n",
       "[79 rows x 48 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "data.to_csv('milan_stocks.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "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.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}