Excel (or Access) coder required

[doris_day]

I bet almost every day on almost every race. I often bet 2 or 3 runners in each race and therefore I build up quite a lot of data. Some courses I perform better at than others and I like to keep track of how I'm doing. I do this weekly by downloading the Bet History from Betfair.
I would like a macro or Access prog that will look at the data and give me the following for each course: name of course, ave price matched at, P/L for course, number of winning bets, number of losing bets. Race type isnt so important at the moment, although in the future I may want a macro that breaks down races into types i.e 5f, 6f, Chase , Hdl etc
Sounds pretty straightforward to me for someone that knows Excel or Access. I'm very happy to pay the going rate via PayPal.
PM me if interested and if you can do it now rather than sometime in the future. Thanks.

[Ian]

You don't really need a macro to do that - have a look in the help for pivot tables.

[doris_day]

OK, I'll take a look. However, I'd much rather pay for someone to do this for me and from their final thing I'll learn more quickly how to do it in future. I learn better by example.

[doris_day]

I've just imported the data into Access and have used their reporting to do what I need. Seems to work OK.

[melcon]

Hi. I am ready to give your project the kick-off. I am a 22 year old student of applied mathematics from Hamburg, Germany. I am into the betting business since the age of 13 and do some casual codingin my free-time. So don`t expect top code-structure but I am motivated to master your needs. If you are interested you can send me a PN whereyou specify the application flow.

Is the raw-data already available?
So that the programm is more or less searching a excel table for pre-defined criteria?

Do you have ICQ or some other messenger to answer questions during the programming fast?

Tim

[doris_day]

Thanks for the offer but I think I've cracked it myself in Access