Support Board
Date/Time: Sun, 02 Feb 2025 21:47:49 +0000
[Programming Help] - Spreadsheet: Insert rows between row #2 and row #3
View Count: 945
| [2019-10-12 08:08:15] |
| caligola - Posts: 116 |
|
Good morning, is there a way to insert blank rows between row #2 and row #3 in the spreadsheet? I need to insert formulas beyond the current bar which is always located in row #3 something like that (from 1 to 2) https://i.imgur.com/Tb5xtfb.png ; in this example I would put my formulas between row #3 a #8 but the spreadsheet does not allow me to do this, every time that I insert rows here it keeps filling them with data. Thank You |
| [2019-10-12 13:22:35] |
| Sawtooth - Posts: 4164 |
|
is there a way to insert blank rows between row #2 and row #3 in the spreadsheet?
No. Each row is a chart bar, with the current bar in row 3 and earlier bars in rows below. There are no rows for bars in the future.Depending on what you are doing, it's possible to reference row 2 in formulas to get 1 bar in the 'future', but it can't be displayed, and it usually requires a reference to ROW()=3 to trap errors. If I understood why you need to insert formulas between rows that always correspond to chart bars, I might be able to offer a way to accomplish what you want. |
| [2019-10-12 15:26:29] |
| caligola - Posts: 116 |
|
why you need to insert formulas between rows that always correspond to chart bars, I might be able to offer a way to accomplish what you want.
I need to build a displaced moving averageplease find the excel attached to this post and take a look; think that I need to use some very big averages as 2400, where half of this must be in the future it's not the same as a normal forward displacement , there is a very basic forecasting involved what I need to plot is in column D Thank You Date Time Of Last Edit: 2019-10-24 18:52:10
|
Private File |
| [2019-10-13 00:13:39] |
| Sawtooth - Posts: 4164 |
|
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. |
| [2019-10-14 14:58:48] |
| caligola - Posts: 116 |
|
Tested with realtime sierra spreadsheet, it's working well done ! not an easy job, to me https://i.imgur.com/oiiGqbt.png all the formulas are in Column T of the attached .xlsx Date Time Of Last Edit: 2019-10-24 18:52:29
|
Private File |
To post a message in this thread, you need to log in with your Sierra Chart account: