Support Board
Date/Time: Tue, 04 Nov 2025 14:13:49 +0000
[User Discussion] - Spreadsheet for Trading = saving a value
View Count: 1045
| [2015-07-20 17:05:01] |
| djcurcio - Posts: 236 |
|
How can I save a value or condition so that it can be evaluated when another value or condition occurs? For example: If macd crossover occurred nn bars before ms crossover then ... thanks |
| [2015-07-20 17:25:09] |
| Sawtooth - Posts: 4285 |
|
Use a double IF statement, like this e.g. in P3: =IF(CROSSFROMBELOW(AB3:AB4,AC3:AC4),TRUE,IF(CROSSFROMABOVE(AB3:AB4,AC3:AC4),FALSE,P4)) The first IF starts the persistent TRUE, the second IF ends it. You will probably want to use something besides the opposite crossover to end it; this is just an example. Then in another column, e.g. Q3: =AND(P3,CROSSFROMBELOW(AE3:AE4,AG3:AG4)) Date Time Of Last Edit: 2015-07-20 18:31:36
|
| [2015-07-20 18:00:59] |
| djcurcio - Posts: 236 |
|
Could you all please invent a spreadsheet function for "If x occurs nn bars after y then". The suggested code hurts my brain. LOL.
|
| [2015-07-22 20:32:01] |
| User224651 - Posts: 28 |
|
Yes, I concur about this feature request as this is a function that we too are seeking. It would be helpful to be able to readily have a counter denoting how many bars a position has been active\filled. Is there a bar number counter in the 'Spreadsheet System for Trading' study? Or is there a way to readily store what is in the J5 or J6 cell for historical reference? |
To post a message in this thread, you need to log in with your Sierra Chart account: