Tweet
Hey Jay,
I just created a 200 row spreadsheet for weekly bars using the Qlink Toolbar. That yields the following formula: =Qlink|Bars!’DIA,W,200,DTOHLCV’. Once the array was created it started displaying all sorts of crazy data until it finally filled the entire array with rows that contain only one date 5/15/2008 (today is 5/12/2008), the value 0 (zero) for all OHLCV fields, and with the time field containing a most recent time value of 8:04:05 PM (as I am typing this it is 9:37 AM MST) and receding upwards by one second per row to a value of about 8:00:46 PM. If I alter the formula to daily bars it displays correctly. I’m running Qlink Version: 2.0 Build: 1167 Date: Mar 12 2008. Got any ideas about what is happening?
-Dave
I just created a 200 row spreadsheet for weekly bars using the Qlink Toolbar. That yields the following formula: =Qlink|Bars!’DIA,W,200,DTOHLCV’. Once the array was created it started displaying all sorts of crazy data until it finally filled the entire array with rows that contain only one date 5/15/2008 (today is 5/12/2008), the value 0 (zero) for all OHLCV fields, and with the time field containing a most recent time value of 8:04:05 PM (as I am typing this it is 9:37 AM MST) and receding upwards by one second per row to a value of about 8:00:46 PM. If I alter the formula to daily bars it displays correctly. I’m running Qlink Version: 2.0 Build: 1167 Date: Mar 12 2008. Got any ideas about what is happening?
-Dave
Comment