Support Board
Date/Time: Fri, 07 Nov 2025 01:27:18 +0000
spreadsheet help
View Count: 43
| [2025-11-05 18:22:23] |
| User411320 - Posts: 350 |
|
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 - 8 views Screenshot 2025-11-05 131313.png / V - Attached On 2025-11-05 18:20:40 UTC - Size: 913 B - 11 views |
| [2025-11-05 20:22:49] |
| John - SC Support - Posts: 42830 |
|
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: 350 |
|
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 - 3 views |
| [2025-11-06 18:53:25] |
| John - SC Support - Posts: 42830 |
|
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 |
To post a message in this thread, you need to log in with your Sierra Chart account: