botany02

Activity

• 
  jesujeganeee → botany02

  hi, can you please help me to get market depth data ( 5 rows) to excell. please

  January 2022
  • 
    jesujeganeee

    my mail id is [email protected]

    January 2022
• 
  Pradyumn → botany02

  Hi,
  please send your excel trading workbook to my mail. ([email protected])
  Thanks

  January 2021
• 
  XE2086 → botany02

  hi,
  Can you please send the kiteXL workbook to my mail id- [email protected]
  
  regards,
  robin

  July 2020
• 
  pyneni → botany02

  Hi,
  
  Could you share the excel trading work book to my mail id?([email protected])
  
  Warm Regards
  Siva

  June 2020
• 
  mails4vimal → botany02

  Hi,
  pls. send your excel trading workbook to my mail. ([email protected])
  Thanks and regards
  Durai

  May 2020
• 
  YM1284 → botany02

  Hello botany02,
  I am using kiteXL to place order.
  Please explain the difference between OPEN and UPDATE order status of XL.
  in what cases KiteXL shows these order status?
  

  May 2018
  • 
    YM1284

    Hi botany02,
    Please update on above query.

    May 2018
  • 
    chandar

    How you use

    October 2019
• 
  Maddyms7 → botany02

  Is there any Sample Excel template built by zerodha to connect Excel with Kite

  August 2019
• 
  AmballiP → botany02

  Hello Sir,
  
  I am new to kite Connect. I would like to build my own fully automated trading platform in Excel (using VBA) by using Kite Connect.
  For that i would be requiring live OHLC and volumes data (minute & hour). So is it possible to get these live values with respect to time frame (minute & hour) in excel using Kite Connect?.

  November 2018
• 
  Parnik → botany02

  I have downloaded excel file but it is indicating that dotnet connector for Kite API is not there. How to get it please?
  

  July 2018
• 
  shilpamc → botany02

  Kindly guide How can i place Automated oreders from Kitexl.

  April 2018
• 
  xh2025XH → botany02

  Kitexl is giving strange error… till yesterday it was working fine… while login, after giving credential – blank page appears… and later on give timeout error.
  Can you Pease help? I am available on team Viewer

  April 2018
• 
  ericv → botany02

  hi,
  
  How can I get zerodha chart for a scrip in Kite XL inside an excel sheet?
  
  
  Thanks
  Eric
  

  March 2018
• 
  Dinesh1234 → botany02

  hi,
  I have been a kitexl user for few months. First let me congratulate you and your team for the awesome job. Eagerly waiting for kite connect 3.0 excel
  
  I am facing this issue for the past few trading sessions. I like to place regular market order in pre-session between 9:00 - 9:07
  But the order gets executed as a limit order. Also I only trade in nifty 100 stocks hence no chance of reaching upper or lower circuit.
  
  Thanks....

  February 2018
• 
  saching6117 → botany02

  I Need help....
  Where do excel files on web side
  and i want to work manually on excel.
  
  

  February 2018
• 
  GasTurbGuy → botany02

  Hi @botany02,
  
  Any update on the progress of the new KiteXL? I understand that while an exact date on the release might be a bit tricky to give out, I'd really appreciate if you can give a tentative date on its release. Thanks!
  

  February 2018
  • 
    botany02

    Hi @GasTurbGuy,
    Will update beta in couple of days, full version before FEB end.
    Thanks.

    February 2018
• 
  GasTurbGuy → botany02

  Hi botany02,
  
  Is there an issue with KiteXL in downloading price data today? It was working fine in the morning but stopped working after that. I've detailed the issue in this discussion on the forum.
  
  https://kite.trade/forum/discussion/3005/quotes-not-streaming-in#latest
  
  Could you please let me know how to fix it? Thanks.

  January 2018
• 
  narayanan → botany02

  Hi botany02,
  congrat for the new kite connect 3.0 release.
  Is kitedotnet also updated to latest

  January 2018
