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-06-18 17:07:47] |
| SSGill - Posts: 36 |
|
Hello; I am trying to record in a column, (so I may display on my ES chart) the last price when the Tick last was equal or crossed over 0. When I get a true condition within a bar, it returns to false, when Tick last column information is over or under the 0 line in that same bar, because it happens so fast. So unless at when the bar ended, and tick was at 0, is the only time I would get this true condition. I tried to use crossover function, but same thing. New Tick Last prices coming in, overwrite the condition. Can you tell me how in spreadsheets if and when Tick Last crossed over the 0 line, from under or above, I can track the ES price at that instance? I have the information from both instruments (ES and Tick) in my spreadsheet by using the overlay study. So for example, I am using minute bars. if Tick last makes a crossover over/under 0, in column X I save the ES price in that instance, but before the bar is finished, if the crossover condition goes back to false, I won't lose my ES price that I recorded, before the bar closes? |