Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Thu, 02 May 2024 19:11:54 +0000
Spreadsheet bug found
View Count: 612
| [2017-04-03 15:09:29] |
| Mistic - Posts: 76 |
|
After editing a spreadsheet study subgraph color/draw style this morning, All the data in the KLMN columns cleared. So i ended up losing all the data i had collected from the night before. When i put the formulas back in. The columns ignored the number format that was set prior but after right clicking->number format, it was set to '1', just not showing that until i hit OK.
|
| [2017-04-03 18:30:58] |
| |
|
So you are saying the Spreadsheet Study formula columns cleared. The reason this happens has to do with the Formula Source Sheet Number Input: http://www.sierrachart.com/index.php?page=doc/SpreadsheetStudyInputs.html#FormulaSourceSheetNumber If this is the problem though it will happen consistently. . So i ended up losing all the data i had collected from the night before. How could this be since the KLMN columns contain the same formula at each row? They do not contain collected data.We will look this over: The columns ignored the number format that was set prior but after right clicking->number format, it was set to '1', just not showing that until i hit OK.
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: 2017-04-03 18:31:35
|
| [2017-04-03 19:02:40] |
| Mistic - Posts: 76 |
|
The data in my columns consists of a formula using live passive offer data. The formula contains some absolute and some not cells. I find that historical data is not as accurate as live data when using bid/ask depth info. The formula input source # did however have the wrong sheet #, It still worked though. I'll change the draw styles again when market takes its break later to see if the 'input source #' was the issue. Thanks |
| [2017-04-03 20:42:02] |
| |
|
Before changing any Study settings, we recommend that you save the Spreadsheet in case the data is cleared for some other reason. It does sound as though the Formula Source Sheet Number input was the problem. 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 |
| [2017-04-03 21:56:47] |
| Mistic - Posts: 76 |
|
It was the problem. Problem solved. Thanks
|
To post a message in this thread, you need to log in with your Sierra Chart account: