@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…
@VenkateshV
KiteNet is a exhaustive library.
It can be tweaked to suit anyone's requirements.
Virtually everything is possible.
For your requirement you can simple do as below;
Assuming you placed your BO entry order with some tag and
want to ca…
@VenkateshV
The LIMIT price is user configurable. You can pass any value as you wish.
Whether you are using Kite class or Bridge class to place BO order, you can always set the LIMIT price as per your requirement.
"A beginner starts with MARKET o…
@VenkateshV
That's how it works. Whenever it crosses, it will return true.
If you want that to happen only once,
We just need to check whether the lastprice is crossed the level or not.
Here is the code
Public Function IsCrossFromBelow(ByVal Dic…
Hi Venkat,
You need to do it in VBA
Below is the example code to get started.
'''Created By HowUTrade
'''https://howutrade.in
'''[email protected]
'Add Reference to 'Microsoft Scripting Runtime'
'VBA Editor --> Menu --> Tools --> Refe…
@VenkateshV
You need to do it in VBA as there is no such function in KiteNet.
Below is the example code in VBA to get started.
'''Created By HowUTrade
'''https://howutrade.in
'''[email protected]
'Add Reference to 'Microsoft Scripting Runtime…
@ramana
Pls refer this link (See Remarks section)
Below is the header
LUD,LUT,EXCH,TRADE_SYMBOL,LTP,OPEN,HIGH,LOW,CLOSE,LTQ,ATP,VOLUME,TOTAL_BUYQTY,TOTAL_SELLQTY,SPOT,OI,LOWER_CIRCUIT,UPPER_CIRCUIT,YEARLY_HIGH,YEARLY_LOW,LTD,LTT,OI_HIGH,OI_LOW,OI…
@deep9686
OrderUpdateEvent is automatically raised whenever you receive updates in Web-Socket irrespective of tick data subscription.
You just need to add handler to OrderUpdateEvent .
Thanks
@Dinesh1234
KiteNet RTD server supports real time Position details.
Topic's "MTM", "NETQTY","AVGBOUGHTPRICE", "AVGSOLDPRICE", "BOUGHTQTY", "SOLDQTY"
Refer this for more details.
If you want to know all the orders placed,
You can call GetOrderIds …
@Dinesh1234
Thanks.
Few points regarding Excel:
*Excel is mostly single threaded.
*Excel will calculate a formula only when the referenced value/cell value changes.
You should not use Worksheet_Calculate to restrict order or for any other thing.…
@mail2kalai1987
It's not mandatory to use in-built web browser which uses IE.
You can use modern browsers like chrome to login.
You can refer this link for login flow.
To login using chrome;
Click on Login Manual button in KiteXL
It will open up …
@xh2025XH
This may be due to corrupted DLL registration or system specific issue.
Could you try re-registering the DLL?
Pls download DLLs from here.
Post registration if face 'ActiveX' error, pls refer this link.
@tasklive
You can ignore this message. This is a broadcast message which will go off tomorrow.
You need to update only if you get another popup which says 'New Version is available'
@tradematic
You need to use Historical data for that.
If you want to compute OHLC from live quotes, you need to write your own wrapper in VBA to store the data in text files or MS access database and calculate OHLC.
@Sudheer
Enable Log ticks in settings (Before Market Starts), this will log all quotes received from Kite Server to text file. We can check whether the quotes received or not.
@Sudheer
We checked with Nifty 200 stocks.
Data is updating correctly.
https://howutrade.in/shared/Nifty200_0908AM.htm
https://howutrade.in/shared/Nifty200_0921AM.htm
@KiteBharath
We guess you are using obsolete version.
Pls refer the below links to know more about KiteNet.
KiteNet is upgrade to KiteXL and KiteDotNet.
https://kite.trade/forum/discussion/3777/dotnet-library-for-kite-connect-api-3rd-party
https…
@deep9686
We are happy to hear ' Wonderful Wrappers' from some one in the forum, Thanks for the appreciation.
Even though, we incorporated HowUTrade as a LLP, we are not into any serious money making business. We are basically developers cum tra…
@VenkateshV
You can't just convert excel workbook to exe.
But, you can write your own app in .Net and port your excel formulas, this will surely have fast execution than excel.
@mintuhouse
That's the default behavior of Bracket Order.
In case of Bracket/Cover order, please remember cancel means exit of position.
To exit particular target order, just modify the limit price to any price higher than LTP in case of Buy or v…
@VenkateshV
You can use the GetCapturedPrice of Bridge class for the same.
Once the value is captured, even if the input is zero, it will return the captured price only.
@VenkateshV
Deleting a symbol in a cell doesn't automatically remove it from KiteNet market watch.
You need to call UnSubscribeQuotes on each symbol you want to remove and make sure you are not calling SubQuotes on the same symbol somewhere in the…
@VenkateshV
GetLTP is a function that returns something when you call (Excel) it by passing correct parameters. Since the Exch and TrdSym is static, excel is not calculating this formula automatically, the option is either make this UDF volatile …
@VenkateshV
To know %change of something, you should have base reference.
For example:
The %Chg you see in Market Depth is the change of price w.r.t previous day close.
Same way, for volume
you can use previous EOD volume or just capture the volu…
@Sudheer
We will share the test version link tomorrow, you can try this for time being.
We are fixing couple of bugs and performance issues, so update release may take time.
But the test version will suffice your purpose (Added OI High/Low).
@VenkateshV
This is how Excel works.
Excel will calculate a formula only when there is a change in the referred value/referenced cell value.
Example:
In Cell A1 = 5
Cell A2 = 6
Cell A3 = Sum(A1+A2)
Excel will initially calculate the formula in A…
@VenkateshV
You can write a function that takes your real time MTM/PnL and trails it. You can refer the trailed MTM to take any actions like exiting position etc.
The Bridge class has one such function, refer this below link
https://howutrade.in/d…
The MTM/PnL is logged per symbol across all product.
Example:
You have bought 2 Qty Axisbank in MIS and
Sold 5 Qty in CNC,
Bought 15 Qty in BO,
Bought 20 Qty CO.
The MTM/PnL will be combined of all the above positions.
You can refer this https://h…
@VenkateshV
KiteNet logs are stored in application's working directory.
For excel it is 'My Documents' (It resides in C:\)
You can change this to any folder/drive as per your choice.
Excel Options --> Save --> Default File Locations
For He…
@VenkateshV
Currently there is no function to check this.
Slippages is dynamic and depends on market conditions. You may get 1% slippage today, tomorrow may be it is 2% or 4% .
If you want to calculate slippages, you need to place real orders an…
@VenkateshV
If you have any open position (real), every MTM/PnL changes will be logged till you exit your position. This log will help you check your position performance like what is the highest/lowest MTM/PnL achieved and at what time it is achi…
@VenkateshV
1. For clarity you can keep all this common variables in a master sheet with workbook scope.
2. There will not be any performance improvement/Difference.
@VenkateshV
Thanks for notifying this.
Its a bug in .bat file, we fixed this, pls fresh download and try to install it from other drives.
Let us know the result.
@VenkateshV
1. SubscribeQuotes needs to be called only once. So you can keep a separate master sheet where you have all symbols + SubscribeQuotes function.
2. Excel is very smart, even if you call GetRTD on same symbol + field on multiple sheets,…
@VenkateshV
You can run the .bat file from any drive/folder except the below folders
1. C:\Windows\System32
2. C:\Windows\SysWOW64
Could you post the install logs here? It's available at 'My Documents\KiteNet_Install.log'
@VenkateshV
Every field is logged including the market depth irrespective of what you have in RTD.
We intentionally left the header to avoid overhead while parsing.
You can get the sequence here (Refer Remarks section)
The sequence is fixed, so …
@EquityOnSMS
You need to call UnSubscribeQuotes to remove it from websocket data subscription.
Tick data consumes large storage space.
For Example, a liquid stock will take appx 6.5mb of file size for whole market hours.
If necessary, then only st…
@EquityOnSMS @xh2025XH
The Inbuilt web-browser uses Internet Explorer to load page.
Internet Explorer behaves differently on every version and operating system and for every user.
Unless you are lucky, it may not work for you. Luck plays vital ro…
@xh2025XH
which version you are using? Try the latest version https://kite.trade/forum/discussion/3777/dotnet-library-for-kite-connect-api-3rd-party
Latest version supports manual login using chrome or firefox
.
@ddingal
The bridge class is under testing and reserved for future use.
Regardless of what you pass, IsLive will always false.
Right now you can use bridge only for Paper Trading.
Use Kite class for placing live orders.
@EquityOnSMS
As you are getting quotes in depth window, we can narrow the issue to Excel.
Try the following sequentially:
1. Ensure RTD throttle interval is set to 0
RTD throttle interval
2. Run Excel as Admin.
Most of the issues will be resolv…
@GasTurbGuy
KiteXL will work in 32 as well as 64 bit.
We have updated KiteXL, pls refer this https://kite.trade/forum/discussion/3777/dotnet-library-for-kite-connect-api-3rd-party
Hi kk,
Please be understand the kite XL is not any kind of product, hence there is no support kind of thing. It’s a SDK meant to help developers to deploy their system.
You have mentioned only a part of the conversation and which is misleading a…
@rahulchitale
You have to send DELETE Request
"https://api.kite.trade/orders/co/151220000000000?api_key=xxx&access_token=yyy&parent_order_id=151210000000000"
This will convert the Stoploss Order to Market & thus close the CO.
@jsudhams
When we place CO order, the API call will return only the 1st leg order id.
For stoploss Order Id, you have to call"https://api.kite.trade/orders?api_key=xxx&access_token=yyy".
This will Return all Orders and you have to parse it to ge…
