betfair balance

[Guest]

Hi fantastic program thanks , is there anyway i can my betfair balance suitably refreshed into the spreadsheet ? this would help with stake management. thanks in advance

[mrclox]

Hi the above post should be in my username mrclox

[GaryRussell]

Not at present, but I will add this ability in the near future. I don't think I'll make it update on every refresh as this could put an unnecessary load on Betfair's server. I may provide a custom function you can use in Excel which will query the site when needed.

[mrclox]

ok thanks in that case is there a routine i could use in a spreadsheet to get the balance myself? the get data doesnt refresh the balance

[GaryRussell]

Unfortunately not.

[mrclox]

ok thanks for your help ... is there a way that i can make a cell remember a number when the reason the no. is there has gone? does that make sense?

[GaryRussell]

The question makes sense. As far as I know you would have to resort to writing a custom function in VBA. When I put the example spreadsheets up I will include something.

If someone has already done this I would be grateful if you could post the answer here.

[monkey]

Here is something which might work

Eg: you wanted to remember the home price in a football match when the match was suspended.

For this example
Cell A1 = Home Price
Cell A2 = Match Status

Cell A3 = Cell to be kept

=IF(A2="Suspended",A3,A1)

This will constantly update cell A3 with the latest price but will refer to its self if the match is suspended.

The only downside is a circular reference is created, this can be solved by selection OPTIONS and setting the number of itterations to 1.

[Captain Sensible]

could be included in the spreadsheet. So you could balance books when various bets have been triggered.

[mrclox]

thanks can i read the data into another cell if it is a circular reference

[mrclox]

ok sorted now thanks , anyone interested you can import your balance from betfair lite and this refreshes automatically!!