Support Board
Date/Time: Sun, 22 Dec 2024 16:09:59 +0000
New Spreadsheets row 2 will not accept a formula
View Count: 1964
| [2014-11-23 18:53:41] |
| Sawtooth - Posts: 4141 |
|
The New Spreadsheets will not retain a formula in row 2 of Formula Columns after a Recalculation. I occasionally use this functionality when the formula in row 3 needs a starting value, as in this example: http://www.sawtoothtrade.com/example-8.html Is this something that can be corrected? Date Time Of Last Edit: 2015-08-14 02:14:09
|
| [2014-11-24 00:17:04] |
| |
|
We will look into this.
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 |
| [2014-12-25 22:37:09] |
| |
|
It is not really suitable to put a formula in the names row 2. Use row 1 instead. The user appears to be attempting to create a column with indices in descending order. One way they could do this is with the following formula: =$J$30 - ROW() + 3. 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 |
| [2014-12-25 23:37:44] |
| Sawtooth - Posts: 4141 |
|
OK, that is another way to put the array in ascending order without using row 2, but I also use a formula in row 2 to create a line label, as in the attached pic. This is one of several examples where the New Spreadsheets have less functionality. I was hoping this one could be removed from the list. |
 Fibs of Pivots.PNG / V - Attached On 2014-12-25 23:34:56 UTC - Size: 64.35 KB - 393 views |
| [2014-12-25 23:54:34] |
| |
|
We will allow a formula in row 2 to name the Subgraph column.
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 |
| [2015-08-15 23:43:31] |
| Sawtooth - Posts: 4141 |
|
We will allow a formula in row 2 to name the Subgraph column.
I noticed this has not happened yet. Is it still on your to-do list?
|
| [2015-08-17 21:51:27] |
| |
|
We will get back about this.
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: 2015-08-17 21:51:37
|
To post a message in this thread, you need to log in with your Sierra Chart account: