Support Board

Date/Time: Wed, 15 May 2024 15:04:14 +0000

Post From: Is there a ID # for Open, High, Low, Close?

[2020-01-06 05:44:17] Link To Thread - Link To Post [Go To First Post]
sourdubber - Posts: 52
Is there a way to use Open, High, Low, Close in the Spreadsheet Formula? Here's the formula I want to create: i = MovingAverage(Close + StdDev, length); where StdDev is the standard deviation. There is a study for standard deviation, so I can get the ID for that but I don't know how I could combine it with "Close". When I used "Close + ID3.SG1" or "E3 + ID3.SG1" (spreadsheet cell) as the input, it did not work. Please advise.