Percentage made Green All

Example spreadsheets and comments on example spreadsheets.
Post Reply
beech19721
Posts: 25
Joined: Tue Dec 06, 2011 4:31 pm

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.
User avatar
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.
User avatar
pdupre1961
Posts: 410
Joined: Fri Feb 18, 2011 8:01 pm
Location: Morden, London

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.
Sorry, I should have given you this one.
http://www.betangel.tv/video/trading-on ... runders-ss
beech19721
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
You do not have the required permissions to view the files attached to this post.
beech19721
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
beech19721
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
beech19721
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.
beech19721
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
You do not have the required permissions to view the files attached to this post.
Anka
Posts: 23
Joined: Fri Aug 10, 2012 6:09 pm

Hi beech19721

It happened to me this in practice mode. Then I tried for real money (but small stake) and it worked ok. Why? I do not know!
Nice sheet! Do not want to share with us (me)? :roll:
SimRick
Posts: 4
Joined: Mon Oct 16, 2017 9:20 am

I take it the selfish........ response was no!
User avatar
Euler
Posts: 24701
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ

This thread is five years old, pretty sure this has been answered elsewhere. But automation has been introduced since then.
Post Reply

Return to “Bet Angel - Example spreadsheets”