NexusFi: Find Your Edge


Home Menu

 





Sierra Chart Worksheet System For Trading/Alert Discussions


Discussion in Sierra Chart

Updated
      Top Posters
    1. looks_one Sawtooth with 73 posts (125 thanks)
    2. looks_two luckcity with 43 posts (2 thanks)
    3. looks_3 RT912 with 12 posts (0 thanks)
    4. looks_4 bxman with 10 posts (0 thanks)
      Best Posters
    1. looks_one Sawtooth with 1.7 thanks per post
    2. looks_two aBuzz54 with 1 thanks per post
    3. looks_3 tradermark2009 with 0.5 thanks per post
    4. looks_4 MWG86 with 0.3 thanks per post
    1. trending_up 64,420 views
    2. thumb_up 139 thanks given
    3. group 44 followers
    1. forum 182 posts
    2. attach_file 9 attachments




 
Search this Thread

Sierra Chart Worksheet System For Trading/Alert Discussions

  #71 (permalink)
 Sawtooth 
Prescott AZ USA
 
Experience: Advanced
Platform: SierraChart
Broker: Stage5, FCM:Dorman, Data:Denali, Routing:Teton
Trading: YM ES NQ
Posts: 474 since Nov 2009
Thanks Given: 219
Thanks Received: 603


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.

Started this thread Reply With Quote
Thanked by:

Can you help answer these questions
from other members on NexusFi?
Are there any eval firms that allow you to sink to your …
Traders Hideout
ZombieSqueeze
Platforms and Indicators
Build trailing stop for micro index(s)
Psychology and Money Management
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
Online prop firm The Funded Trader (TFT) going under?
Traders Hideout
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
59 thanks
Funded Trader platforms
37 thanks
NexusFi site changelog and issues/problem reporting
23 thanks
GFIs1 1 DAX trade per day journal
22 thanks
The Program
19 thanks
  #72 (permalink)
luckcity
sydney australia
 
Posts: 44 since Jul 2012
Thanks Given: 26
Thanks Received: 2

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)
 Sawtooth 
Prescott AZ USA
 
Experience: Advanced
Platform: SierraChart
Broker: Stage5, FCM:Dorman, Data:Denali, Routing:Teton
Trading: YM ES NQ
Posts: 474 since Nov 2009
Thanks Given: 219
Thanks Received: 603



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.

Started this thread Reply With Quote
Thanked by:
  #74 (permalink)
luckcity
sydney australia
 
Posts: 44 since Jul 2012
Thanks Given: 26
Thanks Received: 2

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
  #75 (permalink)
luckcity
sydney australia
 
Posts: 44 since Jul 2012
Thanks Given: 26
Thanks Received: 2

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
  #76 (permalink)
 Sawtooth 
Prescott AZ USA
 
Experience: Advanced
Platform: SierraChart
Broker: Stage5, FCM:Dorman, Data:Denali, Routing:Teton
Trading: YM ES NQ
Posts: 474 since Nov 2009
Thanks Given: 219
Thanks Received: 603

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.

Started this thread Reply With Quote
Thanked by:
  #77 (permalink)
luckcity
sydney australia
 
Posts: 44 since Jul 2012
Thanks Given: 26
Thanks Received: 2

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
  #78 (permalink)
luckcity
sydney australia
 
Posts: 44 since Jul 2012
Thanks Given: 26
Thanks Received: 2

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:	248
Size:	1.4 KB
ID:	276554  
Reply With Quote
  #79 (permalink)
 Sawtooth 
Prescott AZ USA
 
Experience: Advanced
Platform: SierraChart
Broker: Stage5, FCM:Dorman, Data:Denali, Routing:Teton
Trading: YM ES NQ
Posts: 474 since Nov 2009
Thanks Given: 219
Thanks Received: 603


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

Started this thread Reply With Quote
  #80 (permalink)
RT912
Sydney New South Wales / Australia
 
Posts: 19 since Jul 2019
Thanks Given: 5
Thanks Received: 7


Hi Tom,
I

Reply With Quote




Last Updated on January 3, 2022


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
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.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts