Problems with one trigger

[heinz_pt]

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.

[faibo]

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

[heinz_pt]

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)

[heinz_pt]

Thanks you are right.
Didn't saw the minus signal-

[heinz_pt]

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.38)

The trigger made this moves:
Lay at 1.52 - correct
Back at 1.48 - wrong?????

Can anyone help me?

[GaryRussell]

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.

[heinz_pt]

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

[heinz_pt]

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?

[GaryRussell]

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.

[GaryRussell]

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.

Code: Select all

[Z10] = 1

or

Code: Select all

Range("Z10").Value = 1

[heinz_pt]

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.

[GaryRussell]

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?

[heinz_pt]

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.

[heinz_pt]

What's the difference between:
Requests level loss Stop Loss and Requests level loss Stop Loss ?

[heinz_pt]

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