News for hackers. Stuff that matters.
Re:Ask HN: What do you use MS Excel for? by RossTennis on Wednesday October 03, 2018 @01:10PM (#18132371)
I spent the last year building a predictive tennis model using Google Sheets which is basically the same as Excel. I have no technical skills so this was the easiest way to do it, plus it helped me learn SQL. Basically I have around 50,000 tennis matches in one sheet, filter them into another sheet, into around 100 comparative points, then in the end produce a probability for each upcoming match, and bet accordingly. I also use it to produce a little head to head stats visual and automated 200-word match previews.

It all works perfectly but obviously just for one user at a time. So I brought on a dev friend a few months ago and will launch a user facing site next week, as well as a b2b api for match previews / seo rich content.

I'm actually looking for seed funding up to around 25k, if anyone wants to reach out about that, or has other questions.

If you just want to follow some of the tips I'm running a very basic blog site at www.tennisacca.com sharing my most highly recommended picks (rather than listing 100's of games a week and needing a huge bankroll), which win at a ROI of 10%+ on average. It's mostly just for friends until the main site launches next week.

Re:Ask HN: What do you use MS Excel for? by thewizardofaus on Wednesday October 03, 2018 @06:30PM (#18135361)
Hi! I did something similar a few years ago,instead I used python and machine learning algorithms + custom ELO implementations for tennis matches. Unfortunately it worked too well and I was banned from all the bookmakers.
Re:Ask HN: What do you use MS Excel for? by RossTennis on Wednesday October 03, 2018 @07:17PM (#18135607)
nice, well done! Why not use betfair or Molly? Or also sell tips etc? Do you have a site?
Re:Ask HN: What do you use MS Excel for? by xcubic on Thursday October 04, 2018 @03:49AM (#18137952)
Out of curiosity. How did you manage to gather so much data?
Re:Ask HN: What do you use MS Excel for? by RossTennis on Thursday October 04, 2018 @08:20AM (#18139199)
Various data feeds, working in the industry, plus some open source