Support Board
Date/Time: Tue, 26 Nov 2024 14:51:09 +0000
Data in Spreadsheet moves ever 5 seconds
View Count: 285
| [2023-11-27 23:30:41] |
| usgvince - Posts: 23 |
|
In column L in a quote spreadsheet I have the following formula: =CONCATENATE(A2,$L$1) The output is correct, but every 5 seconds the output moves a space to the left and then moves back. The trading day is closed and the text isn't part of data string download from the data provider.
|
| [2023-11-28 16:54:19] |
| Sierra_Chart Engineering - Posts: 17179 |
|
We are not understanding this. Provide screenshots and the actual values in the referenced cells.
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, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-11-29 02:35:02] |
| usgvince - Posts: 23 |
|
https://www.sierrachart.com/image.php?Image=1701224213236.png https://www.sierrachart.com/image.php?Image=1701224966712.png It's hard to know if I got the timing right. First screen shot is how it should look. The second screen shot shows a space after the APA symbol and the -NQTV. It repeats every 5 seconds. I did take a short video of it. Do you want me to send it. |
| [2023-11-29 15:40:33] |
| Sierra_Chart Engineering - Posts: 17179 |
|
Provide the spreadsheet file, and tell us specifically what cells to look at. Instructions: https://www.sierrachart.com/index.php?page=PostingInformation.php#AttachFile 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, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-11-29 18:33:30] |
| ForgivingComputers.com - Posts: 960 |
|
Is it possible you have the same spreadsheet attached to two different chartbooks, but the same chart (and sheet) numbers? This can create swapping of the spreadsheet values in and out as the studies recalculate, and why it is recommended that scss files not be shared between open chartbooks. |
| [2023-11-29 23:53:16] |
| usgvince - Posts: 23 |
|
No - this is a quote spreadsheet where I keep track of stocks gains and losses. This is my only spreadsheet, I closed all workbooks and opened this quote sheet and it keeps on doing it. The stocks were purchased before I started using Sierra. If I knew another way to keep track of gains & losses I would do it. I have 10 or so stocks and it does it to all symbols in the column.
|
To post a message in this thread, you need to log in with your Sierra Chart account: