Support Board
Date/Time: Sun, 22 Dec 2024 21:46:19 +0000
Spreadsheet For Trading - Populate cells within rows with real values instead of zeros? HELP!
View Count: 896
| [2015-06-02 19:13:16] |
| User12222 - Posts: 20 |
|
Data is provided to SC every 15 sec from IB for VXV-IND-CBOE and VIX-IND-CBOE. However, my spreadsheet shows "0" zero in the rows for OHLL if the data value provided by IB had not changed from the previous value. What this gives me is a lot of rows with zeros that are not actionable with spreadsheet functions because no value is present >0 and thus ignored. How do I: 1) tell SC to place values instead of zeros into the cells, even if the value had not changed 2) or calculate the last nonzero value in each column so I can reference that value into the spreadsheet function. I miss trades because the signal exists, but because a bunch of zeros are in the spreadsheet, nothing happens and a signal is not generated. Thanks, Frustrated.
|
| [2015-06-02 21:34:48] |
| |
|
This is not clear for us. Normally this should not be happening so there must be some kind of nonstandard chart settings you have. We need to see a screenshot of the spreadsheet and also of the chart. Here are instructions: https://www.sierrachart.com/index.php?page=PostingInformation.php#Image 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, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2015-06-04 13:55:12] |
| User12222 - Posts: 20 |
|
http://www.sierrachart.com/image.php?l=1433425930761.png http://www.sierrachart.com/image.php?l=1433426038892.png Please see screenshot links for spreadsheet and chart. Thanks! |
| [2015-06-04 18:35:52] |
| |
|
For some reason these images are blank, other than the SierraChart.com in the lower left. If you are uploading the entire desktop that may not be working. We recommend just uploading the chart itself and then using another method to take a screenshot of the spreadsheet. And attach that as a file: 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, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2015-06-04 19:58:43] |
| User12222 - Posts: 20 |
|
File has been uploaded for review |
 help.docx - Attached On 2015-06-04 19:56:56 UTC - Size: 385.86 KB - 381 views Attachment Deleted. |
| [2015-06-05 02:08:14] |
| |
|
This is not such a straightforward setup. But we have a general sense of what you seem to be doing. When you are overlaying the data for one of these symbols to another chart, use the Study/Price Overlay study and set the input Fill Blanks With Last Value to Yes. This should solve 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 Date Time Of Last Edit: 2015-06-05 02:08:41
|
To post a message in this thread, you need to log in with your Sierra Chart account: