Betting Tracker Excel Worksheet

Remove this Banner Ad

Log in to remove this ad.

The only problem would come with making a LAY bet on Betfair. Any way around this???

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.
 
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.


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 :)
 
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 :)

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.
 
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
 

(Log in to remove this ad.)

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

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.
 
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.

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
 
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

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
 
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
Yep, I thought about that today as well.

I will work out a way.

Cheers mate.
 

Remove this Banner Ad

Betting Tracker Excel Worksheet

Remove this Banner Ad

Back
Top