Hi All,
Happy Thanksgiving!!
I am trying to perform analytical function on sample data provided below:
Below is the snapshot of expected output:
Here is the analytical function I am trying to achieve:
Calculate 5 Days Moving Average only for 5th row.
For 6th row, take the value from 5th row and perform arithmetic operation.
For 7th row, take the value from 6th row and perform arithmetic operation and so on.
Here is the db<>fiddle that I have tried so far.
Below is the snapshot of formula from excel spreadsheet:
Row 5 calculation:
Row 6 and Row 7 calculation:
Similarly for other stock, the calculation remains same and continues:
Appreciate any help on this. Thanks in advance.
Thanks,
Richa