Gruss Forum • View topic

by **vilnius** » Thu Feb 25, 2010 1:37 pm

Hi

Is it possible to load the runners in saddleclth order to excel?

When I load a market into excel it always loads in the not sorted order no matter which order I have it in on BA

Regards

Al

by **GaryRussell** » Thu Feb 25, 2010 1:41 pm

See http://www.gruss-software.co.uk/forum/v ... excel+sort

by **vilnius** » Thu Feb 25, 2010 2:04 pm

Thanks Gary

I have had a look at this and it does not help me, would it not be possible to have the choice as to how the list of runners was imported into excel? Saddlecloth number alphabetical order etc.

Regards

Al

by **GaryRussell** » Thu Feb 25, 2010 2:09 pm

We have no plans to do this. Why do you need them in saddlecloth order? I am sure you can achieve what you need by using the rank function.

by **vilnius** » Thu Feb 25, 2010 2:19 pm

I want to compare a selections price on betfair at a given time against the live show price in percentage terms.

To do this I am importing the live show data in saddlecloth order as this remains constant.

by **GaryRussell** » Thu Feb 25, 2010 2:22 pm

You could use the vlookup function on the saddlecloth number to match the imported data to the BA data.

by **vilnius** » Thu Feb 25, 2010 2:31 pm

Maybe Gary but I just want to load the data, do a quick calculation and get out again, I don't have the time to start entering complex (for me) functions.

If the list of runners went into excel in saddlecloth order that would be fine.

Al

by **GaryRussell** » Thu Feb 25, 2010 2:41 pm

It's not as easy for me to do that as you might think. It could cause all sorts of problems if not done properly and will require a lot of testing. To add a lookup function to your spreadsheet would take 5 minutes. I'll even help you do it if you send me a copy of the spreadsheet.

by **vilnius** » Thu Feb 25, 2010 2:48 pm

I will send you a sample spreadsheet Gary, thanks,

Al

by **Ian** » Thu Feb 25, 2010 3:13 pm

As a matter of interest where are you getting a live show from that is in saddlecloth number order ?

by **vilnius** » Thu Feb 25, 2010 7:43 pm

Hi Ian

I am taking the live show from billys, how the market is viewed can be customised by clicking the relevant column header.

Rgds

Al

by **Ian** » Fri Feb 26, 2010 8:50 am

I think Billy's is the best site for getting the live show - I do a vlookup on the horses name.

by **mak** » Fri Feb 26, 2010 9:50 am

hi,
can you give a link for that site please?

by **Ian** » Fri Feb 26, 2010 10:12 am

Billys is William Hill :wink:

by **mak** » Fri Feb 26, 2010 10:18 am

Ian wrote:Billys is William Hill

thanks

Saddlecloth order in excel

Saddlecloth order in excel

Who is online

Sports betting software from Gruss Software