Support Board
Date/Time: Sun, 24 Nov 2024 01:15:22 +0000
[User Discussion] - Assist in creating a condition
View Count: 241
| [2024-07-08 20:00:53] |
| User669552 - Posts: 15 |
|
Kindly assist in making a condition that would highlight the following. a) On a Red candlestick with positive Delta. Highlight When the Ask is greater than the bid horizontally and at the same instance the Ask is also greater than the Bid diagonally. b) On a Green candlestick with negative Delta. Highlight were the bid is greater than Ask horizontally and at the same time the bid is greater than tha Ask diagonally. Kindly assist I don't have programing knowledge. I use a Range chart |
| [2024-07-08 20:47:47] |
| John - SC Support - Posts: 36238 |
|
We can only give you the information for what you need to do. It is beyond the scope of our support to do it all for you. To begin with, we will give you the information for just situation a) as b) is just a changing of some of the information. To start with, a red candlestick is one where the Close is lower than the Open (in general). Therefore the formula for this is fairly straightforward as: =C < O Then to check the Delta for the bar, you need a study from which to gather that information. The Numbers Bars Calculated Values is one of the easiest to get it from, and since you are on Package 11, you have access to this, so you would just need to look at subgraph 1 (Ask Volume Bid Volume Difference) of the "Numbers Bars Calculated Values" study. So that formula would be the following where ID1 is the ID of the Numbers Bars Calculated Values study: =ID1.SG1 > 0 Things get harder from here, as we assume you are wanting to test every price level for the Bid/Ask imbalance. In which case, you need to spell out what you want at each level. Since you are using a Range bar, this limits the number of times you need to do this, since you know how many levels there are in each bar. For the imbalance tests at the bottom two levels of a bar, it would look like the following: =OR(AND(AVAP(L, 0) > BVAP(L, 0), AVAP(L, 0) > BVAP(L - TICKSIZE * 1, 0)), AND(AVAP(L + TICKSIZE * 1, 0) > BVAP(L + TICKSIZE * 1, 0), AVAP(L + TICKSIZE * 1, 0) > BVAP(L, 0))) Refer to the following for information on AVAP and BVAP: Study/Chart Alerts And Scanning: Special Functions Note that the multiplication by 1 for the ticksize is not necessary, but we put it there so you understand how to deal with the data at further up price levels. The 'L' is the Low of the bar. You then have to put everything together using the AND() function. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2024-07-08 20:48:14
|
| [2024-07-09 14:12:56] |
| User669552 - Posts: 15 |
|
Lastly Kindly assist with the condition part. I would like a result that would give me a a thick dark blue line on the left side of the Numbers bar that would extend from from upper price Leve that is being compared to the lower price leve being compared if condition a) or b) is met. This line is intended to help me easily see those two price level when the condition a) or b) is met. |
| [2024-07-09 17:05:01] |
| John - SC Support - Posts: 36238 |
|
The only thing we can do is point you to the documentation for the "Color Bar Based on Alert Condition" which has the ability to place a marker at a specific level. Refer to the following, and the section on "Drawing Arrows/Text or Other Styles at the High or Low of Bars" in particular: Color Bar Based on Alert Condition For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-07-09 23:36:21] |
| User669552 - Posts: 15 |
|
Is This the proper condition for a) and b) as per your guidance? a) AND(AND((C<O), ID1.SG1 > 0), OR( AND(AVAP(L + 1, 0) > BVAP(L + 1, 0), AVAP(L + 1, 0) > BVAP(L, 0)), AND(AVAP(L + 2, 0) > BVAP(L + 2, 0), AVAP(L + 2, 0) > BVAP(L + 1, 0)), AND(AVAP(L + 3, 0) > BVAP(L + 3, 0), AVAP(L + 3, 0) > BVAP(L + 2, 0)), AND(AVAP(L + 4, 0) > BVAP(L + 4, 0), AVAP(L + 4, 0) > BVAP(L + 3, 0)), AND(AVAP(L + 5, 0) > BVAP(L + 5, 0), AVAP(L + 5, 0) > BVAP(L + 4, 0)), AND(AVAP(L + 6, 0) > BVAP(L + 6, 0), AVAP(L + 6, 0) > BVAP(L + 5, 0)), AND(AVAP(L + 7, 0) > BVAP(L + 7, 0), AVAP(L + 7, 0) > BVAP(L + 6, 0)), AND(AVAP(L + 8, 0) > BVAP(L + 8, 0), AVAP(L + 8, 0) > BVAP(L + 7, 0)) )) b) AND(AND((C<O), ID1.SG1 > 0), OR( AND(BVAP(L, 0) > AVAP(L, 0), BVAP(L, 0) > AVAP(L + 1, 0)), AND(BVAP(L + 1, 0) > AVAP(L + 1, 0), BVAP(L + 1, 0) > AVAP(L + 2, 0)), AND(BVAP(L + 2, 0) > AVAP(L + 2, 0), BVAP(L + 2, 0) > AVAP(L + 3, 0)), AND(BVAP(L + 3, 0) > AVAP(L + 3, 0), BVAP(L + 3, 0) > AVAP(L + 4, 0)), AND(BVAP(L + 4, 0) > AVAP(L + 4, 0), BVAP(L + 4, 0) > AVAP(L + 5, 0)), AND(BVAP(L + 5, 0) > AVAP(L + 5, 0), BVAP(L + 5, 0) > AVAP(L + 6, 0)), AND(BVAP(L + 6, 0) > AVAP(L + 6, 0), BVAP(L + 6, 0) > AVAP(L + 7, 0)), AND(BVAP(L + 7, 0) > AVAP(L + 7, 0), BVAP(L + 7, 0) > AVAP(L + 8, 0)) )) Date Time Of Last Edit: 2024-07-10 06:38:37
|
| [2024-07-16 12:40:38] |
| User669552 - Posts: 15 |
|
Is the `NUMBARS_COLOR(condition, color, location)` suitable to use with the spreadsheet to highlight specific areas in the Numbers Bar under conditions. I am still struggling to highlight areas in Red candlestick Where the Ask Volume is greater the Bid Volume horizontally and diagonal Bid Volume at a lower level. Date Time Of Last Edit: 2024-07-16 13:16:12
|
| [2024-07-16 13:18:53] |
| User669552 - Posts: 15 |
|
Am not a coder but I can Use A.I . I just need to be pointed in the right direction. If I could get the frame I can bus A.I to finish the job I just need directions
|
To post a message in this thread, you need to log in with your Sierra Chart account: