Login Page - Create Account

Support Board


Date/Time: Mon, 25 Nov 2024 13:27:22 +0000



[User Discussion] - Spreadsheet help

View Count: 261

[2024-02-24 20:40:54]
User411320 - Posts: 289
Hello,

I'm trying to create the z-score price - MA but I'm getting a flat line. attached are photos , please let me know what I'm doing wrong. thanks
Date Time Of Last Edit: 2024-02-24 20:42:17
imageScreenshot 2024-02-24 152523.png / V - Attached On 2024-02-24 20:42:04 UTC - Size: 6.64 KB - 52 views
imageScreenshot 2024-02-24 152642.png / V - Attached On 2024-02-24 20:42:12 UTC - Size: 30.22 KB - 50 views
[2024-02-24 22:37:14]
ForgivingComputers.com - Posts: 960
The first place to look is the formulas in columns K and above.
[2024-02-24 23:07:39]
User411320 - Posts: 289
Hello Brad,

for column L (Last - MA)
for column M STDEV.P(L3:L3002)
for column N (L3/M3)
[2024-02-29 21:20:37]
User411320 - Posts: 289
anyone?
[2024-03-01 00:58:51]
Sawtooth - Posts: 4120
If column N is the desired result, set the other columns/subgraphs to Ignore.
[2024-03-01 17:41:39]
User411320 - Posts: 289
Hello Sawtooth, that worked! thank you.... at least now I know my math is wrong now

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account