Support Board
Date/Time: Mon, 22 Dec 2025 21:56:35 +0000
spreadsheet help
View Count: 219
| [2025-11-05 18:22:23] |
| User411320 - Posts: 359 |
|
Hello all, I'm using J3 a constant in a formula but no matter which value I input in J3, it has no effect on the results of the formula. What am I doing wrong? |
 Screenshot 2025-11-05 131254.png / V - Attached On 2025-11-05 18:20:31 UTC - Size: 985 B - 30 views Screenshot 2025-11-05 131313.png / V - Attached On 2025-11-05 18:20:40 UTC - Size: 913 B - 32 views |
| [2025-11-05 20:22:49] |
| John - SC Support - Posts: 43581 |
|
What cell are you entering your formula into? Is this a Spreadsheet Study or a regular spreadsheet (started with File >> New Spreadsheet)? We do wonder if this might be an order of operations issue. You are subtracting numbers that are multiplied together. The multiplication will occur first, then the subtraction. So if BK3 is zero, then you will always get the same result (T3). For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-11-06 15:34:49] |
| User411320 - Posts: 359 |
|
John, The cell being used is U (attached photo) This was created by selecting "Spreadsheet study" from the Studies Available. I did have to change the formula source sheet number as this chart was created by duplication of another. I also did think it may be order of operations but I'm copying the formula from a book |
| Screenshot 2025-11-06 103309.png / V - Attached On 2025-11-06 15:34:43 UTC - Size: 7.01 KB - 24 views |
| [2025-11-06 18:53:25] |
| John - SC Support - Posts: 43581 |
|
Check what is stated in cell D1. That specifies the Formula Source Sheet based on the Inputs. Make sure it is set to the same Sheet number as you are using for this formula. Otherwise, we can not think of any reason for there to be an issue. If you are still having a problem, then get us that chart and spreadsheet by following these instructions (you need to add the Spreadsheet file itself, which has an extension of .scss): Support Board Posting Information: Providing Chartbook with Only a Single Chart For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-11-07 13:20:06] |
| User411320 - Posts: 359 |
|
John, I was able to get it to work by creating a new chart. I have another question, when dealing with price changes. Is there correct way E3-E4 or E4-E3? Thanks |
| [2025-11-07 16:13:50] |
| John - SC Support - Posts: 43581 |
|
In the end, it really doesn't matter. You just have to be careful to understand which direction you are looking in order to know what a negative or positive value represents. If you are just looking at the magnitude (absolute value, so you don't care about positive/negative) then it really doens't matter at all.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-11-07 16:56:03] |
| User411320 - Posts: 359 |
|
I ask because when I used ABS(E3-E4), and use the standard deviation study based on the formula it removes all data after each new bar. When I use ABS(E4-E3) it doesn't have the issue
|
| [2025-11-07 18:29:37] |
| John - SC Support - Posts: 43581 |
|
Exactly what data is being removed? Can you get us "before" and "after" images?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-11-08 20:30:30] |
| User411320 - Posts: 359 |
|
John, attached are before and after photos. The picture with values is before any changes. The picture without values is after changing the length of standard deviation. During market hours, whenever a new bar is formed it does the same and I have to recalculate all values. |
| Screenshot 2025-11-08 152715.png / V - Attached On 2025-11-08 20:30:15 UTC - Size: 3.25 KB - 22 views Screenshot 2025-11-08 152646.png / V - Attached On 2025-11-08 20:30:22 UTC - Size: 12.15 KB - 20 views |
| [2025-11-10 15:05:44] |
| John - SC Support - Posts: 43581 |
|
Please get us that chart and spreadsheet file. Follow these instructions to get us the chart itself: Support Board Posting Information: Providing Chartbook with Only a Single Chart And then follow these instructions to get us the spreadsheet file. The file extension for the spreadsheet is .scss: Support Board Posting Information: Attaching a File (Optional) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-11-10 20:05:09] |
| User411320 - Posts: 359 |
|
Attached is what you asked for
|
 Chartbook5.Cht - Attached On 2025-11-10 20:03:44 UTC - Size: 4.22 KB - 28 views Private File |
| [2025-11-10 20:29:45] |
| John - SC Support - Posts: 43581 |
|
You have a circular reference occurring. You are taking the data from Cell K, then having a study doing a Standard Deviation on it, and then looking for that data back in the spreadsheet and then manipulating it. Do not use the "Standard Deviation" study, rather use one of the "STDEV()" functions in the spreadsheet itself. Refer to the following: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#STDEV_Function For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-11-11 14:52:50] |
| User411320 - Posts: 359 |
|
thank you I will try that
|
To post a message in this thread, you need to log in with your Sierra Chart account: