Build me a probability excel sheet
Budget: $30 – $250 USD
I teach people how to trade financial markets. I have 2 other excel sheet I have made myself already. I need one with probabilities where the odds of having multiple loss/win streaks is calculated. I would like the outputs to be in %. I would like the color of the block that has a high or low % to change color based on its %. White, Green, Blue, Yellow, Orange, Red, Black are the colors id like used. They will correspond with >99%,>90%,>66%>33%,<33%,<10%<1% respectively.
The user will input the win % and sample size, and this will fill a column of data on how likely a loss streak will be.
The row will have different loss streak loss sum in the rows. I want the color of the % to change automatically.
I need this as a visual tool to teach people how likely something is to happen. the user would input the sample size of trades, and % of trades won. The excel sheet would come out with probabilities of loss streaks.
I have a snapshot of someone else who has done this, however I want my own custom version.
I would like the math on how someone would come up with the same thing outside of excel as well. I want this because I have a website and at some point I will develop a tools section to integrate into the website; For now excel sheets will suffice.
The user will input the win % and sample size, and this will fill a column of data on how likely a loss streak will be.
The row will have different loss streak loss sum in the rows. I want the color of the % to change automatically.
I need this as a visual tool to teach people how likely something is to happen. the user would input the sample size of trades, and % of trades won. The excel sheet would come out with probabilities of loss streaks.
I have a snapshot of someone else who has done this, however I want my own custom version.
I would like the math on how someone would come up with the same thing outside of excel as well. I want this because I have a website and at some point I will develop a tools section to integrate into the website; For now excel sheets will suffice.