Hi,
Could anyone tell me how to export the last matched price before the jump to the betangel1 spreadsheet.
Similarly, I also need to be able to download the distance of each race into this sheet in order to automate. It currently has the distance in the name but I need it separated out.
I'm new to this so appreciate the help in advance.
At jump odds
Do you mean just before it goes inplay?
Your second question is quite tricky, it depends on (and this is going to sound obvious), what is in the cell.
I.E. It could start with "Weth" or "Ayr" (both different lengths,) it could be 2m, 2m4f, of 6f
Here's a formula that looks at the spaces in the description,and then extracts the distance, it'll work as long as there are no spaces in the distance description, ie, 2m4f will be fine, but 2m 4f will pose a problem
=LEFT(MID(B1,FIND(" ",B1,20)+1,255),FIND(" ",MID(B1,FIND(" ",B1,21)+1,255))-1)
Nigel
Your second question is quite tricky, it depends on (and this is going to sound obvious), what is in the cell.
I.E. It could start with "Weth" or "Ayr" (both different lengths,) it could be 2m, 2m4f, of 6f
Here's a formula that looks at the spaces in the description,and then extracts the distance, it'll work as long as there are no spaces in the distance description, ie, 2m4f will be fine, but 2m 4f will pose a problem
=LEFT(MID(B1,FIND(" ",B1,20)+1,255),FIND(" ",MID(B1,FIND(" ",B1,21)+1,255))-1)
Nigel
Yes, I mean just before it goes in-play.
Thanks for the help with the distances, but as I trade Australian markets too (distances in m - 1000m etc) the left formulas don't really work unfortunately.
The distance one is not really that important, but I would like to get the odds just before it goes in-play.
Thanks for the help with the distances, but as I trade Australian markets too (distances in m - 1000m etc) the left formulas don't really work unfortunately.
The distance one is not really that important, but I would like to get the odds just before it goes in-play.