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


Sierra Chart Worksheet System For Trading/Alert Discussions
Updated: Views / Replies:10,077 / 27
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 90,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

  #21 (permalink)
Elite Member
PORTLAND, OR
 
Futures Experience: None
Platform: NinjaTrader
Favorite Futures: Futures
 
Posts: 185 since Jul 2011
Thanks: 74 given, 166 received


Poocher View Post
Thanks Tomgilb for sharing your efforts.

Any opinions on a good book to learn the Sierra Charts Worksheet (spreadsheet) programming?

I'm guessing that C Programming is harder than spreadsheet programming and I'm hoping to learn to do more with SC so hope to learn one of them.

I assume a beginners Excel book?...does it matter what year?...is 2010 Excel for Dummies better than 2007?




...this looks good:

http://www.amazon.com/Learn-Excel-Essential-Skills-Method/dp/0955459923/ref=sr_1_11?s=books&ie=UTF8&qid=1311623874&sr=1-11

I would recommend one of the online training sites, Lynda.com is known for business application training, Pluralsight is good for development stuff. Here is the link to the excel stuff on Lynda, im self taught through work but have a lot of holes in stuff I haven't needed to learn, so I am currently going through their lessons as well:

Excel Training & Tutorials

Google for the free 7 day trial, it costs $25/mo for unlimited access to all their videos which I think is a pretty good deal. If you get into other languages look to Pluralsight, same type of deal, I like to watch a C# video on their app while having lunch etc.

Reply With Quote
 
  #22 (permalink)
Elite Member
Všnersborg Sweden
 
Futures Experience: Beginner
Platform: Sierra
Broker/Data: Transact
Favorite Futures: YM,EMD,DAX,CL,CG
 
Outlander's Avatar
 
Posts: 392 since Jan 2013
Thanks: 552 given, 132 received


tomgilb View Post
Here's a handy tool to use in Sierra's spreadsheets: Locking the TRUE state of a formula condition. This is an expanded explanation of its function, based on Sierra Chart's documentation:
Sierra Chart - Spreadsheet Additional Information

This is the basic resettable locking state formula:
=AND(OR(H1=TRUE,H2>1),H3=FALSE)

The colored portions are the only things you edit.

The Red is the cell that contains the entire formula. In this example this formula would go in H1. This creates a circular reference to H1. You may need to check the box 'Iteration' in the Workbook Explorer. (Right click in a cell, choose Workbook Explorer >> Workbook Set >> Calculation >> Iteration).

The Blue is the formula that must go TRUE to lock H1 TRUE. It can be as complex as needed, it can be part of this formula, or you can put the formula in another cell and reference it, as in the example.

The Green is the cell (H3 in this example) that contains the formula to reset the locked state of H1. When H3 goes TRUE, the lock is reset. H3 must then go FALSE before H1 can be locked TRUE again.

-Tom

Tom thanks for the help I got from you in the past. I have had great use of how to lock a cell true statement. I wonder is it possible to lock a value in a cell? Lets say I have the value 50 in a cell and want to lock this value until I release it? Any help would be kind. Regards Outlander

Reply With Quote
 
  #23 (permalink)
Elite Member
Phoenix AZ USA
 
Futures Experience: Advanced
Platform: SierraChart
Broker/Data: TradePro/TransAct
Favorite Futures: NQ YM RTY
 
Posts: 295 since Nov 2009
Thanks: 125 given, 338 received



Outlander View Post
Tom thanks for the help I got from you in the past. I have had great use of how to lock a cell true statement. I wonder is it possible to lock a value in a cell? Lets say I have the value 50 in a cell and want to lock this value until I release it? Any help would be kind. Regards Outlander

I don't know of a way to lock a value in a cell, only T/F.

The only way I know to do something like it is to use formulas in the K-Z-AX array that update on each bar, but this only works with values that are updated at each bar, which is why I have asked for more Trading: ........ studies.

Incredibly, SC once eliminated all of those studies, but brought most of them back when I made a case for them, then added some others.
Trading: Studies have been removed? - Sierra Chart

Reply With Quote
The following user says Thank You to tomgilb for this post:
 
  #24 (permalink)
Elite Member
Všnersborg Sweden
 
Futures Experience: Beginner
Platform: Sierra
Broker/Data: Transact
Favorite Futures: YM,EMD,DAX,CL,CG
 
Outlander's Avatar
 
Posts: 392 since Jan 2013
Thanks: 552 given, 132 received


tomgilb View Post
I don't know of a way to lock a value in a cell, only T/F.

The only way I know to do something like it is to use formulas in the K-Z-AX array that update on each bar, but this only works with values that are updated at each bar, which is why I have asked for more Trading: ........ studies.

Incredibly, SC once eliminated all of those studies, but brought most of them back when I made a case for them, then added some others.
Trading: Studies have been removed? - Sierra Chart

Zigzag hi and lows for a worksheet - Sierra Chart

I have manage to use the formula for catching H/L from the ZigZag. So I can get the High values as intended. But the problem is that I want to use the value at the bar in progress. Now it catches the value on bar close. Regards Outlander

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

Getting the hang of SC spreadsheets

Hi Tom,
Thanks for answering a question previously on the SC forum.
Posting here this time, as looking to fire off a few more, and most recent one was ignored there
I'm assuming this is a different forum, but also realize futures.io does integrate the SC forum,
So here goes

1.
I was thinking of creating small calculations in scattered cells and referencing them, instead of managing a long string in the entry/exit cells
Which subject was the last question sent to SC, maybe it fell under "we donít debug formulasĒ category.
I had asked where best to put those, and they were suggesting at the bottom of I/J columns
Asked if using the H column was as good, as it seems to be working ok, and is more conveniently located.
2.
A general question.... are formulas a decent substitute for ASCIL?
One obstacle encountered was when signal is set to the end of the candle, and I donít think an ss formula is able to unset that.
Just looking for a "my experience is" sort of answer, as you may not have tried ASCIL.
3.
How manageable are stops in formulas, for an example, can a stop be tightened if a moving average shifts direction.
4.
Along the same lines, could a target be changed, if criteria is met, from a value in formula, to instead use one of the (trend following) studies
5.
Two more questions unanswered but guessing the answer is no.
Functions used with StudyChart Alerts And Scanning cannot be used, correct?
such as
Referencing Data Other than Last Bar
Base Graph Identifiers
(tried links but was prohibited)
can these be used in spreadsheet system for trading?

Reply With Quote
 
  #26 (permalink)
Elite Member
Phoenix AZ USA
 
Futures Experience: Advanced
Platform: SierraChart
Broker/Data: TradePro/TransAct
Favorite Futures: NQ YM RTY
 
Posts: 295 since Nov 2009
Thanks: 125 given, 338 received


luckcity View Post
Hi Tom,
Thanks for answering a question previously on the SC forum.
Posting here this time, as looking to fire off a few more, and most recent one was ignored there
I'm assuming this is a different forum, but also realize futures.io does integrate the SC forum,
So here goes

1.
I was thinking of creating small calculations in scattered cells and referencing them, instead of managing a long string in the entry/exit cells
Which subject was the last question sent to SC, maybe it fell under "we donít debug formulasĒ category.
I had asked where best to put those, and they were suggesting at the bottom of I/J columns
Asked if using the H column was as good, as it seems to be working ok, and is more conveniently located.
2.
A general question.... are formulas a decent substitute for ASCIL?
One obstacle encountered was when signal is set to the end of the candle, and I donít think an ss formula is able to unset that.
Just looking for a "my experience is" sort of answer, as you may not have tried ASCIL.
3.
How manageable are stops in formulas, for an example, can a stop be tightened if a moving average shifts direction.
4.
Along the same lines, could a target be changed, if criteria is met, from a value in formula, to instead use one of the (trend following) studies
5.
Two more questions unanswered but guessing the answer is no.
Functions used with StudyChart Alerts And Scanning cannot be used, correct?
such as
Referencing Data Other than Last Bar
Base Graph Identifiers
(tried links but was prohibited)
can these be used in spreadsheet system for trading?

