@HowUTrade
I have been not able develope any stable excel strategy that is also profit making....any suggestions or should I give up on kite connect API. Thank u
@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!
Error
PVR19FEBFUT is not valid symbol ...Google cloud
Aloe as I erlier asked get rtd for indexes is not working on cloud though it work…
It worked! Thanks! It's been 3 months and still looks like I don't know enough about using kitexl effectively! Steep learning curve!
Anyways kitexl is still the best trading platform!
@HowUTrade
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!
@HowUTrade
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…
We have set 5000 as limit. So you won't have any problem up to 3000 symbols......created the option chain yday and reached the limit of 3000. Id doesn't seem it's set to 5000?
@HowUTrade
*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…
Every PE or CE option for every strike price for same symbol will be considered as different ticker?
And unless we have data streaming how we going build option chain or option Greeks?
@HowUTrade
Okey! Is it future possibility? Or can we do somehow in Python App?
Also same API key and secret should work for two different instances if I could run two instances at all?
@HowUTrade
@HowUTrade looking forward to kitexl alternative for Linux based OS or OpenOffice/libre office compatibility!
By the way how many of people using kite API are using cloud computing? Just for GK!
Google cloud
Windows server 2012 4vCPU 15GB Mumbai
Office365
My custum kiteXL
Microsoft RDP
Up and running within 15min
Ping time 200ms...I mean latency time
Great experience with feel of operating my laptop itself !
Only concern…
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 but is it possible to run strategy written in kitexl to run in cloud?
Also is it possible to use office 365 in cloud to run kitexl and every possible strategy?
@HowUTrade
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?
@HowUTrade
@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…
@HowUTrade
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!
@HowUTrade what is this ExcelORB?
BTW I could do workaround by using mtm , max and min functions to exactly replicate BO except for slippage that occurs with real world market orders!
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 have mailed bridge logs, pls check.
as per documentation, is it ok to pass main leg order id to exit bo ?
still modifyboslbridge doesnt seem to work!
by the way i have upgraded kitexl dll
@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
@sujith
@HowUTrade
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??????…
@shweta basically i am PhD medical student , didn't know even Excel VBA few months back , and don't have Ninja subscription even if I were to try it! U can try yourself and learn through mistakes!
@HowUTrade
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 ?@HowUTrade
@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…
Despitr It being bridge method , after IF condition is met will it go on firing opposite order multiple times ? It will require another piece of code to prevent multiple firing?@HowUTrade
@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
End Prope…
