tag:blogger.com,1999:blog-1034836236404925218.post8484954757291831012..comments2023-03-21T07:09:43.224-03:00Comments on EE & CS: Moving Averages Using Google Apps ScriptsMarcelo Roberto Jimenezhttp://www.blogger.com/profile/00559195914754568252noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-1034836236404925218.post-23218852573602533542020-05-05T00:03:47.391-03:002020-05-05T00:03:47.391-03:00Hi Marcelo, very nice script. I am confused about ...Hi Marcelo, very nice script. I am confused about the following: for the WeightedMovingAverage(weights, values) function, when I change the weights from 20 ones to 10 ones and modify the arrayformula reference value in cell E2=10 intead of 20, the resulting average is not the same? Am I using the function in a wrong way?<br /><br />Thank you! frankn66https://www.blogger.com/profile/11082538630916380991noreply@blogger.comtag:blogger.com,1999:blog-1034836236404925218.post-39724009286316403262017-04-25T14:14:11.328-03:002017-04-25T14:14:11.328-03:00Muchas gracias Marcelo por tu rapida respuesta! Muchas gracias Marcelo por tu rapida respuesta! Anonymoushttps://www.blogger.com/profile/05672049994428505141noreply@blogger.comtag:blogger.com,1999:blog-1034836236404925218.post-32773548422488454612017-04-24T15:26:21.999-03:002017-04-24T15:26:21.999-03:00Hi Fernando,
The alpha parameter can be any numbe...Hi Fernando,<br /><br />The alpha parameter can be any number you want. If it is less than one, the average's weight is greater for larger values of the index. If it is greater than one, the opposite. If it is equal to one, you get a weightless arithmetic average.<br /><br />There is no explicit rule to calculate the parameter, it will depend upon the desired use of the average.<br /><br />Regards,<br />Marcelo.Marcelo Roberto Jimenezhttps://www.blogger.com/profile/00559195914754568252noreply@blogger.comtag:blogger.com,1999:blog-1034836236404925218.post-12873278546131827712017-04-22T05:59:25.776-03:002017-04-22T05:59:25.776-03:00Thank you in advance :)Thank you in advance :)Anonymoushttps://www.blogger.com/profile/05672049994428505141noreply@blogger.comtag:blogger.com,1999:blog-1034836236404925218.post-34365396488351141642017-04-22T05:58:47.373-03:002017-04-22T05:58:47.373-03:00Hello Marcelo,
Can you explain how do you calcual...Hello Marcelo,<br /><br />Can you explain how do you calcualte @param alpha?<br /><br />In your examples, we see 0.9 for a window of 20 days. What happens if we use a different window size?<br /><br />I have seen in other sites that the muliplier is calculated like that: Multiplicador: (2 / (Períodos de tiempo + 1)) = (2 / (10 + 1)) = 0,1818 (18,18%)Anonymoushttps://www.blogger.com/profile/05672049994428505141noreply@blogger.com