@sujith is this problem specifically limited to only kitexl or for the apps in python etc...I mean is there no way to get overnight positions though kite connect API or oderids of those positions ...because usually FnO positions remain for few days …
Solved ! It was actually excel settings set to automatically update links in excel sheet on opening!
PVR19FEBFUT is not valid symbol ...Google cloud
Aloe as I erlier asked get rtd for indexes is not working on cloud though it work…
i have subscribed for 500 eq nse stocks, near date 204 fut, and near expiry 9*2*204=3672 option tickers....total 4376 but i am getting following errors !windows 10, 64bit Excel! screenshot attached!
Yes eroor was same in the celll saying 'maximum ticker limit reached' when tried to subscribe more than 3000 tickers as demanded by option chain and I used only 9 expiries per symbol!
But few days back it seemed ticker limit was no more problem…
*On successful login, client id will be checked in our data base for custom algo and enables/disables algo accordingly. (Automatic)...here u mean kitexl VBA/.net library will work only post log in? After activation?
Also what I understand is o…
Yes got it working!
5000 per instance of kitexl?
How are the orders from kitexl routed to kite connect servers? How we get data feed from kite API? Is it routed through any third party server e.g like yours? How do u get to know about orders pla…
@HowUTrade but do you guys have kept 2000 tiker limit for kitxl wrapper for KiteNet? if not i will try to subscribe more tickers in kitexl, if yes, will you please increase the limit to 3000! of course i will using much less than that but if in case…
Windows server 2012 4vCPU 15GB Mumbai
My custum kiteXL
Up and running within 15min
Ping time 200ms...I mean latency time
Great experience with feel of operating my laptop itself !
Using Google cloud , trial period to test! Windows server2016 vm , again excel 365 trial version? @HowUTrade
Running Ubuntu or non windows VM is quite cheap on Google cloud , so can I install windows VM on Ubuntu and then run excel over it?
Okey! Got it! In this video AWS is used, what I have learned in past few days is that excel has best performance with 4gb RAM, 8 core processors for hyperthreading,64bit windows environment.
This set of feature may cost a lot on AWS or any othe…
Okey that's good!
I thought we do get order update on exiting BO so that should reset BO signals.
In above method the problem would be that when order is exited by OMS , BO signals won't be reset!
Am I right?
@getsymbol has got use....I want download list ofcontracts of NFO fut in excel directly then split it , so may be syntax must be different for different fut expiry dates also different syntax for options?
And large string argument might not be …
Okey! So this method wont work without this dummy parameter in excel but should work in other applications?
Also is this possible to replicate this same method for getATP UDF? As follows by modifying getATP UDF
Public function getATP(etc..…
@HowUTrade no issues !
Thing is I didn't really needed to exit all BO in different strategies at once as of yet !
But I guess I have found it that trailing mtm directly is possible irrespective of number of orders of a pertucular symbol so ma…
ExitBOSL is working! Modifybosl is hard to configure and one doesn't really need to modifybosl every time LTP changes, that so much of work for excel and oms rather I am trailing stoploss in excel only and exiting when it is hit!
Okey! But if I use getATP in a cell or in a formula , every time the excel recalculates itself we should get latest value?
Or we need to force excel to recalculate that pertucular cell every time LTP is updated?
Why I am asking is using G…
@HowUTrade I will recheck but I was passing child orderid with SL ordertype to modifyBOSLbridge not ModifyBOSL.
But you saying modifyBOSL or bridge version of it itself checks ordertype , if that is the case then I can pass both child order IDs t…
@HowUTrade yes I could really re-register the DLLs but now when I open my kitexl workbook and try to log in there is an error ....class does not support automation or does not support expected interface
tried to reregister DLL as administrator but tying Y in command promt there is an error as "your folder contains special characters pls rename it and try". which folder , i tried renaming KiteNet_Test to KiteNetTest?
@HowUTrade I think same thing is happening with extiBObride.
I had already downloaded the latest kitexl version from a link on this forum.
So I need rewrite all my VBA code again in new kitexl also the strategy, that would be painful??????…
In live mode bridge
To exit BObridge I need to pass childorderid, but childorderids is a string of two long numbers saperated by comma, I guess first is for target and second for SL , so which one to pass?
Same for modifyBObridge , do I…
So we can deduce circuit limits by adding and subtracting 5% from previous day's close , but what if circuit limit is hit and then exchange changes the circuit limits again after a while [email protected]
@HowUTrade Okey but when live mode is enabled getOrderIDbridge should give valid order id which would be taken by other methods as valid argument , am I right? Or I need to use getorderids method to get valid order id?
Here I am talking about BO placed through placeBObride method from Excel cell directly ( not through order window which places order as windridge) i.e. source being xlbride , Syntax goes like this =placeBOBridge(A2,B2,C2,D2,E2,F2,G2,,,H2,I2,"A1","TR…
@HowUTrade xlbridge is working perfectly in Paper mode , obviously i get getOrderIDbridge , but don't get getOrderID, that seems perfectly fine in paper mode as no order is being placed to exchange.
Am I right?
Also please consider other f…
I used Excel query to read bottom 2000 lines of ticks from text file and transformed the way I want to , when I refresh the query it loads pretty much fast but it doesn't evaluate the next bottom ticks , it's the same lines of ticks when query was c…
thanks for replay @HowUTrade
since last 2 months i have learned lot about VBA but struggling to store tick data
should my my VBA look like this....
Public Kite As New Kite
Public Property Get LogTicks() As Boolean
Kite.LogTicks = True