Newbie question re Excel Spreadsheets.

[Art Decko]

Hi, just getting to grips with gruss...(hopefully)

Can anybody point me in the direction of a preconfigured spreadsheet which will link to Bet assistant and which will allow me to type in the names of selections, along with required odds both back and lay, the back odds to be taken 30 seconds before the race (if reached) , and the lay bets to be kept in-running?

I am sure this question has been asked a thousand times, but, I am new here ...

TIA[/b]

[Captain Sensible]

Just use the sample sheet http://www.gruss-software.co.uk/Excel/Place_Bets.xls , set your sheet to auto select the markets 30 seconds before the off , use trigger BACK for back bets and trigger LAY-IP for any lay bets

[Art Decko]

Thank you for taking the time to reply, Captain, but I have to shamefacedly admit that that spreadsheet might as well be written in Chinese as far as my being able to comprehend or make use of it is concerned. I have no idea what all the #N/A's are about, and what half the column headings are referring to.

Maybe I'll just stick to inputting the bets manually.

[Captain Sensible]

No problem , here's the instructions to the sheet

http://www.gruss-software.co.uk/Excel/E ... etting.htm

The #N/A's just mean not available as the horse names hasn't been matched you can turn that type of error reporting off if needed. If it's just as easy to do for you manually just stick to that no point in complicating things using automation if it's not going to bring any additional benefits

[Art Decko]

Thank you for that further post, Captain, and having read through the instructions, toggling back and forth between instructions and sample spreadsheet, I think I am beginning to understand it.

Am I correct in thinking that Columns A through to Y contain historical data which is automatically inserted into the spreadsheet after the race is over, and which can be accessed for research purposes ?And would the list of horses be the total number of runners in the field, or just the horses which were selected to back and/or lay?

Finally, and this may be a really stupid question, but I am not totally clear on the issue, it would appear to me that if you want to both back and lay a horse, you need to enter the name of the selection twice, and each row is a separate bet, it can't be done on one row. Or am I missing something very obvious ?

I know that I will look back at this thread in a few months time and think "How could I have been so thick ..."

[Captain Sensible]

The data A to Y is live data that Betting assistant exports to excel it includes all runners. As soon as you move to the next market new data is populated into excel so you'd have to look at using vba etc if you wanted to collect data.

I've never used the sheet so no idea if it'll accept backs and lays for the same runner, the original thread here http://gruss-software.co.uk/forum/viewtopic.php?t=3557 looks like a separate sheet has been added to do that. Otherwise you have plenty of options with the triggers if you want offset bets placed after you've been matched if you're looking to 'trade' a runner