Support Board
Date/Time: Sat, 10 May 2025 21:58:07 +0000
Post From: Custom Spreadsheet Study not recalculating with changes.
| [2018-04-20 16:14:56] |
| 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 - 281 views |