GUI_script.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "6b521b2f",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-07-22T06:22:26.975826Z",
     "start_time": "2021-07-22T06:22:14.855546Z"
    },
    "scrolled": false
   },
   "outputs": [
    {
     "ename": "RuntimeError",
     "evalue": "module compiled against API version 0xe but this version of numpy is 0xd",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mRuntimeError\u001b[0m                              Traceback (most recent call last)",
      "\u001b[0;31mRuntimeError\u001b[0m: module compiled against API version 0xe but this version of numpy is 0xd"
     ]
    },
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "c8bdfa5033bd46a79ab170c78478dc6a",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "QgridWidget(grid_options={'fullWidthRows': True, 'syncColumnCellResize': True, 'forceFitColumns': True, 'defau…"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<pre style=\"white-space:pre;overflow-x:auto;line-height:normal;font-family:Menlo,'DejaVu Sans Mono',consolas,'Courier New',monospace\">LOGIN ZERODHA : Hemang Atulkumar Joshi\n",
       "</pre>\n"
      ],
      "text/plain": [
       "<rich.jupyter.JupyterRenderable at 0x7f669a30d250>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<pre style=\"white-space:pre;overflow-x:auto;line-height:normal;font-family:Menlo,'DejaVu Sans Mono',consolas,'Courier New',monospace\">LOGIN ZERODHA : Menandbhai Meramanbhai Shindhal\n",
       "</pre>\n"
      ],
      "text/plain": [
       "<rich.jupyter.JupyterRenderable at 0x7f66ce59f940>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<pre style=\"white-space:pre;overflow-x:auto;line-height:normal;font-family:Menlo,'DejaVu Sans Mono',consolas,'Courier New',monospace\">LOGIN ZERODHA : Rahul Karshanbhai Ram\n",
       "</pre>\n"
      ],
      "text/plain": [
       "<rich.jupyter.JupyterRenderable at 0x7f669a30dcd0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "from kiteconnect.exceptions import *\n",
    "\n",
    "from pyportmanlib import  *\n",
    "auth_df = pd.read_excel('./auth_info.xlsx')\n",
    "stocks_df = pd.read_excel('./stocks.xlsx')\n",
    "global_exchange_type = 'NSE'\n",
    "display(qgrid.show_grid(stocks_df))\n",
    "# display(qgrid.show_grid(auth_df))\n",
    "\n",
    "this_clients_group = my_clients_group(auth_df)\n",
    "\n",
    "this_clients_group.do_login_df()\n",
    "\n",
    "def make_global(x):\n",
    "    global xy\n",
    "    xy = x\n",
    "\n",
    "def get_holding_qty(user_name,symbol_name):\n",
    "    this_hld_list = globals()[user_name].get_holdings_list()\n",
    "    this_qty = 0\n",
    "    if(len(this_hld_list)>0):\n",
    "        for one_hld in this_hld_list:\n",
    "            if(symbol_name==one_hld.tradingsymbol):\n",
    "                this_qty+=one_hld.quantity + one_hld.t1_quantity\n",
    "    return this_qty\n",
    "\n",
    "def get_position_qty(user_name,symbol_name):\n",
    "    this_pos_list = globals()[user_name].get_positions_list()\n",
    "    this_qty = 0\n",
    "    if(len(this_pos_list)>0):\n",
    "        for one_pos in this_pos_list:\n",
    "            if(symbol_name==one_pos.tradingsymbol):\n",
    "                this_qty+=one_pos.buy_quantity - one_pos.sell_quantity\n",
    "    return this_qty\n",
    "\n",
    "for one_user in this_clients_group.user_list:\n",
    "    globals()[one_user.ac_name] = one_user\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "b80b70ca",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-07-22T07:43:21.431769Z",
     "start_time": "2021-07-22T06:22:27.046369Z"
    },
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<pre style=\"white-space:pre;overflow-x:auto;line-height:normal;font-family:Menlo,'DejaVu Sans Mono',consolas,'Courier New',monospace\">I am done\n",
       "</pre>\n"
      ],
      "text/plain": [
       "<rich.jupyter.JupyterRenderable at 0x7f6698f04730>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import PySimpleGUI as sg   \n",
    "import pandas as pd\n",
    "from collections import OrderedDict\n",
    "sg.theme('LightBrown10')    \n",
    "pd.set_option('display.max_columns', None)\n",
    "pd.set_option('display.max_rows', None)\n",
    "####################################### GTT ##########################################\n",
    "gtts_df = pd.read_excel('./plot_df/gtts.xlsx')\n",
    "gtts_df = gtts_df[['user','gtt_gtt_status','gtt_gtt_type',\n",
    "         'gtt_gtt_condition_tradingsymbol','gtt_gtt_condition_trigger_values_0',\n",
    "         'gtt_gtt_condition_trigger_values_1','gtt_gtt_orders_0_quantity',\n",
    "         'gtt_gtt_orders_0_transaction_type','gtt_gtt_id']]\n",
    "\n",
    "gtts_df.rename(columns={'gtt_gtt_status':'status',\n",
    "                        'gtt_gtt_type':'type',\n",
    "                        'gtt_gtt_condition_tradingsymbol':'symbol',\n",
    "                        'gtt_gtt_condition_trigger_values_0':'trigger_0',\n",
    "                        'gtt_gtt_condition_trigger_values_1':'trigger_1',\n",
    "                        'gtt_gtt_orders_0_quantity':'qty',\n",
    "                        'gtt_gtt_orders_0_transaction_type':'transaction',\n",
    "                        'gtt_gtt_id':'id',\n",
    "                        },\n",
    "          inplace=True, errors='raise')\n",
    "\n",
    "gtt_user_list = gtts_df.user.to_list()\n",
    "gtt_symbol_list = gtts_df.symbol.to_list()\n",
    "gtt_id_list = gtts_df.id.to_list()\n",
    "gtt_button_id_list = []\n",
    "gtt_counter = 0\n",
    "for one_symbol in gtt_symbol_list:\n",
    "    this_gtt_button_id = str('Delete:'+ str(gtt_user_list[gtt_counter])+':'+gtt_symbol_list[gtt_counter]+':'+str(gtt_id_list[gtt_counter])) \n",
    "    gtt_button_id_list.append(this_gtt_button_id)\n",
    "    gtt_counter+=1\n",
    "    \n",
    "gtts_main_list = []\n",
    "gtts_header_list = list(gtts_df.columns.values)\n",
    "gtts_header_widget_list = []\n",
    "for one_header in gtts_header_list:\n",
    "    gtts_header_widget_list.append(sg.Text(one_header, size=(10,1)))\n",
    "gtts_header_widget_list.append(sg.Button('Cancel_All_GTTs'))\n",
    "gtts_main_list.append(gtts_header_widget_list)\n",
    "temp_counter = 0\n",
    "for __,one_row in gtts_df.iterrows():\n",
    "    sec_list = []\n",
    "    for one_key in one_row.keys():\n",
    "        sec_list.append(sg.Text(one_row[one_key], size=(10,1)))\n",
    "    sec_list.append(sg.Button(gtt_button_id_list[temp_counter]))\n",
    "    gtts_main_list.append(sec_list)\n",
    "    temp_counter += 1\n",
    "    \n",
    "#### USER WISE gtts ###  \n",
    "gtts_users_list_non_repeating = list(OrderedDict.fromkeys(gtts_df.user.to_list()))\n",
    "gtts_users_wise_buttons_id_list = [ 'Delete:gtts:user:'+y for y in gtts_users_list_non_repeating ]\n",
    "gtts_users_wise_buttons_list  = [ sg.Button(y, size=(25,1)) for y in gtts_users_wise_buttons_id_list ]\n",
    "\n",
    "gtts_main_list.append([sg.HSeparator()])\n",
    "tp_counter = 0\n",
    "total_counter = 0\n",
    "temp_button_row = []\n",
    "for one_button in gtts_users_wise_buttons_list:\n",
    "    temp_button_row.append(one_button)\n",
    "    if(tp_counter%5==0 or total_counter==(len(gtts_users_wise_buttons_list)-1)):\n",
    "        tp_counter = 0\n",
    "        gtts_main_list.append(temp_button_row)\n",
    "        temp_button_row = []\n",
    "    tp_counter+=1\n",
    "    total_counter+=1\n",
    "\n",
    "#### SYMBOL WISE gtts ###\n",
    "gtts_symbol_list_non_repeating = list(OrderedDict.fromkeys(gtts_df.symbol.to_list()))\n",
    "gtts_symbol_wise_buttons_id_list = [ 'Delete:gtts:symbol:'+y for y in gtts_symbol_list_non_repeating ]\n",
    "gtts_symbol_wise_buttons_list  = [ sg.Button(y, size=(25,1)) for y in gtts_symbol_wise_buttons_id_list ]\n",
    "\n",
    "total_counter = 0\n",
    "gtts_main_list.append([sg.HSeparator()])\n",
    "tp_counter = 0\n",
    "temp_button_row = []\n",
    "for one_button in gtts_symbol_wise_buttons_list:\n",
    "    temp_button_row.append(one_button)\n",
    "    if(tp_counter%5==0 or total_counter==(len(gtts_symbol_wise_buttons_list)-1)):\n",
    "        tp_counter = 0\n",
    "        gtts_main_list.append(temp_button_row)\n",
    "        temp_button_row = []\n",
    "    tp_counter+=1\n",
    "    total_counter+=1\n",
    "    \n",
    "############################3####### HOLDING #########################################\n",
    "holding_df = pd.read_excel('./plot_df/holding.xlsx')\n",
    "\n",
    "user_list = holding_df.user.to_list()\n",
    "symbol_list = holding_df.hld_holding_tradingsymbol.to_list()\n",
    "holding_button_id_list = []\n",
    "holding_counter = 0\n",
    "for one_symbol in symbol_list:\n",
    "    this_hold_button_id = str('Exit:'+ str(user_list[holding_counter])+':hld:'+symbol_list[holding_counter]) \n",
    "    holding_button_id_list.append(this_hold_button_id)\n",
    "    holding_counter+=1\n",
    "\n",
    "holding_df = holding_df[['user','hld_tradingsymbol','hld_holding_opening_quantity',\n",
    "                         'hld_holding_pnl','hld_day_change_percentage']]\n",
    "\n",
    "holding_df.rename(columns={'hld_tradingsymbol':'symbol',\n",
    "                            'hld_holding_opening_quantity':'qty',\n",
    "                            'hld_holding_pnl':'pnl',\n",
    "                            'hld_day_change_percentage':'ch_percent'\n",
    "                             },\n",
    "          inplace=True, errors='raise')\n",
    "\n",
    "holding_df\n",
    "holding_main_list = []\n",
    "holding_header_list = list(holding_df.columns.values)\n",
    "holding_header_widget_list = []\n",
    "for one_header in holding_header_list:\n",
    "    holding_header_widget_list.append(sg.Text(one_header, size=(10,1)))\n",
    "holding_header_widget_list.append(sg.Button('EXIT_ALL_HOLDINGS'))\n",
    "holding_main_list.append(holding_header_widget_list)\n",
    "temp_counter = 0\n",
    "for __,one_row in holding_df.iterrows():\n",
    "    sec_list = []\n",
    "    for one_key in one_row.keys():\n",
    "        sec_list.append(sg.Text(one_row[one_key], size=(10,1)))\n",
    "    sec_list.append(sg.Button(holding_button_id_list[temp_counter]))\n",
    "    holding_main_list.append(sec_list)\n",
    "    temp_counter+=1\n",
    "\n",
    "#### USER WISE HOLDING ###  \n",
    "hld_users_list_non_repeating = list(OrderedDict.fromkeys(holding_df.user.to_list()))\n",
    "hld_users_wise_buttons_id_list = [ 'Exit:hld:user:'+y for y in hld_users_list_non_repeating ]\n",
    "hld_users_wise_buttons_list  = [ sg.Button(y, size=(25,1)) for y in hld_users_wise_buttons_id_list ]\n",
    "\n",
    "holding_main_list.append([sg.HSeparator()])\n",
    "tp_counter = 0\n",
    "total_counter = 0\n",
    "temp_button_row = []\n",
    "for one_button in hld_users_wise_buttons_list:\n",
    "    temp_button_row.append(one_button)\n",
    "    if(tp_counter%5==0 or total_counter==(len(hld_users_wise_buttons_list)-1)):\n",
    "        tp_counter = 0\n",
    "        holding_main_list.append(temp_button_row)\n",
    "        temp_button_row = []\n",
    "    tp_counter+=1\n",
    "    total_counter+=1\n",
    "\n",
    "#### SYMBOL WISE HOLDING ###\n",
    "hld_symbol_list_non_repeating = list(OrderedDict.fromkeys(holding_df.symbol.to_list()))\n",
    "hld_symbol_wise_buttons_id_list = [ 'Exit:hld:symbol:'+y for y in hld_symbol_list_non_repeating ]\n",
    "hld_symbol_wise_buttons_list  = [ sg.Button(y, size=(25,1)) for y in hld_symbol_wise_buttons_id_list ]\n",
    "\n",
    "total_counter = 0\n",
    "holding_main_list.append([sg.HSeparator()])\n",
    "tp_counter = 0\n",
    "temp_button_row = []\n",
    "for one_button in hld_symbol_wise_buttons_list:\n",
    "    temp_button_row.append(one_button)\n",
    "    if(tp_counter%5==0 or total_counter==(len(hld_symbol_wise_buttons_list)-1)):\n",
    "        tp_counter = 0\n",
    "        holding_main_list.append(temp_button_row)\n",
    "        temp_button_row = []\n",
    "    tp_counter+=1\n",
    "    total_counter+=1\n",
    "\n",
    "################################## POSITION #########################################\n",
    "position_df = pd.read_excel('./plot_df/positions.xlsx')\n",
    "position_df['qty'] = position_df['pos_buy_quantity'] - position_df['pos_sell_quantity']\n",
    "position_df.rename(columns={'pos_position_average_price': 'avg_price',\n",
    "                   'pos_tradingsymbol': 'symbol',\n",
    "                   'pos_position_value': 'value',\n",
    "                   'pos_position_pnl': 'pnl',\n",
    "                   'pos_unrealised': 'unreal',},\n",
    "          inplace=True, errors='raise')\n",
    "\n",
    "position_df = position_df[['user','symbol','qty',\n",
    "                           'avg_price','value',\n",
    "                           'pnl','unreal']]\n",
    "\n",
    "user_list = position_df.user.to_list()\n",
    "symbol_list = position_df.symbol.to_list()\n",
    "position_button_id_list = []\n",
    "position_counter = 0\n",
    "for one_symbol in symbol_list:\n",
    "    this_hold_button_id = str('Exit:'+ str(user_list[position_counter])+':'+'pos'+':'+symbol_list[position_counter]) \n",
    "    position_button_id_list.append(this_hold_button_id)\n",
    "    position_counter+=1\n",
    "position_button_id_list\n",
    "\n",
    "position_main_list = []\n",
    "position_header_list = list(position_df.columns.values)\n",
    "position_header_widget_list = []\n",
    "\n",
    "for one_header in position_header_list:\n",
    "    position_header_widget_list.append(sg.Text(one_header, size=(10,1)))\n",
    "position_main_list.append(position_header_widget_list)\n",
    "position_header_widget_list.append(sg.Button('EXIT_ALL_POSITIONS'))\n",
    "temp_counter = 0\n",
    "    \n",
    "for __,one_row in position_df.iterrows():\n",
    "    sec_list = []\n",
    "    for one_key in one_row.keys():\n",
    "        sec_list.append(sg.Text(one_row[one_key], size=(10,1)))\n",
    "    sec_list.append(sg.Button(position_button_id_list[temp_counter]))\n",
    "    position_main_list.append(sec_list)\n",
    "    temp_counter+=1\n",
    "    \n",
    "\n",
    "## USER WISE POSITION BUTTON ##\n",
    "pos_users_list_non_repeating = list(OrderedDict.fromkeys(position_df.user.to_list()))\n",
    "pos_users_wise_buttons_id_list = [ 'Exit:pos:user:'+y for y in pos_users_list_non_repeating ]\n",
    "pos_users_wise_buttons_list  = [ sg.Button(y, size=(25,1)) for y in pos_users_wise_buttons_id_list ]\n",
    "\n",
    "position_main_list.append([sg.HSeparator()])\n",
    "tp_counter = 0\n",
    "total_counter = 0\n",
    "temp_button_row = []\n",
    "for one_button in pos_users_wise_buttons_list:\n",
    "    temp_button_row.append(one_button)\n",
    "    if(tp_counter%5==0 or total_counter==(len(pos_users_wise_buttons_list)-1)):\n",
    "        tp_counter = 0\n",
    "        position_main_list.append(temp_button_row)\n",
    "        temp_button_row = []\n",
    "    tp_counter+=1\n",
    "    total_counter+=1\n",
    "### SYMBOL WISE POSITION  ### \n",
    "pos_symbol_list_non_repeating = list(OrderedDict.fromkeys(position_df.symbol.to_list()))\n",
    "pos_symbol_wise_buttons_id_list = ['Exit:pos:symbol:'+y for y in pos_symbol_list_non_repeating ]\n",
    "pos_symbol_wise_buttons_list  = [ sg.Button(y, size=(25,1)) for y in pos_symbol_wise_buttons_id_list ]\n",
    "\n",
    "position_main_list.append([sg.HSeparator()])\n",
    "tp_counter = 0\n",
    "total_counter = 0\n",
    "temp_button_row = []\n",
    "for one_button in pos_symbol_wise_buttons_list:\n",
    "    temp_button_row.append(one_button)\n",
    "    if(tp_counter%5==0 or total_counter==(len(pos_symbol_wise_buttons_list)-1)):\n",
    "        tp_counter = 0\n",
    "        position_main_list.append(temp_button_row)\n",
    "        temp_button_row = []\n",
    "    tp_counter+=1\n",
    "    total_counter+=1\n",
    "    \n",
    "####################################### STOCKS ##################################### \n",
    "stock_df = pd.read_excel('./stocks.xlsx')\n",
    "\n",
    "stock_main_list = []\n",
    "stock_header_list = list(stock_df.columns.values)\n",
    "stock_header_widget_list = []\n",
    "for one_header in stock_header_list:\n",
    "    stock_header_widget_list.append(sg.Text(one_header, size=(10,1)))\n",
    "stock_main_list.append(stock_header_widget_list)\n",
    "\n",
    "user_name_list_for_stock = []\n",
    "\n",
    "for one_user in this_clients_group.user_list:\n",
    "    user_name_list_for_stock.append(one_user.ac_name)\n",
    "\n",
    "for __,one_row in stock_df.iterrows():\n",
    "    sec_list = []\n",
    "    for one_key in one_row.keys():\n",
    "        sec_list.append(sg.Text(one_row[one_key], size=(10,1)))\n",
    "    \n",
    "    for each_user in user_name_list_for_stock:\n",
    "        sec_list.append(sg.Button(each_user,key=each_user+':'+one_row['symbol']+':buy_new:'+str(one_row['percent'])))\n",
    "    \n",
    "    stock_main_list.append(sec_list)\n",
    "    \n",
    "####@@@@@@@@@@@@@@@@@@@@@@@@@@ MAIN PROCESS @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@\n",
    "layout4 = [[sg.Button('Save Experience Details')]]\n",
    "tabgrp = [[sg.TabGroup([[sg.Tab('GTT', gtts_main_list,),\n",
    "                    sg.Tab('Holding', holding_main_list),\n",
    "                    sg.Tab('Position', position_main_list),\n",
    "                    sg.Tab('Stocks', stock_main_list),]])]]  \n",
    "\n",
    "window =sg.Window(\"Tabs\",\n",
    "                   resizable=True,\n",
    "                   finalize=True).Layout([[sg.Column(tabgrp, \n",
    "                                                     size=(1366,720),\n",
    "                                                     scrollable=True)]])\n",
    "\n",
    "\n",
    "####@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@\n",
    "\n",
    "\n",
    "######################## EVENT FUNCTION MANAGEMENT ################################\n",
    "while True:\n",
    "    event, values = window.read()\n",
    "    event_split_list=[]\n",
    "    if(event!=None):\n",
    "        event_split_list = event.split(':')\n",
    "######################################## GTT #####################################    \n",
    "    #### DELETING SINGLE GTT  ####\n",
    "    for one_gtt_id in gtt_button_id_list:\n",
    "        if event ==one_gtt_id :\n",
    "            print(f'Delete single gtt id : {event_split_list[3]}')\n",
    "            \n",
    "    ### CANCEL ALL GTTs ###\n",
    "    if event == 'Cancel_All_GTTs':\n",
    "        print('Cancel_All_GTTs')\n",
    "        \n",
    "    ## DELETE GTTs FOR A USER ####\n",
    "    if (('Delete' in event_split_list) and ('user' in event_split_list)):\n",
    "        print(f'Delete GTTs for user {event_split_list[3]}')\n",
    "        \n",
    "    ## DELETE GTTs FOR A SYMBOL ####\n",
    "    if (('Delete' in event_split_list) and ('symbol' in event_split_list)):\n",
    "        print(f'Delete GTTs for symbol {event_split_list[3]}')\n",
    "        \n",
    "######################################## HOLDING ####################################      \n",
    "    #### EXITING SINGLE HOLDING ####\n",
    "    for one_hld in holding_button_id_list:\n",
    "        if event == one_hld:\n",
    "            userip = event_split_list[1]\n",
    "            symbol = event_split_list[3]\n",
    "            this_hld_qty = get_holding_qty(userip,symbol)\n",
    "            print(f'Exit single holding : {userip} : {symbol} : {this_hld_qty}')\n",
    "            try:\n",
    "                this_message = globals()[userip].zerodha_user.place_order(globals()[userip].zerodha_user.VARIETY_REGULAR,\n",
    "                                                                            global_exchange_type,symbol,\n",
    "                                                                            globals()[userip].zerodha_user.TRANSACTION_TYPE_SELL,\n",
    "                                                                            this_hld_qty,\n",
    "                                                                            globals()[userip].zerodha_user.PRODUCT_CNC,\n",
    "                                                                            globals()[userip].zerodha_user.ORDER_TYPE_MARKET\n",
    "                                                                           )\n",
    "                print(this_message)\n",
    "            except InputException as ipxcp:\n",
    "                print(ipxcp)\n",
    "            except GeneralException as ipxcp:\n",
    "                print(ipxcp)\n",
    "    \n",
    "    ### EXIT ALL HOLDINGS@MARKET ####\n",
    "    if event == 'EXIT_ALL_HOLDINGS':\n",
    "        print('EXIT_ALL_HOLDINGS')\n",
    "        \n",
    "    ## DELETE HOLDINGS FOR A USER ####\n",
    "    if (('Exit' in event_split_list) and ('user' in event_split_list) and ('hld' in event_split_list)):\n",
    "        print(f'Exit holdings for user {event_split_list[3]}')\n",
    "        \n",
    "    ## DELETE HOLDINGS FOR A SYMBOL ####\n",
    "    if (('Exit' in event_split_list) and ('symbol' in event_split_list) and ('hld' in event_split_list)):\n",
    "        print(f'Exit holdings for symbol {event_split_list[3]}')\n",
    "    \n",
    "######################################## POSITION ####################################      \n",
    "    #### EXITING SINGLE POSITIONS ####\n",
    "    for one_pos in position_button_id_list:\n",
    "        if event == one_pos:\n",
    "            userip = event_split_list[1]\n",
    "            symbol = event_split_list[3]\n",
    "            this_pos_qty = get_position_qty(userip,symbol)\n",
    "            print(f'Exit single position : {userip} : {symbol} : {this_pos_qty}')\n",
    "            try:\n",
    "                \n",
    "                this_message = globals()[userip].zerodha_user.place_order( globals()[userip].zerodha_user.VARIETY_REGULAR,\n",
    "                                                                            global_exchange_type,symbol,\n",
    "                                                                            globals()[userip].zerodha_user.TRANSACTION_TYPE_SELL,\n",
    "                                                                            this_pos_qty,\n",
    "                                                                            globals()[userip].zerodha_user.PRODUCT_CNC,\n",
    "                                                                            globals()[userip].zerodha_user.ORDER_TYPE_MARKET\n",
    "                                                                           )\n",
    "                print(this_message)\n",
    "            except InputException as ipxcp:\n",
    "                print(ipxcp)\n",
    "            except GeneralException as ipxcp:\n",
    "                print(ipxcp)\n",
    "            \n",
    "            \n",
    "    \n",
    "    ### EXIT ALL POSITIONS@MARKET ####\n",
    "    if event == 'EXIT_ALL_POSITIONS':\n",
    "        print('EXIT_ALL_POSITIONS')\n",
    "        \n",
    "    ## DELETE POSITIONS FOR A USER ####\n",
    "    if (('Exit' in event_split_list) and ('user' in event_split_list) and ('pos' in event_split_list)):\n",
    "        print(f'Exit position for user {event_split_list[3]}')\n",
    "        \n",
    "    ## DELETE POSITIONS FOR A SYMBOL ####\n",
    "    if (('Exit' in event_split_list) and ('symbol' in event_split_list) and ('pos' in event_split_list)):\n",
    "        print(f'Exit position for symbol {event_split_list[3]}')\n",
    "    \n",
    "    if event == sg.WIN_CLOSED:\n",
    "        print(\"I am done\")\n",
    "        break\n",
    "        \n",
    "    if event == 'add_button':\n",
    "        this_column_ip.AddRow(sg.InputText(),)\n",
    "        this_column_ip.Update([sg.InputText()])\n",
    "        \n",
    "        \n",
    "################################# STOCKS PAGE ######################################\n",
    "    if('buy_new' in event_split_list):\n",
    "        \n",
    "        userip = event_split_list[0]\n",
    "        symbol = event_split_list[1]\n",
    "        percent = float(event_split_list[3])\n",
    "        \n",
    "        avail_margin = globals()[userip].zerodha_user.margins()['equity']['available']['cash']\n",
    "        this_ltp = globals()[userip].zerodha_user.quote(f'NSE:{symbol}')[f'NSE:{symbol}']['last_price']\n",
    "        this_qty = int((avail_margin*(percent/100))/this_ltp)\n",
    "        \n",
    "        print(f'Exit single position : {userip} : {symbol} : {this_qty}')\n",
    "        try:\n",
    "            this_message = globals()[userip].zerodha_user.place_order( globals()[userip].zerodha_user.VARIETY_REGULAR,\n",
    "                                                                        global_exchange_type,symbol,\n",
    "                                                                        globals()[userip].zerodha_user.TRANSACTION_TYPE_BUY,\n",
    "                                                                        this_qty,\n",
    "                                                                        globals()[userip].zerodha_user.PRODUCT_CNC,\n",
    "                                                                        globals()[userip].zerodha_user.ORDER_TYPE_MARKET\n",
    "                                                                       )\n",
    "            print(this_message)\n",
    "        except InputException as ipxcp:\n",
    "            print(ipxcp)\n",
    "        except GeneralException as ipxcp:\n",
    "            print(ipxcp)\n",
    "\n",
    "\n",
    "window.Close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d7dc4e49",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-07-22T05:18:14.180523Z",
     "start_time": "2021-07-22T05:18:14.176946Z"
    }
   },
   "outputs": [],
   "source": [
    "window.Close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f7fabb5d",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-07-21T17:04:23.169019Z",
     "start_time": "2021-07-21T17:04:23.027440Z"
    }
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c49ebc38",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-07-22T05:10:17.276882Z",
     "start_time": "2021-07-22T05:10:04.610486Z"
    }
   },
   "outputs": [],
   "source": [
    "import PySimpleGUI as sg\n",
    "from alpha_vantage.timeseries import TimeSeries\n",
    "import time\n",
    "\n",
    "sg.theme('BluePurple')\n",
    "\n",
    "layout = [[sg.Text('Last Price', size=(20, 2), justification='center')],\n",
    "          [sg.Text('', size=(10, 2), font=('Helvetica', 20),\n",
    "                   justification='center', key='quote')]]\n",
    "\n",
    "window = sg.Window('MikeQuote', layout)\n",
    "av = TimeSeries(key = 'key')\n",
    "spy, _ = av.get_quote_endpoint(symbol='SPY')\n",
    "last = spy['05. price']\n",
    "yest = spy['08. previous close']\n",
    "wait = 1  # Wait is in seconds\n",
    "\n",
    "while True:\n",
    "    event, values = window.read(timeout=10)\n",
    "    if event in (None, 'Quit'):\n",
    "        break\n",
    "    spy, _ = av.get_quote_endpoint(symbol='SPY')\n",
    "    last = spy['05. price']\n",
    "    window['quote'].update(last)\n",
    "    time.sleep(wait)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "02cce439",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e0112a4b",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-07-22T05:19:08.578275Z",
     "start_time": "2021-07-22T05:19:06.757932Z"
    },
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "###### TABLE ADD ROW EXAMPLE ####\n",
    "\n",
    "import PySimpleGUI as sg\n",
    "# import PySimpleGUIQt as sg                # runs on Qt too\n",
    "\n",
    "def table_example():\n",
    "    data = [['a1', 'b1', 'c1', 'd1'],\n",
    "            ['a2', 'b2', 'c2', 'd2'],\n",
    "            ['a3', 'b3', 'c3', 'd3'],\n",
    "            ['a4', 'b4', 'c4', 'd4']]\n",
    "    header_list = ['Col1', 'Col2', 'Col3', 'Col4']\n",
    "\n",
    "    layout = [[sg.Table(values=data, headings=header_list, auto_size_columns=True,justification='center',\n",
    "                        num_rows=min(len(data), 20), display_row_numbers=True, key='table')],\n",
    "              [sg.Button('Add Row'), sg.CButton('Close')]]\n",
    "\n",
    "    window = sg.Window('Simple Table', layout)\n",
    "    while True:\n",
    "        event, values = window.Read()\n",
    "        if event in ('Close', None): break\n",
    "        if event == 'Add Row':\n",
    "            layout2 = [[sg.Text('Col1:', size=(8, 1)), sg.InputText(key='C1')],\n",
    "                       [sg.Text('Col2:', size=(8, 1)), sg.InputText(key='C2')],\n",
    "                       [sg.Text('Col3:', size=(8, 1)), sg.InputText(key='C3')],\n",
    "                       [sg.Text('Col4:', size=(8, 1)), sg.InputText(key='C4')],\n",
    "                       [sg.Button('Add'), sg.Button('Insert Pasted Values'), sg.Button('Close')]]\n",
    "\n",
    "            window2 = sg.Window('Row Addition', layout2)\n",
    "            while True:\n",
    "                event2, v2 = window2.Read()\n",
    "                print(event2, v2)\n",
    "                if event2 in ('Close', None): break\n",
    "                elif event2 == 'Add':\n",
    "                    data.append([v2['C1'], v2['C2'], v2['C3'], v2['C4']])\n",
    "                    window.FindElement('table').Update(values=data, num_rows=len(data))\n",
    "                    break\n",
    "                elif event2 == 'Insert Pasted Values':\n",
    "                    for key, value in {'C1': 'a5', 'C2': 'b5', 'C3': 'c5', 'C4': 'd5'}.items():\n",
    "                        window2.Element(key).Update(value)\n",
    "            window2.Close()\n",
    "table_example()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a2731bd1",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-07-22T05:13:58.636055Z",
     "start_time": "2021-07-22T05:13:58.630049Z"
    }
   },
   "outputs": [],
   "source": [
    "window.AllKeysDict.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a7c476ea",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-07-22T05:18:25.554943Z",
     "start_time": "2021-07-22T05:18:25.540460Z"
    }
   },
   "outputs": [],
   "source": [
    "window2.Close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "bc5561c4",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "hide_input": false,
  "kernelspec": {
   "display_name": "Python 3.9.5 64-bit",
   "language": "python",
   "name": "python395jvsc74a57bd0916dbcbb3f70747c44a77c7bcd40155683ae19c65e1c03b4aa3499c5328201f1"
  },
  "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.9.5"
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}