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 11th November 2014, 06:35 AM
Rinconpaul Rinconpaul is offline
Banned
 
Join Date: Feb 2013
Posts: 755
Default Punters Sentiment Meter?

Need a bit of excel help here (walkermac, the maestro, where are you?)

This idea could be of interest to all and sundry though. In DNA of a Longshot Winner, I toyed with the idea of a pattern recognition theory using the flucs. It assigned a colour if on course flucs shortened, drifted or steady. This time I'm looking at all the Betfair flucs from Open to Close.

The Logic: If they're are more shorteners than drifter flucs, you could say that punters reckon the selection's got a chance and vice versa. Well the jury's out on that one! You could look at weight of money too, but I haven't seen anything conclusive there either. However if you included the price value into the equation, could that be more reliable?

In the attachment are the Betfair flucs of four runners in a race. The closing fluc is always the top of each column of flucs. Working from bottom to top, the Open fluc is assigned a positive number to begin each sequence. Any consecutive number higher than previous fluc remains a positive number. Any consecutive number lower than the previous is assigned a negative value (red text). At the end of each sequence, in col E, the sum of the positive and negative flucs is totalled. It's getting columns D & E to work in excel, is my bugbear, as it needs to recognise the change to next runner, as well as higher or lower value of cell under.

Once I've got that, I can Pivot Table the spreadsheet and see what values were place getters and whether or not there's a pattern emerging.

Thanks in anticipation
Attached Files
File Type: xlsx Punters Sentiment Measure.xlsx (10.9 KB, 699 views)
Reply With Quote
  #2  
Old 11th November 2014, 08:50 AM
darkydog2002 darkydog2002 is offline
Banned
 
Join Date: Nov 1999
Posts: 4,332
Talking

hehehe,
Your having a lend.
Reply With Quote
  #3  
Old 11th November 2014, 10:06 AM
Rinconpaul Rinconpaul is offline
Banned
 
Join Date: Feb 2013
Posts: 755
Default

Quote:
Originally Posted by darkydog2002
hehehe,
Your having a lend.


Might be, but check this out. Notice anything about the Sum of the first 3 placegetters compared to the rest?

All these sorts of things are building blocks that might not work stand alone, but combined with a few others might build you a successful system/method. So take off the blinkers and look around where no one else is looking.
Attached Thumbnails
Click image for larger version

Name:  Having a Lend.JPG
Views: 643
Size:  48.9 KB  
Reply With Quote
  #4  
Old 11th November 2014, 11:00 AM
beton beton is offline
Member
 
Join Date: Jan 1970
Posts: 589
Default

I have to make some assumptions here. Firstly this is not a one off. Secondly that you have noticed a trend. Thirdly it is a significant trend. Fourthly you have only looked a small sample and alerting us.
How many samples have you looked at and how many match your observations?
Furthermore this could only be done with Betfair as the oncourse flucs are a result of human manipulation. Similarly it could not be done on tote prices as the weight of money on any horse affects all prices.

The Betfair flucs are matching of a lay bet and back bet, and is a matter of accepting what is available at the time. Each and every matched bet creates a fluc. Hence this would need to be automated as some races must generate thousands of flucs. The Cup would most likely be the benchmark, so how many flucs occur in that event?
Reply With Quote
  #5  
Old 11th November 2014, 11:21 AM
Rinconpaul Rinconpaul is offline
Banned
 
Join Date: Feb 2013
Posts: 755
Default

Quote:
Originally Posted by beton
I have to make some assumptions here. Firstly this is not a one off. Secondly that you have noticed a trend. Thirdly it is a significant trend. Fourthly you have only looked a small sample and alerting us.
How many samples have you looked at and how many match your observations?
Furthermore this could only be done with Betfair as the oncourse flucs are a result of human manipulation. Similarly it could not be done on tote prices as the weight of money on any horse affects all prices.

The Betfair flucs are matching of a lay bet and back bet, and is a matter of accepting what is available at the time. Each and every matched bet creates a fluc. Hence this would need to be automated as some races must generate thousands of flucs. The Cup would most likely be the benchmark, so how many flucs occur in that event?


First and foremost, this thread is not a Gimme, no keys to the kingdom here, unless you're prepared to put in the time consuming effort of collecting data and analysing it. That'll cut out 98% of readers, sad but true. If it turns out to be successful, I certainly won't be spruiking about it, shhh!!

Just an idea based on a little logic and a spoonful of observations. The main purpose is to glean from others, more adept at excel, a formula so that I can test a large sample. Then, anyone reading this thread will have the IDEA and the TOOLS to test for themselves.
Reply With Quote
  #6  
Old 11th November 2014, 12:32 PM
beton beton is offline
Member
 
Join Date: Jan 1970
Posts: 589
Default

Just when I was getting the hang of the younger generation and their expectation of ask and you will receive because one has the God given right to anything one wants, you go and tell me to be Lieutenant Rowan. Besides "keys to the kingdom" implies that one would have to unlock the door. I was of the opinion that the younger generation expects the door to be already open.

Keep these left field ideas coming.
Reply With Quote
  #7  
Old 11th November 2014, 01:54 PM
darkydog2002 darkydog2002 is offline
Banned
 
Join Date: Nov 1999
Posts: 4,332
Talking

I,ll pass.
hehehe
Reply With Quote
  #8  
Old 11th November 2014, 04:20 PM
walkermac walkermac is online now
Member
 
Join Date: Nov 2013
Posts: 596
Default

Re-using some of those inelegant formulas again (though it has its advantages as well)


In D2:
Code:
=IF(A2=A3,IF(B2>B3,B2,-B2),B2)


In E2:
Code:
=IF(C2="Close",SUM(INDIRECT("D"&F2&":D"&G2)),"")


In F2:
Code:
=IFERROR(IF(A2="","",IF(NOT(A2=A1),ROW(),F1)),"")


In G2:
Code:
=IF(F2=F3,G3,ROW())



Fill Down.


Remember me when you earn too much money to spend...

Last edited by walkermac : 11th November 2014 at 04:21 PM. Reason: added Code tags
Reply With Quote
  #9  
Old 11th November 2014, 04:30 PM
Rinconpaul Rinconpaul is offline
Banned
 
Join Date: Feb 2013
Posts: 755
Thumbs up

Works a treat, thanks again and again.

Don't worry walkermac, if I come up with something viable, I'll repay you in spades.

Cheers
Reply With Quote
  #10  
Old 11th November 2014, 05:11 PM
beton beton is offline
Member
 
Join Date: Jan 1970
Posts: 589
Default

Quote:
Originally Posted by Rinconpaul
Works a treat, thanks again and again.

Don't worry walkermac, if I come up with something viable, I'll repay you in spades.

Cheers
Cheap fella. Spring for some Crownies at least
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 12:15 PM.


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