This stock analyser handles data in the form of prices, discrete or continuous returns, daily, weekly, monthly, yearly, ascending, descending,
This stock analyser calculates the maximum, minimum, mean, standard deviation, variance, amount of data, skewness, kurtosis, 95% confidence interval, standard error, median, mode, and variation, of the stock returns. It also calculates an average for every input data, and a covariance matrix. You receive the results in written form, and most of the results are also presented in chart form. You receive the input rates, prices or returns, in chart form. You may also choose to produce charts of selections of your stocks from the "Input" sheet. This application handles up to 40 stocks, and you may use up to 3670 rows for your data input. For a better view, click the image.
File size: 438 KB