Support Board
Date/Time: Thu, 28 Nov 2024 20:03:50 +0000
[Programming Help] - Spreadsheet don´t read rows
View Count: 280
| [2023-04-03 14:35:59] |
| Hopeman - Posts: 166 |
|
Hi there! I have a spreadsheet with the bid and ask volume by price in a configuration with volume that replicates the tape almost perfectly. The issue is that when I do a sum formula that occupies 4 or 5 ASK or BID readings, it does not recognize it because there are rows with zeros, do you know if there is any way that the program can read all the ask that appears on the line skipping the zeros? Thank you, |
rows.png| [2023-04-03 17:21:35] |
| John - SC Support - Posts: 36350 |
|
We are not understanding this. You can use a SUM() function with zero values.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-04-03 18:12:50] |
| Hopeman - Posts: 166 |
|
I will approve what you tell me, I want to clarify that I have 20 rows of spreadseet that interprets the tape and when it reaches number 16 the spreadsheet starts counting again, could you be so kind as to indicate what it is due to? |
| [2023-04-04 15:54:11] |
| John - SC Support - Posts: 36350 |
|
We can not answer, as we do not know how you have setup the spreadsheet.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-04-04 17:36:06] |
| Hopeman - Posts: 166 |
|
I have a graph with the study time and sales volume configured in bar period, the configuration of the bars is 20 per volume, I have this in a spreadshhet that only reads 16 rows of 25, when it goes past 16 it starts reading again from above, that is, in row 17 the same numbering of row 1 appears and so on
|
To post a message in this thread, you need to log in with your Sierra Chart account: