Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Thu, 28 Nov 2024 15:50:21 +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: 4120
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))