Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
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 for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
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?
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
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.
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
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?
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.
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
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