Sierra Chart Worksheet System For Trading/Alert Discussions - Sierra Chart Programming | futures io social day trading
futures io futures trading


Notices

Sierra Chart Worksheet System For Trading/Alert Discussions
Updated: Views / Replies:12,441 / 51
Created: by tomgilb Attachments:4

Welcome to futures io.

(If you already have an account, login at the top of the page)

futures io is the largest futures trading community on the planet, with over 100,000 members. At futures io, our goal has always been and always will be to create a friendly, positive, forward-thinking community where members can openly share and discuss everything the world of trading has to offer. The community is one of the friendliest you will find on any subject, with members going out of their way to help others. Some of the primary differences between futures io and other trading sites revolve around the standards of our community. Those standards include a code of conduct for our members, as well as extremely high standards that govern which partners we do business with, and which products or services we recommend to our members.

At futures io, our focus is on quality education. No hype, gimmicks, or secret sauce. The truth is: trading is hard. To succeed, you need to surround yourself with the right support system, educational content, and trading mentors Ė all of which you can find on futures io, utilizing our social trading environment.

With futures io, you can find honest trading reviews on brokers, trading rooms, indicator packages, trading strategies, and much more. Our trading review process is highly moderated to ensure that only genuine users are allowed, so you donít need to worry about fake reviews.

We are fundamentally different than most other trading sites:
  • We are here to help. Just let us know what you need.
  • We work extremely hard to keep things positive in our community.
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts.
  • We firmly believe in and encourage sharing. The holy grail is within you, we can help you find it.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.

You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

Reply
 4  
 
Thread Tools Search this Thread
 

Sierra Chart Worksheet System For Trading/Alert Discussions

  #41 (permalink)
Trading Apprentice
sydney australia
 
Futures Experience: Intermediate
Platform: Sierra Chart
Favorite Futures: ES
 
Posts: 15 since Jul 2012
Thanks: 11 given, 1 received

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...

Reply With Quote
 
  #42 (permalink)
Elite Member
Phoenix AZ USA
 
Futures Experience: Advanced
Platform: SierraChart
Broker/Data: TradePro/TransAct
Favorite Futures: NQ YM
 
Posts: 318 since Nov 2009
Thanks: 126 given, 382 received

It could be as simple as this, in Z3:
=IF(K3,D3,Z4)

Reply With Quote
The following user says Thank You to tomgilb for this post:
 
  #43 (permalink)
Trading Apprentice
sydney australia
 
Futures Experience: Intermediate
Platform: Sierra Chart
Favorite Futures: ES
 
Posts: 15 since Jul 2012
Thanks: 11 given, 1 received


Tom,

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?

Reply With Quote
 
  #44 (permalink)
Trading Apprentice
sydney australia
 
Futures Experience: Intermediate
Platform: Sierra Chart
Favorite Futures: ES
 
Posts: 15 since Jul 2012
Thanks: 11 given, 1 received

OK seeing =MAX(F3,F4,F5,F6,F7,F8,F9,F10,F11,F12) is working
nevermind...


Last edited by luckcity; August 29th, 2018 at 02:13 AM.
Reply With Quote
 
  #45 (permalink)
Elite Member
Phoenix AZ USA
 
Futures Experience: Advanced
Platform: SierraChart
Broker/Data: TradePro/TransAct
Favorite Futures: NQ YM
 
Posts: 318 since Nov 2009
Thanks: 126 given, 382 received


luckcity View Post
OK seeing =MAX(F3,F4,F5,F6,F7,F8,F9,F10,F11,F12) is working
nevermind...

You can simplify it like this:
=MAX(F3:F12)

Reply With Quote
The following user says Thank You to tomgilb for this post:
 
  #46 (permalink)
Trading Apprentice
sydney australia
 
Futures Experience: Intermediate
Platform: Sierra Chart
Favorite Futures: ES
 
Posts: 15 since Jul 2012
Thanks: 11 given, 1 received

Conditional Stop order

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.

Reply With Quote
 
  #47 (permalink)
Trading for Fun
Merida, Yucatan, Mexico
 
Futures Experience: Intermediate
Platform: Sierra Chart, ThinkorSwim
Broker/Data: Inifinity
Favorite Futures: NQ, YM, ES, CL, GC, 6E
 
Posts: 101 since Nov 2010
Thanks: 14 given, 57 received


luckcity View Post
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.)

Reply With Quote
The following user says Thank You to bradhouser for this post:
 
  #48 (permalink)
Trading Apprentice
sydney australia
 
Futures Experience: Intermediate
Platform: Sierra Chart
Favorite Futures: ES
 
Posts: 15 since Jul 2012
Thanks: 11 given, 1 received

Thanks for taking a look.

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)

Reply With Quote
 
  #49 (permalink)
Trading for Fun
Merida, Yucatan, Mexico
 
Futures Experience: Intermediate
Platform: Sierra Chart, ThinkorSwim
Broker/Data: Inifinity
Favorite Futures: NQ, YM, ES, CL, GC, 6E
 
Posts: 101 since Nov 2010
Thanks: 14 given, 57 received

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.

Reply With Quote
 
  #50 (permalink)
Trading Apprentice
sydney australia
 
Futures Experience: Intermediate
Platform: Sierra Chart
Favorite Futures: ES
 
Posts: 15 since Jul 2012
Thanks: 11 given, 1 received



bradhouser View Post
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.

Reply With Quote

Reply



futures io > > > > > Sierra Chart Worksheet System For Trading/Alert Discussions

Thread Tools Search this Thread
Search this Thread:

Advanced Search



Upcoming Webinars and Events (4:30PM ET unless noted)
 

Fundraiser: Feeding Families in Need (ends Dec 17)

December
 

Battlestations! Show us your trading desks w/GFF Brokers ($750 in Prizes)

January
     

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sierra Chart Cumulative Delta Big Mike Sierra Chart 65 January 18th, 2015 07:21 PM
Sierra Chart and multiple trading accounts or data feeds Big Mike Sierra Chart 42 November 24th, 2011 11:25 AM
Reliability of Sierra Chart for automated trading? Xyzzy Sierra Chart 3 May 29th, 2011 06:46 AM
Using the Sierra chart DOM numbers aquarian1 Traders Hideout 9 April 3rd, 2011 11:11 AM
Attention Sierra Chart Programmers! Big Mike Sierra Chart Programming 0 March 13th, 2010 04:07 AM


Tags
adx, alerts, algos, atr, automated trading, autotrading, average, c#, chartbook, conditional, crossovers, data, divergence, dow, drawdown, flatten, futures, indicator, indicators, information, macd, macdbb, market_replay, nq, oscillator, paint bars, pivot points, pivots, programming, quotes, range bars, replay, sierra chart, sierra charts, sierrachart, sierra_chart, signal, signals, slope, spreadsheets, support_and_resistance, tf, time frames, timeframe, tpo, trade entry, trading, trading room, trading system, trading systems, trend, values, volume, volume bars, white

All times are GMT -4. The time now is 11:20 PM. (this page content is cached, log in for real-time version)

Copyright © 2018 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
All information is for educational use only and is not investment advice.
There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
no new posts
Page generated 2018-12-13 in 0.08 seconds with 14 queries on phoenix