RE my Excel pgm
 

Hi all,
before we go to far, let me just say that.
This dingo programme is not that flash, it does tell me what i have to do and calculates what i said it does however, it doesnt interface with anything externally like tabs (im not that good) and it doesnt have macros, i am working on that.
I will post it below for anyone that wants to have it,....please i am useless in excel but as i said it works for me.
just over type the venue cells, stick in the secection and dollars and the return and away you go,
Hope you all werent expecting too much but i offer what i can!
Thanks lefty, found it !

Cheers Dingo

well i can do that !

Excel Fun
 

Dingo...

Your presentation is much better than mine. Believe it or not, I print out the day's races ON PAPER!. Again I have a macro (cos I'm a lazy sod). I go to WA tab, Racing Info, Today's Races and select all and copy. I click on my macro button and it copies into excel (Special, Text), expands into columns if necessary and deletes all columns except Time, Track, Race and No of Runners. This is then copied into my daily worksheet.

Shaun....

Again with the macro! I copy from WA tab race screen and press my button which pastes into my spreadsheet (Text, Special) and expands into columns. All the details I need are there. If you are interested I can send you a version of the macro I use. It can be adapted if you know your way around macros. If my system pans out I guess one day I will convert it to VB.

As I try to compare lots of data from TAB, I would be very interested in how the interface works. I know it is there because some of the shyster products currently being vilified (quite rightly) on this forum use it. Any information would be appreciated.

Oh, to answer your question, yes I have WA Tab open on two pages one for race details, which I copy and analyse and one on the expert screen. As I said earlier, the last macro statements highlights and copies my selections so I just right mouse once on the expert screen and select paste then press "Log bets". I was interested in your approach in the hope that it would allow me to keep only one screen open and reduce actions by me.

If anyone is interested i can give you formulas for doing different things in excel...i am not an expert on excel but what i need to get done i can...things like....importing prices from ACT TAB/IAS/Spotingbet Australia...maybe a few others have not tried them all......i can also copy the 3 start form from VirtualFormguide and past it in to excel then i can extract any of the information i want from it like Win%/Place%/Average Prizemoney/race dates/finished positions or lengths beaten/race prize money or just about anything listed on that page.....you can then use this information to create your own rateings.....it is not fancy like some can do but it works......problem is comeing up with accurate rateings that work.....this is still an ongoing process....my newest rateings will be tested tomorrow but show promis.

The good thing about importing the prices from these sites is you can have them automaticly refresh so if you are dutch betting you don't have to keep changeing prices then you can send the bets to the tab with a couple of mouse clicks

Hey Shaun & SeeDee,

I've written some software that can import an excel spreadsheet containing your bet details (such as track, race no, horse no, required track condition, win odds range, etc) and then place the bets for you using TABOnline. It waits until the race is about to close before placing the bet (there's some variables you can play around with to get the timing right for this).

The basic idea is that you load your picks at the start of the day and then let the application do all the work.

Currently got a couple of users giving it a bit of a trial run and am looking for a couple more testers. Let me know if you're interested. It's a bit of a work in progress at the moment but it's going pretty well.

I would be interested in haveing a peak...send me an e-mail about what it can do

shaun dot tsisquaya at ozadsl dot com dot au

That email address sounds like one of Kenchars funny conversations in whatever language he uses.

Gungadin
 

I would like to have a look at your system.

Please contact me on crdowd at iprimus dot com dot au

GungaDin
 

I too would be interested in looking at your system. Just for your interest I too am I qualified programmer and have some ideas we could possibly look at working together on? You can email me at:
mail001 at dodo dot com dot au