@JB5267
The 'GetOrderTrdSym' etc are functions, it will not auto update.
Just entering the the formula in a cell doesn't mean that the formula will be calculated automatically.
Excel will calculate the formula only when any changes in the referenc…
@vkn2220
This means you are placing order using Bridge class.
Bridge class is a premium feature.
You can use Kite class for Placing orders
https://howutrade.in/docs/kitenet/html/T_KiteNet_Kite.htm
Check here to know more about Bridge class
https…
@JB5267
Below is the syntax of PlaceRegularOrder function
PlaceRegularOrder(Exch,TrdSym,Trans,OrdType,Qty,ProdType,LmtPrice,TrgPrice)
You are passing the TrgPrice to LmtPrice Parameter
As per your example
PlaceRegularOrder(NFO,NIFTY2010912350CE,"…
@kenip
Yes, We are always thankful to Zerodha for their innovative ideas and customer care.
We understand that the software issues are part of the game, given the huge client base of Zerodha, the issues are very negligible compare to others.
We t…
@kenip
What a coincidence!
Yes, we are reconnecting the socket, but it is not a solution, websocket should not disconnect at first (at least this many times).
@sujith
Nothing has changed in our side, the same setup used for months without any …
@sujith
It's happening today also.
Time of Disconnection
09:22:32.923
09:26:47.829
@krtrader
Could you pls check whether you are getting disconnection at your side?
@krtrader
To be precise, socket was disconnected 27 times during market hours.
@sujith
Pls kindly check this, it was not from client side, it's the kite server abruptly closing the socket connection.
Same happened in last Monday …
@impratikthakkar
Are you passing price from referring other cell?
If that's the case, then your placeorder formula is called before your price formula.
You can add a IF to check for zero price
Example:
Cell A1 = Some Formula which returns price
Ce…
@kulguru
The GetNetQty function calculates the net position details from the order updates received via web-socket. This function doesn't include overnight positions.
We guess you had overnight short positions.
Please note, this is a non-api …
@vickydeepi
It should not happen, are you sure the TickerList_KiteNet.txt file contains 300 symbols only and still getting error?
BTW, the maximum ticker limit is 3000, could you pls drop an email with your client id to [email protected] , we wil…
@dckamtikar
Restart is required after installing .Net 4.5.2
Post restart, try registering, if the problem persists, then try manual registration., see ReadMe_Manual.txt file included in the downloaded zip file.
@ramana @chandar @vkn2220 @Ashishkachhdiya @arunpanjala @Sudheer @impratikthakkar @Sreenath @Bhaskar @Kamalesvary
Pls download the latest DLL from the below link
https://codeadvisor.in/trading-apps/ (see end of page)
If you are using custom app…
@Ashishkachhdiya
Pls download temp DLL from here
https://howutrade.in/downloads/temp/kitenet.zip
and also you need to update to stable version tomorrow
https://kite.trade/forum/discussion/6722/kitenet-update
@Ashishkachhdiya
If you know basic AFL coding, and have trading system already coded in AFL and your AFL generates valid signals then
1. Take API subscription from zerodha
2. Download and install Hello Kite from https://codeadvisor.in/trading-a…
@vkn2220
The Bridge functions (PlaceOrder) works on the concept of Signals.
There are 4 signals
BUY
SELL (==Buy Exit)
SHORT
COVER (==Short Exit)
When you get BUY signal in your system
Call PlaceOrder function with SignalType as "BUY"
PlaceBOBrid…
@arunpanjala
User settings and properties are stored at application level per installation(application folder).
So you can't initialize two Kite object in same process.
Just make a copy of your application folder, and run your app as two separate…
@arunpanjala
You can check the below file for full list of indices.
[APPDIR]\KiteNet\[DDMMMYYYY]\NSE_Index.txt
The syntax is same as you mentioned except the exchange name is "NSE_Index"
objKite.SubscribeQuotes("NSE_Index", "NIFTY 50");
objKite.S…
@mohanarakere
The last contract of a month is MONTHLY option and the symbol format is different from WEEKLY options. The syntax is [SYMBOL] [YY] [MMM] [STRIKE] [OPT TYPE]
It should be NIFTY19SEP11100CE
You may refer the below link to know more a…
@vkn2220
Pls follow the below steps;
1. Open a new Excel sheet, Disable Macros and Close Excel (no need to save the blank sheet)
2. Open your KiteNet Excel workbook.
3. Go to VBA editor
4. In VBA Editor, go to Menu --> Tools --> References
5…
@infotrade
You are using official .Net library, as per its doc
You need to pass Parent OrderId along with Child OrderId
// BO SL exiting
kite.CancelOrder(
OrderId: "1234",
Variety: Constants.VARIETY_BO,
…
@infotrade
Hope the below will clear;
Normally closing a position means, you have to place opposite order with same quantity. Example: if you bought 10 quantity of AXISBANK, to close that position, you have to place a SELL order in AXISBANK with 1…
@arunpanjala
This ticker limit is imposed at application level by KiteNet (our .Net library)
This is to prevent misuse of RTD/Data by novice users.
Pls mail us your client id to [email protected], we will increase this to the maximum of 3000
Pls …
@Maddyms7
VBA knowledge is must to build Trading system in Excel.
We already have sample excel platform built with KiteNet (.Net Library) and Kite API.
This sample excel platform is as good as Traditional Trading Platform with Market Watch, Admin…
@Jegan
CO entry order is not allowed for modification by OMS.
Your are left with 2 options
1. Use Order Type MARKET
2. cancel old entry order (sl order will be cancelled automatically) and enter new one (take care of throttle)
@arunpanjala
Trade-updates are not supported by Kite API, it is just provided for compatibility with Upstox API.
Only order updates are sent by Kite API
@impratikthakkar
CheckExecutionLatency function will not work as zerodha blocks order with invalid price, so you can ignore.
To test order placement, you can try placing a manual order using order window.
To debug, remove error handling from the…
@deepmangukiya
You are only permitted to change the trigger price not the limit price.
Limit price is assigned by OMS (up to upper/lower circuit). You should pass the same Limit price in your request
In the above request
parent_order_id=130000000…
@kulguru
For exiting you can pass id of any childorder i.e. Target or Stoploss or csv of childorders.
Example:
Assume you have Parent OrderId i.e. Entry OrderId
Just call the GetChildOrders to get comma seperated list of childorders and pass it t…
@raaghulr
Here is small list
https://www.nseindia.com/products/content/sec_bhavdata_full.csv
https://www.nseindia.com/live_market/dynaContent/live_analysis/pre_open/all.json
https://www.nseindia.com//homeNextDate.htm
https://www.nseindia.com/l…
@sujith
Everything was fine today.
Also we are able to place order in non-market hours and receive proper order id from OMS.
Is there anything you fixed at your end?
@sujith
We are also facing this issue.
We got this, when we tried to place order in NSE and NFO in non-market hours.
Looks like instead of throwing web exception, kite server responds with status 200 Ok.
Earlier we get web exception from kite s…
@RameshS
Let's check it through Remote Desktop.
Mail your AnyDesk Id to help @howutrade.in
Available Time: 10AM to 01Pm and 02PM to 05PM
We will try to connect within 30mins of receiving mail
@vmm
We suspect some intermittent network issue.
Only yourself and another user reported this issue, working fine for rest all users.
If the issue is persistent or occurring more frequently, let us know.
@vmm
It is a false alarm.
The installer uses .bat file to register the DLL., AV's raises false alarm because of .bat files.
If you are not comfortable, then download the DLL files and register as usual.
Links available at the end of the web page …
@Sudheer
The invalid checksum error indicates, wrong API key or secret or both or API expired.
You can try the following;
1.Go to https://developers.kite.trade/
2.Re-Generate your API Secret
3.Save your API subscription
4.Open settings window in…
@SanjayKrSao
The syntax for PlaceBO function is
PlaceBO(Exch,TrdSym,Trans,Qty,LmtPrice,SqOffValue,StoplossValue,TrailingStoploss,OrdType,TrgPrice,CTag,TagAPI)
For your example, the formula will be
OrdType = "SL"
LmtPrice = 101.00
TrgPrice = 100.5…
@Avnesh
You need to open your Excel application as Administrator and then open your workbook from File Menu.
https://digital-qa.blogspot.com/2013/02/open-excel-in-administrator-mode.html
@linkin7827
The GetLastOrderId is not a API function, it manipulated at application level.
This will return the order id of the last order placed through your application (Excel/API).
@ambooj
We will be available on the below time.
1000AM to 1100AM and 0400PM to 0500PM
Ping your AnyDesk id to [email protected] within the above mentioned time slot, we will check the issue through Remote Desktop.
@y3ec884
You can download the KiteNet dll files from the below link which also includes latest sample/demo excel workbook.
https://codeadvisor.in/trading-apps/
@Avnesh
Pls make sure you have the system requirements as specified here
https://howutrade.in/docs/kitenet/html/Introduction.htm#Section7
If still facing error, drop a mail to [email protected] with AnyDesk id.
We will try to connect within 30 mi…
@jenish_shakti
Yes, websocket will not work behind proxy. We have tried all, but we didn't make it work. So we stopped researching further on this. If we make it in future, let you know.
But it is highly recommended and advised to run trading sys…
@Kailash @sujith @tonystark
Could you pls look in to the below issue on priority?
'null' value for products and order_types in access token response.
{
"status": "success",
"data": {
"user_type": "",
"email": "[email protected]",
…
@Sreenath
[APPDIR]\KiteNet\[DDMMMYYYY]\KiteNet_Logs.txt
or
[APPDIR]\KiteNet\[DDMMMYYYY]\Debug.txt
In case of excel, the app directory is ‘My Documents’
@catchmaheshkcf
Currently, no such function available in our KiteNet DLL.
But Kite API provides this information.
https://api.kite.trade/margins/equity
Text/Csv Format: https://howutrade.in/brokerdata/symbol_list/equity_margin.txt
Html Format (T…
@madhukar
Make sure you called SubscribeQuotes.
Did you get any error while calling SubscribeQuotes(Exch_Index, Symbol_Index)? Post the output of this formula.
Could you post the Exch_Index and Symbol_Index you tried?
(Copy and paste from the ex…
@madhukar
You are able to trade whatever the symbols they are sending in the Master contract.
Yes, Nifty weekly contracts are available in the Master Contract.
@catchmaheshkcf
This is the default limit set in KiteNet.
We have removed this limit for XU9837, now you can subscribe to the maximum permissible tickers i.e. 3000.
In order for the changes to take effect, pls close and re-login in excel.
@madhukar ,
We haven't released any new updates.
Regarding the 'Version Update message', this popup will come only when new updates are available and will go off once, you update the DLL. Ideally it should not popup now as no updates are there.
Ca…
@ZZ8030
The best way to do this, virtually trail your mtm in excel and when your PnL crosses below your trailmtm, then call ExitBO to close your BO position.
But if still want to modify all SL order, then you can use the below code;
'This is gene…
@krtrader
Most of the discount broker's are started offering rest API.
We have tried all, but when it comes to reliability and stability, then Kite API is at top.
We agree that some time you may face tech glitch with Kite API, but if compare wit…
@ZZ8030
Looks like, you are using old DLL.
Could you install latest DLL from here and try?
For testing, you can just use the ModifyOrder window from dashboard sheet.
Try modifying the BO stoploss order using ModifyOrder window.
@mayurpatwardhan
GetRTD is a UDF which wraps the complex excel RTD function, so that you can easily use it in a excel cell. Post market hours, you will get 0 for most of the field.
Excel RTD is weird. Below are the some of the reason's that lead…
@AkashTawade
This 'net' and 'day' positions mainly affects Futures positions/trades.
Example case:
Yesterday, you bought 1 lot of Nifty
Today, you sold that 1 lot of Nifty
Net Position
Nifty Qty = 0
Day Position
Nifty Qty = -75
@mayurpatwardhan
If you are getting data in MarketDepth Window (Excel) or GetLtp method, then Excel RTD might have corrupted. Excel RTD may corrupt for many reasons, the best solution is repair MS Office.
You can refer this thread https://kite.tr…
@raja1sttarde
The difference in the OI at 1530 Hrs & after 1630 Hrs is due to "the clearing member trade settlements" that happens after normal market close. Trade volume remains same, only the OI changes based on the clearing and settlement.…
@ZZ8030
You should pass the order id of the stoploss.
For the error, this may be due to the one of the reasons mentioned below;
1. You are passing Invalid order id (Error: OrderId is not found)
2. You are passing Wrong order id (Error: Order is …
@chiragkeswani
Is it possible?
Yes..
But it may (will) not work efficiently. Because,
1. Excel is single threaded.
2. Frequent reading/writing values from/to excel cell will drastically affect performance.
3. Tracking multiple symbols will reduc…
