Betfair P&L screen changes

A place to discuss anything.
Post Reply
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

FFS just noticed they've changed the format to csv from XLS too, I normally download the pnl and send to a database weekly. Gonna have to recode things now they've changed format just have to hope they haven't changed fields too :(

Just noticed they've even changed the format and lost country fields so my old database is pretty much useless now :(:( :evil:
Last edited by spreadbetting on Fri Jul 24, 2020 3:02 pm, edited 2 times in total.
Top
User avatar
Naffman
Posts: 5924
Joined: Sun Aug 11, 2013 5:46 am

How is this still not fixed?

Giving Hull City a run for their money on the worst run business in the uk
Top
User avatar
Ethanol
Posts: 148
Joined: Thu Jun 09, 2011 9:09 am

spreadbetting wrote: ↑
Fri Jul 24, 2020 2:59 pm
 FFS just noticed they've changed the format to csv from XLS too, I normally download the pnl and send to a database weekly. Gonna have to recode things now they've changed format just have to hope they haven't changed fields too :(

Just noticed they've even changed the format and lost country fields so my old database is pretty much useless now :(:( :evil:
:(

I'd hold off on that recoding. Things may change even more over the coming weeks...
Top
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

True, they must have rolled it back to previous data at least once as my database is up to 21 July with correct data. Just checked and I'd updated the DB 11:40 on 21st for the previous weeks data and this thread started the previous day.

Dunno how a so called tech company can get it wrong so often. I had a report this week for something different and they'd arsed that up by merging cells etc just to make it all look pretty, anyone getting that result would just want the raw data not a fancy xls sheet which probably took someone a week to do for no good reason.
Top
User avatar
Derek27
Posts: 25159
Joined: Wed Aug 30, 2017 11:44 am

Next will be downloading someone else's P/L!
Top
jamesg46
Posts: 3772
Joined: Sat Jul 30, 2016 1:05 pm

Derek27 wrote: ↑
Fri Jul 24, 2020 4:13 pm
 Next will be downloading someone else's P/L!
That would be interesting!
Top
User avatar
ShaunWhite
Posts: 10560
Joined: Sat Sep 03, 2016 3:42 am

spreadbetting wrote: ↑
Fri Jul 24, 2020 2:59 pm
 FFS just noticed they've changed the format to csv from XLS too, I normally download the pnl and send to a database weekly. Gonna have to recode things now they've changed format just have to hope they haven't changed fields too :(

Just noticed they've even changed the format and lost country fields so my old database is pretty much useless now :(:( :evil:
Don't make changes just yet. If you look back to the msg from Neil I posted you'll see they're addressing the event info and that should include country code.
Top
User avatar
ShaunWhite
Posts: 10560
Joined: Sat Sep 03, 2016 3:42 am

If they'd just reinstate the market ID on the transaction statement you wouldn't even need the pl page except maybe for a check on today's pl. It's the transactions that are important not just a market total and for a few months now you can't group the transaction statement by market.
Top
User avatar
Derek27
Posts: 25159
Joined: Wed Aug 30, 2017 11:44 am

I'm glad I haven't yet got round to writing code to import transaction data into a database. When I do I'll have to make the fields flexible and move data field by field. A straight-forward dump is out of the question now.
Top
User avatar
ShaunWhite
Posts: 10560
Joined: Sat Sep 03, 2016 3:42 am

Derek27 wrote: ↑
Fri Jul 24, 2020 4:43 pm
 I'm glad I haven't yet got round to writing code to import transaction data into a database. When I do I'll have to make the fields flexible and move data field by field. A straight-forward dump is out of the question now.
I've been looking at Excel Power Pivot Get and Transform (catchy name). It might be a quick and dirty way to move things around but I haven't tried it. I've just remembered you're an Acess guy I think so I suppose that's got it all covered.
Top
User avatar
Naffman
Posts: 5924
Joined: Sun Aug 11, 2013 5:46 am

They still haven't fixed it and we all know nothing gets done on the weekends at HQ - BF is going down the shitter, just so hard for anyone to compete though
Top
User avatar
Derek27
Posts: 25159
Joined: Wed Aug 30, 2017 11:44 am

Naffman wrote: ↑
Fri Jul 24, 2020 7:04 pm
 They still haven't fixed it and we all know nothing gets done on the weekends at HQ - BF is going down the shitter, just so hard for anyone to compete though
There's always Honest Joe. They've been carrying out maintenance for the last year or two but the site says they'll be up again shortly. ;)
Top
User avatar
Naffman
Posts: 5924
Joined: Sun Aug 11, 2013 5:46 am

Derek27 wrote: ↑
Fri Jul 24, 2020 7:10 pm
Naffman wrote: ↑
Fri Jul 24, 2020 7:04 pm
 They still haven't fixed it and we all know nothing gets done on the weekends at HQ - BF is going down the shitter, just so hard for anyone to compete though
There's always Honest Joe. They've been carrying out maintenance for the last year or two but the site says they'll be up again shortly. ;)
Ahhhh no wonder why BF have been so slack then, when Joe gets back online BF will be back on their best behaviour
Top
User avatar
gazuty
Posts: 2557
Joined: Sun Jun 26, 2011 11:03 am

P&L page down. :(
Top
User avatar
Kai
Posts: 7179
Joined: Tue Jan 20, 2015 12:21 pm

gazuty wrote: ↑
Tue Jul 28, 2020 12:24 am
 P&L page down. :(
Don't think so, you sure? It's just been very slow recently. Takes sometimes like half a minute to load stuff up but works.

I like how it automatically loads today's P&L, this change is actually useful.
Top
Post Reply

Return to “General discussion”