tag:blogger.com,1999:blog-6634548863347354947.post6757184881298963839..comments2024-02-24T14:02:58.396+00:00Comments on Betfair Trading Mind Games: Unlocking the secrets of your P&L data by customising Results SummaryMind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-6634548863347354947.post-82077953533472783552021-07-27T18:48:26.853+01:002021-07-27T18:48:26.853+01:00Hi Tadz, currently the spreadsheet imports Betfai...Hi Tadz, currently the spreadsheet imports Betfair and Betdaq P&L files unedited. The P&L files are provided at market level (i.e. net P&L after commission for a market such as a horse race or a football match) and not at an individual bet level. As you can do L2B and B2L multiple times within the same market it's not possible to report on them at a market level.<br />Let me know if you have any other suggestions, they're good to hear!Mind Gameshttps://www.blogger.com/profile/00353279735822178218noreply@blogger.comtag:blogger.com,1999:blog-6634548863347354947.post-48737085765286165982021-07-25T00:12:26.641+01:002021-07-25T00:12:26.641+01:00My 2 areas of in-play trading are B2L and L2B.
Is ...My 2 areas of in-play trading are B2L and L2B.<br />Is there some way I could add a new column (or 2) somewhere to filter between the two. <br />I can't see how this information can be gleamed from the Betfair results, so I presume if possible it would involve a manual data input at the end of each days play, a simple toggle between L2B and B2L would seem suffice.<br />Thanks.<br />TadzTadzhttps://www.blogger.com/profile/15210863047521820942noreply@blogger.comtag:blogger.com,1999:blog-6634548863347354947.post-57209698429941532932021-01-04T23:27:33.686+00:002021-01-04T23:27:33.686+00:00Perfect - Thank you very much, it works like a cha...Perfect - Thank you very much, it works like a charm after following your instructions!Jayhttps://www.blogger.com/profile/12105407986949087493noreply@blogger.comtag:blogger.com,1999:blog-6634548863347354947.post-56777291742829877072021-01-04T17:30:11.967+00:002021-01-04T17:30:11.967+00:00Thanks Jay, that's great to hear. You can copy...Thanks Jay, that's great to hear. You can copy and paste tables, it is a little bit tricky to properly select it before copying though. You need to place the cursor just above the table name but still within the table until the cursor changes into a black arrow (pointing right), then click and type ctrl-c, arrow over to where you want the new table (put it to the side not underneath any existing tables) then ctrl-p to paste.<br />Remember to take a backup copy of your spreadsheet first. Very important!Mind Gameshttps://www.blogger.com/profile/00353279735822178218noreply@blogger.comtag:blogger.com,1999:blog-6634548863347354947.post-56817296693943834932021-01-04T17:06:09.932+00:002021-01-04T17:06:09.932+00:00This is great! Is there anyway to make a copy of t...This is great! Is there anyway to make a copy of the tables, so you have both the original table setup and also a bespoke table to view data in the different format simultaneously? Ideally I would like a second horse racing tab to do this, but don't know it that is possible or not? Alternative having copies of the original tables to customise in the same tab would work too. Any thoughts?<br /><br />I must say, I'm very impressed with this spreadsheet, there's a hell of a lot of work gone into it and it's extremely good value for under £4!<br />Jayhttps://www.blogger.com/profile/12105407986949087493noreply@blogger.comtag:blogger.com,1999:blog-6634548863347354947.post-77323473873317553762020-05-22T10:16:49.084+01:002020-05-22T10:16:49.084+01:00Thanks! That's exactly what I'm hoping for...Thanks! That's exactly what I'm hoping for!Mind Gameshttps://www.blogger.com/profile/00353279735822178218noreply@blogger.comtag:blogger.com,1999:blog-6634548863347354947.post-52582601572438971702020-04-02T04:25:54.596+01:002020-04-02T04:25:54.596+01:00Wow, Thank you! I've just stumbled on a golden...Wow, Thank you! I've just stumbled on a golden mine field... I'm very appreciative for your work and commitment to share with traders like myself! :) Anonymoushttps://www.blogger.com/profile/05258817844161623580noreply@blogger.com