Bet Angel - Example spreadsheets : Percentage made Green All

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

Sun Nov 04, 2012 12:01 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

Sun Nov 04, 2012 12:54 pm

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

Sun Nov 04, 2012 1:11 pm

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

Sun Nov 04, 2012 3:14 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

Sun Nov 04, 2012 3:26 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

Sun Nov 04, 2012 8:41 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

Sun Nov 04, 2012 8:44 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

Sun Nov 04, 2012 8:51 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

Tue Nov 20, 2012 10: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: 3
Joined: Mon Oct 16, 2017 9:20 am

Sat Oct 28, 2017 2:13 am

I take it the selfish........ response was no!

Post Reply

Return to “Bet Angel - Example spreadsheets”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest