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