Login Page - Create Account

Support Board


Date/Time: Thu, 01 May 2025 09:34:13 +0000



How to Show Cumulative $Tick-NYSE (Market Stats) as Candlesticks instead of Line/Bar

View Count: 306

[2025-03-07 13:14:11]
User708340 - Posts: 12
Using "Cumulative Sum of Study" , I plot cumulative $TICK-NYSE (Market Stats) data in Sierra Chart, but I'd like to display it as candlesticks instead of the default line/bar chart with "cumulative Sum of Study".

I've noticed that the Cumulative Volume Delta (CVD) indicator use candlesticks.

Please tell me how to Show Cumulative $Tick-NYSE (Market Stats) as Candlesticks instead of Line/Bar.

Thanks
Date Time Of Last Edit: 2025-03-07 16:04:43
image$TICK .png / V - Attached On 2025-03-07 16:04:36 UTC - Size: 18.96 KB - 32 views
[2025-03-07 15:52:58]
John - SC Support - Posts: 39580
We really do not understand what you are doing, or what you want to do.

But if you have a way to define the Open, High, Low, and Close to create a bar, then the easiest way to do this is to use the "Spreadsheet Formula - Bar" study. Refer to the following:
Spreadsheet Formula
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2025-03-07 16:08:05]
User708340 - Posts: 12
Sorry for the confusion.

I want to show cumulative $TICK-NYSE (Market Stats) as Candlesticks instead of Line/Bar.
[2025-03-07 16:37:35]
cmet - Posts: 690
In your NYSE Tick Chart:

Go to Chart Settings > Bar Period > Graph Draw Type > Candlestick Bars
[2025-03-07 16:42:42]
User708340 - Posts: 12
Thanks, CMET

That's not what I meant. I have TICK-NYSE displayed as Candlestick. I have applied "Cumulative Sum of Study" on it and the result is the cumulative TICK-NYSE in Chart Region 1. But it's in line or bar format.

I want to show the cumulative TICK-NYSE as Candlestick.

Thanks
[2025-03-07 16:59:43]
John - SC Support - Posts: 39580
The "Cumulative Sum of Study" has to be set to be the cumulative of one of the 4 items that make up a bar - Open, High, Low, and Close.

To get a "Bar" for the "Cumulative Sum of Study", you would need to sum each of the item, which would require a total of 4 "Cumulative Sum of Study" studies, one each for Open, High, Low, and Close.

Then use the "Spreadsheet Formula - Bar" and set each item to reference the appropriate Cumulative Sum of Study.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2025-03-07 17:01:14]
cmet - Posts: 690
Gotcha. An alt to spreadsheet would be to take the code for the "Cumulative Sum of Study" and create a new version that includes the ability to plot candles. Like mentioned above, you just need the O,H,L,C to create them.

Original code is in Studies5.cpp
[2025-03-07 18:12:53]
User708340 - Posts: 12
Hi John

I followed your instruction. The result is not right. May you tell me where I did wrong. Image attached.
imagecumulative result.jpg / V - Attached On 2025-03-07 18:12:43 UTC - Size: 163.2 KB - 41 views
[2025-03-07 19:54:25]
John - SC Support - Posts: 39580
That makes sense to me for what it is.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2025-03-07 21:25:05]
cmet - Posts: 690
Here's a custom version of the Cumulative Sum of Study.

You can add the dll to your Data directory or compile yourself with the cpp file.
attachmentCSoS_2_64.dll - Attached On 2025-03-07 21:24:36 UTC - Size: 105.5 KB - 62 views
attachmentCSoS_2.cpp - Attached On 2025-03-07 21:24:44 UTC - Size: 2.12 KB - 74 views
imageCsoS_2.jpg / V - Attached On 2025-03-07 21:24:49 UTC - Size: 108.86 KB - 49 views
[2025-03-07 21:30:36]
User708340 - Posts: 12
Thank you so much, cmet.

That's exactly what I need.

Appreciated!!
[2025-03-07 23:17:17]
ondafringe - Posts: 322
That's pretty slick, @cmet!

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

Login

Login Page - Create Account