# 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] #1 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 tomgilb - Posts: 3277 You can do it with the Spreadsheet Study study.
 [2013-09-17 02:49:59] #3 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 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] #5 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 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] #7 AndyL - Posts: 119 tom: thanks very much, i think i understand how this works now.