Need help managing bets

**ipickwinners** · 10-26-09, 12:41 AM

#1. who the fck pays juice when u win??????
#2. if you cannot keep track of 20-25 bets in a week, u are pretty slow. my one local has about 55 players and said he handles upwards of 2,000 bets in a week while NFL and NBA is going on and has two guys take calls
#3. write down the bets on paper

**ipickwinners** · 10-26-09, 01:00 AM

well....??

**20Four7** · 10-26-09, 01:42 AM

writing it down is too easy....... But who the hell is losing 105 to win 90. I want them as my customer. At first read I thought you were juicing them 10% and paying out 5%

**kp126** · 10-26-09, 01:43 AM

Good Points but,

I write it down on paper now but what happens when i get more people and more bets(i know 20 today is a small amount but im just starting and because I wasnt prepared I almost F'ed up) I still want to save it on my computer so i can go back and see how I am doing and what others are doing(would use mysbr but dont have internet access all the time)... really just looking for a nice excel sheet or something(i know i can make it myself but wanted ideas of how others did it)...

oh and i dont think i will ever be handling 55 people and 2,000 bets ... thinking more of the 50-100 a day and no more than 15 bettors

**n1co35** · 10-26-09, 02:05 AM

Originally posted by kp126

Ok so this season my local bookie changed his payout structure. He pays me 1 to 1 on all bets. If i lose i have to pay 105 for every 100 i lost(I know makes no sense to me).

This structure rewards you for winning because you get even payouts. Some people I know have recently started to ask me to call in bets for them. I decided that I can charge 10% on wins and still collect 105 on losses(I risk nothing outside of non payment). So this week I called in over 5000 in winning bets which means I collected 500 by doing maybe 1 hour of work.

I am handling bets for 4 bettors(all co workers). I need to figure out how to manage bets because this week I almost lost track of all the wagers(roughly 20-25) that were placed. I thought about getting a windows phone and using excel but I need a good template.

Any ideas? also was thinking there must be some simple software out there. anyone know anything that might help me manage wagers and keep track of who owes what and who I need to payout?

was not sure if this is the forum to post in but if it isn't then point me in the correct direction.

any help is appreciated

EDIT: forgot to mention that I work on Saturdays and Sundays (at a big warehouse chain, and those are the two busiest days for betting and shopping coincidentally) and need to figure out a system I can use on the go and then at the end of the day I can archive it on my comp

hey i dunno if this excel sheet will help. but i used to do this to for a local bookie.
and i used the this excel spread it's pretty simple but it helped me manage it.

Attached Files

football spreadsheet.xls (23.5 KB, 282 views)

**kp126** · 10-26-09, 02:26 AM

Originally posted by n1co35

hey i dunno if this excel sheet will help. but i used to do this to for a local bookie.
and i used the this excel spread it's pretty simple but it helped me manage it.

not bad...

playing around in excel right now... setting up a tab for each person and each tab will be sectioned by week... each week will have a running total row for +/- and the usuals like spread, amount, result(W/L) , balance(-/+), commission collected and at the bottom I can have season totals

pretty basic but once i get a windows phone this will travel with me anywhere.

seems like the easiest answer for small operations

ill post it up once im done so if anyone has suggestions or might want to use it can get it.

thanks for the help

**n1co35** · 10-26-09, 02:45 AM

i see, GL with ur excel hope u find a way to be able to manage ur bets

the spreadsheet here on sbr. is pretty good, if i only knew how to get that in excel it would be great.

**kp126** · 10-26-09, 03:25 AM

ok so here is something simple i set up... of course im going to mess around with formatting a little bit so the table is more flexible

made with office 2007 so might not be compatible with older versions

Attached Files

FootballSpreadsheet.zip (17.2 KB, 173 views)

**shantystar** · 10-26-09, 03:40 AM

hummmmm

**TGHMak** · 10-26-09, 03:44 AM

Originally posted by kp126

EDIT: forgot to mention that I work on Saturdays and Sundays (at a big warehouse chain, and those are the two busiest days for betting and shopping coincidentally) and need to figure out a system I can use on the go and then at the end of the day I can archive it on my comp

Mobile excel is really incumbent in most situation, I think you would be better off using something like evernote to take down people's wagers and then just copy it into your excel template when you get home.

**kp126** · 10-26-09, 02:26 PM

Originally posted by TGHMak

Mobile excel is really incumbent in most situation, I think you would be better off using something like evernote to take down people's wagers and then just copy it into your excel template when you get home.

I like your idea of evernote beceause its compatible over many different Operating systems... currently using an iPhone but if i can sync my notes from phone to computer(windows) than I wouldnt have to chagne phones.

thanks for the idea

**durito** · 10-26-09, 02:37 PM

Originally posted by ipickwinners

#1. who the fck pays juice when u win??????
#2. if you cannot keep track of 20-25 bets in a week, u are pretty slow. my one local has about 55 players and said he handles upwards of 2,000 bets in a week while NFL and NBA is going on and has two guys take calls
#3. write down the bets on paper

you pay juice on every bet win or lose

**ipickwinners** · 10-26-09, 09:28 PM

Originally posted by durito

you pay juice on every bet win or lose

sooo....if u win a $110 bet to win $100......the bookie gives u $100 and then u give him $10?? no, if u win u do not pay juice....wow, ppl are stupid

**20Four7** · 10-26-09, 11:43 PM

durito is correct, despite the conventional wisdom that only losers pay juice.

**ipickwinners** · 10-27-09, 12:15 AM

Originally posted by 20Four7

durito is correct, despite the conventional wisdom that only losers pay juice.

please explain how he is right

**kp126** · 10-27-09, 12:29 AM

Originally posted by ipickwinners

please explain how he is right

correct me if im wrong but,
seems like if you are using your example, you bet 110 and only got paid 100. what happened to the extra 10 that you wagered? juice.

**ipickwinners** · 10-27-09, 12:31 AM

Originally posted by kp126

correct me if im wrong but,
seems like if you are using your example, you bet 110 and only got paid 100. what happened to the extra 10 that you wagered? juice.

the $10 was never paid because u won

**kp126** · 10-27-09, 12:39 AM

but it was placed. You wagered 110 not 100. in my situation if i place 110 i win 110 not 100. big difference because if i hit 51% i end up profitable but in your situation 51% is not profitable. I understand your reasoning that you are not "paying" when u win but think of it like this, you wagered 110 but they keep 10 when u win.

**Hybris** · 10-27-09, 08:22 AM

Originally posted by ipickwinners

please explain how he is right

no need, he just is.

**u21c3f6** · 10-27-09, 10:27 AM

Originally posted by kp126

but it was placed. You wagered 110 not 100. in my situation if i place 110 i win 110 not 100. big difference because if i hit 51% i end up profitable but in your situation 51% is not profitable. I understand your reasoning that you are not "paying" when u win but think of it like this, you wagered 110 but they keep 10 when u win.

If I understood your arrangement correctly, you lose 105 to win 100. So you are not really laying 110 to win 110 because if you lose you have to pay 110*1.05 = 115.50 which would not be profitable at 51%. Is this correct?

As to the rest, I would love to find individuals that are willing to lay 105 to win 90.

Joe.

**kp126** · 10-27-09, 01:59 PM

Your right my math was off a little but at 52% I am profitable... where in most cases 52% would not be profitable.

and if i lay down halftime bets for my "clients"... wagers are 110 to win 80 (again i get paid 100 by my local bookie)

**Nolimit1163** · 10-27-09, 08:07 PM

Actually i know about 10 people who are willing to take 80 bucks for every 100 they risk.Trust me there are people out there willing to risk a shitload of money to win jackshit. Goodluck KP. hope you keeping jacking those fools. Good luck to everyone this year. Cheers

**kp126** · 10-28-09, 04:15 PM

Originally posted by Nolimit1163

Actually i know about 10 people who are willing to take 80 bucks for every 100 they risk.Trust me there are people out there willing to risk a shitload of money to win jackshit. Goodluck KP. hope you keeping jacking those fools. Good luck to everyone this year. Cheers

Jacking from them would be taking without consent. I, my friend, make sure they know what they are risking and what they stand to gain. It is all fair as long as they agree.

**OSUCOWBOYS** · 10-28-09, 05:38 PM

The market must have dead money to survive. Your "clients" are prime examples of why sports will always be beatable.