Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 18 May 2024 06:01:40 +0000
Post From: Flat to Flat Average price with Scale out Profits factored in it
| [2017-03-14 00:55:28] |
| Sawtooth - Posts: 4000 |
|
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. |