Support Board

Date/Time: Fri, 19 Apr 2024 18:23:50 +0000

Post From: Modifying an equation

[2013-03-22 09:36:21] Link To Thread - Link To Post [Go To First Post]
tobi - Posts: 351
It's exactly as Tom pointed out. To have a more universal solution, so you can easily adjust to other markets too other than the YM, please change the spreadsheet as follows: In cell Q2 type in: "=J21Q1" (without the quotation marks) In cell R2 type in: "=J21R1" In cell Q1 type in e.g. "0,5" (or you might have to use "0.5" depending on your decimal system) In cell R1 type in e.g. "1" The numbers in cells Q1 and R1 are responsible for the distance between the high/low and the alert signal. They can vary for different markets. You have to play around a bit with those numbers, to find the distance you want to have. Don't change anything in the formulas in columns K to P.