New User looking for Tips and Advice

[Jambo]

Hi All,

Had Gruss for a while but never really done too much with the excel outputs but came across something where the output to excel will help massively in play.

These questions might have been asked a million times so apologies if they have been but I couldn't find exactly what I was looking for or a walk through of sorts.

Essentially what I'm doing is exporting my quickpick list to excel, I've got the tracks opening on different windows within BA and then linking those windows to different tabs in my excel workbook.

I'm opening all of the races in the window so they show in excel and then copying formulas down for triggers, along with stakes etc and thought there's got to be an easier way to do this?

I believe that I might need to use VBA for this but.....

Can I just have the once race open per window and it'll cycle through when that race has ended and the next one is about to start? It'll then copy my forumulas that work out a qualifier and then copy my trigger and stakes? Or do I need to do it the way I am doing it and just take the time early in the morning to set it up?

Can the quickpick lists be refreshed daily or do I need to shut down BA and restart or could VBA help with that too?

Also, can I have a few instances of BA running, one for football and one for Horses?

[alrodopial]

1. options/preferences/quick pick list for cycling through races
2. excel/log multiple sheets quick link conected with your "default" excel file with your formulas in clm Q
3. Q2 modifiers - in manual
4. you can use multiple instances as long as you place the bets manually or though exel

manual:

http://www.gruss-software.co.uk/Betting ... e/help.htm

[Jambo]

Thanks.

I was asking Claude some questions earlier and it recommended not having multiple tracks in different tabs and only having them on 1 sheet, but loading 8 at a time, then clearing them down and adding a new race every 15 mins. Of course Ai could be making it up but is that possible too? Is it a wise approach or not if possible?

I had a basic sheet today with 5 tabs for races. In the last 2 I should have had the winner but it didn't seem to back the horses for some reason, It did back others in the race but not the ones I wanted. I was using a simple "back" was that my issue? The back was an if statement and if the odds I'd calculated were hit then a bet should have placed. The odds would have been hit as it then went onto win so not sure why they didn't place.

[alrodopial]

I'm using 10 tabs connected to 10 sheets, one for each Track (not for each race but for each course)
Cycle among the races in every tab/quick pick list eg at 5min before each official off using the settings

For your bet not been placed maybe there was an old bet reff in clmn T?
They can be auto cleared when a race is changed in BA through settings