1)_Getting_Started_with_Zerodha_.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "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"
    },
    "colab": {
      "name": "1). Getting Started with Zerodha .ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "include_colab_link": true
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/ashishkumar30/Zerodha_Live_Automate_Trading-_using_AI_ML_on_Indian_stock_market-using-basic-python/blob/master/1)_Getting_Started_with_Zerodha_.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "kXWQClNAL7Mm",
        "colab_type": "text"
      },
      "source": [
        "# Starting new project with zerodha"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "_jiHn21EL7Mq",
        "colab_type": "text"
      },
      "source": [
        "install Kiteconnect\n",
        "* pip install kiteconnect "
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "ucuJO79BL7Ms",
        "colab_type": "text"
      },
      "source": [
        "# Import All libraries required"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "C0OaOAMUL7Mu",
        "colab_type": "code",
        "colab": {}
      },
      "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"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "IQ5RKDp2L7M1",
        "colab_type": "text"
      },
      "source": [
        "# Login to zerodha "
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "4jgYunT5L7M3",
        "colab_type": "text"
      },
      "source": [
        "enter your api key and api secret"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "CMnS0c19L7M4",
        "colab_type": "code",
        "colab": {}
      },
      "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\")"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "_hzNKYX5L7M-",
        "colab_type": "text"
      },
      "source": [
        "# Finding \" Instrument Token list of zerodha\" "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "-6ciKl6pL7M_",
        "colab_type": "code",
        "colab": {},
        "outputId": "f68ea1a0-6fba-445e-f1cd-ebde5ac38dc4"
      },
      "source": [
        "pd.DataFrame(kite.instruments()).tail(20)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "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  "
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 29
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "wupBzeMsL7NG",
        "colab_type": "text"
      },
      "source": [
        "# Finding a token from symbol"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Koy2VLajL7NI",
        "colab_type": "code",
        "colab": {},
        "outputId": "1debe635-8a35-408f-c228-67fec9935f7a"
      },
      "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)]"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "input token name\n",
            "SUNPHARMA\n",
            "enter exchange\n",
            "NSE\n"
          ],
          "name": "stdout"
        },
        {
          "output_type": "execute_result",
          "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"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "1fRSYtDGL7NO",
        "colab_type": "text"
      },
      "source": [
        "# INPUTS"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "RMBqa3gXL7NQ",
        "colab_type": "text"
      },
      "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": {
        "id": "MGovyvrHL7NS",
        "colab_type": "text"
      },
      "source": [
        "# Getting HISTORICAL DATA"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "et9R_RZnL7NT",
        "colab_type": "code",
        "colab": {},
        "outputId": "6b85af02-315d-4c0e-9792-bb3404ac8802"
      },
      "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",
        "zap=kite.historical_data(token,starting_date,ending_date,time_period,0)\n",
        "zapp=pd.DataFrame(zap).tail(10)\n",
        "\n",
        "zapp"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "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"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "KIx98xOHL7NY",
        "colab_type": "text"
      },
      "source": [
        "# Getting continous data of stock "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "demMQQvwL7Na",
        "colab_type": "code",
        "colab": {},
        "outputId": "8e8fb3f5-015d-4281-9c32-d82b4dfe756a"
      },
      "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()"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "display_data",
          "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": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "GSjcvC7aL7Nf",
        "colab_type": "text"
      },
      "source": [
        "# for last trade price of stock"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Iu86itHNL7Ni",
        "colab_type": "code",
        "colab": {},
        "outputId": "239d51c3-2644-49a9-9460-30cbe0580830"
      },
      "source": [
        "# GAIL\n",
        "kite.ltp(1207553)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'1207553': {'instrument_token': 1207553, 'last_price': 129.8}}"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 46
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "LrZ8NJ18L7No",
        "colab_type": "text"
      },
      "source": [
        "# for last ohlc of stock"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ZsVWbdSZL7Nq",
        "colab_type": "code",
        "colab": {},
        "outputId": "652b0e2c-db2a-47b7-e42e-ede1ccec1c7f"
      },
      "source": [
        "# GAIL\n",
        "kite.ohlc(1207553)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "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}}}"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 31
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "2Pw6DhmaL7Nu",
        "colab_type": "text"
      },
      "source": [
        "# FOR PLACING AN ORDER :-"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "814BeUu5L7Nw",
        "colab_type": "text"
      },
      "source": [
        "* market order place"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "78WtFpA1L7Nx",
        "colab_type": "code",
        "colab": {},
        "outputId": "ecc33c8a-e35c-4e3a-f8a0-1048f73375ab"
      },
      "source": [
        "kite.place_order(variety=\"regular\",tradingsymbol='IDEA',quantity=1,exchange='NSE',order_type='MARKET',transaction_type='SELL',product='MIS',tag='test')"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "'190901000000678'"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 32
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "g3wDh1s3L7N2",
        "colab_type": "text"
      },
      "source": [
        "* BUY limit order place"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "JY9r4wBBL7N4",
        "colab_type": "code",
        "colab": {},
        "outputId": "9e58b2dd-4733-41b0-9290-311b80c7080b"
      },
      "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\")"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "'190901000000681'"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 35
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "CAF4z5X0L7N9",
        "colab_type": "text"
      },
      "source": [
        "* SELL limit order place"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "xpki0GzjL7N_",
        "colab_type": "code",
        "colab": {},
        "outputId": "75af1d7e-b018-4088-a3da-e4a82ff2de88"
      },
      "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\")"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "'190901000000682'"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 37
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "zrSUAWOLL7OE",
        "colab_type": "text"
      },
      "source": [
        "# Cancel an order "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "s8D5SrIwL7OG",
        "colab_type": "code",
        "colab": {},
        "outputId": "25002b6f-33db-4a19-acda-561b989e35cb"
      },
      "source": [
        "kite.cancel_order(\"regular\",order_id=\"190901000000682\", parent_order_id=None)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "'190901000000682'"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 40
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "jHXZewPOL7OK",
        "colab_type": "text"
      },
      "source": [
        "# Exit from an order"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "q1wtTkp1L7OL",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "kite.exit_order(variety=\"regular\",order_id='190901000000682')"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "jr5t0McRL7OR",
        "colab_type": "text"
      },
      "source": [
        "# Order Placed information"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "EJxLX0ggL7OT",
        "colab_type": "code",
        "colab": {},
        "outputId": "8f2077fd-1ed0-4891-c7c4-9c7acc24105b"
      },
      "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\"]])"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "display_data",
          "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": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "DtpoIoTQL7OY",
        "colab_type": "text"
      },
      "source": [
        "# Open positions "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "4EiG5wOFL7Oa",
        "colab_type": "code",
        "colab": {},
        "outputId": "54404645-158a-437f-8177-09ec9ea616be"
      },
      "source": [
        "pd.DataFrame(kite.positions())"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "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: []"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 44
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "VlRSy_tUL7Oe",
        "colab_type": "text"
      },
      "source": [
        "# Holdings you have "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "50-CsWRZL7Og",
        "colab_type": "code",
        "colab": {},
        "outputId": "16481f88-38a1-40f1-b700-879ebac4f9db"
      },
      "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\" ]])      "
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "display_data",
          "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": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "DpKZz6BBL7Ok",
        "colab_type": "text"
      },
      "source": [
        "# Websocket"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "tyTOWvvhL7Om",
        "colab_type": "code",
        "colab": {}
      },
      "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()"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "QAXvT4H7L7Ou",
        "colab_type": "text"
      },
      "source": [
        "# Websocket threading"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "vYRCVdgvL7Ov",
        "colab_type": "code",
        "colab": {}
      },
      "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()"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "-4X3r23vL7O0",
        "colab_type": "text"
      },
      "source": [
        "# STATUS of order from websocket :-"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "s_RJNIPBL7O1",
        "colab_type": "text"
      },
      "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"
      ]
    }
  ]
}