DSE_Historical_Data_Scrapping.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "def extractdse(fdate, tday, instrument):\n",
    "\n",
    "    # Importing packages\n",
    "    import pandas as pd, datetime, lxml\n",
    "    from selenium import webdriver\n",
    "    from selenium.webdriver.support.select import Select\n",
    "    from bs4 import BeautifulSoup\n",
    "    from IPython.display import display_html\n",
    "\n",
    "    # load the driver, download chrome driver and put the .exe file in C:/Windows\n",
    "    driver = webdriver.Chrome()\n",
    "\n",
    "    # load DSE data archive site\n",
    "    driver.get(\"https://www.dsebd.org/day_end_archive.php\")\n",
    "\n",
    "    # deal with the pop up warning\n",
    "    try:\n",
    "        alert = driver.switch_to.alert\n",
    "        alert.accept()\n",
    "    except NoAlertPresentException:\n",
    "        print(\"No alert here\")\n",
    "\n",
    "    # from date\n",
    "    fd = fdate\n",
    "    fdate = datetime.datetime.strptime(fdate, \"%Y-%m-%d\")\n",
    "    yr = str(fdate.year)\n",
    "    mn = (\"0\" + str(fdate.month))[-2:]\n",
    "    dy = (\"0\" + str(fdate.day))[-2:]\n",
    "\n",
    "    # to date\n",
    "    td = tday\n",
    "    tday = datetime.datetime.strptime(tday, \"%Y-%m-%d\")\n",
    "    bdd = (\"0\" + str(tday.day))[-2:]\n",
    "    bdm = (\"0\" + str(tday.month))[-2:]\n",
    "    bdy = str(tday.year)\n",
    "\n",
    "    # beginning day\n",
    "    x = Select(driver.find_element_by_name(\"DayEndSumDate1_day\"))\n",
    "    x.select_by_value(dy)\n",
    "\n",
    "    # beginning month\n",
    "    y = Select(driver.find_element_by_name(\"DayEndSumDate1_month\"))\n",
    "    y.select_by_value(mn)\n",
    "\n",
    "    # beginning year\n",
    "    z = Select(driver.find_element_by_name(\"DayEndSumDate1_year\"))\n",
    "    z.select_by_value(yr)\n",
    "\n",
    "    # end day\n",
    "    xp = Select(driver.find_element_by_name(\"DayEndSumDate2_day\"))\n",
    "    xp.select_by_value(bdd)\n",
    "\n",
    "    # end month\n",
    "    yp = Select(driver.find_element_by_name(\"DayEndSumDate2_month\"))\n",
    "    yp.select_by_value(bdm)\n",
    "\n",
    "    # end year\n",
    "    zp = Select(driver.find_element_by_name(\"DayEndSumDate2_year\"))\n",
    "    zp.select_by_value(bdy)\n",
    "\n",
    "    # instrument\n",
    "    inst = Select(driver.find_element_by_name(\"Symbol\"))\n",
    "    inst.select_by_visible_text(instrument)\n",
    "\n",
    "    # generate the table\n",
    "    driver.find_element_by_name(\"ViewDayEndArchive\").click()\n",
    "\n",
    "    # extract the table\n",
    "    soup = BeautifulSoup(driver.page_source, \"html.parser\")\n",
    "    tables = soup.find_all(\"table\")\n",
    "    tt = tables[374]\n",
    "    k = pd.read_html(driver.page_source, header=0)[len(tables) - 5]\n",
    "    k = k.drop([\"#\"], axis=1)\n",
    "\n",
    "    # write the file to xlsx\n",
    "    fn = instrument + \"-\" + fd + \"-\" + \"to\" + \"-\" + td + \".xlsx\"\n",
    "    k.to_excel(fn, index=False)\n",
    "\n",
    "    return (k)"
   ]
  },
  {
   "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 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>DATE</th>\n",
       "      <th>TRADING CODE</th>\n",
       "      <th>LTP*</th>\n",
       "      <th>HIGH</th>\n",
       "      <th>LOW</th>\n",
       "      <th>OPENP*</th>\n",
       "      <th>CLOSEP*</th>\n",
       "      <th>YCP</th>\n",
       "      <th>TRADE</th>\n",
       "      <th>VALUE (mn)</th>\n",
       "      <th>VOLUME</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018-10-25</td>\n",
       "      <td>ACI</td>\n",
       "      <td>348.9</td>\n",
       "      <td>355.0</td>\n",
       "      <td>346.0</td>\n",
       "      <td>354.7</td>\n",
       "      <td>347.7</td>\n",
       "      <td>348.5</td>\n",
       "      <td>271</td>\n",
       "      <td>6.377</td>\n",
       "      <td>18286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018-10-24</td>\n",
       "      <td>ACI</td>\n",
       "      <td>349.7</td>\n",
       "      <td>349.9</td>\n",
       "      <td>345.2</td>\n",
       "      <td>346.3</td>\n",
       "      <td>348.5</td>\n",
       "      <td>343.4</td>\n",
       "      <td>196</td>\n",
       "      <td>3.639</td>\n",
       "      <td>10451</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018-10-23</td>\n",
       "      <td>ACI</td>\n",
       "      <td>342.1</td>\n",
       "      <td>346.6</td>\n",
       "      <td>342.1</td>\n",
       "      <td>344.2</td>\n",
       "      <td>343.4</td>\n",
       "      <td>343.8</td>\n",
       "      <td>401</td>\n",
       "      <td>10.575</td>\n",
       "      <td>30716</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2018-10-22</td>\n",
       "      <td>ACI</td>\n",
       "      <td>343.1</td>\n",
       "      <td>350.8</td>\n",
       "      <td>342.6</td>\n",
       "      <td>346.1</td>\n",
       "      <td>343.8</td>\n",
       "      <td>346.1</td>\n",
       "      <td>253</td>\n",
       "      <td>3.876</td>\n",
       "      <td>11226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2018-10-21</td>\n",
       "      <td>ACI</td>\n",
       "      <td>345.9</td>\n",
       "      <td>351.5</td>\n",
       "      <td>345.8</td>\n",
       "      <td>349.9</td>\n",
       "      <td>346.1</td>\n",
       "      <td>348.2</td>\n",
       "      <td>251</td>\n",
       "      <td>4.269</td>\n",
       "      <td>12280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2018-10-18</td>\n",
       "      <td>ACI</td>\n",
       "      <td>347.5</td>\n",
       "      <td>357.0</td>\n",
       "      <td>345.6</td>\n",
       "      <td>350.0</td>\n",
       "      <td>348.2</td>\n",
       "      <td>345.4</td>\n",
       "      <td>422</td>\n",
       "      <td>9.076</td>\n",
       "      <td>25886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2018-10-17</td>\n",
       "      <td>ACI</td>\n",
       "      <td>348.0</td>\n",
       "      <td>352.9</td>\n",
       "      <td>344.7</td>\n",
       "      <td>351.7</td>\n",
       "      <td>345.4</td>\n",
       "      <td>351.2</td>\n",
       "      <td>536</td>\n",
       "      <td>13.067</td>\n",
       "      <td>37738</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2018-10-16</td>\n",
       "      <td>ACI</td>\n",
       "      <td>350.2</td>\n",
       "      <td>355.0</td>\n",
       "      <td>349.0</td>\n",
       "      <td>355.0</td>\n",
       "      <td>351.2</td>\n",
       "      <td>353.8</td>\n",
       "      <td>400</td>\n",
       "      <td>9.554</td>\n",
       "      <td>27221</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2018-10-15</td>\n",
       "      <td>ACI</td>\n",
       "      <td>353.0</td>\n",
       "      <td>362.9</td>\n",
       "      <td>353.0</td>\n",
       "      <td>359.0</td>\n",
       "      <td>353.8</td>\n",
       "      <td>357.8</td>\n",
       "      <td>376</td>\n",
       "      <td>7.641</td>\n",
       "      <td>21550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2018-10-14</td>\n",
       "      <td>ACI</td>\n",
       "      <td>357.1</td>\n",
       "      <td>365.1</td>\n",
       "      <td>357.0</td>\n",
       "      <td>364.0</td>\n",
       "      <td>357.8</td>\n",
       "      <td>364.0</td>\n",
       "      <td>471</td>\n",
       "      <td>13.256</td>\n",
       "      <td>36828</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2018-10-11</td>\n",
       "      <td>ACI</td>\n",
       "      <td>360.4</td>\n",
       "      <td>372.0</td>\n",
       "      <td>360.4</td>\n",
       "      <td>371.2</td>\n",
       "      <td>364.0</td>\n",
       "      <td>371.2</td>\n",
       "      <td>731</td>\n",
       "      <td>25.698</td>\n",
       "      <td>69955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2018-10-10</td>\n",
       "      <td>ACI</td>\n",
       "      <td>371.6</td>\n",
       "      <td>398.0</td>\n",
       "      <td>367.0</td>\n",
       "      <td>398.0</td>\n",
       "      <td>371.2</td>\n",
       "      <td>374.8</td>\n",
       "      <td>1139</td>\n",
       "      <td>35.872</td>\n",
       "      <td>95184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2018-10-09</td>\n",
       "      <td>ACI</td>\n",
       "      <td>374.8</td>\n",
       "      <td>374.8</td>\n",
       "      <td>347.9</td>\n",
       "      <td>347.9</td>\n",
       "      <td>374.8</td>\n",
       "      <td>344.7</td>\n",
       "      <td>967</td>\n",
       "      <td>45.272</td>\n",
       "      <td>121441</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2018-10-08</td>\n",
       "      <td>ACI</td>\n",
       "      <td>348.8</td>\n",
       "      <td>348.9</td>\n",
       "      <td>342.0</td>\n",
       "      <td>344.0</td>\n",
       "      <td>344.7</td>\n",
       "      <td>341.9</td>\n",
       "      <td>457</td>\n",
       "      <td>13.219</td>\n",
       "      <td>38499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2018-10-07</td>\n",
       "      <td>ACI</td>\n",
       "      <td>343.0</td>\n",
       "      <td>347.1</td>\n",
       "      <td>341.0</td>\n",
       "      <td>347.1</td>\n",
       "      <td>341.9</td>\n",
       "      <td>346.2</td>\n",
       "      <td>556</td>\n",
       "      <td>13.012</td>\n",
       "      <td>37822</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2018-10-04</td>\n",
       "      <td>ACI</td>\n",
       "      <td>347.8</td>\n",
       "      <td>348.0</td>\n",
       "      <td>345.0</td>\n",
       "      <td>348.0</td>\n",
       "      <td>346.2</td>\n",
       "      <td>347.7</td>\n",
       "      <td>349</td>\n",
       "      <td>6.778</td>\n",
       "      <td>19575</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2018-10-03</td>\n",
       "      <td>ACI</td>\n",
       "      <td>348.3</td>\n",
       "      <td>349.8</td>\n",
       "      <td>346.4</td>\n",
       "      <td>348.6</td>\n",
       "      <td>347.7</td>\n",
       "      <td>347.6</td>\n",
       "      <td>152</td>\n",
       "      <td>2.136</td>\n",
       "      <td>6140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2018-10-02</td>\n",
       "      <td>ACI</td>\n",
       "      <td>347.5</td>\n",
       "      <td>349.0</td>\n",
       "      <td>346.2</td>\n",
       "      <td>349.0</td>\n",
       "      <td>347.6</td>\n",
       "      <td>345.3</td>\n",
       "      <td>199</td>\n",
       "      <td>3.682</td>\n",
       "      <td>10600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2018-10-01</td>\n",
       "      <td>ACI</td>\n",
       "      <td>344.5</td>\n",
       "      <td>352.8</td>\n",
       "      <td>341.6</td>\n",
       "      <td>342.0</td>\n",
       "      <td>345.3</td>\n",
       "      <td>340.0</td>\n",
       "      <td>270</td>\n",
       "      <td>6.432</td>\n",
       "      <td>18549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2018-09-30</td>\n",
       "      <td>ACI</td>\n",
       "      <td>343.0</td>\n",
       "      <td>349.0</td>\n",
       "      <td>339.4</td>\n",
       "      <td>348.0</td>\n",
       "      <td>340.0</td>\n",
       "      <td>347.2</td>\n",
       "      <td>418</td>\n",
       "      <td>7.880</td>\n",
       "      <td>23064</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2018-09-27</td>\n",
       "      <td>ACI</td>\n",
       "      <td>346.1</td>\n",
       "      <td>349.9</td>\n",
       "      <td>346.1</td>\n",
       "      <td>349.9</td>\n",
       "      <td>347.2</td>\n",
       "      <td>349.8</td>\n",
       "      <td>106</td>\n",
       "      <td>2.196</td>\n",
       "      <td>6313</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2018-09-26</td>\n",
       "      <td>ACI</td>\n",
       "      <td>347.3</td>\n",
       "      <td>353.0</td>\n",
       "      <td>345.2</td>\n",
       "      <td>349.0</td>\n",
       "      <td>349.8</td>\n",
       "      <td>345.2</td>\n",
       "      <td>199</td>\n",
       "      <td>5.013</td>\n",
       "      <td>14380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2018-09-25</td>\n",
       "      <td>ACI</td>\n",
       "      <td>345.3</td>\n",
       "      <td>347.0</td>\n",
       "      <td>344.0</td>\n",
       "      <td>347.0</td>\n",
       "      <td>345.2</td>\n",
       "      <td>346.0</td>\n",
       "      <td>292</td>\n",
       "      <td>6.426</td>\n",
       "      <td>18599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2018-09-24</td>\n",
       "      <td>ACI</td>\n",
       "      <td>346.7</td>\n",
       "      <td>353.2</td>\n",
       "      <td>345.1</td>\n",
       "      <td>353.1</td>\n",
       "      <td>346.0</td>\n",
       "      <td>352.8</td>\n",
       "      <td>440</td>\n",
       "      <td>8.854</td>\n",
       "      <td>25323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2018-09-23</td>\n",
       "      <td>ACI</td>\n",
       "      <td>352.0</td>\n",
       "      <td>362.0</td>\n",
       "      <td>351.2</td>\n",
       "      <td>357.0</td>\n",
       "      <td>352.8</td>\n",
       "      <td>360.6</td>\n",
       "      <td>351</td>\n",
       "      <td>9.029</td>\n",
       "      <td>25293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2018-09-20</td>\n",
       "      <td>ACI</td>\n",
       "      <td>362.5</td>\n",
       "      <td>362.5</td>\n",
       "      <td>357.2</td>\n",
       "      <td>357.2</td>\n",
       "      <td>360.6</td>\n",
       "      <td>357.2</td>\n",
       "      <td>222</td>\n",
       "      <td>7.628</td>\n",
       "      <td>21177</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2018-09-19</td>\n",
       "      <td>ACI</td>\n",
       "      <td>357.4</td>\n",
       "      <td>362.0</td>\n",
       "      <td>356.6</td>\n",
       "      <td>360.3</td>\n",
       "      <td>357.2</td>\n",
       "      <td>361.0</td>\n",
       "      <td>446</td>\n",
       "      <td>11.806</td>\n",
       "      <td>32888</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2018-09-18</td>\n",
       "      <td>ACI</td>\n",
       "      <td>360.4</td>\n",
       "      <td>363.9</td>\n",
       "      <td>360.1</td>\n",
       "      <td>361.1</td>\n",
       "      <td>361.0</td>\n",
       "      <td>361.3</td>\n",
       "      <td>307</td>\n",
       "      <td>8.376</td>\n",
       "      <td>23154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2018-09-17</td>\n",
       "      <td>ACI</td>\n",
       "      <td>362.0</td>\n",
       "      <td>366.1</td>\n",
       "      <td>360.6</td>\n",
       "      <td>366.0</td>\n",
       "      <td>361.3</td>\n",
       "      <td>366.1</td>\n",
       "      <td>637</td>\n",
       "      <td>19.125</td>\n",
       "      <td>52709</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2018-09-16</td>\n",
       "      <td>ACI</td>\n",
       "      <td>366.2</td>\n",
       "      <td>372.6</td>\n",
       "      <td>365.0</td>\n",
       "      <td>372.6</td>\n",
       "      <td>366.1</td>\n",
       "      <td>369.6</td>\n",
       "      <td>447</td>\n",
       "      <td>11.003</td>\n",
       "      <td>29972</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>2018-07-18</td>\n",
       "      <td>ACI</td>\n",
       "      <td>357.0</td>\n",
       "      <td>358.0</td>\n",
       "      <td>341.3</td>\n",
       "      <td>342.0</td>\n",
       "      <td>355.1</td>\n",
       "      <td>341.2</td>\n",
       "      <td>1504</td>\n",
       "      <td>47.070</td>\n",
       "      <td>134612</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>2018-07-17</td>\n",
       "      <td>ACI</td>\n",
       "      <td>341.0</td>\n",
       "      <td>344.0</td>\n",
       "      <td>339.7</td>\n",
       "      <td>340.0</td>\n",
       "      <td>341.2</td>\n",
       "      <td>339.0</td>\n",
       "      <td>379</td>\n",
       "      <td>20.930</td>\n",
       "      <td>61276</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>2018-07-16</td>\n",
       "      <td>ACI</td>\n",
       "      <td>338.5</td>\n",
       "      <td>346.9</td>\n",
       "      <td>338.0</td>\n",
       "      <td>343.9</td>\n",
       "      <td>339.0</td>\n",
       "      <td>343.0</td>\n",
       "      <td>691</td>\n",
       "      <td>26.798</td>\n",
       "      <td>78701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>2018-07-15</td>\n",
       "      <td>ACI</td>\n",
       "      <td>342.5</td>\n",
       "      <td>345.0</td>\n",
       "      <td>338.0</td>\n",
       "      <td>340.0</td>\n",
       "      <td>343.0</td>\n",
       "      <td>340.3</td>\n",
       "      <td>757</td>\n",
       "      <td>25.854</td>\n",
       "      <td>75721</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>2018-07-12</td>\n",
       "      <td>ACI</td>\n",
       "      <td>337.1</td>\n",
       "      <td>344.6</td>\n",
       "      <td>337.1</td>\n",
       "      <td>339.6</td>\n",
       "      <td>340.3</td>\n",
       "      <td>339.6</td>\n",
       "      <td>460</td>\n",
       "      <td>13.812</td>\n",
       "      <td>40447</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>2018-07-11</td>\n",
       "      <td>ACI</td>\n",
       "      <td>339.1</td>\n",
       "      <td>350.0</td>\n",
       "      <td>338.0</td>\n",
       "      <td>340.0</td>\n",
       "      <td>339.6</td>\n",
       "      <td>337.0</td>\n",
       "      <td>451</td>\n",
       "      <td>11.841</td>\n",
       "      <td>34662</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>2018-07-10</td>\n",
       "      <td>ACI</td>\n",
       "      <td>337.0</td>\n",
       "      <td>340.5</td>\n",
       "      <td>336.5</td>\n",
       "      <td>339.2</td>\n",
       "      <td>337.0</td>\n",
       "      <td>339.1</td>\n",
       "      <td>657</td>\n",
       "      <td>20.206</td>\n",
       "      <td>59755</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>2018-07-09</td>\n",
       "      <td>ACI</td>\n",
       "      <td>337.2</td>\n",
       "      <td>343.2</td>\n",
       "      <td>336.0</td>\n",
       "      <td>343.2</td>\n",
       "      <td>339.1</td>\n",
       "      <td>342.4</td>\n",
       "      <td>584</td>\n",
       "      <td>16.407</td>\n",
       "      <td>48311</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>2018-07-08</td>\n",
       "      <td>ACI</td>\n",
       "      <td>343.5</td>\n",
       "      <td>344.8</td>\n",
       "      <td>338.0</td>\n",
       "      <td>338.0</td>\n",
       "      <td>342.4</td>\n",
       "      <td>336.0</td>\n",
       "      <td>344</td>\n",
       "      <td>9.761</td>\n",
       "      <td>28515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>2018-07-05</td>\n",
       "      <td>ACI</td>\n",
       "      <td>338.0</td>\n",
       "      <td>340.9</td>\n",
       "      <td>335.0</td>\n",
       "      <td>336.1</td>\n",
       "      <td>336.0</td>\n",
       "      <td>336.0</td>\n",
       "      <td>697</td>\n",
       "      <td>27.469</td>\n",
       "      <td>81549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>2018-07-04</td>\n",
       "      <td>ACI</td>\n",
       "      <td>336.4</td>\n",
       "      <td>342.5</td>\n",
       "      <td>334.9</td>\n",
       "      <td>338.2</td>\n",
       "      <td>336.0</td>\n",
       "      <td>337.5</td>\n",
       "      <td>588</td>\n",
       "      <td>22.232</td>\n",
       "      <td>66060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>2018-07-03</td>\n",
       "      <td>ACI</td>\n",
       "      <td>342.0</td>\n",
       "      <td>344.9</td>\n",
       "      <td>336.4</td>\n",
       "      <td>341.0</td>\n",
       "      <td>337.5</td>\n",
       "      <td>341.0</td>\n",
       "      <td>422</td>\n",
       "      <td>9.162</td>\n",
       "      <td>27002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>2018-07-02</td>\n",
       "      <td>ACI</td>\n",
       "      <td>340.2</td>\n",
       "      <td>350.7</td>\n",
       "      <td>340.0</td>\n",
       "      <td>350.6</td>\n",
       "      <td>341.0</td>\n",
       "      <td>347.8</td>\n",
       "      <td>676</td>\n",
       "      <td>17.312</td>\n",
       "      <td>50293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>2018-06-28</td>\n",
       "      <td>ACI</td>\n",
       "      <td>348.7</td>\n",
       "      <td>349.9</td>\n",
       "      <td>345.1</td>\n",
       "      <td>345.1</td>\n",
       "      <td>347.8</td>\n",
       "      <td>348.4</td>\n",
       "      <td>510</td>\n",
       "      <td>16.877</td>\n",
       "      <td>48503</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>2018-06-27</td>\n",
       "      <td>ACI</td>\n",
       "      <td>348.0</td>\n",
       "      <td>351.9</td>\n",
       "      <td>347.9</td>\n",
       "      <td>349.8</td>\n",
       "      <td>348.4</td>\n",
       "      <td>347.1</td>\n",
       "      <td>411</td>\n",
       "      <td>14.467</td>\n",
       "      <td>41392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>2018-06-26</td>\n",
       "      <td>ACI</td>\n",
       "      <td>346.1</td>\n",
       "      <td>351.1</td>\n",
       "      <td>346.0</td>\n",
       "      <td>348.0</td>\n",
       "      <td>347.1</td>\n",
       "      <td>346.7</td>\n",
       "      <td>369</td>\n",
       "      <td>10.211</td>\n",
       "      <td>29333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>2018-06-25</td>\n",
       "      <td>ACI</td>\n",
       "      <td>345.2</td>\n",
       "      <td>354.8</td>\n",
       "      <td>345.1</td>\n",
       "      <td>348.5</td>\n",
       "      <td>346.7</td>\n",
       "      <td>348.3</td>\n",
       "      <td>687</td>\n",
       "      <td>16.072</td>\n",
       "      <td>45928</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>2018-06-24</td>\n",
       "      <td>ACI</td>\n",
       "      <td>348.2</td>\n",
       "      <td>349.7</td>\n",
       "      <td>345.0</td>\n",
       "      <td>345.0</td>\n",
       "      <td>348.3</td>\n",
       "      <td>344.6</td>\n",
       "      <td>614</td>\n",
       "      <td>17.190</td>\n",
       "      <td>49548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>2018-06-21</td>\n",
       "      <td>ACI</td>\n",
       "      <td>345.0</td>\n",
       "      <td>347.7</td>\n",
       "      <td>342.8</td>\n",
       "      <td>345.5</td>\n",
       "      <td>344.6</td>\n",
       "      <td>344.2</td>\n",
       "      <td>812</td>\n",
       "      <td>21.732</td>\n",
       "      <td>63208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>2018-06-20</td>\n",
       "      <td>ACI</td>\n",
       "      <td>342.8</td>\n",
       "      <td>347.4</td>\n",
       "      <td>342.5</td>\n",
       "      <td>343.6</td>\n",
       "      <td>344.2</td>\n",
       "      <td>343.8</td>\n",
       "      <td>598</td>\n",
       "      <td>13.139</td>\n",
       "      <td>38093</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>2018-06-19</td>\n",
       "      <td>ACI</td>\n",
       "      <td>344.1</td>\n",
       "      <td>352.9</td>\n",
       "      <td>343.5</td>\n",
       "      <td>352.9</td>\n",
       "      <td>343.8</td>\n",
       "      <td>348.7</td>\n",
       "      <td>591</td>\n",
       "      <td>11.241</td>\n",
       "      <td>32565</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>2018-06-18</td>\n",
       "      <td>ACI</td>\n",
       "      <td>345.5</td>\n",
       "      <td>352.0</td>\n",
       "      <td>341.2</td>\n",
       "      <td>344.0</td>\n",
       "      <td>348.7</td>\n",
       "      <td>343.2</td>\n",
       "      <td>488</td>\n",
       "      <td>11.593</td>\n",
       "      <td>33240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>2018-06-12</td>\n",
       "      <td>ACI</td>\n",
       "      <td>346.0</td>\n",
       "      <td>351.0</td>\n",
       "      <td>342.2</td>\n",
       "      <td>351.0</td>\n",
       "      <td>343.2</td>\n",
       "      <td>349.2</td>\n",
       "      <td>672</td>\n",
       "      <td>13.178</td>\n",
       "      <td>38197</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>2018-06-11</td>\n",
       "      <td>ACI</td>\n",
       "      <td>350.0</td>\n",
       "      <td>356.0</td>\n",
       "      <td>348.4</td>\n",
       "      <td>351.6</td>\n",
       "      <td>349.2</td>\n",
       "      <td>349.2</td>\n",
       "      <td>665</td>\n",
       "      <td>15.664</td>\n",
       "      <td>44546</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>2018-06-10</td>\n",
       "      <td>ACI</td>\n",
       "      <td>348.3</td>\n",
       "      <td>350.2</td>\n",
       "      <td>342.2</td>\n",
       "      <td>344.0</td>\n",
       "      <td>349.2</td>\n",
       "      <td>341.9</td>\n",
       "      <td>658</td>\n",
       "      <td>12.473</td>\n",
       "      <td>35918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>2018-06-07</td>\n",
       "      <td>ACI</td>\n",
       "      <td>341.4</td>\n",
       "      <td>343.9</td>\n",
       "      <td>338.5</td>\n",
       "      <td>342.2</td>\n",
       "      <td>341.9</td>\n",
       "      <td>341.0</td>\n",
       "      <td>800</td>\n",
       "      <td>13.540</td>\n",
       "      <td>39686</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>2018-06-06</td>\n",
       "      <td>ACI</td>\n",
       "      <td>340.0</td>\n",
       "      <td>345.0</td>\n",
       "      <td>338.0</td>\n",
       "      <td>340.9</td>\n",
       "      <td>341.0</td>\n",
       "      <td>337.1</td>\n",
       "      <td>978</td>\n",
       "      <td>23.759</td>\n",
       "      <td>69371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>2018-06-05</td>\n",
       "      <td>ACI</td>\n",
       "      <td>337.0</td>\n",
       "      <td>338.3</td>\n",
       "      <td>331.5</td>\n",
       "      <td>333.0</td>\n",
       "      <td>337.1</td>\n",
       "      <td>330.5</td>\n",
       "      <td>702</td>\n",
       "      <td>19.964</td>\n",
       "      <td>59571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>2018-06-04</td>\n",
       "      <td>ACI</td>\n",
       "      <td>331.0</td>\n",
       "      <td>334.0</td>\n",
       "      <td>330.0</td>\n",
       "      <td>333.9</td>\n",
       "      <td>330.5</td>\n",
       "      <td>331.5</td>\n",
       "      <td>554</td>\n",
       "      <td>8.814</td>\n",
       "      <td>26605</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>2018-06-03</td>\n",
       "      <td>ACI</td>\n",
       "      <td>333.0</td>\n",
       "      <td>339.9</td>\n",
       "      <td>329.9</td>\n",
       "      <td>339.9</td>\n",
       "      <td>331.5</td>\n",
       "      <td>337.2</td>\n",
       "      <td>808</td>\n",
       "      <td>18.153</td>\n",
       "      <td>54539</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>96 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          DATE TRADING CODE   LTP*   HIGH    LOW  OPENP*  CLOSEP*    YCP  \\\n",
       "0   2018-10-25          ACI  348.9  355.0  346.0   354.7    347.7  348.5   \n",
       "1   2018-10-24          ACI  349.7  349.9  345.2   346.3    348.5  343.4   \n",
       "2   2018-10-23          ACI  342.1  346.6  342.1   344.2    343.4  343.8   \n",
       "3   2018-10-22          ACI  343.1  350.8  342.6   346.1    343.8  346.1   \n",
       "4   2018-10-21          ACI  345.9  351.5  345.8   349.9    346.1  348.2   \n",
       "5   2018-10-18          ACI  347.5  357.0  345.6   350.0    348.2  345.4   \n",
       "6   2018-10-17          ACI  348.0  352.9  344.7   351.7    345.4  351.2   \n",
       "7   2018-10-16          ACI  350.2  355.0  349.0   355.0    351.2  353.8   \n",
       "8   2018-10-15          ACI  353.0  362.9  353.0   359.0    353.8  357.8   \n",
       "9   2018-10-14          ACI  357.1  365.1  357.0   364.0    357.8  364.0   \n",
       "10  2018-10-11          ACI  360.4  372.0  360.4   371.2    364.0  371.2   \n",
       "11  2018-10-10          ACI  371.6  398.0  367.0   398.0    371.2  374.8   \n",
       "12  2018-10-09          ACI  374.8  374.8  347.9   347.9    374.8  344.7   \n",
       "13  2018-10-08          ACI  348.8  348.9  342.0   344.0    344.7  341.9   \n",
       "14  2018-10-07          ACI  343.0  347.1  341.0   347.1    341.9  346.2   \n",
       "15  2018-10-04          ACI  347.8  348.0  345.0   348.0    346.2  347.7   \n",
       "16  2018-10-03          ACI  348.3  349.8  346.4   348.6    347.7  347.6   \n",
       "17  2018-10-02          ACI  347.5  349.0  346.2   349.0    347.6  345.3   \n",
       "18  2018-10-01          ACI  344.5  352.8  341.6   342.0    345.3  340.0   \n",
       "19  2018-09-30          ACI  343.0  349.0  339.4   348.0    340.0  347.2   \n",
       "20  2018-09-27          ACI  346.1  349.9  346.1   349.9    347.2  349.8   \n",
       "21  2018-09-26          ACI  347.3  353.0  345.2   349.0    349.8  345.2   \n",
       "22  2018-09-25          ACI  345.3  347.0  344.0   347.0    345.2  346.0   \n",
       "23  2018-09-24          ACI  346.7  353.2  345.1   353.1    346.0  352.8   \n",
       "24  2018-09-23          ACI  352.0  362.0  351.2   357.0    352.8  360.6   \n",
       "25  2018-09-20          ACI  362.5  362.5  357.2   357.2    360.6  357.2   \n",
       "26  2018-09-19          ACI  357.4  362.0  356.6   360.3    357.2  361.0   \n",
       "27  2018-09-18          ACI  360.4  363.9  360.1   361.1    361.0  361.3   \n",
       "28  2018-09-17          ACI  362.0  366.1  360.6   366.0    361.3  366.1   \n",
       "29  2018-09-16          ACI  366.2  372.6  365.0   372.6    366.1  369.6   \n",
       "..         ...          ...    ...    ...    ...     ...      ...    ...   \n",
       "66  2018-07-18          ACI  357.0  358.0  341.3   342.0    355.1  341.2   \n",
       "67  2018-07-17          ACI  341.0  344.0  339.7   340.0    341.2  339.0   \n",
       "68  2018-07-16          ACI  338.5  346.9  338.0   343.9    339.0  343.0   \n",
       "69  2018-07-15          ACI  342.5  345.0  338.0   340.0    343.0  340.3   \n",
       "70  2018-07-12          ACI  337.1  344.6  337.1   339.6    340.3  339.6   \n",
       "71  2018-07-11          ACI  339.1  350.0  338.0   340.0    339.6  337.0   \n",
       "72  2018-07-10          ACI  337.0  340.5  336.5   339.2    337.0  339.1   \n",
       "73  2018-07-09          ACI  337.2  343.2  336.0   343.2    339.1  342.4   \n",
       "74  2018-07-08          ACI  343.5  344.8  338.0   338.0    342.4  336.0   \n",
       "75  2018-07-05          ACI  338.0  340.9  335.0   336.1    336.0  336.0   \n",
       "76  2018-07-04          ACI  336.4  342.5  334.9   338.2    336.0  337.5   \n",
       "77  2018-07-03          ACI  342.0  344.9  336.4   341.0    337.5  341.0   \n",
       "78  2018-07-02          ACI  340.2  350.7  340.0   350.6    341.0  347.8   \n",
       "79  2018-06-28          ACI  348.7  349.9  345.1   345.1    347.8  348.4   \n",
       "80  2018-06-27          ACI  348.0  351.9  347.9   349.8    348.4  347.1   \n",
       "81  2018-06-26          ACI  346.1  351.1  346.0   348.0    347.1  346.7   \n",
       "82  2018-06-25          ACI  345.2  354.8  345.1   348.5    346.7  348.3   \n",
       "83  2018-06-24          ACI  348.2  349.7  345.0   345.0    348.3  344.6   \n",
       "84  2018-06-21          ACI  345.0  347.7  342.8   345.5    344.6  344.2   \n",
       "85  2018-06-20          ACI  342.8  347.4  342.5   343.6    344.2  343.8   \n",
       "86  2018-06-19          ACI  344.1  352.9  343.5   352.9    343.8  348.7   \n",
       "87  2018-06-18          ACI  345.5  352.0  341.2   344.0    348.7  343.2   \n",
       "88  2018-06-12          ACI  346.0  351.0  342.2   351.0    343.2  349.2   \n",
       "89  2018-06-11          ACI  350.0  356.0  348.4   351.6    349.2  349.2   \n",
       "90  2018-06-10          ACI  348.3  350.2  342.2   344.0    349.2  341.9   \n",
       "91  2018-06-07          ACI  341.4  343.9  338.5   342.2    341.9  341.0   \n",
       "92  2018-06-06          ACI  340.0  345.0  338.0   340.9    341.0  337.1   \n",
       "93  2018-06-05          ACI  337.0  338.3  331.5   333.0    337.1  330.5   \n",
       "94  2018-06-04          ACI  331.0  334.0  330.0   333.9    330.5  331.5   \n",
       "95  2018-06-03          ACI  333.0  339.9  329.9   339.9    331.5  337.2   \n",
       "\n",
       "    TRADE  VALUE (mn)  VOLUME  \n",
       "0     271       6.377   18286  \n",
       "1     196       3.639   10451  \n",
       "2     401      10.575   30716  \n",
       "3     253       3.876   11226  \n",
       "4     251       4.269   12280  \n",
       "5     422       9.076   25886  \n",
       "6     536      13.067   37738  \n",
       "7     400       9.554   27221  \n",
       "8     376       7.641   21550  \n",
       "9     471      13.256   36828  \n",
       "10    731      25.698   69955  \n",
       "11   1139      35.872   95184  \n",
       "12    967      45.272  121441  \n",
       "13    457      13.219   38499  \n",
       "14    556      13.012   37822  \n",
       "15    349       6.778   19575  \n",
       "16    152       2.136    6140  \n",
       "17    199       3.682   10600  \n",
       "18    270       6.432   18549  \n",
       "19    418       7.880   23064  \n",
       "20    106       2.196    6313  \n",
       "21    199       5.013   14380  \n",
       "22    292       6.426   18599  \n",
       "23    440       8.854   25323  \n",
       "24    351       9.029   25293  \n",
       "25    222       7.628   21177  \n",
       "26    446      11.806   32888  \n",
       "27    307       8.376   23154  \n",
       "28    637      19.125   52709  \n",
       "29    447      11.003   29972  \n",
       "..    ...         ...     ...  \n",
       "66   1504      47.070  134612  \n",
       "67    379      20.930   61276  \n",
       "68    691      26.798   78701  \n",
       "69    757      25.854   75721  \n",
       "70    460      13.812   40447  \n",
       "71    451      11.841   34662  \n",
       "72    657      20.206   59755  \n",
       "73    584      16.407   48311  \n",
       "74    344       9.761   28515  \n",
       "75    697      27.469   81549  \n",
       "76    588      22.232   66060  \n",
       "77    422       9.162   27002  \n",
       "78    676      17.312   50293  \n",
       "79    510      16.877   48503  \n",
       "80    411      14.467   41392  \n",
       "81    369      10.211   29333  \n",
       "82    687      16.072   45928  \n",
       "83    614      17.190   49548  \n",
       "84    812      21.732   63208  \n",
       "85    598      13.139   38093  \n",
       "86    591      11.241   32565  \n",
       "87    488      11.593   33240  \n",
       "88    672      13.178   38197  \n",
       "89    665      15.664   44546  \n",
       "90    658      12.473   35918  \n",
       "91    800      13.540   39686  \n",
       "92    978      23.759   69371  \n",
       "93    702      19.964   59571  \n",
       "94    554       8.814   26605  \n",
       "95    808      18.153   54539  \n",
       "\n",
       "[96 rows x 11 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "extractdse(\"2018-06-01\", \"2018-10-25\", \"ACI\")"
   ]
  }
 ],
 "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.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}