Getting Started with Zerodha.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Starting new project with zerodha"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Kite Connect is a set of REST-like HTTP APIs that expose many capabilities \n",
    "required to build a complete stock market investment and trading platform.\n",
    "It lets you execute orders in real time (equities, commodities, mutual funds), \n",
    "manage user portfolios, stream live market data over WebSockets, and more."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "* Install Kiteconnect\n",
    "* pip install kiteconnect "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Import All libraries required"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import time\n",
    "import secrets \n",
    "import threading\n",
    "import webbrowser\n",
    "import numpy as np\n",
    "import pandas as pd \n",
    "from math import modf\n",
    "from pprint import pprint \n",
    "from pytz import timezone\n",
    "from datetime import datetime \n",
    "from time import gmtime, strftime\n",
    "from kiteconnect import KiteTicker \n",
    "from kiteconnect import KiteConnect\n",
    "from IPython.display import clear_output"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Login to zerodha "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "enter your api key and api secret"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "api_key='******************* @@enter your api key here@@@**************' \n",
    "api_secret='**********************@@enter your api key here****************'\n",
    "print(KiteConnect(api_key,api_secret).login_url())\n",
    "webbrowser.open_new_tab(KiteConnect(api_key,api_secret).login_url())\n",
    "\n",
    "# make object \n",
    "\n",
    "kite = KiteConnect(api_key=api_key)\n",
    "data = kite.generate_session(((str(input(\"ENTER full link generated in URL :- \")).split(\"request_token=\")[1]).split(\"&action\"))[0],api_secret)\n",
    "kite.set_access_token(data[\"access_token\"])\n",
    "print(\"success\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Finding \" Instrument Token list of zerodha\" "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "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>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>58709</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>58710</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>58711</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>58712</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>58713</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>58714</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>58715</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>58716</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>58717</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>58718</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>58719</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>58720</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>58721</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>58722</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>58723</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>58724</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>58725</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>58726</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>58727</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>58728</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",
       "</div>"
      ],
      "text/plain": [
       "       instrument_token exchange_token tradingsymbol  \\\n",
       "58709           1045249           4083  AMBANIORG-SM   \n",
       "58710           1823233           7122  788GS2030-GS   \n",
       "58711           5181953          20242    OBEROIRLTY   \n",
       "58712           2762497          10791       NUCLEUS   \n",
       "58713           2752257          10751       NTPC-ND   \n",
       "58714           2751745          10749       NTPC-NC   \n",
       "58715           2750977          10746       NTPC-NB   \n",
       "58716           2750465          10744       NTPC-NA   \n",
       "58717           2749697          10741       NTPC-N9   \n",
       "58718           2748673          10737       NTPC-N8   \n",
       "58719           1888513           7377       NTPC-N7   \n",
       "58720           3730433          14572      GLOBOFFS   \n",
       "58721           5052929          19738     GLOBAL-SM   \n",
       "58722           1895937           7406      GLENMARK   \n",
       "58723            295169           1153         GLAXO   \n",
       "58724           1225217           4786        AKG-SM   \n",
       "58725           6953217          27161      CINELINE   \n",
       "58726           6447105          25184        CIMMCO   \n",
       "58727           1316353           5142    CIGNITITEC   \n",
       "58728            175361            685      CHOLAFIN   \n",
       "\n",
       "                            name  last_price expiry  strike  tick_size  \\\n",
       "58709                                    0.0            0.0       0.05   \n",
       "58710                                    0.0            0.0       0.01   \n",
       "58711              OBEROI REALTY         0.0            0.0       0.05   \n",
       "58712   NUCLEUS SOFTWARE EXPORTS         0.0            0.0       0.05   \n",
       "58713      TFB 7.62% 2035 SR. 3B         0.0            0.0       0.01   \n",
       "58714      TFB 7.53% 2030 SR. 2B         0.0            0.0       0.01   \n",
       "58715      TFB 7.36% 2025 SR. 1B         0.0            0.0       0.01   \n",
       "58716      TFB 7.37% 2035 SR. 3A         0.0            0.0       0.01   \n",
       "58717      TFB 7.28% 2030 SR. 2A         0.0            0.0       0.01   \n",
       "58718      TFB 7.11% 2025 SR. 1A         0.0            0.0       0.01   \n",
       "58719  8.49% SEC NON-CUM RED NCD         0.0            0.0       0.01   \n",
       "58720                                    0.0            0.0       0.05   \n",
       "58721           GLOBAL EDUCATION         0.0            0.0       0.05   \n",
       "58722   GLENMARK PHARMACEUTICALS         0.0            0.0       0.05   \n",
       "58723  GLAXOSMITHKLINE PHARMA LT         0.0            0.0       0.05   \n",
       "58724                                    0.0            0.0       0.05   \n",
       "58725             CINELINE INDIA         0.0            0.0       0.05   \n",
       "58726                     CIMMCO         0.0            0.0       0.05   \n",
       "58727                                    0.0            0.0       0.05   \n",
       "58728  CHOLAMANDALAM IN & FIN CO         0.0            0.0       0.05   \n",
       "\n",
       "       lot_size instrument_type segment exchange  \n",
       "58709      2000              EQ     NSE      NSE  \n",
       "58710         1              EQ     NSE      NSE  \n",
       "58711         1              EQ     NSE      NSE  \n",
       "58712         1              EQ     NSE      NSE  \n",
       "58713         1              EQ     NSE      NSE  \n",
       "58714         1              EQ     NSE      NSE  \n",
       "58715         1              EQ     NSE      NSE  \n",
       "58716         1              EQ     NSE      NSE  \n",
       "58717         1              EQ     NSE      NSE  \n",
       "58718         1              EQ     NSE      NSE  \n",
       "58719         1              EQ     NSE      NSE  \n",
       "58720         1              EQ     NSE      NSE  \n",
       "58721      1000              EQ     NSE      NSE  \n",
       "58722         1              EQ     NSE      NSE  \n",
       "58723         1              EQ     NSE      NSE  \n",
       "58724      4000              EQ     NSE      NSE  \n",
       "58725         1              EQ     NSE      NSE  \n",
       "58726         1              EQ     NSE      NSE  \n",
       "58727         1              EQ     NSE      NSE  \n",
       "58728         1              EQ     NSE      NSE  "
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(kite.instruments()).tail(20)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Finding a token from symbol"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "input token name\n",
      "SUNPHARMA\n",
      "enter exchange\n",
      "NSE\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>tradingsymbol</th>\n",
       "      <th>instrument_token</th>\n",
       "      <th>name</th>\n",
       "      <th>exchange</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>SUNPHARMA</td>\n",
       "      <td>857857</td>\n",
       "      <td>SUN PHARMACEUTICAL IND L</td>\n",
       "      <td>NSE</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    tradingsymbol  instrument_token                      name exchange\n",
       "378     SUNPHARMA            857857  SUN PHARMACEUTICAL IND L      NSE"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print(\"input token name\")\n",
    "token_n=str(input())\n",
    "print(\"enter exchange\")\n",
    "exc=str(input())\n",
    "pd.DataFrame(kite.instruments(exc))[[\"tradingsymbol\",\"instrument_token\",\"name\",\"exchange\"]][pd.DataFrame(kite.instruments(exc))[[\"tradingsymbol\",\"instrument_token\",\"name\",\"exchange\"]]['tradingsymbol'].str.contains(token_n)]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# INPUTS"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Example:  ( Inputs are case sensitive )\n",
    "1. Trading symbol             ... ( \"SUNPHARMA \")\n",
    "2. exchange                   ... (\" NSE / BSE \" / \" CDS \")\n",
    "3. productt                   ... (\" CNC\" / \" NRML \" )\n",
    "4. Quantity                   ... (1 , 2 , 3 etc ! how much u want)\n",
    "5. Instrument token           ... ( Ex SUNPHARMA instrument token is 857857 )\n",
    "6. RSI in condition           ...       ( 30 )\n",
    "7. RSI out condition          ...       ( 31 )\n",
    "8. rofit booking RSI condition...       ( 70 )\n",
    "9. Time frame of candels      ...   ( \"minute\"/ \"10 minute\" )\n",
    "10. starting data of Data     ...   ( \"2019-06-05\" )\n",
    "11. Ending data Of Data       ...   ( \"2019-07-02\" )"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Getting HISTORICAL DATA"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>close</th>\n",
       "      <th>date</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>open</th>\n",
       "      <th>volume</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>426.00</td>\n",
       "      <td>2019-08-19 00:00:00+05:30</td>\n",
       "      <td>434.20</td>\n",
       "      <td>421.00</td>\n",
       "      <td>424.75</td>\n",
       "      <td>11584821</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>420.90</td>\n",
       "      <td>2019-08-20 00:00:00+05:30</td>\n",
       "      <td>426.50</td>\n",
       "      <td>417.30</td>\n",
       "      <td>426.00</td>\n",
       "      <td>5151625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>417.00</td>\n",
       "      <td>2019-08-21 00:00:00+05:30</td>\n",
       "      <td>425.85</td>\n",
       "      <td>413.60</td>\n",
       "      <td>421.00</td>\n",
       "      <td>5120294</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>414.55</td>\n",
       "      <td>2019-08-22 00:00:00+05:30</td>\n",
       "      <td>420.75</td>\n",
       "      <td>408.50</td>\n",
       "      <td>416.70</td>\n",
       "      <td>5299316</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>427.80</td>\n",
       "      <td>2019-08-23 00:00:00+05:30</td>\n",
       "      <td>429.95</td>\n",
       "      <td>408.90</td>\n",
       "      <td>415.00</td>\n",
       "      <td>5479802</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>419.35</td>\n",
       "      <td>2019-08-26 00:00:00+05:30</td>\n",
       "      <td>429.80</td>\n",
       "      <td>415.10</td>\n",
       "      <td>428.00</td>\n",
       "      <td>6258106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>416.75</td>\n",
       "      <td>2019-08-27 00:00:00+05:30</td>\n",
       "      <td>425.45</td>\n",
       "      <td>415.10</td>\n",
       "      <td>424.05</td>\n",
       "      <td>6738413</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>413.10</td>\n",
       "      <td>2019-08-28 00:00:00+05:30</td>\n",
       "      <td>421.70</td>\n",
       "      <td>411.50</td>\n",
       "      <td>416.90</td>\n",
       "      <td>3441725</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>434.65</td>\n",
       "      <td>2019-08-29 00:00:00+05:30</td>\n",
       "      <td>438.60</td>\n",
       "      <td>421.10</td>\n",
       "      <td>428.00</td>\n",
       "      <td>19967263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>450.40</td>\n",
       "      <td>2019-08-30 00:00:00+05:30</td>\n",
       "      <td>453.40</td>\n",
       "      <td>429.75</td>\n",
       "      <td>432.95</td>\n",
       "      <td>12308149</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     close                      date    high     low    open    volume\n",
       "68  426.00 2019-08-19 00:00:00+05:30  434.20  421.00  424.75  11584821\n",
       "69  420.90 2019-08-20 00:00:00+05:30  426.50  417.30  426.00   5151625\n",
       "70  417.00 2019-08-21 00:00:00+05:30  425.85  413.60  421.00   5120294\n",
       "71  414.55 2019-08-22 00:00:00+05:30  420.75  408.50  416.70   5299316\n",
       "72  427.80 2019-08-23 00:00:00+05:30  429.95  408.90  415.00   5479802\n",
       "73  419.35 2019-08-26 00:00:00+05:30  429.80  415.10  428.00   6258106\n",
       "74  416.75 2019-08-27 00:00:00+05:30  425.45  415.10  424.05   6738413\n",
       "75  413.10 2019-08-28 00:00:00+05:30  421.70  411.50  416.90   3441725\n",
       "76  434.65 2019-08-29 00:00:00+05:30  438.60  421.10  428.00  19967263\n",
       "77  450.40 2019-08-30 00:00:00+05:30  453.40  429.75  432.95  12308149"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "token=857857 # this is the token of sunpharma \n",
    "starting_date=\"2019-05-10\"\n",
    "ending_date=\"2020-08-16\"\n",
    "time_period=\"day\"\n",
    "\n",
    "\n",
    "zap=kite.historical_data(token,starting_date,ending_date,time_period,0)\n",
    "zapp=pd.DataFrame(zap).tail(10)\n",
    "\n",
    "\n",
    "zapp"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Getting continous data of stock "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>close</th>\n",
       "      <th>date</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>open</th>\n",
       "      <th>volume</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>29244</th>\n",
       "      <td>452.45</td>\n",
       "      <td>2019-08-30 15:25:00+05:30</td>\n",
       "      <td>452.85</td>\n",
       "      <td>452.35</td>\n",
       "      <td>452.80</td>\n",
       "      <td>36323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29245</th>\n",
       "      <td>452.05</td>\n",
       "      <td>2019-08-30 15:26:00+05:30</td>\n",
       "      <td>452.55</td>\n",
       "      <td>452.05</td>\n",
       "      <td>452.45</td>\n",
       "      <td>16843</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29246</th>\n",
       "      <td>452.20</td>\n",
       "      <td>2019-08-30 15:27:00+05:30</td>\n",
       "      <td>452.25</td>\n",
       "      <td>452.00</td>\n",
       "      <td>452.05</td>\n",
       "      <td>30296</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29247</th>\n",
       "      <td>452.95</td>\n",
       "      <td>2019-08-30 15:28:00+05:30</td>\n",
       "      <td>452.95</td>\n",
       "      <td>452.05</td>\n",
       "      <td>452.20</td>\n",
       "      <td>49371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29248</th>\n",
       "      <td>452.15</td>\n",
       "      <td>2019-08-30 15:29:00+05:30</td>\n",
       "      <td>453.00</td>\n",
       "      <td>452.00</td>\n",
       "      <td>452.45</td>\n",
       "      <td>34857</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        close                      date    high     low    open  volume\n",
       "29244  452.45 2019-08-30 15:25:00+05:30  452.85  452.35  452.80   36323\n",
       "29245  452.05 2019-08-30 15:26:00+05:30  452.55  452.05  452.45   16843\n",
       "29246  452.20 2019-08-30 15:27:00+05:30  452.25  452.00  452.05   30296\n",
       "29247  452.95 2019-08-30 15:28:00+05:30  452.95  452.05  452.20   49371\n",
       "29248  452.15 2019-08-30 15:29:00+05:30  453.00  452.00  452.45   34857"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "token=857857 # this is the token of sunpharma \n",
    "starting_date=\"2019-05-10\"\n",
    "ending_date=\"2020-08-16\"\n",
    "time_period=\"minute\"\n",
    "\n",
    "def livedata():\n",
    "    while (True):\n",
    "        clear_output(wait=True)\n",
    "        z=kite.historical_data(token,starting_date,ending_date,time_period,0)\n",
    "        za=pd.DataFrame(z)\n",
    "        display(za.tail())\n",
    "        time.sleep(1)\n",
    "livedata()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# for last trade price of stock"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'1207553': {'instrument_token': 1207553, 'last_price': 129.8}}"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# GAIL\n",
    "kite.ltp(1207553)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# for last ohlc of stock"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'1207553': {'instrument_token': 1207553,\n",
       "  'last_price': 129.8,\n",
       "  'ohlc': {'open': 129.65, 'high': 133.1, 'low': 125.2, 'close': 128.5}}}"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# GAIL\n",
    "kite.ohlc(1207553)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# FOR PLACING AN ORDER :-"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "* market order place"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'190901000000678'"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kite.place_order(variety=\"regular\",tradingsymbol='IDEA',quantity=1,exchange='NSE',order_type='MARKET',transaction_type='SELL',product='MIS',tag='test')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "* BUY limit order place"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'190901000000681'"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kite.place_order( variety=\"regular\",tradingsymbol=\"ADANIPOWER\",quantity=1,exchange=\"BSE\",order_type='LIMIT',price=54,trigger_price=55,transaction_type='SELL',product='CNC',tag=\"te\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "* SELL limit order place"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'190901000000682'"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kite.place_order( variety=\"regular\",tradingsymbol=\"ADANIPOWER\",quantity=1,exchange=\"BSE\",order_type='LIMIT',price=54 ,trigger_price=52,transaction_type='SELL',product='CNC',tag=\"test\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Cancel an order "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'190901000000682'"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kite.cancel_order(\"regular\",order_id=\"190901000000682\", parent_order_id=None)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Exit from an order"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "kite.exit_order(variety=\"regular\",order_id='190901000000682')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Order Placed information"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "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>tradingsymbol</th>\n",
       "      <th>instrument_token</th>\n",
       "      <th>status</th>\n",
       "      <th>order_id</th>\n",
       "      <th>quantity</th>\n",
       "      <th>price</th>\n",
       "      <th>trigger_price</th>\n",
       "      <th>order_type</th>\n",
       "      <th>exchange_update_timestamp</th>\n",
       "      <th>exchange</th>\n",
       "      <th>tag</th>\n",
       "      <th>validity</th>\n",
       "      <th>average_price</th>\n",
       "      <th>pending_quantity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>GAIL</td>\n",
       "      <td>1207553</td>\n",
       "      <td>REJECTED</td>\n",
       "      <td>190901000000537</td>\n",
       "      <td>765</td>\n",
       "      <td>131.00</td>\n",
       "      <td>130.90</td>\n",
       "      <td>SL</td>\n",
       "      <td>None</td>\n",
       "      <td>NSE</td>\n",
       "      <td>advG</td>\n",
       "      <td>DAY</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NTPC</td>\n",
       "      <td>2977281</td>\n",
       "      <td>REJECTED</td>\n",
       "      <td>190901000000538</td>\n",
       "      <td>819</td>\n",
       "      <td>122.35</td>\n",
       "      <td>122.25</td>\n",
       "      <td>SL</td>\n",
       "      <td>None</td>\n",
       "      <td>NSE</td>\n",
       "      <td>advG</td>\n",
       "      <td>DAY</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>VEDL</td>\n",
       "      <td>784129</td>\n",
       "      <td>REJECTED</td>\n",
       "      <td>190901000000539</td>\n",
       "      <td>711</td>\n",
       "      <td>140.90</td>\n",
       "      <td>140.80</td>\n",
       "      <td>SL</td>\n",
       "      <td>None</td>\n",
       "      <td>NSE</td>\n",
       "      <td>advG</td>\n",
       "      <td>DAY</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>HDFC</td>\n",
       "      <td>340481</td>\n",
       "      <td>REJECTED</td>\n",
       "      <td>190901000000549</td>\n",
       "      <td>13</td>\n",
       "      <td>2171.95</td>\n",
       "      <td>2170.70</td>\n",
       "      <td>SL</td>\n",
       "      <td>None</td>\n",
       "      <td>NSE</td>\n",
       "      <td>advG</td>\n",
       "      <td>DAY</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>IDEA</td>\n",
       "      <td>3677697</td>\n",
       "      <td>REJECTED</td>\n",
       "      <td>190901000000678</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>MARKET</td>\n",
       "      <td>None</td>\n",
       "      <td>NSE</td>\n",
       "      <td>test</td>\n",
       "      <td>DAY</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>ADANIPOWER</td>\n",
       "      <td>136472580</td>\n",
       "      <td>REJECTED</td>\n",
       "      <td>190901000000681</td>\n",
       "      <td>1</td>\n",
       "      <td>54.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>LIMIT</td>\n",
       "      <td>None</td>\n",
       "      <td>BSE</td>\n",
       "      <td>te</td>\n",
       "      <td>DAY</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>ADANIPOWER</td>\n",
       "      <td>136472580</td>\n",
       "      <td>REJECTED</td>\n",
       "      <td>190901000000682</td>\n",
       "      <td>1</td>\n",
       "      <td>54.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>LIMIT</td>\n",
       "      <td>None</td>\n",
       "      <td>BSE</td>\n",
       "      <td>test</td>\n",
       "      <td>DAY</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  tradingsymbol  instrument_token    status         order_id  quantity  \\\n",
       "0          GAIL           1207553  REJECTED  190901000000537       765   \n",
       "1          NTPC           2977281  REJECTED  190901000000538       819   \n",
       "2          VEDL            784129  REJECTED  190901000000539       711   \n",
       "3          HDFC            340481  REJECTED  190901000000549        13   \n",
       "4          IDEA           3677697  REJECTED  190901000000678         1   \n",
       "5    ADANIPOWER         136472580  REJECTED  190901000000681         1   \n",
       "6    ADANIPOWER         136472580  REJECTED  190901000000682         1   \n",
       "\n",
       "     price  trigger_price order_type exchange_update_timestamp exchange   tag  \\\n",
       "0   131.00         130.90         SL                      None      NSE  advG   \n",
       "1   122.35         122.25         SL                      None      NSE  advG   \n",
       "2   140.90         140.80         SL                      None      NSE  advG   \n",
       "3  2171.95        2170.70         SL                      None      NSE  advG   \n",
       "4     0.00           0.00     MARKET                      None      NSE  test   \n",
       "5    54.00           0.00      LIMIT                      None      BSE    te   \n",
       "6    54.00           0.00      LIMIT                      None      BSE  test   \n",
       "\n",
       "  validity  average_price  pending_quantity  \n",
       "0      DAY              0                 0  \n",
       "1      DAY              0                 0  \n",
       "2      DAY              0                 0  \n",
       "3      DAY              0                 0  \n",
       "4      DAY              0                 0  \n",
       "5      DAY              0                 0  \n",
       "6      DAY              0                 0  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(pd.DataFrame(kite.orders())[[\"tradingsymbol\",\"instrument_token\",\"status\",\"order_id\",\"quantity\",\"price\",\"trigger_price\",\"order_type\",\"exchange_update_timestamp\",\"exchange\",'tag',\"validity\",  \"average_price\",\"pending_quantity\"]])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Open positions "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "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>net</th>\n",
       "      <th>day</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [net, day]\n",
       "Index: []"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(kite.positions())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Holdings you have "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "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>tradingsymbol</th>\n",
       "      <th>instrument_token</th>\n",
       "      <th>pnl</th>\n",
       "      <th>average_price</th>\n",
       "      <th>close_price</th>\n",
       "      <th>collateral_quantity</th>\n",
       "      <th>collateral_type</th>\n",
       "      <th>day_change</th>\n",
       "      <th>day_change_percentage</th>\n",
       "      <th>exchange</th>\n",
       "      <th>isin</th>\n",
       "      <th>last_price</th>\n",
       "      <th>price</th>\n",
       "      <th>product</th>\n",
       "      <th>quantity</th>\n",
       "      <th>realised_quantity</th>\n",
       "      <th>t1_quantity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ADANIPOWER</td>\n",
       "      <td>4451329</td>\n",
       "      <td>-2.95</td>\n",
       "      <td>61.350</td>\n",
       "      <td>58.40</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NSE</td>\n",
       "      <td>INE814H01011</td>\n",
       "      <td>58.40</td>\n",
       "      <td>0</td>\n",
       "      <td>CNC</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CRESSAN</td>\n",
       "      <td>131169028</td>\n",
       "      <td>-0.05</td>\n",
       "      <td>0.200</td>\n",
       "      <td>0.19</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>BSE</td>\n",
       "      <td>INE716D01033</td>\n",
       "      <td>0.19</td>\n",
       "      <td>0</td>\n",
       "      <td>CNC</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>IDEA</td>\n",
       "      <td>3677697</td>\n",
       "      <td>-26.72</td>\n",
       "      <td>10.694</td>\n",
       "      <td>5.37</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>-0.02</td>\n",
       "      <td>-0.372439</td>\n",
       "      <td>NSE</td>\n",
       "      <td>INE669E01016</td>\n",
       "      <td>5.35</td>\n",
       "      <td>0</td>\n",
       "      <td>CNC</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>VIKASPROP</td>\n",
       "      <td>3109889</td>\n",
       "      <td>-0.25</td>\n",
       "      <td>4.300</td>\n",
       "      <td>4.05</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NSE</td>\n",
       "      <td>INE767B01022</td>\n",
       "      <td>4.05</td>\n",
       "      <td>0</td>\n",
       "      <td>CNC</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  tradingsymbol  instrument_token    pnl  average_price  close_price  \\\n",
       "0    ADANIPOWER           4451329  -2.95         61.350        58.40   \n",
       "1       CRESSAN         131169028  -0.05          0.200         0.19   \n",
       "2          IDEA           3677697 -26.72         10.694         5.37   \n",
       "3     VIKASPROP           3109889  -0.25          4.300         4.05   \n",
       "\n",
       "   collateral_quantity collateral_type  day_change  day_change_percentage  \\\n",
       "0                    0                        0.00               0.000000   \n",
       "1                    0                        0.00               0.000000   \n",
       "2                    0                       -0.02              -0.372439   \n",
       "3                    0                        0.00               0.000000   \n",
       "\n",
       "  exchange          isin  last_price  price product  quantity  \\\n",
       "0      NSE  INE814H01011       58.40      0     CNC         1   \n",
       "1      BSE  INE716D01033        0.19      0     CNC         5   \n",
       "2      NSE  INE669E01016        5.35      0     CNC         5   \n",
       "3      NSE  INE767B01022        4.05      0     CNC         1   \n",
       "\n",
       "   realised_quantity  t1_quantity  \n",
       "0                  1            0  \n",
       "1                  5            0  \n",
       "2                  5            0  \n",
       "3                  1            0  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(pd.DataFrame(kite.holdings())[[\"tradingsymbol\",\"instrument_token\",\"pnl\",\"average_price\",\"close_price\",\"collateral_quantity\",\"collateral_type\",\"day_change\",\"day_change_percentage\",\"exchange\",\"isin\",\"last_price\",\"price\",\"product\",\"quantity\",\"realised_quantity\",\"t1_quantity\" ]])      "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Websocket"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import logging\n",
    "from kiteconnect import KiteTicker\n",
    "logging.basicConfig(level=logging.DEBUG)\n",
    "kws = KiteTicker(\"inx2yhl01h5udgec\", \"R46Cl90i4SQakKZqFvC3g130gQAzj31J\")\n",
    "def on_ticks(ws, ticks):\n",
    "    logging.debug(\"Ticks: {}\".format(ticks))\n",
    "def on_connect(ws, response):\n",
    "    ws.subscribe([256265])\n",
    "    ws.set_mode(ws.MODE_FULL, [256265])\n",
    "def on_close(ws, code, reason):\n",
    "    ws.stop()\n",
    "kws.on_ticks = on_ticks\n",
    "kws.on_connect = on_connect\n",
    "kws.on_close = on_close\n",
    "kws.connect()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Websocket threading"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import threading \n",
    "class ThreadingData(object):\n",
    "    #  Making Variables as global of websocket\n",
    "    global app_z_status\n",
    "    global app_z_order\n",
    "    global app_z_order_type\n",
    "    global app_z_transaction_type\n",
    "    # Variables of websocket\n",
    "    app_z_status=[]\n",
    "    app_z_order=[]\n",
    "    app_z_order_type=[]\n",
    "    app_z_transaction_type=[]\n",
    "    def __init__(self):\n",
    "        thread = threading.Thread(target=self.run, args=())\n",
    "        thread.daemon = True\n",
    "        thread.start()\n",
    "    def run(self):\n",
    "        \n",
    "        #----------------------------------------------------------------------------***** PUBLIC TOKEN\n",
    "        \n",
    "        access_token=\"tCplfRM4E5VZkfDc81byFjFGWy29R7uN\" \n",
    "        api_key=\"inx2yhl01h5udgec\"\n",
    "        logging.basicConfig(level=logging.DEBUG, format='%(asctime)s - %(name)s - %(levelname)s - %(message)s')\n",
    "        clear_output(wait=True)\n",
    "        kws = KiteTicker(api_key, access_token, debug=True)\n",
    "        \n",
    "        # Making Variables as global of websocket\n",
    "        \n",
    "        global app_z_status\n",
    "        global app_z_order\n",
    "        global app_z_order_type\n",
    "        global app_z_transaction_type\n",
    "\n",
    "        # INPUT TOKEN --------------------------------------------------------------***** INPUT TOKEN\n",
    "        \n",
    "        tokens = [131169028]\n",
    "        \n",
    "        print(\"Tokens length\", len(tokens))     \n",
    "        \n",
    "        # Websocket Working\n",
    "        def on_connect(ws, response):\n",
    "            logging.debug(\"on connect: {}\".format(response))\n",
    "            ws.subscribe(tokens)\n",
    "            ws.set_mode(ws.MODE_FULL, tokens)\n",
    "        def on_close(ws, code, reason):\n",
    "            logging.error(\"closed connection on close: {} {}\".format(code, reason))\n",
    "        def on_error(ws, code, reason):\n",
    "            logging.error(\"closed connection on error: {} {}\".format(code, reason))\n",
    "        def on_noreconnect(ws):\n",
    "            logging.error(\"Reconnecting the websocket failed\")\n",
    "        def on_reconnect(ws, attempt_count):\n",
    "            logging.debug(\"Reconnecting the websocket: {}\".format(attempt_count))\n",
    "        def on_order_update(ws, data):\n",
    "            \n",
    "            # Accessing Data from websocket \n",
    "            \n",
    "            z_status=data['status']\n",
    "            z_order=data[\"order_id\"]\n",
    "            z_order_type=data[\"order_type\"]\n",
    "            z_transaction_type=[\"transaction_type\"]\n",
    "            \n",
    "            # APPEND websocket data into variables\n",
    "            \n",
    "            app_z_status.append(z_status)\n",
    "            app_z_order.append(z_order)\n",
    "            app_z_order_type.append(z_order_type)\n",
    "            app_z_transaction_type.append(z_transaction_type)\n",
    "            \n",
    "            # printing All websocket data \n",
    "            \n",
    "            print(app_z_status)\n",
    "            print(app_z_order)\n",
    "            print(app_z_order_type)\n",
    "            print(app_z_transaction_type)\n",
    "            print(data)\n",
    "            \n",
    "        # calling all functions\n",
    "        \n",
    "        kws.on_connect      = on_connect\n",
    "        kws.on_close        = on_close\n",
    "        kws.on_error        = on_error\n",
    "        kws.on_noreconnect  = on_noreconnect\n",
    "        kws.on_reconnect    = on_reconnect\n",
    "        kws.on_order_update = on_order_update\n",
    "        kws.connect()\n",
    "\n",
    "thre=ThreadingData()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# STATUS of order from websocket :-"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    " {'average_price': 0,\n",
    "  'cancelled_quantity': 0,\n",
    "  'disclosed_quantity': 0,\n",
    "  'exchange': 'NSE',\n",
    "  'exchange_order_id': None,\n",
    "  'exchange_timestamp': None,\n",
    "  'filled_quantity': 0,\n",
    "  'guid': '10778X8ZFO5b41UslC',\n",
    "  'instrument_token': 857857,\n",
    "  'market_protection': 0,\n",
    "  'order_id': '190521001155150',\n",
    "  'order_timestamp': datetime.datetime(2019, 5, 21, 10, 54, 46),\n",
    "  'order_type': 'SL',\n",
    "  'parent_order_id': None,\n",
    "  'pending_quantity': 0,\n",
    "  'placed_by': 'BQ8330',\n",
    "  'price': 555,\n",
    "  'product': 'CNC',\n",
    "  'quantity': 1,\n",
    "  'status': 'REJECTED',\n",
    "  'status_message': 'Price exceeds circuit limits for the instrument. Place an order within the daily range.',\n",
    "  'status_message_raw': 'RMS:R"
   ]
  }
 ],
 "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
}
#END