Generating P+L Reports from BA

Discuss anything related to using the program (eg. triggered betting tactics)

Moderator: 2020vision

Re: Generating P+L Reports from BA

Postby GaryRussell » Mon Jul 27, 2020 1:13 pm

Sorry, there is an issue with exporting to CSV that I overlooked. If you are fortunate to win more than 1,000 in a market then it messes up the CSV because the amount includes a comma. I have enclosed the amount in quotes to prevent this issue. Please re-install from the same link when you get the chance.
User avatar
GaryRussell
Site Admin
 
Posts: 9679
Joined: Fri Nov 18, 2005 8:09 pm
Location: Birmingham, UK

Re: Generating P+L Reports from BA

Postby Deestar » Mon Jul 27, 2020 1:28 pm

Those are good issues to have.

The only other thing i noticed Gary is the time in the market info gives the local event time (so AUS time for an AUS event, UK time for a UK event) as opposed to all times as BST. Not a big deal for me, particularly as the date field includes the standardised time.
Deestar
 
Posts: 262
Joined: Sun Apr 26, 2015 8:17 am

Re: Generating P+L Reports from BA

Postby GaryRussell » Mon Jul 27, 2020 1:39 pm

Deestar wrote:Those are good issues to have.

The only other thing i noticed Gary is the time in the market info gives the local event time (so AUS time for an AUS event, UK time for a UK event) as opposed to all times as BST. Not a big deal for me, particularly as the date field includes the standardised time.

Thanks for letting me know. I’ll see if I can change this.
User avatar
GaryRussell
Site Admin
 
Posts: 9679
Joined: Fri Nov 18, 2005 8:09 pm
Location: Birmingham, UK

Re: Generating P+L Reports from BA

Postby Captain Sensible » Mon Jul 27, 2020 2:07 pm

Thanks Gary, just had a quick look and seems fine, it'd be nice if it simply saved to file rather than opening in excel if possible.

