Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 30th March 2009, 06:03 PM
Dennis G Dennis G is offline
Member
 
Join Date: Mar 2006
Posts: 112
Default Excel Help - Market Framing

Hi Guys,
I got a problem with re-adjusting markets to take scratchings into account.

It seemed so easy, but when I sat down to do it I realised I had not clue one what I was doing. I went to an Excel help site, but realised it would be easier to explain to the racing mob.

What I want to do is write a template for up to 20 horses (the max I expect to encounter), so Column A = TAB No, Col B = Original Market, Col C = Adjusted Market after Scratchings.

My first problem was establishing the market percentage of Col A.
It went something like - =SUM(100/B1+100/B2+100/B3+100/B4+.....100/B20) which apart from being incredibly cumbersome doesn't take blank cells into account and there returns a #Div/0! error. So I started playing around with conditional functions and, and..... I've got a headache....

Surely one of you very charitable souls can point me in the right direction, I'd REALLY appreciate it.

Thanks,
Den
Reply With Quote
  #2  
Old 30th March 2009, 06:27 PM
Crackone Crackone is offline
Member
 
Join Date: Apr 2006
Posts: 368
Default

have a look at http://forums.ozmium.com.au/showthread.php?t=17865 post #5 it has a excel spread sheet that might have something in it that you can use. not exactly what you want but may help.
Reply With Quote
  #3  
Old 31st March 2009, 12:18 PM
Chrome Prince Chrome Prince is offline
Member
 
Join Date: Jan 1970
Posts: 4,424
Default

I've quickly put together...

Market Maker Deluxe

Simply delete the rating of any scratching and the market will recalculate to 100%

Hope this helps.
Attached Files
File Type: xls Market Maker Deluxe.xls (23.0 KB, 1306 views)
__________________
RaceCensus - powerful system testing software.
Now with over 407,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 30/09/2024
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg
Reply With Quote
  #4  
Old 1st April 2009, 04:12 PM
Dennis G Dennis G is offline
Member
 
Join Date: Mar 2006
Posts: 112
Default

Thanks Chrome, certainly a professional looking job but you misconstrued what I meant, or more likely I didn't explain very well.

What I wanted was to put in a column for paper prices and have it auto recalculate the odds after scratchings.

I finally got it done - very messy, took 6 columns although 3 of them can be 'hidden'. I knew there was a way cause I can sit down with a calculator and pencil and achieve the result. There may be a more efficient way but it works.

I have attached the file in case anyone else wants it.

Market Adjuster Gold

Note: In this example 3 & 10 are scratched.
Attached Files
File Type: xls Market Adjuster Gold.xls (32.0 KB, 1236 views)
Reply With Quote
  #5  
Old 1st April 2009, 04:44 PM
Chrome Prince Chrome Prince is offline
Member
 
Join Date: Jan 1970
Posts: 4,424
Default

Looks good, great job.
__________________
RaceCensus - powerful system testing software.
Now with over 407,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 30/09/2024
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 09:48 AM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655