• 
  GasTurbGuy → botany02

  Hi, I'm trying to login with KiteXL. I've installed it as per instructions and have entered in my API key and secret.
  
  The problem is that I get this error message: "User access denied. User is not enabled for kite connect".
  
  On the forum I had noticed that you had requested the user to PM you their client ID for resolution. My client ID is DA7338. I'm not using multiple instances. Could you please help me out? Thanks.

  January 2018
  • 
    botany02

    Hi, are you Publisher API?

    January 2018
  • 
    GasTurbGuy

    Thanks for replying back.
    
    No, it's the paid subscription (Kite connect + publisher). I've PM'd a screenshot of the relevant kite connect developer app page.

    January 2018
  • 
    botany02

    @gastrubGuy
    Ping your Teamviewer Id and Password at 1030am.
    I'll check it through TV

    January 2018
  • 
    GasTurbGuy

    @botany02
    
    Sorry I didn't see your message till now. I've PM'd you my teamviewer ID... I'll be online today during market hours. I'll be available tomorrow too if you can't make it today. Thanks!

    January 2018
  • 
    GasTurbGuy

    @botany02
    
    Could you please let me know if someone is trying to address my complaint? It's very frustrating that I can't even log in and I'm not getting any feedback on the matter. All the while, it's not like my paid subscription is getting extended due to this error.

    January 2018
  • 
    GasTurbGuy

    @botany02
    
    I've PM'd you my phone number. Could you please give me a call when you're free to resolve the issue please? I'd really like to resolve this issue at the earliest.

    January 2018
  • 
    GasTurbGuy

    @botany02
    
    Could you get to me on this please? I would really appreciate it if the isssue can be resolved. Thanks.

    January 2018
  • 
    GasTurbGuy

    Thanks for sorting out the issue @botany02. I didn't know that you were someone independent from Zerodha and yet you spend time helping other users. Much appreciated!

    January 2018
• 
  money → botany02

  Thanks for the reply. i am free between 1-2 pm today. should i share my number?

  January 2018
  • 
    botany02

    No.. Mobile number not required.
    https://howutrade.in/docs/kitexl/html/KiteXL.zip
    Download the file and follow the install notes

    January 2018
  • 
    money

    586 844 002 pass word. s5f39n

    January 2018
• 
  narayanan → botany02

  Hello,
  20180104790009 ticket no is opened by me.
  I am using kitedotnet. details added in that ticket. Getorderstatus is not working.

  January 2018
• 
  tradematic → botany02

  Hi @Botany02
  
  Is there any way to get number of Open positions through Kite Xl.. I know that clicking Position button will give me whole data. But i need some thing like RTD function.
  
  As i want to automate my trades, i need count of my open positions.
  
  for eg if (number of positions is < = 2 then trade else wait)
  
  Thanks in advance.

  November 2017
  • 
    botany02

    Hi @tradematic,
    This will be available soon

    November 2017
