Support Board
Date/Time: Sat, 11 Jan 2025 19:47:11 +0000
[User Discussion] - Order management via spreadsheet?
View Count: 1650
| [2016-12-22 16:27:15] |
| User305145 - Posts: 38 |
|
Hi, I am not interested in fully automatic trading, but would like to have order management automatic once I've manually entered a position. E.g. when order filled - place volume triggered stop at x and limit take profit order at y - if filled on either, cancel the other. Is this all possible via the SC spreadsheet? If so, any documentation I can look closer at? /Martin |
| [2016-12-22 18:09:28] |
| |
|
In the case of when using a Bid/Ask Quantity Triggered Stop, this cannot be automatically submitted. It needs to be manually done: http://www.sierrachart.com/index.php?page=doc/OrderTypes.html#BidAskQuantityTriggeredStopStudy Otherwise, a target and other types of stops can be automatically placed: http://www.sierrachart.com/index.php?page=doc/AttachedOrders.html 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 |
| [2016-12-22 20:42:18] |
| Sawtooth - Posts: 4148 |
|
If you want to move an Attached Order with a spreadsheet formula, you can use the Trade Management by Study study referencing a subgraph (Formula Column) that contain a formula that returns a price. If you want to exit from an Attached Order via a spreadsheet formula referencing volume, use cells L3 and N3 (of the Spreadsheet System for Trading study), and set 'Cancel All Working Orders On Exit' to Yes. |
| [2016-12-27 14:24:39] |
| User305145 - Posts: 38 |
|
Thanks tomgilb, I'm gonna have a look into this. Are you using this yourself in any form?
|
| [2016-12-27 15:41:25] |
| Sawtooth - Posts: 4148 |
|
Yes, I have, and it works great.
|
| [2017-01-06 15:28:02] |
| User787778 - Posts: 142 |
|
Is there any way to use the "Trade Management by Study" to enter trades?
|
| [2017-01-06 15:44:12] |
| Sawtooth - Posts: 4148 |
|
No, but have a look at other 'Trading:...." studies. Or use the Spreadsheet System for Trading study. http://www.sierrachart.com/index.php?page=doc/TradeStatusWindows.html#TradeDataStudies Unfortunately, the latest Trading: studies have not been documented. |
| [2017-01-06 16:17:30] |
| User787778 - Posts: 142 |
|
Thanks Tom. What I like about using more than one "Trade Management by Study" studies and a Spreadsheet Study is the flexibility to change the stop strategy, on the fly, by pressing a "Custom Study Button". Is there anyway to do the same just using Spreadsheet Studies? |
| [2017-01-06 16:58:03] |
| Sawtooth - Posts: 4148 |
|
You could use a cell in column H to enter a strategy indentifier, then a formula referencing that cell would return a price in a Formula Column based on that strategy, then the Trade Management by Study would move the Stoploss to that price. This is the only way to change the stop strategy on the fly, using a spreadsheet study. |
| [2017-01-06 17:49:17] |
| User787778 - Posts: 142 |
|
Thanks Tom
|
| [2017-01-06 18:40:14] |
| User787778 - Posts: 142 |
|
Is it possible to use a "Custom Study Button" to entry a number in a cell in a spreadsheet?
|
| [2017-01-06 18:43:54] |
| Sawtooth - Posts: 4148 |
|
No, but you could have something custom programmed using ACSIL. http://www.sierrachart.com/index.php?page=doc/SierraChartStudyAndSystemProgrammers.php Date Time Of Last Edit: 2017-01-06 18:47:19
|
To post a message in this thread, you need to log in with your Sierra Chart account: