Support Board
Date/Time: Fri, 20 Jun 2025 08:22:40 +0000
Probability and statistics with spreadsheet
View Count: 445
| [2022-06-06 16:47:07] |
| Hopeman - Posts: 166 |
|
Hello, I am trying to make a statistical percentage formula which indicates how many times the price has broken the overnight high in session and indicates it in percentage. I am trying it with several simple formulas, but the spreadsheet returns an error. where C3 is the high d is the Low price and AA is the overnight high I wonder if it is possible to do this using the spreadshett and draw a line on the graph marking the probability percentage. =PROB(C3:C51,DE3:D51,AA3) Thank you for your attention |
| [2022-06-06 17:34:50] |
| John - SC Support - Posts: 40526 |
|
The one thing we see is that you have an extra 'E' in your formula after the first D - it shows as "DE3". Remove that E and see if you get what you want.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: