Support Board
Date/Time: Tue, 26 Nov 2024 15:31:38 +0000
automate
View Count: 2401
| [2014-05-17 23:58:21] |
| User62789 - Posts: 6 |
|
I want to be able to automate an entry based on the confines of a set time period once it breaks out of those confines and be able to test it. I do not know how to do this. I am able to mark on my chart the high/low for time period extended and that is about it.
|
| [2014-05-18 00:52:27] |
| vegasfoster - Posts: 444 |
|
Do you know how to use a spreadsheet?
|
| [2014-05-18 01:57:04] |
| User62789 - Posts: 6 |
|
No I have looked at it but can not figure it out. How can I get some help figuring it out?
Date Time Of Last Edit: 2014-05-18 03:10:33
|
| [2014-05-18 16:35:01] |
| vegasfoster - Posts: 444 |
|
I would start by learning the basics of using a spreadsheet. SC currently uses a low features version of excel, with very basic functionality. You can right click on any cell in the spreadsheet to see available options. Search for excel training or excel tutorial to find beginner material. To speed things up you want to focus initially on cell referencing and creating formulas and you can skip past things like graphing, pivot tables, illustrations, or any other feature that's not available in SC by right clicking on a cell. If you give more details about the system you want to start with, then I can give you formulas to play with as you are learning. I need to know the studies and the order you have them on your chart, entry and exit criteria, etc. |
| [2014-05-18 18:47:13] |
| User62789 - Posts: 6 |
|
I did a tutorial on excel but have never used it. I am just starting to get familiar with the computer. I have been charting by hand for years but never on the computer. I learn fast with a little help. What I want to do is a simple process. I want to be able to pick a time such as from 6-7am or 10am-12pm find the high and low of the time period or range. I would like to use these to buy or sell a breakout of this range. I would like to place a tight stop and to exit at a set time example on close or 2pm... I would like to be able to have the ability to test different inputs such as play with the entry time and the time where I get the range,the tick amount of the stop, the time of the exit and I would like to even have the option to move my stop to break even after so much of a move or to lock in some profit after a move of n ticks in a direction. I would like to optimize this through back testing. The studies I have found to be able to draw a line at the high and low is High/Low Extended of a time frame. The only other study I have included on my chart is volume. |
| [2014-05-18 19:05:55] |
| Sawtooth - Posts: 4120 |
|
vegasfoster is very capable but you might also take a look at these tips: http://www.sawtoothtrade.com/tip-1.html http://www.sawtoothtrade.com/tip-2.html Also, SC's documentation is extensive so start here and surf through all of the links: http://www.sierrachart.com/index.php?l=doc/doc_WorksheetStudy.html Date Time Of Last Edit: 2015-08-14 02:01:02
|
| [2014-05-20 16:25:53] |
| vegasfoster - Posts: 444 |
|
SC doesn't have any optimization capabilities. You will have to manually make a change and then run it through each time. Is this going to work for you? Regardless, 1. Add the High/Low For Time Period - Extended study to a new chart 2. Add the Spreadsheet System For Trading study to your chart 3. Click on settings for the spreadsheet study and in the lower left corner, give the spreadsheet a unique name, e.g. HighLowBreakout 4. In the Input window of the spreadsheet settings set Reset Condition On New Bar - Yes Signal Only Once Per Bar - Yes Signal Only On Bar Close - No (for both) Strict Signal On Bar Close Evaluation - No 6. Click 'OK', then click on the spreadsheet tab 7. To set up the start time, in I105, 'Start Hour:' in J105, enter the hour you want to start trading in military time as an integer, e.g. for 6:00 am would enter 6 in I106, 'Start Minute:' in J106, enter the minute you want to start from 0 to 59 9. To tell it to enter short on break of low, in cell M3, =AND(TIME(HOUR(A3), MINUTE(A3), SECOND(A3))>=TIME($J$105, $J$106, 0), E3<AB3) 10. To exit at a specific time, in cell I107, 'Exit Hour:' in cell I108, 'Exit Minute:' in cell J107, enter the hour you want to exit in military time as an integer, for 2:00 pm would enter 14 in cell J108, enter the minute you want to exit from 0 to 59 in cell J29, =TIME(HOUR(A3), MINUTE(A3), SECOND(A3))>=TIME($J$107, $J$108, 0) 12. Check the box to Use Attached Orders 13. Read this and learn how to set up your stops, targets, and breakeven http://www.sierrachart.com/index.php?l=doc/doc_AttachedOrders.html 14. Think of all the things to spend your riches on :) |
| [2014-05-21 04:02:02] |
| |
|
You probably will want to use the Spreadsheet System for Trading study as has been previously indicated. Here is the documentation for that: http://www.sierrachart.com/index.php?l=doc/doc_SystemsAlerts.php 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 |
| [2014-05-22 00:17:15] |
| User62789 - Posts: 6 |
|
I have been able to get further but still do not have it right. I filled in all the cells as you said. I now have a lot of arrows on my screen. They are not in the place where the trading should start and continue through the entire chart. I want to be able to look at the results how each individual day would have turned out and be able to see the P/L and where and when I would have been filled and out of the trade. I would think that these would be marked with arrows. I would like to be able to optimize this eventually however I do need to first get it working right. I would like to get some one on one help if that is possible. |
| [2014-05-22 00:20:49] |
| User62789 - Posts: 6 |
|
Vegas I have tried what you said and I have been able to get farther in the process but not to where I want and it is not entering the trades or exiting where I want. I have a lot of green arrows on my screen. I want to see the order entries and exits marked by the arrows not just arrows everywhere. I do want to be able to optimize this eventually. One thing at a time though. I would really like it if I could get some one on one assistance with this. Is this possible? |
| [2014-05-22 01:31:27] |
| |
|
Make sure you have Automated Trading enabled . This and other information related to this is documented here: http://www.sierrachart.com/index.php?l=doc/doc_SystemsAlerts.php#IgnoredSignals 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 |
To post a message in this thread, you need to log in with your Sierra Chart account: