Help please

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
footysystems
Posts: 165
Joined: Thu May 09, 2013 5:57 pm

I have a CSV or files that collect each day with a rating i created for inplay football which i download daily the CSV is now huge cumbersome to say the least is there another way i can collect the data ??? and make it do stuff i want ??? now tried Access today and it done my head in.... any help ?
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

Your post is a bit confusing as you say you download the data and then ask us if there's another way to collect the data when we have no idea where it's from.

At the end of the day CSV is fine for small data files but if it's now unmanageable you'll have to learn to use some database program to handle it all. The good thing is there's plenty of free databases so plenty of help available and all can easily import CSV files. Your best bet is to bite the bullet and either learn to use Access or much better to use one of the free SQL databases. Once you get started they're not as hard to use as you'd imagine
footysystems
Posts: 165
Joined: Thu May 09, 2013 5:57 pm

Done my head in all day tbh here an xls file with yesterdays data..When i went to school you had a timex watch you was doing well :D
You do not have the required permissions to view the files attached to this post.
Atho55
Posts: 678
Joined: Tue Oct 06, 2015 1:37 pm

What are you looking for from this data?
dailyGoals.xlsx

There is a basic pivot table in the file above but could be any combination but may need some format changes first
You do not have the required permissions to view the files attached to this post.
footysystems
Posts: 165
Joined: Thu May 09, 2013 5:57 pm

Atho55 wrote:
Thu Jan 30, 2020 7:15 pm
What are you looking for from this data?

dailyGoals.xlsx


There is a basic pivot table in the file above but could be any combination but may need some format changes first
The main data has 20k goal in it after 15 days so i have copied and pasted it into all one CSV its all over the place.

Averages times and ratings i am after % fhg and so on
greenmark
Posts: 6266
Joined: Mon Jan 29, 2018 2:15 pm

As Spreadbetting says, sounds to me you're at that stage when you realise you need a proper database.
I went with SQL Server.
Installing SQL Server shouldn't be difficult. Designing a database and writing programs to populate it, is difficult.
What's the advantage of all that effort?
The ability to examine (query) all that data with SQL (the dominant data query language). So you can look at stuff by course, horse, jockey...or whatever data you've decided to store in the database.
But it's a step by step process, so go for it.
footysystems
Posts: 165
Joined: Thu May 09, 2013 5:57 pm

greenmark wrote:
Thu Jan 30, 2020 8:48 pm
As Spreadbetting says, sounds to me you're at that stage when you realise you need a proper database.
I went with SQL Server.
Installing SQL Server shouldn't be difficult. Designing a database and writing programs to populate it, is difficult.
What's the advantage of all that effort?
The ability to examine (query) all that data with SQL (the dominant data query language). So you can look at stuff by course, horse, jockey...or whatever data you've decided to store in the database.
But it's a step by step process, so go for it.
I have a program that i had written 12 months ago its world class and just talking to my programmer now that maybe able to come too a solution. its all inplay data which i have from an API i no have the CSV daily export wanted to build a data base of the stats and get some firm markers the markers i have are good but want too tighten it right up..
greenmark
Posts: 6266
Joined: Mon Jan 29, 2018 2:15 pm

Ok. I have no knowledge of collecting inplay data. Good luck :-)
footysystems
Posts: 165
Joined: Thu May 09, 2013 5:57 pm

:lol: :lol: its not about look its a about numbers :lol:
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”