Skip to content

Commit 8e1359f

Browse files
authored
Create NiftyMonthOptions_OHLC_vol_OI
1 parent 9932922 commit 8e1359f

1 file changed

Lines changed: 93 additions & 0 deletions

File tree

‎NiftyMonthOptions_OHLC_vol_OI‎

Lines changed: 93 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,93 @@
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

Comments
 (0)