Login Page - Create Account

Support Board


Date/Time: Sat, 28 Jun 2025 10:16:21 +0000



Post From: Help with spreadsheet study. Did not find similar question on the boards

[2021-09-09 12:42:57]
Sawtooth - Posts: 4231
This is the correct syntax:
=if(row()=3,(sum(BE3:BE12)-sum(BC3:BC12))/(sum(BE3:BE12)+sum(BC3:BC12)),0)

If you are trying to create a OHLC bar, you'll need 4 values, only in columns K,L,M,N, using this setting to Yes:
Spreadsheet Study Inputs: Use Price Graph Style