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
Tom,
I'm sure I asked this at some time, but not finding my notes, so must ask again.
Would like to store the low of an entry candle as a exit stop when going long, how is that done?
It was a persistent formula, I'm sure, maybe one of those double Ifs...
Can you help answer these questions from other members on NexusFi?
I like how the session start was used as a reset to start looking for highest volumes of the day in your suggested:
=IF(OR(INT(A3)>INT(A4),AND(FRACTIME(A4)<$J$75,FRACTIME(A3)>=$J$75)),0,IF(F3>O4,F3,O4))
How would one reset after 10 candles, e.g. what is the value of the highest volume in the last 10 candles?
I have a stop order successfully being set at the high of day, after certain conditions are met, using J17 and J71.
Is there a way to impose another condition, say a favorable macd, AC3>=AE3, once price reaches the stop order?
Currently, the initial stop setting conditions are in K column.
Unless I am missing something, if your order to buy in K3 is something like =Z3, then use the AND function to combine the existing formula and the new condition: =AND(Z3,(AC3>=AZ3).
(replace Z3 with whatever is in K3, without the = sign.)
OK to clarify, here is the requirement:
A stop order is successfully being set at the high of day, after certain conditions are met, using J17 and J71.
These conditions are set in K3, and basically look for a dip in prices before setting the stop order.
OK so the stop order is visible, having met those conditions.
A 2nd set of conditions to enable that order's execution, when macd is favorable, is required when price meets the stop order.
These cannot be added to K3, as those conditions were met already.
Its looking that this isn't going to be easy to do.
Instead of setting a stop order, as a workaround, tried to set a market order once the macd goes favorable AND the price reaches the high of the day (which is stored, so isn't dynamic) by using in K3, E3 (last price >= the stored high) but the "greater than" has a delayed effect where it can trigger late because macd was in transition (and price has gotten greater, but execution really should trigger when price meets the high).
Using just equals (last price = the stored high) will only trigger when the candle's last price = high, even it seems when "Signal only on bar close, K and M" is set to No.
Just to eliminate tick issues, using symbol YM, which has J21 (tick size) of 1 (trying to simplify by not referring to J21 until this gets debugged)
Are you using the Spreadsheet System/Alert? If so you should use the Spreadsheet System for trading. The difference is that in the trading spreadsheet, when K3 = 1, a buy entry signal is sent. L3 is Buy Exit, M3 is Sell Entry and N3 is Sell Exit. Using M3 or N3, you can trigger an exit if all the conditions are met. The Limit Order is not necessary.
Using Spreadsheet System for trading. Preferring the stop order. mostly just to see the targeted price before execution. Could use a limit order, but with a stop, execution is guaranteed around the required price.
