Home >> Support Board

Support Board

Date/Time: Sun, 05 May 2024 17:08:07 +0000

How to Post a Message for Support

Formula plot-subchart study

View Count: 1289

[2016-11-12 20:54:11] #1 [Go To First Post]
User931283 - Posts: 55
You have Studies suitable for basis for a couple of useful subgraphs, with slight changes. I need a simple plot formula capability (like an O-AD column) If Colored Background (C.B) could optionally plot a formula, that would help improve those. We run out of columns on a spreadsheet (after AD), and need "just one more" custom formula column (formula plot). "H" does not work well when a curve needs to be studied. I'm in that situation now. A study addable as a spreadsheet column (best) could display a curve to test improvements to an existing O-AD formula. Colored Background might be the basis, to optionally plot an input condition formula, instead of test true. This would be useful for bars comparisons between OHLC overlays (a custom divergence test). That could input the "alert condition" formula without the <, > , = (True) test, and output 1 more spreadsheet column, or replace the Vertical line column (better to keep 2 columns always) to not ruin spreadsheets if option is set back to Vertical Line. Maybe better to use code of something like C.Bckgrnd in a new "Plot Formula" study. Hopefully this might go on a "middle burner", as not a very complex goal.

[2016-11-12 21:37:59] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
We do not understand hardly any of this. However, there is no need to clarify because this is not within the scope of our support. One thing that it seems as though you are asking for is more formula columns. Currently there are 60 of them. Refer to: Spreadsheet Study Inputs: Number of Formula Columns However, you can use whatever columns you want to contain formulas. Just simply use them and fill the formula down to the row that you require. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, change to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2016-11-12 21:38:14

[2016-11-13 00:25:19] #3 [Go To First Post]
User931283 - Posts: 55
By "run out of columns (after AD)" means I set 20 open columns typically. All 10 inter-related spreadsheets are full, with 24 to 70 studies each, with long formulas referring to all of them, and overlays. (15 months development) I see no way to "use whatever columns you want".-- Inserting beyond 20 formula columns would change all the letters-- take months to convert and introduce errors. A "Plot Formula" study would be very handy for users and non-users of spreadsheets. Some may need only 2 or 3 plots and get going with S.C. faster (ie: new clients, before learning spreadsheets),-- plus they'd save resources. - - - EDITED- I put a formula out 20 columns past study #38, copied down the column. It computes like a spreadsheet. Is that what you meant by use any column? How can that be plotted or referenced from manual column FK, with no study ID? A manual column is obliterated if a study is added, or likely any study setting changed. Date Time Of Last Edit: 2016-11-13 13:53:40

[2016-11-13 14:21:12] #4 [Go To First Post]
Sawtooth - Posts: 3993
Inserting beyond 20 formula columns would change all the letters If you use the ID#.SG#@# referencing format, you can insert columns, and studies, without this problem. http://www.sierrachart.com/index.php?page=doc/Spreadsheets.html#ReferencesStudySubgraphColumnsSpreadsheetStudy If column H does not provide enough cells, you can add a sheet to the spreadsheet that is not associated with a chart to do intermediate calculations and user input tables, then reference them from sheets that are associated with charts. http://www.sierrachart.com/index.php?page=doc/Spreadsheets.html#ReferencesOtherSheets Here are my recommendations when building a complex system: -Set the Number of Formula Columns to 60. It doesn't hurt to have spares when you're working. You can reduce them later if you must, if you use the ID#.SG#@# referencing format. -Use the ID#.SG#@# referencing format when referencing studies, and use the traditional column/row referencing format for all other columns/cells. With the Number of Formula Columns set to 60, this allows the flexibility to insert/delete columns because references will automatically follow. The only thing you have to manually change is the respective Draw Styles. Caution: if you have formulas in the 60th column, and then insert a column, those formulas will be overwritten by a study output. Leave spare columns to the right of your working columns. -Do not use columns beyond those used by studies. If you add a study, your formulas will be overwritten. Instead, add an unassociated sheet. Date Time Of Last Edit: 2016-11-13 18:14:06

[2016-11-13 18:35:02] #5 [Go To First Post]
User931283 - Posts: 55
Thanks Tom, as usual you illuminate more than the immediate problem and offer general solutions helpful to all. After 15 months daily development, it's late for me convert to ID#.SG#@# I'm glad I used 20 cols, not 16. Newbie SC spreadsheet system builders; heed Tom's forward-looking advice re more columns,because normally you reference parts of studies attached to charts, so "intermediate calculations" on another sheet might not help much. It's helpful to be able to plot intermediate results (components) of larger formulas, to make sure they do what you think they do.

To post a message in this thread, you need to log in with your Sierra Chart account: