Welcome guest, is this your first visit? Create Account now to join.
  • Login:

Welcome to the Australia Sports Betting Forum.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Betfair
Results 1 to 2 of 2
  1. #1
    New Member
    Join Date
    Jan 2015
    Posts
    1

    Some suggestions (thanks so much for spectacular excel)

    Hello, I am new to this forum. I wanted to congratulate the creator of this excel. It is absolutely spectacular. I don't want to think in time that has led him to have it finished. It's a great job. I had never seen anything similar. Anyway, I have some suggestions where I think that excel could be improved:

    - The main problem that I see is that only the amounts of money are computed. There should be a box with the unit stake. I.E. If your stake 1/10 unit represents 1% of your bankroll and bankroll is 20K then 1/10 is $100. This should serve to yield statistics would not be affected by the change in the bankroll of every person. A fixed yield per unit of stake is more real to me than a yield altered by variable stake. Example:

    Tipster X: 400 bets 7% yield in 2014

    First 6 months with high-yield but low bankroll. Last 6 months with yield low but high bankroll. Then that 7% would be affected drastically, when the reality is that the tipster has been profitable in 2014.

    This could be solved by adding a box "Unit Stake" in "Bets" sheet and compute this box for the calculation of yield in the sheet "Tipper Analysis". In this case you might see performance stake fixed as well as variable stake. But I don't know how to make this change without affecting the rest of formulas.

    - "Performance Summary" sheet there are many options available to analyze but for me one of the most important would be the "Performance by odd". You can divide this in x ranges and add. To have the odd box obviously available in sheet "Bets" believe that it would not be a great job adding this tool. Also "Performance by stake", although currently not having fixed stake unit would also rather confusing.


    Then there are other suggestions although less important, but if you consider them interesting facing a new update:

    - In configuration, you could add a table that included purses MB or Neteller or can also include your own Bank, to be able to control your total money.

    - On the sheet of "Deposits"/Method, adding MB or Neteller you could calculate automatically the withdrawal of money in Available Funds, where you could add both MB and Neteller. Currently such operations can be made by adding MB or Neteller as bookies and repeating each Bookie-MB/Neteller transaction in reverse.

    - Increasingly the tipsters premium, I think that would be interesting to include a table with the monthly payments to tipsters premium in sheet "Deposits".

    - Conditional formatting with green for successful betting and boxes which represent a profit.


    PS: Sorry for my english and my total extension of post, only want help with these suggestions.

    Thanks in advance
    Last edited by mt20; 2nd January 2015 at 08:05 AM.

  2. #2
    Moderator
    Join Date
    Aug 2011
    Posts
    989
    Hi mt20, thank you for the great feedback! I will review your suggestions when work begins on the next version.

 

 

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •