• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculate Value based on Variable Time Period & Product

S

SRsubs

New Member
Hi, I have an array of data as follows:

Prod1 Prod2 Prod3 etc
Jan-05 0.1 0.05 1.15
Feb-05 0.15 -0.32 -0.53
Mar-05 0.17 -0.07 2.07
etc

The data are monthly returns, i.e. 0.1 is actually 0.1%

I'd like to be able to use this data to calculate:

2005 2006 2007 2008...
Prod1 (1+0.1/100)*(1+0.15/100)*(1+0.17/100)*etc
Prod2 (1+0.05/100)*(1-0.32/100)*(1-0.53/100)*etc
Prod3 etc

In the above the formula would just calculate yearly returns based on the available monthly data.

I suspect it's a combination of offset, product and possibly match or index functions but can't quite figure it out.

Also, if it's possible to separately choose a variable time period and product and calculate the return accordingly that would be very useful.

Grateful for any volunteer help...Many thanks....
 
SRsubs

Firstly, Welcome to the Chandoo.org forums

can you please attach a sample file with the data and expected outputs
 
You must log in or register to reply here.
Back
Top