Login Page - Create Account

Support Board


Date/Time: Mon, 25 Nov 2024 06:24:40 +0000



Visualize Daily Change % from Quote Board in a Chart?

View Count: 573

[2024-03-19 17:46:55]
MarkusK - Posts: 99
Is it somehow possible to visualize the percentages from the Daily Change % column of the Quote Board in a chart?

I tried to achieve this by adding the corresponding symbols to a chart and then using the "Percent Change Since Open" study, but somehow this shows a different percentage value than the Quote Board.

Any advice how to implement that would greatly be appreciated.
[2024-03-20 14:45:41]
John - SC Support - Posts: 36238
Refer to how the Daily Change in the Quote Board is calculated at the following link:
Getting Quotes: Field Descriptions

You can view/get the Settlement Price from a Daily Historical Chart as well.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-03-21 13:06:09]
MarkusK - Posts: 99
Thanks for the link John!

Based on that documentation, I understand how the daily change is calculated in the QuoteBoard and also how to extract the settlement price from a daily historical chart.

But what I don't see yet is how to properly visualize that information in a chart (e.g. as a line chart)
My goal is to build a "FAANG chart", that displays the daily change in % for the major tech stocks.

I assume it's much easier to realize than I think, but I just cannot find a solution right now.

Any additional advice would really be appreciated.
[2024-03-21 16:25:45]
John - SC Support - Posts: 36238
We need a bit more information on what you want to see.

In particular, it sounds like you want an indicator that shows the Daily Change % over time, but in order to do this properly, you would have to look at the Close for a day that is NOT the settlement price and then divide that by the previous day's settlement price.

Or, do you want to compare Settlement price from day to day?

Or is it something else?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-03-22 04:49:21]
MarkusK - Posts: 99
Thanks John. Yes, exactly, I would like to create a chart that shows the Daily Change % over time for a trading day for multiple stocks (to see how the market, especially tech stocks, develop during RTH).

I attached a screenshot of my current chart to illustrate how that looks like so far:
I created a blank chart, and for each stock that I want to watch I added an "Add Additional Symbol" study and "paired" it with a corresponding "Percent Change Since Open" study.

I assumed that this would match with the % values for each stock that I can see in the DailyChange% column of the quote board (which is 0.00% on the attached screenshot because the market is closed at this moment), but the % values are different.

So, I'm not sure, if my approach is completely wrong, or if I just missed some important details. Maybe I just mistunderstood how the "Percent Change Since Open" study works.
imageFAANG Chart.png / V - Attached On 2024-03-22 04:49:03 UTC - Size: 118.24 KB - 57 views
[2024-03-22 14:46:05]
John - SC Support - Posts: 36238
As we noted above, the main reason you see a difference between the "Daily Change %" and the "Percent Change Since Open" is that the "Daily Change %" uses the Settlement price, which requires that you compare to the Close of the previous day from a Daily chart. This is going to be different from the Open of the current day in an Intraday Chart.

Getting exactly what you want is going to be a bit complicated, but it can be done. It is a bit more than what we can help you with in this Support Board. Basically, you will have to have two charts, one Intraday and one Daily, so you can get the Settlement price from the Daily chart. And then you will need to overlay the Daily to the Intraday and then use the Spreadsheet Study to align the data so that you can get the Daily data aligned to the Session Times for your Intraday Chart and then you can divide the Close of the Intraday bar by the Close of the previous day's Settlement.

Sorry we can not help more, as we said, it's going to be a bit complicated.

Doing this with a Custom Study would be easier. Refer to the following:
Advanced Custom Study Interface and Language (ACSIL)

List of Third Party Sierra Chart Study and System Programmers
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-03-22 14:54:48]
MarkusK - Posts: 99
Thanks a lot John, your explanation was already very helpful and pointed me in the right direction!

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

Login

Login Page - Create Account