Support Board
Date/Time: Fri, 07 Feb 2025 00:37:09 +0000
Post From: Spreadsheet programming question
| [2020-05-12 16:41:00] |
| Sawtooth - Posts: 4173 |
|
I struggle for the last two weeks with the persistent values and the logic part of it...
The basic format to create a persistent variable in a spreadsheet Formula Column is:If event, then value, else previous value. Here are some examples: Spreadsheet Example Formulas and Usage: Persistent and Incrementing Variables Spreadsheet Example Formulas and Usage: Return Last Two Zig Zag Reversal Values Sometimes you need to release the persistent variable with a second IF statement. What would you recommend using as a "fixed" base for persistent values
You could use a fixed value in the 'then' portion, but not for the 'else' portion. The 'event' portion is a change of state or a change of value from one bar/row to the next.Another question: I have noticed that since end of last week, when a stop moves and position closes, there is a remaining "Pending stop" displayed but not active and I can't remove it using the "x"! Have you any clue what could that come from? Is it a malfunction of the TMS?, my formula?, New SC2102, my broker API?
Most likely the latter. Check the Trade Service log.
|