Calculating Bets, Profit & Loss

**rbpd5015** · 01-12-2011, 08:52 PM

Guys I am working on a project and was looking for some help

below is some sample data I have

11/22/2010 L -9
11/20/2010 L -5.5
11/19/2010 L -11.5
11/17/2010 W -8.5
11/13/2010 L -15
11/11/2010 L -6.5
11/9/2010 L -9
11/6/2010 L -17
11/5/2010 L -6
11/2/2010 W -16.5
10/31/2010 W -9
10/29/2010 W -4
10/27/2010 W -8
10/26/2010 L -1

What I am trying to do is find a custom formula which will do the following

count how many time this team had back to back wins. However this can not include a game already counted. Then I am trying to give the second game of the 2 games a price in a neighboring cell. I think want every L on schedule giving a price in a neighboring cell. the idea is I will leave the formulas in the neighboring cells and just cut and paste from the web the data I got and read it.

below is by hand how I want the above data to look automatically upon pasting of the data

Date Result Bet Game Profit Profit
11/22/2010 L -9 1000 -1000 0
11/20/2010 L -5.5 1000 -1000 1000
11/19/2010 L -11.5 2000 -1000 2000
11/17/2010 W -8.5 1000 1000
11/13/2010 L -15 1000 -1000 3000
11/11/2010 L -6.5 1000 -1000 4000
11/9/2010 L -9 1000 -1000 5000
11/6/2010 L -17 1000 -1000 6000
11/5/2010 L -6 1000 -1000 7000
11/2/2010 W -16.5 2000 2000 8000
10/31/2010 W -9 1000 1000
10/29/2010 W -4 2000 2000 4000
10/27/2010 W -8 1000 1000 0
10/26/2010 L -1 1000 -1000 -1000

I will write the formula I think is sudo code

I will bet every game with the goal to win back to back games and start over

so I start by betting 1000 to win 1000 If I loose I reduce my bankroll by 1000 and start the next game betting 1000 again. If I win I got 2000 and bet the 2000 to win 2000 more.
if I win the game I got a total of 4000 and add that to the profit and start the next game at 1000 again.

This cycle goes on until the end. and hopefully my profit is + at the end.

Any help would be appreciated.

Matt

if I loose t

**rbpd5015** · 01-12-2011, 09:28 PM

Dave,

I have attached the workbook for you to look at the area in blue is the area I will be pasting in from a website for each time. Col G H I J are col I want filled automatically.

B1 is a variable that effects col B.

Please ask any questions

Matt

**rbpd5015** · 01-12-2011, 09:53 PM

Ok I redid the file with a little more detailed. I have made row J calculate on its own.

Now I just need to auto calc G H and I.

Please help someone!

thanks in advance

**rbpd5015** · 01-12-2011, 10:11 PM

I got 3 possibilities as I see it

E6 can be a W, L or P

If E6 is a W I need to know if I am goint to make my bet Col = D2 (1000) or D3 (1900)
to check what it should be I would do the following

if the game before was a L then it is allways = D2

if the game before was a W then it is D3 unless the bet of the game before was already D3 then it would return to D2.

hOW THE HECK DO I PUT THAT IN CODE

I AM SO STUMPED!

PLEASE HELP

Matt

**rbpd5015** · 01-13-2011, 12:05 AM

Can someone please look at my book. I could really use some help. If i could just make the formula the three columns it would save me days of hand entry.

Thanks so much

Matt

**DonkeyOte** · 01-13-2011, 05:07 AM

Perhaps:

Please Login or Register  to view this content.

I don't really follow the logic of Won & Profit as the results seem inconsistent to me:

Why when you bet $1000 and win is the Profit not $1900 given a $1900 bet won shows $3610 profit ?

Why when you bet $1900 and lose is the Profit not -$1900 given a $1000 bet lost shows -$1000 profit ?