Formulae: EMA (Exponential Moving Average) self-referencing formula: R solution
-
Good day
Kindly assist, Please see attached Excel Sheet, The formula I'm calculating is self referencing.
Cell H15 is average formula, Cell H16 is the start of the new formula where it references the cell above.
Please advise if any more information is needed.
thank youAttachments
Stock EMA.xlsx 341K -
2 Comments
-
Because of self-referencing the answer is not going to be a simple Omniscope formula. You could use SCRIPT formula or Script operation in the DataManager.
Similar to http://forums.visokio.com/discussion/2530/formulae-moving-average-on-the-previous-rows-results
Alternatively you can try using the R operation block.
We've reclassified this as an idea, so other users can vote to enable self-referencing.
Welcome!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
Tagged
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.