Google docs Spreadsheet for Football/Soccer betting bankroll managment

  • Posted:
  • Proposals: 3
  • Remote
  • #1127359
  • Expired
Waqar Z.Karthik S.Christine M. have already sent a proposal.
  • 1

Description

Experience Level: Intermediate
Estimated project duration: less than 1 week
Industry: Sports and Fitness
Description of excel work: I need help building a Google Betting SpreadSheet.

The Sheet will contain 3 tabs.

1. Main Tab where you have an overview of you bank and where you enter your bets.
2. Data & Charts tab where you will se aggregated data and charts that visualize your performance.
3. Bank Management tab where you will have data about your bankroll.

The Idea is that when you begin using the spreadsheet you enter some initial data as starting bank, betting strategy and choice of Currency

Then, the only thing you have to do is to enter your bets and the rest will be calculated automatically.

Key calculations is:

- Bets are calculated as win/loss based on a drop down menu (win or loss)
- Win or loss streak
- Profit vs bets as a line diagram
- Bet amount is calculated based on your betting strategy (This is mainly three choices where you can choose between a percentage of you bank and whether it is recalculated on every bet based on win/loss or every month or never)
- Most/least profitable bet type (Single, combo, over under etc)
- Percentage of bank used in each bet
- Advices bet based on current bank
- Maximal affordable losses (calculation of how many lost bets one can do before bank is empty)
- Current bank health ( shows either color green, yellow or red based on calculation of available losses)
- Current winning or los streak
- Best winning streak
- Worst loss streak
- Losses have to be show in red fields and wins in green field automatically.
- Weekly wins or loss
- Monthly wins or loss

I have attached a SpreadSheet for you to take a look at. I have tried to explain and demonstrate in the spreadsheet, but we will have to communicate in order to reach an understanding of how I want things, and how you recommend doing things.
Extra notes:

New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.