Convert Excel macro to format useable in Apple Number
- Status: Closed
- Prize: $30
- Entries Received: 1
- Winner: AmolSS
I had freelancer s create a macro on excel that performed a calculation of annual compound return based on the formala you'll see in the note from investopedia below:
"Among the alternatives, the geometric average (also known as the "compound average") does the best job of describing investment return reality. To illustrate, imagine that you have an investment that provides the following total returns over a three-year period:
Year 1: 15%
Year 2: -10%
Year 3: 5%
To calculate the compound average return, we first add 1 to each annual return, which gives us 1.15, 0.9, and 1.05, respectively. We then multiply those figures together and raise the product to the power of one-third to adjust for the fact that we have combined returns from three periods.
Numerically this gives us:
(1.15)*(0.9)*(1.05)^1/3 = 1.0281
Finally, to convert to a percentage, we subtract the 1, and multiply by 100. In doing so, we find that we earned 2.81% annually over the three-year period."
Read more: How To Calculate Your Investment Return [login to view URL]
My request was to apply that formula to whatever cells in a spreadsheet that I selected; in other words, if I have a series of 95 cells with numerical data , and I selected a series of 3 consecutive cells, it would calc the resulting geometric return for those 3 cells only; if I selected a series of 7 different cells, it would give the answer for those 7, etc.
Unfortunately, I use Apple Numbers, not Excel, so the macro that was created for me won't work. I'm wondering if AppleScript or automator can be used to create the same result for an Apple Numbers spreadsheet? The excel spreadsheet with the macro is attached.
Top entries from this contest
AmolSS United States