☰
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
11.9K
All Categories
85
Node JS client
30
Go client
685
.Net API client
330
Kite Publisher
523
.Net / VBA / Excel (3rd party)
393
Algorithms and Strategies
891
Java client
903
API clients
383
PHP client
3.3K
Python client
310
Mobile and Desktop apps
1.2K
Market data (WebSockets)
2.9K
General
In this Discussion
May 2017
arjunmurali1993
May 2017
botany02
Get Market Depth Data into Excel using KiteXL
arjunmurali1993
May 2017
in
.Net / VBA / Excel (3rd party)
Hi
@botany02
I am building my trading app based on KiteXL and wanted to get the market depth data (just total bids and offers, no need for top 5) in addition to the LTP for all the scrips.
Is this possible? I see there is no parameter in GetRTD for this.
Can you please help?
Regards,
Arjun Murali
Tagged:
WebSocket
tick data
live streaming
KiteXL
getting quotes
botany02
May 2017
edited May 2017
@arjunmurali1993
Its there...
=GetRTD("NSE","AXISBANK","
BUYQTY
") 'For Total Bids
=GetRTD("NSE","AXISBANK","
SELLQTY
") 'For Total Offers
arjunmurali1993
May 2017
Thanks for the quick help
@botany02
This discussion has been closed.
Its there...
=GetRTD("NSE","AXISBANK","BUYQTY") 'For Total Bids
=GetRTD("NSE","AXISBANK","SELLQTY") 'For Total Offers