Login Page - Create Account

Support Board


Date/Time: Mon, 25 Nov 2024 08:45:46 +0000



Creating Pivot Ranges for Next Day

View Count: 423

[2024-03-12 19:17:32]
SierrChartUser - Posts: 6
Hello,

It would be nice to have the day's pivot range (one market is closed and settle is established) show for the next day. I can't seem to get anything to show for the next day.

Is it possible that once the market is closed for the day that I could caclulate the 1 day and 3 day pivot range and show it as a highlighted range in the blank space to the right of the current day close?

I appreciate everyone's time and assistance. Thank you!

Matthew
[2024-03-12 19:44:54]
John - SC Support - Posts: 36238
There is an Input in the Pivot Points Daily study for "Forward Project Pivot Point Lines". Refer to the following:
Pivot Points: Forward Project Pivot Point Lines

In the Pivot Points Variable Period there is an Input for "Number of Forward Projection Bars". Refer to the following:
Pivot Points: Number of Forward Project Bars
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-03-12 21:04:36]
SierrChartUser - Posts: 6
I have played around with these studies and they don't seem to work correctly. I am simply trying to display current days pivot and the current days 3 day pivot.

The closest is using another study called "Pivot Range-Variable Period" however it cannot calculate beyond one day. IF I say, set the time period type to Days and Length to 3 I see the program adds 2 extra pivot before displaying the current day pivot to the right of the chart instead of displaying the 3 day pivot. Even using 1 day pivot, the study always displays yesterdays pivot and todays instead of just todays displayed to the right of the chart.
[2024-03-12 21:34:31]
SierrChartUser - Posts: 6
Hi John,

I would just like to add that the H and L is taken from an RTH intraday chart and the settle is taken from a historical chart to match to the CME settle. I have this calculation in a SC spreadsheet that displays the current day. I just can't seem to figure out how to project it into the next.
Date Time Of Last Edit: 2024-03-12 21:35:10
[2024-03-13 13:45:07]
John - SC Support - Posts: 36238
There is a way to get a line into the forward projection area, but it takes a few studies per line. There is a study called "Forward Projection Bars" that will take the last n bars and display them in the forward projection area, but this study only works with bars. It is possible to make this work, however. What you would need to do is the following for each line you want to project:
- Add the "Spreadsheet Formula - Bar" study.
- Enter the following formula for the Close in the Spreadsheet Formula - Bar: =ID1.SG1
Where ID1 is the ID of your Spreadsheet study and SG1 is the subgraph that has the data you want to project
- Add the "Forward Projection" study to the chart and set the "Based On" to be the "Spreadsheet Formula - Bar". In the Subgraphs tab change the "Graph Draw Type" at the top to "Line on Close". Change the color and width for the Close subgraph as you want.
- Repeat the above for each line.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-03-21 00:02:24]
SierrChartUser - Posts: 6
This actually worked well. It took a bit of tweaking to get it to where I would like it and now I am satisfied with the results. Thank you, John for pointing me in the right direction.

I've started learning ACSIL and would like to turn this into a study. It think it would be a good first start as the code "shouldn't" be too complicated.

Thank you again.

Matthew

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

Login

Login Page - Create Account