YHT_1.5_paisa_10_10_2020_version.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# import logging\n",
    "# from kiteconnect import KiteConnect\n",
    "# logging.basicConfig(level=logging.ERROR)\n",
    "# import threading\n",
    "# kite = KiteConnect(api_key=\"w19o0chuo929jxkp\")\n",
    "# import joblib\n",
    "# kite = joblib.load('kitefile.p')\n",
    "# kite.login_url()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# mytoken = input('Enter Token Here : ')  \n",
    "# data = kite.generate_session(mytoken,api_secret=\"gsw8ps17ex7lf3cuji4prfnwb4vlyr4y\")\n",
    "# kite.set_access_token(data[\"access_token\"])\n",
    "# import joblib\n",
    "# joblib.dump(kite,'kitefile.p')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# import act"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "yc7FqxAzIL19nknBFgI2f7Ntce5KEPYZ\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "\n",
       "    <div class=\"bk-root\">\n",
       "        <a href=\"https://bokeh.org\" target=\"_blank\" class=\"bk-logo bk-logo-small bk-logo-notebook\"></a>\n",
       "        <span id=\"1001\">Loading BokehJS ...</span>\n",
       "    </div>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "\n",
       "(function(root) {\n",
       "  function now() {\n",
       "    return new Date();\n",
       "  }\n",
       "\n",
       "  var force = true;\n",
       "\n",
       "  if (typeof root._bokeh_onload_callbacks === \"undefined\" || force === true) {\n",
       "    root._bokeh_onload_callbacks = [];\n",
       "    root._bokeh_is_loading = undefined;\n",
       "  }\n",
       "\n",
       "  var JS_MIME_TYPE = 'application/javascript';\n",
       "  var HTML_MIME_TYPE = 'text/html';\n",
       "  var EXEC_MIME_TYPE = 'application/vnd.bokehjs_exec.v0+json';\n",
       "  var CLASS_NAME = 'output_bokeh rendered_html';\n",
       "\n",
       "  /**\n",
       "   * Render data to the DOM node\n",
       "   */\n",
       "  function render(props, node) {\n",
       "    var script = document.createElement(\"script\");\n",
       "    node.appendChild(script);\n",
       "  }\n",
       "\n",
       "  /**\n",
       "   * Handle when an output is cleared or removed\n",
       "   */\n",
       "  function handleClearOutput(event, handle) {\n",
       "    var cell = handle.cell;\n",
       "\n",
       "    var id = cell.output_area._bokeh_element_id;\n",
       "    var server_id = cell.output_area._bokeh_server_id;\n",
       "    // Clean up Bokeh references\n",
       "    if (id != null && id in Bokeh.index) {\n",
       "      Bokeh.index[id].model.document.clear();\n",
       "      delete Bokeh.index[id];\n",
       "    }\n",
       "\n",
       "    if (server_id !== undefined) {\n",
       "      // Clean up Bokeh references\n",
       "      var cmd = \"from bokeh.io.state import curstate; print(curstate().uuid_to_server['\" + server_id + \"'].get_sessions()[0].document.roots[0]._id)\";\n",
       "      cell.notebook.kernel.execute(cmd, {\n",
       "        iopub: {\n",
       "          output: function(msg) {\n",
       "            var id = msg.content.text.trim();\n",
       "            if (id in Bokeh.index) {\n",
       "              Bokeh.index[id].model.document.clear();\n",
       "              delete Bokeh.index[id];\n",
       "            }\n",
       "          }\n",
       "        }\n",
       "      });\n",
       "      // Destroy server and session\n",
       "      var cmd = \"import bokeh.io.notebook as ion; ion.destroy_server('\" + server_id + \"')\";\n",
       "      cell.notebook.kernel.execute(cmd);\n",
       "    }\n",
       "  }\n",
       "\n",
       "  /**\n",
       "   * Handle when a new output is added\n",
       "   */\n",
       "  function handleAddOutput(event, handle) {\n",
       "    var output_area = handle.output_area;\n",
       "    var output = handle.output;\n",
       "\n",
       "    // limit handleAddOutput to display_data with EXEC_MIME_TYPE content only\n",
       "    if ((output.output_type != \"display_data\") || (!output.data.hasOwnProperty(EXEC_MIME_TYPE))) {\n",
       "      return\n",
       "    }\n",
       "\n",
       "    var toinsert = output_area.element.find(\".\" + CLASS_NAME.split(' ')[0]);\n",
       "\n",
       "    if (output.metadata[EXEC_MIME_TYPE][\"id\"] !== undefined) {\n",
       "      toinsert[toinsert.length - 1].firstChild.textContent = output.data[JS_MIME_TYPE];\n",
       "      // store reference to embed id on output_area\n",
       "      output_area._bokeh_element_id = output.metadata[EXEC_MIME_TYPE][\"id\"];\n",
       "    }\n",
       "    if (output.metadata[EXEC_MIME_TYPE][\"server_id\"] !== undefined) {\n",
       "      var bk_div = document.createElement(\"div\");\n",
       "      bk_div.innerHTML = output.data[HTML_MIME_TYPE];\n",
       "      var script_attrs = bk_div.children[0].attributes;\n",
       "      for (var i = 0; i < script_attrs.length; i++) {\n",
       "        toinsert[toinsert.length - 1].firstChild.setAttribute(script_attrs[i].name, script_attrs[i].value);\n",
       "        toinsert[toinsert.length - 1].firstChild.textContent = bk_div.children[0].textContent\n",
       "      }\n",
       "      // store reference to server id on output_area\n",
       "      output_area._bokeh_server_id = output.metadata[EXEC_MIME_TYPE][\"server_id\"];\n",
       "    }\n",
       "  }\n",
       "\n",
       "  function register_renderer(events, OutputArea) {\n",
       "\n",
       "    function append_mime(data, metadata, element) {\n",
       "      // create a DOM node to render to\n",
       "      var toinsert = this.create_output_subarea(\n",
       "        metadata,\n",
       "        CLASS_NAME,\n",
       "        EXEC_MIME_TYPE\n",
       "      );\n",
       "      this.keyboard_manager.register_events(toinsert);\n",
       "      // Render to node\n",
       "      var props = {data: data, metadata: metadata[EXEC_MIME_TYPE]};\n",
       "      render(props, toinsert[toinsert.length - 1]);\n",
       "      element.append(toinsert);\n",
       "      return toinsert\n",
       "    }\n",
       "\n",
       "    /* Handle when an output is cleared or removed */\n",
       "    events.on('clear_output.CodeCell', handleClearOutput);\n",
       "    events.on('delete.Cell', handleClearOutput);\n",
       "\n",
       "    /* Handle when a new output is added */\n",
       "    events.on('output_added.OutputArea', handleAddOutput);\n",
       "\n",
       "    /**\n",
       "     * Register the mime type and append_mime function with output_area\n",
       "     */\n",
       "    OutputArea.prototype.register_mime_type(EXEC_MIME_TYPE, append_mime, {\n",
       "      /* Is output safe? */\n",
       "      safe: true,\n",
       "      /* Index of renderer in `output_area.display_order` */\n",
       "      index: 0\n",
       "    });\n",
       "  }\n",
       "\n",
       "  // register the mime type if in Jupyter Notebook environment and previously unregistered\n",
       "  if (root.Jupyter !== undefined) {\n",
       "    var events = require('base/js/events');\n",
       "    var OutputArea = require('notebook/js/outputarea').OutputArea;\n",
       "\n",
       "    if (OutputArea.prototype.mime_types().indexOf(EXEC_MIME_TYPE) == -1) {\n",
       "      register_renderer(events, OutputArea);\n",
       "    }\n",
       "  }\n",
       "\n",
       "  \n",
       "  if (typeof (root._bokeh_timeout) === \"undefined\" || force === true) {\n",
       "    root._bokeh_timeout = Date.now() + 5000;\n",
       "    root._bokeh_failed_load = false;\n",
       "  }\n",
       "\n",
       "  var NB_LOAD_WARNING = {'data': {'text/html':\n",
       "     \"<div style='background-color: #fdd'>\\n\"+\n",
       "     \"<p>\\n\"+\n",
       "     \"BokehJS does not appear to have successfully loaded. If loading BokehJS from CDN, this \\n\"+\n",
       "     \"may be due to a slow or bad network connection. Possible fixes:\\n\"+\n",
       "     \"</p>\\n\"+\n",
       "     \"<ul>\\n\"+\n",
       "     \"<li>re-rerun `output_notebook()` to attempt to load from CDN again, or</li>\\n\"+\n",
       "     \"<li>use INLINE resources instead, as so:</li>\\n\"+\n",
       "     \"</ul>\\n\"+\n",
       "     \"<code>\\n\"+\n",
       "     \"from bokeh.resources import INLINE\\n\"+\n",
       "     \"output_notebook(resources=INLINE)\\n\"+\n",
       "     \"</code>\\n\"+\n",
       "     \"</div>\"}};\n",
       "\n",
       "  function display_loaded() {\n",
       "    var el = document.getElementById(\"1001\");\n",
       "    if (el != null) {\n",
       "      el.textContent = \"BokehJS is loading...\";\n",
       "    }\n",
       "    if (root.Bokeh !== undefined) {\n",
       "      if (el != null) {\n",
       "        el.textContent = \"BokehJS \" + root.Bokeh.version + \" successfully loaded.\";\n",
       "      }\n",
       "    } else if (Date.now() < root._bokeh_timeout) {\n",
       "      setTimeout(display_loaded, 100)\n",
       "    }\n",
       "  }\n",
       "\n",
       "\n",
       "  function run_callbacks() {\n",
       "    try {\n",
       "      root._bokeh_onload_callbacks.forEach(function(callback) {\n",
       "        if (callback != null)\n",
       "          callback();\n",
       "      });\n",
       "    } finally {\n",
       "      delete root._bokeh_onload_callbacks\n",
       "    }\n",
       "    console.debug(\"Bokeh: all callbacks have finished\");\n",
       "  }\n",
       "\n",
       "  function load_libs(css_urls, js_urls, callback) {\n",
       "    if (css_urls == null) css_urls = [];\n",
       "    if (js_urls == null) js_urls = [];\n",
       "\n",
       "    root._bokeh_onload_callbacks.push(callback);\n",
       "    if (root._bokeh_is_loading > 0) {\n",
       "      console.debug(\"Bokeh: BokehJS is being loaded, scheduling callback at\", now());\n",
       "      return null;\n",
       "    }\n",
       "    if (js_urls == null || js_urls.length === 0) {\n",
       "      run_callbacks();\n",
       "      return null;\n",
       "    }\n",
       "    console.debug(\"Bokeh: BokehJS not loaded, scheduling load and callback at\", now());\n",
       "    root._bokeh_is_loading = css_urls.length + js_urls.length;\n",
       "\n",
       "    function on_load() {\n",
       "      root._bokeh_is_loading--;\n",
       "      if (root._bokeh_is_loading === 0) {\n",
       "        console.debug(\"Bokeh: all BokehJS libraries/stylesheets loaded\");\n",
       "        run_callbacks()\n",
       "      }\n",
       "    }\n",
       "\n",
       "    function on_error() {\n",
       "      console.error(\"failed to load \" + url);\n",
       "    }\n",
       "\n",
       "    for (var i = 0; i < css_urls.length; i++) {\n",
       "      var url = css_urls[i];\n",
       "      const element = document.createElement(\"link\");\n",
       "      element.onload = on_load;\n",
       "      element.onerror = on_error;\n",
       "      element.rel = \"stylesheet\";\n",
       "      element.type = \"text/css\";\n",
       "      element.href = url;\n",
       "      console.debug(\"Bokeh: injecting link tag for BokehJS stylesheet: \", url);\n",
       "      document.body.appendChild(element);\n",
       "    }\n",
       "\n",
       "    const hashes = {\"https://cdn.bokeh.org/bokeh/release/bokeh-2.2.1.min.js\": \"qkRvDQVAIfzsJo40iRBbxt6sttt0hv4lh74DG7OK4MCHv4C5oohXYoHUM5W11uqS\", \"https://cdn.bokeh.org/bokeh/release/bokeh-widgets-2.2.1.min.js\": \"Sb7Mr06a9TNlet/GEBeKaf5xH3eb6AlCzwjtU82wNPyDrnfoiVl26qnvlKjmcAd+\", \"https://cdn.bokeh.org/bokeh/release/bokeh-tables-2.2.1.min.js\": \"HaJ15vgfmcfRtB4c4YBOI4f1MUujukqInOWVqZJZZGK7Q+ivud0OKGSTn/Vm2iso\"};\n",
       "\n",
       "    for (var i = 0; i < js_urls.length; i++) {\n",
       "      var url = js_urls[i];\n",
       "      var element = document.createElement('script');\n",
       "      element.onload = on_load;\n",
       "      element.onerror = on_error;\n",
       "      element.async = false;\n",
       "      element.src = url;\n",
       "      if (url in hashes) {\n",
       "        element.crossOrigin = \"anonymous\";\n",
       "        element.integrity = \"sha384-\" + hashes[url];\n",
       "      }\n",
       "      console.debug(\"Bokeh: injecting script tag for BokehJS library: \", url);\n",
       "      document.head.appendChild(element);\n",
       "    }\n",
       "  };\n",
       "\n",
       "  function inject_raw_css(css) {\n",
       "    const element = document.createElement(\"style\");\n",
       "    element.appendChild(document.createTextNode(css));\n",
       "    document.body.appendChild(element);\n",
       "  }\n",
       "\n",
       "  \n",
       "  var js_urls = [\"https://cdn.bokeh.org/bokeh/release/bokeh-2.2.1.min.js\", \"https://cdn.bokeh.org/bokeh/release/bokeh-widgets-2.2.1.min.js\", \"https://cdn.bokeh.org/bokeh/release/bokeh-tables-2.2.1.min.js\"];\n",
       "  var css_urls = [];\n",
       "  \n",
       "\n",
       "  var inline_js = [\n",
       "    function(Bokeh) {\n",
       "      Bokeh.set_log_level(\"info\");\n",
       "    },\n",
       "    function(Bokeh) {\n",
       "    \n",
       "    \n",
       "    }\n",
       "  ];\n",
       "\n",
       "  function run_inline_js() {\n",
       "    \n",
       "    if (root.Bokeh !== undefined || force === true) {\n",
       "      \n",
       "    for (var i = 0; i < inline_js.length; i++) {\n",
       "      inline_js[i].call(root, root.Bokeh);\n",
       "    }\n",
       "    if (force === true) {\n",
       "        display_loaded();\n",
       "      }} else if (Date.now() < root._bokeh_timeout) {\n",
       "      setTimeout(run_inline_js, 100);\n",
       "    } else if (!root._bokeh_failed_load) {\n",
       "      console.log(\"Bokeh: BokehJS failed to load within specified timeout.\");\n",
       "      root._bokeh_failed_load = true;\n",
       "    } else if (force !== true) {\n",
       "      var cell = $(document.getElementById(\"1001\")).parents('.cell').data().cell;\n",
       "      cell.output_area.append_execute_result(NB_LOAD_WARNING)\n",
       "    }\n",
       "\n",
       "  }\n",
       "\n",
       "  if (root._bokeh_is_loading === 0) {\n",
       "    console.debug(\"Bokeh: BokehJS loaded, going straight to plotting\");\n",
       "    run_inline_js();\n",
       "  } else {\n",
       "    load_libs(css_urls, js_urls, function() {\n",
       "      console.debug(\"Bokeh: BokehJS plotting callback run at\", now());\n",
       "      run_inline_js();\n",
       "    });\n",
       "  }\n",
       "}(window));"
      ],
      "application/vnd.bokehjs_load.v0+json": "\n(function(root) {\n  function now() {\n    return new Date();\n  }\n\n  var force = true;\n\n  if (typeof root._bokeh_onload_callbacks === \"undefined\" || force === true) {\n    root._bokeh_onload_callbacks = [];\n    root._bokeh_is_loading = undefined;\n  }\n\n  \n\n  \n  if (typeof (root._bokeh_timeout) === \"undefined\" || force === true) {\n    root._bokeh_timeout = Date.now() + 5000;\n    root._bokeh_failed_load = false;\n  }\n\n  var NB_LOAD_WARNING = {'data': {'text/html':\n     \"<div style='background-color: #fdd'>\\n\"+\n     \"<p>\\n\"+\n     \"BokehJS does not appear to have successfully loaded. If loading BokehJS from CDN, this \\n\"+\n     \"may be due to a slow or bad network connection. Possible fixes:\\n\"+\n     \"</p>\\n\"+\n     \"<ul>\\n\"+\n     \"<li>re-rerun `output_notebook()` to attempt to load from CDN again, or</li>\\n\"+\n     \"<li>use INLINE resources instead, as so:</li>\\n\"+\n     \"</ul>\\n\"+\n     \"<code>\\n\"+\n     \"from bokeh.resources import INLINE\\n\"+\n     \"output_notebook(resources=INLINE)\\n\"+\n     \"</code>\\n\"+\n     \"</div>\"}};\n\n  function display_loaded() {\n    var el = document.getElementById(\"1001\");\n    if (el != null) {\n      el.textContent = \"BokehJS is loading...\";\n    }\n    if (root.Bokeh !== undefined) {\n      if (el != null) {\n        el.textContent = \"BokehJS \" + root.Bokeh.version + \" successfully loaded.\";\n      }\n    } else if (Date.now() < root._bokeh_timeout) {\n      setTimeout(display_loaded, 100)\n    }\n  }\n\n\n  function run_callbacks() {\n    try {\n      root._bokeh_onload_callbacks.forEach(function(callback) {\n        if (callback != null)\n          callback();\n      });\n    } finally {\n      delete root._bokeh_onload_callbacks\n    }\n    console.debug(\"Bokeh: all callbacks have finished\");\n  }\n\n  function load_libs(css_urls, js_urls, callback) {\n    if (css_urls == null) css_urls = [];\n    if (js_urls == null) js_urls = [];\n\n    root._bokeh_onload_callbacks.push(callback);\n    if (root._bokeh_is_loading > 0) {\n      console.debug(\"Bokeh: BokehJS is being loaded, scheduling callback at\", now());\n      return null;\n    }\n    if (js_urls == null || js_urls.length === 0) {\n      run_callbacks();\n      return null;\n    }\n    console.debug(\"Bokeh: BokehJS not loaded, scheduling load and callback at\", now());\n    root._bokeh_is_loading = css_urls.length + js_urls.length;\n\n    function on_load() {\n      root._bokeh_is_loading--;\n      if (root._bokeh_is_loading === 0) {\n        console.debug(\"Bokeh: all BokehJS libraries/stylesheets loaded\");\n        run_callbacks()\n      }\n    }\n\n    function on_error() {\n      console.error(\"failed to load \" + url);\n    }\n\n    for (var i = 0; i < css_urls.length; i++) {\n      var url = css_urls[i];\n      const element = document.createElement(\"link\");\n      element.onload = on_load;\n      element.onerror = on_error;\n      element.rel = \"stylesheet\";\n      element.type = \"text/css\";\n      element.href = url;\n      console.debug(\"Bokeh: injecting link tag for BokehJS stylesheet: \", url);\n      document.body.appendChild(element);\n    }\n\n    const hashes = {\"https://cdn.bokeh.org/bokeh/release/bokeh-2.2.1.min.js\": \"qkRvDQVAIfzsJo40iRBbxt6sttt0hv4lh74DG7OK4MCHv4C5oohXYoHUM5W11uqS\", \"https://cdn.bokeh.org/bokeh/release/bokeh-widgets-2.2.1.min.js\": \"Sb7Mr06a9TNlet/GEBeKaf5xH3eb6AlCzwjtU82wNPyDrnfoiVl26qnvlKjmcAd+\", \"https://cdn.bokeh.org/bokeh/release/bokeh-tables-2.2.1.min.js\": \"HaJ15vgfmcfRtB4c4YBOI4f1MUujukqInOWVqZJZZGK7Q+ivud0OKGSTn/Vm2iso\"};\n\n    for (var i = 0; i < js_urls.length; i++) {\n      var url = js_urls[i];\n      var element = document.createElement('script');\n      element.onload = on_load;\n      element.onerror = on_error;\n      element.async = false;\n      element.src = url;\n      if (url in hashes) {\n        element.crossOrigin = \"anonymous\";\n        element.integrity = \"sha384-\" + hashes[url];\n      }\n      console.debug(\"Bokeh: injecting script tag for BokehJS library: \", url);\n      document.head.appendChild(element);\n    }\n  };\n\n  function inject_raw_css(css) {\n    const element = document.createElement(\"style\");\n    element.appendChild(document.createTextNode(css));\n    document.body.appendChild(element);\n  }\n\n  \n  var js_urls = [\"https://cdn.bokeh.org/bokeh/release/bokeh-2.2.1.min.js\", \"https://cdn.bokeh.org/bokeh/release/bokeh-widgets-2.2.1.min.js\", \"https://cdn.bokeh.org/bokeh/release/bokeh-tables-2.2.1.min.js\"];\n  var css_urls = [];\n  \n\n  var inline_js = [\n    function(Bokeh) {\n      Bokeh.set_log_level(\"info\");\n    },\n    function(Bokeh) {\n    \n    \n    }\n  ];\n\n  function run_inline_js() {\n    \n    if (root.Bokeh !== undefined || force === true) {\n      \n    for (var i = 0; i < inline_js.length; i++) {\n      inline_js[i].call(root, root.Bokeh);\n    }\n    if (force === true) {\n        display_loaded();\n      }} else if (Date.now() < root._bokeh_timeout) {\n      setTimeout(run_inline_js, 100);\n    } else if (!root._bokeh_failed_load) {\n      console.log(\"Bokeh: BokehJS failed to load within specified timeout.\");\n      root._bokeh_failed_load = true;\n    } else if (force !== true) {\n      var cell = $(document.getElementById(\"1001\")).parents('.cell').data().cell;\n      cell.output_area.append_execute_result(NB_LOAD_WARNING)\n    }\n\n  }\n\n  if (root._bokeh_is_loading === 0) {\n    console.debug(\"Bokeh: BokehJS loaded, going straight to plotting\");\n    run_inline_js();\n  } else {\n    load_libs(css_urls, js_urls, function() {\n      console.debug(\"Bokeh: BokehJS plotting callback run at\", now());\n      run_inline_js();\n    });\n  }\n}(window));"
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# LOGIN\n",
    "import login\n",
    "from login import *\n",
    "import pandas as pd\n",
    "pd.set_option('plotting.backend', 'pandas_bokeh')\n",
    "import pandas_bokeh\n",
    "pandas_bokeh.output_notebook()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#kite.orders()[-1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#kite.positions()['net']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#kite.holdings()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#kite.margins(segment = 'equity')['available']['live_balance']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Today Date : 2020-10-10\n",
      "Yestreday Date : 2020-10-09\n",
      "last close : 73.245\n",
      "last high : 73.74\n",
      "last low : 73.1225\n",
      "HL Range : 0.6175\n",
      "My Margin : 85080.71\n",
      "Pivot Price : 73.245\n",
      "Full Quantity : 4254\n",
      "Number of Steps : 157\n",
      "Price Difference Between One Trade : 0.005\n",
      "Quantity Difference Between One Trade : 27\n",
      "Last Buy Pivot Price : 72.46\n",
      "Last Sell Pivot Price : 74.03\n",
      "Stoploss On ? : False\n",
      "Moving Pivot On ? : True\n",
      "\n",
      "pivot_price : 73.245\n",
      "\n",
      "p1b : 73.225\n",
      "p2b : 73.22\n",
      "p3b : 73.215\n",
      "p4b : 73.21\n",
      "p5b : 73.205\n",
      "p6b : 73.2\n",
      "p7b : 73.195\n",
      "p8b : 73.19\n",
      "p9b : 73.185\n",
      "p10b : 73.18\n",
      "p11b : 73.175\n",
      "p12b : 73.17\n",
      "p13b : 73.165\n",
      "p14b : 73.16\n",
      "p15b : 73.155\n",
      "p16b : 73.15\n",
      "p17b : 73.145\n",
      "p18b : 73.14\n",
      "p19b : 73.135\n",
      "p20b : 73.13\n",
      "p21b : 73.125\n",
      "p22b : 73.12\n",
      "p23b : 73.115\n",
      "p24b : 73.11\n",
      "p25b : 73.105\n",
      "p26b : 73.1\n",
      "p27b : 73.095\n",
      "p28b : 73.09\n",
      "p29b : 73.085\n",
      "p30b : 73.08\n",
      "p31b : 73.075\n",
      "p32b : 73.07\n",
      "p33b : 73.065\n",
      "p34b : 73.06\n",
      "p35b : 73.055\n",
      "p36b : 73.05\n",
      "p37b : 73.045\n",
      "p38b : 73.04\n",
      "p39b : 73.035\n",
      "p40b : 73.03\n",
      "p41b : 73.025\n",
      "p42b : 73.02\n",
      "p43b : 73.015\n",
      "p44b : 73.01\n",
      "p45b : 73.005\n",
      "p46b : 73.0\n",
      "p47b : 72.995\n",
      "p48b : 72.99\n",
      "p49b : 72.985\n",
      "p50b : 72.98\n",
      "p51b : 72.975\n",
      "p52b : 72.97\n",
      "p53b : 72.965\n",
      "p54b : 72.96\n",
      "p55b : 72.955\n",
      "p56b : 72.95\n",
      "p57b : 72.945\n",
      "p58b : 72.94\n",
      "p59b : 72.935\n",
      "p60b : 72.93\n",
      "p61b : 72.925\n",
      "p62b : 72.92\n",
      "p63b : 72.915\n",
      "p64b : 72.91\n",
      "p65b : 72.905\n",
      "p66b : 72.9\n",
      "p67b : 72.895\n",
      "p68b : 72.89\n",
      "p69b : 72.885\n",
      "p70b : 72.88\n",
      "p71b : 72.875\n",
      "p72b : 72.87\n",
      "p73b : 72.865\n",
      "p74b : 72.86\n",
      "p75b : 72.855\n",
      "p76b : 72.85\n",
      "p77b : 72.845\n",
      "p78b : 72.84\n",
      "p79b : 72.835\n",
      "p80b : 72.83\n",
      "p81b : 72.825\n",
      "p82b : 72.82\n",
      "p83b : 72.815\n",
      "p84b : 72.81\n",
      "p85b : 72.805\n",
      "p86b : 72.8\n",
      "p87b : 72.795\n",
      "p88b : 72.79\n",
      "p89b : 72.785\n",
      "p90b : 72.78\n",
      "p91b : 72.775\n",
      "p92b : 72.77\n",
      "p93b : 72.765\n",
      "p94b : 72.76\n",
      "p95b : 72.755\n",
      "p96b : 72.75\n",
      "p97b : 72.745\n",
      "p98b : 72.74\n",
      "p99b : 72.735\n",
      "p100b : 72.73\n",
      "p101b : 72.725\n",
      "p102b : 72.72\n",
      "p103b : 72.715\n",
      "p104b : 72.71\n",
      "p105b : 72.705\n",
      "p106b : 72.7\n",
      "p107b : 72.695\n",
      "p108b : 72.69\n",
      "p109b : 72.685\n",
      "p110b : 72.68\n",
      "p111b : 72.675\n",
      "p112b : 72.67\n",
      "p113b : 72.665\n",
      "p114b : 72.66\n",
      "p115b : 72.655\n",
      "p116b : 72.65\n",
      "p117b : 72.645\n",
      "p118b : 72.64\n",
      "p119b : 72.635\n",
      "p120b : 72.63\n",
      "p121b : 72.625\n",
      "p122b : 72.62\n",
      "p123b : 72.615\n",
      "p124b : 72.61\n",
      "p125b : 72.605\n",
      "p126b : 72.6\n",
      "p127b : 72.595\n",
      "p128b : 72.59\n",
      "p129b : 72.585\n",
      "p130b : 72.58\n",
      "p131b : 72.575\n",
      "p132b : 72.57\n",
      "p133b : 72.565\n",
      "p134b : 72.56\n",
      "p135b : 72.555\n",
      "p136b : 72.55\n",
      "p137b : 72.545\n",
      "p138b : 72.54\n",
      "p139b : 72.535\n",
      "p140b : 72.53\n",
      "p141b : 72.525\n",
      "p142b : 72.52\n",
      "p143b : 72.515\n",
      "p144b : 72.51\n",
      "p145b : 72.505\n",
      "p146b : 72.5\n",
      "p147b : 72.495\n",
      "p148b : 72.49\n",
      "p149b : 72.485\n",
      "p150b : 72.48\n",
      "p151b : 72.475\n",
      "p152b : 72.47\n",
      "p153b : 72.465\n",
      "p154b : 72.46\n",
      "p155b : 72.455\n",
      "p156b : 72.45\n",
      "p157b : 72.445\n",
      "\n",
      "p1s : 73.265\n",
      "p2s : 73.27\n",
      "p3s : 73.275\n",
      "p4s : 73.28\n",
      "p5s : 73.285\n",
      "p6s : 73.29\n",
      "p7s : 73.295\n",
      "p8s : 73.3\n",
      "p9s : 73.305\n",
      "p10s : 73.31\n",
      "p11s : 73.315\n",
      "p12s : 73.32\n",
      "p13s : 73.325\n",
      "p14s : 73.33\n",
      "p15s : 73.335\n",
      "p16s : 73.34\n",
      "p17s : 73.345\n",
      "p18s : 73.35\n",
      "p19s : 73.355\n",
      "p20s : 73.36\n",
      "p21s : 73.365\n",
      "p22s : 73.37\n",
      "p23s : 73.375\n",
      "p24s : 73.38\n",
      "p25s : 73.385\n",
      "p26s : 73.39\n",
      "p27s : 73.395\n",
      "p28s : 73.4\n",
      "p29s : 73.405\n",
      "p30s : 73.41\n",
      "p31s : 73.415\n",
      "p32s : 73.42\n",
      "p33s : 73.425\n",
      "p34s : 73.43\n",
      "p35s : 73.435\n",
      "p36s : 73.44\n",
      "p37s : 73.445\n",
      "p38s : 73.45\n",
      "p39s : 73.455\n",
      "p40s : 73.46\n",
      "p41s : 73.465\n",
      "p42s : 73.47\n",
      "p43s : 73.475\n",
      "p44s : 73.48\n",
      "p45s : 73.485\n",
      "p46s : 73.49\n",
      "p47s : 73.495\n",
      "p48s : 73.5\n",
      "p49s : 73.505\n",
      "p50s : 73.51\n",
      "p51s : 73.515\n",
      "p52s : 73.52\n",
      "p53s : 73.525\n",
      "p54s : 73.53\n",
      "p55s : 73.535\n",
      "p56s : 73.54\n",
      "p57s : 73.545\n",
      "p58s : 73.55\n",
      "p59s : 73.555\n",
      "p60s : 73.56\n",
      "p61s : 73.565\n",
      "p62s : 73.57\n",
      "p63s : 73.575\n",
      "p64s : 73.58\n",
      "p65s : 73.585\n",
      "p66s : 73.59\n",
      "p67s : 73.595\n",
      "p68s : 73.6\n",
      "p69s : 73.605\n",
      "p70s : 73.61\n",
      "p71s : 73.615\n",
      "p72s : 73.62\n",
      "p73s : 73.625\n",
      "p74s : 73.63\n",
      "p75s : 73.635\n",
      "p76s : 73.64\n",
      "p77s : 73.645\n",
      "p78s : 73.65\n",
      "p79s : 73.655\n",
      "p80s : 73.66\n",
      "p81s : 73.665\n",
      "p82s : 73.67\n",
      "p83s : 73.675\n",
      "p84s : 73.68\n",
      "p85s : 73.685\n",
      "p86s : 73.69\n",
      "p87s : 73.695\n",
      "p88s : 73.7\n",
      "p89s : 73.705\n",
      "p90s : 73.71\n",
      "p91s : 73.715\n",
      "p92s : 73.72\n",
      "p93s : 73.725\n",
      "p94s : 73.73\n",
      "p95s : 73.735\n",
      "p96s : 73.74\n",
      "p97s : 73.745\n",
      "p98s : 73.75\n",
      "p99s : 73.755\n",
      "p100s : 73.76\n",
      "p101s : 73.765\n",
      "p102s : 73.77\n",
      "p103s : 73.775\n",
      "p104s : 73.78\n",
      "p105s : 73.785\n",
      "p106s : 73.79\n",
      "p107s : 73.795\n",
      "p108s : 73.8\n",
      "p109s : 73.805\n",
      "p110s : 73.81\n",
      "p111s : 73.815\n",
      "p112s : 73.82\n",
      "p113s : 73.825\n",
      "p114s : 73.83\n",
      "p115s : 73.835\n",
      "p116s : 73.84\n",
      "p117s : 73.845\n",
      "p118s : 73.85\n",
      "p119s : 73.855\n",
      "p120s : 73.86\n",
      "p121s : 73.865\n",
      "p122s : 73.87\n",
      "p123s : 73.875\n",
      "p124s : 73.88\n",
      "p125s : 73.885\n",
      "p126s : 73.89\n",
      "p127s : 73.895\n",
      "p128s : 73.9\n",
      "p129s : 73.905\n",
      "p130s : 73.91\n",
      "p131s : 73.915\n",
      "p132s : 73.92\n",
      "p133s : 73.925\n",
      "p134s : 73.93\n",
      "p135s : 73.935\n",
      "p136s : 73.94\n",
      "p137s : 73.945\n",
      "p138s : 73.95\n",
      "p139s : 73.955\n",
      "p140s : 73.96\n",
      "p141s : 73.965\n",
      "p142s : 73.97\n",
      "p143s : 73.975\n",
      "p144s : 73.98\n",
      "p145s : 73.985\n",
      "p146s : 73.99\n",
      "p147s : 73.995\n",
      "p148s : 74.0\n",
      "p149s : 74.005\n",
      "p150s : 74.01\n",
      "p151s : 74.015\n",
      "p152s : 74.02\n",
      "p153s : 74.025\n",
      "p154s : 74.03\n",
      "p155s : 74.035\n",
      "p156s : 74.04\n",
      "p157s : 74.045\n",
      "\n",
      "p1q : 27\n",
      "p2q : 54\n",
      "p3q : 81\n",
      "p4q : 108\n",
      "p5q : 135\n",
      "p6q : 162\n",
      "p7q : 189\n",
      "p8q : 216\n",
      "p9q : 243\n",
      "p10q : 270\n",
      "p11q : 297\n",
      "p12q : 324\n",
      "p13q : 351\n",
      "p14q : 378\n",
      "p15q : 405\n",
      "p16q : 432\n",
      "p17q : 459\n",
      "p18q : 486\n",
      "p19q : 513\n",
      "p20q : 540\n",
      "p21q : 567\n",
      "p22q : 594\n",
      "p23q : 621\n",
      "p24q : 648\n",
      "p25q : 675\n",
      "p26q : 702\n",
      "p27q : 729\n",
      "p28q : 756\n",
      "p29q : 783\n",
      "p30q : 810\n",
      "p31q : 837\n",
      "p32q : 864\n",
      "p33q : 891\n",
      "p34q : 918\n",
      "p35q : 945\n",
      "p36q : 972\n",
      "p37q : 999\n",
      "p38q : 1026\n",
      "p39q : 1053\n",
      "p40q : 1080\n",
      "p41q : 1107\n",
      "p42q : 1134\n",
      "p43q : 1161\n",
      "p44q : 1188\n",
      "p45q : 1215\n",
      "p46q : 1242\n",
      "p47q : 1269\n",
      "p48q : 1296\n",
      "p49q : 1323\n",
      "p50q : 1350\n",
      "p51q : 1377\n",
      "p52q : 1404\n",
      "p53q : 1431\n",
      "p54q : 1458\n",
      "p55q : 1485\n",
      "p56q : 1512\n",
      "p57q : 1539\n",
      "p58q : 1566\n",
      "p59q : 1593\n",
      "p60q : 1620\n",
      "p61q : 1647\n",
      "p62q : 1674\n",
      "p63q : 1701\n",
      "p64q : 1728\n",
      "p65q : 1755\n",
      "p66q : 1782\n",
      "p67q : 1809\n",
      "p68q : 1836\n",
      "p69q : 1863\n",
      "p70q : 1890\n",
      "p71q : 1917\n",
      "p72q : 1944\n",
      "p73q : 1971\n",
      "p74q : 1998\n",
      "p75q : 2025\n",
      "p76q : 2052\n",
      "p77q : 2079\n",
      "p78q : 2106\n",
      "p79q : 2133\n",
      "p80q : 2160\n",
      "p81q : 2187\n",
      "p82q : 2214\n",
      "p83q : 2241\n",
      "p84q : 2268\n",
      "p85q : 2295\n",
      "p86q : 2322\n",
      "p87q : 2349\n",
      "p88q : 2376\n",
      "p89q : 2403\n",
      "p90q : 2430\n",
      "p91q : 2457\n",
      "p92q : 2484\n",
      "p93q : 2511\n",
      "p94q : 2538\n",
      "p95q : 2565\n",
      "p96q : 2592\n",
      "p97q : 2619\n",
      "p98q : 2646\n",
      "p99q : 2673\n",
      "p100q : 2700\n",
      "p101q : 2727\n",
      "p102q : 2754\n",
      "p103q : 2781\n",
      "p104q : 2808\n",
      "p105q : 2835\n",
      "p106q : 2862\n",
      "p107q : 2889\n",
      "p108q : 2916\n",
      "p109q : 2943\n",
      "p110q : 2970\n",
      "p111q : 2997\n",
      "p112q : 3024\n",
      "p113q : 3051\n",
      "p114q : 3078\n",
      "p115q : 3105\n",
      "p116q : 3132\n",
      "p117q : 3159\n",
      "p118q : 3186\n",
      "p119q : 3213\n",
      "p120q : 3240\n",
      "p121q : 3267\n",
      "p122q : 3294\n",
      "p123q : 3321\n",
      "p124q : 3348\n",
      "p125q : 3375\n",
      "p126q : 3402\n",
      "p127q : 3429\n",
      "p128q : 3456\n",
      "p129q : 3483\n",
      "p130q : 3510\n",
      "p131q : 3537\n",
      "p132q : 3564\n",
      "p133q : 3591\n",
      "p134q : 3618\n",
      "p135q : 3645\n",
      "p136q : 3672\n",
      "p137q : 3699\n",
      "p138q : 3726\n",
      "p139q : 3753\n",
      "p140q : 3780\n",
      "p141q : 3807\n",
      "p142q : 3834\n",
      "p143q : 3861\n",
      "p144q : 3888\n",
      "p145q : 3915\n",
      "p146q : 3942\n",
      "p147q : 3969\n",
      "p148q : 3996\n",
      "p149q : 4023\n",
      "p150q : 4050\n",
      "p151q : 4077\n",
      "p152q : 4104\n",
      "p153q : 4131\n",
      "p154q : 4158\n",
      "p155q : 4185\n",
      "p156q : 4212\n",
      "p157q : 4239\n",
      "\n",
      "S Limit : 74.1907\n",
      "B Limit : 72.2993\n"
     ]
    }
   ],
   "source": [
    "# NORMAL RUN-1\n",
    "#####################\n",
    "one_dollar_margin = 20.0\n",
    "per_order_quant = 27\n",
    "initial_difference = 0.0150\n",
    "order_type = 'MIS' # MIS / NRML # NOT WORKING CURRENTLY\n",
    "symbol_ip = 'USDINR20OCTFUT'\n",
    "stoploss_on = False # True / False\n",
    "inst_token = 690691 # 690691(USD) / 690435(JPY) / 000000(EUR) / 000000(GBP)\n",
    "moving_pivot_on = True # True / False\n",
    "#####################\n",
    "\n",
    "import datetime\n",
    "interval='day'\n",
    "todaydt=datetime.date.today()\n",
    "hud_ago=todaydt-datetime.timedelta(days=10)\n",
    "to_date=datetime.date.isoformat(todaydt)\n",
    "\n",
    "from_date=datetime.date.isoformat(hud_ago)\n",
    "data = kite.historical_data(inst_token, from_date, to_date, interval, continuous=False)\n",
    "\n",
    "import pandas as pd\n",
    "mydata = pd.DataFrame(data)\n",
    "\n",
    "last_close = 123.0\n",
    "last_high = 123.0\n",
    "last_low = 123.0\n",
    "hl_range = 123.0\n",
    "\n",
    "from datetime import date\n",
    "\n",
    "today = date.today()\n",
    "\n",
    "print('Today Date : '+str(today))\n",
    "\n",
    "\n",
    "for i in range(len(mydata['date'])):\n",
    "    if(mydata['date'][i].date()==today-datetime.timedelta(days=1)):\n",
    "        print('Yestreday Date : '+str(mydata['date'][i].date()))\n",
    "        last_close = mydata['close'][i]\n",
    "        last_high = mydata['high'][i]\n",
    "        last_low = mydata['low'][i]\n",
    "        hl_range = last_high - last_low\n",
    "        \n",
    "print('last close : '+ str(last_close))\n",
    "print('last high : '+ str(last_high))\n",
    "print('last low : '+ str(last_low))\n",
    "print('HL Range : '+ str(round(hl_range,4)))\n",
    "\n",
    "mymargin = round(kite.margins(segment = 'equity')['available']['live_balance'],4)\n",
    "#mymargin = 185777.23\n",
    "\n",
    "pivot_price = last_close\n",
    "\n",
    "fullquantity = int(mymargin / one_dollar_margin)\n",
    "\n",
    "num_of_steps = int(fullquantity / per_order_quant)\n",
    "\n",
    "difference = round(hl_range / num_of_steps,4)\n",
    "\n",
    "difference = round(0.0025 * round(difference /0.0025),4)\n",
    "\n",
    "last_buy_price = round(pivot_price -  difference*num_of_steps,4)\n",
    "last_sell_price = round(pivot_price +  difference*num_of_steps,4)\n",
    "\n",
    "print('My Margin : '+str(mymargin))\n",
    "print('Pivot Price : ' + str(pivot_price))\n",
    "print('Full Quantity : '+str(fullquantity))\n",
    "print('Number of Steps : '+str(num_of_steps))\n",
    "print('Price Difference Between One Trade : ' + str(difference))\n",
    "print('Quantity Difference Between One Trade : ' + str(per_order_quant))\n",
    "print('Last Buy Pivot Price : '+str(last_buy_price))\n",
    "print('Last Sell Pivot Price : '+str(last_sell_price))\n",
    "print('Stoploss On ? : '+str(stoploss_on))\n",
    "print('Moving Pivot On ? : '+str(moving_pivot_on))\n",
    "base=0.0025\n",
    "max_no_of_order = int(fullquantity / per_order_quant)\n",
    "total_parts = 2*max_no_of_order\n",
    "\n",
    "print()\n",
    "print('pivot_price : '+str(pivot_price))\n",
    "print()\n",
    "upper_limit = 0.12\n",
    "lower_limit = 0.12\n",
    "def calc_pivots():\n",
    "    global upper_limit, lower_limit\n",
    "    for i in range(1,max_no_of_order+1):\n",
    "        globals()['p'+str(i)+'b'] = pivot_price - (initial_difference + i* difference)\n",
    "        globals()['p'+str(i)+'b'] = round(base * round(globals()['p'+str(i)+'b'] /base),4)\n",
    "        print('p'+str(i)+'b : '+str(globals()['p'+str(i)+'b']))\n",
    "\n",
    "    print()\n",
    "    for i in range(1,max_no_of_order+1):\n",
    "        globals()['p'+str(i)+'s'] = pivot_price + (initial_difference + i* difference)\n",
    "        globals()['p'+str(i)+'s'] = round(base * round(globals()['p'+str(i)+'s'] /base),4)\n",
    "        print('p'+str(i)+'s : '+str(globals()['p'+str(i)+'s']))\n",
    "\n",
    "    print()\n",
    "    for i in range(1,max_no_of_order+1):\n",
    "        globals()['p'+str(i)+'q'] = per_order_quant*i\n",
    "        print('p'+str(i)+'q : '+str(globals()['p'+str(i)+'q']))\n",
    "        \n",
    "    print()\n",
    "    upper_limit = round(((globals()['p'+str(max_no_of_order)+'s']) + hl_range*0.236),4)\n",
    "    lower_limit = round(((globals()['p'+str(max_no_of_order)+'b']) - hl_range*0.236),4)\n",
    "    print('S Limit : '+str(upper_limit))\n",
    "    print('B Limit : '+str(lower_limit))\n",
    "\n",
    "calc_pivots()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# NORMAL RUN-2\n",
    "myquantity = 0\n",
    "def getquant():\n",
    "    global myquantity\n",
    "    global order_type\n",
    "    global symbol_ip\n",
    "    allpos = kite.positions()['net']\n",
    "    for i in range(len(allpos)):\n",
    "        if(allpos[i]['tradingsymbol']==symbol_ip and  allpos[i]['product']== order_type):\n",
    "            myquantity = allpos[i]['quantity']\n",
    "            print('My Quantity : ' + str(allpos[i]['quantity']))\n",
    "\n",
    "getquant()\n",
    "\n",
    "stopbuy = False\n",
    "stopsell = False\n",
    "\n",
    "def placeneworder(quantdiff):\n",
    "    global stopbuy\n",
    "    global stopsell\n",
    "    global order_type\n",
    "    global symbol_ip\n",
    "    if(quantdiff>0 and stopbuy == False):\n",
    "        try:\n",
    "                order_id= kite.place_order(tradingsymbol=symbol_ip,\n",
    "                            exchange=kite.EXCHANGE_CDS,\n",
    "                            transaction_type=kite.TRANSACTION_TYPE_BUY,\n",
    "                            quantity=abs(quantdiff),\n",
    "                            order_type=kite.ORDER_TYPE_MARKET,\n",
    "                            variety = kite.VARIETY_REGULAR,\n",
    "                            product=kite.PRODUCT_MIS if order_type=='MIS' else kite.PRODUCT_NRML)\n",
    "                getquant()\n",
    "                stopsell = False\n",
    "        except Exception as e:\n",
    "            stopbuy = False\n",
    "            print(e)\n",
    "            getquant()\n",
    "    if(quantdiff<0 and stopsell == False):\n",
    "        try:\n",
    "                order_id= kite.place_order(tradingsymbol=symbol_ip,\n",
    "                            exchange=kite.EXCHANGE_CDS,\n",
    "                            transaction_type=kite.TRANSACTION_TYPE_SELL,\n",
    "                            quantity=abs(quantdiff),\n",
    "                            order_type=kite.ORDER_TYPE_MARKET,\n",
    "                            variety = kite.VARIETY_REGULAR,\n",
    "                            product=kite.PRODUCT_MIS if order_type=='MIS' else kite.PRODUCT_NRML)\n",
    "                getquant()\n",
    "                stopbuy = False\n",
    "        except Exception as e:\n",
    "            stopsell = True\n",
    "            print(e)\n",
    "            getquant()\n",
    "\n",
    "\n",
    "def ckqnt (orderprice,orderquant):\n",
    "    global myquantity\n",
    "    quantdiff = orderquant - myquantity\n",
    "    placeneworder(quantdiff)\n",
    "    return myquantity\n",
    "\n",
    "\n",
    "last_price = pivot_price\n",
    "\n",
    "def checkpivot(ltps):\n",
    "    global last_price, upper_limit, lower_limit\n",
    "    trade_quant = 0\n",
    "    \n",
    "    if((ltps > upper_limit or ltps < lower_limit) and stoploss_on ):\n",
    "        ckqnt(pivot_price,0)\n",
    "    \n",
    "    elif ((ltps>=(pivot_price-0.0025)) and (ltps<=(pivot_price+0.0025))):\n",
    "        ckqnt(pivot_price,0)\n",
    "        print('in pivot range')\n",
    "        \n",
    "    elif(upper_limit>ltps>(globals()['p'+str(max_no_of_order)+'s'])):\n",
    "        ckqnt(globals()['p'+str(max_no_of_order)+'s'],-globals()['p'+str(max_no_of_order)+'q'])\n",
    "        \n",
    "    elif(lower_limit<ltps<(globals()['p'+str(max_no_of_order)+'b'])):\n",
    "        ckqnt(globals()['p'+str(max_no_of_order)+'b'],globals()['p'+str(max_no_of_order)+'q'])\n",
    "        \n",
    "    else:\n",
    "        for i in range(1,int(total_parts/2)+1):\n",
    "\n",
    "            if(ltps<pivot_price):\n",
    "                trade_quant = globals()['p'+str(i)+'q']\n",
    "            elif(ltps>pivot_price):\n",
    "                trade_quant = -globals()['p'+str(i)+'q']\n",
    "\n",
    "            if ((ltps == globals()['p'+str(i)+'b'] or ltps == globals()['p'+str(i)+'s']) and ltps < last_price):\n",
    "                ckqnt(globals()['p'+str(i)+'b'],trade_quant)\n",
    "                print('==========' +'p'+str(i)+'b @ ' +str(ltps) + '==============' )\n",
    "                last_price=ltps\n",
    "\n",
    "            if ((ltps == globals()['p'+str(i)+'b'] or ltps == globals()['p'+str(i)+'s']) and ltps > last_price):\n",
    "                ckqnt(globals()['p'+str(i)+'s'],trade_quant)\n",
    "                print('==========' +'p'+str(i)+'s @ ' +str(ltps) + '==============' )\n",
    "                last_price=ltps"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "p1b : 73.2175\n",
      "p2b : 73.185\n",
      "p3b : 73.1525\n",
      "p4b : 73.12\n",
      "p5b : 73.0875\n",
      "p6b : 73.055\n",
      "p7b : 73.0225\n",
      "\n",
      "p1s : 73.2825\n",
      "p2s : 73.315\n",
      "p3s : 73.3475\n",
      "p4s : 73.38\n",
      "p5s : 73.4125\n",
      "p6s : 73.445\n",
      "p7s : 73.4775\n",
      "\n",
      "p1q : 6\n",
      "p2q : 12\n",
      "p3q : 18\n",
      "p4q : 24\n",
      "p5q : 30\n",
      "p6q : 36\n",
      "p7q : 42\n",
      "\n",
      "S Limit : 73.5312\n",
      "B Limit : 72.9688\n",
      "==========================\n",
      "LTP : 73.25\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "ERROR:kiteconnect.ticker:Connection error: 1006 - connection was closed uncleanly (peer dropped the TCP connection without previous WebSocket closing handshake)\n",
      "ERROR:root:closed connection on error: 1006 connection was closed uncleanly (peer dropped the TCP connection without previous WebSocket closing handshake)\n",
      "ERROR:kiteconnect.ticker:Connection closed: 1006 - connection was closed uncleanly (peer dropped the TCP connection without previous WebSocket closing handshake)\n",
      "Unhandled Error\n",
      "Traceback (most recent call last):\n",
      "  File \"/home/hemang/.local/lib/python3.8/site-packages/twisted/internet/defer.py\", line 311, in addCallbacks\n",
      "    self._runCallbacks()\n",
      "  File \"/home/hemang/.local/lib/python3.8/site-packages/twisted/internet/defer.py\", line 654, in _runCallbacks\n",
      "    current.result = callback(current.result, *args, **kw)\n",
      "  File \"/home/hemang/.local/lib/python3.8/site-packages/twisted/internet/base.py\", line 447, in _continueFiring\n",
      "    callable(*args, **kwargs)\n",
      "  File \"/home/hemang/.local/lib/python3.8/site-packages/twisted/internet/base.py\", line 704, in disconnectAll\n",
      "    log.callWithLogger(reader,\n",
      "--- <exception caught here> ---\n",
      "  File \"/home/hemang/.local/lib/python3.8/site-packages/twisted/python/log.py\", line 103, in callWithLogger\n",
      "    return callWithContext({\"system\": lp}, func, *args, **kw)\n",
      "  File \"/home/hemang/.local/lib/python3.8/site-packages/twisted/python/log.py\", line 86, in callWithContext\n",
      "    return context.call({ILogContext: newCtx}, func, *args, **kw)\n",
      "  File \"/home/hemang/.local/lib/python3.8/site-packages/twisted/python/context.py\", line 122, in callWithContext\n",
      "    return self.currentContext().callWithContext(ctx, func, *args, **kw)\n",
      "  File \"/home/hemang/.local/lib/python3.8/site-packages/twisted/python/context.py\", line 85, in callWithContext\n",
      "    return func(*args,**kw)\n",
      "  File \"/home/hemang/.local/lib/python3.8/site-packages/twisted/internet/tcp.py\", line 519, in connectionLost\n",
      "    self._commonConnection.connectionLost(self, reason)\n",
      "  File \"/home/hemang/.local/lib/python3.8/site-packages/twisted/internet/tcp.py\", line 327, in connectionLost\n",
      "    protocol.connectionLost(reason)\n",
      "  File \"/home/hemang/.local/lib/python3.8/site-packages/twisted/protocols/tls.py\", line 403, in connectionLost\n",
      "    ProtocolWrapper.connectionLost(self, reason)\n",
      "  File \"/home/hemang/.local/lib/python3.8/site-packages/twisted/protocols/policies.py\", line 125, in connectionLost\n",
      "    self.wrappedProtocol.connectionLost(reason)\n",
      "  File \"/home/hemang/.local/lib/python3.8/site-packages/autobahn/twisted/websocket.py\", line 287, in connectionLost\n",
      "    self._connectionLost(reason)\n",
      "  File \"/home/hemang/.local/lib/python3.8/site-packages/autobahn/websocket/protocol.py\", line 3412, in _connectionLost\n",
      "    WebSocketProtocol._connectionLost(self, reason)\n",
      "  File \"/home/hemang/.local/lib/python3.8/site-packages/autobahn/websocket/protocol.py\", line 1126, in _connectionLost\n",
      "    self._onClose(self.wasClean, WebSocketProtocol.CLOSE_STATUS_CODE_ABNORMAL_CLOSE, \"connection was closed uncleanly (%s)\" % self.wasNotCleanReason)\n",
      "  File \"/home/hemang/.local/lib/python3.8/site-packages/autobahn/twisted/websocket.py\", line 330, in _onClose\n",
      "    self.onClose(wasClean, code, reason)\n",
      "  File \"/home/hemang/.local/lib/python3.8/site-packages/kiteconnect/ticker.py\", line 81, in onClose\n",
      "    self.factory.on_close(self, code, reason)\n",
      "  File \"/home/hemang/.local/lib/python3.8/site-packages/kiteconnect/ticker.py\", line 654, in _on_close\n",
      "    self.on_close(self, code, reason)\n",
      "  File \"<ipython-input-4-1b2e280ca94b>\", line 31, in on_close\n",
      "    ws.stop()\n",
      "  File \"/home/hemang/.local/lib/python3.8/site-packages/kiteconnect/ticker.py\", line 555, in stop\n",
      "    reactor.stop()\n",
      "  File \"/home/hemang/.local/lib/python3.8/site-packages/twisted/internet/base.py\", line 646, in stop\n",
      "    raise error.ReactorNotRunning(\n",
      "twisted.internet.error.ReactorNotRunning: Can't stop reactor that isn't running.\n",
      "\n"
     ]
    }
   ],
   "source": [
    "# NORMAL RUN-3\n",
    "#!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!\n",
    "#              START TRADING             !\n",
    "#!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!\n",
    "\n",
    "import logging\n",
    "from kiteconnect import KiteTicker\n",
    "logging.basicConfig(level=logging.DEBUG)\n",
    "# kws = KiteTicker(\"w19o0chuo929jxkp\", \"eA5B5OJQNOtZ0OYihkBmYw7Ke3B9pmCC\")\n",
    "\n",
    "def on_ticks(ws, ticks):\n",
    "    global pivot_price, moving_pivot_on\n",
    "    checkpivot(ticks[0]['last_price'])\n",
    "\n",
    "    if(moving_pivot_on):\n",
    "        pivot_price =round(base * round(ticks[0]['average_price']/base),4) # Moving Trade Average Line : 1\n",
    "        calc_pivots();                                                     # Moving Trade Average Line : 2\n",
    "        \n",
    "    #print(hjhj)\n",
    "    #print('===========================')\n",
    "    #print()\n",
    "    #print(type(ticks[0]['last_price']))\n",
    "    print('==========================')\n",
    "    print( 'LTP : ' + str(ticks[0]['last_price']))\n",
    "    #print('==========================')\n",
    "    #print()\n",
    "\n",
    "def on_connect(ws, response):\n",
    "    global inst_token\n",
    "    ws.subscribe([inst_token])\n",
    "    ws.set_mode(ws.MODE_FULL, [inst_token])\n",
    "\n",
    "def on_close(ws, code, reason):\n",
    "    ws.stop()\n",
    "    \n",
    "def on_error(ws, code, reason):\n",
    "    logging.error(\"closed connection on error: {} {}\".format(code, reason))\n",
    "\n",
    "def on_noreconnect(ws):\n",
    "    logging.error(\"Reconnecting the websocket failed\")\n",
    "\n",
    "def on_reconnect(ws, attempt_count):\n",
    "    logging.debug(\"Reconnecting the websocket: {}\".format(attempt_count))\n",
    "\n",
    "#def on_order_update(ws, data):\n",
    "#    print(\"order update: \", data)\n",
    "\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",
    "\n",
    "kws.on_ticks = on_ticks\n",
    "kws.on_connect = on_connect\n",
    "kws.on_close = on_close\n",
    "\n",
    "kws.connect()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "order_id= kite.place_order(tradingsymbol=\"JPYINR20OCTFUT\",\n",
    "                        exchange=kite.EXCHANGE_CDS,\n",
    "                        transaction_type=kite.TRANSACTION_TYPE_BUY,\n",
    "                        quantity=50,\n",
    "                        order_type=kite.ORDER_TYPE_MARKET,\n",
    "                        variety = kite.VARIETY_AMO,\n",
    "                        product=kite.PRODUCT_NRML)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "9\n",
      "18\n",
      "27\n",
      "36\n",
      "45\n",
      "52\n",
      "52\n",
      "56\n",
      "58\n",
      "66\n",
      "66\n",
      "66\n",
      "66\n",
      "66\n",
      "66\n",
      "66\n",
      "66\n",
      "66\n",
      "66\n",
      "66\n"
     ]
    }
   ],
   "source": [
    "import datetime\n",
    "old_lst=[]\n",
    "interval='week'\n",
    "todaydt=datetime.date.today()\n",
    "hud_ago=todaydt-datetime.timedelta(days=59)\n",
    "to_date=datetime.date.isoformat(todaydt)\n",
    "from_date=datetime.date.isoformat(hud_ago)\n",
    "\n",
    "for i2 in range(20):\n",
    "    new_lst = kite.historical_data(inst_token, from_date, to_date, interval,continuous=False)\n",
    "    old_lst = new_lst + old_lst\n",
    "    todaydt=todaydt-datetime.timedelta(days=60)\n",
    "    hud_ago=hud_ago-datetime.timedelta(days=60)\n",
    "    to_date=datetime.date.isoformat(todaydt)\n",
    "    from_date=datetime.date.isoformat(hud_ago)\n",
    "    print(len(old_lst))\n",
    "    \n",
    "mydata2  = pd.DataFrame(old_lst)\n",
    "mydata2 ['hl_range'] = mydata2['high'] - mydata2['low']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>open</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>close</th>\n",
       "      <th>volume</th>\n",
       "      <th>hl_range</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2019-04-15 00:00:00+05:30</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2019-04-22 00:00:00+05:30</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2019-04-29 00:00:00+05:30</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2019-07-01 00:00:00+05:30</td>\n",
       "      <td>2.0800</td>\n",
       "      <td>2.1600</td>\n",
       "      <td>2.0800</td>\n",
       "      <td>2.1600</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2019-07-08 00:00:00+05:30</td>\n",
       "      <td>1.9475</td>\n",
       "      <td>2.2050</td>\n",
       "      <td>1.9475</td>\n",
       "      <td>1.9600</td>\n",
       "      <td>0</td>\n",
       "      <td>0.2575</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2019-07-15 00:00:00+05:30</td>\n",
       "      <td>2.1300</td>\n",
       "      <td>2.1300</td>\n",
       "      <td>1.7375</td>\n",
       "      <td>1.8925</td>\n",
       "      <td>0</td>\n",
       "      <td>0.3925</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2019-07-22 00:00:00+05:30</td>\n",
       "      <td>1.8025</td>\n",
       "      <td>1.8025</td>\n",
       "      <td>1.6975</td>\n",
       "      <td>1.6975</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2019-10-28 00:00:00+05:30</td>\n",
       "      <td>73.4300</td>\n",
       "      <td>73.7100</td>\n",
       "      <td>72.5200</td>\n",
       "      <td>73.5700</td>\n",
       "      <td>2517</td>\n",
       "      <td>1.1900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2019-11-04 00:00:00+05:30</td>\n",
       "      <td>73.5000</td>\n",
       "      <td>73.8675</td>\n",
       "      <td>73.3500</td>\n",
       "      <td>73.8250</td>\n",
       "      <td>2509</td>\n",
       "      <td>0.5175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2019-11-11 00:00:00+05:30</td>\n",
       "      <td>73.8000</td>\n",
       "      <td>74.6775</td>\n",
       "      <td>73.5050</td>\n",
       "      <td>74.3100</td>\n",
       "      <td>5903</td>\n",
       "      <td>1.1725</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2019-11-18 00:00:00+05:30</td>\n",
       "      <td>74.1500</td>\n",
       "      <td>74.4600</td>\n",
       "      <td>74.1400</td>\n",
       "      <td>74.2175</td>\n",
       "      <td>16671</td>\n",
       "      <td>0.3200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2019-11-25 00:00:00+05:30</td>\n",
       "      <td>74.1600</td>\n",
       "      <td>74.2150</td>\n",
       "      <td>73.7200</td>\n",
       "      <td>74.0725</td>\n",
       "      <td>2046</td>\n",
       "      <td>0.4950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2019-12-02 00:00:00+05:30</td>\n",
       "      <td>74.0600</td>\n",
       "      <td>74.1900</td>\n",
       "      <td>73.6900</td>\n",
       "      <td>73.7250</td>\n",
       "      <td>1699</td>\n",
       "      <td>0.5000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2019-12-09 00:00:00+05:30</td>\n",
       "      <td>73.8200</td>\n",
       "      <td>73.8200</td>\n",
       "      <td>73.0000</td>\n",
       "      <td>73.3000</td>\n",
       "      <td>4042</td>\n",
       "      <td>0.8200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2019-12-16 00:00:00+05:30</td>\n",
       "      <td>73.4325</td>\n",
       "      <td>73.7000</td>\n",
       "      <td>73.3800</td>\n",
       "      <td>73.5650</td>\n",
       "      <td>1290</td>\n",
       "      <td>0.3200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2019-12-23 00:00:00+05:30</td>\n",
       "      <td>73.5775</td>\n",
       "      <td>73.7800</td>\n",
       "      <td>73.5775</td>\n",
       "      <td>73.7600</td>\n",
       "      <td>918</td>\n",
       "      <td>0.2025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2019-12-30 00:00:00+05:30</td>\n",
       "      <td>73.7875</td>\n",
       "      <td>74.1300</td>\n",
       "      <td>73.6000</td>\n",
       "      <td>74.1125</td>\n",
       "      <td>1153</td>\n",
       "      <td>0.5300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2020-01-06 00:00:00+05:30</td>\n",
       "      <td>74.4000</td>\n",
       "      <td>74.4400</td>\n",
       "      <td>73.1500</td>\n",
       "      <td>73.2275</td>\n",
       "      <td>848</td>\n",
       "      <td>1.2900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2020-01-13 00:00:00+05:30</td>\n",
       "      <td>73.2100</td>\n",
       "      <td>73.3125</td>\n",
       "      <td>73.0500</td>\n",
       "      <td>73.2975</td>\n",
       "      <td>1218</td>\n",
       "      <td>0.2625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2020-01-20 00:00:00+05:30</td>\n",
       "      <td>73.3075</td>\n",
       "      <td>73.4525</td>\n",
       "      <td>73.3075</td>\n",
       "      <td>73.4000</td>\n",
       "      <td>163</td>\n",
       "      <td>0.1450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2020-01-27 00:00:00+05:30</td>\n",
       "      <td>73.5000</td>\n",
       "      <td>73.7000</td>\n",
       "      <td>73.3625</td>\n",
       "      <td>73.4750</td>\n",
       "      <td>52</td>\n",
       "      <td>0.3375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2020-02-03 00:00:00+05:30</td>\n",
       "      <td>73.7000</td>\n",
       "      <td>73.7000</td>\n",
       "      <td>73.2000</td>\n",
       "      <td>73.3775</td>\n",
       "      <td>768</td>\n",
       "      <td>0.5000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2020-02-10 00:00:00+05:30</td>\n",
       "      <td>73.2600</td>\n",
       "      <td>73.3225</td>\n",
       "      <td>73.1500</td>\n",
       "      <td>73.2100</td>\n",
       "      <td>1183</td>\n",
       "      <td>0.1725</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2020-02-17 00:00:00+05:30</td>\n",
       "      <td>73.2200</td>\n",
       "      <td>73.3200</td>\n",
       "      <td>73.2000</td>\n",
       "      <td>73.3200</td>\n",
       "      <td>126</td>\n",
       "      <td>0.1200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2020-02-24 00:00:00+05:30</td>\n",
       "      <td>73.5000</td>\n",
       "      <td>73.9325</td>\n",
       "      <td>73.2800</td>\n",
       "      <td>73.8975</td>\n",
       "      <td>1227</td>\n",
       "      <td>0.6525</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2020-03-02 00:00:00+05:30</td>\n",
       "      <td>73.9100</td>\n",
       "      <td>75.7000</td>\n",
       "      <td>73.9100</td>\n",
       "      <td>75.3725</td>\n",
       "      <td>5180</td>\n",
       "      <td>1.7900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2020-03-09 00:00:00+05:30</td>\n",
       "      <td>75.7900</td>\n",
       "      <td>76.1300</td>\n",
       "      <td>75.2600</td>\n",
       "      <td>75.5675</td>\n",
       "      <td>2536</td>\n",
       "      <td>0.8700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2020-03-16 00:00:00+05:30</td>\n",
       "      <td>75.7750</td>\n",
       "      <td>77.5000</td>\n",
       "      <td>75.7000</td>\n",
       "      <td>77.0500</td>\n",
       "      <td>8865</td>\n",
       "      <td>1.8000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2020-03-23 00:00:00+05:30</td>\n",
       "      <td>77.6875</td>\n",
       "      <td>80.8000</td>\n",
       "      <td>76.7500</td>\n",
       "      <td>77.2850</td>\n",
       "      <td>5518</td>\n",
       "      <td>4.0500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2020-03-30 00:00:00+05:30</td>\n",
       "      <td>77.4975</td>\n",
       "      <td>78.0800</td>\n",
       "      <td>76.9600</td>\n",
       "      <td>78.0750</td>\n",
       "      <td>4735</td>\n",
       "      <td>1.1200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2020-04-06 00:00:00+05:30</td>\n",
       "      <td>77.8500</td>\n",
       "      <td>78.2800</td>\n",
       "      <td>77.4900</td>\n",
       "      <td>78.0000</td>\n",
       "      <td>455</td>\n",
       "      <td>0.7900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>2020-04-13 00:00:00+05:30</td>\n",
       "      <td>77.9000</td>\n",
       "      <td>78.0675</td>\n",
       "      <td>77.8300</td>\n",
       "      <td>77.9725</td>\n",
       "      <td>60</td>\n",
       "      <td>0.2375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>2020-04-13 00:00:00+05:30</td>\n",
       "      <td>77.7475</td>\n",
       "      <td>78.5825</td>\n",
       "      <td>77.6300</td>\n",
       "      <td>78.0475</td>\n",
       "      <td>2015</td>\n",
       "      <td>0.9525</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>2020-04-20 00:00:00+05:30</td>\n",
       "      <td>78.0500</td>\n",
       "      <td>78.6200</td>\n",
       "      <td>77.5325</td>\n",
       "      <td>77.7750</td>\n",
       "      <td>2170</td>\n",
       "      <td>1.0875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>2020-04-27 00:00:00+05:30</td>\n",
       "      <td>77.7000</td>\n",
       "      <td>77.9450</td>\n",
       "      <td>76.3600</td>\n",
       "      <td>76.4000</td>\n",
       "      <td>3015</td>\n",
       "      <td>1.5850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>2020-05-04 00:00:00+05:30</td>\n",
       "      <td>77.0000</td>\n",
       "      <td>77.3000</td>\n",
       "      <td>76.7275</td>\n",
       "      <td>76.9375</td>\n",
       "      <td>1492</td>\n",
       "      <td>0.5725</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>2020-05-11 00:00:00+05:30</td>\n",
       "      <td>77.0000</td>\n",
       "      <td>77.2500</td>\n",
       "      <td>76.4050</td>\n",
       "      <td>77.0975</td>\n",
       "      <td>3016</td>\n",
       "      <td>0.8450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>2020-05-18 00:00:00+05:30</td>\n",
       "      <td>77.0250</td>\n",
       "      <td>77.5700</td>\n",
       "      <td>76.7500</td>\n",
       "      <td>77.0350</td>\n",
       "      <td>1150</td>\n",
       "      <td>0.8200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>2020-05-25 00:00:00+05:30</td>\n",
       "      <td>77.2475</td>\n",
       "      <td>77.2475</td>\n",
       "      <td>76.5800</td>\n",
       "      <td>76.6400</td>\n",
       "      <td>2324</td>\n",
       "      <td>0.6675</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>2020-06-01 00:00:00+05:30</td>\n",
       "      <td>76.3000</td>\n",
       "      <td>76.6700</td>\n",
       "      <td>75.9375</td>\n",
       "      <td>76.6425</td>\n",
       "      <td>7543</td>\n",
       "      <td>0.7325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>2020-06-08 00:00:00+05:30</td>\n",
       "      <td>76.6200</td>\n",
       "      <td>77.0300</td>\n",
       "      <td>76.3900</td>\n",
       "      <td>76.8075</td>\n",
       "      <td>8657</td>\n",
       "      <td>0.6400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>2020-06-15 00:00:00+05:30</td>\n",
       "      <td>76.8825</td>\n",
       "      <td>77.3000</td>\n",
       "      <td>76.7400</td>\n",
       "      <td>77.1400</td>\n",
       "      <td>9399</td>\n",
       "      <td>0.5600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>2020-06-22 00:00:00+05:30</td>\n",
       "      <td>77.1000</td>\n",
       "      <td>77.1550</td>\n",
       "      <td>76.2450</td>\n",
       "      <td>76.4775</td>\n",
       "      <td>38243</td>\n",
       "      <td>0.9100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>2020-06-29 00:00:00+05:30</td>\n",
       "      <td>76.5000</td>\n",
       "      <td>76.5000</td>\n",
       "      <td>75.3975</td>\n",
       "      <td>75.4875</td>\n",
       "      <td>50637</td>\n",
       "      <td>1.1025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>2020-07-06 00:00:00+05:30</td>\n",
       "      <td>75.3775</td>\n",
       "      <td>76.1200</td>\n",
       "      <td>75.2700</td>\n",
       "      <td>76.0450</td>\n",
       "      <td>22789</td>\n",
       "      <td>0.8500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>2020-07-13 00:00:00+05:30</td>\n",
       "      <td>75.9725</td>\n",
       "      <td>76.2750</td>\n",
       "      <td>75.7100</td>\n",
       "      <td>75.7350</td>\n",
       "      <td>26897</td>\n",
       "      <td>0.5650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>2020-07-20 00:00:00+05:30</td>\n",
       "      <td>75.6000</td>\n",
       "      <td>75.7575</td>\n",
       "      <td>75.2600</td>\n",
       "      <td>75.5250</td>\n",
       "      <td>39170</td>\n",
       "      <td>0.4975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>2020-07-27 00:00:00+05:30</td>\n",
       "      <td>75.6200</td>\n",
       "      <td>75.7000</td>\n",
       "      <td>75.3000</td>\n",
       "      <td>75.4400</td>\n",
       "      <td>66066</td>\n",
       "      <td>0.4000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>2020-08-03 00:00:00+05:30</td>\n",
       "      <td>75.5400</td>\n",
       "      <td>75.9100</td>\n",
       "      <td>75.3550</td>\n",
       "      <td>75.5400</td>\n",
       "      <td>65864</td>\n",
       "      <td>0.5550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>2020-08-10 00:00:00+05:30</td>\n",
       "      <td>75.5600</td>\n",
       "      <td>75.5675</td>\n",
       "      <td>75.1425</td>\n",
       "      <td>75.2225</td>\n",
       "      <td>19249</td>\n",
       "      <td>0.4250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>2020-08-10 00:00:00+05:30</td>\n",
       "      <td>75.3025</td>\n",
       "      <td>75.4875</td>\n",
       "      <td>75.2725</td>\n",
       "      <td>75.4450</td>\n",
       "      <td>15999</td>\n",
       "      <td>0.2150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>2020-08-17 00:00:00+05:30</td>\n",
       "      <td>75.3675</td>\n",
       "      <td>75.6475</td>\n",
       "      <td>75.1400</td>\n",
       "      <td>75.3650</td>\n",
       "      <td>115955</td>\n",
       "      <td>0.5075</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>2020-08-24 00:00:00+05:30</td>\n",
       "      <td>75.3475</td>\n",
       "      <td>75.4275</td>\n",
       "      <td>73.6975</td>\n",
       "      <td>73.7350</td>\n",
       "      <td>654524</td>\n",
       "      <td>1.7300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>2020-08-31 00:00:00+05:30</td>\n",
       "      <td>73.6250</td>\n",
       "      <td>74.1275</td>\n",
       "      <td>73.1500</td>\n",
       "      <td>73.5225</td>\n",
       "      <td>1053299</td>\n",
       "      <td>0.9775</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>2020-09-07 00:00:00+05:30</td>\n",
       "      <td>73.5225</td>\n",
       "      <td>74.2800</td>\n",
       "      <td>73.3575</td>\n",
       "      <td>73.8700</td>\n",
       "      <td>1038817</td>\n",
       "      <td>0.9225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>2020-09-14 00:00:00+05:30</td>\n",
       "      <td>73.7525</td>\n",
       "      <td>74.0850</td>\n",
       "      <td>73.4425</td>\n",
       "      <td>73.7050</td>\n",
       "      <td>1295042</td>\n",
       "      <td>0.6425</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>2020-09-21 00:00:00+05:30</td>\n",
       "      <td>73.7450</td>\n",
       "      <td>74.4550</td>\n",
       "      <td>73.5425</td>\n",
       "      <td>73.9325</td>\n",
       "      <td>2784205</td>\n",
       "      <td>0.9125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>2020-09-28 00:00:00+05:30</td>\n",
       "      <td>73.8100</td>\n",
       "      <td>74.1175</td>\n",
       "      <td>73.1875</td>\n",
       "      <td>73.3425</td>\n",
       "      <td>8881901</td>\n",
       "      <td>0.9300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>2020-10-05 00:00:00+05:30</td>\n",
       "      <td>73.2900</td>\n",
       "      <td>73.7675</td>\n",
       "      <td>73.1225</td>\n",
       "      <td>73.2450</td>\n",
       "      <td>10266191</td>\n",
       "      <td>0.6450</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        date     open     high      low    close    volume  \\\n",
       "7  2019-04-15 00:00:00+05:30   0.0000   0.0000   0.0000   0.0000         0   \n",
       "8  2019-04-22 00:00:00+05:30   0.0000   0.0000   0.0000   0.0000         0   \n",
       "9  2019-04-29 00:00:00+05:30   0.0000   0.0000   0.0000   0.0000         0   \n",
       "10 2019-07-01 00:00:00+05:30   2.0800   2.1600   2.0800   2.1600         0   \n",
       "11 2019-07-08 00:00:00+05:30   1.9475   2.2050   1.9475   1.9600         0   \n",
       "12 2019-07-15 00:00:00+05:30   2.1300   2.1300   1.7375   1.8925         0   \n",
       "13 2019-07-22 00:00:00+05:30   1.8025   1.8025   1.6975   1.6975         0   \n",
       "14 2019-10-28 00:00:00+05:30  73.4300  73.7100  72.5200  73.5700      2517   \n",
       "15 2019-11-04 00:00:00+05:30  73.5000  73.8675  73.3500  73.8250      2509   \n",
       "16 2019-11-11 00:00:00+05:30  73.8000  74.6775  73.5050  74.3100      5903   \n",
       "17 2019-11-18 00:00:00+05:30  74.1500  74.4600  74.1400  74.2175     16671   \n",
       "18 2019-11-25 00:00:00+05:30  74.1600  74.2150  73.7200  74.0725      2046   \n",
       "19 2019-12-02 00:00:00+05:30  74.0600  74.1900  73.6900  73.7250      1699   \n",
       "20 2019-12-09 00:00:00+05:30  73.8200  73.8200  73.0000  73.3000      4042   \n",
       "21 2019-12-16 00:00:00+05:30  73.4325  73.7000  73.3800  73.5650      1290   \n",
       "22 2019-12-23 00:00:00+05:30  73.5775  73.7800  73.5775  73.7600       918   \n",
       "23 2019-12-30 00:00:00+05:30  73.7875  74.1300  73.6000  74.1125      1153   \n",
       "24 2020-01-06 00:00:00+05:30  74.4000  74.4400  73.1500  73.2275       848   \n",
       "25 2020-01-13 00:00:00+05:30  73.2100  73.3125  73.0500  73.2975      1218   \n",
       "26 2020-01-20 00:00:00+05:30  73.3075  73.4525  73.3075  73.4000       163   \n",
       "27 2020-01-27 00:00:00+05:30  73.5000  73.7000  73.3625  73.4750        52   \n",
       "28 2020-02-03 00:00:00+05:30  73.7000  73.7000  73.2000  73.3775       768   \n",
       "29 2020-02-10 00:00:00+05:30  73.2600  73.3225  73.1500  73.2100      1183   \n",
       "30 2020-02-17 00:00:00+05:30  73.2200  73.3200  73.2000  73.3200       126   \n",
       "31 2020-02-24 00:00:00+05:30  73.5000  73.9325  73.2800  73.8975      1227   \n",
       "32 2020-03-02 00:00:00+05:30  73.9100  75.7000  73.9100  75.3725      5180   \n",
       "33 2020-03-09 00:00:00+05:30  75.7900  76.1300  75.2600  75.5675      2536   \n",
       "34 2020-03-16 00:00:00+05:30  75.7750  77.5000  75.7000  77.0500      8865   \n",
       "35 2020-03-23 00:00:00+05:30  77.6875  80.8000  76.7500  77.2850      5518   \n",
       "36 2020-03-30 00:00:00+05:30  77.4975  78.0800  76.9600  78.0750      4735   \n",
       "37 2020-04-06 00:00:00+05:30  77.8500  78.2800  77.4900  78.0000       455   \n",
       "38 2020-04-13 00:00:00+05:30  77.9000  78.0675  77.8300  77.9725        60   \n",
       "39 2020-04-13 00:00:00+05:30  77.7475  78.5825  77.6300  78.0475      2015   \n",
       "40 2020-04-20 00:00:00+05:30  78.0500  78.6200  77.5325  77.7750      2170   \n",
       "41 2020-04-27 00:00:00+05:30  77.7000  77.9450  76.3600  76.4000      3015   \n",
       "42 2020-05-04 00:00:00+05:30  77.0000  77.3000  76.7275  76.9375      1492   \n",
       "43 2020-05-11 00:00:00+05:30  77.0000  77.2500  76.4050  77.0975      3016   \n",
       "44 2020-05-18 00:00:00+05:30  77.0250  77.5700  76.7500  77.0350      1150   \n",
       "45 2020-05-25 00:00:00+05:30  77.2475  77.2475  76.5800  76.6400      2324   \n",
       "46 2020-06-01 00:00:00+05:30  76.3000  76.6700  75.9375  76.6425      7543   \n",
       "47 2020-06-08 00:00:00+05:30  76.6200  77.0300  76.3900  76.8075      8657   \n",
       "48 2020-06-15 00:00:00+05:30  76.8825  77.3000  76.7400  77.1400      9399   \n",
       "49 2020-06-22 00:00:00+05:30  77.1000  77.1550  76.2450  76.4775     38243   \n",
       "50 2020-06-29 00:00:00+05:30  76.5000  76.5000  75.3975  75.4875     50637   \n",
       "51 2020-07-06 00:00:00+05:30  75.3775  76.1200  75.2700  76.0450     22789   \n",
       "52 2020-07-13 00:00:00+05:30  75.9725  76.2750  75.7100  75.7350     26897   \n",
       "53 2020-07-20 00:00:00+05:30  75.6000  75.7575  75.2600  75.5250     39170   \n",
       "54 2020-07-27 00:00:00+05:30  75.6200  75.7000  75.3000  75.4400     66066   \n",
       "55 2020-08-03 00:00:00+05:30  75.5400  75.9100  75.3550  75.5400     65864   \n",
       "56 2020-08-10 00:00:00+05:30  75.5600  75.5675  75.1425  75.2225     19249   \n",
       "57 2020-08-10 00:00:00+05:30  75.3025  75.4875  75.2725  75.4450     15999   \n",
       "58 2020-08-17 00:00:00+05:30  75.3675  75.6475  75.1400  75.3650    115955   \n",
       "59 2020-08-24 00:00:00+05:30  75.3475  75.4275  73.6975  73.7350    654524   \n",
       "60 2020-08-31 00:00:00+05:30  73.6250  74.1275  73.1500  73.5225   1053299   \n",
       "61 2020-09-07 00:00:00+05:30  73.5225  74.2800  73.3575  73.8700   1038817   \n",
       "62 2020-09-14 00:00:00+05:30  73.7525  74.0850  73.4425  73.7050   1295042   \n",
       "63 2020-09-21 00:00:00+05:30  73.7450  74.4550  73.5425  73.9325   2784205   \n",
       "64 2020-09-28 00:00:00+05:30  73.8100  74.1175  73.1875  73.3425   8881901   \n",
       "65 2020-10-05 00:00:00+05:30  73.2900  73.7675  73.1225  73.2450  10266191   \n",
       "\n",
       "    hl_range  \n",
       "7     0.0000  \n",
       "8     0.0000  \n",
       "9     0.0000  \n",
       "10    0.0800  \n",
       "11    0.2575  \n",
       "12    0.3925  \n",
       "13    0.1050  \n",
       "14    1.1900  \n",
       "15    0.5175  \n",
       "16    1.1725  \n",
       "17    0.3200  \n",
       "18    0.4950  \n",
       "19    0.5000  \n",
       "20    0.8200  \n",
       "21    0.3200  \n",
       "22    0.2025  \n",
       "23    0.5300  \n",
       "24    1.2900  \n",
       "25    0.2625  \n",
       "26    0.1450  \n",
       "27    0.3375  \n",
       "28    0.5000  \n",
       "29    0.1725  \n",
       "30    0.1200  \n",
       "31    0.6525  \n",
       "32    1.7900  \n",
       "33    0.8700  \n",
       "34    1.8000  \n",
       "35    4.0500  \n",
       "36    1.1200  \n",
       "37    0.7900  \n",
       "38    0.2375  \n",
       "39    0.9525  \n",
       "40    1.0875  \n",
       "41    1.5850  \n",
       "42    0.5725  \n",
       "43    0.8450  \n",
       "44    0.8200  \n",
       "45    0.6675  \n",
       "46    0.7325  \n",
       "47    0.6400  \n",
       "48    0.5600  \n",
       "49    0.9100  \n",
       "50    1.1025  \n",
       "51    0.8500  \n",
       "52    0.5650  \n",
       "53    0.4975  \n",
       "54    0.4000  \n",
       "55    0.5550  \n",
       "56    0.4250  \n",
       "57    0.2150  \n",
       "58    0.5075  \n",
       "59    1.7300  \n",
       "60    0.9775  \n",
       "61    0.9225  \n",
       "62    0.6425  \n",
       "63    0.9125  \n",
       "64    0.9300  \n",
       "65    0.6450  "
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mydata2[:][:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    250.000000\n",
       "mean       0.298200\n",
       "std        0.277858\n",
       "min        0.000000\n",
       "25%        0.145000\n",
       "50%        0.238750\n",
       "75%        0.383750\n",
       "max        3.112500\n",
       "Name: hl_range, dtype: float64"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mydata2['hl_range'][37:].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "  <div class=\"bk-root\" id=\"f8c176bf-eadc-42d2-9106-f87a961dbbbd\" data-root-id=\"6024\"></div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "(function(root) {\n",
       "  function embed_document(root) {\n",
       "    \n",
       "  var docs_json = {\"f1e55476-7a3c-4479-a3fc-a2c5976d4c54\":{\"roots\":{\"references\":[{\"attributes\":{\"below\":[{\"id\":\"6035\"}],\"center\":[{\"id\":\"6038\"},{\"id\":\"6042\"},{\"id\":\"6071\"}],\"left\":[{\"id\":\"6039\"}],\"output_backend\":\"webgl\",\"plot_height\":400,\"renderers\":[{\"id\":\"6061\"}],\"sizing_mode\":\"fixed\",\"title\":{\"id\":\"6025\"},\"toolbar\":{\"id\":\"6050\"},\"x_range\":{\"id\":\"6027\"},\"x_scale\":{\"id\":\"6031\"},\"y_range\":{\"id\":\"6029\"},\"y_scale\":{\"id\":\"6033\"}},\"id\":\"6024\",\"subtype\":\"Figure\",\"type\":\"Plot\"},{\"attributes\":{\"axis\":{\"id\":\"6035\"},\"ticker\":null},\"id\":\"6038\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"6065\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{\"click_policy\":\"hide\",\"items\":[{\"id\":\"6072\"}]},\"id\":\"6071\",\"type\":\"Legend\"},{\"attributes\":{\"axis\":{\"id\":\"6039\"},\"dimension\":1,\"ticker\":null},\"id\":\"6042\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"6027\",\"type\":\"DataRange1d\"},{\"attributes\":{},\"id\":\"6040\",\"type\":\"BasicTicker\"},{\"attributes\":{\"active_drag\":\"auto\",\"active_inspect\":\"auto\",\"active_multi\":null,\"active_scroll\":{\"id\":\"6044\"},\"active_tap\":\"auto\",\"tools\":[{\"id\":\"6043\"},{\"id\":\"6044\"},{\"id\":\"6045\"},{\"id\":\"6046\"},{\"id\":\"6047\"},{\"id\":\"6048\"},{\"id\":\"6073\"}]},\"id\":\"6050\",\"type\":\"Toolbar\"},{\"attributes\":{},\"id\":\"6033\",\"type\":\"LinearScale\"},{\"attributes\":{},\"id\":\"6048\",\"type\":\"HelpTool\"},{\"attributes\":{},\"id\":\"6070\",\"type\":\"UnionRenderers\"},{\"attributes\":{},\"id\":\"6043\",\"type\":\"PanTool\"},{\"attributes\":{\"overlay\":{\"id\":\"6049\"}},\"id\":\"6045\",\"type\":\"BoxZoomTool\"},{\"attributes\":{},\"id\":\"6046\",\"type\":\"SaveTool\"},{\"attributes\":{},\"id\":\"6047\",\"type\":\"ResetTool\"},{\"attributes\":{},\"id\":\"6069\",\"type\":\"Selection\"},{\"attributes\":{\"bottom\":{\"field\":\"bottom\"},\"fill_alpha\":{\"value\":1.2},\"fill_color\":{\"value\":\"#1f77b4\"},\"left\":{\"field\":\"left\"},\"line_alpha\":{\"value\":1.2},\"line_color\":{\"value\":null},\"line_width\":{\"value\":2},\"right\":{\"field\":\"right\"},\"top\":{\"field\":\"top\"}},\"id\":\"6059\",\"type\":\"Quad\"},{\"attributes\":{\"data\":{\"bins\":[\"0.0\\uff0d0.015562499999999986\",\"0.015562499999999986\\uff0d0.031124999999999972\",\"0.031124999999999972\\uff0d0.04668749999999996\",\"0.04668749999999996\\uff0d0.062249999999999944\",\"0.062249999999999944\\uff0d0.07781249999999992\",\"0.07781249999999992\\uff0d0.09337499999999992\",\"0.09337499999999992\\uff0d0.10893749999999991\",\"0.10893749999999991\\uff0d0.12449999999999989\",\"0.12449999999999989\\uff0d0.14006249999999987\",\"0.14006249999999987\\uff0d0.15562499999999985\",\"0.15562499999999985\\uff0d0.17118749999999985\",\"0.17118749999999985\\uff0d0.18674999999999983\",\"0.18674999999999983\\uff0d0.2023124999999998\",\"0.2023124999999998\\uff0d0.21787499999999982\",\"0.21787499999999982\\uff0d0.2334374999999998\",\"0.2334374999999998\\uff0d0.24899999999999978\",\"0.24899999999999978\\uff0d0.26456249999999976\",\"0.26456249999999976\\uff0d0.28012499999999974\",\"0.28012499999999974\\uff0d0.2956874999999997\",\"0.2956874999999997\\uff0d0.3112499999999997\",\"0.3112499999999997\\uff0d0.32681249999999973\",\"0.32681249999999973\\uff0d0.3423749999999997\",\"0.3423749999999997\\uff0d0.3579374999999997\",\"0.3579374999999997\\uff0d0.37349999999999967\",\"0.37349999999999967\\uff0d0.38906249999999964\",\"0.38906249999999964\\uff0d0.4046249999999996\",\"0.4046249999999996\\uff0d0.4201874999999996\",\"0.4201874999999996\\uff0d0.43574999999999964\",\"0.43574999999999964\\uff0d0.4513124999999996\",\"0.4513124999999996\\uff0d0.4668749999999996\",\"0.4668749999999996\\uff0d0.4824374999999996\",\"0.4824374999999996\\uff0d0.49799999999999955\",\"0.49799999999999955\\uff0d0.5135624999999996\",\"0.5135624999999996\\uff0d0.5291249999999995\",\"0.5291249999999995\\uff0d0.5446874999999995\",\"0.5446874999999995\\uff0d0.5602499999999995\",\"0.5602499999999995\\uff0d0.5758124999999995\",\"0.5758124999999995\\uff0d0.5913749999999994\",\"0.5913749999999994\\uff0d0.6069374999999995\",\"0.6069374999999995\\uff0d0.6224999999999994\",\"0.6224999999999994\\uff0d0.6380624999999994\",\"0.6380624999999994\\uff0d0.6536249999999995\",\"0.6536249999999995\\uff0d0.6691874999999994\",\"0.6691874999999994\\uff0d0.6847499999999994\",\"0.6847499999999994\\uff0d0.7003124999999993\",\"0.7003124999999993\\uff0d0.7158749999999994\",\"0.7158749999999994\\uff0d0.7314374999999993\",\"0.7314374999999993\\uff0d0.7469999999999993\",\"0.7469999999999993\\uff0d0.7625624999999994\",\"0.7625624999999994\\uff0d0.7781249999999993\",\"0.7781249999999993\\uff0d0.7936874999999993\",\"0.7936874999999993\\uff0d0.8092499999999992\",\"0.8092499999999992\\uff0d0.8248124999999993\",\"0.8248124999999993\\uff0d0.8403749999999992\",\"0.8403749999999992\\uff0d0.8559374999999992\",\"0.8559374999999992\\uff0d0.8714999999999993\",\"0.8714999999999993\\uff0d0.8870624999999992\",\"0.8870624999999992\\uff0d0.9026249999999992\",\"0.9026249999999992\\uff0d0.9181874999999992\",\"0.9181874999999992\\uff0d0.9337499999999992\",\"0.9337499999999992\\uff0d0.9493124999999991\",\"0.9493124999999991\\uff0d0.9648749999999992\",\"0.9648749999999992\\uff0d0.9804374999999991\",\"0.9804374999999991\\uff0d0.9959999999999991\",\"0.9959999999999991\\uff0d1.011562499999999\",\"1.011562499999999\\uff0d1.0271249999999992\",\"1.0271249999999992\\uff0d1.042687499999999\",\"1.042687499999999\\uff0d1.058249999999999\",\"1.058249999999999\\uff0d1.073812499999999\",\"1.073812499999999\\uff0d1.089374999999999\",\"1.089374999999999\\uff0d1.104937499999999\",\"1.104937499999999\\uff0d1.120499999999999\",\"1.120499999999999\\uff0d1.136062499999999\",\"1.136062499999999\\uff0d1.151624999999999\",\"1.151624999999999\\uff0d1.167187499999999\",\"1.167187499999999\\uff0d1.1827499999999989\",\"1.1827499999999989\\uff0d1.198312499999999\",\"1.198312499999999\\uff0d1.213874999999999\",\"1.213874999999999\\uff0d1.2294374999999989\",\"1.2294374999999989\\uff0d1.2449999999999988\",\"1.2449999999999988\\uff0d1.260562499999999\",\"1.260562499999999\\uff0d1.2761249999999988\",\"1.2761249999999988\\uff0d1.2916874999999988\",\"1.2916874999999988\\uff0d1.307249999999999\",\"1.307249999999999\\uff0d1.3228124999999988\",\"1.3228124999999988\\uff0d1.3383749999999988\",\"1.3383749999999988\\uff0d1.3539374999999987\",\"1.3539374999999987\\uff0d1.3694999999999988\",\"1.3694999999999988\\uff0d1.3850624999999988\",\"1.3850624999999988\\uff0d1.4006249999999987\",\"1.4006249999999987\\uff0d1.4161874999999988\",\"1.4161874999999988\\uff0d1.4317499999999987\",\"1.4317499999999987\\uff0d1.4473124999999987\",\"1.4473124999999987\\uff0d1.4628749999999986\",\"1.4628749999999986\\uff0d1.4784374999999987\",\"1.4784374999999987\\uff0d1.4939999999999987\",\"1.4939999999999987\\uff0d1.5095624999999986\",\"1.5095624999999986\\uff0d1.5251249999999987\",\"1.5251249999999987\\uff0d1.5406874999999987\",\"1.5406874999999987\\uff0d1.5562499999999986\",\"1.5562499999999986\\uff0d1.5718124999999985\",\"1.5718124999999985\\uff0d1.5873749999999986\",\"1.5873749999999986\\uff0d1.6029374999999986\",\"1.6029374999999986\\uff0d1.6184999999999985\",\"1.6184999999999985\\uff0d1.6340624999999986\",\"1.6340624999999986\\uff0d1.6496249999999986\",\"1.6496249999999986\\uff0d1.6651874999999985\",\"1.6651874999999985\\uff0d1.6807499999999984\",\"1.6807499999999984\\uff0d1.6963124999999986\",\"1.6963124999999986\\uff0d1.7118749999999985\",\"1.7118749999999985\\uff0d1.7274374999999984\",\"1.7274374999999984\\uff0d1.7429999999999986\",\"1.7429999999999986\\uff0d1.7585624999999985\",\"1.7585624999999985\\uff0d1.7741249999999984\",\"1.7741249999999984\\uff0d1.7896874999999983\",\"1.7896874999999983\\uff0d1.8052499999999985\",\"1.8052499999999985\\uff0d1.8208124999999984\",\"1.8208124999999984\\uff0d1.8363749999999983\",\"1.8363749999999983\\uff0d1.8519374999999982\",\"1.8519374999999982\\uff0d1.8674999999999984\",\"1.8674999999999984\\uff0d1.8830624999999983\",\"1.8830624999999983\\uff0d1.8986249999999982\",\"1.8986249999999982\\uff0d1.9141874999999984\",\"1.9141874999999984\\uff0d1.9297499999999983\",\"1.9297499999999983\\uff0d1.9453124999999982\",\"1.9453124999999982\\uff0d1.9608749999999981\",\"1.9608749999999981\\uff0d1.9764374999999983\",\"1.9764374999999983\\uff0d1.9919999999999982\",\"1.9919999999999982\\uff0d2.0075624999999984\",\"2.0075624999999984\\uff0d2.023124999999998\",\"2.023124999999998\\uff0d2.038687499999998\",\"2.038687499999998\\uff0d2.0542499999999984\",\"2.0542499999999984\\uff0d2.069812499999998\",\"2.069812499999998\\uff0d2.085374999999998\",\"2.085374999999998\\uff0d2.100937499999998\",\"2.100937499999998\\uff0d2.116499999999998\",\"2.116499999999998\\uff0d2.132062499999998\",\"2.132062499999998\\uff0d2.147624999999998\",\"2.147624999999998\\uff0d2.163187499999998\",\"2.163187499999998\\uff0d2.178749999999998\",\"2.178749999999998\\uff0d2.194312499999998\",\"2.194312499999998\\uff0d2.209874999999998\",\"2.209874999999998\\uff0d2.225437499999998\",\"2.225437499999998\\uff0d2.240999999999998\",\"2.240999999999998\\uff0d2.256562499999998\",\"2.256562499999998\\uff0d2.272124999999998\",\"2.272124999999998\\uff0d2.287687499999998\",\"2.287687499999998\\uff0d2.303249999999998\",\"2.303249999999998\\uff0d2.3188124999999977\",\"2.3188124999999977\\uff0d2.334374999999998\",\"2.334374999999998\\uff0d2.349937499999998\",\"2.349937499999998\\uff0d2.3654999999999977\",\"2.3654999999999977\\uff0d2.381062499999998\",\"2.381062499999998\\uff0d2.396624999999998\",\"2.396624999999998\\uff0d2.4121874999999977\",\"2.4121874999999977\\uff0d2.427749999999998\",\"2.427749999999998\\uff0d2.443312499999998\",\"2.443312499999998\\uff0d2.4588749999999977\",\"2.4588749999999977\\uff0d2.474437499999998\",\"2.474437499999998\\uff0d2.4899999999999975\",\"2.4899999999999975\\uff0d2.5055624999999977\",\"2.5055624999999977\\uff0d2.521124999999998\",\"2.521124999999998\\uff0d2.5366874999999975\",\"2.5366874999999975\\uff0d2.5522499999999977\",\"2.5522499999999977\\uff0d2.567812499999998\",\"2.567812499999998\\uff0d2.5833749999999975\",\"2.5833749999999975\\uff0d2.5989374999999977\",\"2.5989374999999977\\uff0d2.614499999999998\",\"2.614499999999998\\uff0d2.6300624999999975\",\"2.6300624999999975\\uff0d2.6456249999999977\",\"2.6456249999999977\\uff0d2.661187499999998\",\"2.661187499999998\\uff0d2.6767499999999975\",\"2.6767499999999975\\uff0d2.6923124999999977\",\"2.6923124999999977\\uff0d2.7078749999999974\",\"2.7078749999999974\\uff0d2.7234374999999975\",\"2.7234374999999975\\uff0d2.7389999999999977\",\"2.7389999999999977\\uff0d2.7545624999999974\",\"2.7545624999999974\\uff0d2.7701249999999975\",\"2.7701249999999975\\uff0d2.7856874999999977\",\"2.7856874999999977\\uff0d2.8012499999999974\",\"2.8012499999999974\\uff0d2.8168124999999975\",\"2.8168124999999975\\uff0d2.8323749999999976\",\"2.8323749999999976\\uff0d2.8479374999999973\",\"2.8479374999999973\\uff0d2.8634999999999975\",\"2.8634999999999975\\uff0d2.8790624999999976\",\"2.8790624999999976\\uff0d2.8946249999999973\",\"2.8946249999999973\\uff0d2.9101874999999975\",\"2.9101874999999975\\uff0d2.925749999999997\",\"2.925749999999997\\uff0d2.9413124999999973\",\"2.9413124999999973\\uff0d2.9568749999999975\",\"2.9568749999999975\\uff0d2.972437499999997\",\"2.972437499999997\\uff0d2.9879999999999973\",\"2.9879999999999973\\uff0d3.0035624999999975\",\"3.0035624999999975\\uff0d3.019124999999997\",\"3.019124999999997\\uff0d3.0346874999999973\",\"3.0346874999999973\\uff0d3.0502499999999975\",\"3.0502499999999975\\uff0d3.065812499999997\",\"3.065812499999997\\uff0d3.0813749999999973\",\"3.0813749999999973\\uff0d3.096937499999997\",\"3.096937499999997\\uff0d3.112499999999997\"],\"bottom\":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],\"left\":{\"__ndarray__\":\"AAAAAAAAAACkHFpkO9+PP6QcWmQ7358/e5VDi2znpz+kHFpkO9+vP+ZRuB6F67M/e5VDi2zntz8Q2c73U+O7P6QcWmQ7378/HLByaJHtwT/mUbgehevDP7Hz/dR46cU/e5VDi2znxz9FN4lBYOXJPxDZzvdT48s/2noUrkfhzT+kHFpkO9/PPzffT42X7tA/HLByaJHt0T8BgZVDi+zSP+ZRuB6F69M/zCLb+X7q1D+x8/3UeOnVP5bEILBy6NY/e5VDi2zn1z9gZmZmZubYP0U3iUFg5dk/KgisHFrk2j8Q2c73U+PbP/Wp8dJN4tw/2noUrkfh3T+/SzeJQeDeP6QcWmQ7398/xXa+nxpv4D8330+Nl+7gP6pH4XoUbuE/HLByaJHt4T+PGARWDm3iPwGBlUOL7OI/dOkmMQhs4z/mUbgehevjP1m6SQwCa+Q/zCLb+X7q5D8+i2zn+2nlP7Hz/dR46eU/I1yPwvVo5j+WxCCwcujmPwgtsp3vZ+c/e5VDi2zn5z/u/dR46WboP2BmZmZm5ug/0873U+Nl6T9FN4lBYOXpP7ifGi/dZOo/KgisHFrk6j+dcD0K12PrPxDZzvdT4+s/gkFg5dBi7D/1qfHSTeLsP2cSg8DKYe0/2noUrkfh7T9M46WbxGDuP79LN4lB4O4/MbTIdr5f7z+kHFpkO9/vP4vC9ShcL/A/xXa+nxpv8D/+KocW2a7wPzffT42X7vA/cJMYBFYu8T+qR+F6FG7xP+P7qfHSrfE/HLByaJHt8T9WZDvfTy3yP48YBFYObfI/yMzMzMys8j8BgZVDi+zyPzs1XrpJLPM/dOkmMQhs8z+tne+nxqvzP+ZRuB6F6/M/IAaBlUMr9D9ZukkMAmv0P5JuEoPAqvQ/zCLb+X7q9D8F16NwPSr1Pz6LbOf7afU/dz81Xrqp9T+x8/3UeOn1P+qnxks3KfY/I1yPwvVo9j9dEFg5tKj2P5bEILBy6PY/z3jpJjEo9z8ILbKd72f3P0LhehSup/c/e5VDi2zn9z+0SQwCKyf4P+791HjpZvg/J7Kd76em+D9gZmZmZub4P5kaL90kJvk/0873U+Nl+T8Mg8DKoaX5P0U3iUFg5fk/f+tRuB4l+j+4nxov3WT6P/FT46WbpPo/KgisHFrk+j9kvHSTGCT7P51wPQrXY/s/1iQGgZWj+z8Q2c73U+P7P0mNl24SI/w/gkFg5dBi/D+79Shcj6L8P/Wp8dJN4vw/Ll66SQwi/T9nEoPAymH9P6DGSzeJof0/2noUrkfh/T8TL90kBiH+P0zjpZvEYP4/hpduEoOg/j+/SzeJQeD+P/j/////H/8/MbTIdr5f/z9raJHtfJ//P6QcWmQ73/8/b2iR7XwPAECLwvUoXC8AQKgcWmQ7TwBAxXa+nxpvAEDh0CLb+Y4AQP4qhxbZrgBAGoXrUbjOAEA330+Nl+4AQFQ5tMh2DgFAcJMYBFYuAUCN7Xw/NU4BQKpH4XoUbgFAxqFFtvONAUDj+6nx0q0BQABWDi2yzQFAHLByaJHtAUA5CtejcA0CQFZkO99PLQJAcr6fGi9NAkCPGARWDm0CQKtyaJHtjAJAyMzMzMysAkDlJjEIrMwCQAGBlUOL7AJAHtv5fmoMA0A7NV66SSwDQFePwvUoTANAdOkmMQhsA0CRQ4ts54sDQK2d76fGqwNAyvdT46XLA0DmUbgehesDQAOsHFpkCwRAIAaBlUMrBEA8YOXQIksEQFm6SQwCawRAdhSuR+GKBECSbhKDwKoEQK/Idr6fygRAzCLb+X7qBEDofD81XgoFQAXXo3A9KgVAIjEIrBxKBUA+i2zn+2kFQFvl0CLbiQVAdz81XrqpBUCUmZmZmckFQLHz/dR46QVAzU1iEFgJBkDqp8ZLNykGQAcCK4cWSQZAI1yPwvVoBkBAtvP91IgGQF0QWDm0qAZAeWq8dJPIBkCWxCCwcugGQLMehetRCAdAz3jpJjEoB0Ds0k1iEEgHQAgtsp3vZwdAJYcW2c6HB0BC4XoUrqcHQF4730+NxwdAe5VDi2znB0CY76fGSwcIQLRJDAIrJwhA0aNwPQpHCEDu/dR46WYIQApYObTIhghAJ7Kd76emCEBDDAIrh8YIQA==\",\"dtype\":\"float64\",\"order\":\"little\",\"shape\":[200]},\"right\":{\"__ndarray__\":\"pBxaZDvfjz+kHFpkO9+fP3uVQ4ts56c/pBxaZDvfrz/mUbgeheuzP3uVQ4ts57c/ENnO91Pjuz+kHFpkO9+/PxywcmiR7cE/5lG4HoXrwz+x8/3UeOnFP3uVQ4ts58c/RTeJQWDlyT8Q2c73U+PLP9p6FK5H4c0/pBxaZDvfzz8330+Nl+7QPxywcmiR7dE/AYGVQ4vs0j/mUbgehevTP8wi2/l+6tQ/sfP91Hjp1T+WxCCwcujWP3uVQ4ts59c/YGZmZmbm2D9FN4lBYOXZPyoIrBxa5No/ENnO91Pj2z/1qfHSTeLcP9p6FK5H4d0/v0s3iUHg3j+kHFpkO9/fP8V2vp8ab+A/N99PjZfu4D+qR+F6FG7hPxywcmiR7eE/jxgEVg5t4j8BgZVDi+ziP3TpJjEIbOM/5lG4HoXr4z9ZukkMAmvkP8wi2/l+6uQ/Pots5/tp5T+x8/3UeOnlPyNcj8L1aOY/lsQgsHLo5j8ILbKd72fnP3uVQ4ts5+c/7v3UeOlm6D9gZmZmZuboP9PO91PjZek/RTeJQWDl6T+4nxov3WTqPyoIrBxa5Oo/nXA9Ctdj6z8Q2c73U+PrP4JBYOXQYuw/9anx0k3i7D9nEoPAymHtP9p6FK5H4e0/TOOlm8Rg7j+/SzeJQeDuPzG0yHa+X+8/pBxaZDvf7z+LwvUoXC/wP8V2vp8ab/A//iqHFtmu8D8330+Nl+7wP3CTGARWLvE/qkfhehRu8T/j+6nx0q3xPxywcmiR7fE/VmQ7308t8j+PGARWDm3yP8jMzMzMrPI/AYGVQ4vs8j87NV66SSzzP3TpJjEIbPM/rZ3vp8ar8z/mUbgehevzPyAGgZVDK/Q/WbpJDAJr9D+SbhKDwKr0P8wi2/l+6vQ/BdejcD0q9T8+i2zn+2n1P3c/NV66qfU/sfP91Hjp9T/qp8ZLNyn2PyNcj8L1aPY/XRBYObSo9j+WxCCwcuj2P8946SYxKPc/CC2yne9n9z9C4XoUrqf3P3uVQ4ts5/c/tEkMAisn+D/u/dR46Wb4Pyeyne+npvg/YGZmZmbm+D+ZGi/dJCb5P9PO91PjZfk/DIPAyqGl+T9FN4lBYOX5P3/rUbgeJfo/uJ8aL91k+j/xU+Olm6T6PyoIrBxa5Po/ZLx0kxgk+z+dcD0K12P7P9YkBoGVo/s/ENnO91Pj+z9JjZduEiP8P4JBYOXQYvw/u/UoXI+i/D/1qfHSTeL8Py5eukkMIv0/ZxKDwMph/T+gxks3iaH9P9p6FK5H4f0/Ey/dJAYh/j9M46WbxGD+P4aXbhKDoP4/v0s3iUHg/j/4/////x//PzG0yHa+X/8/a2iR7Xyf/z+kHFpkO9//P29oke18DwBAi8L1KFwvAECoHFpkO08AQMV2vp8abwBA4dAi2/mOAED+KocW2a4AQBqF61G4zgBAN99PjZfuAEBUObTIdg4BQHCTGARWLgFAje18PzVOAUCqR+F6FG4BQMahRbbzjQFA4/up8dKtAUAAVg4tss0BQBywcmiR7QFAOQrXo3ANAkBWZDvfTy0CQHK+nxovTQJAjxgEVg5tAkCrcmiR7YwCQMjMzMzMrAJA5SYxCKzMAkABgZVDi+wCQB7b+X5qDANAOzVeukksA0BXj8L1KEwDQHTpJjEIbANAkUOLbOeLA0Ctne+nxqsDQMr3U+OlywNA5lG4HoXrA0ADrBxaZAsEQCAGgZVDKwRAPGDl0CJLBEBZukkMAmsEQHYUrkfhigRAkm4Sg8CqBECvyHa+n8oEQMwi2/l+6gRA6Hw/NV4KBUAF16NwPSoFQCIxCKwcSgVAPots5/tpBUBb5dAi24kFQHc/NV66qQVAlJmZmZnJBUCx8/3UeOkFQM1NYhBYCQZA6qfGSzcpBkAHAiuHFkkGQCNcj8L1aAZAQLbz/dSIBkBdEFg5tKgGQHlqvHSTyAZAlsQgsHLoBkCzHoXrUQgHQM946SYxKAdA7NJNYhBIB0AILbKd72cHQCWHFtnOhwdAQuF6FK6nB0BeO99PjccHQHuVQ4ts5wdAmO+nxksHCEC0SQwCKycIQNGjcD0KRwhA7v3UeOlmCEAKWDm0yIYIQCeyne+npghAQwwCK4fGCEBgZmZmZuYIQA==\",\"dtype\":\"float64\",\"order\":\"little\",\"shape\":[200]},\"top\":[6,0,4,2,5,5,8,5,13,10,6,10,9,9,15,8,10,9,3,11,6,5,7,7,3,3,4,4,5,3,2,5,5,2,1,0,2,2,2,3,1,1,1,2,2,0,0,0,0,0,0,1,1,0,0,0,1,1,1,1,1,0,0,1,0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1]},\"selected\":{\"id\":\"6069\"},\"selection_policy\":{\"id\":\"6070\"}},\"id\":\"6057\",\"type\":\"ColumnDataSource\"},{\"attributes\":{\"bottom\":{\"field\":\"bottom\"},\"fill_alpha\":{\"value\":0.1},\"fill_color\":{\"value\":\"#1f77b4\"},\"left\":{\"field\":\"left\"},\"line_alpha\":{\"value\":0.1},\"line_color\":{\"value\":null},\"line_width\":{\"value\":2},\"right\":{\"field\":\"right\"},\"top\":{\"field\":\"top\"}},\"id\":\"6060\",\"type\":\"Quad\"},{\"attributes\":{\"source\":{\"id\":\"6057\"}},\"id\":\"6062\",\"type\":\"CDSView\"},{\"attributes\":{\"data_source\":{\"id\":\"6057\"},\"glyph\":{\"id\":\"6059\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"6060\"},\"selection_glyph\":null,\"view\":{\"id\":\"6062\"}},\"id\":\"6061\",\"type\":\"GlyphRenderer\"},{\"attributes\":{\"callback\":null,\"mode\":\"vline\",\"renderers\":[{\"id\":\"6061\"}],\"tooltips\":\"<h3> hl_range: </h3> <h4>bin=@bins</h4> <h4>value=@top </h4>\"},\"id\":\"6073\",\"type\":\"HoverTool\"},{\"attributes\":{\"ticks\":[0.0,0.015562499999999986,0.031124999999999972,0.04668749999999996,0.062249999999999944,0.07781249999999992,0.09337499999999992,0.10893749999999991,0.12449999999999989,0.14006249999999987,0.15562499999999985,0.17118749999999985,0.18674999999999983,0.2023124999999998,0.21787499999999982,0.2334374999999998,0.24899999999999978,0.26456249999999976,0.28012499999999974,0.2956874999999997,0.3112499999999997,0.32681249999999973,0.3423749999999997,0.3579374999999997,0.37349999999999967,0.38906249999999964,0.4046249999999996,0.4201874999999996,0.43574999999999964,0.4513124999999996,0.4668749999999996,0.4824374999999996,0.49799999999999955,0.5135624999999996,0.5291249999999995,0.5446874999999995,0.5602499999999995,0.5758124999999995,0.5913749999999994,0.6069374999999995,0.6224999999999994,0.6380624999999994,0.6536249999999995,0.6691874999999994,0.6847499999999994,0.7003124999999993,0.7158749999999994,0.7314374999999993,0.7469999999999993,0.7625624999999994,0.7781249999999993,0.7936874999999993,0.8092499999999992,0.8248124999999993,0.8403749999999992,0.8559374999999992,0.8714999999999993,0.8870624999999992,0.9026249999999992,0.9181874999999992,0.9337499999999992,0.9493124999999991,0.9648749999999992,0.9804374999999991,0.9959999999999991,1.011562499999999,1.0271249999999992,1.042687499999999,1.058249999999999,1.073812499999999,1.089374999999999,1.104937499999999,1.120499999999999,1.136062499999999,1.151624999999999,1.167187499999999,1.1827499999999989,1.198312499999999,1.213874999999999,1.2294374999999989,1.2449999999999988,1.260562499999999,1.2761249999999988,1.2916874999999988,1.307249999999999,1.3228124999999988,1.3383749999999988,1.3539374999999987,1.3694999999999988,1.3850624999999988,1.4006249999999987,1.4161874999999988,1.4317499999999987,1.4473124999999987,1.4628749999999986,1.4784374999999987,1.4939999999999987,1.5095624999999986,1.5251249999999987,1.5406874999999987,1.5562499999999986,1.5718124999999985,1.5873749999999986,1.6029374999999986,1.6184999999999985,1.6340624999999986,1.6496249999999986,1.6651874999999985,1.6807499999999984,1.6963124999999986,1.7118749999999985,1.7274374999999984,1.7429999999999986,1.7585624999999985,1.7741249999999984,1.7896874999999983,1.8052499999999985,1.8208124999999984,1.8363749999999983,1.8519374999999982,1.8674999999999984,1.8830624999999983,1.8986249999999982,1.9141874999999984,1.9297499999999983,1.9453124999999982,1.9608749999999981,1.9764374999999983,1.9919999999999982,2.0075624999999984,2.023124999999998,2.038687499999998,2.0542499999999984,2.069812499999998,2.085374999999998,2.100937499999998,2.116499999999998,2.132062499999998,2.147624999999998,2.163187499999998,2.178749999999998,2.194312499999998,2.209874999999998,2.225437499999998,2.240999999999998,2.256562499999998,2.272124999999998,2.287687499999998,2.303249999999998,2.3188124999999977,2.334374999999998,2.349937499999998,2.3654999999999977,2.381062499999998,2.396624999999998,2.4121874999999977,2.427749999999998,2.443312499999998,2.4588749999999977,2.474437499999998,2.4899999999999975,2.5055624999999977,2.521124999999998,2.5366874999999975,2.5522499999999977,2.567812499999998,2.5833749999999975,2.5989374999999977,2.614499999999998,2.6300624999999975,2.6456249999999977,2.661187499999998,2.6767499999999975,2.6923124999999977,2.7078749999999974,2.7234374999999975,2.7389999999999977,2.7545624999999974,2.7701249999999975,2.7856874999999977,2.8012499999999974,2.8168124999999975,2.8323749999999976,2.8479374999999973,2.8634999999999975,2.8790624999999976,2.8946249999999973,2.9101874999999975,2.925749999999997,2.9413124999999973,2.9568749999999975,2.972437499999997,2.9879999999999973,3.0035624999999975,3.019124999999997,3.0346874999999973,3.0502499999999975,3.065812499999997,3.0813749999999973,3.096937499999997,3.112499999999997]},\"id\":\"6075\",\"type\":\"FixedTicker\"},{\"attributes\":{\"label\":{\"value\":\"hl_range\"},\"renderers\":[{\"id\":\"6061\"}]},\"id\":\"6072\",\"type\":\"LegendItem\"},{\"attributes\":{\"axis_label\":\"hl_range\",\"formatter\":{\"id\":\"6067\"},\"ticker\":{\"id\":\"6040\"}},\"id\":\"6039\",\"type\":\"LinearAxis\"},{\"attributes\":{\"bottom_units\":\"screen\",\"fill_alpha\":0.5,\"fill_color\":\"lightgrey\",\"left_units\":\"screen\",\"level\":\"overlay\",\"line_alpha\":1.0,\"line_color\":\"black\",\"line_dash\":[4,4],\"line_width\":2,\"right_units\":\"screen\",\"top_units\":\"screen\"},\"id\":\"6049\",\"type\":\"BoxAnnotation\"},{\"attributes\":{},\"id\":\"6044\",\"type\":\"WheelZoomTool\"},{\"attributes\":{},\"id\":\"6029\",\"type\":\"DataRange1d\"},{\"attributes\":{},\"id\":\"6067\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{\"axis_label\":\"hl_range\",\"formatter\":{\"id\":\"6065\"},\"ticker\":{\"id\":\"6075\"}},\"id\":\"6035\",\"type\":\"LinearAxis\"},{\"attributes\":{},\"id\":\"6031\",\"type\":\"LinearScale\"},{\"attributes\":{\"text\":\"\"},\"id\":\"6025\",\"type\":\"Title\"}],\"root_ids\":[\"6024\"]},\"title\":\"Bokeh Application\",\"version\":\"2.2.1\"}};\n",
       "  var render_items = [{\"docid\":\"f1e55476-7a3c-4479-a3fc-a2c5976d4c54\",\"root_ids\":[\"6024\"],\"roots\":{\"6024\":\"f8c176bf-eadc-42d2-9106-f87a961dbbbd\"}}];\n",
       "  root.Bokeh.embed.embed_items_notebook(docs_json, render_items);\n",
       "\n",
       "  }\n",
       "  if (root.Bokeh !== undefined) {\n",
       "    embed_document(root);\n",
       "  } else {\n",
       "    var attempts = 0;\n",
       "    var timer = setInterval(function(root) {\n",
       "      if (root.Bokeh !== undefined) {\n",
       "        clearInterval(timer);\n",
       "        embed_document(root);\n",
       "      } else {\n",
       "        attempts++;\n",
       "        if (attempts > 100) {\n",
       "          clearInterval(timer);\n",
       "          console.log(\"Bokeh: ERROR: Unable to run BokehJS code because BokehJS library is missing\");\n",
       "        }\n",
       "      }\n",
       "    }, 10, root)\n",
       "  }\n",
       "})(window);"
      ],
      "application/vnd.bokehjs_exec.v0+json": ""
     },
     "metadata": {
      "application/vnd.bokehjs_exec.v0+json": {
       "id": "6024"
      }
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "ax = mydata2['hl_range'][50:].plot.hist(bins=200, alpha=1.2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2000     0.0000\n",
       "2001     0.0000\n",
       "2002     0.0000\n",
       "2003     0.0000\n",
       "2004     0.0000\n",
       "          ...  \n",
       "21232    0.0150\n",
       "21233    0.0100\n",
       "21234    0.0175\n",
       "21235    0.0150\n",
       "21236    0.0175\n",
       "Name: hl_range, Length: 19237, dtype: float64"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mydata2['hl_range'][2000:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}