Support Board
Date/Time: Tue, 21 Jan 2025 14:02:01 +0000
Post From: Questions on Spreadsheet_Studies
| [2018-08-04 13:49:07] |
| Sawtooth - Posts: 4157 |
|
Why is this happening?
I don't know.But the bar graph is still displayed so it shouldn't matter unless you need the historical values on the spreadsheet for other calculations. Here is a workaround to output all historical SMA values in a spreadsheet column: Put this in S3: =AVERAGE(OFFSET(Q3,0,0,1,1)) This is a formula to create a SMA on the spreadsheet, from examples here: https://www.sierrachart.com/index.php?page=doc/SpreadsheetExampleFormulasAndUsage.php#SimpleMovingAverag |