To get instrument list from zerodha.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "from kiteconnect import KiteTicker               \n",
    "from kiteconnect import KiteConnect  \n",
    "api_key='*************'                      \n",
    "api_secret='************'   \n",
    "kite=KiteConnect(api_key,api_secret)\n",
    "kite.login_url()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import logging\n",
    "logging.basicConfig(level=logging.DEBUG)\n",
    "kite = KiteConnect(api_key=api_key)\n",
    "token=\"39aA1wm2nfNa5aweX7OXX4GDsTjrQR2B\"\n",
    "data = kite.generate_session(token,api_secret)\n",
    "kite.set_access_token(data[\"access_token\"])\n",
    "print(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "DEBUG:urllib3.connectionpool:Starting new HTTPS connection (1): api.kite.trade:443\n",
      "DEBUG:urllib3.connectionpool:https://api.kite.trade:443 \"GET /instruments HTTP/1.1\" 200 5039621\n"
     ]
    },
    {
     "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>instrument_token</th>\n",
       "      <th>exchange_token</th>\n",
       "      <th>tradingsymbol</th>\n",
       "      <th>name</th>\n",
       "      <th>last_price</th>\n",
       "      <th>expiry</th>\n",
       "      <th>strike</th>\n",
       "      <th>tick_size</th>\n",
       "      <th>lot_size</th>\n",
       "      <th>instrument_type</th>\n",
       "      <th>segment</th>\n",
       "      <th>exchange</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>130820612</td>\n",
       "      <td>511018</td>\n",
       "      <td>ZMILGFIN</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>50</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>249018372</td>\n",
       "      <td>972728</td>\n",
       "      <td>YES28MAR12</td>\n",
       "      <td>YESBANK-9.90%-28-3-22-PVT</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>138919428</td>\n",
       "      <td>542654</td>\n",
       "      <td>VRFILMS</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>2000</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>242695172</td>\n",
       "      <td>948028</td>\n",
       "      <td>UPL08JUN12B</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>242694916</td>\n",
       "      <td>948027</td>\n",
       "      <td>UPL08JUN12A</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>135994372</td>\n",
       "      <td>531228</td>\n",
       "      <td>RANDER</td>\n",
       "      <td>RANDER CORPORATION</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>135916804</td>\n",
       "      <td>530925</td>\n",
       "      <td>RAMSONS</td>\n",
       "      <td>RAMSONS PROJECTS</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>135923460</td>\n",
       "      <td>530951</td>\n",
       "      <td>RAMINFO</td>\n",
       "      <td>RAMINFO</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>131641092</td>\n",
       "      <td>514223</td>\n",
       "      <td>RAMGOPOLY</td>\n",
       "      <td>RAMGOPAL POLYTEX</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>136286724</td>\n",
       "      <td>532370</td>\n",
       "      <td>RAMCOSYS</td>\n",
       "      <td>RAMCO SYSTEMS</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>136105732</td>\n",
       "      <td>531663</td>\n",
       "      <td>YUVRAAJHPL</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>134790404</td>\n",
       "      <td>526525</td>\n",
       "      <td>WWLEATH</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>138304516</td>\n",
       "      <td>540252</td>\n",
       "      <td>VSL</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1500</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>136589572</td>\n",
       "      <td>533553</td>\n",
       "      <td>TDPOWERSYS</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>132121092</td>\n",
       "      <td>516098</td>\n",
       "      <td>VENTURA</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>130942212</td>\n",
       "      <td>511493</td>\n",
       "      <td>VCKCAP</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>136286468</td>\n",
       "      <td>532369</td>\n",
       "      <td>RAMCOIND</td>\n",
       "      <td>RAMCO INDUSTRIES</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>128066564</td>\n",
       "      <td>500260</td>\n",
       "      <td>RAMCOCEM</td>\n",
       "      <td>THE RAMCO CEMENTS</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>133961988</td>\n",
       "      <td>523289</td>\n",
       "      <td>RAMAVISION</td>\n",
       "      <td>RAMA VISION</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>138063108</td>\n",
       "      <td>539309</td>\n",
       "      <td>RAMASTEEL</td>\n",
       "      <td>RAMA STEEL TUBES</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>131872516</td>\n",
       "      <td>515127</td>\n",
       "      <td>RAMASIGNS</td>\n",
       "      <td>RAMASIGNS INDUSTRIES</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>131620868</td>\n",
       "      <td>514144</td>\n",
       "      <td>UNIWORTH</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>131088388</td>\n",
       "      <td>512064</td>\n",
       "      <td>VISVEN</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>131127044</td>\n",
       "      <td>512215</td>\n",
       "      <td>STEPHANOTIS</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>128662276</td>\n",
       "      <td>502587</td>\n",
       "      <td>RAMAPULP</td>\n",
       "      <td>RAMA PULP &amp; PAPERS</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>128091396</td>\n",
       "      <td>500357</td>\n",
       "      <td>RAMAPPR-B</td>\n",
       "      <td>RAMA PAPER MILLS</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>134153476</td>\n",
       "      <td>524037</td>\n",
       "      <td>RAMAPHO</td>\n",
       "      <td>RAMA PHOSPHATES</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>128090884</td>\n",
       "      <td>500355</td>\n",
       "      <td>RALLIS</td>\n",
       "      <td>RALLIS INDIA</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>134680324</td>\n",
       "      <td>526095</td>\n",
       "      <td>RALEGRA</td>\n",
       "      <td>RAVILEELA GRANITES</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>136362244</td>\n",
       "      <td>532665</td>\n",
       "      <td>RAJVIR</td>\n",
       "      <td>RAJVIR INDUSTRIES</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>BSE</td>\n",
       "      <td>BSE</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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64389</th>\n",
       "      <td>2054913</td>\n",
       "      <td>8027</td>\n",
       "      <td>726GS2029-GS</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64390</th>\n",
       "      <td>1845249</td>\n",
       "      <td>7208</td>\n",
       "      <td>717GS2028-GS</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64391</th>\n",
       "      <td>1800961</td>\n",
       "      <td>7035</td>\n",
       "      <td>716GS2023-GS</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64392</th>\n",
       "      <td>1839105</td>\n",
       "      <td>7184</td>\n",
       "      <td>706GS2046-GS</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64393</th>\n",
       "      <td>2066945</td>\n",
       "      <td>8074</td>\n",
       "      <td>700GS2021-GS</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64394</th>\n",
       "      <td>1786625</td>\n",
       "      <td>6979</td>\n",
       "      <td>69GS2019-GS</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64395</th>\n",
       "      <td>1832449</td>\n",
       "      <td>7158</td>\n",
       "      <td>697GS2026-GS</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64396</th>\n",
       "      <td>1833217</td>\n",
       "      <td>7161</td>\n",
       "      <td>684GS2022-GS</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64397</th>\n",
       "      <td>1775361</td>\n",
       "      <td>6935</td>\n",
       "      <td>683GS2039-GS</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64398</th>\n",
       "      <td>945409</td>\n",
       "      <td>3693</td>\n",
       "      <td>GAYAHWS</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64399</th>\n",
       "      <td>1045249</td>\n",
       "      <td>4083</td>\n",
       "      <td>AMBANIORG-SM</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>2000</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64400</th>\n",
       "      <td>1823233</td>\n",
       "      <td>7122</td>\n",
       "      <td>788GS2030-GS</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64401</th>\n",
       "      <td>5181953</td>\n",
       "      <td>20242</td>\n",
       "      <td>OBEROIRLTY</td>\n",
       "      <td>OBEROI REALTY</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64402</th>\n",
       "      <td>2762497</td>\n",
       "      <td>10791</td>\n",
       "      <td>NUCLEUS</td>\n",
       "      <td>NUCLEUS SOFTWARE EXPORTS</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64403</th>\n",
       "      <td>2752257</td>\n",
       "      <td>10751</td>\n",
       "      <td>NTPC-ND</td>\n",
       "      <td>TFB 7.62% 2035 SR. 3B</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64404</th>\n",
       "      <td>2751745</td>\n",
       "      <td>10749</td>\n",
       "      <td>NTPC-NC</td>\n",
       "      <td>TFB 7.53% 2030 SR. 2B</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64405</th>\n",
       "      <td>2750977</td>\n",
       "      <td>10746</td>\n",
       "      <td>NTPC-NB</td>\n",
       "      <td>TFB 7.36% 2025 SR. 1B</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64406</th>\n",
       "      <td>2750465</td>\n",
       "      <td>10744</td>\n",
       "      <td>NTPC-NA</td>\n",
       "      <td>TFB 7.37% 2035 SR. 3A</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64407</th>\n",
       "      <td>2749697</td>\n",
       "      <td>10741</td>\n",
       "      <td>NTPC-N9</td>\n",
       "      <td>TFB 7.28% 2030 SR. 2A</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64408</th>\n",
       "      <td>2748673</td>\n",
       "      <td>10737</td>\n",
       "      <td>NTPC-N8</td>\n",
       "      <td>TFB 7.11% 2025 SR. 1A</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64409</th>\n",
       "      <td>1888513</td>\n",
       "      <td>7377</td>\n",
       "      <td>NTPC-N7</td>\n",
       "      <td>8.49% SEC NON-CUM RED NCD</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64410</th>\n",
       "      <td>3730433</td>\n",
       "      <td>14572</td>\n",
       "      <td>GLOBOFFS</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64411</th>\n",
       "      <td>5052929</td>\n",
       "      <td>19738</td>\n",
       "      <td>GLOBAL-SM</td>\n",
       "      <td>GLOBAL EDUCATION</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1000</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64412</th>\n",
       "      <td>1895937</td>\n",
       "      <td>7406</td>\n",
       "      <td>GLENMARK</td>\n",
       "      <td>GLENMARK PHARMACEUTICALS</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64413</th>\n",
       "      <td>295169</td>\n",
       "      <td>1153</td>\n",
       "      <td>GLAXO</td>\n",
       "      <td>GLAXOSMITHKLINE PHARMA LT</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64414</th>\n",
       "      <td>1225217</td>\n",
       "      <td>4786</td>\n",
       "      <td>AKG-SM</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>4000</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64415</th>\n",
       "      <td>6953217</td>\n",
       "      <td>27161</td>\n",
       "      <td>CINELINE</td>\n",
       "      <td>CINELINE INDIA</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64416</th>\n",
       "      <td>6447105</td>\n",
       "      <td>25184</td>\n",
       "      <td>CIMMCO</td>\n",
       "      <td>CIMMCO</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64417</th>\n",
       "      <td>1316353</td>\n",
       "      <td>5142</td>\n",
       "      <td>CIGNITITEC</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64418</th>\n",
       "      <td>175361</td>\n",
       "      <td>685</td>\n",
       "      <td>CHOLAFIN</td>\n",
       "      <td>CHOLAMANDALAM IN &amp; FIN CO</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>EQ</td>\n",
       "      <td>NSE</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>64419 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       instrument_token exchange_token tradingsymbol  \\\n",
       "0             130820612         511018      ZMILGFIN   \n",
       "1             249018372         972728    YES28MAR12   \n",
       "2             138919428         542654       VRFILMS   \n",
       "3             242695172         948028   UPL08JUN12B   \n",
       "4             242694916         948027   UPL08JUN12A   \n",
       "5             135994372         531228        RANDER   \n",
       "6             135916804         530925       RAMSONS   \n",
       "7             135923460         530951       RAMINFO   \n",
       "8             131641092         514223     RAMGOPOLY   \n",
       "9             136286724         532370      RAMCOSYS   \n",
       "10            136105732         531663    YUVRAAJHPL   \n",
       "11            134790404         526525       WWLEATH   \n",
       "12            138304516         540252           VSL   \n",
       "13            136589572         533553    TDPOWERSYS   \n",
       "14            132121092         516098       VENTURA   \n",
       "15            130942212         511493        VCKCAP   \n",
       "16            136286468         532369      RAMCOIND   \n",
       "17            128066564         500260      RAMCOCEM   \n",
       "18            133961988         523289    RAMAVISION   \n",
       "19            138063108         539309     RAMASTEEL   \n",
       "20            131872516         515127     RAMASIGNS   \n",
       "21            131620868         514144      UNIWORTH   \n",
       "22            131088388         512064        VISVEN   \n",
       "23            131127044         512215   STEPHANOTIS   \n",
       "24            128662276         502587      RAMAPULP   \n",
       "25            128091396         500357     RAMAPPR-B   \n",
       "26            134153476         524037       RAMAPHO   \n",
       "27            128090884         500355        RALLIS   \n",
       "28            134680324         526095       RALEGRA   \n",
       "29            136362244         532665        RAJVIR   \n",
       "...                 ...            ...           ...   \n",
       "64389           2054913           8027  726GS2029-GS   \n",
       "64390           1845249           7208  717GS2028-GS   \n",
       "64391           1800961           7035  716GS2023-GS   \n",
       "64392           1839105           7184  706GS2046-GS   \n",
       "64393           2066945           8074  700GS2021-GS   \n",
       "64394           1786625           6979   69GS2019-GS   \n",
       "64395           1832449           7158  697GS2026-GS   \n",
       "64396           1833217           7161  684GS2022-GS   \n",
       "64397           1775361           6935  683GS2039-GS   \n",
       "64398            945409           3693       GAYAHWS   \n",
       "64399           1045249           4083  AMBANIORG-SM   \n",
       "64400           1823233           7122  788GS2030-GS   \n",
       "64401           5181953          20242    OBEROIRLTY   \n",
       "64402           2762497          10791       NUCLEUS   \n",
       "64403           2752257          10751       NTPC-ND   \n",
       "64404           2751745          10749       NTPC-NC   \n",
       "64405           2750977          10746       NTPC-NB   \n",
       "64406           2750465          10744       NTPC-NA   \n",
       "64407           2749697          10741       NTPC-N9   \n",
       "64408           2748673          10737       NTPC-N8   \n",
       "64409           1888513           7377       NTPC-N7   \n",
       "64410           3730433          14572      GLOBOFFS   \n",
       "64411           5052929          19738     GLOBAL-SM   \n",
       "64412           1895937           7406      GLENMARK   \n",
       "64413            295169           1153         GLAXO   \n",
       "64414           1225217           4786        AKG-SM   \n",
       "64415           6953217          27161      CINELINE   \n",
       "64416           6447105          25184        CIMMCO   \n",
       "64417           1316353           5142    CIGNITITEC   \n",
       "64418            175361            685      CHOLAFIN   \n",
       "\n",
       "                            name  last_price expiry  strike  tick_size  \\\n",
       "0                                        0.0            0.0       0.05   \n",
       "1      YESBANK-9.90%-28-3-22-PVT         0.0            0.0       0.01   \n",
       "2                                        0.0            0.0       0.05   \n",
       "3                                        0.0            0.0       0.01   \n",
       "4                                        0.0            0.0       0.01   \n",
       "5             RANDER CORPORATION         0.0            0.0       0.01   \n",
       "6               RAMSONS PROJECTS         0.0            0.0       0.01   \n",
       "7                        RAMINFO         0.0            0.0       0.05   \n",
       "8               RAMGOPAL POLYTEX         0.0            0.0       0.01   \n",
       "9                  RAMCO SYSTEMS         0.0            0.0       0.05   \n",
       "10                                       0.0            0.0       0.01   \n",
       "11                                       0.0            0.0       0.01   \n",
       "12                                       0.0            0.0       0.05   \n",
       "13                                       0.0            0.0       0.05   \n",
       "14                                       0.0            0.0       0.01   \n",
       "15                                       0.0            0.0       0.01   \n",
       "16              RAMCO INDUSTRIES         0.0            0.0       0.05   \n",
       "17             THE RAMCO CEMENTS         0.0            0.0       0.05   \n",
       "18                   RAMA VISION         0.0            0.0       0.01   \n",
       "19              RAMA STEEL TUBES         0.0            0.0       0.05   \n",
       "20          RAMASIGNS INDUSTRIES         0.0            0.0       0.01   \n",
       "21                                       0.0            0.0       0.01   \n",
       "22                                       0.0            0.0       0.05   \n",
       "23                                       0.0            0.0       0.05   \n",
       "24            RAMA PULP & PAPERS         0.0            0.0       0.05   \n",
       "25              RAMA PAPER MILLS         0.0            0.0       0.05   \n",
       "26               RAMA PHOSPHATES         0.0            0.0       0.05   \n",
       "27                  RALLIS INDIA         0.0            0.0       0.05   \n",
       "28            RAVILEELA GRANITES         0.0            0.0       0.01   \n",
       "29             RAJVIR INDUSTRIES         0.0            0.0       0.01   \n",
       "...                          ...         ...    ...     ...        ...   \n",
       "64389                                    0.0            0.0       0.01   \n",
       "64390                                    0.0            0.0       0.01   \n",
       "64391                                    0.0            0.0       0.01   \n",
       "64392                                    0.0            0.0       0.01   \n",
       "64393                                    0.0            0.0       0.01   \n",
       "64394                                    0.0            0.0       0.01   \n",
       "64395                                    0.0            0.0       0.01   \n",
       "64396                                    0.0            0.0       0.01   \n",
       "64397                                    0.0            0.0       0.01   \n",
       "64398                                    0.0            0.0       0.05   \n",
       "64399                                    0.0            0.0       0.05   \n",
       "64400                                    0.0            0.0       0.01   \n",
       "64401              OBEROI REALTY         0.0            0.0       0.05   \n",
       "64402   NUCLEUS SOFTWARE EXPORTS         0.0            0.0       0.05   \n",
       "64403      TFB 7.62% 2035 SR. 3B         0.0            0.0       0.01   \n",
       "64404      TFB 7.53% 2030 SR. 2B         0.0            0.0       0.01   \n",
       "64405      TFB 7.36% 2025 SR. 1B         0.0            0.0       0.01   \n",
       "64406      TFB 7.37% 2035 SR. 3A         0.0            0.0       0.01   \n",
       "64407      TFB 7.28% 2030 SR. 2A         0.0            0.0       0.01   \n",
       "64408      TFB 7.11% 2025 SR. 1A         0.0            0.0       0.01   \n",
       "64409  8.49% SEC NON-CUM RED NCD         0.0            0.0       0.01   \n",
       "64410                                    0.0            0.0       0.05   \n",
       "64411           GLOBAL EDUCATION         0.0            0.0       0.05   \n",
       "64412   GLENMARK PHARMACEUTICALS         0.0            0.0       0.05   \n",
       "64413  GLAXOSMITHKLINE PHARMA LT         0.0            0.0       0.05   \n",
       "64414                                    0.0            0.0       0.05   \n",
       "64415             CINELINE INDIA         0.0            0.0       0.05   \n",
       "64416                     CIMMCO         0.0            0.0       0.05   \n",
       "64417                                    0.0            0.0       0.05   \n",
       "64418  CHOLAMANDALAM IN & FIN CO         0.0            0.0       0.05   \n",
       "\n",
       "       lot_size instrument_type segment exchange  \n",
       "0            50              EQ     BSE      BSE  \n",
       "1             1              EQ     BSE      BSE  \n",
       "2          2000              EQ     BSE      BSE  \n",
       "3             1              EQ     BSE      BSE  \n",
       "4             1              EQ     BSE      BSE  \n",
       "5             1              EQ     BSE      BSE  \n",
       "6             1              EQ     BSE      BSE  \n",
       "7             1              EQ     BSE      BSE  \n",
       "8             1              EQ     BSE      BSE  \n",
       "9             1              EQ     BSE      BSE  \n",
       "10            1              EQ     BSE      BSE  \n",
       "11            1              EQ     BSE      BSE  \n",
       "12         1500              EQ     BSE      BSE  \n",
       "13            1              EQ     BSE      BSE  \n",
       "14            1              EQ     BSE      BSE  \n",
       "15            1              EQ     BSE      BSE  \n",
       "16            1              EQ     BSE      BSE  \n",
       "17            1              EQ     BSE      BSE  \n",
       "18            1              EQ     BSE      BSE  \n",
       "19            1              EQ     BSE      BSE  \n",
       "20            1              EQ     BSE      BSE  \n",
       "21            1              EQ     BSE      BSE  \n",
       "22            1              EQ     BSE      BSE  \n",
       "23            1              EQ     BSE      BSE  \n",
       "24            1              EQ     BSE      BSE  \n",
       "25            1              EQ     BSE      BSE  \n",
       "26            1              EQ     BSE      BSE  \n",
       "27            1              EQ     BSE      BSE  \n",
       "28            1              EQ     BSE      BSE  \n",
       "29            1              EQ     BSE      BSE  \n",
       "...         ...             ...     ...      ...  \n",
       "64389         1              EQ     NSE      NSE  \n",
       "64390         1              EQ     NSE      NSE  \n",
       "64391         1              EQ     NSE      NSE  \n",
       "64392         1              EQ     NSE      NSE  \n",
       "64393         1              EQ     NSE      NSE  \n",
       "64394         1              EQ     NSE      NSE  \n",
       "64395         1              EQ     NSE      NSE  \n",
       "64396         1              EQ     NSE      NSE  \n",
       "64397         1              EQ     NSE      NSE  \n",
       "64398         1              EQ     NSE      NSE  \n",
       "64399      2000              EQ     NSE      NSE  \n",
       "64400         1              EQ     NSE      NSE  \n",
       "64401         1              EQ     NSE      NSE  \n",
       "64402         1              EQ     NSE      NSE  \n",
       "64403         1              EQ     NSE      NSE  \n",
       "64404         1              EQ     NSE      NSE  \n",
       "64405         1              EQ     NSE      NSE  \n",
       "64406         1              EQ     NSE      NSE  \n",
       "64407         1              EQ     NSE      NSE  \n",
       "64408         1              EQ     NSE      NSE  \n",
       "64409         1              EQ     NSE      NSE  \n",
       "64410         1              EQ     NSE      NSE  \n",
       "64411      1000              EQ     NSE      NSE  \n",
       "64412         1              EQ     NSE      NSE  \n",
       "64413         1              EQ     NSE      NSE  \n",
       "64414      4000              EQ     NSE      NSE  \n",
       "64415         1              EQ     NSE      NSE  \n",
       "64416         1              EQ     NSE      NSE  \n",
       "64417         1              EQ     NSE      NSE  \n",
       "64418         1              EQ     NSE      NSE  \n",
       "\n",
       "[64419 rows x 12 columns]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from pprint import pprint\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "k=kite.instruments(exchange=None)\n",
    "z=pd.DataFrame(k)\n",
    "z.to_csv(\"tokenlist.csv\")\n",
    "z "
   ]
  },
  {
   "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}