getting this error:Instrument Token for NIFTY18APR2422500CE: ('NFO', '41756')
Making API request with params: {'exchange': 'NSE', 'symboltoken': ('NFO', '41756'), 'interval': 'FIVE_MINUTE', 'fromdate': '2024-04-10 19:17', 'todate': '2024-04-12 19:17'}
Error fetching candle data: Couldn't parse the JSON response received from the server: b''
Failed to retrieve candle data. this is my function:def historical_data(symbol, interval):
df = dataa()
to_date = datetime.now().strftime("%Y-%m-%d %H:%M")
from_date_calculate = datetime.now() - timedelta(days=2)
from_date = from_date_calculate.strftime("%Y-%m-%d %H:%M")
symbol_code = get_instrument_token_symbol(df, symbol)
print(f"Instrument Token for {symbol}: {symbol_code}")
if symbol_code is None:
print(f"Error: Instrument token not found for symbol {symbol}")
return None
historicParam = {
"exchange": "NSE",
"symboltoken": symbol_code,
"interval": interval,
"fromdate": from_date,
"todate": to_date
}
try:
print("Making API request with params:", historicParam)
data = obj.getCandleData(historicParam)
print("API response:", data)
if data and 'data' in data and data['data']:
data_ohcl = pd.DataFrame(data['data'])
data_ohcl.columns = ['timestamp', 'Open', 'High', 'Low', 'Close', 'Volume']
return data_ohcl
else:
print("No valid data found in the API response.")
return None
except Exception as e:
print(f"Error fetching candle data: {e}")
return None
def dat():
data_ohcl = historical_data("NIFTY18APR2422500CE", 'FIVE_MINUTE')
if data_ohcl is not None:
if isinstance(data_ohcl, pd.DataFrame) and not data_ohcl.empty:
print("Candle Data:")
print(data_ohcl)
else:
print("No valid candle data returned.")
else:
print("Failed to retrieve candle data.")