I'm going to take my "Sport betting fund" online (using Excel to keep records today), i.e. show my open bets, betting history, statistics etc. on a web page. Below I post details about what I am looking for.
I need you to have some design skills since I want the information (see "Front-end" below) to be presented in a good looking way (designed boxes or something). Perhaps I also need help integrating the "Front-end part" into a sub page of my WordPress blog.
I hope you follow what I mean. Please let me know if you have any questions!
BACK-END (ADMIN PAGE)
Add Funds at start
Add bet type
ID-Date-Event-Game/Games* -Bookie**-Bet type**-Picks-Stake-Odds-Commission***-Won/Lost/Cancelled****
* Should be possible to add several rows/games in the same bet/ID.
** Choose from drop down menu (added in “Settings”)
*** % of the profit (odds x stake – stake) that goes to bookie. Should be reduced from the profit of the bet (if bet won).
****Radio buttons to correct the bet.
FRONT-END (PRESENTATION ON WEB PAGE)
- Box 1
Start date: [= when first bet is made]
Fund at start:
Current fund: [=Fund at start + Bonuses - Total Stake + Total Winnings]
...of which in play: [= money in open bets]
Result (+/-): [= Currents fund - Funds at start]
Result (%): [= Fund at start / Current fund]
- Box 2
Number of bets:
Bets in play:
Won bets %: [= Won bets / Lost bets]
Average odds won bets:
Average odds lost bets:
- Box 3
Result (+/-): (= Total Winnings - Total Stake]
ROI %: [= Total Winnings / Total Stakes]
- Box 4
Betting history [Sorted per month, i.e. show one page/tabel for each month]:
Date-Event-Games/Games-Bookie-Bet type-Picks-Stake-Odds-Possible profit-Won/Lost.