☰
Login
Signup
Home
›
.Net / VBA / Excel (3rd party)
Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Sign In
Register
Categories
Recent Discussions
Activity
Categories
13.8K
All Categories
0
Incidents
153
Node JS client
40
Go client
793
.Net API client
378
Kite Publisher
537
.Net / VBA / Excel (3rd party)
457
Algorithms and Strategies
993
Java client
1.1K
API clients
404
PHP client
4K
Python client
346
Mobile and Desktop apps
1.4K
Market data (WebSockets)
3.3K
General
In this Discussion
November 2018
gkumbhar
November 2018
HowUTrade
Change in OI
gkumbhar
November 2018
in
.Net / VBA / Excel (3rd party)
Hi,
I am trying to get the change in OI field in KiteXL, however getting error that field is not available. Can you help to get this one in Excel?
HowUTrade
November 2018
@gkumbhar
You can find the all the supported fields
here
gkumbhar
November 2018
Thanks but when I am trying to fetch the data it shows only 0, does that field returns any value?
HowUTrade
November 2018
@gkumbhar
We will check this with our tech team and get back to you.
gkumbhar
November 2018
Hi, did you get anything on this? This is really urgent for me, appreciate your help on this.
HowUTrade
November 2018
@gkumbhar
Currently, Kite connect API does not stream/support this field.
This field is reserved for future use.
You can request Kite team to provide this data.
Fields reserved for future use:
LOWERCKT
UPPERCKT
SPOT
YEARLYHIGH
YEARLYLOW
OINETCHG
OIPCTCHG
If you need it urgent, you can try other alternates.
Since real-time OI is available in Kite API, all you need is previous day EOD OI.
You can use NSE bhav copy to to get previous day OI.
We also have back-up of bhav copy in ready to use state.
Html Link
https://howutrade.in/brokerdata/symbol_list/?data=bhav_fut
You can refer this
link
to know how to fetch data in to excel using web query.
Text Link
https://howutrade.in/brokerdata/symbol_list/bhav_fut.txt
This text file can be used within VBA to fetch data and it is more efficient than web query.
gkumbhar
November 2018
Thanks a lot. However I needed the CHOI real time. Do you have any idea when this will be available? Any tentative date?
Sign In
or
Register
to comment.
You can find the all the supported fields here
We will check this with our tech team and get back to you.
Currently, Kite connect API does not stream/support this field.
This field is reserved for future use.
You can request Kite team to provide this data.
Fields reserved for future use:
LOWERCKT
UPPERCKT
SPOT
YEARLYHIGH
YEARLYLOW
OINETCHG
OIPCTCHG
If you need it urgent, you can try other alternates.
Since real-time OI is available in Kite API, all you need is previous day EOD OI.
You can use NSE bhav copy to to get previous day OI.
We also have back-up of bhav copy in ready to use state.
Html Link
https://howutrade.in/brokerdata/symbol_list/?data=bhav_fut
You can refer this link to know how to fetch data in to excel using web query.
Text Link
https://howutrade.in/brokerdata/symbol_list/bhav_fut.txt
This text file can be used within VBA to fetch data and it is more efficient than web query.