Support Board
Date/Time: Fri, 31 Oct 2025 08:07:02 +0000
Post From: Spreadsheet: Insert rows between row #2 and row #3
| [2019-10-13 00:13:39] |
| Sawtooth - Posts: 4281 |
|
The spreadsheet study array is in descending order, and your xlsx is in ascending order, so I'm not sure what the MA formula would be for times earlier than 13:30:00. You could use this formula, e.g. in P3, to offset the current price 8 bars, then retain that value forward to row 3: =IF(ROW()<11,P4,OFFSET(E3,-8,0)) This takes your column C and puts it in descending order. You might be able to modify the concept in this example to create the displaced MA: https://www.sawtoothtrade.com/free-stuff-18.html Remember, the spreadsheet study cannot display anything at future chart bars so the furthest forecasting could only be at the current bar. |