Hi,
I have tried searching, but i can't find my answer.
I am trying to find out if the excel sheet used on the tutorial for multiple over/under goals is available for download.This is just what i need.
http://www.betangel.tv/video/trading-on ... runders-ss
I'm afraid my Excel skills are no way near capable of writing that, also is it possible to trade from the excel sheet if you instance you are in profit and what to close, will it place all bets for you?
I was wondering if anyone can point me in the right direction please if it is available.
Many Thanks
Graham
Over/Under goals video
-
beech19721
- Posts: 25
- Joined: Tue Dec 06, 2011 4:31 pm
I have managed to put together the worksheet to see an overall P/L.
I spent ages trying to get it to place the bets, thanks to The Hub, he told me that it won't place if there is something in the Global Status Box.
Now i am unable to get it to place all the bets, as i have "OK" in the Global Status box.
If i delete it, it will place the bet, but then OK will return.
Does anybody know how to get rid of OK or another method i can use.
Many Thanks
Graham
I spent ages trying to get it to place the bets, thanks to The Hub, he told me that it won't place if there is something in the Global Status Box.
Now i am unable to get it to place all the bets, as i have "OK" in the Global Status box.
If i delete it, it will place the bet, but then OK will return.
Does anybody know how to get rid of OK or another method i can use.
Many Thanks
Graham
-
beech19721
- Posts: 25
- Joined: Tue Dec 06, 2011 4:31 pm
=IF(overs!I3="Y","GREEN_ALL","")
That is the formula i have in at the moment.
I would like to just insert a press a button for it to do it, but i am not too hot on excel.
That is the formula i have in at the moment.
I would like to just insert a press a button for it to do it, but i am not too hot on excel.
Hi Graham,
as I understand the situation you are in one sheet and execute that instruction according to the content of the cell I3 of the sheet "overs". The command you execute is relative to the event running in the sheet the command finds itself, but the global command "green_all" is a closing command.. after that nothing else is to be done on that event. So, if you are talking about repeating the same procedure for a different event coming in then you simply have to clear the cell O6 with a line of code in the "worksheet_calculate()" section (rightclick on the sheetname at the bottom and choose "view code"). That line could be very simple - Range("O6").value = "" - but I suggest you be careful because this will probably lock the sheet into a loop as that section is executed continually, like the cells of the sheet. So you need an if statement which only executes the line once.
If I got your problem correctly, please write it here and I'll write a little bit of code that will do the job correctly.
salut
Ennio
as I understand the situation you are in one sheet and execute that instruction according to the content of the cell I3 of the sheet "overs". The command you execute is relative to the event running in the sheet the command finds itself, but the global command "green_all" is a closing command.. after that nothing else is to be done on that event. So, if you are talking about repeating the same procedure for a different event coming in then you simply have to clear the cell O6 with a line of code in the "worksheet_calculate()" section (rightclick on the sheetname at the bottom and choose "view code"). That line could be very simple - Range("O6").value = "" - but I suggest you be careful because this will probably lock the sheet into a loop as that section is executed continually, like the cells of the sheet. So you need an if statement which only executes the line once.
If I got your problem correctly, please write it here and I'll write a little bit of code that will do the job correctly.
salut
Ennio
-
beech19721
- Posts: 25
- Joined: Tue Dec 06, 2011 4:31 pm
Hi Ennio,
thanks for your quick reply.
What i am doing is using the overs page like the video, and say if i am up in 3 games, down in 2, and giving me an overall profit i want to close all trades.
So i want it to click the button,(which i managed to do now) then greenall bets and thats it, no more betting.
but at the moment, it says OK in the status box, if i delete that it places the bet, but only on that page, i have to manually go through all pages and do that.
I want to just, click the button, it close trades on all the running pages, and then close down.
I hope that dosen't sound too confusing.
Graham
thanks for your quick reply.
What i am doing is using the overs page like the video, and say if i am up in 3 games, down in 2, and giving me an overall profit i want to close all trades.
So i want it to click the button,(which i managed to do now) then greenall bets and thats it, no more betting.
but at the moment, it says OK in the status box, if i delete that it places the bet, but only on that page, i have to manually go through all pages and do that.
I want to just, click the button, it close trades on all the running pages, and then close down.
I hope that dosen't sound too confusing.
Graham
Hi Graham,
perhaps you are not familiar with the macro programming of the excel sheets. So I try my best to explain how to clear automaticly the O6 cell as a new event enters each sheet. So I take for granted that the value of 'Overs!I3 is not "Y" then.
you rightclick one of the sheets involved and choose on the drop menu "view code". when you are in the code programming area you pick the Worksheet_calculate() section, if you don't see it already, pick it from the righthand side drop menu.
so you should see:
Private sub Worksheet_calculate()
end sub
you key in the following statement before the End Sub line:
if worksheets("overs").Range("I3").value <> "Y" And Range("O6").Value = "OK" then Range("O6").Value = ""
Make sure the statement is all on the same line!!!
you can then copy and paste this code on each of the sheets you need it and this will clear the cell O6 every time a new event enters.
Hope I've been useful.
cheers
Ennio
perhaps you are not familiar with the macro programming of the excel sheets. So I try my best to explain how to clear automaticly the O6 cell as a new event enters each sheet. So I take for granted that the value of 'Overs!I3 is not "Y" then.
you rightclick one of the sheets involved and choose on the drop menu "view code". when you are in the code programming area you pick the Worksheet_calculate() section, if you don't see it already, pick it from the righthand side drop menu.
so you should see:
Private sub Worksheet_calculate()
end sub
you key in the following statement before the End Sub line:
if worksheets("overs").Range("I3").value <> "Y" And Range("O6").Value = "OK" then Range("O6").Value = ""
Make sure the statement is all on the same line!!!
you can then copy and paste this code on each of the sheets you need it and this will clear the cell O6 every time a new event enters.
Hope I've been useful.
cheers
Ennio
-
beech19721
- Posts: 25
- Joined: Tue Dec 06, 2011 4:31 pm
Hi Ennio,
What can i say, many many thanks indeed, that has worked perfectly, i would have never been able to do that, as you can tell my knowledge of Excel is pretty basic.
Sorry to be a pain, can i just ask one more thing if its possible to do.
Can you only use one function for the global commands, what i was thinking is this.
for games say that are 2-0, and i have backed over 2-5 goals, can i have one function to green all and one function to trade so i break even if it stays 2-0 but lay my stake on over's so i will win only if it's over 2-5 goals.
So say i back over at 2.00 £10-00
game goes 2-0 and now lay odds are say 1.2, can i do a function to lay the £10-00 at 1.2 so i break even if stays 2-0 or win £8-00 if its 3 or more goals.
Hope that is clear.
Thanks so much again.
What can i say, many many thanks indeed, that has worked perfectly, i would have never been able to do that, as you can tell my knowledge of Excel is pretty basic.
Sorry to be a pain, can i just ask one more thing if its possible to do.
Can you only use one function for the global commands, what i was thinking is this.
for games say that are 2-0, and i have backed over 2-5 goals, can i have one function to green all and one function to trade so i break even if it stays 2-0 but lay my stake on over's so i will win only if it's over 2-5 goals.
So say i back over at 2.00 £10-00
game goes 2-0 and now lay odds are say 1.2, can i do a function to lay the £10-00 at 1.2 so i break even if stays 2-0 or win £8-00 if its 3 or more goals.
Hope that is clear.
Thanks so much again.
Hi Graham,
I'm glad I was able to help you. What you ask now seems to require a little more organizing though, and anyway it changes completely the system you set up sofar, because all sheets have one element in common (Overs!I3) being set to "Y" but now you wish to differentiate between various cases.... perhaps you need a different flag for each sheet? perhaps you want a lay statement on the overs line (column L9,L11) which shoots under the right condition? And anyway, how do you know the right score in any given moment?
But to get back to your question the answer is that you can have a statement as complex as you want.. example: IF(overs!I3="Y","GREEN_ALL",IF(OVERS!I3="X","CLEAR_ALL",""))
But as I said above perhaps you cannot do what you want now with a global command, every sheet has to have also some indipendence....
well all the best Graham, cheers
Ennio
I'm glad I was able to help you. What you ask now seems to require a little more organizing though, and anyway it changes completely the system you set up sofar, because all sheets have one element in common (Overs!I3) being set to "Y" but now you wish to differentiate between various cases.... perhaps you need a different flag for each sheet? perhaps you want a lay statement on the overs line (column L9,L11) which shoots under the right condition? And anyway, how do you know the right score in any given moment?
But to get back to your question the answer is that you can have a statement as complex as you want.. example: IF(overs!I3="Y","GREEN_ALL",IF(OVERS!I3="X","CLEAR_ALL",""))
But as I said above perhaps you cannot do what you want now with a global command, every sheet has to have also some indipendence....
well all the best Graham, cheers
Ennio
Hi Graham,
I read your last question again and the solution appears very simple and elegant:
keep your system as it is, so that if there is an overall win you green up, but on every event you put a permanent instruction on the unders to back £2 when the odds are at 5, it should come to the same (elegant, also because when the odds are at 5 or above it must be that the score is at 2). So you can start with the three formulae in place: the one you already put on the overs, the new one on the unders and the global command. The only thing is that you want to make sure that the back on the overs has been placed before shooting the back on the unders, so the formula on the unders could be like this: IF(C9<>0,"LAY",""), column M has 5, column N has 2, so if the odds never reach 5 on the unders no damage is done.
well good luck Graham
Ennio
I read your last question again and the solution appears very simple and elegant:
keep your system as it is, so that if there is an overall win you green up, but on every event you put a permanent instruction on the unders to back £2 when the odds are at 5, it should come to the same (elegant, also because when the odds are at 5 or above it must be that the score is at 2). So you can start with the three formulae in place: the one you already put on the overs, the new one on the unders and the global command. The only thing is that you want to make sure that the back on the overs has been placed before shooting the back on the unders, so the formula on the unders could be like this: IF(C9<>0,"LAY",""), column M has 5, column N has 2, so if the odds never reach 5 on the unders no damage is done.
well good luck Graham
Ennio
-
beech19721
- Posts: 25
- Joined: Tue Dec 06, 2011 4:31 pm
Hi Ennio,
Sorry i not replied sooner.
I can't say thanks enough to you, that works perfectly, i tried it this afternoon and made a good little profit.
I would never have been able to manage any of that, i am sorry for my excel knowledge, i know i am trying to sprint before i can walk really.
Look at the numbers today in running, it's probably better off greening up, but have now only run it twice, so needs a few more tests.
Thanks so much again, really appreciate your help.
Graham
Sorry i not replied sooner.
I can't say thanks enough to you, that works perfectly, i tried it this afternoon and made a good little profit.
I would never have been able to manage any of that, i am sorry for my excel knowledge, i know i am trying to sprint before i can walk really.
Look at the numbers today in running, it's probably better off greening up, but have now only run it twice, so needs a few more tests.
Thanks so much again, really appreciate your help.
Graham
-
beech19721
- Posts: 25
- Joined: Tue Dec 06, 2011 4:31 pm
Sorry, just read the last post, yeah i had changed it to Back.
Thanks
Thanks
Hi Graham
Would there be any chance of you sharing your spread sheet. I’ve just bought Dummies for Excel 2010 and am finding it difficult to get through the introduction, never mind anything else. It would be a big help to have an example sheet to explore and dissect.
Regards Ray
Would there be any chance of you sharing your spread sheet. I’ve just bought Dummies for Excel 2010 and am finding it difficult to get through the introduction, never mind anything else. It would be a big help to have an example sheet to explore and dissect.
Regards Ray
