http://forums.visokio.com/discussions/tagged/index-formulae/feed.rss Mon, 30 Oct 17 19:11:05 -0400 Tagged with index-formulae - Visokio Forums en-CA http://forums.visokio.com/discussion/2398/analysis-dynamic-field-normalization-using-a-variables Wed, 06 Nov 2013 11:28:15 -0500 SteveMiller 2398@/discussions
I have a stock index data set that consists of the following attributes: portfolio, date, index. all told, about 18 years of daily index values for 20 portfolios. In Omniscope, I wanna choose a number of portfolios and a date range, then compare portfolio performance through the indexes. how can I dynamically create a normalized index variable that starts at one for each portfolio and date range selected? e.g. for each portfolio and date range, I wanna divide the index vector by the first value?

Thanks.]]> http://forums.visokio.com/discussion/1867/idea-dynamic-normalisation-base-index-vs-moving-index-demo Fri, 26 Oct 2012 05:27:49 -0400 davedunckley 1867@/discussions
So in the example below, I will use that start figure as 100.

So I would have a column of my data called (data) and one for the index

Data Index
100 100
50 50
25 25
11 11

But, if my start figure was say 22, the below would be displayed.

Data Index
22 100
100 454.55
50 227.27
25 113.64
11 50

In Excel, I could do it like this:-

=(C$4/B$4)*B5

Any ideas? - Dave]]>