Home >> Support Board

Support Board

Date/Time: Fri, 03 May 2024 16:40:12 +0000

How to Post a Message for Support

NORMSDIST() function

View Count: 1714

[2017-10-18 06:26:39] #1 [Go To First Post]
User799373 - Posts: 19
Is there an equivalent spreadsheet function or set of functions to NORMSDIST()?? Also is there any way to keep a record of any of the J cells, for example J10(could be any cell), and have it display it's state from bar to bar or cell to cell rather, on column "O" for example. thanks!

[2017-10-18 17:57:21] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
That function is not supported. The supported functions are here: Spreadsheet Functions Also is there any way to keep a record of any of the J cells, for example J10(could be any cell), and have it display it's state from bar to bar or cell to cell rather, on column "O" for example. Inherently this is difficult to do with Spreadsheets. We do not know how. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, change to the Teton service: Sierra Chart Teton Futures Order Routing

[2017-10-18 18:53:58] #3 [Go To First Post]
Sawtooth - Posts: 3992
Inherently this is difficult to do with Spreadsheets. We do not know how. 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. Currently, only these studies do this: Trading: Closed Profit/Loss, J11 (Cumulative Closed Profit/Loss) Trading: Daily Profit/Loss, J45 (Closed Daily Profit/Loss) Trading: Total Quantity Filled, J53 (Daily Total Quantity Filled) Trading: Total Trades, J35 (Total Trades) Trading: Total Losing Trades, J34 (Lose Trades) Trading: Total Winning Trades, J33 (Win Trades) Trading: Position, J5/J8 (Position Quantity) It would also be nice if the study names were consistent with the column I titles. Date Time Of Last Edit: 2017-10-18 20:27:27

[2017-10-18 20:28:35] #4 [Go To First Post]
Sawtooth - Posts: 3992
Post #3 edited.

[2017-10-19 01:13:00] #5 [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?

[2017-10-19 04:38:36] #6 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
Yes that is true in post #3. We had thought of mentioning those particular studies but those are not really the answer in all cases. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, change to the Teton service: Sierra Chart Teton Futures Order Routing

[2017-10-19 18:39:50] #7 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
In response to post #5 we are going to write a more detailed description for the ZTEST function. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, change to the Teton service: Sierra Chart Teton Futures Order Routing

[2017-10-19 22:01:03] #8 [Go To First Post]
User799373 - Posts: 19
Thank you Sierra! Quick question.... Is it possible to have different(and static also? Like the J column) formulas in the cells of a column? Like Cell X1=(formula A), Cell X2=(formula B), and so forth

[2017-10-20 01:56:36] #9 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
Yes. Just do not use one of the Formula Columns (By default K through Z) on the Spreadsheet Sheet. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, change to the Teton service: Sierra Chart Teton Futures Order Routing

[2017-10-21 01:37:34] #10 [Go To First Post]
User799373 - Posts: 19
Yes. Just do not use one of the Formula Columns (By default K through Z) on the Spreadsheet Sheet Ok that's straight forward enough :) By the way I just discovered that the STANDARDIZE() function in Sierra does the same as NORMSDIST(). In case is worth including a note on the function description.

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