Matched Bets

[FrankCole]

Hi,

Is there anyway of pulling in to a spreadsheet the individual bets I have got matched. Similar to other software spreadsheets?

[FrankCole]

sorry by other software spreadsheets, I mean in a similar manner as other software where is pulls all my bets into a tab, MyBets. From there it is easy to work out positions etc.

[PeterLe]

Frank
I havent used it myself; but click on
Guardian > Advanced settings > Export Reports on Market closure
Regards
Peter

(There is a blog/forum post on it too I think?)

[FrankCole]

I'll have a look, see if I can use it. Do you know if the data is pulled in real time to excel

[PeterLe]

I would imagine so Frank
Can you let us know what you think of it when youve had chance to take a look?
thanks

[chainsaw]

Hi,
Any luck finding something on the forum/blog? I posted a (maybe) similar question 2 minutes ago, Then read this one (sigh).
@FrankCole - are wanting live data ? (thats what i am after)

As to the Export under Advanced settings, you get 3 files in a folder with the current date.

Matched Bets
Time Back/Lay Selection Odds Stake Reference
08/01/2016 22:13 Lay KR Reykjavik 15.5 1 13204
08/01/2016 22:14 Back KR Reykjavik 16 1 13206

Profit&Loss
(This was a football match)
Time Selection Profit If Win Profit If Lose
23:55:34 KR Reykjavik 1.39 0
23:55:34 Hafnarfjordur 54.59 0
23:55:34 The Draw 1.33 0

And a copy of the log

So, i think this does what you wanted in your post.


EDIT : just noticed the date of the OP - lol

[FrankCole]

Hi,

Apologies I haven't had a chance to try it yet. I want it to update as soon as my bets are placed, so I can have it running alongside my strategies. So I will be able to work out what my position is what unmatched bets I have etc

[FrankCole]

I believe this only does it in market close?

[Euler]

Hi, Apologies I haven't had a chance to try it yet. I want it to update as soon as my bets are placed, so I can have it running alongside my strategies. So I will be able to work out what my position is what unmatched bets I have etc

You only need to work our your net stake, you don't need to see all matched and unmatched bets.