Forum

Exponential Moving ...
 
Notifications
Clear all

Exponential Moving Average (EMA)

3 Posts
2 Users
0 Reactions
199 Views
(@mscheweer)
Posts: 8
Active Member
Topic starter
 

I have calculated in 3 steps the EMA for 1600 rows. This with the use of a Index column. Running this query costs a lot of time. Does anyone know a faster solution? 

 
Posted : 07/06/2022 2:59 pm
Alan Sidman
(@alansidman)
Posts: 222
Member Moderator
 

How about supplying us with a sample file that we can analyze.  You have not provided enough data.  

 
Posted : 08/06/2022 8:23 am
(@mscheweer)
Posts: 8
Active Member
Topic starter
 

Hello Alan,

I have created a small sample sheet and attached it to this post. I like to have a query that generates the EMA as calculated in Column H without the use of index function. 

 
Posted : 09/06/2022 1:26 am
Share: