Support Board

Date/Time: Sun, 24 Nov 2024 22:29:09 +0000

Post From: Searching rows for specific pricepoints using spreadsheets

[2024-04-28 02:36:01] Link To Thread - Link To Post [Go To First Post]
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 - 62 views Screenshot 2024-04-27 193435.png / V - Attached On 2024-04-28 02:35:42 UTC - Size: 26.12 KB - 58 views