Support Board
Date/Time: Sat, 17 May 2025 15:54:31 +0000
[Programming Help] - Searching rows for specific pricepoints using spreadsheets
View Count: 233
| [2024-04-28 02:36:01] |
| aswade3451 - Posts: 19 |
|
Hello, I am trying to create an automated study that goes long or short whenever there is a diagonal imbalance as well as a regular Bid x Ask imbalance. Attached I have a screenshot of what I am looking for as a condition for an entry. The Box indicates a diagonal imbalance and the dot represents a horizontal imbalance. What I am having trouble with is searching the values for the imbalances on the spreadsheet since they are presented in different columns (again I provided a screenshot so we're on the same page). Which spreadsheet function should I be using to compare the prices? GetCorrespondingMatch or HLOOKUP? Or is there another way to accomplish this? Thanks very much! |
 Screenshot 2024-04-27 193522.png / V - Attached On 2024-04-28 02:35:38 UTC - Size: 56.98 KB - 97 views Screenshot 2024-04-27 193435.png / V - Attached On 2024-04-28 02:35:42 UTC - Size: 26.12 KB - 82 views |
To post a message in this thread, you need to log in with your Sierra Chart account: