Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 18 May 2024 13:53:44 +0000
[Programming Help] - Searching rows for specific pricepoints using spreadsheets
View Count: 54
| [2024-04-28 02:36:01] |
| aswade3451 - Posts: 17 |
|
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 - 15 views Screenshot 2024-04-27 193435.png / V - Attached On 2024-04-28 02:35:42 UTC - Size: 26.12 KB - 18 views |
To post a message in this thread, you need to log in with your Sierra Chart account: