Login Page - Create Account

Support Board


Date/Time: Tue, 26 Nov 2024 15:41:51 +0000



Post From: DOM Bid/Ask Size Alert

[2023-11-20 19:50:48]
John - SC Support - Posts: 36296
You can do this by adding the "Depth of Market Data" study along with the "Spreadsheet Study". You need the Spreadsheet Study in order to be able to view/manage the data as it flows.

In the Spreadsheet Study you would put in the following for Column K to find all Bid Depth levels that are greater than 200 (for example):
=IF(ID1.SG1@3 > 200, 1, 0)

Then in Column L you would use the following to denote at row 3 if there are any values anywhere in the range:
=IF(ISNUMBER(VLOOKUP(1, $S$3:$S$2000, 1)), 1, 0)

You can then set an alert for when Column L is a value of 1.

Refer to the following:
Depth of Market Data

Spreadsheet Functions
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing