Support Board

Date/Time: Thu, 02 May 2024 08:33:40 +0000

Post From: Custom Spreadsheet Study not recalculating with changes.

[2018-04-20 16:14:56] Link To Thread - Link To Post [Go To First Post]
Mooshu22 - Posts: 25
Thank you for the response. I have been looking at the Moving_Average_-_Hull.148.scss reference spreadsheet on how the HMA is calculated. I am trying to replicate these HMA calculations in to my own spreadsheet system to avoid the circle reference and I can't figure out how to calculate the data for Column G, Rows 3-29. I understand how the HMA is calculated in multiple steps but I don't understand how you would get results for Column G, ROWS 3-29 if the formula calculates the data this way. I attached a picture of the spreadsheet and how each column of calculations references data. It's not until ROW 30 that you get the HMA using a 25 period length. How are the results for Rows 3-29 being calculated in an HMA study that I'm adding to my chart?


HMA Question.png / V - Attached On 2018-04-20 16:14:33 UTC - Size: 43.04 KB - 235 views