Support Board
Date/Time: Wed, 29 Jan 2025 20:33:08 +0000
[Programming Help] - Spreadsheet Buy signal one time until next sell signal.
View Count: 1038
| [2018-01-24 20:58:22] |
| User252419 - Posts: 235 |
|
How can I see only 1 Buy Signal until next Sell Signal? Instead of viewing multiple Buy Signals while the Sell Signal does not appear. I'm using a Spreadsheet System/Alert, Buy Entry and Sell Entry Columns. Thank you Date Time Of Last Edit: 2018-01-24 21:02:25
|
| [2018-01-24 21:23:05] |
| Sawtooth - Posts: 4163 |
|
You need to use an additional Formula Column to create a persistent 1 with the Buy signal formula, then release it with the Sell signal formula, e.g. in cell P3: =IF(yourbuyconditions,1,IF(yoursellconditions,0,P4)) Then in K3: =AND(P4=0,P3) And in M3: =AND(P4,P3=0) This is a simplified solution; your specific situation may require modifying this concept. |
| [2018-01-25 10:22:05] |
| User252419 - Posts: 235 |
|
Thank you very much @tomgilb! It works great! Would it be possible to talk with you? Do you work for SC? Thank you! |
| [2018-01-25 14:57:43] |
| Sawtooth - Posts: 4163 |
|
I do not work for SC. I am a futures trader and an independent consultant. You can contact me here: https://www.sawtoothtrade.com/contact.html |
To post a message in this thread, you need to log in with your Sierra Chart account: