Support Board

Date/Time: Fri, 10 May 2024 20:28:58 +0000

Post From: Questions on Spreadsheet_Studies

[2018-08-04 13:49:07] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3995
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