live score excel triggers

[burdo77]

Hi there, i am trying to set up triggers to bet with excel using live scores for football.

THe main problem is that the scores are displayed as, eg, 1-0 within the one cell.

How do count the cell as "1" if the cell contains
1-0 or 0-1?

CHEERS

[nigelk]

Assuming the scoreline is in B4, the following formula will return 1 if either score is a 1, else it will return FALSE

=IF(LEFT(B4,FIND("-",B4,1)-1)="1",1,IF(MID(B4,FIND("-",B4,1)+1,LEN(B4))="1",1))

[verycrispy]

how do you get the live score in excel? thanks in advance!

[burdo77]

thanks a million, that is one hell of an if command!
I dont really understand it, but hopefully it works.

In regauds to live scores find a live scores site such as livescore.com,

open up your excel page such as,
1)multiple template within guardian
2) click on data
3) click from web
4) insert web page address eg livescore.com into new web query, click GO.
5) Insert table that you want that includes your game required.
6) once pasted, click data again
7) go to properties, change refresh time to 1min, click OK and thats it.

This is probably a roundabout way to do this. but if anyone has a better method, or better site to use please let me know?

[LeTiss]

You guys need to tread very carefully

Invariably, BF have re-opened their markets after a goal has been scored, before websites showing latest scores have been updated

If your script doesn't have any safety nets, your trousers will be around your ankles before you can say "equaliser"

[6thSense]

This thread may help also:

viewtopic.php?f=19&t=7148&start=20

[burdo77]

I take your point Letiss, it is a valid one.