Balance

[Russell]

Is it possible to make the balance appear as a number in the Excel templates? I am using Excel 2016 and am unable to make any calculations using the balance.

[PeterLe]

It already does
I don't have betangel open at the moment, but I think it's in cell c6
Individual p&l's in c9, c11, c13 etc are vey useful (would love to see this cell ref in guardian automation )


G1 = Displays ‘In-play’ text when market is ‘in-play’
H1 = Display ‘Suspended’ text when the market is suspended.
C3 = Last updated time
C2 = Total money matched
C4 = Number of runners
C5 = Number of unmatched bets in market
C6 = Betfair account balance
F2 = Number of transactions made in past hour
F3 = Published event start time
F4= Countdown to event start

[LeTiss]

Talking of BA Excel, it's a shame BA can't slightly modify an aspect of this, as it's still an excellent way of automating trades. I'm referring to clearing the cell, because this is a pain in the ass. Guardian Automation allows you to place unlimited trades, and if you're scripting is wrong, meaning you place too many bets by mistake - tough shit!

I'd love BA Excel to have an option where we can turn the clearing cell option off/on

[Russell]

Hi PeterLe

I can see the balance clearly, and yes it is in C6. My difficulty is that I am unable to use the value in the balance to perform any calculations, such as stake size - I have attached a screenshot and as you will see if I link the cell to a calculation I get #value. I thought it was a formatting issue but I've tried pretty much every option and I still cant use it.

What I am actually trying to do is to use multiple markets but set a maximum balance so that the markets stop trading when it is reached. I am cautious about over-trading.

Russell

[spreadbetting]

Looks like it's treating the value as text rather than a number,formatted to the left,~value error. Try putting =ISTEXT(C6) in a cell. It'll show as TRUE for a text value or FALSE if it's a number.

Dunno what version of excel you use but you could simply convert it to a number using

=VALUE(C6)/300

I don't use the BA spreadsheets so surprised if it's being sent as text and probably an easier fix but that should sort it out til someone comes along with the proper answer. Maybe be something as simple as right clicking the C6 cell and formatting it as currency.

[foxwood]

It is the currency sign causing it to being taken as text.

I use the balance as a true number in a cell on another sheet - populated with formula ...

Code: Select all

=RIGHT('Bet Angel'!C6,LEN('Bet Angel'!C6)-1)*1

The "*1" was needed to convince Excel it was a number.

You could simply refer to the balance value directly as a number using the "N" function as shown below wherever a reference to "C6" is required ...

Code: Select all

N(RIGHT('Bet Angel'!C6,LEN('Bet Angel'!C6)-1))

[spreadbetting]

The VALUE function is the inbuilt function to convert text to numbers, much easier than using RIGHT and muliplying by 1, try VALUE as it'll give the same result

=VALUE('Bet Angel'!C6)

[Russell]

Foxwood, that was inspired... it worked a treat. Well done and thanks

[foxwood]

The VALUE function is the inbuilt function to convert text to numbers, much easier than using RIGHT and muliplying by 1, try VALUE as it'll give the same result

=VALUE('Bet Angel'!C6)

Doesn't work for me - gives #VALUE!

However ... my C6 currency symbol is different to my default Windows currency symbol - when they are the same then VALUE() works

[spreadbetting]

Yep it uses your default locale settings to extract the number, if you've a newer version of excel (2013 onwards) you could use the inbuilt NUMBERVALUE function which allows you to set your own separators so it's not dependant if your PC settings and C6 settings don't match.