Automation of record keeping?

[Brovashift]

I want to record more than just P&L, like on the BFMG spreadsheet, I just dont want to do it manually if I dont have to....Because I go from race to race/course to course the info will help me pin point on what type of race and at what course I tend to take my biggest hits and allow me to see what needs work or what to avoid all together.

Unless I am missing something the only manual thing you would have to do is click download on your P&L page and then add that to the BFMG SS. Do that once a month and you have about 60 seconds work to do and you get to see what you have just laid out, courses, distances etc etc

Sounds like you are trying to reinvent the wheel when someone is happy to sell you a wheel for less than £10.

I agree the Mindgames spreadsheet is fantastic.

As you've been such a help in the past I value your opinion RealRocknRoller... so looks like BFMG have made another sale. I've wasted half the day trying to look at updating csv files, when someone has done all the work for me, and like PDC says for under a tenner! Im what is known in the industry as a cheap charlie

[PDC]

I agree the Mindgames spreadsheet is fantastic.

I haven't used it so can't say, I just looked it up. For what he is charging it doesn't seem worth the effort trying to reproduce what you can buy for the price of a pint and packet of crisps. For what he seems to want it sounds like it fits the bill, so spend your time on your trading instead of trying to reproduce it.

As has been said, spent half the day and got no where, you could have spent that time trading and making a multiple of what it costs to buy.

Let us know what you think to it once you have tried it.

[Brovashift]

I agree the Mindgames spreadsheet is fantastic.

I haven't used it so can't say, I just looked it up. For what he is charging it doesn't seem worth the effort trying to reproduce what you can buy for the price of a pint and packet of crisps. For what he seems to want it sounds like it fits the bill, so spend your time on your trading instead of trying to reproduce it.

Let us know what you think to it once you have tried it.

Will do.... I didn't realise it was that easy tbh. I thought it required manual input of each race, type, course, P&L etc. which would obviously take an age, and be a major distraction between trades. I think I can handle a couple of minutes a month.

[Realrocknrolla]

It is piss easy to use. Like you said just download your P n L individually and import into the spreadsheet. Lots of nice charts and graphs and pivot tables.

[Realrocknrolla]

I agree the Mindgames spreadsheet is fantastic.

I haven't used it so can't say, I just looked it up. For what he is charging it doesn't seem worth the effort trying to reproduce what you can buy for the price of a pint and packet of crisps. For what he seems to want it sounds like it fits the bill, so spend your time on your trading instead of trying to reproduce it.

As has been said, spent half the day and got no where, you could have spent that time trading and making a multiple of what it costs to buy.

Let us know what you think to it once you have tried it.

Great advice as always.

[Brovashift]

It is piss easy to use. Like you said just download your P n L individually and import into the spreadsheet. Lots of nice charts and graphs and pivot tables.

Ye... I looked at it last night on my phone but didnt dive too deep into it. I watched the youtube videos before on my PC and man, it does even more than I need. Looks brilliant!

Out of curiosity, what excel version are you using? Im using MS Excel 2007 on a windows 10 machine which is listed as all good in the requirements on the BFMG website, but for some reason I cant get it to open, says its corrupt. And the BF lifetime report says some issue with Macros.

I've ping'd over an email to him anyway, just waiting for a reply.

[Realrocknrolla]

Im on 2016 but since i have upgraded to Windows 11 all my office suites upgraded to 365 which is a bonus.

[Brovashift]

Im on 2016 but since i have upgraded to Windows 11 all my office suites upgraded to 365 which is a bonus.

All working now, he forwarded me another version in older file format. How does Windows 11 compare to 10, any good? Im always reluctant to upgrade too soon, until I know all the bugs and issues have been worked through. Been like that since the epic failure that was Windows Vista lol.

[Realrocknrolla]

All fine for me mate. I had to uninstall one application and re install but apart from that I had no problem.

I like the upgrade, it seems slicker.

PS good luck with the analysis

[Brovashift]

Cheers mate

[CallumPerry]

Just to clarify, yes I simply meant create a new rules file, add a stored value then from the drop-down check out all of the options BA would record for you automatically. You then select all markets, auto-bind throughout the day and you have everything you need.

Since getting back from work, I see you have been recommended another spreadsheet that takes your data and displays it with fancy graphs/charts. Let me know if it's any good! I like a good, colourful output to slice and dice my info. As has been said, it's good to see your performance (/ a bot) from a wider perspective.

[Brovashift]

Just to clarify, yes I simply meant create a new rules file, add a stored value then from the drop-down check out all of the options BA would record for you automatically. You then select all markets, auto-bind throughout the day and you have everything you need.

Since getting back from work, I see you have been recommended another spreadsheet that takes your data and displays it with fancy graphs/charts. Let me know if it's any good! I like a good, colourful output to slice and dice my info. As has been said, it's good to see your performance (/ a bot) from a wider perspective.

Cheers Callum, yes the BFMG spreadsheet is very good, very easy to use, and it breaks all your data down so you can clearly see what areas are working and what aren't.
I've discovered that a lot of my betfair activity has been matched betting as well as trading, so the data is all a bit mixed up with losses that aren't losses, just money moving from exchange to bookies / bookies to exchange. So I have now moved all non trading activity away from betfair and into Smarkets now, so going forward only trading data will be added to the BFMG spreadsheet.
Also very easy to upload BF data, litterally about 6 mouse clicks, about 30 seconds. And for the price as welll... Excellent.