Home >> Support Board

Support Board

Date/Time: Fri, 26 Apr 2024 04:18:44 +0000

How to Post a Message for Support

[User Discussion] - Round level indicator?

View Count: 2204

[2013-09-17 02:00:31] #1 [Go To First Post]
AndyL - Posts: 119
I would like to draw a line (preferably a short line at the right edge of the chart) at every 50 and 100 point round-number level. Is there a ready made indictor available for this, or would i have to program this myself? Regards, Andy

[2013-09-17 02:02:59] #2 [Go To First Post]
Sawtooth - Posts: 3976
You can do it with the Spreadsheet Study study.

[2013-09-17 02:49:59] #3 [Go To First Post]
AndyL - Posts: 119
tom: could you tell me how to do that? I am not really proficient with the sheets. I would only need to draw 2 levels - the next round level up and the next down from current price (at either a 50 or 100 point level). Regards, Andy

[2013-09-17 04:09:21] #4 [Go To First Post]
Sawtooth - Posts: 3976
Andy, What symbol? Please give me an example. And how many bar back do you want the line? Date Time Of Last Edit: 2013-09-17 04:11:19

[2013-09-17 04:14:21] #5 [Go To First Post]
AndyL - Posts: 119
tom: for example, EUR/USD: say price is at 1.3425, i want to draw a line at 1.3400 and 1.3450. Actually, forex data is one more digit - but i have rounded it to 4 using the "Round price bars to ticksize" study. I dont know if that makes a difference. Regards, Andy

[2013-09-17 04:24:00] #6 [Go To First Post]
Sawtooth - Posts: 3976
Andy, Add the Spreadsheet Study study, give it a name in the Spreadsheet Name field, set the Chart Region to 1, and set the Number of Rows to 10. Put this in K3: =IF($O$3>$E$3,$O$3,$L$3+0.005) Put this in L3: =IF($O$3<$E$3,$O$3,$K$3-0.005) Put this in O3: =MROUND($E$3,0.005) -Tom Date Time Of Last Edit: 2013-09-17 05:32:38

[2013-09-18 00:15:52] #7 [Go To First Post]
AndyL - Posts: 119
tom: thanks very much, i think i understand how this works now.

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