Remove this Banner Ad

Betting Tracker Excel Worksheet

  • Thread starter Thread starter stuziman
  • Start date Start date
  • Tagged users Tagged users None

🥰 Love BigFooty? Join now for free.

I seriously recommend downloading this it's free

For the record I have no link to the website either
 

Log in to remove this Banner Ad

GoodesStuff said:
The only problem would come with making a LAY bet on Betfair. Any way around this???
Click to expand...

Just reverse the bet - for example if you lay a team @ $1.50 you are actually backing the other team at $3.00.

Your formula to get the BET odds is:

100/(100-(100/LAY ODDS))

Great spreadsheet by the way. Shites all over the one I've got.
 
Daytripper said:
Just reverse the bet - for example if you lay a team @ $1.50 you are actually backing the other team at $3.00.

Your formula to get the BET odds is:

100/(100-(100/LAY ODDS))

Great spreadsheet by the way. Shites all over the one I've got.
Click to expand...


Yeh I thought you would do it someway like that but didnt know if you had to have it 100/? because the markets arent set to 100%

Cheers :)
 
I can't believe that I found this after contemplating making something similar
 
GoodesStuff said:
Yeh I thought you would do it someway like that but didnt know if you had to have it 100/? because the markets arent set to 100%

Cheers :)
Click to expand...

What the market is set to doesn't matter for these purposes.

What is relevant is the commission but you probably don't want to over complicate things too much.

If you really need a formula for that, let me know.
 
Daytripper said:
What the market is set to doesn't matter for these purposes.

What is relevant is the commission but you probably don't want to over complicate things too much.

If you really need a formula for that, let me know.
Click to expand...

Yeah I think I would probably use the odds less comission to not over complicate things.
 
perfect. now i can seperate my melb,syd,bris quaddies and find out which are more profitable. if i wasn't lazy i could even add groups for days but ill take a pass on that.

cheers for link
 

Remove this Banner Ad

And then move up to Access for pure customisable querying joy. :)
 
stuziman said:
http://www.aussportsbetting.com/tools/betting-tracker-excel-worksheet/

i was looking for something similar and hit the jackpot

everyone punting big time should take a look at this
Click to expand...

is anyone else having troubles with this? i got it myself because thought it would be helpful and liked the look of it when i got it but after typing in all the info needed before starting like agencies i use and sports i bet on i find i have troubles when trying to put my bets in. When i click the drop down menu there are no options there or it just doesnt come up. Is anyone else having problems with it? i am only using excel 2003 could that be a problem? any help much appreciated. thanks.
 
had the same issue Doctor, I just went and downloaded an older version and worked just fine albeit it does not have some of the new features.

Would also be nice to know the password to unprotect the sheet so that people can tinker with it themselves.
 

🥰 Love BigFooty? Join now for free.

cammiss05 said:
had the same issue Doctor, I just went and downloaded an older version and worked just fine albeit it does not have some of the new features.

Would also be nice to know the password to unprotect the sheet so that people can tinker with it themselves.
Click to expand...

thanks mate ill try that myself. The password isnt 'sport' like the new one is it?
 
What is a good way to enter in quaddies tho?

Hard to fill in the odds bracket.

Just started entering today's bets, decided to make a separate *sport* for Quaddies and just put $1 at odds of $1024 but not sure what odds I will put for losses etc.?

Messes up the *average odds* bit, not that I am all that fussed about this
 
Rough_Edges said:
What is a good way to enter in quaddies tho?

Hard to fill in the odds bracket.

Just started entering today's bets, decided to make a separate *sport* for Quaddies and just put $1 at odds of $1024 but not sure what odds I will put for losses etc.?

Messes up the *average odds* bit, not that I am all that fussed about this
Click to expand...

if you check the approximates before the last race could you divide that by how much you put it on for? ie quaddie approx is 2400 and it cost you 48 to put on then your odds are 50-1 then if you only took it for a 50c unit your odds would be 25-1. Not sure if thats of any help lol
 
The_Doctor said:
if you check the approximates before the last race could you divide that by how much you put it on for? ie quaddie approx is 2400 and it cost you 48 to put on then your odds are 50-1 then if you only took it for a 50c unit your odds would be 25-1. Not sure if thats of any help lol
Click to expand...
Yep, I thought about that today as well.

I will work out a way.

Cheers mate.
 
Rough_Edges said:
Yep, I thought about that today as well.

I will work out a way.

Cheers mate.
Click to expand...

If your super keen, you can approximate your odds of losing quaddies by working out what % of the book your selections represent for each leg, then invert and multiply them together.
 

Remove this Banner Ad

Similar threads

NotAMagpieBogan
  • Sticky
2025 triple j Hottest 100 Betting Thread
Replies
3
Views
539
grayson0808
G

Remove this Banner Ad

🥰 Love BigFooty? Join now for free.

Back
Top