Flagging the Market Winner(s) in the P&L Report
- firlandsfarm
- Posts: 2720
- Joined: Sat May 03, 2014 8:20 am
A "Winner flag" would be a great advantage when reviewing the various reports produced by BA rather than wade through various websites to find the result of each market or do a match-up with the Betfair SP file that's not available until the next day. Could the winner be flagged in the Export P&L File automation command if known when the rule is triggered.
- firlandsfarm
- Posts: 2720
- Joined: Sat May 03, 2014 8:20 am
I agree "usually" but not always. And can I get an extract of the stored values, I'm not aware of how to do so. In which case it's not really a solution as I will need to sit down and read which runner the stored value is against and manually note it in the spreadsheet … that's what I would want to avoid, it's very time consuming.
If you tick "show in market logs" then the stored value will save in there. You can use some simple code to extract it where you want.firlandsfarm wrote: ↑Thu May 30, 2019 12:39 pmI agree "usually" but not always. And can I get an extract of the stored values, I'm not aware of how to do so. In which case it's not really a solution as I will need to sit down and read which runner the stored value is against and manually note it in the spreadsheet … that's what I would want to avoid, it's very time consuming.
- firlandsfarm
- Posts: 2720
- Joined: Sat May 03, 2014 8:20 am
OK, I didn't realise it would show in the Log CSV and yeah I can extract it from there but what a palaver just to find who won a race. DOS copy all the log files into one file, import that file into a worksheet, copy it into the market closure report workbook, run the look-ups to merge the result with the P&L for the runner! I just feel it should be a fundamental part of a P&L extract.
- firlandsfarm
- Posts: 2720
- Joined: Sat May 03, 2014 8:20 am
It might be, if you know how to set up and match scraped data into Excel … I don't And what about Greyhounds, USA, AUS, RSA etc. That's an awful lot of scrapes!
sa7med, all your suggestions are workable in the right hands and I thank you for them but I will still put my suggestion forward. I guess the majority of BA users possibly don't know how to consolidate multiple CSV files into one let alone build a real time scrape and match in Excel. This is a suggestion to improve BA, make it more useable and more user friendly. Yes there are workarounds but a workaround is defined by Oxford dictionaries as "a method for overcoming a problem or limitation in a program or system". It must be so much easier for it to be incorporated into BA than have people keep thinking of and constructing workarounds.
- firlandsfarm
- Posts: 2720
- Joined: Sat May 03, 2014 8:20 am
Thanks Euler but that only works where there is in-running betting … there are many markets that close at the off. All greyhounds, some place markets ...
- firlandsfarm
- Posts: 2720
- Joined: Sat May 03, 2014 8:20 am
OK and thanks for explaining the need for a results service … in my ignorance I assumed Betfair provided that info through their API as they show the winner on the market screen after the finish but if they don't I can understand the problem. Maybe 1p bets is a way to do it so long as Betfair don't get pissed off!
There is a Winner indicator on the API - it used to be too slow to update to be useful in the P&L report, but we'll test it again to see if we can make use of it in a future version.firlandsfarm wrote: ↑Fri May 31, 2019 1:23 pmI assumed Betfair provided that info through their API
- firlandsfarm
- Posts: 2720
- Joined: Sat May 03, 2014 8:20 am
Thanks … again I assumed it would be the same as on the market screen when it gets cleared and the winner and their odds are shownBet Angel wrote: ↑Thu Jun 06, 2019 3:10 pmThere is a Winner indicator on the API - it used to be too slow to update to be useful in the P&L report, but we'll test it again to see if we can make use of it in a future version.firlandsfarm wrote: ↑Fri May 31, 2019 1:23 pmI assumed Betfair provided that info through their API