Recent Activity

any one can solve this

@imran can you pls fix this issue

Hii Arjun send me your contact number.. I will fix this through anydesk.

Hi Imran, Hi Arjun,
I am also facing the same issue. Could you kindly help me to fix this?
Thank you in advance.

I am able to get the access token but when I added "logging.basicConfig(level=logging.DEBUG)". I am getting below error

DEBUG:urllib3.connectionpool:Starting new HTTPS connection (1): api.kite.trade:443
DEBUG:urllib3.connectionpool:https://api.kite.trade:443 "POST /session/token HTTP/1.1" 403 None
Can someone guide me?

Thank you

Hii arthite

see the below video for reference.

1. https://www.youtube.com/watch?v=z1sleBSX8w0&t=963s
2. https://www.youtube.com/watch?v=B1jjo0zcE6g&t=354s
3. https://www.youtube.com/watch?v=UTRbPkUJNXM

sir i tried this, but while exporting data to excel its showing me dates and variable names not values.
this is the code :
from kiteconnect import KiteConnect
from kiteconnect import KiteTicker
import pandas as pd
import numpy as np
from numpy import array
import datetime,time,os,random
import pdb
from openpyxl import Workbook
from pandas.io.json import json_normalize
import xlwings as xw
import talib


kws = ""
kite = ""

api_k = "xgzzqisbd6vil8cn" # api_key
api_s = "e1e1acyzv5hrgawjsnq5oc4kidadcg78" # api_secret
access_token = "mR48QhHegwehw1o4OrPuSCaCkqSiNAlN"
trd_portfolio = {'PCJ': {'token': 315393},'ACC': {'token': 5633}}
#trd_portfolio = {738561:"PCJ",5633:"ACC",40193:"APPOLO"}

def get_login(api_k, api_s): # log in to zerodha API panel
global kws, kite
kite = KiteConnect(api_key=api_k)

#print("[*] Generate access Token : ", kite.login_url())
#request_tkn = input("[*] Enter Your Request Token Here : ")
#data = kite.generate_session(request_tkn, api_secret=api_s)
kite.set_access_token(access_token)
kws = KiteTicker(api_k, access_token)
#print('access_token')

# # pdb.set_trace()
# kite.set_access_token('4tN29CKS89i71siZyLsL0rSc3EcJvccY')
# kws = KiteTicker(api_k, '4tN29CKS89i71siZyLsL0rSc3EcJvccY')
# print(data['access_token'])


get_login(api_k, api_s)


# pdb.set_trace()

ticks_storage = pd.DataFrame()
timeframe = 1
temp = {}


name = 'ACC'

wb = xw.Book('Tick Data1.xlsx')
sht = wb.sheets['ACC']
row_no = 2

def on_ticks(ws, ticks):
global row_no



for name in trd_portfolio:
token = trd_portfolio[name]['token']
for single_company in ticks:
if single_company['instrument_token'] == token:

temp[single_company['timestamp']] = single_company
#dt = datetime_withtimezone.replace(tzinfo=None)
df = pd.DataFrame.from_dict(temp,orient='index')
ohlc = df['last_price'].resample(str(timeframe)+'Min').ohlc()

#pdb.set_trace()
#time = ticks[0]['timestamp']
#open1 = ohlc.open.values
#high1 = ohlc.high.values
#low1 = ohlc.low.values
#close1 = ohlc.close.values
ohlc.to_excel('Tick Data1.xlsx')
print(ohlc)
#pdb.set_trace()
sht.range('A' + str(row_no)).value = ohlc
#sht.range('B' + str(row_no)).value = time


row_no = row_no + 1










#print(low1)

#print(high1)
#print(open1)
#print(close)
#print(ohlc)
# pdb.set_trace()


subscribe = [315393]


def on_connect(ws, response):
ws.subscribe(subscribe)
ws.set_mode(ws.MODE_FULL, subscribe)


kws.on_ticks = on_ticks
kws.on_connect = on_connect
kws.connect()

moreover sir ,when i am trying to add more instrument codes, open high low close values are getting mixed up