Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
Sierra Chart Worksheet System For Trading/Alert Discussions
Thanks for your earlier suggestion of formulae using $j$8=0 in the J28 disable function.
As you pointed out, this allows exit of current positions after disable time rather than upon $J28 becoming TRUE.
I thought I'd like to share with the community that if you use =$j$28 in J29 (where J28 has some conditions) this
a) will disable auto trading, and
b) flatten and cancell
Assuming a) and b) what you want, this is a very simple solution.
Apologies if this is blindingly obvious, but it was a bit of a relevation to me. I hope you , and / or others in the community find this useful.
OK, Tom, taken me a while to look again at unlocking the "Locking the State of a One Time Condition" concept, and I am thinking of using the first and last seconds of the candle, specifically using J41 to calculate the 1st second, and J36 to determine the last second.
Referring to your page https://www.sawtoothtrade.com/example-9.html, the Green would go true in the first, and then false in the last second.
1. How, theoretically, does this sound as a solution?
If, again, there are too many caveats in answering this, I can take the bad news.
The ACSIL quote was $400 AUD...but not sure it will actually work as planned, so was thinking of "building a prototype" as described above, for recording one stop level.
I think there is a limitation with the potential of the prototype, though.
If the Blue formula is something like (ticks profit)>6, it will be true at 7, but it will also be true if/when it goes to 8.
2. Will it only lock-in (and store) the 7 once, or will it then also lock-in the 8, and store it after the 7 was stored?
Here is a link to the post with the scheme/diagram, to just refresh, if needed.
Hi Tom,
After some thinking, the ratio is 1 to 1, with an offset.
Drew a picture to help explain, though this stop strategy may be a bit convoluted, but wanted to try it, if it can be done.
The idea of its effectiveness may be just as convoluted
Using the Lock a Condition True is best reserved for special situations. It is difficult to get to work properly automatically, and there are usually alternatives that are more suited.
You can't store a value with Lock a Condition True; you can only store a true.
You can store a value using a persistent or incrementing variable across bars/rows, and this is the recommended method.
A specific solution for you is not possible in a forum venue because it would require an personal and individual examination of your system.
I'm new to Sierra, just wondering if it's possible to scale-in trades using the spreadsheet. I'm stuck on how to go about doing this. Any pointers would be greatly appreciated... Thanks
Yes, you can scale in using the Spreadsheet System for Trading study.
ln:12 would need to be Yes.
You will need a formula in J26 that returns the correct entry quantity for the initial and subsequent entries.
The K3/M3 formulas will need to be able to trigger the initial entry and subsequent entries.
There might be other settings and formulas to consider, depending on your specific system.
the "Locking the State of a One Time Condition" concept, and I am thinking of using the first and last seconds of the candle, specifically using J41 to calculate the 1st second, and J36 to determine the last second.