Support Board

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

Post From: Custom Spreadsheet Study not recalculating with changes.

[2018-04-19 16:13:05] Link To Thread - Link To Post [Go To First Post]
Mooshu22 - Posts: 25
This is exactly the problem and makes perfect sense now. Thank you for leading me in the right direction. I've added another spreadsheet to work around the problem however, no matter where I place the additional spreadsheet in the "Studies to Graph" list the new sheet has a CalcOrder lower than the HMA data that I'm trying to signal and has the same problem. I'm assuming the best way to work around this is to calculate the HMA data using new columns in the first spreadsheet with the HMA formula, and then referencing these new columns of HMA data in a spreadsheet with a later CalcOrder. Is this line of thinking accurate? If so, this would lead me to ask if there is a spreadsheet formula posted somewhere showing how HMA is being calculated in Sierra Charts (the actual code)? Or is this the only reference?: Moving Average - Hull Thank you for all the help. EDIT: I did some more looking and found the .scss download on that page with the calculations being made in the spreadsheet page IntermediateCalculations. I can work with that from here. If you could confirm my line of thinking in this solve I would appreciate it. Thank you once again! Date Time Of Last Edit: 2018-04-19 16:19:43