Support Board

Date/Time: Sat, 04 May 2024 09:29:10 +0000

Post From: Spreadsheet: Insert rows between row #2 and row #3

[2019-10-13 00:13:39] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3993
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.