Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #OPTION DATA
- import pandas as pd
- import datetime as dt
- import time
- def download_opt_data(ticker,resolution,range_from,range_to):
- """Use this function to pull options data from Fyers API.
- Contains offset that will prevent the data limit breach"""
- yy = str(ticker['expiry_end'].year)[-2:]
- m = str(ticker['expiry_end'].month)
- dd = '{:02d}'.format(ticker['expiry_end'].day)
- strike_price = ticker['range_lower']
- options = []
- while strike_price <= ticker['range_upper']:
- options.append(f"NSE:{ticker['root']}{yy}{m}{dd}{strike_price}CE")
- options.append(f"NSE:{ticker['root']}{yy}{m}{dd}{strike_price}PE")
- strike_price += ticker['increment']
- print(f'Loaded {len(options)} options')
- count = 1
- for option in options:
- print(f'Doing {count}: {option}')
- symbol = option
- resolution = str(resolution)
- query = \
- {"symbol":symbol,
- "resolution":resolution,
- "date_format":"1",
- "range_from":range_from,
- "range_to":range_to,
- "cont_flag":"1"}
- data = fyers.history(query)
- if data['s'] != 'ok':
- print(data)
- return 0
- df = pd.DataFrame.from_dict(data['candles'])
- df.columns = ['Date','Open','High','Low','Close','Volume']
- df['Date'] = pd.to_datetime(df['Date'],unit='s')
- df['Date'] = df['Date'] + dt.timedelta(minutes = 330)
- df['Expiry'] = ticker['expiry_end']
- df['Symbol'] = symbol[4:]
- df['Strike Price'] = symbol[-7:-2]
- df.to_csv(f"Data/{ticker['root']}_{ticker['expiry_end']}.csv",mode = 'a',index = False)
- if(count % 15 == 0):
- print('Waiting...')
- time.sleep(5)
- count += 1
- print('Done')
- index = {
- 'banknifty' : {
- 'root': 'BANKNIFTY',
- 'increment':100,
- 'range_lower':30400, #EDIT HERE
- 'range_upper':40900, #EDIT HERE
- 'expiry_start' : dt.date(2021,6,16), #EDIT HERE
- 'expiry_end' : dt.date(2021,9,16) #EDIT HERE
- },
- 'nifty' : {
- 'root': 'NIFTY',
- 'increment':50,
- 'range_lower':18950, #EDIT HERE
- 'range_upper':19000, #EDIT HERE
- 'expiry_start' : dt.date(2021,6,16), #EDIT HERE
- 'expiry_end' : dt.date(2021,9,16) #EDIT HERE
- }
- }
- download_opt_data(index['banknifty'],1,'2021-6-16','2021-9-16') #EDIT HERE
- #INDEX, RESOLUTION, START-DATE, END-DATE
Advertisement
Add Comment
Please, Sign In to add comment