☰
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
14.3K
All Categories
0
Incidents
164
Node JS client
46
Go client
807
.Net API client
387
Kite Publisher
538
.Net / VBA / Excel (3rd party)
469
Algorithms and Strategies
1K
Java client
1.1K
API clients
408
PHP client
4.1K
Python client
353
Mobile and Desktop apps
1.4K
Market data (WebSockets)
3.4K
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