Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 03 May 2024 20:28:10 +0000
spreadsheet systeme trading different order quantity for buy and sell
View Count: 423
| [2022-07-23 21:10:33] |
| User719206 - Posts: 92 |
|
hello, i m using the spreadsheet automated trading system, and i'm a little confused about how it's work for order quantity. I'm using different data from the spreadsheet to set my entry point to buy or sell , and to exit with Take profit or stop loss. But first suprise I m not able to find how to set up the order quatity for buy and for sell , it looks there is only one cell the J26. I can't Imagine a software as sierra chart dont give us the way to choice different order quantity for buy or sell . I know the j26 can use a formula , so i can manage the cell to display the buy order quantity if the price is nearest of my buy entry point or the sell order quantity if the price is nearest of my sell entry point. but the J26 is also use to exit , hopefully there is the cell j 80 and j 81 to use a different order quantity , but one time more there is no difference betwen buy and sell , and i cant manage this cell with the fact she is nearest of my buy exit price or sell exit price , because there are 4 exit price ( buy stop ,but TP , sell stop ,sell TP ) I imagine that i miss something it looks impossible that a softwear as sierra dont give us a way to manage it. I tryed the "trade management by study" , but we can only choice to send order on "bar clothe" or "by second" , for a stop loss or a Take profit it's not possible , too dangerous. I need to manage dynamicaly my stop , TP and order quantity so the attached order are exclude I imagine. SO i need help , someone to help me ? ^^ Date Time Of Last Edit: 2022-07-23 21:41:20
|
| [2022-07-24 01:20:32] |
| |
|
But first suprise I m not able to find how to set up the order quatity for buy and for sell , it looks there is only one cell the J26. Use a separate Spreadsheet System for Trading study. One would be for Buy and the other for Sell. This way they have their own order quantity cell. This would be the recommended solution.I can't Imagine a software as sierra chart dont give us the way to choice different order quantity for buy or sell . Another possibility is to use ACSIL to create a trading system: Automated Trading From an Advanced Custom Study This gives you the highest degree of control. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2022-07-24 01:22:18
|
| [2022-07-24 12:36:05] |
| Sawtooth - Posts: 3993 |
|
If you would rather use just one instance of the Spreadsheet System for Trading study, try this: J26: =IF(K3,BUYn,IF(M3,SELLn,0)) J82: =1 J83: =IF(AND(L3,J8>0,E3>J9),buyTPn,IF(AND(L3,J8>0,E3<J9),buySLn,IF(AND(N3,J8<0,E3<J9),sellTPn,IF(AND(N3,J8<0,E3>J9),sellSLn,0)))) These signals will be intrabar; for close-of-bar signals, change all row 3 references to row 4. |
| [2022-07-27 23:53:23] |
| User719206 - Posts: 92 |
|
good idea tomgilb , i almost did it it's working , thanks a lot ;)
|
To post a message in this thread, you need to log in with your Sierra Chart account: