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:15,428 / 84
Created: by tomgilb Attachments:6

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
 6  
 
Thread Tools Search this Thread
 

Sierra Chart Worksheet System For Trading/Alert Discussions

  #71 (permalink)
Phoenix AZ USA
 
Trading Experience: Advanced
Platform: SierraChart
Broker/Data: Sierra Futures/SC Denali
Favorite Futures: YM NQ
 
Posts: 353 since Nov 2009
Thanks: 145 given, 439 received


Quoting 
There are 50 blanks after the 200

Do you get different P/L using 300 rows vs 400 rows?
Find the number of rows where the P/L does not vary from a hundred count to the next, and use it.


Quoting 
the bunching of the candles is due to plotting of 0's from chart #2, but don't know where the switch to disable zero plotting is

If you are using the Background draw style, it shouldn't bunch the candles. There must be another reason.

Reply With Quote
The following 2 users say Thank You to tomgilb for this post:
 
  #72 (permalink)
sydney australia
 
 
Posts: 30 since Jul 2012
Thanks: 19 given, 2 received

2 questions Tom

1.
Using the Automatic Trendlines again...
proves to be more helpful than MA, at least for me

AY----------------- AZ
Up Trendline---Down Trendline
7649.75--------7681.70
7641.5----------7684.14
0-----------------7686.58
0-----------------7689.02
0-----------------7691.47
0-----------------7693.91
0-----------------7696.35
0-----------------7698.79
0-----------------7701.23
0-----------------7703.67
0-----------------0
0-----------------0
0-----------------0
0-----------------0

In this example, I cant figure out how to return the last number before the zero for each column, as the values are in flux, so would like to see 7641.5 and 7703.67 returned, if it is possible

2.
Just a general question about use of the first row, I have seen spreadsheets using this row, is this practice best used for formulas that are referenced in rows numbered 3 and above?
In this case must this cell be referenced statically e.g. $V$1?
Can this first cell be referenced in other columns besides (in this example) V?
Is there any disadvantage or caution using this first cell in this way?

Reply With Quote
 
  #73 (permalink)
Phoenix AZ USA
 
Trading Experience: Advanced
Platform: SierraChart
Broker/Data: Sierra Futures/SC Denali
Favorite Futures: YM NQ
 
Posts: 353 since Nov 2009
Thanks: 145 given, 439 received



Quoting 
In this example, I cant figure out how to return the last number before the zero for each column, as the values are in flux, so would like to see 7641.5 and 7703.67 returned, if it is possible

