Support Board
Date/Time: Mon, 03 Feb 2025 03:53: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] |
| 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! |