| Author |
Message
|
| heinz_pt |
 Posted: Mon Feb 27, 2012 11:51 pm Post subject: Problems with one trigger |
 |
|
Joined: 21 Feb 2012
Posts: 24
|
Hello everyone, I have been testing the Excel triggers, using two markets simultaneous.
In the second market, I've this trigger:
BACK-TL-101-SL-65-SL-IPC
Made the back at 1.65, and then made a lay at 1.66????
I don't understand, the trigger is made by automatically, calculating the offset and the stop-loss:
The ticks that gave was -101 and -65. Is the minus signal?
thanks. |
|
| Back to top |
|
 |
| faibo |
| Posted: Tue Feb 28, 2012 12:21 am Post subject: |
|
|
Joined: 18 Sep 2011
Posts: 23
|
The trigger is wrong. Read the help file again.
You want something like "BACK-T2".
That's 2 ticks offset. "BACK-T-2" would be -2 ticks offset. The same for SL |
|
| Back to top |
|
|
| heinz_pt |
| Posted: Tue Feb 28, 2012 12:24 am Post subject: |
|
|
Joined: 21 Feb 2012
Posts: 24
|
For further help the formulas, for the ticks are:
For the offset
offset = (back odd - lay odd)* 100
Stop loss = IF(back odd < 2.01; (back odd- lay odd)*100; (2- back odd)*100 + (back odd -2)*50) |
|
| Back to top |
|
|
| heinz_pt |
| Posted: Tue Feb 28, 2012 12:25 am Post subject: |
|
|
Joined: 21 Feb 2012
Posts: 24
|
Thanks you are right.
Didn't saw the minus signal- |
|
| Back to top |
|
|
| heinz_pt |
| Posted: Tue Feb 28, 2012 11:17 pm Post subject: |
|
|
Joined: 21 Feb 2012
Posts: 24
|
Hello again still having problems with the triggers:
LAY-TL69-SL14-SL-IPC
My understanding of this trigger is:
Lay at 1.52
TL69 = Tick Offset bet with Auto Level Profit where 69 ticks up (Back at 2.42)
SL14-SL = Sliding Stop Loss where 14 represents the number of ticks down (Back at 1.3
The trigger made this moves:
Lay at 1.52 - correct
Back at 1.48 - wrong?????
Can anyone help me? |
|
| Back to top |
|
|
| GaryRussell |
| Posted: Wed Feb 29, 2012 6:51 am Post subject: |
|
|
Site Admin
Joined: 18 Nov 2005
Posts: 8095
Location: Birmingham, UK
|
| Are you sure that the back below your original lay odds wasn't a result of the stop loss being triggered? Remember a back bet can get matched at higher odds than requested which will explain why it is not 14 ticks below. You should look in the transaction log under the account menu to see if the tick offset and stop loss bets were triggered and at which odds. I am pretty sure you are not seeing the full picture here. |
|
| Back to top |
|
|
| heinz_pt |
| Posted: Wed Feb 29, 2012 11:30 am Post subject: |
|
|
Joined: 21 Feb 2012
Posts: 24
|
I can only see the log, later in the day, after work. But i'm going to put were another problem i'm having.
I keep getting the 1004 error and I can understand why is it happening. I'm working on the excel that is connect to BA. Is there any special configuration that i have to do.
I'm doing a simple command
Sub Tempo()
Dim hora_folha As Date
Dim hora_comparar As Date
' hora_folha = Sheet1.Cells(2, D)
hora_comparar = TimeValue("00:15:00")
Sheet1.Cells(10, Z) = 1 it gives me the error where
' If hora_folha < hora_comparar Then
' Sheet1.Cells(10, Z) = 1
'Else
' Sheet1.Cells(10, Z) = 0
'End If
End Sub
Thanks |
|
| Back to top |
|
|
| heinz_pt |
| Posted: Wed Feb 29, 2012 11:43 am Post subject: |
|
|
Joined: 21 Feb 2012
Posts: 24
|
| GaryRussell wrote: |
| Are you sure that the back below your original lay odds wasn't a result of the stop loss being triggered? Remember a back bet can get matched at higher odds than requested which will explain why it is not 14 ticks below. You should look in the transaction log under the account menu to see if the tick offset and stop loss bets were triggered and at which odds. I am pretty sure you are not seeing the full picture here. |
A question if it was the stop loss triggered, it was triggered to soon. Right or in using wrong the triggers? |
|
| Back to top |
|
|
| GaryRussell |
| Posted: Wed Feb 29, 2012 11:59 am Post subject: |
|
|
Site Admin
Joined: 18 Nov 2005
Posts: 8095
Location: Birmingham, UK
|
| heinz_pt wrote: |
| GaryRussell wrote: |
| Are you sure that the back below your original lay odds wasn't a result of the stop loss being triggered? Remember a back bet can get matched at higher odds than requested which will explain why it is not 14 ticks below. You should look in the transaction log under the account menu to see if the tick offset and stop loss bets were triggered and at which odds. I am pretty sure you are not seeing the full picture here. |
A question if it was the stop loss triggered, it was triggered to soon. Right or in using wrong the triggers? |
Maybe you are not aware of how the stop loss functions. If the lay bet is matched at 1.52 and the best lay odds go to 1.38 or below then the stop loss will be placed at the best lay odds minus 1 tick.
You also specified sliding stop loss so if the lay odds went up to 1.62 then the stop loss trigger odds are reset to 1.48 therefore they only have to go down to 1.48 to be triggered. This could also be the reason why you think it was triggered too early. If you don't want this to happen then don't specify the sliding option. |
|
| Back to top |
|
|
| GaryRussell |
| Posted: Wed Feb 29, 2012 12:10 pm Post subject: |
|
|
Site Admin
Joined: 18 Nov 2005
Posts: 8095
Location: Birmingham, UK
|
| heinz_pt wrote: |
I can only see the log, later in the day, after work. But i'm going to put were another problem i'm having.
I keep getting the 1004 error and I can understand why is it happening. I'm working on the excel that is connect to BA. Is there any special configuration that i have to do.
I'm doing a simple command
Sub Tempo()
Dim hora_folha As Date
Dim hora_comparar As Date
' hora_folha = Sheet1.Cells(2, D)
hora_comparar = TimeValue("00:15:00")
Sheet1.Cells(10, Z) = 1 it gives me the error where
' If hora_folha < hora_comparar Then
' Sheet1.Cells(10, Z) = 1
'Else
' Sheet1.Cells(10, Z) = 0
'End If
End Sub
Thanks |
You cannot refer to cells in that way unless "Z" is a variable. Because Z is uninitialised it's value is 0 and therefore you are trying to reference a cell out of range. I assume you want to access cell Z10. The following would work.
or
| Code: |
| Range("Z10").Value = 1 |
|
|
| Back to top |
|
|
| heinz_pt |
| Posted: Wed Feb 29, 2012 2:27 pm Post subject: |
|
|
Joined: 21 Feb 2012
Posts: 24
|
| GaryRussell wrote: |
| You also specified sliding stop loss so if the lay odds went up to 1.62 then the stop loss trigger odds are reset to 1.48 therefore they only have to go down to 1.48 to be triggered. This could also be the reason why you think it was triggered too early. If you don't want this to happen then don't specify the sliding option. |
That might be the reason, I tought that was trailing stoploss. Is this option available by trigger?
Thank you for the help, it was been very usefull. |
|
| Back to top |
|
|
| GaryRussell |
| Posted: Wed Feb 29, 2012 5:47 pm Post subject: |
|
|
Site Admin
Joined: 18 Nov 2005
Posts: 8095
Location: Birmingham, UK
|
| We call it sliding stop loss, but I always considered it to be the same as trailing. What would you expect a trailing stop loss to do different to our sliding stop loss? |
|
| Back to top |
|
|
| heinz_pt |
| Posted: Wed Feb 29, 2012 9:48 pm Post subject: |
|
|
Joined: 21 Feb 2012
Posts: 24
|
Is because of too fast odd movement.
For example:
If I have stop loss at 1.35, when the boot identifies the and triggers the bet, during the 5 seconds that the bet as to wait to be available, the odd drops to 1.30, the stop loss, will not enter.
My idea is for the bot, chase the falling odd.
This example is if you do a lay and the stop loss is a back. |
|
| Back to top |
|
|
| heinz_pt |
| Posted: Wed Feb 29, 2012 10:01 pm Post subject: |
|
|
Joined: 21 Feb 2012
Posts: 24
|
What's the difference between:
Requests level loss Stop Loss and Requests level loss Stop Loss ? |
|
| Back to top |
|
|
| heinz_pt |
| Posted: Thu Mar 01, 2012 1:02 am Post subject: |
|
|
Joined: 21 Feb 2012
Posts: 24
|
First off all thank you guys for your patience!!!
One more question: Is there a way to put in a excell the start time off the event?
E now that in VBA is an object: startTime but i can make it work.
This is the code:
Private Sub ba_evenid()
If ba Is Nothing Then
Set ba = New BettingAssistantCom.ComClass
End If
event_id = Range("N1")
events = ba.getEvents(event_id)
Cells(i, 6).Value = events.startTime
End Sub
The error is: Run-time error '424'
Object required |
|
| Back to top |
|
|
|
|
