Support Board
Date/Time: Thu, 16 Jan 2025 08:43:41 +0000
NORMSDIST() function
View Count: 1921
| [2017-10-18 06:26:39] |
| 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] |
| |
|
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. 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] |
| Sawtooth - Posts: 4153 |
|
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] |
| Sawtooth - Posts: 4153 |
|
Post #3 edited.
|
| [2017-10-19 01:13:00] |
| 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] |
| |
|
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] |
| |
|
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] |
| 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] |
| |
|
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] |
| 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: