Support Board
Date/Time: Sun, 22 Dec 2024 21:21:35 +0000
Post From: Spreadsheet For Trading - Populate cells within rows with real values instead of zeros? HELP!
[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.
|