December 22, 200916 yr Newbies I am attempting to put together a database that will report figures such as YTD Return, Median, average monthly return, compound yearly returns, Skewness, Kurtosis, and other results such as Trailing 12 month returns. Does anyone have an example file I could look at that has functions like this set up so I could learn what you did to write that code? I am trying to analyze data that includes a date, a company, and their performance (in a percentage) for each month. LIKE THIS: Date Year Company Return 1/31/09 2009 xyz -0.56% 2/31/09 2009 xyz 4.53% and so on...
Create an account or sign in to comment