Support Board
Date/Time: Wed, 27 Nov 2024 00:29:35 +0000
[Programming Help] - Can't update Buy Exit formula column in Spreadsheet System For Trading
View Count: 248
| [2023-10-11 16:53:36] |
| User562383 - Posts: 10 |
|
I made a mistake in my Buy Exit formula column and need to change it from "=AND($J8>0,ID6.SG1@3=1)" to "=AND($J$8>0,ID6.SG1@3=1)" After I change cell L3 there is no option to copy paste the formula down like usually pops up. When I ctrl-c and ctrl-p it doesn't work. If I delete cells L3-L999 I can copy the new formula with the menu option "Spreadsheet -> Paste" but then if I save and exit and reload the spreadsheet, it gets reset to the old formula. Or if I make changes and go to "Spreadsheet -> Recalculate all formulas" it reloads the old formula. Date Time Of Last Edit: 2023-10-11 16:53:58
|
| [2023-10-11 17:48:28] |
| John - SC Support - Posts: 36309 |
|
Make sure you are editing the correct spreadsheet file (as defined in the "Spreadsheet System for Trading" study in the "Spreadsheet Name" entry) and that you are editing the correct Sheet (unless you have specifically changed it, the Sheet Number is the same as the Chart Number). Also, if you are using the option for a different "Formula Source Sheet" then make sure that you are making the changes to the Formula Sheet and not to the Chart Sheet. Refer to the following items related to the above: Spreadsheet Study Inputs: Chart Data Output Specification Type Spreadsheet Study Inputs: Formula Source Sheet Specification Type Chart Studies: Settings and Inputs Tab >> Spreadsheet Name / DLL File and Function Name 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: