Hello,
I'm trying to build a UDF to calculate the average return of a stock over periods of time, based solely on the stock prices each month. I built this code in order to store the individual return values in an array, and hopefully take the average of that array, however it isn't working and i'm not sure why.
ExcelProblem.jpg
You should use the code tags instead of inserting a picture.
For one thing you don't need the as Double after Redim.
The other thing is arrays start counting at zero.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks