Support Board
Date/Time: Sun, 24 Nov 2024 05:29:08 +0000
[User Discussion] - Round level indicator?
View Count: 2359
| [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] |
| Sawtooth - Posts: 4118 |
|
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] |
| Sawtooth - Posts: 4118 |
|
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] |
| Sawtooth - Posts: 4118 |
|
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: