Support Board
Date/Time: Tue, 04 Nov 2025 10:00:07 +0000
[User Discussion] - Volume - Colored Based on Volume
View Count: 1275
| [2020-06-23 07:18:48] |
| ULADZIMIR VALASACH - Posts: 38 |
|
I would like to make a trading strategy on this indicator. Problem: there is only one SG in the spreadsheet. You can set the time for opening an order - by the magnitude of the indicator, but how to determine the direction of the order in the spreadsheet (the indicator gives a red or green color)? |
 volume colored.png / V - Attached On 2020-06-23 07:17:34 UTC - Size: 11.54 KB - 318 views |
| [2020-06-23 13:25:15] |
| Sawtooth - Posts: 4285 |
|
Use a Formula Column to calculate when the color changes. Use this formula in row 3: =IF(F3>F4,1,IF(F3<F4,-1,0)) This will return a 1 for the up-color, and a -1 for the down-color. |
| [2020-06-23 13:48:58] |
| ULADZIMIR VALASACH - Posts: 38 |
|
Thank you very much - I will try!
|
| [2020-06-24 12:24:31] |
| ULADZIMIR VALASACH - Posts: 38 |
|
Is it necessary to register in K3 and M3?
|
| [2020-06-24 13:04:14] |
| ULADZIMIR VALASACH - Posts: 38 |
|
placed in FS3 - it turns out wrong ...
|
| [2020-06-24 13:32:44] |
| Sawtooth - Posts: 4285 |
|
You must use a Formula Column. If 'Number of Formula Columns' is set to 16 then you can only use columns K-Z. Spreadsheet Study Inputs: Number of Formula Columns If you are using the Spreadsheet System for Trading study, only use columns O-Z because columns K-N are for entry and exit signals. So, for example, put =IF(F3>F4,1,IF(F3<F4,-1,0)) in cell O3, and reference it in your entry formulas in K3/M3. |
| [2020-06-24 15:20:54] |
| ULADZIMIR VALASACH - Posts: 38 |
|
Thanks - now the color determines (translates to 1 or -1) !! How to specify the condition for the purchase? = AND ($ AC3> 3,000,000, $ O3> 0) |
| [2020-06-24 15:32:15] |
| Sawtooth - Posts: 4285 |
|
Only use commas to separate the AND conditions. No commas in the 3,000,000 number. =AND(AC3>3000000,O3=1) |
| [2020-06-25 06:51:35] |
| ULADZIMIR VALASACH - Posts: 38 |
|
Thank! Set: K3=AND(AC3>3000000,O3=1) M3=AND(AC3>3000000,O3=-1) Opens only buy orders! |
| only buy.png / V - Attached On 2020-06-25 06:51:29 UTC - Size: 61.46 KB - 327 views |
| [2020-06-25 14:50:56] |
| Sawtooth - Posts: 4285 |
|
The formula I offered will only work when using Volume - Colored Based on Volume study, as you put in the title of this thread. Sorry, I didn't notice in the pics that you were instead using the Volume - Colored Based on Bar Closes study. I see that you are also using Renko bars. Apparently the Volume - Colored Based on Bar Closes study is not using Renko open and close values. Try this: 1. Add the Renko Visual Open/Close Values study, and hide the study. 2. Use a formula like this in O3: =IF(AF3>AE3,1,IF(AF3<AE3,-1,O4)) -where the Renko open is in AE3 and the Renko close is in AF3. Edit as needed. 3. Use these formulas in K3/M3: K3: =AND(AC3>3000000,O4=-1,O3=1) M3: =AND(AC3>3000000,O4=1,O3=-1) |
| [2020-06-26 06:53:20] |
| ULADZIMIR VALASACH - Posts: 38 |
|
Oh - it's my fault - I mixed up and did not notice! Thank you very much for your help! I will try. |
| [2020-07-01 09:45:56] |
| ULADZIMIR VALASACH - Posts: 38 |
|
Good day! And can you register it as a signal to open an order - a change in the color of the renko bar? For example, if it was green and turned red - sale, it was red and turned green - purchase. |
| [2020-07-01 13:20:10] |
| Sawtooth - Posts: 4285 |
|
And can you register it as a signal to open an order - a change in the color of the renko bar?
You'll need to use the Spreadsheet System for Trading study for this.
|
To post a message in this thread, you need to log in with your Sierra Chart account: