Support Board
Date/Time: Sun, 24 Nov 2024 10:36:38 +0000
Post From: Here is a Divergence Study Collection
| [2020-06-24 14:13:20] |
| User7817001 - Posts: 96 |
|
Great! Yes, the formulas in the cells refer to other cells in the worksheet (same row), those referenced cells are either raw live data feed from your chart, beginning from Column A, then there is a gap of columns with no data or formulas, then columns with my formulas.... Cuz I am dumb, I had to work out the logic over several columns, one for determining where the change of direction takes place, one for plotting the custom study (big dot, little dot), etc...This accounts for the many columns of formulas. Be careful when adding or removing studies from in the charts where this is applied, the raw data gets inserted/removed and may throw off the complete workbook, experiment, you will see, I think I remember being able to add studies to the very end of the of the study user interface on the chart, or the beginning, not between existing studies...again you will need to play Hint: in excel if you choose a cell, and it has a formula references other cells, and you click (pretend to edit) the text on in the edit cell atop the worksheet, all referenced cells will be highlighted in the worksheet, allowing you to drag and drop if you need to change the formulas cell references, which you should not, all you should need to do is replace one of the two studies which exist, with the one you want (in the chart studies ui), then make sure the column(s) being filled by sierra chart are filling up with data |