Support Board
Date/Time: Tue, 26 Nov 2024 02:30:26 +0000
Post From: Calculating Price Change Since Last Alert
| [2024-01-16 13:45:54] |
| pjk0225 - Posts: 34 |
|
My spreadsheet formula doesn't seem to be doing anything. I first set up a spreadsheet and made an alert study to output "1" in column AB. I then tried using GetCorrespondingMatch in a spreadsheet formula study to find the most recent instance of "1" in column AB and return the Open price from column B for that row. I thought this would produce the Open value of that row on its own cell (GetCorrespondingMatch is in column AA, so I expected to see an Open price there) but column AA only displays "0" throughout the spreadsheet. Am I misunderstanding the application of this study? =GetCorrespondingMatch(AB3:AB20000, 1, 0, 1, 0, B3:B20000, 0) ^ this is what I used in the Spreadsheet Formula study, which outputs to column AA. While I'm here, if someone can help, I'm trying to achieve two things with this: 1) make a study tell me when 5 bars have passed since the last signal, and 2) measure the difference between the most recent price vs. the price corresponding to the most recent signal trigger (ex. Change of Open of Signal vs Open Now) I'd greatly appreciate any pointers or examples Date Time Of Last Edit: 2024-01-16 13:46:45
|