Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 08:15:38 +0000



[User Discussion] - Volume - Colored Based on Volume

View Count: 1038

[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)?
imagevolume colored.png / V - Attached On 2020-06-23 07:17:34 UTC - Size: 11.54 KB - 254 views
imagesg1.png / V - Attached On 2020-06-23 07:17:48 UTC - Size: 40.52 KB - 275 views
imageAK3.png / V - Attached On 2020-06-23 07:17:58 UTC - Size: 10.47 KB - 251 views
[2020-06-23 13:25:15]
Sawtooth - Posts: 3952
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 ...
imageAC3.png / V - Attached On 2020-06-24 13:04:05 UTC - Size: 32.43 KB - 246 views
[2020-06-24 13:32:44]
Sawtooth - Posts: 3952
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: 3952
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!
imageset.png / V - Attached On 2020-06-25 06:51:18 UTC - Size: 40.01 KB - 234 views
imageonly buy.png / V - Attached On 2020-06-25 06:51:29 UTC - Size: 61.46 KB - 261 views
[2020-06-25 14:50:56]
Sawtooth - Posts: 3952
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: 3952
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:

Login

Login Page - Create Account