Support Board

Date/Time: Sat, 04 May 2024 22:50:28 +0000

Post From: Overlay only the open of a 30 minute price bar onto another non time based chart

[2019-10-06 12:46:54] Link To Thread - Link To Post [Go To First Post]
User626032 - Posts: 36
Thanks for the help. That worked perfect, but only for the 9:30 open bar period. How can I add on the other TIMEVALUES in your formula? I tried adding onto your formula like this: =IF(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) But it was rejected saying the formula has no value Is there anyway to add the other 30 min. opens in one formula? I guess I could duplicate this for each bar but that would add too many studies. I want to learn spreadsheet studies and the language but can't find a good resource for starting out. The documentation is written for software engineers not coding bunnies like me. Is there a Spreadsheets for Dummies out there anywhere? Thanks once more, I appreciate your reply. Anymore help would be great!