botany02

About

Username
botany02
Joined
Visits
3,434
Last Active
Roles
Member

Activity

  • jesujeganeee
    hi, can you please help me to get market depth data ( 5 rows) to excell. please
    January 2022
  • Pradyumn
    Hi,
    please send your excel trading workbook to my mail. ([email protected])
    Thanks
    January 2021
  • XE2086
    hi,
    Can you please send the kiteXL workbook to my mail id- [email protected]

    regards,
    robin
    July 2020
  • pyneni
    Hi,

    Could you share the excel trading work book to my mail id?([email protected])

    Warm Regards
    Siva
    June 2020
  • mails4vimal
    Hi,
    pls. send your excel trading workbook to my mail. ([email protected])
    Thanks and regards
    Durai
    May 2020
  • YM1284
    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
      YM1284
      Hi botany02,
      Please update on above query.
    • chandar
      chandar
      How you use
  • Maddyms7
    Is there any Sample Excel template built by zerodha to connect Excel with Kite
    August 2019
  • AmballiP
    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
    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
    Kindly guide How can i place Automated oreders from Kitexl.
    April 2018
  • xh2025XH
    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
    hi,

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


    Thanks
    Eric
    March 2018
  • Dinesh1234
    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
    I Need help....
    Where do excel files on web side
    and i want to work manually on excel.

    February 2018
  • GasTurbGuy
    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
      botany02
      Hi @GasTurbGuy,
      Will update beta in couple of days, full version before FEB end.
      Thanks.
  • GasTurbGuy
    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
    Hi botany02,
    congrat for the new kite connect 3.0 release.
    Is kitedotnet also updated to latest
    January 2018
  • GasTurbGuy
    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
      botany02
      Hi, are you Publisher API?
    • GasTurbGuy
      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.
    • botany02
      botany02
      @gastrubGuy
      Ping your Teamviewer Id and Password at 1030am.
      I'll check it through TV
    • GasTurbGuy
      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!
    • GasTurbGuy
      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.
    • GasTurbGuy
      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.
    • GasTurbGuy
      GasTurbGuy
      @botany02

      Could you get to me on this please? I would really appreciate it if the isssue can be resolved. Thanks.
    • GasTurbGuy
      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!
  • money
    Thanks for the reply. i am free between 1-2 pm today. should i share my number?
    January 2018
    • botany02
      botany02
      No.. Mobile number not required.
      https://howutrade.in/docs/kitexl/html/KiteXL.zip
      Download the file and follow the install notes
    • money
      money
      586 844 002 pass word. s5f39n
  • narayanan
    Hello,
    20180104790009 ticket no is opened by me.
    I am using kitedotnet. details added in that ticket. Getorderstatus is not working.
    January 2018
  • tradematic
    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
      botany02
      Hi @tradematic,
      This will be available soon
  • rejeesh31
    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
      rejeesh31
      also, is there a way to fully automate the loginflow? like hard coding clientID, passcode and security qns?
    • rejeesh31
      rejeesh31
      GetOrderStatus(A3) is returning null. A3 contains orderID 171113000625998
    • rejeesh31
      rejeesh31
      GetOrderStatus(A3) is returning null at times and works fine at times
    • rejeesh31
      rejeesh31
      GetOrderStatus acting is weird! the order is complete in kite and still showing 'Trigger Pending' when i fire getorderstatus
    • rejeesh31
      rejeesh31
      how do i really find if an order is complete using getorderstatus?
    • botany02
      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.
    • botany02
      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.
  • rejeesh31
    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
      rejeesh31
      Can we add Reference manually via VBA editor?
    • botany02
      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
    • rejeesh31
      rejeesh31
      Thanks that was helpful!
  • Ones
    I understand from @sujith, that you have made KiteXL, hence if you could respond in my thread "Issues with KiteXL".
    September 2017
  • ZA8868
    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
    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
    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
    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
      botany02
      Could You Please post code snippet...?
    • paragsatpute
      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.
    • paragsatpute
      paragsatpute
      @botany02,
      Please can you review the code snippet and advise.
  • jasdeepwalia
    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
    Kite.Login() is not opening the browser window - can you please help - i am not able to login
    August 2017