Login Page - Create Account

Support Board


Date/Time: Wed, 25 Dec 2024 14:07:09 +0000



High Volume Bar of the day

View Count: 1128

[2015-11-23 20:01:23]
User167108 - Posts: 49
Hi,

Would it be possible to Color Bar alert or some kind of a way to see Highest Volume Traded Bar ? I am using Number Bar Calucalted Values .. I can see the numbers ..How do i get color changed for that High volume Bar ? Appreciate your time .
[2015-11-23 22:04:58]
Sawtooth - Posts: 4142
If you only want to color the latest Highest Volume Traded Bar, and uncolor the previous Highest Volume Traded Bar, you would need to use a spreadsheet study.
[2015-11-24 12:53:28]
User167108 - Posts: 49
Thanks Tomglib . I am brand new as u might have already noticed and trying to learn . NOT sure about those spread sheet study ..Would it be possible to share any simple example chart study with spread sheet study and guide me .. I will take it from there and try myself ..Appreciate your time ,
[2015-11-24 20:29:06]
Sawtooth - Posts: 4142
Attached is a New Spreadsheets example chartbook/spreadsheet file to demonstrate this. Put both files in your Sierra Chart \Data folder, then go to File >> Open Chartbook >> High Vol Bar of Day.cht

There are some limitations:
-Maximum lookback is 18 days, due to a maximum of 60 Formula Columns.
-The New Spreadsheets version has inherent inefficiencies and cannot do more than a few days lookback without severe lag. I had to delete the formulas in columns W:BR so that it would function. The attached example has only 2 days lookback, current day inclusive.
-The Old Spreadsheets version could do up to 18 days lookback without significant lag.

This may seem like a simple thing to do but it is best done with a custom ACSIL study.
attachmentHigh Vol Bar of Day.cht - Attached On 2015-11-24 20:28:07 UTC - Size: 38.81 KB - 456 views
attachmentHigh Vol Bar of Day.scss - Attached On 2015-11-24 20:28:17 UTC - Size: 66.95 KB - 457 views
[2015-11-24 22:21:10]
User167108 - Posts: 49
Thanks a lot Tomgilb , I will give a try . You are so helpful ..Thanks again

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account