Login Page - Create Account

Support Board


Date/Time: Fri, 14 Mar 2025 09:37:59 +0000



[User Discussion] - SPREADSHEET FORMULA HELP ZONAL ENTRY!

View Count: 326

[2022-06-20 07:07:23]
User9890731 - Posts: 47
hi, Iam trying to code an entry spreadsheet using zones based on price range, i need help coding a formula for when last price(=Id0.SG4@3) within to a certain price range or zone. Iam using the POC of volume profile to determine my zones, so each zone will be between POC and certain number of ticks(J21) from the current POC.

So basically if ID0.SG4@3 is ''between'' (J21*no of tick from the POC) and POC (=ID3.SG2@3) then a signal is formed depending on whether its buy or sell...
[2022-06-20 12:55:32]
Sawtooth - Posts: 4182
Try this:

Zone above POC:
=AND(E3>ID3.SG2@3,E3<ID3.SG2@3+$J$21*n)

Zone below POC:
=AND(E3<ID3.SG2@3,E3>ID3.SG2@3-$J$21*n)

Zone straddling POC:
=AND(E3>ID3.SG2@3-$J$21*n,E3<ID3.SG2@3+$J$21*n)

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account