Login Page - Create Account

Support Board


Date/Time: Sun, 16 Mar 2025 16:14:48 +0000



Post From: ONH and ONL

[2022-08-16 20:51:59]
User707307 - Posts: 84
Oh well, just when I thought I had everything done, now the ONH and ONL is not shown on the right place. I followed all the steps I read on Sierra but there is still something I must be doing wrong.

I followed the next steps:

- I created a high/low for time period extended. (You can see the settings on picture 1)

After I created a spreedsheet formula for the ONH and one for the ONL with the following settings:
ONH: =IF(AND(BARTIME>=TIMEVALUE("15:30:00"),BARTIME<TIMEVALUE("22:00:00")),ID12.SG1,0)
ONL: =IF(AND(BARTIME>=TIMEVALUE("15:30:00"),BARTIME<TIMEVALUE("22:00:00")),ID12.SG2,0)

But I find out the ONH and ONL is not shown on the right place, it should be on:
ONH: 4300.25
ONL: 4279.25

And it's actually on 4292.5 for the ONH and 4286.5 for the ONL.

What am I doing wrong?
Thank you
imageSettings 1.png / V - Attached On 2022-08-16 20:50:48 UTC - Size: 39.84 KB - 120 views