One click trading - free program coming soon

[GaryRussell]

Originally posted by: soccergeez
Gaseous,
some more advice would be great if you are around today!
I have the clock installed now so all my prices update automatically during the match. I now need a formula which basically says if the current available price is bigger than my price back the selection, however i only want it to back it once not continually back it every time the prices change and are still bigger than mine.

Also my spreadsheet contains prices for all sorts of markets, correct score, match odds, next goal etc etc is there any way I can have all these markets current prices downloaded from Layit's program at the same time so I could in effect place bets over several markets at the same time?

[GaryRussell]

Originally posted by: The Gambling Monkey
Soccergeez,
Sounds like you need something like:

IF(A2>A1,"BACK","")

in the trigger column, just substitute your relevant cells where I have put A1 & A2.

[GaryRussell]

Originally posted by: The Gambling Monkey
Sorry, forgot the = sign in front of IF.

I'm new to all this Macro & Function stuff but it is very interesting. Hope this helps

[GaryRussell]

Originally posted by: soccergeez
cheers GM I thought that too but how do I stop it then placing another bet a minute later when the price is again bigger than my estimate?

[GaryRussell]

Originally posted by: The Gambling Monkey
If you look just a bit higher in this post LayItYouMug explains how his triggered betting works better than I can. From memory once it has placed a bet, so long as you do not delete the bef ref and bet time it will not place another bet.
Hope this helps.

[GaryRussell]

Originally posted by: soccergeez
Thanks again GM. Do you know if its possible to download more than one market from Layit's program and have them running on the spreadsheet simultaneously?

[GaryRussell]

Originally posted by: The Gambling Monkey
Yes but only three on my computer anyway. I've put up a post earlier asking if three is the maximum or not. Ideally I would want 21; to cover all the day's horseracing.
See if you can get more than three, if you can then it's a problem my end.
Cheers

[GaryRussell]

Originally posted by: soccergeez
Ok I can download a fair few ( got up to 8 then gave up) but the clock only ticks on the last market downloaded so presumably the prices also only change on the last downloaded market, so not much good for me.

[GaryRussell]

Originally posted by: The Gambling Monkey
Are they all on the same spreadsheet or on different ones?
I tried to get it to work with a different market on a different spreadsheet and could only get it to log three.

[GaryRussell]

Originally posted by: soccergeez
It was spread over 2 pages of spreadsheet, 4 on page 1 and 4 on page 2 - did the markets continue to update on yours?

[GaryRussell]

Originally posted by: LayItYouMug
The Gambling monkey.

What exactly happens when you try to add a 4th market?

[GaryRussell]

Originally posted by: soccergeez
Layit, I presume there is nothing I can do to get the markets continually updating on my sheet when I have more than one on there?

[GaryRussell]

Originally posted by: The Gambling Monkey
Hi LayitYouMug,
I've just tried it again with no problems at all. Yesterday it just did nothing when I attempted to log prices to a fourth worksheet. Seems it must have been a problem with my computer.
Thanks once again this triggered betting is dynamite.


Soccergeez,
Thanks for your help but it's fixed now.

[GaryRussell]

Originally posted by: The Gambling Monkey
Soccergeez,
Just got 11 markets up all refreshing normally.

[GaryRussell]

Originally posted by: The Owls are Going Up
Layityoumug

Did you receive my email

Haviton