Support Board
Date/Time: Sat, 15 Mar 2025 07:18:40 +0000
Post From: SPREADSHEETS - save last ES price to column if $tick-nyse hits 0
| [2022-07-10 14:38:22] |
| SSGill - Posts: 36 |
|
Hello; I am trying to save the first instance when last TICK crosses over 0 for each 1 minute bar. I have tried the above instructions and used =AND(OR(E3=10,K3>0),H3=FALSE) the formula recommended. Please see the attached screenshot. So my formula is as follows: once the condition comes true in L3, turn the 0 to a 1. =AND(h$3=false,or(crossfromabove(aq3:aq4,0), l3>0)) Then I need to record the instance of last price (e3) upon L3 becoming true. =if(m3>0,m3,if(l3=1,e3,0)) both columns work on the first row, however the same value gets carried forward for each cell instead of L3, M3 resetting itself to 0. I have included a screenshot, and the workbook for your reference. The issue is in the TandP_ES.scss worksheet. Any other methods or solutions to achieve the same result would be greatly appreciated. I hope, when I get this resolved to display a dot on the ES price bar, at the price in column M on the chart. However, once the value goes true for the first minute I run the spreadsheet, the value carries over for each subsequent row, and will not reset itself. |
 Screenshot 2022-07-10 101102.png / V - Attached On 2022-07-10 14:35:39 UTC - Size: 64.16 KB - 124 views  Tick and Price divergence.Cht - Attached On 2022-07-10 14:36:54 UTC - Size: 13.71 KB - 280 views Private File |