Gruss Forum • View topic

by **soccergeez** » Mon Mar 06, 2006 10:09 pm

when I use the triggered betting facility with Excel column u on my sheet shows the P&L figures from the BT software. However although they can be seen on the sheet Excel doesn't seem to be aware they are there as they are not being picked up by the calculation cells on the sheet. If however I manually type the same P&L figures into column U the calculation cells recognise the figures & update perfectly.
Anyone got any ideas how to sort this out?

by **Ian** » Tue Mar 07, 2006 8:51 am

Have you just got one figure in col U ? I have no problem reading this figure into formulas but if there are two - say, on the place market - you will have to split the cell into two new cells.

by **soccergeez** » Tue Mar 07, 2006 11:21 pm

The profit and loss figures go into u14, u15 & u16. I then have the formula =max (u14:u16) in cell f1 however this cell never recognises the P&L figures unless I manually input them.

by **Ian** » Wed Mar 08, 2006 6:04 pm

Doesn't F1 get updated on every refresh ?

by **soccergeez** » Wed Mar 08, 2006 6:13 pm

It doesn't update at all just staying at 0.00 when using the figures from BA. If I have manually typed in the P&L to column U F1 recognises it, however as soon as BA refreshes and updates column U again F1 goes back to 0.00 again.

by **Ian** » Wed Mar 08, 2006 6:40 pm

That's what I would expect it to do - try putting the formula in, say, Z1 instead of F1. I've used exactly this same formula in one of my spreadsheets with no problems.

by **soccergeez** » Thu Mar 09, 2006 12:06 am

Just tried it, still no good I'm afraid. It must be something to do with Excel not recognising the BA P&L figures, so it thinks column U is empty when its not.

by **Mitch** » Thu Mar 09, 2006 12:17 am

Are you in the UK?

Just a thought... I think BA makes allowances for different decimal seperators in the stakes but maybe not in the P/L.

If you are in the UK I'll get me coat :oops:

by **soccergeez** » Thu Mar 09, 2006 12:27 am

I'm in the UK!

by **tkp** » Thu Mar 09, 2006 12:31 am

This is intriguing - I don't seem to have a problem with this.......

does this happen in every spreadsheet you've tried it in?

Can you send an example spreadsheet ? (you needn't send your whole "system" if you don't want to).......

send it to

nortonphilster at gmail dot com

tkp

by **soccergeez** » Thu Mar 09, 2006 12:43 am

tkp,
Its coming over now - its actually something someone else put together for me and it works fine on their Excel, therefore I assume its some setting or option i need to adjust on mine but God knows what. Its driving me mental

excel trouble

excel trouble

Who is online

Sports betting software from Gruss Software