Support Board
Date/Time: Sat, 18 Jan 2025 22:51:44 +0000
Post From: Flat to Flat Average price with Scale out Profits factored in it
| [2017-03-14 00:55:28] |
| Sawtooth - Posts: 4154 |
|
The reference to P4 in P3 is what brings the value to the current row. In Formula Columns, spreadsheet studies will autofill rows below row 3, incrementing the row reference to P4, and P3. Try this example making the bar high price persistent from row 7: in Z3: =IF(ROW()=7,C3,Z4) Now look at the formulas in Z4, Z5, Z6, Z7. |