Login Page - Create Account

Support Board


Date/Time: Mon, 17 Mar 2025 18:25:47 +0000



[Programming Help] - How to draw Horizontal line based on value in study spreadsheet

View Count: 894

[2022-09-14 08:06:31]
User361939 - Posts: 167
Hi,
I have a value in spreadsheet and i want to draw horizontal line based on it. What study should i use to achieve this?

Best REgards
[2022-09-14 15:54:42]
Sawtooth - Posts: 4185
The spreadsheet study can draw a horizontal line if the value is in one of the Formula Columns K-Z...BR.
[2022-09-14 16:12:15]
User361939 - Posts: 167
Would you be kind and give some more detail? E.g Value for level is on K3, how can i automatically draw level? Color bar or color background studies works if condition is 1, here i have only Value.
What i am missing?
[2022-09-14 18:38:49]
Sawtooth - Posts: 4185
You'll need to make the value absolute by preceding the row with $ in the formula, like this:
=C$3
Then set the Draw Style to Line or Dash.

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

Login

Login Page - Create Account