☰
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.3K
All Categories
0
Incidents
166
Node JS client
46
Go client
811
.Net API client
391
Kite Publisher
538
.Net / VBA / Excel (3rd party)
469
Algorithms and Strategies
1K
Java client
1.1K
API clients
408
PHP client
4.1K
Python client
354
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