• 
  rejeesh31 → botany02

  Hello, my kiteXL is frequently logged out hence not able to place orders based on my automated algo...what could be the reason and how do we fix this?

  November 2017
  • 
    rejeesh31

    also, is there a way to fully automate the loginflow? like hard coding clientID, passcode and security qns?

    November 2017
  • 
    rejeesh31

    GetOrderStatus(A3) is returning null. A3 contains orderID 171113000625998

    November 2017
  • 
    rejeesh31

    GetOrderStatus(A3) is returning null at times and works fine at times

    November 2017
  • 
    rejeesh31

    GetOrderStatus acting is weird! the order is complete in kite and still showing 'Trigger Pending' when i fire getorderstatus

    November 2017
  • 
    rejeesh31

    how do i really find if an order is complete using getorderstatus?

    November 2017
  • 
    botany02

    @rejeesh31
    #1 This may be due to Temp Files/Cookies/Cache, most of the time this issue caused by system, so you have to dig out. You may try the below;
    1. Delete Temp Files/Cookies/Cache
    2. Try running KiteXL in other Laptop/PC, see whether the issue continues o not
    
    #2 'GetOrderStatus' will return order status from the stored value. KiteXL is not fetching the status from Kite Server, this is so because to prevent users from getting 429 error and for fast performance, otherwise if fetching from Kite Server for multiple orders will lead to system instability and 429 error.
    
    when you place a order, KiteXL stores the order id in a key with initial status as Null and starts a thread to fetch order status in a loop with interval of 10 sec and exits the loop once the order status changes to 'COMPLETE', 'REJECTED' or 'CANCELLED' and stores the Final order status in the Key. This is so because, since the order status is sent via post-back that needs a domain and the domain should be connected to user KiteXL via some communication mechanism like TCP/IP, so we implemented thread for checking the order status.
    This will work fine until you have limited number of orders or the order type is Market (The loop will exit immediately as your order will be COMPLETE with Market order type).
    But when you place more order with order type as LIMIT or SL or SL-M, more threads are created, all threads keep on running (as LIMIT or SL or SL-M order) and all threads simultaneously trying to fetch order status in a loop with interval, thus leads to 429 error and system instability.When a thread experience a 429 error, it exits the loop, so leaving the order status to NULL forever till you reopen the KiteXL or Fetch order Book.
    
    This is the known issue as we don't have any other option (as post-back is the only way to get order updates and that requires domain and integration with KiteXL)
    
    We are updating the KiteXL, which will be released soon with Post-back support.
    This version will give user more flexible than ever, you will get each and every data and updates.
    You have more control over your system and increased stability, lot more functions to manipulate orders, symbols and positions, options to login in chrome and use the access token in Excel(can ignore IE).
    
    (If Order updates through web-sockets is implemented by Zerodha, then it's bonus, we no need to rely on post-back which requires additional head ache to initiate a communication between KiteXL and the domain.dates)
    
    We recommend, you wait for our release.

    February 2018
  • 
    botany02

    @rejeesh31
    #1 This may be due to Temp Files/Cookies/Cache, most of the time this issue caused by system, so you have to dig out. You may try the below;
    1. Delete Temp Files/Cookies/Cache
    2. Try running KiteXL in other Laptop/PC, see whether the issue continues o not
    
    #2 'GetOrderStatus' will return order status from the stored value. KiteXL is not fetching the status from Kite Server, this is so because to prevent users from getting 429 error and for fast performance, otherwise if fetching from Kite Server for multiple orders will lead to system instability and 429 error.
    
    when you place a order, KiteXL stores the order id in a key with initial status as Null and starts a thread to fetch order status in a loop with interval of 10 sec and exits the loop once the order status changes to 'COMPLETE', 'REJECTED' or 'CANCELLED' and stores the Final order status in the Key. This is so because, since the order status is sent via post-back that needs a domain and the domain should be connected to user KiteXL via some communication mechanism like TCP/IP, so we implemented thread for checking the order status.
    This will work fine until you have limited number of orders or the order type is Market (The loop will exit immediately as your order will be COMPLETE with Market order type).
    But when you place more order with order type as LIMIT or SL or SL-M, more threads are created, all threads keep on running (as LIMIT or SL or SL-M order) and all threads simultaneously trying to fetch order status in a loop with interval, thus leads to 429 error and system instability.When a thread experience a 429 error, it exits the loop, so leaving the order status to NULL forever till you reopen the KiteXL or Fetch order Book.
    
    This is the known issue as we don't have any other option (as post-back is the only way to get order updates and that requires domain and integration with KiteXL)
    
    We are updating the KiteXL, which will be released soon with Post-back support.
    This version will give user more flexible than ever, you will get each and every data and updates.
    You have more control over your system and increased stability, lot more functions to manipulate orders, symbols and positions, options to login in chrome and use the access token in Excel(can ignore IE).
    
    (If Order updates through web-sockets is implemented by Zerodha, then it's bonus, we no need to rely on post-back which requires additional head ache to initiate a communication between KiteXL and the domain.dates)
    
    We recommend, you wait for our release.

    February 2018
• 
  rejeesh31 → botany02

  Hello, I'm trying to configure KiteXL and i'm getting this error when I press the Login button - "ActiveX component can't create object. I have referred to earlier threads on this topic and completed install_notes as specified. My windows is 64bit and Excel is 32bit. Please advise

  October 2017
  • 
    rejeesh31

    Can we add Reference manually via VBA editor?

    October 2017
  • 
    botany02

    Yes rajeesh31,
    You can add reference Menu --> Tools --> Add Reference --> Select 'COM Library for KiteConnect API of Zerodha'.
    Also you need to change the binding in the module. Right-now, it is late binding

    October 2017
  • 
    rejeesh31

    Thanks that was helpful!

    November 2017
• 
  Ones → botany02

  I understand from @sujith, that you have made KiteXL, hence if you could respond in my thread "Issues with KiteXL".

  September 2017
• 
  ZA8868 → botany02

  Sir,
  
  I need help in writing code to place simple Intraday order rom excel to Kite
  Usually in morning first 30-45 mins we plan 8-10 trades which need to eb excuted very qucickly
  Appreciate if you can help or somebody help us on this
  we are ok to pay for any compensation
  
  my contact is - 9987591171 / [email protected]
  
  Regards
  
  HEMANT

  August 2017
• 
  chiragkeswani → botany02

  Hi @botany02,
  
  Can you suggest how can I get historical data in KiteXL? I want 15 days OLH and Volume data
  
  Regards-
  Chirag Keswani

  July 2017
• 
  paragsatpute → botany02

  Hi,
  I got the earlier error sorted out but, now receiving the error as "Trade Symbol is Null or Invalid".
  Here is the code snippet. I am doing it in C#.
  
  string InstruName;
  string InstruName = "TITAN17JULFUT";
  string OrderId = Kite.PlaceBO("NFO", InstruName, "Buy", 1, 523.25, 2,2,1);
  
  Please help.

  July 2017
• 
  paragsatpute → botany02

  Hi,
  I am getting error as "Transaction Type is Null or Invalid.Should be BUY or SELL"
  I have tried all sorts of combinations (directly typing out BUY/SELL in string quotes, passing through variable etc.) but nothing works.
  
  I am using the KiteDotNet API within the C# environment. Please help.
  
  

  June 2017
  • 
    botany02

    Could You Please post code snippet...?

    June 2017
  • 
    paragsatpute

    Hi,
    I got the earlier error sorted out but not receiving the error as "Trade Symbol is Null or Invalid".
    Here is the code snippet. I am doing it in C#.
    
    string InstruName;
    string InstruName = "TITAN17JULFUT";
    string OrderId = Kite.PlaceBO("NFO", InstruName, "Buy", 1, 523.25, 2,2,1);
    
    Please help.

    July 2017
  • 
    paragsatpute

    @botany02,
    Please can you review the code snippet and advise.

    July 2017
• 
  jasdeepwalia → botany02

  Hi,
  
  I am using your kite API. we have interacted earlier also. Facing one issue
  Sometimes if i try to get historical data for a Call or put it says invalid symbol. Though i am able to fetch data for the same symbol string directly from zerodha. basically by using
  
  "https://api.kite.trade/instruments/historical/5633/minute?from=2015-12-28&to=2016-01-01&api_key=xxx&access_token=yyy"
  
  not sure whats the issue here. instrument download and everything is good, but still does not work. Placeregularorder also fails because of same error, but placing directly in zerodha works.
  
  

  June 2017
• 
  Pradeep → botany02

  Kite.Login() is not opening the browser window - can you please help - i am not able to login

  August 2017