Downloaded a weeks worth (haven't tried more), Betfair's version only lets me do a couple of days so guessing you must have some code to roll it up as it was over the 1000 markets. Took a while and froze the prog whilst it was doing it, so might be best to download in downtime but a nice addition as I'll be able to parse the data into the same format used to provide so my DB can still be used.

Thanks
User avatar
Captain Sensible
 
Posts: 2883
Joined: Sat Nov 19, 2005 2:29 pm

Re: Generating P+L Reports from BA

Postby GaryRussell » Mon Jul 27, 2020 2:18 pm

Captain Sensible wrote:Thanks Gary, just had a quick look and seems fine, it'd be nice if it simply saved to file rather than opening in excel if possible.

Downloaded a weeks worth (haven't tried more), Betfair's version only lets me do a couple of days so guessing you must have some code to roll it up as it was over the 1000 markets. Took a while and froze the prog whilst it was doing it, so might be best to download in downtime but a nice addition as I'll be able to parse the data into the same format used to provide so my DB can still be used.

Thanks

Ok I will make it optional to open it after creating. I will move the retrieval to a background thread to prevent it blocking the rest of the application.
User avatar
GaryRussell
Site Admin
 
Posts: 9679
Joined: Fri Nov 18, 2005 8:09 pm
Location: Birmingham, UK

Re: Generating P+L Reports from BA

Postby Captain Sensible » Mon Jul 27, 2020 2:46 pm

Thanks
User avatar
Captain Sensible
 
Posts: 2883
Joined: Sat Nov 19, 2005 2:29 pm

Re: Generating P+L Reports from BA

Postby GaryRussell » Mon Jul 27, 2020 5:47 pm

I've made it retrieve data in the background now. Also the query date range wasn't being requested how I intended. You had to put in tomorrow's date as the to date to get today's P&L. It will now retrieve today's if both dates are today. You can install from the same link.
User avatar
GaryRussell
Site Admin
 
Posts: 9679
Joined: Fri Nov 18, 2005 8:09 pm
Location: Birmingham, UK

Re: Generating P+L Reports from BA

Postby Captain Sensible » Mon Jul 27, 2020 8:53 pm

Thanks, it's still opening up the CSV file in the same instance of excel as my betting sheets so it throws up debugging errors. More likely down to my sheet not referencing a distinct workbook but would be good if it simply wrote a CSV file rather than opening it as I'd guess most of us will simply use the file to import elsewhere. Another suggestion would be that it doesn't automatically download data when opened as most of us will probably stick in our own dates and sports rather than use the default one so to have it open the day's racing is a bit unneccessary. Just a couple of niggles but other than that all working fine.

Thanks..
User avatar
Captain Sensible
 
Posts: 2883
Joined: Sat Nov 19, 2005 2:29 pm

Re: Generating P+L Reports from BA

Postby GaryRussell » Tue Jul 28, 2020 10:23 am

I've added a tick box to allow automatic opening in Excel. If it's unticked it prompts to choose a file name and then just saves to that file.

I've also added a drop down to select which period you want the report for like the website.
User avatar
GaryRussell
Site Admin
 
Posts: 9679
Joined: Fri Nov 18, 2005 8:09 pm
Location: Birmingham, UK

Re: Generating P+L Reports from BA

Postby Deestar » Tue Jul 28, 2020 11:12 am

Brilliant. Particularly like the added "Please wait, it's calculating" info line. Thanks.
Deestar
 
Posts: 262
Joined: Sun Apr 26, 2015 8:17 am

Re: Generating P+L Reports from BA

Postby alrodopial » Tue Jul 28, 2020 11:36 am

small "bug" :

when first started it auto updates to previous version (m)
To avoid it, install as advised, create a new shortcut from bettingassistant.exe file (in ba's folder) and use this shortcut instead
Software will not auto update further so consider rolling back to normal shortcut sometime in the future
alrodopial
 
Posts: 1353
Joined: Wed Dec 06, 2006 9:59 pm

Re: Generating P+L Reports from BA

Postby GaryRussell » Tue Jul 28, 2020 12:00 pm

alrodopial wrote:small "bug" :

when first started it auto updates to previous version (m)
To avoid it, install as advised, create a new shortcut from bettingassistant.exe file (in ba's folder) and use this shortcut instead
Software will not auto update further so consider rolling back to normal shortcut sometime in the future

Was you running a version before version m when you installed this? The launcher checks if the last ran version is less than our server. So after running version m you should be able to install version n without it updating again.
User avatar
GaryRussell
Site Admin
 
Posts: 9679
Joined: Fri Nov 18, 2005 8:09 pm
Location: Birmingham, UK

Re: Generating P+L Reports from BA

Postby Captain Sensible » Tue Jul 28, 2020 1:18 pm

GaryRussell wrote:I've added a tick box to allow automatic opening in Excel. If it's unticked it prompts to choose a file name and then just saves to that file.

I've also added a drop down to select which period you want the report for like the website.



Thanks, all working fine and the tweaks make it a lot more useable especially as it seems Betfair are sticking with their new version which is pretty much unuseable for anyone who does lots of markets and wants all market data.
User avatar
Captain Sensible
 
Posts: 2883
Joined: Sat Nov 19, 2005 2:29 pm

Re: Generating P+L Reports from BA

Postby alrodopial » Tue Jul 28, 2020 1:19 pm

you're right
I was running the "l" version
alrodopial
 
Posts: 1353
Joined: Wed Dec 06, 2006 9:59 pm

Re: Generating P+L Reports from BA

Postby GaryRussell » Wed Jul 29, 2020 12:08 pm

Nobody said anything about the default sport being Horse Racing! I will change it to remember the last sport you selected unless anybody has a better suggestion.
User avatar
GaryRussell
Site Admin
 
Posts: 9679
Joined: Fri Nov 18, 2005 8:09 pm
Location: Birmingham, UK

PreviousNext

Return to Discussion

Who is online

Users browsing this forum: Bing [Bot] and 36 guests

Sports betting software from Gruss Software


The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.

Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.

Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.

He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.

We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.

cron