Sierra Chart Worksheet System For Trading/Alert Discussions - futures io
futures io futures trading



Sierra Chart Worksheet System For Trading/Alert Discussions


Discussion in Sierra Chart

Updated by luckcity
      Top Posters
    1. looks_one tomgilb with 56 posts (94 thanks)
    2. looks_two luckcity with 40 posts (2 thanks)
    3. looks_3 RT912 with 12 posts (0 thanks)
    4. looks_4 MWG86 with 6 posts (2 thanks)
      Best Posters
    1. looks_one tomgilb with 1.7 thanks per post
    2. looks_two tradermark2009 with 0.5 thanks per post
    3. looks_3 MWG86 with 0.3 thanks per post
    4. looks_4 luckcity with 0.1 thanks per post
    1. trending_up 27,504 views
    2. thumb_up 101 thanks given
    3. group 29 followers
    1. forum 137 replies
    2. attach_file 9 attachments




Welcome to futures io: the largest futures trading community on the planet, with well over 100,000 members
  • 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 and simple.

-- Big Mike, Site Administrator

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

 
Search this Thread
 

Sierra Chart Worksheet System For Trading/Alert Discussions

(login for full post details)
  #71 (permalink)
Nashville TN USA
 
Experience: Advanced
Platform: SierraChart
Broker: Sierra Futures/SC Denali
Trading: YM NQ
 
Posts: 390 since Nov 2009
Thanks: 150 given, 472 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:

Can you help answer these questions
from other members on futures io?
The Journey
Traders Hideout
QDEL
Stocks and ETFs
Dollar crash in 2021
Currencies
Degiro Negative Balance Advice
Traders Hideout
Macros for flatten and reverse
TradeStation
 
Best Threads (Most Thanked)
in the last 7 days on futures io
Lost & losing hope
25 thanks
VWAP for stock index futures trading?
25 thanks
Coronavirus COVID-19
25 thanks
Emini 4 Tick Scalp still valid?
17 thanks
Price Action Kewltech Style
15 thanks
 
(login for full post details)
  #72 (permalink)
sydney australia
 
 
Posts: 41 since Jul 2012
Thanks: 23 given, 2 received

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
 
(login for full post details)
  #73 (permalink)
Nashville TN USA
 
Experience: Advanced
Platform: SierraChart
Broker: Sierra Futures/SC Denali
Trading: YM NQ
 
Posts: 390 since Nov 2009
Thanks: 150 given, 472 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


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.

Reply With Quote
The following 2 users say Thank You to tomgilb for this post:
 
(login for full post details)
  #74 (permalink)
sydney australia
 
 
Posts: 41 since Jul 2012
Thanks: 23 given, 2 received

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?

Reply With Quote
 
(login for full post details)
  #75 (permalink)
sydney australia
 
 
Posts: 41 since Jul 2012
Thanks: 23 given, 2 received

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?

Reply With Quote
 
(login for full post details)
  #76 (permalink)
Nashville TN USA
 
Experience: Advanced
Platform: SierraChart
Broker: Sierra Futures/SC Denali
Trading: YM NQ
 
Posts: 390 since Nov 2009
Thanks: 150 given, 472 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 2 users say Thank You to tomgilb for this post:
 
(login for full post details)
  #77 (permalink)
sydney australia
 
 
Posts: 41 since Jul 2012
Thanks: 23 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

Reply With Quote
 
(login for full post details)
  #78 (permalink)
sydney australia
 
 
Posts: 41 since Jul 2012
Thanks: 23 given, 2 received

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
Click image for larger version

Name:	tick size.PNG
Views:	26
Size:	1.4 KB
ID:	276554  
Reply With Quote
 
(login for full post details)
  #79 (permalink)
Nashville TN USA
 
Experience: Advanced
Platform: SierraChart
Broker: Sierra Futures/SC Denali
Trading: YM NQ
 
Posts: 390 since Nov 2009
Thanks: 150 given, 472 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

Reply With Quote
 
(login for full post details)
  #80 (permalink)
Sydney New South Wales / Australia
 
 
Posts: 19 since Jul 2019
Thanks: 5 given, 7 received


Hi Tom,
I

Reply With Quote


futures io Trading Community Platforms and Indicators Sierra Chart > Sierra Chart Worksheet System For Trading/Alert Discussions


September 14, 2020


Upcoming Webinars and Events
     



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