Login Page - Create Account

Support Board


Date/Time: Sun, 29 May 2022 01:43:52 +0000



[User Discussion] - Round level indicator?

View Count: 1492

[2013-09-17 02:00:31]
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]
tomgilb - Posts: 3277
You can do it with the Spreadsheet Study study.
[2013-09-17 02:49:59]
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]
tomgilb - Posts: 3277
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]
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]
tomgilb - Posts: 3277
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]
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:

Login

Login Page - Create Account