Total profit or loss for the day/week

[Euler]

Alpha, Bet Angel doesn't know the result and therefore can't settle the market without knowing that. That is why there isn't a balance in practice mode. It has no idea who won or how, that information is not available.

[jimibt]

So i agree with you a practice figured bank would be good, at the momment i use a spreadsheet and have to pop in returns manually, if i could of connected that up to go in automatically that would of been great, but its in the BA teams hands, go on Peter lets have it

+1... for developing new strategies, this would be a great addition and one that OTHER software has had for quite some time.

[lisawatsuk1]

Hi,

Can anyone tell me if the ''Export Report on Market Closure'' is the same as ''export profit and loss report'' that is available in the rules files please? If not, what is the difference?

Thanks
Kaz

Hi Kaz,
I'm not 100% sure but I think they're similar. From what I have noticed using both features at different times, the 'Export Report on Market Closure'' has a more in depth summary (automation logs, match bets and profit/loss), whereas I believe the export profit and loss report just has the profit and loss report. In my opinion, I think you would benefit more from the 'Export Report on Market Closure''. Again, I'm not 100% sure so hopefully someone else can shed some light if I am wrong

[lisawatsuk1]

lisawatsuk1

Untested but should work
You need to extract a unique list of the data in column B

To do this select G1 then on the ribbon you want data, advanced filter. When the dialogue box pops up your list range will be whats in column B, so select column B.

Leave the criteria box empty, but tick the radio button "Copy to another location", and then select the "Copy To" box and select G1, finally notice theres a tick box in the bottom left hand corner, "Unique records only", tick this

See the formulas in cols H & I to get what you are after (attached just above picture)

Hi nigelk,
I have just tried this method and it has only extracted the meetings and times. I have also tried changing to column D to extract the prices, but to no avail.

[lisawatsuk1]

Lisa, you need to convert the values to numeric value rather than a string using =value(A1) if the text value was in cell A1

Hi Euler,
I have attempted to convert this (assuming I am doing it right) but it seems that it is already in numeric value. The problem is on certain races, the potential profit varies between each horse and when I try to extract that, excel is totalling them up.
I think I am just going to have to accept I will be adding the profits up manually with hope that in the future there will be a way around this

[lisawatsuk1]

Afternoon all,

When I come home from work every evening, I check my betfair account for the daily profit and loss where it will show me my overall winnings or losses. However this will not show when running bet angel on practice mode. Is there a rule in automation or a setting where maybe an excel spreadsheet will CLEARLY show how much I am up or down by without me having to whip out my calculator and total up the profit or loss from each individual market ?
I have previously used the "explore profit reports folder" and I have created a rule to "export profit or loss report" but all it is really showing is the profit or loss in each market (shown in attachment). I still have to manually calculate it. Is there a way of showing an overall total??

I hope this makes sense

lisawatsuk1, i have been a BA User for the last 7 years and must admit it is the best for its automation & guardian works. I use to practice on another bit of kit in the early days and it has a practice mode bank, which really helped me where i am today ie monitering performance, assisting me to change style, stakes to get the income build i want from trading. I have said to the BA team it would be good to have this, every time the upgrades come out it has everything that doesnt interest me, but i upgrade for the sake of it 6 months after, once there has not been to many complants about bugs. So i agree with you a practice figured bank would be good, at the momment i use a spreadsheet and have to pop in returns manually, if i could of connected that up to go in automatically that would of been great, but its in the BA teams hands, go on Peter lets have it

Hopefully BA will find a way to make this happen, it seems quite a few people would benefit from this as well

[nigelk]

I have just tried this method and it has only extracted the meetings and times. I have also tried changing to column D to extract the prices, but to no avail.

Thats exactly how it should be. All you have to do now is enter the formulas shown in columns H & I (expand the column width in col G first) to make it easier to read.

[rhodaewart]

The answer to the original question is "No". Bet Angel has no method of calculating or displaying your daily p/l other than by displaying your betfair account balance when in live mode.

I believe Bet Angel can't calculate your balance because it doesn't actually know who won the event.

I'm new to Bet Angel; I find very little they do is intuitive. I think that they're too close to the problem. They assume the reader already has an adequate knowledge base. This clearly isn't the case or else I wouldn't be writing this post. The whole practise mode feature is rendered redundant if the user is not able to review results of his/her work. I can't believe that Bet Angel have missed this point.

[Derek27]

Using Practice Mode

[foxwood]

Using Practice Mode

+1 +RTFM