Excel In Play

[aubweaver]

Hi All,
This is a two part question concerning excel. ALL IN PLAY
1. Can I have a BACK bet and a LAY bet on the one sheet., i.e. will a LAY bet be submitted after a BACK bet has been matched (or vice versa)?
I don't want to clear the bet refs for the fear of submitting further BACK (or LAY) bets.
At the moment I have 4 separate worksheets linked and I set it up on separate 'BetAssistant' pages. This works fine but can be a bit cumbersome setting up.
This leads me to my second'Q'.
2. At present I select on the quick pick list all UK Win (I may also consider Irish as well if I can overcome the problem). I then delete any possible conflicting races. ie a new race will load before the last race is finished and the end is where the action is and I often have open bets in the market. Q. Can I have the next race load after the present race has finished (I realise I may miss the beginning but this might not be a problem).
I have in the past simply doubled up on the Bet Assistant pages and then separate all the races accordingly but I would then have 8 pages and worksheets logged on and I'm not sure whether this could cause issues with Betfair downloads?? Hence having BACKS and LAYS on one sheet will at least halve the present set up.
I hope I've explained the above well enough, any suggestions would be appreciated. Thanks,
Peter.

[alrodopial]

1. After the first bet been placed place a flag so no further bets of the same type are fired and if in the bet reff is a number clear the reff.
2.At the start of the day you can loop through all the races in your quick list , download all their ids and then using the GOTO:"id" in cell Q2 you can go at whatever race you want, in your case at the next race if the current one has finished.
For downloading this basic info I have posted a sheet that works fine some time ago, it's somewhere here.

[aubweaver]

Thanks for your quick response. The 'goto' function is basically a quick find manual function in excel (unless I'm missing something..?). I wanted the next race to load automatically at the end/finish of the preceding race. This is because being in Australia all the UK racing is between 11pm and 7am. Anyway I think I may have overcome this part of the question.
Sometimes I just make things hard for myself.... I presently have 4 worksheets with various parts 'linked' so what the results are on one sheet is sent to another sheet thereby allowing that sheet to respond accordingly ie place a bet if certain criteria is met etc. However the one thing I didn't have linked were the actual races 'DUMBO' I now have linked columns A to Y eliminating the need to have each worksheet loaded to a new BA page. I will still end up with two sets of four sheets but only the two main sheets will need to be logged on, hence two BA pages, I can then have 'x' amount of races on each page leaving a good space between each.
The answer to the other Q would still be good, 'stop loss/ tick offsets' etc. as this will cut down the other linked worksheets and possibly work better.
Thanks Again,
Peter.

[alrodopial]

I wanted the next race to load automatically at the end/finish of the preceding race.

It can be done with little VBA and the "goto:id"

[aubweaver]

Thanks again I will look into that. You also mentioned placing a flag so that no further bets of the same type woud be entered, I havent found any info on how to do that..? Could you please assist or point me in the right direction?
Cheers,
Peter

[alrodopial]

Can you adapt the below?

http://rapidshare.com/files/455006130/f ... r_bets.xls

You must also change the formulas in columns F,BA,BB

Not tested, so be careful.

[aubweaver]

Thanks for the 'link' but it lead me to a RapidShare open an account page. Which after a few hiccups I managed to do and then I couldn't find any means to download the file..? I've sent RapidShare an email and await their response. Hopefully I'll soon be able to view the information.
Thanks again for your help.
Peter

[mak]

follow the link again, and choose "slow download" wait a few seconds and download...there is no need to sign up

[aubweaver]

Thanks Mak,
I received your notification into my email with a link to the Gruss forum and the associated the messages,all exactly the same as when I enter the forum via Bet Assistant. However this time I got the page you referred to "Fastdownload or Slow download", this did not happen before.
Am I going MAD, I then went into bet assistant into the same forum, same series of messages and it didn't work, all I got was the RapidShare registration page. Not to be beaten I tried back and forth three more times with exactly the same results....via BA and the forum didn,t work, via my email box into the forum it worked....the mind boggles???
Thankyou, It looks promising I actually was trying to do something similar yesterday but to no avail, I'll look into it further probably tomorrow.
Many Thanks,
Peter

[aubweaver]

Hi ,
Thanks for the excel info re setting up a 'flag' to stop re-entering a bet.
I've had a good look at it and I can only see it working if you enter the letter 'Y' in BC5 or BD5 manually as a BACK or a LAY occurs and then clear it at the finish, ready for the next race. This would possibly work if you can monitor every race and act accordingly. Of course the problem with 'In Play' is that the criteria is forever changing and there's nothing to differentiate between a BACK bet or a LAY bet that is left on the excel worksheet, otherwise it would be easy, all we know is that a bet has been matched in the matched odds and stakes columns but nothing to show which type, unless I've missed it somewhere..??
Have I got it right ?
I might have to stick to the separate linked worksheets at the moment and load up additional BA pages. Any suggestions would be appreciated.
Thanks,
Peter