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