Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Mon, 21 Jul 2025 01:46:20 +0000

How to Post a Message for Support

Post From: Weird issue with spreadsheet BARS

[2023-04-21 13:51:16]
[Go To First Post]
Sawtooth - Posts: 4245
The Spreadsheet Formula (Bar) study does not have an option to draw zeros.

Use these formulas as a workaround:
=IF((O-ID2.SG1)/ID2.SG1=0,0.0000001,100000*((O-ID2.SG1)/ID2.SG1))
=IF((H-ID2.SG1)/ID2.SG1=0,0.0000001,100000*((H-ID2.SG1)/ID2.SG1))
=IF((L-ID2.SG1)/ID2.SG1=0,0.0000001,100000*((L-ID2.SG1)/ID2.SG1))
=IF((C-ID2.SG1)/ID2.SG1=0,0.0000001,100000*((C-ID2.SG1)/ID2.SG1))