1) Use Formula Columns to separate portions of your entry formulas, and then reference them in K3/M3 with AND or OR. This makes formula management and debugging much easier. Use non-repeating cells in column H for user parameters, and intermediate calculations that are not associated with chart bars.
Note: Formulas in non-repeating cells must reference row 3 for intrabar triggers and row 4 for close-of-bar triggers. The 'Signal Only On Bar Close' setting only affects Formula Columns.

2) I don't understand what you mean by 'unset', but spreadsheet formulas are capable of doing most things ACSIL can do.

3,4) Stops and targets can definitely be managed with spreadsheet formulas. If you are not using Attached Orders, they are not pending in the market. If you are using Attached Orders, they can be managed with spreadsheet formulas using the Trade Management by Study study. If you are scaling in or scaling out, the Trade Management by Study study will only move the stop/target closest to the current price, but there is a complicated solution to this.
The Trade Management by Study study can be used with any study's subgraph value, including a spreadsheet study.

5) Simple Alert syntax and spreadsheet formula syntax are not the same, but the format is the same. A few spreadsheet functions can be used in Simple Alert formulas, but Base Graph Identifiers cannot be used in spreadsheet formulas. Spreadsheet row 3 is the current bar, and rows below are previous bars. Simple Alerts use bracketed references to previous bars, e.g. [-1] for the previous bar. So it is possible with both to reference data in previous bars.

The best way to learn is to use trial and error. Don't be afraid to try anything. When you can't figure something out, go to the documentation, which is very good. When neither of these answers your questions, then post on this forum or Sierra's forum.

Reply With Quote
The following 2 users say Thank You to tomgilb for this post:
 
  #27 (permalink)
Trading Apprentice
sydney australia
 
Futures Experience: Intermediate
Platform: Sierra Chart
Favorite Futures: ES
 
Posts: 3 since Jul 2012
Thanks: 1 given, 0 received

Thanks for the encouragement and guidance, Tom.
Interesting that Attached orders can be managed using the Trade Management by Study study, will look at that soon.

For #2, a setting such as 'Signal Only On Bar Close' looks to be read only.
Was working on an exit formula with 2 conditions where one was best end of bar, and the other would have been best intrabar.
I'm not sure that can be switched on the fly in an ss formula, but it may not be able to be switched in ASCIL either

Reply With Quote
 
  #28 (permalink)
Elite Member
Phoenix AZ USA
 
Futures Experience: Advanced
Platform: SierraChart
Broker/Data: TradePro/TransAct
Favorite Futures: NQ YM RTY
 
Posts: 295 since Nov 2009
Thanks: 125 given, 338 received


Quoting 
For #2, a setting such as 'Signal Only On Bar Close' looks to be read only.

J58 to J70 are read only outputs from the spreadsheet study settings.

Quoting 
Was working on an exit formula with 2 conditions where one was best end of bar, and the other would have been best intrabar.
I'm not sure that can be switched on the fly in an ss formula, but it may not be able to be switched in ASCIL either

They can be switched with formulas if Signal Only On Bar Close is set to No,
then for intrabar, reference row 3, for close of bar, reference row 4.

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)

Linda Bradford Raschke: Reading The Tape

Elite only

Adam Grimes: TBA

Elite only

NinjaTrader: TBA

January

Ran Aroussi: TBA

Elite only
     

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


All times are GMT -4. The time now is 02:49 AM.

Copyright © 2017 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 2017-12-12 in 0.08 seconds with 19 queries on phoenix via your IP 54.90.207.75