can someone make an excel spreadsheet for martingale ?

[TheKid]

so . there is this video tutorial for a website that no longer exists
https://www.youtube.com/watch?v=F7Qd6D-b92s&t=18s

my question is , can someone replicate that site's sistem in excel .
It doenst seem preety hard , even if I might not now what am talking about .
I dont really work in excel .

thanks !

 

[TheKid]

I am sorry guys . but can you tell me if you can help me with the excel sheet ?
and thanks for your concern about me losing money , but I know how to stop greed making me lose a lot of money .

 

[oldbrewer]

there are many forms of martingale

are you going double stake until a win bases on say roulette red/black

or on roulette column ie odds 3 to 1

tell us how you want the sequence and I will try and make you a spreadsheet

 

[MARK858]

I am afraid it is a lot more complicated than you think .

I don't think I elaborated enough in the above..
What you have in the video is a user form with probably at least 8 lengthy bits of code behind it.
Basically it is a design project and not the type of task you would expect someone to undertake on a question/help forum but you never know someone might be willing to do some free design work

Best if luck (in all ways)

 

[TheKid]

I am not going double stake untill I win . the odds are higher than 2 . they are between 4 and 6 . they are odds from tenis game correct score .
and I want a fix profit . so I start at a fixed profit of 5 euros lets say . and the first odd is 4,3 .
I have to place a bet of 1.16 euros . and that bet is lost . ok I move on to the nest game in that match
now I have to win the profit which is 5 and my first bet of 1.16 . so on my 2nd bet , my profit should be 6.16.
basicaly I want an excel file in which I can place my profit and the odds an calculate for me the stakes I have to palce . progresively .
I hope you understand !

 

[oldbrewer]

5	profit target			bet number	ODDS	running loss	TARGET PROFIT	stake	OUTCOME	WIN	LOSS	RUNNING LOSS
					1	4.3	0.00	5.00	1.16	W	5.00	0.00	0.00
					2	5.1	0.00	5.00	0.98	L	0.00	0.98	0.98
					3	4.7	0.98	5.98	1.27	L	0.00	1.27	2.25
					4	5.5	2.25	7.25	1.32	W	5.00	0.00	0.00
					5	4.2	0.00	5.00	1.19	W	5.00	0.00	0.00
					the above table takes into account running losses when calculating stake
					formulas can be in place but only become active when the odds column is filled
					if this is near what you want, I will post formulas

<colgroup><col span="5"><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>

 

[TheKid]

bet number	ODDS		TARGET PROFIT	stake	OUTCOME	WIN	LOSS
1	4.3		$5	$1.16	L	0	$1.16
2	3.6		$6.16	$1.71	L	0	$2.87
3	5		$7.87	$1.57	L	0	$4.44
4	5.2		$9.44	$1.81	L	0	$6.25
5	4.7		$11.25	$2.39	L	0	$8.64

<tbody>
</tbody>

6 3.6 $13.64 $3.78 W $13.6


ok . this is exactly what I want . I want this on excel to calculate me , based on odds , (odds will be filled in by me one by one ) the stake to place on the next odd in order to win the initial fixed profit and the ammount of money I bet until then . this is as clear as I can make it .
hope you understand . thanks !

 

[TheKid]

apparently the sixth row didnt fit .that is suposingly the winning correct score . I hope you can understand .

 

[oldbrewer]

5	profit target			bet number	ODDS	running loss	TARGET PROFIT	stake	OUTCOME	WIN	LOSS	RUNNING LOSS
					1	4.3	0.00	5.00	1.16	W	5.00	0.00	0.00
					2	5.1	0.00	5.00	0.98	L	0.00	0.98	0.98
					3	4.7	0.98	5.98	1.27	L	0.00	1.27	2.25
					4	5.5	2.25	7.25	1.32	W	5.00	0.00	0.00
					5	4.2	0.00	5.00	1.19	W	5.00	0.00	0.00
					the above table takes into account running losses when calculating stake
					formulas can be in place but only become active when the odds column is filled
					if this is near what you want, I will post formulas
					bet number column is col F
					running loss is column N
					headers are on row 1
					the row for bet number 1 is manual
					so formulas are for row 3
					G3	you type in the odds
					H3	=IF(G3="","",N2)
					I3	=IF(G3="","",5+H3)
					J3	=IF(G3="","",I3/G3)
					K3	you type in W or L
					L3	=IF(G3="","",IF(K3="W",5,0))
					M3	=IF(G3="","",IF(K3="L",J3,0))
					N3	=IF(G3="","",IF(M3<>0,M3+N2,0))
					all are dragged down say 100 rows
					they only come live when you enter new odds in col G
					you win 5 euros each winning bet
					easy to add a column that records cumulative win

<colgroup><col span="5"><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>

 

[TheKid]

sorry . how do I do this

					all are dragged down say 100 rows

<tbody>
</tbody>

and thanks

 

[TheKid]

nevermid my stupid question . thanks for all mate . I apreciate !