|
| 1 | +from kiteconnect import KiteConnect |
| 2 | +import datetime |
| 3 | +import pandas as pd |
| 4 | +import sys |
| 5 | +import time |
| 6 | +userdata = pd.read_csv("C://db//loginkey//userdata.csv") |
| 7 | +print(sys._getframe().f_lineno, "userdata", userdata) |
| 8 | + |
| 9 | +allusers = len(userdata.index.values) |
| 10 | +print(sys._getframe().f_lineno, "allusers", allusers) |
| 11 | + |
| 12 | +kites= [None] * allusers |
| 13 | +print(sys._getframe().f_lineno, "kites", kites) |
| 14 | + |
| 15 | +for i in range(0,allusers): |
| 16 | + try: |
| 17 | + api_key = userdata.loc[i, "api_key"] |
| 18 | + api_secret = userdata.loc[i, "api_secret"] |
| 19 | + request_token = userdata.loc[i, "request_token"] |
| 20 | + access_token = userdata.loc[i, "access_token"] |
| 21 | + public_token = userdata.loc[i, "public_token"] |
| 22 | + kitei = KiteConnect(api_key=api_key) |
| 23 | + kitei.set_access_token(access_token) |
| 24 | + kites[i] = kitei |
| 25 | + except Exception as e: |
| 26 | + print(" ERROR in api_key",i , e, datetime.datetime.now()) |
| 27 | +print(sys._getframe().f_lineno, "kites", kites) |
| 28 | + |
| 29 | +print(sys._getframe().f_lineno, "user data loaded..........", datetime.datetime.now()) |
| 30 | + |
| 31 | + |
| 32 | +df_opinst = pd.read_csv("https://api.kite.trade/instruments") |
| 33 | +df_opinst = df_opinst[df_opinst['tradingsymbol'].str.startswith("NIFTY20")] |
| 34 | +df_opinst = df_opinst[df_opinst['segment'] == "NFO-OPT"] |
| 35 | +df_opinst['expiry'] = pd.to_datetime(df_opinst['expiry']) |
| 36 | +month = datetime.datetime.today().month |
| 37 | +monthly_expdate = [30, 27, 26, 30, 28, 25, 30, 27, 24, 29, 26, 31] # last date each month |
| 38 | +exp_date = monthly_expdate[datetime.datetime.today().month - 1] # -1 as index start from 0 and month from 1 |
| 39 | +exp_date = '2020-{}-{}'.format(month, exp_date) |
| 40 | +exp_date = datetime.datetime.strptime(exp_date, '%Y-%m-%d') |
| 41 | +df_opinst = df_opinst[~(df_opinst['expiry'] > exp_date + datetime.timedelta(days=2))] |
| 42 | +df_opinst = df_opinst[(df_opinst['expiry'] > exp_date - datetime.timedelta(days=2))] |
| 43 | +print("expiry date ", df_opinst,df_opinst.columns.values) |
| 44 | + |
| 45 | +NSELTPformate=['NFO:{}'.format(i) for i in df_opinst.tradingsymbol.values] |
| 46 | +OHLCdict = kites[0].quote(NSELTPformate) |
| 47 | +print(OHLCdict) |
| 48 | + |
| 49 | +df = pd.DataFrame(columns=['tradingsymbol', 'instrument_token', 'timestamp', 'last_price', 'open', 'high', 'low', 'close', 'volume', 'oi']) |
| 50 | + |
| 51 | +print("Waiting to get open price..........", datetime.datetime.now()) |
| 52 | +opentime = int(9) * 60 + int(15) |
| 53 | +closetime = int(15) * 60 + int(30) |
| 54 | +timenow = (datetime.datetime.now().hour * 60 + datetime.datetime.now().minute) |
| 55 | +while timenow < opentime: |
| 56 | + time.sleep(2) |
| 57 | + timenow = (datetime.datetime.now().hour * 60 + datetime.datetime.now().minute) |
| 58 | + |
| 59 | +keep_running = True |
| 60 | +while keep_running : |
| 61 | + try : |
| 62 | + dfi = pd.DataFrame(columns=['tradingsymbol', 'instrument_token', 'timestamp', 'last_price', 'open', 'high', 'low', 'close', |
| 63 | + 'volume', 'oi']) |
| 64 | + for key, value in OHLCdict.items(): |
| 65 | + try: |
| 66 | + tradingsymbol = key.split(":")[1] |
| 67 | + instrument_token = value['instrument_token'] |
| 68 | + timestamp = value['timestamp'] |
| 69 | + last_price = value['last_price'] |
| 70 | + volume = value['volume'] |
| 71 | + oi = value['oi'] |
| 72 | + value2 = value['ohlc'] |
| 73 | + open = value2['open'] |
| 74 | + high = value2['high'] |
| 75 | + low = value2['low'] |
| 76 | + close = value2['close'] |
| 77 | + #print(tradingsymbol, instrument_token, last_price, open, high, low, close) |
| 78 | + dfi.loc[len(dfi)] = [tradingsymbol, instrument_token, timestamp, last_price, open, high, low, close, |
| 79 | + volume, oi] |
| 80 | + df = df.append(dfi, ignore_index=True) |
| 81 | + df.to_csv("C://db//options//JAN2020.csv") |
| 82 | + print(len(df),datetime.datetime.now()) |
| 83 | + time.sleep(3) |
| 84 | + except Exception as e: |
| 85 | + print(e) |
| 86 | + timenow = (datetime.datetime.now().hour * 60 + datetime.datetime.now().minute) |
| 87 | + if timenow > closetime : |
| 88 | + print("Time is above closetime") |
| 89 | + keep_running = False |
| 90 | + print("keep_running = ", keep_running) |
| 91 | + |
| 92 | + except Exception as e: |
| 93 | + print("ERROR", e) |
0 commit comments