GetOrder* , GetChildOrders etc takes order id of Live orders i.e. id of original orders placed to OMS.
If you pass the order id of paper trade(this id just allotted by application), then those functions will throw error as it is not a valid live ord…
@madhukar
'IsLive' is automatically changed to 'False' for the below function even if you set it to 'True'
PlaceBObridge
PlaceCOBridge
PlaceRegularOrderBridge
Your clientId must be enabled from our end to use those functions.
Yes..
Just you need to modify the PlaceOrder UDF to place order only once for a signal..
You can refer this link for example
https://howutrade.in/2017/08/31/restrict-multiple-order-firing-excel-upstox-api/
GetPreviousValue:
This is very similar to GetPriceSide and GetPriceChange, except that it will return the previous value.
As you know excel cell will always display latest value, we don't have reference to what value it is changed from, in that case…
GetPriceChange:
This is similar to GetPriceSide, except that it will return the difference between the latest value and previous value.
Example:
If the LTP is changed from 485.55 to 485.85, then this function will return 0.3 i.e. Latest value - Pr…
@madhukar
GetPreviousValue, GetPriceChange and GetPriceSide are utility functions purely meant to use with Excel and has no connection with Kite API.
Let explain with example:
GetPriceSide:
As you know when a cell value is updated through formu…
@madhukar
This function is purely meant for Excel and it has no connection with Kite API.
Let illustrate with example.
Assume you bought 100 Qty of Stock 'AXISBANK'
and want to exit when your loss reaches -300 and also want to move your max-loss …
@madhukar
We are working on sample trading systems in Excel & AFL (around 5 each).
We will let you know once it is ready..
This samples will be a complete and full-fledged trading systems and developers can use those as start point.
@catchmaheshkcf
Glad, you got the answer.
We totally forgot this thread...
Couple of points...
The historical data provided by Kite API is purely meant for offline back-testing/analysis.
You can easily import the data in to existing excel sheet …
@madhukar
If you are doing it once, then no issue.
But if you write continuously on real-time , then excel will hang/crash as it is mostly single threaded.
@madhukar
You are just creating a new property.
You have to set the property at the time of Kite initialization.
Ex:
Public Kite As New Kite
Kite.LogTicks = True
@catchmaheshkcf
KiteXL just returns whatever the data received from Kite API.
KiteXL will not modify or truncate the data.
As per NSE...
Day Open : 871.85
Day High : 876.75
Avoid comparing Chart High with Day high, most of the time it will never …
@HAs
This is because, when you enter fixed time like '09:15:30' in a cell, it translates to 00-Jan-1990 09:15:30 and the system time translates to 13-Oct-2018 08:15:00.
You can clearly see, D1 is greater than E1 i.e. D1 is earlier date.
So we nee…
Hope, you installed the test version, if not pls install.
You can try couple of things;
Try refreshing RTD from settings window.
Try placing a another buy or sell order and see whether it updates or not (during market hours)
@HAs
Basically, LimitPrice is forced to limit users risk.
If you want your order to be executed like MKT, then place your limit order with haircut.
But be ready to accept any risk.
Example:
For options, you can use 5 - 10% as haircut and for othe…
Better, you re-register the DLL.
Post install of MS office, restart computer, the register DLL.
Install test version from the below link, it has some bug fixes.
https://kite.trade/forum/discussion/comment/17705/#Comment_17705
It is a mistake from our side.
We have rectified, you can re-download the DLL form the link shared above.
You can find the log file at
[AppDir]\KiteNet\[ddMMMyyyy]\Debug.txt
This token exception is thrown by kite server.
Make sure you entered correct API and secret key.
You can try clearing browser cookies and cache.
Try manual login.
@Sreenath
Are you using KiteNet? If yes
Then this issue is already addressed.
Just replaying..
ModifyBOSl expects a order with type "SL-M".
Recently Zerodha, changed the Order type of the BO stoploss order from "SL-M" to "SL" as…
Yes, on below conditions.
1. You just need it one time.
2. You have subscribed for Historical API
Here you go GetHistDataBatch
Basically, historical OHLC data is provided for off-line backtesting purpose.
Even if you want to use it for real time…
There is no such thing like 'Entry price for script'
There's exists only executed price.
You can call GetOrderFilledPrice to get the executed/filled price
It's a bug.
Fixed in the test version.
Download the test version from here
https://howutrade.in/downloads/kitenet/?version=test
Post install if get error in excel, try this troubleshooting
https://howutrade.in/2018/07/17/excel-error-activex-compone…
P.S.
The above is very basic example,
as usual add static variables to restrict multiple order firing and check of null/invalid values before placing order.
@HAs
GetSellTrailPrice function will trail your sell price by the given trail points. You can take action on the trailed price.
Assume,
You just shorted axisbank and want to trail by every 0.5 move in your favour
A1 = "AXISBANK"
B1 = 480.00 (LTP…
@catchmaheshkcf
Exit price of CO is nothing but the average filled price (Executed price) of the child order (2nd leg order). The child order is a SELL order if main order is BUY and vice versa.
Just get the order id of the child order and call
C…
@HAs
There is no concept of pending order qty for script, we hope you meant 'Pending Order Qty for a Order'.
Pending Order Qty = TotalOrderQty - TotalFilledQty
You can use the below function
https://howutrade.in/docs/kitenet/html/M_KiteNet_Kite_G…
@krtrader
Yes, a novice trader uses MARKET order and the professional one uses LIMIT order.
We always use LIMIT order for entry.
You can cancel a order if not executed within certain period (We use 60sec).
You can refer this link https://kite.tr…
We ran into some serious issues (malware attack) which we have never faced in the past in our server that forced us to shut down our primary server.
We had to destroy our server and had to rebuild everything from backup.
Now the issue is rectifie…
@ashish8844 @catchmaheshkcf @xh2025XH @GasTurbGuy @Sudheer
Sorry for the inconvenience, we understand the pain as a developer and trader.
This is first time we ran into critical issue in the last 1½ years.
Other than today's issue, KiteNet has n…
@catchmaheshkcf
Sorry for the inconvenience.
Pls follow up here.
https://kite.trade/forum/discussion/4878/announcement-howutrade-server-under-maintenance
Issue with KiteNet.
Pls contact @sujith to claim your deleted api subscription.
You should n…
@ambuj85
Sorry for the inconvenience.
We ran into some serious issues in our server that forced us to shutdown our primary server. This was an unexpected issue.
We are doing our best to bring the server up.
We 'll let you know if any update.
@prateekthakore
This means Kite is unable to connect with OMS.
Either OMS is down or some BOD process is going on.
You can just ignore and try after 0800 am.
This happens normally at the below period.
0200 - 0600 Hrs
0700 - 0800 Hrs
Note the ti…
@HAs
Just remove the error handler 'On Error Resume Next'
and run the code.
If any error in the code, it will be thrown.
Post the actual error you got here.
@HAs
CancelRegularOrder(OrderId) will cancel the passed OrderId if it is OPEN.
and it will not exit any position.
You have to place a opposite with same qty/product to close your regular/exit positions.
@vischenera
Seems Network issues at your end as it's working fine for others
As this is intermittent , you can ignore this.
Optionally you can try on different Computer/Server and ISP/Network to see whether it work there or not.
@catchmaheshkcf
The GetOrder* functions will return values only for real orders.
Paper trading is very limited option to check simulated PnL on your Buy/Sell/Short/Cover.
https://howutrade.in/docs/kitenet/html/Introduction.htm#Section25
Here is t…
@catchmaheshkcf
All order request functions such as PlaceCO, ModifyCOSl etc are synchronous commands.
So it will either return OrderId (If everything is ok) or will throw error on timeout.
Here the timeout occurs mainly for 2 reasons.
1. Network c…
@catchmaheshkcf
You need to call GetChildOrders function by passing the OrderId returned by PlaceCO to get the child order.
To put it simple:
PlaceOCO will return OrderId of the MainOrder i.e. Ist leg. You need to store this OrderId.
GetChildOrde…
@Siddharthak
We do not represent Zerodha.
But what we have stated is fact.
Links related to this..
https://tradingqna.com/t/why-does-the-same-technical-charts-for-the-same-stock-from-nse-tame-google-finance-yahoo-finance-amibroker-not-match/1688/…
@HAs
Auto-Refreshing OrderBook will kill your Excel.
Still you want to go ahead, then you can use Application.OnTime to pull OrderBook at required interval.
@Siddharthak
To put it simple:
A liquid stock may be ticking more than 100 times in a second. A tick means any changes in the price like a trade has happened, or someone changed his limit price or cancelled a limit order or placed a new limit ord…
Are you running in cloud server?
and are you blocking howutrade.in?
Try opening howutrade.in in web browser.
Let us know if you are able to view our website.
@dadu369
Any other stocks having such issues? or its only SAIL?
If its only SAIL, then RTD might have missed this data.
RTD uses Udp protocol to send/receive data.
@vischenera
If the connection to Kite server is timed out, then 'value can't be null' error is thrown.
This normally occurs during high network traffic time like Market open and close time etc.
This will error will go off automatically on retry.
…
@ambuj85
To get index data,
Use exch as NSE_INDEX
You can find the indices list post login in the below folder.
My Documents\KiteNet\[ddMMMyyy]\NSE_Index.txt
@YB0320
There is no specified sequence of child orders (i.e. target and stoploss).
Child orders are stored as it is received.
So the sequence may be anything like tgt,sl,sl,tgt or sl,sl,tgt,tgt etc
But you can easily separate tgt and sl at user l…
@dadu369
Regarding 'Automation Error', you can refer the below link.
This is a very peculiar issue with excel.
https://howutrade.in/2018/07/17/excel-error-activex-component-cant-create-object-kitenetupstoxnet-dll-update/
This error happens with …
@dadu369
(a) Yes, StgyCode is just an arbitrary name, passed to PlaceOrder function. It should be 2 characters and alphanumeric.
(e)Yes, before start of the day, you should know how many trades you are going to take, what is max margin required, …
@dadu369
(a) You can place order to zerodha in two ways.
1. Using Kite Class
2. Using Bridge Class
Place order function of Bridge accepts additional parameters like StgyCode, IsAsync etc..
Si if you placed a order in "AXISBANK" using Bridge funct…
@dadu369
A bracket order may have(most of the time) more than one child order. The child orders includes both target order and stoploss order. You can call GetChildOrders by passing order id of the Main/Entry order, this will return comma seperate…
@vmm
This happens mainly in Excel, where user changes the trade symbol in excel cell but not calling UnSubscribeQuotes.
Tickers subscribed for quotes are stored in text file in the below mentioned directory.
Pls check how many symbols are there…
@HAs
We wrapped all the DLL functions as UDF in the sample Excel workbook.
Pls check the VBA modules for all functions.
Refer this link for more details.
Post the code where you are updating the values of data grid.
Something wrong in your code.
You can just compare the data from quotesreceived event with kite directly, not datagrid.
@HAs
If you are proficient in Excel VBA or curious to learn things, then you can proceed.
Simplest example:
In cell A1, You have a formula that will display "BUY" on certain conditions and you want to place a BUY order in AXISBANK with 150 Qty wh…
Yes.... Fully...
Just need API subscription from Zerodha Kite.
You can start placing immediately.
But one mandatory requirement.
You must know Excel/VBA.
@sreejithakazhipurath
You need to enable PiBridge from Zerodha.
Cost:
For Semi Auto : Rs 500/Per Month
For Fully Auto :
Rs 4000/per month +
Appx Rs 20000/- one time setup fee (like Membership) +
You need to pass exam conducted by NSE and get c…
@uttam
I'm assuming, you are routing orders through Bridge class of KiteNet.
If that's the case then pls note 'Order routing through bridge' is available only for our Premium clients.
If you are a developer, then you can use Kite Class of KiteNet …
@sidhs
We are still working on the new release.
But this has been included in the test version.
You can download the test version from here
Install as usual.
Post install of new version you may get error in your Excel.
This is explained here
…
@srreedhar2001
We are still working on the new release.
But this has been included in the test version.
You can download the test version from here
Install as usual.
Post install of new version you may get error in your Excel.
This is explained …
@Ashok121
You can try the below logic;
Assuming,
1.You know python well
2.Using Web-sockets to listen for ticks and order updates.
Step1: Place Order
P1=kite.place_order('bo','NSE','YESBANK','BUY',1,product='MIS',order_type='SL',trigger_price=39…
@Ashok121
Do you close your application after placing 2 orders or your application will be running?
If you close your application, then no way to cancel one another..
If your application will be running, then you can write simple logic to do that.
Your IP is blacklisted https://mxtoolbox.com/SuperTool.aspx?action=blacklist:50.62.168.156&run=toolpage
We guess, you are on shared hosting or using shared VPS.
The same IP address is used by multiple domains and some of them involved in il…
@vinodhec
This is the information we got from the other Broker.
Changes has been made in OMS to place SL instead of SL-M for BO stoploss orders.
This changes has been made w.r.t exchange order.
Now on wards,
BO stoploss orders will be SL order t…
@ashish8844
You may get this error when you enter/use Invalid API key or secret or both.
While copying API key and secret from developer a/c, make sure you are copying all characters and not copying any extra spaces.
If your API key & secret …
@Shabeershah2002
All the packets when cast returns number data type (Int16 or Int32)
LastTradedTimeStamp is Unix Time not DateTime.
So DateTime.FromBinary will not work.
Yo need to do;
1. Get the Int32 (Unix time) from the packets BitConverter.To…
