Login Page - Create Account

Support Board


Date/Time: Sat, 15 Mar 2025 23:43:58 +0000



Post From: Study that will draw horizontal lines?

[2022-07-28 16:06:00]
User621878 - Posts: 13
I appreciate your reply, it has made me take another look at how to use the Spreadsheet Study.

I am using regular price bars with a formula looking at the last 4 or more closed bars for a pattern. A True value will be a cell reference to the high, low or close of one of the closed bars. I was hoping to get a horizonal ray drawn from that point.

The good news is I did come up with a formula to lock the cell value to the first True value, which does generate an apparent line. The bad news is the formula locks the value to the first True value, which means I can only get one line which will be drawn from a formula, which be from the first True value. Edit: I did come up with a formula that will allow additional value lines to be drawn from same formula.

I did find a workaround by putting one formula (not the lock value one) in K3, then putting =K3 in the next 12 cells to the right, giving me 13 cells with the same value. All the cells have the same subgraph settings except for one, Displacement. I set the first cell, K3, to Displacement value 0, then each cell to the right I added an additional 2 to the Displacement value, giving me a dotted horizontal line to the right side. This is fine for now.

Again, thanks for your comments.
Date Time Of Last Edit: 2022-07-28 16:09:29