Support Board
Date/Time: Mon, 25 Nov 2024 16:58:01 +0000
Post From: text display net change from open/high/ low and previous close in the middle of chart window
| [2014-01-31 00:49:35] |
| Sawtooth - Posts: 4120 |
|
how do i reference a cell from another sheet in a spreadsheet.
Enter an = in the destination cell (e.g Sheet1 cell K3), navigate to the source sheet and cell (e.g. Sheet2 cell Z3), press Enter. This will give you a something like this in K3:=Sheet2!Z3 http://www.sierrachart.com/index.php?l=doc/doc_Worksheets.html#ReferencesOtherSheets However, here is the recommended way to reference another chart's studies: http://www.sierrachart.com/index.php?l=doc/doc_ReferencingChartsFormulas.html#OverlayStudies Also if I add or delete any indicator it will change the sheet columns and the formula wont change automatically, how can I avoid to change the formula everytime
As you have discovered, study outputs appear on the spreadsheet (beginning in column AA-BR respective to the Number Of Formula Columns setting 16-60) in the same order they appear in the Studies to Graph list. If you add, remove, or rearrange studies, or if you change the Number Of Formula Columns setting, studies will appear in different columns which will require editing all affected column references.There is no goof-proof way to always avoid the need to edit formulas when adding or removing studies, but here are some ideas to mitigate the need: -Use the example in column Q of the ZZ Rev Lines study, where the study's column is referenced in one of the user formula columns. If many formulas reference the same column, you only need to change one reference. -Be careful of the order of the studies in the Studies to Graph list. -Use a larger Number of Formula Columns setting than the default 16 before you write any formulas. I get tired of zooming the charts every time, for some reason es chart has 0 value in the indicator and chart needs to be zoomed up.
In columns O and above, the formula needs to return a value commensurate with the price. A zero or one, or TRUE/FALSE, will cause the chart to squish with most Draw Styles. For example, if you are placing an up arrow at the bottom of the bar, you can use a formula like this:=IF(YourConditions,D3,0) |