Login Page - Create Account

Support Board


Date/Time: Sat, 15 Mar 2025 07:15:14 +0000



Post From: SPREADSHEETS - save last ES price to column if $tick-nyse hits 0

[2022-07-11 01:04:42]
Sawtooth - Posts: 4183
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?
You would use the Study/Price Overlay study on the 1 minute chart to overlay the Spreadsheet Study study from the 1 second chart.
Referencing Other Charts in Spreadsheet Study Formulas: Referencing Other Charts in Spreadsheet Study Formulas

However, the spreadsheet study on the 1 second chart would need too many rows to be of much use overlaid on the 1 minute chart.
IOW, a very large Number of Rows will likely cause some lag.