Sorry, one more question.
I have my over 2-5 goals sheet done, i would like to know if the following is possible.
I have a green all option set up for 12 different games on over 2-5 goals.
I would like it to automatically green all when i reach the required % profit that i have selected, i have a column with total stake and % profit,so once i am in profit say 15%, it automatically greens up.
Hope i explained it properly and any help if this is possible greatly appreciated.
Percentage made Green All
- pdupre1961
- Posts: 410
- Joined: Fri Feb 18, 2011 8:01 pm
- Location: Morden, London
Have a look at this video to connect markets in spreadsheets.
http://www.betangel.tv/video/trading-on ... s-football
Should give you an idea of what can be done.
http://www.betangel.tv/video/trading-on ... s-football
Should give you an idea of what can be done.
- pdupre1961
- Posts: 410
- Joined: Fri Feb 18, 2011 8:01 pm
- Location: Morden, London
Sorry, I should have given you this one.pdupre1961 wrote:Have a look at this video to connect markets in spreadsheets.
http://www.betangel.tv/video/trading-on ... s-football
Should give you an idea of what can be done.
http://www.betangel.tv/video/trading-on ... runders-ss
-
- Posts: 25
- Joined: Tue Dec 06, 2011 4:31 pm
Hi,
Thanks for your reply.
I have done that, i am on the next stage, i have attached a copy of the page.
Once the cell J24 equals cell S20 i want to it to automatically green all, if that makes sense, so say if i want to make 40% profit ie J24, if S20 reaches 40, ie 40% profit it will automatically green all for me.
Many Thanks
Graham
Thanks for your reply.
I have done that, i am on the next stage, i have attached a copy of the page.
Once the cell J24 equals cell S20 i want to it to automatically green all, if that makes sense, so say if i want to make 40% profit ie J24, if S20 reaches 40, ie 40% profit it will automatically green all for me.
Many Thanks
Graham
You do not have the required permissions to view the files attached to this post.
-
- Posts: 25
- Joined: Tue Dec 06, 2011 4:31 pm
think i have done it, was simple in the end, i was looking for something complicated, i just for the IF formula in the GreenAll cell.
Just put If J24 = S20 if true Y, and Y is teh green all macro.
Thanks for your help
Just put If J24 = S20 if true Y, and Y is teh green all macro.
Thanks for your help
-
- Posts: 25
- Joined: Tue Dec 06, 2011 4:31 pm
Well it works in principal, but for some reason when it comes to LAY, it lays about 20 times, so backs the £2-00 stake once, lays various amountsa lot about 20 times.
Does anybody know why it might do this.
many Thanks
Does anybody know why it might do this.
many Thanks
-
- Posts: 25
- Joined: Tue Dec 06, 2011 4:31 pm
here is a picture
You do not have the required permissions to view the files attached to this post.
-
- Posts: 25
- Joined: Tue Dec 06, 2011 4:31 pm
When i press Green up manually, this is what i get, 1 lay bet.
Does anybody know why i get such different outcomes?
Thanks
Does anybody know why i get such different outcomes?
Thanks
You do not have the required permissions to view the files attached to this post.