Support Board
Date/Time: Fri, 27 Dec 2024 03:30:40 +0000
[User Discussion] - Spreadsheet - can this be done
View Count: 3117
| [2015-12-06 20:05:58] |
| Jeff M - Posts: 21 |
|
Wondering if this can be done with the spreadsheet - which I believe I can handle with some pointers and trial and error. I do not think that I can learn ACSIL at my age with the documentation listed on Sierra site. I just don't get it as I need more elementary info and examples. :( There are other entry & exit conditions but this is the basic part. LONG POSITION EXAMPLE ENTRY: Immediately after the bar close that causes a moving average cross over. (I know this can be done) STOP/EXIT: Initial Stop is "x" number of ticks below the bar that caused the moving average cross. Stop moves up to 'X" number of ticks below the bar that closes below a given moving average. If not stopped out (price continues higher) stop remains here until higher price once again closes below a given moving average. At which point Stop is moved up once again to 'X" number of ticks below the bar that closes below the same moving average. If cannot be completely done with Spreadsheet (can any of the STOP/EXIT part?), am I correctly assuming that it could be done with ASCIL? Any pointers / helpful links would be much appreciated for any of this. Thank You |
| [2015-12-06 20:57:51] |
| Sawtooth - Posts: 4143 |
|
Yes, this can be done with the Spreadsheet System for Trading study, in conjunction with the Trade Management by Study study, which will move the stop based on a spreadsheet formula. However, this would not be a simple system and might require more than some pointers.
|
| [2015-12-09 17:56:36] |
| |
|
The Stop/Exit part is complicated. but you may be able to accomplish this using a formula in the Buy/Sell Exit Spreadsheet columns. Here is the documentation for the Spreadsheet System for Trading study: https://www.sierrachart.com/index.php?page=doc/doc_SystemsAlerts.php Here is the documentation for the Trade Management by Study that was referred to above: https://www.sierrachart.com/index.php?page=doc/doc_AttachedOrders.html#StudyControlledTargetsStops 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 |
| [2015-12-09 21:08:15] |
| Jeff M - Posts: 21 |
|
For the Stop/Exit, how about being able to move the stop a set # of ticks below the previous bar as each bar creates a new Hi or new Low Close depending on Long or Short. Would that be a little bit easier to do than my first question dealing with the moving average? Been trying to read all the documentation but I basically have zero coding experience (I'm relatively old) so what may seem very elementary to most, isn't quite that clear and simple to me. So with that being said and wanting to learn how to do this, am I on the correct path that I would use the Trade Management by Study study, then under Settings and Inputs tab, reference the Spreadsheet name I used for the Spreadsheet System for Trading study and then as an Input value reference a cell containing a formula that says if Close price is Higher/Lower move stop to "x" ticks above/below previous bar. And am I correct that I would use the Available Main Price Graph Identifiers such as "C" for close in my formula? To compare previous Close with the Close of the bar before that would it be something like: If C > C-1 then whatever the code is to move the stop? Still reading and re-reading trying to understand. EDIT: Just saw the Previous Bar Close study. Easier to alter & reference that study for the Bar and Previous Bar Close? And add multiple of same study and change input to Open or Close if I'm referencing them for what I want to do? My apologies if these seem like very stupid questions....I want to learn. I'm sure I may have more. Thank you, and thank you tomgilb for your response Date Time Of Last Edit: 2015-12-09 21:27:39
|
| [2015-12-09 23:52:21] |
| Sawtooth - Posts: 4143 |
|
The Trade Management by Study study needs a value, and the current value is in row 3 of a spreadsheet study, so the formula in row 3 needs to return the price where you want the stop moved to. There is no significant difference between moving the stop based on a MA or based on a new high or low, when using the Trade Management by Study study. If your system is flexible enough to use either of these, you might consider using an Attached Orders' trailing stop instead, which would not require any spreadsheet formulas, nor the use of the Trade Management by Study study. Each row in a spreadsheet study is a chart bar, with the most recent bar in row 3, and previous bars in rows below. To reference the current close price in a spreadsheet study use cell E3, so to compare it to the previous close, the formula would look like this: =E3>E4 Here are some basic spreadsheet study tips: http://www.sawtoothtrade.com/tip-1.html http://www.sawtoothtrade.com/tip-2.html |
| [2015-12-10 20:11:18] |
| Jeff M - Posts: 21 |
|
tomgilb, Thank you for the links and suggestions and with your spreadsheet explanation I have a much better understanding of the spreadsheet. Yes, the Attached orders' Trailing Stop would be great but I fail to find how to use it like I want to. Example, on a long position, a normal trail stop moves up as higher highs are achieved and the stop is off the high. What I'm looking for is a way to move the stop up based off the higher LOW of a bar that has the highest CLOSE. I recognize that a bar could have a higher CLOSE AND have a lower LOW - in this case the STOP would remain where it is as I only want the stop to move in one direction. I'm starting to get the feeling that even though I think my process is fairly simple, coding it is not, especially for a non coder. I'll keep trying to learn though. EDIT: Still need to figure this out but, maybe I should start off using the Trailing Stop off every Higher Low (no matter the bar) on a long position. It would be a good start and I can go from there as it can basically achieve what I want to accomplish although not as precise. I can use a different stop amount to try and balance it. Date Time Of Last Edit: 2015-12-10 20:24:51
|
| [2015-12-10 20:30:41] |
| Sawtooth - Posts: 4143 |
|
The Attached Orders' trailing stop cannot be based on a higher low. It can only be based on current last price movement. To move a stop based on a higher low, you'll need to use a formula and the Trade Management by Study study. The formula would necessarily have some complexity to only return a price that didn't retreat. |
| [2015-12-11 05:49:54] |
| Jeff M - Posts: 21 |
|
tomgilb I found a formula in a post of yours from last year that helped me out for what I want to do and also since it's a real example I definitely understand how the spreadsheet works now and how to deal with closing prices around MAs etc.
|
| [2015-12-12 11:56:47] |
| |
|
Refer to the documentation here to use the Trade Management by Study study: https://www.sierrachart.com/index.php?page=doc/doc_AttachedOrders.html#StudyControlledTargetsStops The documentation given is the proper procedure. At this point we are dropping out of this thread and marking this as a User Discussion because most of this is not within the scope of our support. 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: