Chromaweb Excel Sheet

[doubleback]

I have reproduced the Chromaweb - Variable Hedge Tool, in Excel. I thought that I'd share it with anyone who is interested.....



______________________________________

Original Stake = Input Field (D2)

Back Odds = Input Field (D4)

Lay Odds = Input Field (D6)

Percentage of Hedge = Input Field (D8) (Slider)

D20 = Hidden Cell for working out.

F20 = Hidden Cell for working out.

H20 = Hidden Cell for working out.

______________________________________


Back to LAY:

Back to LAY = (((D20-D2)/100)*D8)+D2

If Selection Wins = ((D4-D6)*D2/100)*(100-D8)

If Selection Loses = D10-D2

D20 = ((D4-1)/(D6-1))*D2


Lay to BACK:

Lay to BACK = F20+H20

If Selection Wins = (((D4-D6)*D2)/100)*D8

If Selection Loses = D2-F10

F20 = (((D6-1)/(D4-1))*D2)

H20 = ((D2-F20)/100)*D8

______________________________________

The sheet is protected. Password = geek

Download Link.

[Wednesday 13]

Thanks, db, I'm always eager to see betting spreadsheets; however, something is wrong with your download link - instead of opening MediaFire page, it offers me to download some .lnk file... Can you check it, please...

[doubleback]

Try this link, Wednesday. It's a .xlsx file.

Download Link.

[Wednesday 13]

Yup, that link works. Excellent sheet, many thanks! :Brilliant

[Shaun]

I have some similar calculators i created but this is very nicely done.