Guest User

Untitled

a guest
Sep 23rd, 2021
728
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 2.62 KB | None | 0 0
  1. #OPTION DATA
  2. import pandas as pd
  3. import datetime as dt
  4. import time
  5.  
  6. def download_opt_data(ticker,resolution,range_from,range_to):
  7.     """Use this function to pull options data from Fyers API.
  8.    Contains offset that will prevent the data limit breach"""
  9.  
  10.     yy = str(ticker['expiry_end'].year)[-2:]
  11.     m = str(ticker['expiry_end'].month)
  12.     dd = '{:02d}'.format(ticker['expiry_end'].day)
  13.     strike_price = ticker['range_lower']
  14.     options = []
  15.    
  16.     while strike_price <= ticker['range_upper']:
  17.         options.append(f"NSE:{ticker['root']}{yy}{m}{dd}{strike_price}CE")
  18.         options.append(f"NSE:{ticker['root']}{yy}{m}{dd}{strike_price}PE")
  19.         strike_price += ticker['increment']
  20.    
  21.     print(f'Loaded {len(options)} options')
  22.     count = 1
  23.    
  24.     for option in options:
  25.        
  26.         print(f'Doing {count}: {option}')
  27.        
  28.         symbol = option
  29.         resolution = str(resolution)
  30.  
  31.  
  32.         query = \
  33.                 {"symbol":symbol,
  34.                 "resolution":resolution,
  35.                 "date_format":"1",
  36.                 "range_from":range_from,
  37.                 "range_to":range_to,
  38.                 "cont_flag":"1"}
  39.  
  40.  
  41.         data = fyers.history(query)
  42.  
  43.         if data['s'] != 'ok':
  44.             print(data)
  45.             return 0
  46.  
  47.         df = pd.DataFrame.from_dict(data['candles'])
  48.  
  49.         df.columns = ['Date','Open','High','Low','Close','Volume']
  50.  
  51.         df['Date'] = pd.to_datetime(df['Date'],unit='s')
  52.         df['Date'] = df['Date'] + dt.timedelta(minutes = 330)
  53.         df['Expiry'] = ticker['expiry_end']
  54.         df['Symbol'] = symbol[4:]
  55.         df['Strike Price'] = symbol[-7:-2]
  56.  
  57.         df.to_csv(f"Data/{ticker['root']}_{ticker['expiry_end']}.csv",mode = 'a',index = False)
  58.        
  59.         if(count % 15 == 0):
  60.             print('Waiting...')
  61.             time.sleep(5)
  62.            
  63.         count += 1
  64.  
  65.     print('Done')
  66.  
  67.  
  68.  
  69. index = {
  70.     'banknifty' : {
  71.         'root': 'BANKNIFTY',
  72.         'increment':100,
  73.         'range_lower':30400,                        #EDIT  HERE
  74.         'range_upper':40900,                        #EDIT  HERE
  75.         'expiry_start' : dt.date(2021,6,16),        #EDIT  HERE
  76.         'expiry_end' : dt.date(2021,9,16)           #EDIT  HERE
  77.     },
  78.    
  79.     'nifty' : {
  80.         'root': 'NIFTY',
  81.         'increment':50,
  82.         'range_lower':18950,                        #EDIT  HERE
  83.         'range_upper':19000,                        #EDIT  HERE
  84.         'expiry_start' : dt.date(2021,6,16),        #EDIT  HERE
  85.         'expiry_end' : dt.date(2021,9,16)           #EDIT  HERE
  86.        
  87.     }
  88. }
  89.  
  90. download_opt_data(index['banknifty'],1,'2021-6-16','2021-9-16')         #EDIT  HERE
  91.                         #INDEX, RESOLUTION, START-DATE, END-DATE
Advertisement
Add Comment
Please, Sign In to add comment