Convert Excel macro to format useable in Apple Number

  • État: Closed
  • Prix: $30
  • Propositions reçues: 1
  • Gagnant: AmolSS

Résumé de concours

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.

Compétences recommandées

Meilleures propositions de ce concours

Afficher plus de propositions

Tableau de clarification publique

Aucun message pour l'instant.

Comment commencez des concours

  • Publiez votre concours

    Publiez votre concours Rapide et facile

  • Obtenez des tonnes de propositions

    Obtenez des tonnes de propositions De partout dans le monde

  • Attribuez la meilleure proposition

    Attribuez la meilleure proposition Télécharger les fichiers - Facile !

Publier un concours maintenant ou rejoignez-nous maintenant !