Support Board
Date/Time: Thu, 16 Jan 2025 05:57:35 +0000
Spreadsheet trading or ACSIL DLL for Bracket Orders at Market open?
View Count: 1676
| [2017-10-16 09:43:45] |
| custodiet - Posts: 8 |
|
Hello I have developed a trading strategy that needs to do the following at Market Open- 1) Read the Open Price 930 EST for < 10 symbols 2) Lookup a reference table approx 500 rows x 6 col that contains Profit Targets and Stop Losses for these symbols 3) Pick best Trades based on very simple logic 4) Place Long or Short, Limit Orders with Brackets (using Profit Targets & Stop Losses from above) (would want to consider trailing stops on the brackets as well to maximize profits) The main issue is to get orders in as quickly as possible before Open Price slips away Profit Targets can be as small as 3 Ticks Note I already do this by hand and can successfully complete 80% of the trades manually. I would prefer to use Spreadsheet Trading to automate this activity, is it possible? or do I need to write an ACSIL DLL (which I really prefer not to) If yes for spreadsheet, where do I enter the table? and how can I change Profit Tgt + S/L's? PS I use the Infinity AT Charts version, but am open to switching to Sierra vanilla if required |
| [2017-10-16 17:25:36] |
| |
|
You should be able to do this using the Spreadsheet System for Trading study. That study is fully documented here: Spreadsheet Systems, Alerts and Automated Trading You need to go through the documentation and it will answer your questions. If yes for spreadsheet, where do I enter the table? and how can I change Profit Tgt + S/L's? Spreadsheet Systems, Alerts and Automated Trading: Initiating Trades with Auto-Trading and Using Manual or Attached Orders Exits 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 |
| [2017-10-16 17:34:26] |
| Sawtooth - Posts: 4153 |
|
If yes for spreadsheet, where do I enter the table? and how can I change Profit Tgt + S/L's?
You could also maintain a table on an added sheet that is not associated with a chart.
|
| [2017-10-16 19:32:08] |
| custodiet - Posts: 8 |
|
OK thank you very much everyone and great to know.
Date Time Of Last Edit: 2017-10-16 19:32:33
|
To post a message in this thread, you need to log in with your Sierra Chart account: