Login Page - Create Account

Support Board


Date/Time: Mon, 29 Apr 2024 14:31:57 +0000



how to plot open price from another chart

View Count: 622

[2021-02-08 16:18:12]
User970210 - Posts: 83
Hi,
I would like to know how to plot open price from another chart in the chartbook? thx
[2021-02-08 16:44:34]
John - SC Support - Posts: 31159
It depends on a what Open price you want (current bar Open, or the daily Open) and how you want to display it in your current Chartbook.

In general, refer to the following study:
Text Display For Study
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2021-02-08 19:48:44]
User970210 - Posts: 83
thanks John.
I would like to plot a line on eg 30min chart that represent current opening price from forming bar of 240min chart. I have tried period OHLC study. but it not precise. also tried overlay line and study/price overlay without satisfaction.
Song
[2021-02-09 20:45:35]
User970210 - Posts: 83
Hi,
I am wondering how to specify bar at first day of every week/every month/every year? thx
[2021-02-09 21:14:07]
John - SC Support - Posts: 31159
With regards to drawing the line at the level of the Open of the current bar in a 240min chart to a 30min chart, do the following:

On the 240min chart add the Spreadsheet Formula and use the following settings:
- Formula: =O
- Number of Bars to Calculate: 1

On the 30min chart add the Study/Price Overlay and use the following settings:
- Study to Overlay: 240min chart and Spreadsheet Formula
- Match Source Bars to Destination Bars: No
- Use Styles and Widths from Source Study: No
- On the Subgraphs tab set the Draw Style for the subgraph to: Line from End of Chart - Left to Right


---------------------------

I am wondering how to specify bar at first day of every week/every month/every year?
Are you asking this in relation to the above question, so you would have a line that is the Open for each period? Or are you asking for a Vertical line to denote each time period?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2021-02-10 01:22:43]
User970210 - Posts: 83
thx, John
very smart!
[2021-02-10 21:34:54]
User970210 - Posts: 83
Are you asking this in relation to the above question, so you would have a line that is the Open for each period? Or are you asking for a Vertical line to denote each time period?
yes, John. You are correct that I would like to have horizontal line to indicate higher time frame opening price. or opening price of first bar of the current time period.
thx
[2021-02-10 22:19:34]
John - SC Support - Posts: 31159
I would like to have horizontal line to indicate higher time frame opening price. or opening price of first bar of the current time period.

This can be done using the Daily OHLC study, but there really isn't a study that will allow you to select the Open from the beginning of some time period other than days.

The best way we can think to do this would be to use the Spreadsheet Study and just us an IF statement along with a time and/or date reference. Refer to the information here for the Spreadsheet Study in general:
Using the Spreadsheet Study

Refer to the following for the IF function:
https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#IF_Function

And refer to the following for how to work with Dates and Times:
Spreadsheet Functions: Serial DateTime Values
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