Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 15:56:14 +0000



Measuring percent move on daily basis?

View Count: 326

[2023-01-13 16:15:22]
Spartan79 - Posts: 54
Hi.

Is there a way to measure a move of an instrument based on a it's daily range as opposed to all time price? Like today in ES a 17 point move is 0.43%, whereas 17 point move based on just today's price range of 46.50 is 37%. Either with a tool, but preferably with a zig zag study?

Thank you.
[2023-01-13 16:50:48]
Spartan79 - Posts: 54
I tried percent change since open study and the whole day today shows 890% when measured from top to bottom with calculation tool. And same 17 point move that should be 37%, shows 87.50%. So that will not work.
[2023-01-13 18:47:45]
John - SC Support - Posts: 30459
To start with, what exactly is the calculation you want to view. How do you want to use the Daily Range to determine the percentage movement?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2023-01-13 21:49:07]
Spartan79 - Posts: 54
What I want to achieve is to get a percentage of a move based on the day's high/low range, and not compared to it's price.

Like today in ES a 17 point move would be 0.43% price movement compared to it's price of around 3983. Calculation 17 / 3983 = 0.00426 , which is 0.43%.

Whereas 17 point move in today's full session range before noon, which was 46.5 would be 37%. Calculation 17 / 46.5 = 0.37 , which is 37%.

Hope that makes a bit more clear.
[2023-01-13 22:04:58]
John - SC Support - Posts: 30459
If you are doing this on an Intraday chart and you want the "Day" to be the trading day that starts with the prior day's Evening Session, then start with the Daily OHLC study to get the High and Low for the day. Refer to the following for the Daily OHLC study:
Daily OHLC

Then it's your choice on which study to use to do the calculation. I personally like the Spreadsheet Formula, where you would enter the following for the formula:
=(ID1.SG2 - ID1.SG3) / C

Where ID1 is the ID number of the Daily OHLC study and C is the close of the bar, so at each bar you will see what the close is in comparison to the Range at the current time. The most current bar will give you the current value.

Refer to the following for the Spreadsheet Formula:
Spreadsheet Formula

If you want to display the values as Percentages, then set the Value Format to Percent. You could also multiply by 100 if you do not want to see the % signs. Refer to the following for information on the Value Format:
Chart Studies: Settings and Inputs Tab >> Value Format
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2023-01-13 22:35:54]
Spartan79 - Posts: 54
Can I somehow do it with zig zag study? I would like to see that at each swing plotted automatically, by zig zag as opposed to each bar.

I want to put zig zag on the chart and set it to show just percent of each swing high / low based on calculations in post #4.
[2023-01-13 22:58:32]
John - SC Support - Posts: 30459
To do what you want you need to use the Spreadsheet Study. You can then get rid of the Spreadsheet Formula study and put the formula into one of the calculation columns for the spreadsheet. Note that the formatting is different between the Spreadsheet Formula and the Spreadsheet - the Spreadsheet Formula uses the Alert Syntax, which is different from the Spreadsheet Syntax.

The formula you would enter in the Spreadsheet to calculate the values is the following:
=(ID1.SG2@3 - ID1.SG3@3) / ID0.SG4@3

Then on the Zig Zag study be sure you select Yes for the Input that states Additional Output for Spreadsheets.

Then in the Spreadsheet you will see the Zig Zag information starting around column AA (depending on what other studies you have on your chart). You will then need to create an IF() statement in one of the calculation columns that checks when an inflection occurs and then writes out the value of the formula or a 0 otherwise. Refer to the information for spreadsheet functions at the following link:
Spreadsheet Functions

Then you would want to use a Draw Style for that column of Value on High or one of the options like it to get the value displayed.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2023-01-16 17:30:15]
Spartan79 - Posts: 54
OK, got it to work, thank you.

But I run into a problem. I did that for both price and cumulative delta and it works fine. Since I want the percent values to display both on price and cumulative delta, I put another spreadsheet study. One to display % on price and another to display % on delta in chart region 2. As soon as I put second spreadsheet study on, I start to get double prices, and zig zag line length starts to print same, multiple reversal values in a row. And that in turn messes up the chart.

Is this some unforeseen problem, or I can't put 2 spreadsheet studies on one chart? Everything goes back to normal when I remove the second spreadsheet study.

I included screenshots. First two show the problem. Third is when I remove the second spreadsheet.
imageDouble times - zig zag multiple signal 1.png / V - Attached On 2023-01-16 17:27:20 UTC - Size: 309.42 KB - 49 views
imageBad signal.png / V - Attached On 2023-01-16 17:27:29 UTC - Size: 39.06 KB - 47 views
imageGood .png / V - Attached On 2023-01-16 17:27:45 UTC - Size: 283.96 KB - 43 views
[2023-01-16 19:54:57]
John - SC Support - Posts: 30459
You can have multiple Spreadsheet Studies, but you have to very careful about setting them up so you do not have what happened to you. You can do this one of two ways.

1) Different Spreadsheet Files: Add the Spreadsheet study once and then be sure to save the Spreadsheet to a specific name. Then add the second Spreadsheet study and then save that spreadsheet to a different name. Refer to Step 5 at the following link:
Using the Spreadsheet Study: Step By Step Instructions to use the Spreadsheet Study

2) Different Sheets within a single file: Add the first Spreadsheet study and note the Chart Data Output Sheet Number. A 0 indicates that it should use the Chart Number for the Sheet Number (hence the issue when you add a second spreadsheet. When you add the second Spreadsheet Study make sure you specify a Sheet Number (or Name) that is different from the first spreadsheet study. Just be sure you pay attention to the Sheet you are working on at any given time to make sure it is the correct one.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing

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

Login

Login Page - Create Account