Support Board
Date/Time: Thu, 27 Feb 2025 12:10:16 +0000
Spreadsheet range in a formula?
View Count: 521
| [2021-06-29 16:23:53] |
| owendonk - Posts: 54 |
|
Is it possible to do something like this but for 1000+ rows without manually typing it all out? =AND( AND(ID0.SG4@3<P3), AND(ID0.SG4@4<P4), AND(ID0.SG4@5<P5), AND(ID0.SG4@6<P6), AND(ID0.SG4@7<P7), AND(ID0.SG4@8<P8), AND(ID0.SG4@9<P9), AND(ID0.SG4@10<P10), AND(ID0.SG4@11<P11), AND(ID0.SG4@12<P12), AND(ID0.SG4@13<P13), AND(ID0.SG4@14<P14), AND(ID0.SG4@15<P15), AND(ID0.SG4@16<P16), AND(ID0.SG4@17<P17), AND(ID0.SG4@18<P18), AND(ID0.SG4@19>P19)) I need to do this to count a minimum duration of a crossover being maintained (note 19> instead of <). I have several other general uses in mind for this if possible. Date Time Of Last Edit: 2021-06-29 16:42:16
|
| [2021-06-29 17:05:38] |
| John - SC Support - Posts: 38222 |
|
There is no method to automate this kind of entry within the Spreadsheets within Sierra Chart.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2021-06-29 17:48:05] |
| owendonk - Posts: 54 |
|
I figured out a way in google sheets if anyone else needs a solution. See the screenshot. Just split it up into junks that can be autoincremented with a drag down, concatenate, then drag it down to autofill it.
Date Time Of Last Edit: 2021-06-29 17:48:20
|
 Screenshot.png / V - Attached On 2021-06-29 17:46:37 UTC - Size: 42.52 KB - 184 views |
To post a message in this thread, you need to log in with your Sierra Chart account: