Follow now. Sorry for the mis-steer; though, incidentally, I do find QTab the easiest to work with, even if I bet somewhewre else.

Oh but it is. www.tabracing.com.au Find a race and then click approximate divs if I remember rightly.

Love your soccer names - hee hee.

KV

He's right, you know. Good one, KV

Well done KV. Just have to work out how to manipulate them for Excel. Unfortunately the main screen seems to be a single entity so I can't copy and paste into Excel. But, hey you can't have everything.

Cheers

SeeDee,

What version of Excel are you using? I am using Excel 2003 so I don't know if earlier versions can do this, but all I have to do is right click on the quinella dividend matrix and select 'Export to Excel' and the quinella prices are inserted into an Excel sheet as displayed on the Tab site.

Failing this you still should be able to select the appropriate info for a copy and paste into Excel then select 'match destination formatting' for the same result. (Unless this is also a feature of later versions of Excel)

Wunfluova

Hey Wunfluova,

I am using Excel 97 and I don't get that option. Time to upgrade. I can deal with the Quin odds with a bit of effort - BUT the main screen (from which you select "approximate divs") is not Excel 97 friendly. Can you do the same with that screen? If so, I will definitely upgrade.

SeeDee, I can't select (left click) the prices on that page to copy and paste, but the right click and 'export to excel' option still works fine. It downloads all the price data showing on the page - price fluctuations etc plus all the results and exotic info on the page above the field and price info.

Wunfluova

p.s. If you right click on the page do you get a menu which includes 'view source'? If so this will get the figures for you in amongst all the html tags etc so the info is there but it is probably going to be a nightmare trying to isolate the 'good stuff' from the 'bad stuff'. Easier I think to upgrade your Excel.

Agreed. Many thanks Wunfluova.

Love that formula Wun, does Roger have any more gems you might like to share, like a similar one for trifectas or boxed trifectas?

KV

The attached isn't pretty, but it is what I made up to predict correct quinella and trifecta dividends.

I entered the numbers and expected dividends as per KennyVictor's example in the shaded area, and the expected dividends are shown to the right for each combination.

I've given up on trifectas (just can't nail enough), but my experience with my winning quinella bets is that they pay better than suggested about 90% of the time. So they should, given the reduced TAB take for the pair (compared to win dividends)

Attached Files

Book1.xls (18.0 KB, 794 views)