Login Page - Create Account

Support Board


Date/Time: Mon, 16 Jun 2025 09:32:31 +0000



Post From: How to plot only the current hourly open as dash on a 5min chart

[2025-05-14 17:51:23]
John - SC Support - Posts: 40422
Use the following formula in a "Spreadsheet Formula" study to display the Open from the OHLC Variable Period for just the current hour. You can hide the OHLC Variable Period study once you have this setup.
=IF(INT(BARTIME * 24) = INT(FRACTIME(NOW()) * 24), ID1.SG1, 0)

Where ID1 is the ID of the OHLC Variable Period study and SG1 is the Open subgraph of that study.

Make sure you set the Input for "Draw Zeros" in the Spreadsheet Formula to "No".

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