☰
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.9K
All Categories
0
Incidents
156
Node JS client
40
Go client
793
.Net API client
380
Kite Publisher
537
.Net / VBA / Excel (3rd party)
457
Algorithms and Strategies
998
Java client
1.1K
API clients
404
PHP client
4K
Python client
347
Mobile and Desktop apps
1.4K
Market data (WebSockets)
3.3K
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