excel dutching calculator

[Norwegian Would]

SORRY peeps I had my head so far up my bum that I forgot mention an excel solution ( I use Excel 2007).

[Fixador]

Fancy putting a screenshot of Betangel on this forum - 10 de-merits Van Helsing !

Ask Tsiri ! Or wait for Tsiri

I am on long holiday - as worn out.

cheers mate

[Norwegian Would]

SMITED - Ouch mate.

I am still looking at how to emulate the idea from BetANGLE in excel. I think the basic idea is here somewhere.....



http://www.filedropper.com/betscience

I am NOT looking for a free ride - if someone can give me a few pointers on how to override the Target profit of the FAV or any other selection I would appreciate it. Thanks

[alrodopial]

NW can you give us an example of what are you trying to do?
I personally have few problems understanding it in English

[Norwegian Would]

Thanks Al. Ref screenshot shown in the link on my post 4.april 11:43.

I am trying to construct an excel ss for linking in to Gruss. I can work the triggers out later myself . I have the basic calcs for the "dutching" from pre ious posts But I am not able to workout how to "over-ride" the requested profit on the fav (or any other selection) Maybe the screen shot on the pre ious post will shed some light?

What i mean by over-ride profit is if I am willing to take a smaller profit on the fav than the other ticked selections.

[Norwegian Would]

What I would like help with is the Excel formulæ to reduce the stake and therefore potential profit on the favourite.

Example 1 shows a "normal" Dutching calc (Gleaned from this forum)

Example 2 shows the desired result: The thinking being is that I am "not keen" that the fav will do the biz and in order to cut my liabilty

from £2 053,85 to £1 450,77 = by 600 Inglish Quids;


I am willing to accept say a potential £30 profit (This will be a varible).


See link for Explanitory WorkBook...


Any help would be greatly appreciated

Derek


http://www.filedropper.com/limitingstakeonfav

[osknows]

Hello,

I've had a quick go at this and essentially it is a little tricky I think, I've got a working solution for a fixed number of selections but if you need changes you need to figure out a way to change the formulae by either VBA or dynamic ranges. My approach is to consider each selection as a simultaneous equation

So for 4 selections where O is odds and S is stake

Eq1. (O1-1)S1 - S2 - S3 - S4 = 15
Eq2. (O2-1)S2 - S1 - S3 - S4 = 15
Eq3. (O3-1)S3 - S1 - S2 - S4 = 15
Eq4. (O4-1)S4 - S1 - S2 - S3 = 15

In excel you can use MMULT and MINVERSE as array functions to solve these equations

See http://www.duncanwil.co.uk/simult.html for a simple explanation and here is a link to my example using 4 selections http://www.mediafire.com/?mwhnux0mzim

You will need to figure out how best to change the range depeending on how many selections you choose.....

All the best Os

[Norwegian Would]

Thanks a bunch OzKnows ! I like your approach.

As a token of appreciation I would like to send you a complimentary copy of

Beginning PivotTables In Excel 2007 (2007).pdf

You can pick it up from this link:

http://www.filedropper.com/apress-begin ... el20072007

Cheers

Derek

[osknows]

I was thinking about this more today and I'm almost certain you can't do this without using VBA purely because the formula required in Excel cannot use non - contiguous ranges. So if you pick selections 1, 3 & 6 you have a non contiguous range!

I've put together a quick vba version which copies the data to excel rather than handle everything in array matrices. You can take a look here http://www.mediafire.com/?0n2qegto1dq

Essentially it looks at what selections you have chosen, reorders the variables, copies back the sorted range to excel and performs the matrix calcs

When I say reorder variables here is an example

3 non contiguous selections 1,3,6 would initially look like this
S1 S2 S3 S4 S5 S6 Y
O1 -1 -1 -1 -1 -1 15
-1 -1 O3 -1 -1 -1 15
-1 -1 -1 -1 -1 O6 15

which needs to be re-ordered for excel to
S1 S2 S3 S4 S5 S6 Y
O1 -1 -1 -1 -1 -1 15
-1 O3 -1 -1 -1 -1 15
-1 -1 O6 -1 -1 -1 15

Hope that is useful?
Os

[Norwegian Would]

VERY much appreciated OsKnows ! I will be looking at it over the weekend. Here's to a profitable Grand National.

PS - does anyone have a TV/web-link for the Aintree meeting for us Ex-pats?

[osknows]

PS - does anyone have a TV/web-link for the Aintree meeting for us Ex-pats?

try one of these

http://www.bbc.co.uk/bbcone/watchlive/
http://www.myp2p.eu/broadcast.php?match ... art=sports
http://livevideo.betfair.com/

[Norwegian Would]

Hey up ! What OsKnows don't know ain't worth knowing.

Excellent and a big thanks you. Justin TV worked downloaded the app for the iPhone excellenet quality

You made my day.

[Shaun]

Is there a link to that doc for Dutch laying to set profit, i could use that formula thanks.

[osknows]

You can use the same principls as the backing formula to derive the laying. If you consider 4 selections you wish to lay for a target profit of £15 then again there will be 4 simultaneous equations

For 4 selections where O is odds and S is stake

Eq1. -(O1-1)S1 + S2 + S3 + S4 = 15
Eq2. -(O2-1)S2 + S1 + S3 + S4 = 15
Eq3. -(O3-1)S3 + S1 + S2 + S4 = 15
Eq4. -(O4-1)S4 + S1 + S2 + S3 = 15

Effectively it's the same as the backing equations except the positive terms are negative and vice versa

This file has been updated to include the laying http://www.mediafire.com/file/dfwg0mwlq1z/Dutching.xls

[Shaun]

Thanks for that.

Got a question as you seam to be good with formulas.

If i was down $80 and my next runner was $4 what formula could i use to back and lay to create a zero loss/win situation, basically to to get back losses with out making a profit, or maybe even making a small profit.