☰
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.9K
All Categories
0
Incidents
177
Node JS client
51
Go client
840
.Net API client
397
Kite Publisher
554
.Net / VBA / Excel (3rd party)
490
Algorithms and Strategies
1.1K
Java client
1.2K
API clients
409
PHP client
4.3K
Python client
357
Mobile and Desktop apps
1.5K
Market data (WebSockets)
3.6K
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