Support Board
Date/Time: Tue, 26 Nov 2024 21:32:49 +0000
Post From: Spreadsheet Speed / Logic Issue
| [2014-06-10 14:44:18] |
| drywater0 - Posts: 85 |
|
SC Chart, I created a spreadsheet study in Version 1137. The real time outputs are working fine but the processing of some Excel functions appears to be slow enough to cause errors. From a list of 35 different price levels, 20 of them change by small increments based on the last traded price and the others change much less frequently. I think my hardware is up to the task as I'm using a laptop with Intel quad-core i-7 @ 2.2Ghz and 8 GB RAM. I have used the LARGE function to place them in descending order, and then VLOOKUP to grab text information associated with the price levels. It appears that the LARGE function does not update / re-order components of the original list that are changing on a tick by tick basis. Hence, with stale values the VLOOKUP or INDEX & MATCH functions return a #N/A output. One solution I attempted was to round the quickly changing values to only two decimal places before they are sorted by the LARGE function. Unfortunately, the problem of stuck / stale values re-appeared within a couple price ticks. If I manually go into any blank cell on the sheet and hit enter, all the values in the list are updated and re-ordered but then quickly become stale. Much effort was expended in building the spreadsheet so I would be very grateful for your assistance. |