Keeping records ?

[woods]

Is it possible to keep a record of the bets made through a specific excel workbook, that extends beyond a day ?

What I would like is to have a record of my bets for say an entire month. But I have found that the BA will overwrite the entries in the results sheet, when it logs results the next day..

[bolpx001]

What I do is that at the end of every day I save the work book as a different name say the workbook is called BAexcel.xlsm then, if today’s date is 28th Nov. 2011 I save it as 111128_BAexcel.xlsm. You could also write a VBA macro to copy the data you want to a master file. It is also worth remembering that Betfair keeps a record of your bets which is accessible by clicking on My Account on the main Betfair page after logging in and then Clicking on Account Statement or Betting History.

[woods]

Thanks bolpx

I will probably look at doing a macro, when I have the time. That will append the results to a list in another sheet and add the date. Should be possible I think. So far I have just looked at my betfair account, and written down the odds and if it won or lost. So will continue with that, or saving the workbook with a timestamp, for the time being. Just wanted to be sure there was not some inbuild functionality like that, I had overlooked.