☰
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.2K
All Categories
0
Incidents
128
Node JS client
38
Go client
769
.Net API client
363
Kite Publisher
532
.Net / VBA / Excel (3rd party)
435
Algorithms and Strategies
969
Java client
1K
API clients
401
PHP client
3.8K
Python client
331
Mobile and Desktop apps
1.3K
Market data (WebSockets)
3.2K
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