Chinbok,
Well with that many records you really have to use Access.
My Excel suggestion was to import rankings into Access as you build up the database, but what you want is rankings based on queries?
If your Excel files are that large, you risk data corruption as well - I lost a whole Excel master list 6 years ago which had months of figures in it
Yes, you can include the other calculations, just create a new calculation field in the query based on the Win dividends.
Example POT:Profit/Number of Bets as a calculation.
Yes you can use a macro, just create a recorded macro and modify it later to suit your needs, then run it as a loop.
You can do just about anything in Access you can think of, BUT some things require a lot of trial and error, such as the dreaded ranking issue.
All over the place you find examples of ranking a set of records in a query - just about nowhere can you find rankings by date,track race.
Have a look at that link I posted, if you can follow the tutorial, you'll catch on quickly how to modify it to include the various categories as well.
If anyone else has a better reference or idea for rankings, I'd sure welcome it.