We help IT Professionals succeed at work.

Need best approach to manipulate object data in arrayList

qbawler311
qbawler311 asked
on
Medium Priority
251 Views
Last Modified: 2010-03-31
I have a bean "TeamBean" that stores data (TeamName, spread, odds) as in sports betting info.

Array list of TeamBeans:

philadelphia, 5.5, -110
chicago, -5.5, -110
philadelphia, 0.0, +180
chicago, 0.0, -200
Over, 195.5, -110.0
Under, 195.5, -110.0
Hoouston, 5.0, -110.0
Phoenix -5.0, -110.0
Hoouston, 0.0, 195.0
Phoenix 0.0, -240.0
Over, 204.0, -110.0
Under, 204.0, -110.0
+
.
.
.
n+10,000 (lets assume there are over 10K of these records)

I need a way to compare every Philadelphia 76ers vs Chicago Bulls line in this list against each other to determine if there is an arbitrage or scalper betting situation (I will take care of the algorithm/math for this).  Then do it for every Houston Rockets vs Phoenix Suns game in this list...and so on.  There may be anywhere from 20-30 lines for any game for every sport.

Caveats:
1)  Some of the team names are recorded in different strings.  Ex.  "Philadelphia 76ers" is sometimes reffered to as "philadelphia" or "PHI"
2)  Making a synonym database will take forever, is there a better way?
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016
Commented:
>>is there a better way?

Can't think of one - first of all you have to unify your representations - AFAIK this can't be avoided

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
CERTIFIED EXPERT
Top Expert 2016

Commented:
Once you've unified your objects, you need to map them to individual bookmakers
CERTIFIED EXPERT
Top Expert 2016

Commented:
>>is there a better way?

(Unless there's a standardized way of identifying events between different bookmakers, which i'd doubt)

Author

Commented:
>>Once you've unified your objects, you need to map them to individual bookmakers

Ok so I can make a 4th field that is the name of the book maker.
Please give me more info on how to achieve my goal.
CERTIFIED EXPERT
Top Expert 2016

Commented:
Sounds like you need to think more about your requirements. A Bookmaker object would be entirely separate from any Team object. A Team object would be far down the line that encompasses Bookmaker, Event etc.

Author

Commented:
>>Sounds like you need to think more about your requirements.

Here are my simplified requirements:
1) Scrape data from multiple bookmakers
2) Analyze data to determine arbitrage betting situations
3) Display profitable betting situations in a java GUI.
4) Has to work fast...

If anyone wants to help me through this whole process I am willing to offer as many points as it takes. :)

If points don't do it for you we can talk about other forms of rewards.

Contact me at this e-mail:  <mail removed by Venabili>

CERTIFIED EXPERT
Top Expert 2016

Commented:
Sorry that should have had more emphasis on your needing to analyse the abstractions needed, based on your requirements

Author

Commented:
Did I unify right?  Am I on the right track or is there a more efficient way?

I PostProcessed the previous List so its in the form:

Team1, Spread1, Line1, Site1, Team2, Spread2, Line2, Site2

Ex.
Philadelphia, 5.5, -110, Bodog.com, Chicago, -5.5, -110, Bodog.com

I plan to load this postprocess data into an array of beans, The team1 and team2 columns are banged against a Synonym database so every site hosting the game will then have the same strings.  If Site1 != Site2 then I know preprocess is messed.

Author

Commented:
Whoops...my apologies

/r
qbawler311
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.