Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 18 May 2024 06:01:50 +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: 18 |
|
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.
|