Automate Trades in Upstox Utilizing Free of Cost API in Python

Get List of All FNO Stocks:


For Instructions Follow the Video then go For the Code Input:


All FNO Stocks from NSE Website: "AARTIIND", "ABB", "ABBOTINDIA", "ABCAPITAL", "ABFRL", "ACC", "ADANIENT", "ADANIPORTS", "ALKEM", "AMBUJACEM", "APOLLOHOSP", "APOLLOTYRE", "ASHOKLEY", "ASIANPAINT", "ASTRAL", "ATUL", "AUBANK", "AUROPHARMA", "AXISBANK", "BAJAJ-AUTO", "BAJAJFINSV", "BAJFINANCE", "BALKRISIND", "BALRAMCHIN", "BANDHANBNK", "BANKBARODA", "BATAINDIA", "BEL", "BERGEPAINT", "BHARATFORG", "BHARTIARTL", "BHEL", "BIOCON", "BOSCHLTD", "BPCL", "BRITANNIA", "BSOFT", "CANBK", "CANFINHOME", "CHAMBLFERT", "CHOLAFIN", "CIPLA", "COALINDIA", "COFORGE", "COLPAL", "CONCOR", "COROMANDEL", "CROMPTON", "CUB", "CUMMINSIND", "DABUR", "DALBHARAT", "DEEPAKNTR", "DIVISLAB", "DIXON", "DLF", "DRREDDY", "EICHERMOT", "ESCORTS", "EXIDEIND", "FEDERALBNK", "GAIL", "GLENMARK", "GMRINFRA", "GNFC", "GODREJCP", "GODREJPROP", "GRANULES", "GRASIM", "GUJGASLTD", "HAL", "HAVELLS", "HCLTECH", "HDFCAMC", "HDFCBANK", "HDFCLIFE", "HEROMOTOCO", "HINDALCO", "HINDCOPPER", "HINDPETRO", "HINDUNILVR", "ICICIBANK", "ICICIGI", "ICICIPRULI", "IDEA", "IDFC", "IDFCFIRSTB", "IEX", "IGL", "INDHOTEL", "INDIACEM", "INDIAMART", "INDIGO", "INDUSINDBK", "INDUSTOWER", "INFY", "IOC", "IPCALAB", "IRCTC", "ITC", "JINDALSTEL", "JKCEMENT", "JSWSTEEL", "JUBLFOOD", "KOTAKBANK", "LALPATHLAB", "LAURUSLABS", "LICHSGFIN", "LT", "LTF", "LTIM", "LTTS", "LUPIN", "M&M", "M&MFIN", "MANAPPURAM", "MARICO", "MARUTI", "MCX", "METROPOLIS", "MFSL", "MGL", "MOTHERSON", "MPHASIS", "MRF", "MUTHOOTFIN", "NATIONALUM", "NAUKRI", "NAVINFLUOR", "NESTLEIND", "NMDC", "NTPC", "OBEROIRLTY", "OFSS", "ONGC", "PAGEIND", "PEL", "PERSISTENT", "PETRONET", "PFC", "PIDILITIND", "PIIND", "PNB", "POLYCAB", "POWERGRID", "PVRINOX", "RAMCOCEM", "RBLBANK", "RECLTD", "RELIANCE", "SAIL", "SBICARD", "SBILIFE", "SBIN", "SHREECEM", "SHRIRAMFIN", "SIEMENS", "SRF", "SUNPHARMA", "SUNTV", "SYNGENE", "TATACHEM", "TATACOMM", "TATACONSUM", "TATAMOTORS", "TATAPOWER", "TATASTEEL", "TCS", "TECHM", "TITAN", "TORNTPHARM", "TRENT", "TVSMOTOR", "UBL", "ULTRACEMCO", "UNITDSPR", "UPL", "VEDL", "VOLTAS", "WIPRO", "ZYDUSLIFE"


import pandas as pd  
symbol='BANKNIFTY247105'
option_type='CE'
instruments=pd.read_csv('https://assets.upstox.com/market-quote/instruments/exchange/complete.csv.gz')
tradingsymbol=instruments[(instruments['tradingsymbol'].str.contains(symbol))
&(instruments['tradingsymbol'].str.contains(option_type))
&(instruments['last_price'].round()==9)]
tradingsymbol=tradingsymbol[['tradingsymbol','last_price']]
print(tradingsymbol['tradingsymbol'].iloc[0])

Get Option TradingSymbol Relevant to Last Price without Iteration:


For Instructions Follow the Video then go For the Code Input:



import pandas as pd  
instruments=pd.read_csv('https://assets.upstox.com/market-quote/instruments/exchange/complete.csv.gz')
instruments=instruments[instruments['instrument_type']=='FUTSTK']
tradingsymbol=instruments['tradingsymbol'].sort_values().str.extract(r'([A-Z-&]+)').drop_duplicates()
print(len(tradingsymbol[1:]),tradingsymbol[1:].to_string(index=False))


Output: AARTIIND ABB ABBOTINDIA ABCAPITAL ABFRL ACC ADANIENT ADANIPORTS ALKEM AMBUJACEM APOLLOHOSP APOLLOTYRE ASHOKLEY ASIANPAINT ASTRAL ATUL AUBANK AUROPHARMA AXISBANK BAJAJ-AUTO BAJAJFINSV BAJFINANCE BALKRISIND BALRAMCHIN BANDHANBNK BANKBARODA BATAINDIA BEL BERGEPAINT BHARATFORG BHARTIARTL BHEL BIOCON BOSCHLTD BPCL BRITANNIA BSOFT CANBK CANFINHOME CHAMBLFERT CHOLAFIN CIPLA COALINDIA COFORGE COLPAL CONCOR COROMANDEL CROMPTON CUB CUMMINSIND DABUR DALBHARAT DEEPAKNTR DIVISLAB DIXON DLF DRREDDY EICHERMOT ESCORTS EXIDEIND FEDERALBNK GAIL GLENMARK GMRINFRA GNFC GODREJCP GODREJPROP GRANULES GRASIM GUJGASLTD HAL HAVELLS HCLTECH HDFCAMC HDFCBANK HDFCLIFE HEROMOTOCO HINDALCO HINDCOPPER HINDPETRO HINDUNILVR ICICIBANK ICICIGI ICICIPRULI IDEA IDFC IDFCFIRSTB IEX IGL INDHOTEL INDIACEM INDIAMART INDIGO INDUSINDBK INDUSTOWER INFY IOC IPCALAB IRCTC ITC JINDALSTEL JKCEMENT JSWSTEEL JUBLFOOD KOTAKBANK LALPATHLAB LAURUSLABS LICHSGFIN LT LTF LTIM LTTS LUPIN M&M M&MFIN MANAPPURAM MARICO MARUTI MCX METROPOLIS MFSL MGL MOTHERSON MPHASIS MRF MUTHOOTFIN NATIONALUM NAUKRI NAVINFLUOR NESTLEIND NMDC NTPC OBEROIRLTY OFSS ONGC PAGEIND PEL PERSISTENT PETRONET PFC PIDILITIND PIIND PNB POLYCAB POWERGRID PVRINOX RAMCOCEM RBLBANK RECLTD RELIANCE SAIL SBICARD SBILIFE SBIN SHREECEM SHRIRAMFIN SIEMENS SRF SUNPHARMA SUNTV SYNGENE TATACHEM TATACOMM TATACONSUM TATAMOTORS TATAPOWER TATASTEEL TCS TECHM TITAN TORNTPHARM TRENT TVSMOTOR UBL ULTRACEMCO UNITDSPR UPL VEDL VOLTAS WIPRO ZYDUSLIFE

Fetch ATM|OTM|ITM Data:


For Instructions Follow the Video then go For the Code Input:



import pandas as pd 
import requests
import sys
access_token=open('C:/Users/VIKASH/Desktop/upstox/upa/access_token.txt').read().strip()
headers={
       'Authorization':f'Bearer: {access_token}'
}
index='NSE_INDEX|Nifty Bank'
#instruments=pd.read_csv('https://assets.upstox.com/market-quote/instruments/exchange/complete.csv.gz')
instruments=pd.read_csv('instruments.csv')
#last_price=instruments[instruments['name']==index]
#print(last_price['last_price'])
#sys.exit()
spotsymbol='BANKNIFTY'
option_type='CE'
strike_level=100
market_quote=requests.get(f'https://api.upstox.com/v2/market-quote/ltp?symbol={index}',headers=headers)
strike_price=100*round(market_quote.json()['data']['NSE_INDEX:Nifty Bank']['last_price']/100)
tradingsymbol=spotsymbol+'24JUN'+str(strike_price+strike_level)+option_type
instrument_key=instruments[instruments['tradingsymbol']==tradingsymbol]
instrument_key=instrument_key['instrument_key'].iloc[0]
OTM=requests.get(f'https://api.upstox.com/v2/market-quote/ltp?symbol={instrument_key}',headers=headers)
print(OTM.json()['data'][f'NSE_FO:{tradingsymbol}']['instrument_token'])

Retrieve Market Quote such as Full Market Quote|OHLC|LTP in Python:


For Instructions Follow the Video then go For the Code Input:



import pandas as pd 
import requests
access_token=open('C:/Users/VIKASH/Desktop/upstox/upa/access_token.txt').read().strip()
headers={
       'Authorization':f'Bearer: {access_token}'
}
instruments=pd.read_csv('https://assets.upstox.com/market-quote/instruments/exchange/complete.csv.gz')
spotsymbol='BANKNIFTY'
strike='50000'
option_type='CE'
def get_instrument_key(spotsymbol,strike,option_type):
       instruments['tradingsymbol']=instruments['tradingsymbol'].fillna('')
       instrument_key=instruments[(instruments['tradingsymbol'].str.contains(spotsymbol))
       &(instruments['tradingsymbol'].str.contains(strike))
              &(instruments['tradingsymbol'].str.contains(option_type))].sort_values('expiry')
       return instrument_key['instrument_key'].iloc[0]
key=get_instrument_key(spotsymbol,strike,option_type)
market_quote=requests.get(f'https://api.upstox.com/v2/market-quote/ltp?symbol={key}&interval=1d',headers=headers)
print(market_quote.json()['data']['NSE_FO:BANKNIFTY2461950000CE']['last_price'])

Fetch Premium Based TradingSymbol:


For Instructions Follow the Video then go For the Code Input:



#BANKNIFTY+YYMMDD+STRIKEPRICE+CE
#Index(['instrument_key', 'exchange_token', 'tradingsymbol', 'name',
       #'last_price', 'expiry', 'strike', 'tick_size', 'lot_size',
       #'instrument_type', 'option_type', 'exchange'],
      #dtype='object')
spotsymbol='BANKNIFTY'
expiry='19'
CE=False
PE=True
premium={}
price=10.0
import pandas as pd  
#instruments=pd.read_csv('https://assets.upstox.com/market-quote/instruments/exchange/complete.csv.gz')
instruments=pd.read_csv('instruments.csv')
instruments['tradingsymbol']=instruments['tradingsymbol'].fillna('')
tradingsymbol=instruments[(instruments['tradingsymbol'].str.contains(spotsymbol))
&(instruments['expiry'].str.contains(expiry))]
if PE:
       CET=tradingsymbol.sort_values('tradingsymbol',ascending=False)
       CES=CET['tradingsymbol'].to_list()
       CEP=CET['last_price'].round().to_list()
       for x,y in zip(CEP,CES):
              premium.update({x:y})
print(premium[8.0][-2:])


Fetch Instrument Key of Trading Symbol Using Upstox API in Python:


For Instructions Follow the Video then go For Code Input:


Sample Output HTML Table Given Below this need to Processed Further for Sorting and Fetching the Desired Instrument Key:


instrument_key exchange_token tradingsymbol name last_price expiry strike tick_size lot_size instrument_type option_type exchange
4055 NSE_EQ|INF174K01F59 5851.0 BANKNIFTY1 KOTAKMAMC-KOTAKBKETF 511.69 NaN NaN 0.01 1.0 EQUITY NaN NSE_EQ
7706 NSE_FO|38469 38469.0 BANKNIFTY24AUG42000PE NaN 63.10 2024-08-28 42000.0 0.05 15.0 OPTIDX PE NSE_FO
7750 NSE_FO|38855 38855.0 BANKNIFTY24JUL39500CE NaN 8525.20 2024-07-31 39500.0 0.05 15.0 OPTIDX CE NSE_FO
7751 NSE_FO|38856 38856.0 BANKNIFTY24JUL39500PE NaN 16.75 2024-07-31 39500.0 0.05 15.0 OPTIDX PE NSE_FO
7752 NSE_FO|38859 38859.0 BANKNIFTY24JUL40000CE NaN 8989.85 2024-07-31 40000.0 0.05 15.0 OPTIDX CE NSE_FO
7753 NSE_FO|38860 38860.0 BANKNIFTY24JUL40000PE NaN 24.45 2024-07-31 40000.0 0.05 15.0 OPTIDX PE NSE_FO
7773 NSE_FO|39006 39006.0 BANKNIFTY24JUL40500CE NaN 8510.15 2024-07-31 40500.0 0.05 15.0 OPTIDX CE NSE_FO
7774 NSE_FO|39007 39007.0 BANKNIFTY24JUL40500PE NaN 23.00 2024-07-31 40500.0 0.05 15.0 OPTIDX PE NSE_FO
7775 NSE_FO|39008 39008.0 BANKNIFTY24JUL41000CE NaN 8034.10 2024-07-31 41000.0 0.05 15.0 OPTIDX CE NSE_FO
7776 NSE_FO|39009 39009.0 BANKNIFTY24JUL41000PE NaN 29.00 2024-07-31 41000.0 0.05 15.0 OPTIDX PE NSE_FO
7777 NSE_FO|39010 39010.0 BANKNIFTY24JUL41500CE NaN 7562.75 2024-07-31 41500.0 0.05 15.0 OPTIDX CE NSE_FO
7778 NSE_FO|39011 39011.0 BANKNIFTY24JUL41500PE NaN 32.00 2024-07-31 41500.0 0.05 15.0 OPTIDX PE NSE_FO
7793 NSE_FO|39075 39075.0 BANKNIFTY24JUN43800CE NaN 5549.85 2024-06-26 43800.0 0.05 15.0 OPTIDX CE NSE_FO
7794 NSE_FO|39076 39076.0 BANKNIFTY24JUN43800PE NaN 8.75 2024-06-26 43800.0 0.05 15.0 OPTIDX PE NSE_FO
7938 NSE_FO|39408 39408.0 BANKNIFTY24JUN43900CE NaN 5452.60 2024-06-26 43900.0 0.05 15.0 OPTIDX CE NSE_FO
7941 NSE_FO|39411 39411.0 BANKNIFTY24JUN43900PE NaN 30.90 2024-06-26 43900.0 0.05 15.0 OPTIDX PE NSE_FO
8063 NSE_FO|39677 39677.0 BANKNIFTY24AUG42500CE NaN 6853.85 2024-08-28 42500.0 0.05 15.0 OPTIDX CE NSE_FO
8064 NSE_FO|39678 39678.0 BANKNIFTY24AUG42500PE NaN 104.35 2024-08-28 42500.0 0.05 15.0 OPTIDX PE NSE_FO
8069 NSE_FO|39740 39740.0 BANKNIFTY24JUL42000CE NaN 7097.10 2024-07-31 42000.0 0.05 15.0 OPTIDX CE NSE_FO
8080 NSE_FO|39835 39835.0 BANKNIFTY24JUN44000CE NaN 5895.55 2024-06-26 44000.0 0.05 15.0 OPTIDX CE NSE_FO
8081 NSE_FO|39837 39837.0 BANKNIFTY24JUN44000PE NaN 10.40 2024-06-26 44000.0 0.05 15.0 OPTIDX PE NSE_FO
8082 NSE_FO|39838 39838.0 BANKNIFTY24JUN44100CE NaN 5259.65 2024-06-26 44100.0 0.05 15.0 OPTIDX CE NSE_FO
8083 NSE_FO|39839 39839.0 BANKNIFTY24JUN44100PE NaN 13.35 2024-06-26 44100.0 0.05 15.0 OPTIDX PE NSE_FO
8102 NSE_FO|39983 39983.0 BANKNIFTY24JUN44200CE NaN 5109.80 2024-06-26 44200.0 0.05 15.0 OPTIDX CE NSE_FO
8108 NSE_FO|39996 39996.0 BANKNIFTY24JUN44200PE NaN 20.00 2024-06-26 44200.0 0.05 15.0 OPTIDX PE NSE_FO
8158 NSE_FO|40536 40536.0 BANKNIFTY24JUL42000PE NaN 31.10 2024-07-31 42000.0 0.05 15.0 OPTIDX PE NSE_FO
8165 NSE_FO|40595 40595.0 BANKNIFTY24AUG43000CE NaN 6393.85 2024-08-28 43000.0 0.05 15.0 OPTIDX CE NSE_FO
8166 NSE_FO|40596 40596.0 BANKNIFTY24AUG43000PE NaN 137.00 2024-08-28 43000.0 0.05 15.0 OPTIDX PE NSE_FO
8167 NSE_FO|40615 40615.0 BANKNIFTY24JUN44300CE NaN 5737.70 2024-06-26 44300.0 0.05 15.0 OPTIDX CE NSE_FO
8168 NSE_FO|40616 40616.0 BANKNIFTY24JUN44300PE NaN 9.50 2024-06-26 44300.0 0.05 15.0 OPTIDX PE NSE_FO
8169 NSE_FO|40617 40617.0 BANKNIFTY24JUN44400CE NaN 4936.50 2024-06-26 44400.0 0.05 15.0 OPTIDX CE NSE_FO
8170 NSE_FO|40620 40620.0 BANKNIFTY24JUN44400PE NaN 12.25 2024-06-26 44400.0 0.05 15.0 OPTIDX PE NSE_FO
8171 NSE_FO|40667 40667.0 BANKNIFTY24JUN44500CE NaN 5550.00 2024-06-26 44500.0 0.05 15.0 OPTIDX CE NSE_FO
8172 NSE_FO|40672 40672.0 BANKNIFTY24JUN44500PE NaN 11.65 2024-06-26 44500.0 0.05 15.0 OPTIDX PE NSE_FO
9173 NSE_FO|46475 46475.0 BANKNIFTY24AUG49400CE NaN 1765.95 2024-08-28 49400.0 0.05 15.0 OPTIDX CE NSE_FO
9174 NSE_FO|46476 46476.0 BANKNIFTY24AUG49400PE NaN 1000.00 2024-08-28 49400.0 0.05 15.0 OPTIDX PE NSE_FO
9176 NSE_FO|46479 46479.0 BANKNIFTY24AUG49500CE NaN 1968.10 2024-08-28 49500.0 0.05 15.0 OPTIDX CE NSE_FO
9463 NSE_FO|46936 46936.0 BANKNIFTY24JUN47700PE NaN 85.35 2024-06-26 47700.0 0.05 15.0 OPTIDX PE NSE_FO
9464 NSE_FO|46937 46937.0 BANKNIFTY24JUN47800CE NaN 2210.45 2024-06-26 47800.0 0.05 15.0 OPTIDX CE NSE_FO
9471 NSE_FO|46944 46944.0 BANKNIFTY24JUN47800PE NaN 93.45 2024-06-26 47800.0 0.05 15.0 OPTIDX PE NSE_FO
9474 NSE_FO|46947 46947.0 BANKNIFTY24JUN47900CE NaN 2122.75 2024-06-26 47900.0 0.05 15.0 OPTIDX CE NSE_FO
9555 NSE_FO|47180 47180.0 BANKNIFTY24JUN47900PE NaN 104.20 2024-06-26 47900.0 0.05 15.0 OPTIDX PE NSE_FO
9556 NSE_FO|47185 47185.0 BANKNIFTY24JUN48100CE NaN 1916.60 2024-06-26 48100.0 0.05 15.0 OPTIDX CE NSE_FO
9557 NSE_FO|47186 47186.0 BANKNIFTY24JUN48100PE NaN 125.45 2024-06-26 48100.0 0.05 15.0 OPTIDX PE NSE_FO
9558 NSE_FO|47187 47187.0 BANKNIFTY24JUN48200CE NaN 1839.90 2024-06-26 48200.0 0.05 15.0 OPTIDX CE NSE_FO
9575 NSE_FO|47236 47236.0 BANKNIFTY24AUG49500PE NaN 1045.85 2024-08-28 49500.0 0.05 15.0 OPTIDX PE NSE_FO
9576 NSE_FO|47237 47237.0 BANKNIFTY24AUG49600CE NaN 1673.20 2024-08-28 49600.0 0.05 15.0 OPTIDX CE NSE_FO
9577 NSE_FO|47239 47239.0 BANKNIFTY24AUG49600PE NaN 1878.55 2024-08-28 49600.0 0.05 15.0 OPTIDX PE NSE_FO
9578 NSE_FO|47244 47244.0 BANKNIFTY24AUG49700CE NaN 1889.75 2024-08-28 49700.0 0.05 15.0 OPTIDX CE NSE_FO
9579 NSE_FO|47245 47245.0 BANKNIFTY24AUG49700PE NaN 1363.15 2024-08-28 49700.0 0.05 15.0 OPTIDX PE NSE_FO
9580 NSE_FO|47246 47246.0 BANKNIFTY24AUG49800CE NaN 1583.95 2024-08-28 49800.0 0.05 15.0 OPTIDX CE NSE_FO
9745 NSE_FO|47612 47612.0 BANKNIFTY24AUG49800PE NaN 1269.55 2024-08-28 49800.0 0.05 15.0 OPTIDX PE NSE_FO
9746 NSE_FO|47616 47616.0 BANKNIFTY24AUG49900CE NaN 2549.50 2024-08-28 49900.0 0.05 15.0 OPTIDX CE NSE_FO
9747 NSE_FO|47618 47618.0 BANKNIFTY24AUG49900PE NaN 1218.35 2024-08-28 49900.0 0.05 15.0 OPTIDX PE NSE_FO
9748 NSE_FO|47619 47619.0 BANKNIFTY24AUG50000CE NaN 1687.90 2024-08-28 50000.0 0.05 15.0 OPTIDX CE NSE_FO
9749 NSE_FO|47620 47620.0 BANKNIFTY24AUG50000PE NaN 1269.60 2024-08-28 50000.0 0.05 15.0 OPTIDX PE NSE_FO
9750 NSE_FO|47621 47621.0 BANKNIFTY24AUG50100CE NaN 1456.35 2024-08-28 50100.0 0.05 15.0 OPTIDX CE NSE_FO
9831 NSE_FO|48095 48095.0 BANKNIFTY24AUG52200PE NaN 3522.30 2024-08-28 52200.0 0.05 15.0 OPTIDX PE NSE_FO
9832 NSE_FO|48099 48099.0 BANKNIFTY24AUG52300CE NaN 741.00 2024-08-28 52300.0 0.05 15.0 OPTIDX CE NSE_FO
9833 NSE_FO|48100 48100.0 BANKNIFTY24AUG52300PE NaN 3597.65 2024-08-28 52300.0 0.05 15.0 OPTIDX PE NSE_FO
9834 NSE_FO|48101 48101.0 BANKNIFTY24AUG52400CE NaN 716.80 2024-08-28 52400.0 0.05 15.0 OPTIDX CE NSE_FO
9835 NSE_FO|48102 48102.0 BANKNIFTY24AUG52400PE NaN 3671.70 2024-08-28 52400.0 0.05 15.0 OPTIDX PE NSE_FO
9836 NSE_FO|48103 48103.0 BANKNIFTY24AUG52500CE NaN 693.30 2024-08-28 52500.0 0.05 15.0 OPTIDX CE NSE_FO
9837 NSE_FO|48104 48104.0 BANKNIFTY24AUG52500PE NaN 3000.00 2024-08-28 52500.0 0.05 15.0 OPTIDX PE NSE_FO
9838 NSE_FO|48107 48107.0 BANKNIFTY24AUG52600CE NaN 670.40 2024-08-28 52600.0 0.05 15.0 OPTIDX CE NSE_FO
9839 NSE_FO|48108 48108.0 BANKNIFTY24AUG52600PE NaN 3821.70 2024-08-28 52600.0 0.05 15.0 OPTIDX PE NSE_FO
9840 NSE_FO|48109 48109.0 BANKNIFTY24AUG52700CE NaN 648.15 2024-08-28 52700.0 0.05 15.0 OPTIDX CE NSE_FO
9841 NSE_FO|48110 48110.0 BANKNIFTY24AUG52700PE NaN 3897.60 2024-08-28 52700.0 0.05 15.0 OPTIDX PE NSE_FO
9842 NSE_FO|48111 48111.0 BANKNIFTY24AUG52800CE NaN 624.35 2024-08-28 52800.0 0.05 15.0 OPTIDX CE NSE_FO
9843 NSE_FO|48114 48114.0 BANKNIFTY24AUG52800PE NaN 3972.05 2024-08-28 52800.0 0.05 15.0 OPTIDX PE NSE_FO
9844 NSE_FO|48115 48115.0 BANKNIFTY24AUG52900CE NaN 603.15 2024-08-28 52900.0 0.05 15.0 OPTIDX CE NSE_FO
9845 NSE_FO|48119 48119.0 BANKNIFTY24AUG52900PE NaN 4049.05 2024-08-28 52900.0 0.05 15.0 OPTIDX PE NSE_FO
9846 NSE_FO|48120 48120.0 BANKNIFTY24AUG53000CE NaN 513.05 2024-08-28 53000.0 0.05 15.0 OPTIDX CE NSE_FO
9847 NSE_FO|48130 48130.0 BANKNIFTY24AUG53000PE NaN 4126.60 2024-08-28 53000.0 0.05 15.0 OPTIDX PE NSE_FO
9848 NSE_FO|48131 48131.0 BANKNIFTY24AUG53100CE NaN 562.50 2024-08-28 53100.0 0.05 15.0 OPTIDX CE NSE_FO
9849 NSE_FO|48133 48133.0 BANKNIFTY24AUG53100PE NaN 4204.75 2024-08-28 53100.0 0.05 15.0 OPTIDX PE NSE_FO
9850 NSE_FO|48134 48134.0 BANKNIFTY24AUG53200CE NaN 543.05 2024-08-28 53200.0 0.05 15.0 OPTIDX CE NSE_FO
9851 NSE_FO|48146 48146.0 BANKNIFTY24AUG53200PE NaN 4283.50 2024-08-28 53200.0 0.05 15.0 OPTIDX PE NSE_FO
9852 NSE_FO|48148 48148.0 BANKNIFTY24AUG53300CE NaN 524.10 2024-08-28 53300.0 0.05 15.0 OPTIDX CE NSE_FO
9853 NSE_FO|48153 48153.0 BANKNIFTY24AUG53300PE NaN 4362.80 2024-08-28 53300.0 0.05 15.0 OPTIDX PE NSE_FO
9854 NSE_FO|48154 48154.0 BANKNIFTY24AUG53400CE NaN 505.75 2024-08-28 53400.0 0.05 15.0 OPTIDX CE NSE_FO
9855 NSE_FO|48162 48162.0 BANKNIFTY24AUG53400PE NaN 4442.60 2024-08-28 53400.0 0.05 15.0 OPTIDX PE NSE_FO
9856 NSE_FO|48163 48163.0 BANKNIFTY24AUG53500CE NaN 925.00 2024-08-28 53500.0 0.05 15.0 OPTIDX CE NSE_FO
9857 NSE_FO|48164 48164.0 BANKNIFTY24AUG53500PE NaN 4522.95 2024-08-28 53500.0 0.05 15.0 OPTIDX PE NSE_FO
9858 NSE_FO|48165 48165.0 BANKNIFTY24AUG53600CE NaN 470.60 2024-08-28 53600.0 0.05 15.0 OPTIDX CE NSE_FO
9859 NSE_FO|48166 48166.0 BANKNIFTY24AUG53600PE NaN 4603.85 2024-08-28 53600.0 0.05 15.0 OPTIDX PE NSE_FO
9860 NSE_FO|48167 48167.0 BANKNIFTY24AUG53700CE NaN 453.75 2024-08-28 53700.0 0.05 15.0 OPTIDX CE NSE_FO
9861 NSE_FO|48168 48168.0 BANKNIFTY24AUG53700PE NaN 4685.25 2024-08-28 53700.0 0.05 15.0 OPTIDX PE NSE_FO
9862 NSE_FO|48169 48169.0 BANKNIFTY24AUG53800CE NaN 437.45 2024-08-28 53800.0 0.05 15.0 OPTIDX CE NSE_FO
9863 NSE_FO|48173 48173.0 BANKNIFTY24AUG53800PE NaN 4767.15 2024-08-28 53800.0 0.05 15.0 OPTIDX PE NSE_FO
9864 NSE_FO|48174 48174.0 BANKNIFTY24AUG53900CE NaN 421.65 2024-08-28 53900.0 0.05 15.0 OPTIDX CE NSE_FO
9865 NSE_FO|48175 48175.0 BANKNIFTY24AUG53900PE NaN 4849.50 2024-08-28 53900.0 0.05 15.0 OPTIDX PE NSE_FO
9866 NSE_FO|48179 48179.0 BANKNIFTY24AUG54000CE NaN 500.00 2024-08-28 54000.0 0.05 15.0 OPTIDX CE NSE_FO
9867 NSE_FO|48180 48180.0 BANKNIFTY24AUG54000PE NaN 4932.40 2024-08-28 54000.0 0.05 15.0 OPTIDX PE NSE_FO
9870 NSE_FO|48205 48205.0 BANKNIFTY24AUG54500CE NaN 336.50 2024-08-28 54500.0 0.05 15.0 OPTIDX CE NSE_FO
9871 NSE_FO|48206 48206.0 BANKNIFTY24AUG54500PE NaN 5353.55 2024-08-28 54500.0 0.05 15.0 OPTIDX PE NSE_FO
9872 NSE_FO|48207 48207.0 BANKNIFTY24AUG55000CE NaN 260.00 2024-08-28 55000.0 0.05 15.0 OPTIDX CE NSE_FO
9873 NSE_FO|48208 48208.0 BANKNIFTY24AUG55000PE NaN 5785.15 2024-08-28 55000.0 0.05 15.0 OPTIDX PE NSE_FO
9874 NSE_FO|48209 48209.0 BANKNIFTY24AUG55500CE NaN 447.00 2024-08-28 55500.0 0.05 15.0 OPTIDX CE NSE_FO
9875 NSE_FO|48210 48210.0 BANKNIFTY24AUG55500PE NaN 6225.95 2024-08-28 55500.0 0.05 15.0 OPTIDX PE NSE_FO
9877 NSE_FO|48214 48214.0 BANKNIFTY24AUG56000CE NaN 184.80 2024-08-28 56000.0 0.05 15.0 OPTIDX CE NSE_FO
9878 NSE_FO|48215 48215.0 BANKNIFTY24AUG56000PE NaN 6674.85 2024-08-28 56000.0 0.05 15.0 OPTIDX PE NSE_FO
9880 NSE_FO|48218 48218.0 BANKNIFTY24AUG56500CE NaN 149.70 2024-08-28 56500.0 0.05 15.0 OPTIDX CE NSE_FO
9881 NSE_FO|48219 48219.0 BANKNIFTY24AUG56500PE NaN 7130.75 2024-08-28 56500.0 0.05 15.0 OPTIDX PE NSE_FO
9882 NSE_FO|48220 48220.0 BANKNIFTY24AUG57000CE NaN 225.00 2024-08-28 57000.0 0.05 15.0 OPTIDX CE NSE_FO
9883 NSE_FO|48221 48221.0 BANKNIFTY24AUG57000PE NaN 7592.65 2024-08-28 57000.0 0.05 15.0 OPTIDX PE NSE_FO
9884 NSE_FO|48222 48222.0 BANKNIFTY24AUG57500CE NaN 319.25 2024-08-28 57500.0 0.05 15.0 OPTIDX CE NSE_FO
9885 NSE_FO|48223 48223.0 BANKNIFTY24AUG57500PE NaN 8059.65 2024-08-28 57500.0 0.05 15.0 OPTIDX PE NSE_FO
9886 NSE_FO|48224 48224.0 BANKNIFTY24AUG58000CE NaN 247.00 2024-08-28 58000.0 0.05 15.0 OPTIDX CE NSE_FO
9887 NSE_FO|48225 48225.0 BANKNIFTY24AUG58000PE NaN 8531.05 2024-08-28 58000.0 0.05 15.0 OPTIDX PE NSE_FO
9888 NSE_FO|48226 48226.0 BANKNIFTY24AUG58500CE NaN 63.50 2024-08-28 58500.0 0.05 15.0 OPTIDX CE NSE_FO
9889 NSE_FO|48231 48231.0 BANKNIFTY24AUG58500PE NaN 9006.10 2024-08-28 58500.0 0.05 15.0 OPTIDX PE NSE_FO
9902 NSE_FO|48475 48475.0 BANKNIFTY24JUL43000CE NaN 7210.00 2024-07-31 43000.0 0.05 15.0 OPTIDX CE NSE_FO
9903 NSE_FO|48476 48476.0 BANKNIFTY24JUN48200PE NaN 137.20 2024-06-26 48200.0 0.05 15.0 OPTIDX PE NSE_FO
9904 NSE_FO|48477 48477.0 BANKNIFTY24JUN48300CE NaN 1749.30 2024-06-26 48300.0 0.05 15.0 OPTIDX CE NSE_FO
10067 NSE_FO|49860 49860.0 BANKNIFTY24JUL43000PE NaN 41.15 2024-07-31 43000.0 0.05 15.0 OPTIDX PE NSE_FO
10099 NSE_FO|50247 50247.0 BANKNIFTY24JUL43500CE NaN 6500.00 2024-07-31 43500.0 0.05 15.0 OPTIDX CE NSE_FO
10102 NSE_FO|50260 50260.0 BANKNIFTY24JUL43500PE NaN 51.25 2024-07-31 43500.0 0.05 15.0 OPTIDX PE NSE_FO
10103 NSE_FO|50273 50273.0 BANKNIFTY24JUL43900CE NaN 5402.35 2024-07-31 43900.0 0.05 15.0 OPTIDX CE NSE_FO
10104 NSE_FO|50278 50278.0 BANKNIFTY24JUL43900PE NaN 95.80 2024-07-31 43900.0 0.05 15.0 OPTIDX PE NSE_FO
10105 NSE_FO|50280 50280.0 BANKNIFTY24JUL44000CE NaN 6363.00 2024-07-31 44000.0 0.05 15.0 OPTIDX CE NSE_FO
10106 NSE_FO|50289 50289.0 BANKNIFTY24JUL44000PE NaN 57.50 2024-07-31 44000.0 0.05 15.0 OPTIDX PE NSE_FO
10107 NSE_FO|50290 50290.0 BANKNIFTY24JUL44100CE NaN 5232.85 2024-07-31 44100.0 0.05 15.0 OPTIDX CE NSE_FO
10108 NSE_FO|50295 50295.0 BANKNIFTY24JUL44100PE NaN 168.90 2024-07-31 44100.0 0.05 15.0 OPTIDX PE NSE_FO
10109 NSE_FO|50298 50298.0 BANKNIFTY24JUL44200CE NaN 3443.10 2024-07-31 44200.0 0.05 15.0 OPTIDX CE NSE_FO
10110 NSE_FO|50299 50299.0 BANKNIFTY24JUL44200PE NaN 302.00 2024-07-31 44200.0 0.05 15.0 OPTIDX PE NSE_FO
10111 NSE_FO|50300 50300.0 BANKNIFTY24JUL44300CE NaN 5765.00 2024-07-31 44300.0 0.05 15.0 OPTIDX CE NSE_FO
10112 NSE_FO|50301 50301.0 BANKNIFTY24JUL44300PE NaN 316.65 2024-07-31 44300.0 0.05 15.0 OPTIDX PE NSE_FO
10113 NSE_FO|50302 50302.0 BANKNIFTY24JUL44400CE NaN 5136.35 2024-07-31 44400.0 0.05 15.0 OPTIDX CE NSE_FO
10114 NSE_FO|50303 50303.0 BANKNIFTY24JUL44400PE NaN 331.80 2024-07-31 44400.0 0.05 15.0 OPTIDX PE NSE_FO
10157 NSE_FO|50371 50371.0 BANKNIFTY24JUL46300CE NaN 4036.80 2024-07-31 46300.0 0.05 15.0 OPTIDX CE NSE_FO
10158 NSE_FO|50374 50374.0 BANKNIFTY24JUL46300PE NaN 187.15 2024-07-31 46300.0 0.05 15.0 OPTIDX PE NSE_FO
10234 NSE_FO|50504 50504.0 BANKNIFTY24JUL49400PE NaN 853.50 2024-07-31 49400.0 0.05 15.0 OPTIDX PE NSE_FO
10235 NSE_FO|50505 50505.0 BANKNIFTY24JUL49500CE NaN 1539.15 2024-07-31 49500.0 0.05 15.0 OPTIDX CE NSE_FO
10236 NSE_FO|50510 50510.0 BANKNIFTY24JUL49500PE NaN 887.05 2024-07-31 49500.0 0.05 15.0 OPTIDX PE NSE_FO
10237 NSE_FO|50511 50511.0 BANKNIFTY24JUL49600CE NaN 1488.70 2024-07-31 49600.0 0.05 15.0 OPTIDX CE NSE_FO
10238 NSE_FO|50512 50512.0 BANKNIFTY24JUL49600PE NaN 928.85 2024-07-31 49600.0 0.05 15.0 OPTIDX PE NSE_FO
10239 NSE_FO|50513 50513.0 BANKNIFTY24JUL49700CE NaN 1416.55 2024-07-31 49700.0 0.05 15.0 OPTIDX CE NSE_FO
10240 NSE_FO|50514 50514.0 BANKNIFTY24JUL49700PE NaN 967.40 2024-07-31 49700.0 0.05 15.0 OPTIDX PE NSE_FO
10241 NSE_FO|50515 50515.0 BANKNIFTY24JUL49800CE NaN 1382.20 2024-07-31 49800.0 0.05 15.0 OPTIDX CE NSE_FO
10242 NSE_FO|50516 50516.0 BANKNIFTY24JUL49800PE NaN 1023.40 2024-07-31 49800.0 0.05 15.0 OPTIDX PE NSE_FO
10243 NSE_FO|50517 50517.0 BANKNIFTY24JUL49900CE NaN 1304.50 2024-07-31 49900.0 0.05 15.0 OPTIDX CE NSE_FO
10244 NSE_FO|50518 50518.0 BANKNIFTY24JUL49900PE NaN 1053.65 2024-07-31 49900.0 0.05 15.0 OPTIDX PE NSE_FO
10245 NSE_FO|50519 50519.0 BANKNIFTY24JUL50000CE NaN 1264.75 2024-07-31 50000.0 0.05 15.0 OPTIDX CE NSE_FO
10246 NSE_FO|50520 50520.0 BANKNIFTY24JUL50000PE NaN 1092.30 2024-07-31 50000.0 0.05 15.0 OPTIDX PE NSE_FO
10247 NSE_FO|50521 50521.0 BANKNIFTY24JUL50100CE NaN 1142.60 2024-07-31 50100.0 0.05 15.0 OPTIDX CE NSE_FO
10248 NSE_FO|50522 50522.0 BANKNIFTY24JUN48600PE NaN 198.40 2024-06-26 48600.0 0.05 15.0 OPTIDX PE NSE_FO
10249 NSE_FO|50524 50524.0 BANKNIFTY24JUL50100PE NaN 1145.65 2024-07-31 50100.0 0.05 15.0 OPTIDX PE NSE_FO
10252 NSE_FO|50531 50531.0 BANKNIFTY24JUN48700CE NaN 1429.70 2024-06-26 48700.0 0.05 15.0 OPTIDX CE NSE_FO
10254 NSE_FO|50533 50533.0 BANKNIFTY24JUN48700PE NaN 216.20 2024-06-26 48700.0 0.05 15.0 OPTIDX PE NSE_FO
10255 NSE_FO|50534 50534.0 BANKNIFTY24JUN48800CE NaN 1333.70 2024-06-26 48800.0 0.05 15.0 OPTIDX CE NSE_FO
10256 NSE_FO|50535 50535.0 BANKNIFTY24JUN48800PE NaN 236.95 2024-06-26 48800.0 0.05 15.0 OPTIDX PE NSE_FO
10257 NSE_FO|50536 50536.0 BANKNIFTY24JUN48900CE NaN 1259.15 2024-06-26 48900.0 0.05 15.0 OPTIDX CE NSE_FO
10263 NSE_FO|50542 50542.0 BANKNIFTY24JUL50200CE NaN 1167.65 2024-07-31 50200.0 0.05 15.0 OPTIDX CE NSE_FO
10274 NSE_FO|50558 50558.0 BANKNIFTY24JUL50200PE NaN 1188.95 2024-07-31 50200.0 0.05 15.0 OPTIDX PE NSE_FO
10275 NSE_FO|50559 50559.0 BANKNIFTY24JUL50300CE NaN 1115.00 2024-07-31 50300.0 0.05 15.0 OPTIDX CE NSE_FO
10276 NSE_FO|50567 50567.0 BANKNIFTY24JUL50300PE NaN 1194.35 2024-07-31 50300.0 0.05 15.0 OPTIDX PE NSE_FO
10277 NSE_FO|50570 50570.0 BANKNIFTY24JUL50400CE NaN 1090.00 2024-07-31 50400.0 0.05 15.0 OPTIDX CE NSE_FO
10278 NSE_FO|50571 50571.0 BANKNIFTY24JUL50400PE NaN 1195.05 2024-07-31 50400.0 0.05 15.0 OPTIDX PE NSE_FO
10279 NSE_FO|50572 50572.0 BANKNIFTY24JUL50500CE NaN 1024.30 2024-07-31 50500.0 0.05 15.0 OPTIDX CE NSE_FO
10280 NSE_FO|50573 50573.0 BANKNIFTY24JUL50500PE NaN 1335.55 2024-07-31 50500.0 0.05 15.0 OPTIDX PE NSE_FO
10281 NSE_FO|50576 50576.0 BANKNIFTY24JUL50600CE NaN 955.40 2024-07-31 50600.0 0.05 15.0 OPTIDX CE NSE_FO
10282 NSE_FO|50579 50579.0 BANKNIFTY24JUL50600PE NaN 3594.75 2024-07-31 50600.0 0.05 15.0 OPTIDX PE NSE_FO
10283 NSE_FO|50580 50580.0 BANKNIFTY24JUL50700CE NaN 933.70 2024-07-31 50700.0 0.05 15.0 OPTIDX CE NSE_FO
10284 NSE_FO|50581 50581.0 BANKNIFTY24JUL50700PE NaN 1465.20 2024-07-31 50700.0 0.05 15.0 OPTIDX PE NSE_FO
10285 NSE_FO|50584 50584.0 BANKNIFTY24JUL50800CE NaN 900.00 2024-07-31 50800.0 0.05 15.0 OPTIDX CE NSE_FO
10286 NSE_FO|50585 50585.0 BANKNIFTY24JUL50800PE NaN 3720.85 2024-07-31 50800.0 0.05 15.0 OPTIDX PE NSE_FO
10287 NSE_FO|50591 50591.0 BANKNIFTY24JUL50900CE NaN 781.40 2024-07-31 50900.0 0.05 15.0 OPTIDX CE NSE_FO
10288 NSE_FO|50592 50592.0 BANKNIFTY24JUL50900PE NaN 3799.35 2024-07-31 50900.0 0.05 15.0 OPTIDX PE NSE_FO
10289 NSE_FO|50593 50593.0 BANKNIFTY24JUL51000CE NaN 815.35 2024-07-31 51000.0 0.05 15.0 OPTIDX CE NSE_FO
10290 NSE_FO|50594 50594.0 BANKNIFTY24JUL51000PE NaN 1628.35 2024-07-31 51000.0 0.05 15.0 OPTIDX PE NSE_FO
10291 NSE_FO|50595 50595.0 BANKNIFTY24JUL51100CE NaN 752.00 2024-07-31 51100.0 0.05 15.0 OPTIDX CE NSE_FO
10292 NSE_FO|50596 50596.0 BANKNIFTY24JUL51100PE NaN 1723.20 2024-07-31 51100.0 0.05 15.0 OPTIDX PE NSE_FO
10293 NSE_FO|50603 50603.0 BANKNIFTY24JUL51200CE NaN 885.00 2024-07-31 51200.0 0.05 15.0 OPTIDX CE NSE_FO
10294 NSE_FO|50604 50604.0 BANKNIFTY24JUL51200PE NaN 2346.35 2024-07-31 51200.0 0.05 15.0 OPTIDX PE NSE_FO
10295 NSE_FO|50605 50605.0 BANKNIFTY24JUL51300CE NaN 841.00 2024-07-31 51300.0 0.05 15.0 OPTIDX CE NSE_FO
10296 NSE_FO|50608 50608.0 BANKNIFTY24JUL51300PE NaN 1771.85 2024-07-31 51300.0 0.05 15.0 OPTIDX PE NSE_FO
10297 NSE_FO|50609 50609.0 BANKNIFTY24JUL51400CE NaN 730.00 2024-07-31 51400.0 0.05 15.0 OPTIDX CE NSE_FO
10298 NSE_FO|50610 50610.0 BANKNIFTY24JUL51400PE NaN 1835.90 2024-07-31 51400.0 0.05 15.0 OPTIDX PE NSE_FO
10299 NSE_FO|50613 50613.0 BANKNIFTY24JUL51500CE NaN 623.75 2024-07-31 51500.0 0.05 15.0 OPTIDX CE NSE_FO
10300 NSE_FO|50614 50614.0 BANKNIFTY24JUL51500PE NaN 1872.40 2024-07-31 51500.0 0.05 15.0 OPTIDX PE NSE_FO
10301 NSE_FO|50615 50615.0 BANKNIFTY24JUL51600CE NaN 578.40 2024-07-31 51600.0 0.05 15.0 OPTIDX CE NSE_FO
10302 NSE_FO|50616 50616.0 BANKNIFTY24JUL51600PE NaN 1968.55 2024-07-31 51600.0 0.05 15.0 OPTIDX PE NSE_FO
10303 NSE_FO|50617 50617.0 BANKNIFTY24JUL51700CE NaN 901.75 2024-07-31 51700.0 0.05 15.0 OPTIDX CE NSE_FO
10304 NSE_FO|50618 50618.0 BANKNIFTY24JUL51700PE NaN 2705.05 2024-07-31 51700.0 0.05 15.0 OPTIDX PE NSE_FO
10305 NSE_FO|50619 50619.0 BANKNIFTY24JUL51800CE NaN 874.35 2024-07-31 51800.0 0.05 15.0 OPTIDX CE NSE_FO
10306 NSE_FO|50620 50620.0 BANKNIFTY24JUL51800PE NaN 4520.50 2024-07-31 51800.0 0.05 15.0 OPTIDX PE NSE_FO
10307 NSE_FO|50621 50621.0 BANKNIFTY24JUL51900CE NaN 847.65 2024-07-31 51900.0 0.05 15.0 OPTIDX CE NSE_FO
10309 NSE_FO|50624 50624.0 BANKNIFTY24JUL51900PE NaN 2301.40 2024-07-31 51900.0 0.05 15.0 OPTIDX PE NSE_FO
10310 NSE_FO|50625 50625.0 BANKNIFTY24JUL52000CE NaN 474.00 2024-07-31 52000.0 0.05 15.0 OPTIDX CE NSE_FO
10311 NSE_FO|50626 50626.0 BANKNIFTY24JUL52000PE NaN 2274.90 2024-07-31 52000.0 0.05 15.0 OPTIDX PE NSE_FO
10312 NSE_FO|50627 50627.0 BANKNIFTY24JUL52100CE NaN 796.10 2024-07-31 52100.0 0.05 15.0 OPTIDX CE NSE_FO
10313 NSE_FO|50628 50628.0 BANKNIFTY24JUL52100PE NaN 2337.10 2024-07-31 52100.0 0.05 15.0 OPTIDX PE NSE_FO
10314 NSE_FO|50629 50629.0 BANKNIFTY24JUL52200CE NaN 773.50 2024-07-31 52200.0 0.05 15.0 OPTIDX CE NSE_FO
10315 NSE_FO|50630 50630.0 BANKNIFTY24JUL52200PE NaN 2409.85 2024-07-31 52200.0 0.05 15.0 OPTIDX PE NSE_FO
10316 NSE_FO|50631 50631.0 BANKNIFTY24JUL52300CE NaN 749.45 2024-07-31 52300.0 0.05 15.0 OPTIDX CE NSE_FO
10317 NSE_FO|50632 50632.0 BANKNIFTY24JUL52300PE NaN 2310.75 2024-07-31 52300.0 0.05 15.0 OPTIDX PE NSE_FO
10318 NSE_FO|50633 50633.0 BANKNIFTY24JUL52400CE NaN 513.10 2024-07-31 52400.0 0.05 15.0 OPTIDX CE NSE_FO
10319 NSE_FO|50634 50634.0 BANKNIFTY24JUL52400PE NaN 2321.85 2024-07-31 52400.0 0.05 15.0 OPTIDX PE NSE_FO
10320 NSE_FO|50637 50637.0 BANKNIFTY24JUL52500CE NaN 349.15 2024-07-31 52500.0 0.05 15.0 OPTIDX CE NSE_FO
10321 NSE_FO|50638 50638.0 BANKNIFTY24JUL52500PE NaN 2600.90 2024-07-31 52500.0 0.05 15.0 OPTIDX PE NSE_FO
10323 NSE_FO|50640 50640.0 BANKNIFTY24JUL52600CE NaN 681.00 2024-07-31 52600.0 0.05 15.0 OPTIDX CE NSE_FO
10324 NSE_FO|50641 50641.0 BANKNIFTY24JUL52600PE NaN 2707.45 2024-07-31 52600.0 0.05 15.0 OPTIDX PE NSE_FO
10325 NSE_FO|50651 50651.0 BANKNIFTY24JUL52700CE NaN 657.30 2024-07-31 52700.0 0.05 15.0 OPTIDX CE NSE_FO
10326 NSE_FO|50652 50652.0 BANKNIFTY24JUL52700PE NaN 2788.65 2024-07-31 52700.0 0.05 15.0 OPTIDX PE NSE_FO
10327 NSE_FO|50653 50653.0 BANKNIFTY24JUL52800CE NaN 636.05 2024-07-31 52800.0 0.05 15.0 OPTIDX CE NSE_FO
10328 NSE_FO|50654 50654.0 BANKNIFTY24JUL52800PE NaN 2868.00 2024-07-31 52800.0 0.05 15.0 OPTIDX PE NSE_FO
10329 NSE_FO|50655 50655.0 BANKNIFTY24JUL52900CE NaN 350.05 2024-07-31 52900.0 0.05 15.0 OPTIDX CE NSE_FO
10330 NSE_FO|50656 50656.0 BANKNIFTY24JUL52900PE NaN 2951.65 2024-07-31 52900.0 0.05 15.0 OPTIDX PE NSE_FO
10331 NSE_FO|50665 50665.0 BANKNIFTY24JUL53000CE NaN 259.80 2024-07-31 53000.0 0.05 15.0 OPTIDX CE NSE_FO
10332 NSE_FO|50666 50666.0 BANKNIFTY24JUL53000PE NaN 3050.80 2024-07-31 53000.0 0.05 15.0 OPTIDX PE NSE_FO
10333 NSE_FO|50672 50672.0 BANKNIFTY24JUL53100CE NaN 575.75 2024-07-31 53100.0 0.05 15.0 OPTIDX CE NSE_FO
10334 NSE_FO|50673 50673.0 BANKNIFTY24JUL53100PE NaN 3115.45 2024-07-31 53100.0 0.05 15.0 OPTIDX PE NSE_FO
10335 NSE_FO|50677 50677.0 BANKNIFTY24JUL53200CE NaN 556.70 2024-07-31 53200.0 0.05 15.0 OPTIDX CE NSE_FO
10336 NSE_FO|50682 50682.0 BANKNIFTY24JUL53200PE NaN 3193.45 2024-07-31 53200.0 0.05 15.0 OPTIDX PE NSE_FO
10337 NSE_FO|50683 50683.0 BANKNIFTY24JUL53300CE NaN 538.20 2024-07-31 53300.0 0.05 15.0 OPTIDX CE NSE_FO
10338 NSE_FO|50684 50684.0 BANKNIFTY24JUL53300PE NaN 3284.80 2024-07-31 53300.0 0.05 15.0 OPTIDX PE NSE_FO
10339 NSE_FO|50685 50685.0 BANKNIFTY24JUL53400CE NaN 185.80 2024-07-31 53400.0 0.05 15.0 OPTIDX CE NSE_FO
10340 NSE_FO|50687 50687.0 BANKNIFTY24JUL53400PE NaN 3366.10 2024-07-31 53400.0 0.05 15.0 OPTIDX PE NSE_FO
10341 NSE_FO|50690 50690.0 BANKNIFTY24JUL53500CE NaN 190.30 2024-07-31 53500.0 0.05 15.0 OPTIDX CE NSE_FO
10342 NSE_FO|50691 50691.0 BANKNIFTY24JUL53500PE NaN 3436.85 2024-07-31 53500.0 0.05 15.0 OPTIDX PE NSE_FO
10343 NSE_FO|50692 50692.0 BANKNIFTY24JUL53600CE NaN 485.65 2024-07-31 53600.0 0.05 15.0 OPTIDX CE NSE_FO
10344 NSE_FO|50693 50693.0 BANKNIFTY24JUL53600PE NaN 3533.60 2024-07-31 53600.0 0.05 15.0 OPTIDX PE NSE_FO
10345 NSE_FO|50694 50694.0 BANKNIFTY24JUL53700CE NaN 469.15 2024-07-31 53700.0 0.05 15.0 OPTIDX CE NSE_FO
10346 NSE_FO|50695 50695.0 BANKNIFTY24JUL53700PE NaN 3619.50 2024-07-31 53700.0 0.05 15.0 OPTIDX PE NSE_FO
10347 NSE_FO|50696 50696.0 BANKNIFTY24JUL53800CE NaN 453.10 2024-07-31 53800.0 0.05 15.0 OPTIDX CE NSE_FO
10348 NSE_FO|50697 50697.0 BANKNIFTY24JUL53800PE NaN 3714.70 2024-07-31 53800.0 0.05 15.0 OPTIDX PE NSE_FO
10349 NSE_FO|50698 50698.0 BANKNIFTY24JUL53900CE NaN 397.05 2024-07-31 53900.0 0.05 15.0 OPTIDX CE NSE_FO
10350 NSE_FO|50699 50699.0 BANKNIFTY24JUL53900PE NaN 3798.60 2024-07-31 53900.0 0.05 15.0 OPTIDX PE NSE_FO
10351 NSE_FO|50700 50700.0 BANKNIFTY24JUL54000CE NaN 139.20 2024-07-31 54000.0 0.05 15.0 OPTIDX CE NSE_FO
10352 NSE_FO|50701 50701.0 BANKNIFTY24JUL54000PE NaN 4046.30 2024-07-31 54000.0 0.05 15.0 OPTIDX PE NSE_FO
10353 NSE_FO|50721 50721.0 BANKNIFTY24JUL54500CE NaN 147.95 2024-07-31 54500.0 0.05 15.0 OPTIDX CE NSE_FO
10354 NSE_FO|50722 50722.0 BANKNIFTY24JUL54500PE NaN 4359.90 2024-07-31 54500.0 0.05 15.0 OPTIDX PE NSE_FO
10355 NSE_FO|50723 50723.0 BANKNIFTY24JUL55000CE NaN 81.15 2024-07-31 55000.0 0.05 15.0 OPTIDX CE NSE_FO
10356 NSE_FO|50724 50724.0 BANKNIFTY24JUL55000PE NaN 4819.35 2024-07-31 55000.0 0.05 15.0 OPTIDX PE NSE_FO
10357 NSE_FO|50725 50725.0 BANKNIFTY24JUL55500CE NaN 150.80 2024-07-31 55500.0 0.05 15.0 OPTIDX CE NSE_FO
10358 NSE_FO|50728 50728.0 BANKNIFTY24JUL55500PE NaN 4569.95 2024-07-31 55500.0 0.05 15.0 OPTIDX PE NSE_FO
10359 NSE_FO|50729 50729.0 BANKNIFTY24JUL56000CE NaN 57.65 2024-07-31 56000.0 0.05 15.0 OPTIDX CE NSE_FO
10360 NSE_FO|50743 50743.0 BANKNIFTY24JUL56000PE NaN 5800.00 2024-07-31 56000.0 0.05 15.0 OPTIDX PE NSE_FO
10361 NSE_FO|50750 50750.0 BANKNIFTY24JUL56500CE NaN 47.00 2024-07-31 56500.0 0.05 15.0 OPTIDX CE NSE_FO
10362 NSE_FO|50751 50751.0 BANKNIFTY24JUL56500PE NaN 7378.50 2024-07-31 56500.0 0.05 15.0 OPTIDX PE NSE_FO
10363 NSE_FO|50752 50752.0 BANKNIFTY24JUL57000CE NaN 44.40 2024-07-31 57000.0 0.05 15.0 OPTIDX CE NSE_FO
10364 NSE_FO|50753 50753.0 BANKNIFTY24JUL57000PE NaN 7838.55 2024-07-31 57000.0 0.05 15.0 OPTIDX PE NSE_FO
10365 NSE_FO|50754 50754.0 BANKNIFTY24JUL57500CE NaN 40.20 2024-07-31 57500.0 0.05 15.0 OPTIDX CE NSE_FO
10366 NSE_FO|50755 50755.0 BANKNIFTY24JUL57500PE NaN 8303.65 2024-07-31 57500.0 0.05 15.0 OPTIDX PE NSE_FO
10367 NSE_FO|50756 50756.0 BANKNIFTY24JUL58000CE NaN 87.00 2024-07-31 58000.0 0.05 15.0 OPTIDX CE NSE_FO
10368 NSE_FO|50759 50759.0 BANKNIFTY24JUL58000PE NaN 8773.10 2024-07-31 58000.0 0.05 15.0 OPTIDX PE NSE_FO
10369 NSE_FO|50775 50775.0 BANKNIFTY24JUL58500CE NaN 37.50 2024-07-31 58500.0 0.05 15.0 OPTIDX CE NSE_FO
10370 NSE_FO|50779 50779.0 BANKNIFTY24JUL58500PE NaN 9246.25 2024-07-31 58500.0 0.05 15.0 OPTIDX PE NSE_FO
10371 NSE_FO|50788 50788.0 BANKNIFTY24JUN48900PE NaN 258.00 2024-06-26 48900.0 0.05 15.0 OPTIDX PE NSE_FO
10372 NSE_FO|50789 50789.0 BANKNIFTY24JUN49000CE NaN 1183.30 2024-06-26 49000.0 0.05 15.0 OPTIDX CE NSE_FO
10373 NSE_FO|50790 50790.0 BANKNIFTY24JUN49000PE NaN 283.35 2024-06-26 49000.0 0.05 15.0 OPTIDX PE NSE_FO
10374 NSE_FO|50793 50793.0 BANKNIFTY24JUN49100CE NaN 1101.15 2024-06-26 49100.0 0.05 15.0 OPTIDX CE NSE_FO
10588 NSE_FO|52418 52418.0 BANKNIFTY24JUN49100PE NaN 309.30 2024-06-26 49100.0 0.05 15.0 OPTIDX PE NSE_FO
10589 NSE_FO|52419 52419.0 BANKNIFTY24JUN49200CE NaN 1036.45 2024-06-26 49200.0 0.05 15.0 OPTIDX CE NSE_FO
10590 NSE_FO|52434 52434.0 BANKNIFTY24JUN49200PE NaN 337.65 2024-06-26 49200.0 0.05 15.0 OPTIDX PE NSE_FO
10591 NSE_FO|52435 52435.0 BANKNIFTY24JUN49300CE NaN 965.65 2024-06-26 49300.0 0.05 15.0 OPTIDX CE NSE_FO
10592 NSE_FO|52436 52436.0 BANKNIFTY24JUN49300PE NaN 363.80 2024-06-26 49300.0 0.05 15.0 OPTIDX PE NSE_FO
10593 NSE_FO|52437 52437.0 BANKNIFTY24JUN49400CE NaN 900.10 2024-06-26 49400.0 0.05 15.0 OPTIDX CE NSE_FO
10659 NSE_FO|52735 52735.0 BANKNIFTY24JUN49400PE NaN 403.15 2024-06-26 49400.0 0.05 15.0 OPTIDX PE NSE_FO
10660 NSE_FO|52740 52740.0 BANKNIFTY24JUN49600CE NaN 772.60 2024-06-26 49600.0 0.05 15.0 OPTIDX CE NSE_FO
10661 NSE_FO|52741 52741.0 BANKNIFTY24JUN49600PE NaN 475.65 2024-06-26 49600.0 0.05 15.0 OPTIDX PE NSE_FO
10662 NSE_FO|52743 52743.0 BANKNIFTY24JUN49700CE NaN 713.50 2024-06-26 49700.0 0.05 15.0 OPTIDX CE NSE_FO
10664 NSE_FO|52746 52746.0 BANKNIFTY24JUN49700PE NaN 517.00 2024-06-26 49700.0 0.05 15.0 OPTIDX PE NSE_FO
10665 NSE_FO|52747 52747.0 BANKNIFTY24JUN49800CE NaN 658.75 2024-06-26 49800.0 0.05 15.0 OPTIDX CE NSE_FO
10666 NSE_FO|52748 52748.0 BANKNIFTY24JUN49800PE NaN 556.65 2024-06-26 49800.0 0.05 15.0 OPTIDX PE NSE_FO
10667 NSE_FO|52749 52749.0 BANKNIFTY24JUN49900CE NaN 607.55 2024-06-26 49900.0 0.05 15.0 OPTIDX CE NSE_FO
10814 NSE_FO|53729 53729.0 BANKNIFTY24JUN49900PE NaN 603.05 2024-06-26 49900.0 0.05 15.0 OPTIDX PE NSE_FO
10815 NSE_FO|53730 53730.0 BANKNIFTY24JUN50000CE NaN 556.10 2024-06-26 50000.0 0.05 15.0 OPTIDX CE NSE_FO
10816 NSE_FO|53733 53733.0 BANKNIFTY24JUN50000PE NaN 646.40 2024-06-26 50000.0 0.05 15.0 OPTIDX PE NSE_FO
10817 NSE_FO|53734 53734.0 BANKNIFTY24JUN50100CE NaN 507.10 2024-06-26 50100.0 0.05 15.0 OPTIDX CE NSE_FO
50892 NSE_FO|39762 39762.0 BANKNIFTY2471046500CE NaN 3213.75 2024-07-10 46500.0 0.05 15.0 OPTIDX CE NSE_FO
52978 NSE_FO|55168 55168.0 BANKNIFTY2471050300CE NaN 1173.30 2024-07-10 50300.0 0.05 15.0 OPTIDX CE NSE_FO
52979 NSE_FO|55169 55169.0 BANKNIFTY2471050300PE NaN 1841.90 2024-07-10 50300.0 0.05 15.0 OPTIDX PE NSE_FO
52980 NSE_FO|55170 55170.0 BANKNIFTY2471050400CE NaN 909.45 2024-07-10 50400.0 0.05 15.0 OPTIDX CE NSE_FO
52981 NSE_FO|55171 55171.0 BANKNIFTY2471050400PE NaN 1572.50 2024-07-10 50400.0 0.05 15.0 OPTIDX PE NSE_FO
52982 NSE_FO|55172 55172.0 BANKNIFTY2471050500CE NaN 698.55 2024-07-10 50500.0 0.05 15.0 OPTIDX CE NSE_FO
52983 NSE_FO|55175 55175.0 BANKNIFTY2471050500PE NaN 1387.95 2024-07-10 50500.0 0.05 15.0 OPTIDX PE NSE_FO
52984 NSE_FO|55176 55176.0 BANKNIFTY2471050600CE NaN 837.85 2024-07-10 50600.0 0.05 15.0 OPTIDX CE NSE_FO
52985 NSE_FO|55177 55177.0 BANKNIFTY2471050600PE NaN 2030.80 2024-07-10 50600.0 0.05 15.0 OPTIDX PE NSE_FO
52986 NSE_FO|55178 55178.0 BANKNIFTY2471050700CE NaN 803.70 2024-07-10 50700.0 0.05 15.0 OPTIDX CE NSE_FO
52987 NSE_FO|55179 55179.0 BANKNIFTY2471050700PE NaN 2095.90 2024-07-10 50700.0 0.05 15.0 OPTIDX PE NSE_FO
52988 NSE_FO|55180 55180.0 BANKNIFTY2471050800CE NaN 1018.00 2024-07-10 50800.0 0.05 15.0 OPTIDX CE NSE_FO
52989 NSE_FO|55181 55181.0 BANKNIFTY2471050800PE NaN 2162.05 2024-07-10 50800.0 0.05 15.0 OPTIDX PE NSE_FO
53029 NSE_FO|55231 55231.0 BANKNIFTY2471052800PE NaN 3680.15 2024-07-10 52800.0 0.05 15.0 OPTIDX PE NSE_FO
53030 NSE_FO|55232 55232.0 BANKNIFTY2471052900CE NaN NaN 2024-07-10 52900.0 0.05 15.0 OPTIDX CE NSE_FO
53031 NSE_FO|55233 55233.0 BANKNIFTY2471052900PE NaN NaN 2024-07-10 52900.0 0.05 15.0 OPTIDX PE NSE_FO

To Process the Above Instruments File and get the Instrument Key We Can utilize a Single Column that is Tradingsymbol BANKNIFTY+YYMMDD+50000+CE which Consists of Spot Symbol Name with Expiry,Strike Price and Option Type to get Current Expiry We will Sort it out with Expiry Column:


#BANKNIFTY+YYMMDD+50000+CE
#Index(['instrument_key', 'exchange_token', 'tradingsymbol', 'name',
       #'last_price', 'expiry', 'strike', 'tick_size', 'lot_size',
       #'instrument_type', 'option_type', 'exchange'],
      #dtype='object')
import pandas as pd  
#instruments=pd.read_csv('https://assets.upstox.com/market-quote/instruments/exchange/complete.csv.gz')
spotsymbol='BANKNIFTY'
strike='50000'
option_type='CE'
def get_instrument_key(spotsymbol,strike,option_type):
	instruments=pd.read_csv('instruments.csv')
	instruments['tradingsymbol']=instruments['tradingsymbol'].fillna('')
	instrument_key=instruments[(instruments['tradingsymbol'].str.contains(spotsymbol))
	&(instruments['tradingsymbol'].str.contains(strike))
		&(instruments['tradingsymbol'].str.contains(option_type))].sort_values('expiry')
	return instrument_key['instrument_key'].iloc[0]
key=get_instrument_key(spotsymbol,strike,option_type)
print(key)


Websocket Market Data Streamer Upstox Free API in Python:


For Instructions Follow the Video then go For Code Input:



#Generate the Instruments Symbol
import pandas as pd  
instruments=pd.read_csv('https://assets.upstox.com/market-quote/instruments/exchange/complete.csv.gz')
instruments.to_csv('instruments.csv',index=False)


#WebSocket Market Data Streamer
import upstox_client
instrument_keys=['NSE_FO|37054','NSE_INDEX|Nifty 50','NSE_INDEX|Bank Nifty']
access_token=open('access_token.txt').read().strip()
def on_message(message):
    print(message)
def main():
    config=upstox_client.Configuration()
    config.access_token=access_token
    streamer=upstox_client.MarketDataStreamer(
        upstox_client.ApiClient(config),instrument_keys,'ltpc')
    streamer.on('message',on_message)
    streamer.connect()
if __name__=='__main__':
    main()


Automate Trades in Upstox Utilizing Free of Cost API in Python:


For Instructions Follow the Video then go For the Code Input:



import requests
api_key=open('api_key.txt','r').read().strip()
api_secret=open('api_secret.txt','r').read().strip()
uri='https://account.upstox.com/developer/apps'
code='ZnNMAG'
url='https://api-v2.upstox.com/login/authorization/token'
headers={
      'accept': 'application/json',
      'Api-Version': '2.0',
      'Content-Type': 'application/x-www-form-urlencoded'
      }
data={
    'code':code,
    'client_id':api_key,
    'client_secret':api_secret,
    'redirect_uri':uri,
    'grant_type':'authorization_code'
    }
response=requests.post(url,headers=headers,data=data)
access_token=response.json()['access_token']
print(access_token,file=open('access_token.txt','w'))
print(access_token)
access_token=open('access_token.txt','r').read().strip()
quote='https://api-v2.upstox.com/market-quote/quotes?symbol=NSE_EQ|INE848E01016'
headers={
  'accept': 'application/json',
 'Api-Version': '2.0',
 'Authorization': f'Bearer {access_token}'
  }
response=requests.get(quote,headers=headers)
print(response.json())