Forum Discussion
zoeskee
Sep 25, 2021Copper Contributor
Need Help Formulating a Win Percentage (Excel)
Hi, I'm trying to figure a the formula to calculate my win percentage in Excel. Do I need to add an extra cell? Thanks in advance.
- Sep 25, 2021
Your Exit/
=(Exit-Entry)/Entry
Then format it to show in percentage values (%)
By the way, you dont need to include # of shares in your calculation for this.
Juliano-Petrukio
Sep 25, 2021Bronze Contributor
Your Exit/
=(Exit-Entry)/Entry
Then format it to show in percentage values (%)
By the way, you dont need to include # of shares in your calculation for this.
zoeskee
Sep 25, 2021Copper Contributor
Thank you so much! It worked! Juliano-Petrukio
- Juliano-PetrukioSep 25, 2021Bronze Contributor
You're welcome, I'm happy knowing it worked for you.
Don't forget please to flag it as solved and hit the "like" button.