Dear Tradhull team,
could you please help to read the short and long hist data from the "kotakneo brokar "
import pickle
import talib
from anyio import current_time
import tradehull
import pandas as pd
import datetime
import time
from datetime import datetime
import calendar
import pdb
import pandas_ta as ta
import xlwings as xw
from Kotak_Neo_TradeHull import TradeHull
from openpyxl import load_workbook
import math
# Broker login
kotakNeo = pd.read_excel('Live Trading Sheet2.xlsx', sheet_name='Kotakneo')
zerodha = pd.read_excel('Live Trading Sheet2.xlsx', sheet_name='zerodha')
login = False
while not login:
try:
tsl = TradeHull(kotakNeo['Client_ID'].iloc[0], kotakNeo['Consumer_ID'].iloc[0], kotakNeo['Consumer_Secret_key'].iloc[0], kotakNeo['Password'].iloc[0], kotakNeo['Mobile_number'].iloc[0], kotakNeo['MPIN'].iloc[0])
login = True
except Exception as e:
print(f"Failed to initialize TradeHull: {e}")
time.sleep(5)
completed_sheet = pd.read_excel('Live Trading Sheet2.xlsx', sheet_name='completed orders')
# Initialize Tradehull
TH = tradehull.Tradehull(zerodha['API_KEY'].iloc[0], zerodha['API_Secret_key'].iloc[0], 'yes')
kite = TH.kite
watchlist = ['NIFTYQLITY', 'NV20IETF', 'LOWVOLIETF', 'MIDSMALL', 'ALPL30IETF', 'ALPHA', 'MOM30IETF', 'GOLDBEES','ADANIPORTS', 'ADANIENT', 'SBIN', 'TATASTEEL', 'BAJAJFINSV', 'RELIANCE', 'TCS', 'JSWSTEEL', 'HCLTECH', 'TECHM', 'NTPC', 'BHARTIARTL', 'WIPRO', 'BAJFINANCE', 'INDUSINDBK', 'KOTAKBANK', 'HINDALCO', 'ULTRACEMCO', 'AXISBANK', 'M&M', 'MARUTI', 'HEROMOTOCO', 'EICHERMOT', 'COALINDIA', 'TITAN', 'UPL', 'HINDUNILVR', 'ITC', 'NESTLEIND', 'APOLLOHOSP', 'ICICIBANK', 'GRASIM', 'BRITANNIA', 'ASIANPAINT', 'POWERGRID', 'SBILIFE', 'ONGC']
for name in watchlist:
data = TH.get_short_length_hist_data(name=name, exchange="NSE", interval="5minute", oi=True)
# all the data i want to read from Kotakneo broker
# i want to read the date for 5 mint and 15 mint.
# i want to ready the one day hist data for all the watchlist.