Annualized Returns for time range

Hi All - I am new to Alteryx i am trying to do small calculation using alteryx. I want help in designing work flow. I have monthly data which i need to annualized returns every month - the formula used in excel is

{=PRODUCT(C$2:C14+1)^(12/COUNT(C$2:C14))-1}

I need a summary of data in below format which is were i am stuck and this table will be updated on month to month basis as when the data gets added to input columns

	1 Mo (%)	3 Mo (%)	YTD (%)	1YR (%)	3YR (%)	5YR (%)	7 YR (%)	10 YR (%)	SI (%)
Input 1
Input 2
Input 3
Input 4

I want 1 month data to be latest data example= Nov month returns and rest with formula

Consolidated Sheet-1.xlsx

Reporting

Custom Tools

Connectors

Date Time

Transformation

Dynamic Processing

Preparation

Data Investigation

Time Series

Scheduler

Accepted answers

All comments

prveenk86kumar

Any help on above topic

pedrodrfaria

Hi @prveenk86kumar

I'm not 100% sure I get exactly what you are looking for.

The workflow below will assign the value per different category for the time period for each input column.

Please let me know if this was what you were looking for.

Pedro.

Annualized Returns for time range.yxmd

RolandSchubert

Hi @prveenk86kumar ,

hope I got you right. In my understanding, you want to calculate the Excel matrix formula for each input column and the defined period ranges based on the period you specified (currently Nov 2020).

You could start with an Text Input tool to define your current period (if this is not the last month). Based on this, you could calculate the start periods for the ranges and add this identifier to your data. The next steps are intended to calculate the base value (e.g. product of returns for last year). Based on this results, you can calculate the final result for each period range (did this only for some of the ranges)