Is there a way to derive P/L in ticks

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
User avatar
brimson25
Posts: 504
Joined: Sat Apr 08, 2017 11:42 am

From your betfair account data?

I'd like to know:

- When I profit, I do so by x ticks

- And when I make a loss, I do so by y ticks?

Thanks for any help - and sorry if this is somehow a daft\obvious question.
User avatar
jimibt
Posts: 3641
Joined: Mon Nov 30, 2015 6:42 pm
Location: Narnia

brimson25 wrote:
Thu Feb 21, 2019 12:16 pm
From your betfair account data?

I'd like to know:

- When I profit, I do so by x ticks

- And when I make a loss, I do so by y ticks?

Thanks for any help - and sorry if this is somehow a daft\obvious question.
the obvious problem here is that not every trade will have been setup to achieve the same £ per tick. thus you could have two trades, one with a £250 liability, another with a £25 liability. the outcome of either could be literally anything, so therefore, based on those two simple trades, you'd have no idea on your p&l at a single £/tick level.

in short -yes at single trade level, no at consolidated p&l level.
User avatar
brimson25
Posts: 504
Joined: Sat Apr 08, 2017 11:42 am

Cheers. To explain why I want this, I have a table (which I didn't make) which how much downside you can bear before you lose for a given strike rate.

So, if you a strike rate of 80% but you make 1 tick profit, you can lose 4 ticks when you lose and break even. So, I wanted a general sense of my tick P/L but suspected it would be hard to fathom, as you say.

Perhaps I can adapt the same table to £ values.

Thanks for your help.
User avatar
brimson25
Posts: 504
Joined: Sat Apr 08, 2017 11:42 am

I've just worked it out.

I feel a bit embarrassed :oops: by this thread now.
User avatar
jimibt
Posts: 3641
Joined: Mon Nov 30, 2015 6:42 pm
Location: Narnia

brimson25 wrote:
Thu Feb 21, 2019 12:35 pm
I've just worked it out.

I feel a bit embarrassed :oops: by this thread now.
proudly wear your shame on your sleeve :D
User avatar
brimson25
Posts: 504
Joined: Sat Apr 08, 2017 11:42 am

Both sleeves, there's so much....
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

Typing and talking are two great ways to find answers to problems, it exercises different parts of the grey matter to when you just internalise. Nice touch of humility though brimson but relax, to err is human.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”