How to get F & O Companies List from Kite Connect API

how-to-get-f-o-companies-list-from-kite-connect-api.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "How to get F & O Companies List from Kite Connect API",
      "provenance": [],
      "collapsed_sections": [],
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/gist/aeron7/273cd205c2aba15dfed52dc13a9a19fe/how-to-get-f-o-companies-list-from-kite-connect-api.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "rS-BpDOFQsLN",
        "colab_type": "code",
        "outputId": "44c4abc7-2c99-43ff-f59d-ec7d32393acd",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        }
      },
      "source": [
        "#Srapping the Site\n",
        "import requests\n",
        "session = requests.Session()\n",
        "headers = {\n",
        "    'accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3',\n",
        "    'accept-encoding': 'gzip, deflate, br',\n",
        "    'accept-language': 'en-US,en;q=0.9,hi;q=0.8',\n",
        "    'Cache-Control': 'max-age=0',\n",
        "    'Connection': 'keep-alive',\n",
        "    'user-agent':'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36'\n",
        "    }\n",
        "response=session.get('http://zerodha.com/margin-calculator/Futures/')\n",
        "response= (response.content)\n",
        "#print(response)\n",
        "\n",
        "#Extracting the Table\n",
        "response = str(response,\"utf-8\").split('<div id=\"legend_container\" class=\"mini-container\">')[1]\n",
        "response = response.split('<div id=\"popup-futures\" class=\"popup\">')[0]\n",
        "\n",
        "\n",
        "#Feeding the Table to Pandas Dataframe\n",
        "import pandas as pd\n",
        "tables=pd.read_html(response)[1]\n",
        "#print(tables)\n",
        "\n",
        "#Drop the duplicate Expiries\n",
        "\n",
        "tables.drop_duplicates(subset =\"Contract\", keep = 'first', inplace = True) \n",
        "#print(tables)\n",
        "\n",
        "#Extracting the NFO list\n",
        "\n",
        "nfolist = tables['Contract'].tolist()\n",
        "for x in nfolist:\n",
        "  print(x)"
      ],
      "execution_count": 1,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "ACC\n",
            "ADANIENT\n",
            "ADANIPORTS\n",
            "ADANIPOWER\n",
            "AMARAJABAT\n",
            "AMBUJACEM\n",
            "APOLLOHOSP\n",
            "APOLLOTYRE\n",
            "ASHOKLEY\n",
            "ASIANPAINT\n",
            "AUROPHARMA\n",
            "AXISBANK\n",
            "BAJAJ-AUTO\n",
            "BAJAJFINSV\n",
            "BAJFINANCE\n",
            "BALKRISIND\n",
            "BANKBARODA\n",
            "BANKNIFTY\n",
            "BATAINDIA\n",
            "BEL\n",
            "BERGEPAINT\n",
            "BHARATFORG\n",
            "BHARTIARTL\n",
            "BHEL\n",
            "BIOCON\n",
            "BOSCHLTD\n",
            "BPCL\n",
            "BRITANNIA\n",
            "CADILAHC\n",
            "CANBK\n",
            "CASTROLIND\n",
            "CENTURYTEX\n",
            "CESC\n",
            "CHOLAFIN\n",
            "CIPLA\n",
            "COALINDIA\n",
            "COLPAL\n",
            "CONCOR\n",
            "CUMMINSIND\n",
            "DABUR\n",
            "DISHTV\n",
            "DIVISLAB\n",
            "DLF\n",
            "DRREDDY\n",
            "EICHERMOT\n",
            "EQUITAS\n",
            "ESCORTS\n",
            "EXIDEIND\n",
            "FEDERALBNK\n",
            "GAIL\n",
            "GLENMARK\n",
            "GMRINFRA\n",
            "GODREJCP\n",
            "GRASIM\n",
            "HAVELLS\n",
            "HCLTECH\n",
            "HDFC\n",
            "HDFCBANK\n",
            "HEROMOTOCO\n",
            "HEXAWARE\n",
            "HINDALCO\n",
            "HINDPETRO\n",
            "HINDUNILVR\n",
            "IBULHSGFIN\n",
            "ICICIBANK\n",
            "ICICIPRULI\n",
            "IDEA\n",
            "IDFCFIRSTB\n",
            "IGL\n",
            "INDIGO\n",
            "INDUSINDBK\n",
            "INFRATEL\n",
            "INFY\n",
            "IOC\n",
            "ITC\n",
            "JINDALSTEL\n",
            "JSWSTEEL\n",
            "JUBLFOOD\n",
            "JUSTDIAL\n",
            "KOTAKBANK\n",
            "L&TFH\n",
            "LICHSGFIN\n",
            "LT\n",
            "LUPIN\n",
            "M&M\n",
            "M&MFIN\n",
            "MANAPPURAM\n",
            "MARICO\n",
            "MARUTI\n",
            "MCDOWELL-N\n",
            "MFSL\n",
            "MGL\n",
            "MINDTREE\n",
            "MOTHERSUMI\n",
            "MRF\n",
            "MUTHOOTFIN\n",
            "NATIONALUM\n",
            "NBCC\n",
            "NCC\n",
            "NESTLEIND\n",
            "NIFTY\n",
            "NIFTYIT\n",
            "NIITTECH\n",
            "NMDC\n",
            "NTPC\n",
            "OIL\n",
            "ONGC\n",
            "PAGEIND\n",
            "PEL\n",
            "PETRONET\n",
            "PFC\n",
            "PIDILITIND\n",
            "PNB\n",
            "POWERGRID\n",
            "PVR\n",
            "RAMCOCEM\n",
            "RBLBANK\n",
            "RECLTD\n",
            "RELIANCE\n",
            "SAIL\n",
            "SBIN\n",
            "SHREECEM\n",
            "SIEMENS\n",
            "SRF\n",
            "SRTRANSFIN\n",
            "SUNPHARMA\n",
            "SUNTV\n",
            "TATACHEM\n",
            "TATAELXSI\n",
            "TATAGLOBAL\n",
            "TATAMOTORS\n",
            "TATAMTRDVR\n",
            "TATAPOWER\n",
            "TATASTEEL\n",
            "TCS\n",
            "TECHM\n",
            "TITAN\n",
            "TORNTPHARM\n",
            "TORNTPOWER\n",
            "TVSMOTOR\n",
            "UBL\n",
            "UJJIVAN\n",
            "ULTRACEMCO\n",
            "UNIONBANK\n",
            "UPL\n",
            "VEDL\n",
            "VOLTAS\n",
            "WIPRO\n",
            "YESBANK\n",
            "ZEEL\n"
          ],
          "name": "stdout"
        }
      ]
    }
  ]
}