Support Board

Date/Time: Sun, 19 May 2024 09:47:31 +0000

Post From: Understanding Spreadsheet Formula Examples

[2018-05-05 14:49:00] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4000
"If the absolute value of J8 equals 5, then 2, else if the absolute value of J8 equals 3, then 3, else 0" This formula goes in J26, which is the Order Quantity, so the outputs of 2, 3, and 0 are the conditional order quantities. J8 is the Position Quantity and it will be positive if in a long, or negative if in a short, so the absolute value is used to always return a positive number.