Tagged with self-referencing - Visokio Forums http://forums.visokio.com/discussions/tagged/self-referencing/feed.rss Mon, 30 Oct 17 18:32:42 -0400 Tagged with self-referencing - Visokio Forums en-CA Formulae: Moving Average on the previous row's result? http://forums.visokio.com/discussion/2530/formulae-moving-average-on-the-previous-rows-results Wed, 23 Apr 2014 11:11:58 -0400 Oke369 2530@/discussions Please can you assist, basically I have attached 3 files, Automation Excel, I am trying to replicate this formula on Omniscope. if you look at k17 the formula is a moving average, then in cell k18 the formula changes by referencing cell k17 and then Adding a few variables.

In stock I've added a few of my failed attempts at the formula, I would just like clarity on where I'm going wrong. I manage to get the first 3 results. correct but then it seems to loop?
Please let me know if you need anything else.
thank you, Stephen]]>