☰
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
127
Node JS client
38
Go client
769
.Net API client
362
Kite Publisher
532
.Net / VBA / Excel (3rd party)
437
Algorithms and Strategies
966
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
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