Support Board
Date/Time: Tue, 04 Mar 2025 21:59:28 +0000
[Programming Help] - Spreadsheet for Trading Question
View Count: 518
| [2022-01-06 16:45:17] |
| User769783 - Posts: 191 |
|
Is it possible to have multiple buy and sell entries using the spreadsheet for trading study? Would I place all the buy entries into one cell, etc. Or, would I need to use multiple copies of spreadsheet for trading? I am interested in using the spreadsheet in ascil for enhanced stop loss and trailing functionality, but I cannot find any examples. So this brings me here. Any information I am grateful and happy 2022 to all SC users. Thanks.
|
| [2022-01-06 18:22:45] |
| traderacefly - Posts: 57 |
|
You can put as many buy/sell entry (conditional) formulas as you want into the single Buy or Sell entry cells. You could optionally attach a spreadsheet for trading study to each individual chart that has your entry criteria defined. But even then, you can use the same spreadsheet study file and it will add an additional worksheet for each chart you attach the study to. Many ways to "skin-the-cat" with this study.
|
| [2022-01-06 18:51:26] |
| User769783 - Posts: 191 |
|
So, using a single study, how would I place multiple entry conditions into the one cell? Do I have to separate the conditions with || like in ASCIL, or do I use commas? This has been the issue really? Big thanks for your help...
|
| [2022-01-06 19:32:33] |
| Sawtooth - Posts: 4179 |
|
how would I place multiple entry conditions into the one cell?
Use the OR function:=OR(Condition1,Condition2,Condition3) |
| [2022-01-06 19:49:53] |
| User769783 - Posts: 191 |
|
Awesome. So it is just like writing alerts? Im asking because my entry conditions have multiple commas and I didn't know how to separate the conditions. But if it's like writing alerts and stuff, I should be good then. Big Thanks..
|
| [2022-01-06 21:30:36] |
| Sawtooth - Posts: 4179 |
|
So it is just like writing alerts?
Just like alerts, but with spreadsheet syntax.
|
To post a message in this thread, you need to log in with your Sierra Chart account: