Support Board
Date/Time: Mon, 25 Nov 2024 18:46:03 +0000
Post From: Question about a spreadsheet study that references time and draws a line
| [2024-02-15 00:28:34] |
| trader2017 - Posts: 98 |
|
In case anyone else is trying to do something similar, here is what worked. The previous row didn’t make sense in this context, I don’t work with spreadsheet studies very often and the chronological order is most recent first so there is no need to reference the previous row, the next row is what you need to carry forward a value. I still have to figure out if I can add a value to the 18:00 number by having it reference a static number like 60 minutes to increase it by so I can copy and paste these into new columns and not have to change the numbers manually. For example (18:00:00 + (60 *1)), (18:00:00 + (60 *2)), etc. CELL K3 =FRACTIME(MROUND(A3,1/86400))=TIMEVALUE("18:00:00") CELL L3 =IF(K3=1,ID0.SG2@3+.50,0) CELL M3 =IF(L3=0,M4,L3) Date Time Of Last Edit: 2024-02-15 00:31:10
|