Support Board

Date/Time: Fri, 19 Oct 2018 19:04:10 +0000

[User Discussion] - Modifying an equation

Support Request:
 [2013-03-22 01:01:49] #1 mogull - Posts: 40 I'm sure I will need to provide more information. But Tobi was good enough to generate some analysis files based on the watts trading method for me. I trade YM and one of the alert equations is =IF(AND(AC3>AG3,AK3<45,L4=0,AQ3<0,AV3>0),(D3-\$Q\$2),0) There are varios signal arrows, etc that have a distance added or subtracted based on that market. I was interested in using the alert (modifying and saving one) for things like the euro and yen, but I don't know how to change the end of the equation (\$Q\$2) to make it work on those markets. Cause I don't know what those variables are or mean. So let me know what I need to do or give you. Thanks Alan
 [2013-03-22 04:52:30] #2 tomgilb - Posts: 1974 My guess is that Q2 contains a value or a formula based on tick size, so that the arrow is n ticks less than the Low. (D3-\$Q\$2) The tick size is in cell J21, so I'd do something like this: (D3-\$J\$21*2) This will put the arrow 2 ticks under the low of the bar.
 [2013-03-22 09:36:21] #3 tobi - Posts: 315 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: "=J21*Q1" (without the quotation marks) In cell R2 type in: "=J21*R1" 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.
 [2013-03-22 21:58:25] #4 mogull - Posts: 40 Great answer. AS always the mechanics of this always gets me. What I do is select the "Wattsalert" study, which also brings up the spreadsheet. With inappropriate arrows. 1) I type/change these values physically in the cells that I want. How do I save the changes so they translate to the chart? (I will then call up the study and save it as that variation of the study for euro). 2) What value/number should I put in? Of course I could have tried what Tom said if I could have gotten part 1 of this message right. But once I do, if I want to do what tobi said, then what numerical values should I put in cell Q1 and R1 for the euro, which is "1.2876" for example? Thanks Alan
 [2013-03-23 09:06:19] #5 tobi - Posts: 315 Alan, a working version of Ryan Watt's setup, with appropriate arrows can be found here (post #42): http://www.sierrachart.com/supportboard/showthread.php?t=40305&highlight=907 In addition, there are a lot of information regarding the use of spreadsheets in that thread. As mentioned several times before, make sure you get familiar of how they work. All the information/answer to your initial question can be found in my prior post (#3). You do have to put a little work into this yourself. There is nothing else I can do for you on this topic. Regards, Tobi
 [2013-03-26 18:40:12] #6 mogull - Posts: 40 Perhaps you could tell me how to enter a value in a cell on the spreadsheet and have it stay there?