Support Board
Date/Time: Sat, 15 Mar 2025 07:15:16 +0000
Post From: SPREADSHEETS - save last ES price to column if $tick-nyse hits 0
| [2022-07-10 22:57:54] |
| SSGill - Posts: 36 |
|
Tom; Another workaround that I have thought about, is that I can use a second bar for the ES, and overlay a one second chart of the TICK, then record the last ES price when there is crossover on TICk at the 0 line. Because I am doing it second by second, I have a much more accurate record when Tick hit 0. Then I could average the ES price results for that minute (since the crossover may occur on multiple rows for that minute). I can't figure out how to take this average ES price for respective minute in my second chart over to my one minute ES chart. I referenced the documentation, and could not see how to reference another spreadsheet study. My goal would be to find the information on the one second chart worksheet that I averaged the crossover prices back to the respective minute of the one minute sheet. Is this possible? |