1. Try these:
For the Up Trendline, e.g. in S3:
=IF(AND(ID1.SG1@4=0,ID1.SG1@3>0),ID1.SG1@3,S4)
For the Down Trendline, e.g. in T3:
=IF(AND(ID1.SG2@4=0,ID1.SG2@3>0),ID1.SG2@3,T4)
where the Auto Trendline study is ID1; edit as needed. (It's best to reference the ID# instead of the column alpha.)
https://www.sierrachart.com/index.php?page=doc/WorkingWithSpreadsheets.php#ReferencesStudySubgraphColumnsSpreadsheetStudy


Quoting 
Just a general question about use of the first row

2. You can use Row 1 as you would use column H.
Row 1 cells are not associated with what's in Row 2 and below, so they can be referenced from any other cell.
If you are referencing a Row 1 cell in a Formula Column, you must use an absolute reference, e.g. $V$1.
There is no caution, except don't use A1 or D1, or any Row 1 cell to the right of the right-most Formula Column, as these cells will be overwritten.


Last edited by tomgilb; July 25th, 2019 at 09:25 AM.
Reply With Quote
The following 2 users say Thank You to tomgilb for this post:
 
  #74 (permalink)
sydney australia
 
 
Posts: 30 since Jul 2012
Thanks: 19 given, 2 received

Duplicating a .cht/.scss set

Hi Tom

Me again

Having intermittent success when trying to clone a set; one .cht that links to one .scss.
The method that has worked on occasion is

1. In the Data folder, copy the cht and the scss and rename both copies, e.g V2.cht V2.scss
2. Open V2.cht and open the Spreadsheet study, and select the V2.scss replacing the V1.scss
The V2.scss appears

This is where things go weird
Expect the V1.scss (and believe it has upon occasion) to say it is closing, and agree to close w/o saving.
But frequently it does not say its closing, and 2 scss's appear linked to the cht.
If one force closes the V1 window, it says it will remove the study, and it does, leaving no study.

Tried duplicating the study, having one link to V1 and the other to V2, but behavior doesn't change after removing the V1 study.

There's been times those steps have worked, but there must be something subtle that I had done that made a difference

any ideas?


Last edited by luckcity; September 18th, 2019 at 09:42 PM.
Reply With Quote
 
  #75 (permalink)
sydney australia
 
 
Posts: 30 since Jul 2012
Thanks: 19 given, 2 received

Removing sheet 1

OK here's another, and sorry because there isn't as much detail as the previous query
Typically when there are 2 charts in a chartbook, the first is represented by SS1, and the 2nd by SS2.

If attempting to remove chart1, its been noticed that, even though removing sheet 1 is allowed, it isn't a straightforward operation, and often the ss study doesn't work at all after ss1 is removed.
It's known that ss1 does not require removal, but removal was attempted to "clean things" up
Its also known there is a selector in the study to point to a ss#

I believe if 1 is removed, 2 becomes 1.


Is there something special about ss 1 that guides or sets a model for the other sheets?


Last edited by luckcity; September 18th, 2019 at 11:49 PM.
Reply With Quote
 
  #76 (permalink)
Phoenix AZ USA
 
Trading Experience: Advanced
Platform: SierraChart
Broker/Data: Sierra Futures/SC Denali
Favorite Futures: YM NQ
 
Posts: 353 since Nov 2009
Thanks: 145 given, 439 received

By default, the Sheet# is the same as the Chart#.

But you can change what sheet the chart uses for its formulas by setting the 'Formula Source Sheet Number' to something other than that which matches the chart number.

If you are using the same-named spreadsheet on more than one chart in the same chartbook, and all of the charts are using the same formulas, you can set all of the Formula Source Sheet Numbers to the same sheet so you only need to edit one sheet.

If you are using the same-named spreadsheet on more than one chart in the same chartbook, but each chart needs its own formulas, set the Formula Source Sheet Number to the same as the chart number. IOW, you don't need a uniquely named spreadsheet for each chart.
(You only need an uniquely named spreadsheet if you concurrently have more than one chartbook open. IOW, each concurrently open chartbook needs its own uniquely named spreadsheet.)

If you want to change the name of the spreadsheet, here's an easy way to do it:
- Focus the spreadsheet and go to File >> Save As and give it a new name, and click on Save.
- When asked if you want to Save Spreadsheet ... , click Yes.
- The original spreadsheet will disappear.
- Go to the Analysis >> Studies >> highlight the spreadsheet study >> Settings button >> click on the Select button next to the Spreadsheet Name field and choose the newly named spreadsheet file.
- The newly named spreadsheet will appear.
- If you want to use the newly named spreadsheet on the other charts in the chartbook that have the original spreadsheet, go to the spreadsheet study settings on each chart and use the Select button next to the Spreadsheet Name field to choose it.
- If, after you've renamed the spreadsheet, you also want to rename the chartbook, focus any chart and go to File >> Save As and give it a new name.

If you want to delete unused Sheets, there cannot be a spreadsheet of the same name on the Chart# that matches the Sheet#. You can only delete sheets that have no corresponding spreadsheet study. If you delete a sheet that has a corresponding spreadsheet study, it will reappear.

If you remove a chart from the chartbook that has other charts with the same-named spreadsheet, and there was a spreadsheet study on the removed chart, you can then safely delete the corresponding Sheet#.

Summary:
- You should do all of the renaming and deleting within Sierra Chart.
- You should pay close attention to the 'Formula Source Sheet Number'.
- To keep things simple, you should use the default settings, and only change the 'Formula Source Sheet Number' when necessary.

Reply With Quote
The following user says Thank You to tomgilb for this post:
 
  #77 (permalink)
sydney australia
 
 
Posts: 30 since Jul 2012
Thanks: 19 given, 2 received

Really helpful. thanks Tom


tomgilb View Post
If you want to change the name of the spreadsheet, here's an easy way to do it:
- Focus the spreadsheet and go to File >> Save As and give it a new name, and click on Save.
-


Not sure how the saving can be done, though, the only "File >> Save As" I'm seeing is on the chart menu and that will de-focus the Spreadsheet.
Maybe I'm missing somethin


OK..nevermind I figured it out, my SS was detached


Last edited by luckcity; September 19th, 2019 at 07:01 AM.
Reply With Quote
 
  #78 (permalink)
sydney australia
 
 
Posts: 30 since Jul 2012
Thanks: 19 given, 2 received

why figures are not rounded/accurate

Hi Tom,
Why are numbers such as those in snapshot not rounded, expected just .1 for the Russel tick size.
There are other cells besides tick size where this is true

Attached Thumbnails
Sierra Chart Worksheet System For Trading/Alert Discussions-tick-size.png  
Reply With Quote
 
  #79 (permalink)
Phoenix AZ USA
 
Trading Experience: Advanced
Platform: SierraChart
Broker/Data: Sierra Futures/SC Denali
Favorite Futures: YM NQ
 
Posts: 353 since Nov 2009
Thanks: 145 given, 439 received


luckcity View Post
Hi Tom,
Why are numbers such as those in snapshot not rounded, expected just .1 for the Russel tick size.
There are other cells besides tick size where this is true

The value has floating point errors.
You can use this formula in cell H21 to round the tick size:
=1 / ROUND(1 / J21, 0)
https://www.sierrachart.com/index.php?page=doc/SpreadsheetExampleFormulasAndUsage.php#RemovingFloatingPointImprecision

Reply With Quote
 
  #80 (permalink)
Sydney New South Wales / Australia
 
 
Posts: 7 since Jul 2019
Thanks: 2 given, 1 received


Hi Tom,
I

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)
 

futures io is celebrating 10-years w/ over $18,000 in prizes!

Right now
 

$250 Amazon Gift Cards with our "Thanks Contest" challenge!

Right now
 

Webinar: CME Micro-Indices & Important Lessons Learned w/FuturesTrader71

Elite only
 

Show us your trading desks and win $1,400 in prizes w/Earn2Trade

November
     

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


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

Copyright © 2019 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