Support Board
Date/Time: Fri, 20 Jun 2025 14:11:09 +0000
Post From: Probability and statistics with spreadsheet
| [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 |