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