Support Board

Date/Time: Thu, 02 May 2024 00:48:54 +0000

Post From: Custom Spreadsheet Study not recalculating with changes.

[2018-04-18 16:48:01] Link To Thread - Link To Post [Go To First Post]
Mooshu22 - Posts: 25
I have a signal I created that is not recalculating when changes are being made anywhere in the chartbook. I am wondering if I am asking too much of the "spreadsheet system for trading"? I am calculating this signal in four steps: #1: I have a custom spreadsheet formula I created in column W: =((E3-MIN(D3:D43))/(MAX(C3:C43)-MIN(D3:D43)))*100. #2: Then smooth this column of data to a line by using a sierra chart built in study which charts to column AF: Hull MA (HMA); setting "based on data" to the spreadsheet, "input data" to column W, length 20. #3: Repeat steps #1-#2 with slightly different settings in column X and the HMA charts to AH (similar number of rows and HMA length for the settings) #4 Next I have a column Y setup to determine if line AH is greater or less than line AF data. The data in columns AH and AF are only posting row AF3 and AH3 when changes are made and rows AF4,AF5, and so on are blank. The only way to get them back is to close the chartbook and open or right click in the spreadsheet and "recalculate all formulas." Is there a setting I am missing to get these HMA columns to recalculate? Thank you-