Support Board

Date/Time: Sat, 04 May 2024 03:26:18 +0000

Post From: NORMSDIST() function

[2017-10-19 01:13:00] Link To Thread - Link To Post [Go To First Post]
User799373 - Posts: 19
The only way to do this with the Spreadsheet System for Trading study is if additional Trading:...(P) studies were added, where the transient values in column J are 'remembered' and aligned with each bar's timestamp. Tomgilb, thank you. I use spreadsheet studies in a similar way to keep track of things which aren't permanently plotted on the chart. That function is not supported. The supported functions are here: Spreadsheet Functions Sierra engineering, thanks. I've got that page on my bookmarks :) What I would like to do is check the probability of the closing price being > X, or < Y, or between X and Y. Would ZTEST() help me achieve this? and if so would this be the correct way of using it? where the array would be say Q1:Q2(Q1 with value X, and Q2 with value Y), the mean would be the closing price, and the sigma being the number of standard deviations, say like 1. So it would look like this... =ZTEST(Q1:Q2, E3, 1) is this correct usage of the function?