Support Board
Date/Time: Mon, 03 Feb 2025 04:06:05 +0000
Post From: Overlay only the open of a 30 minute price bar onto another non time based chart
| [2019-10-18 23:37:05] |
| Sawtooth - Posts: 4164 |
|
Use this formula in the Spreadsheet Formula study on the 30 min chart: =IF(OR(MROUND(BARTIME,1/86400)=TIMEVALUE("09:30:00"),MROUND(BARTIME,1/86400)=TIMEVALUE("08:30:00"),MROUND(BARTIME,1/86400)=TIMEVALUE("09:00:00"),MROUND(BARTIME,1/86400)=TIMEVALUE("07:30:00"),MROUND(BARTIME,1/86400)=TIMEVALUE("07:00:00")),O,0) Is there a Spreadsheets for Dummies out there anywhere?
There's this:https://www.sawtoothtrade.com/tip-1.html https://www.sawtoothtrade.com/tip-2.html But SC's documentation is the authoritive resource. It may seem daunting but it is comprehensive. Start here: Overview of Spreadsheet Studies You can also go to YouTube and search for "sierra chart spreadsheet" There are some videos from various sources. |