☰
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
12.1K
All Categories
91
Node JS client
32
Go client
705
.Net API client
338
Kite Publisher
525
.Net / VBA / Excel (3rd party)
401
Algorithms and Strategies
901
Java client
918
API clients
386
PHP client
3.4K
Python client
314
Mobile and Desktop apps
1.2K
Market data (WebSockets)
2.9K
General
In this Discussion
January 2019
madhukar
January 2019
HowUTrade
GetSymbol method
madhukar
January 2019
in
.Net / VBA / Excel (3rd party)
This method is not working for NFO argument?
GetAvvolume...av of how many days?
GetAnnualVolatilty...I suppose daily volatility for certain day is converted into annual volatility...so how this value is provided in kitexl?
@HowUTrade
Tagged:
KiteXL
HowUTrade
January 2019
@madhukar
GetSymbol returns a very large string for NFO (appx 70000 symbols), so excel can't handle such a large string.
GetAvgVolume returns average volume (Day) for the last 3 months. This function depends on nseindia.com data and available Nifty200 stocks only.
GetAnnualVolatility & GetDailyVolatility just returns the data from here
https://www.nseindia.com/archives/nsccl/volt/CMVOLT_01012019.CSV
madhukar
January 2019
Okey!
Sign In
or
Register
to comment.
GetSymbol returns a very large string for NFO (appx 70000 symbols), so excel can't handle such a large string.
GetAvgVolume returns average volume (Day) for the last 3 months. This function depends on nseindia.com data and available Nifty200 stocks only.
GetAnnualVolatility & GetDailyVolatility just returns the data from here https://www.nseindia.com/archives/nsccl/volt/CMVOLT_01012019.CSV