Excel Bet/Lay command

[Gareth1976]

Hi guys

Ive been playing about in excel but every time I try enter a trade an ERROR is shown in the status window.

Have I done something wrong? if so please can you help?

here is my "command": LAY [OFFSET:30] [WITH_GREENING:TRUE][STOP:10][TRAILING_STOP:TRUE]KEEP_ALL

Thanks for the help in advance

Gareth

[CallumPerry]

Hi Gareth,

Which cell did you write this command into? You need to tell Excel WHEN you would like the LAY bet to be made so for example, in Cell L9 I need to write a command for the selection at the top of the market. The cells I imagine you'd be interested in are G9:H10 (Best back price and money waiting there and best lay price and money waiting there). A simple trigger would be as follows:

=IF(G9<10,"BACK","")

What this is saying here is: If the BACK price is LESS THAN 10 then "BACK", if it isn't then do nothing (or show a blank cell). To make the trigger more complex you'd add to the 'G9<10' part. The LAY [OFFSET:30] [WITH_GREENING:TRUE][STOP:10][TRAILING_STOP:TRUE]KEEP_ALL rule you want would be substituted in for "BACK" in my example and that should get you going.

Don't forget you also need to fill out the Odds (M9) and Stake (N9) cells, I suggest, before you delve any deeper, that you watch the following videos and then if you still have any questions, post back here

https://www.youtube.com/user/betangeltv ... preadsheet

[eightbo]

1. Remove the square brackets, they're just for example
2. The KEEP_ALL command is a separate command. You'll want to first tell excel about your bet then when it's reached the market you can change its status in the Global Command area:
— — — — — — — — — — — — — — — — — — — 

◘.PNG

Code: Select all

LAY OFFSET:30 WITH_GREENING:TRUE STOP:10 TRAILING_STOP:TRUE

KEEP_ALL

[Gareth1976]

Hi Gareth,

Which cell did you write this command into? You need to tell Excel WHEN you would like the LAY bet to be made so for example, in Cell L9 I need to write a command for the selection at the top of the market. The cells I imagine you'd be interested in are G9:H10 (Best back price and money waiting there and best lay price and money waiting there). A simple trigger would be as follows:

=IF(G9<10,"BACK","")

What this is saying here is: If the BACK price is LESS THAN 10 then "BACK", if it isn't then do nothing (or show a blank cell). To make the trigger more complex you'd add to the 'G9<10' part. The LAY [OFFSET:30] [WITH_GREENING:TRUE][STOP:10][TRAILING_STOP:TRUE]KEEP_ALL rule you want would be substituted in for "BACK" in my example and that should get you going.

Don't forget you also need to fill out the Odds (M9) and Stake (N9) cells, I suggest, before you delve any deeper, that you watch the following videos and then if you still have any questions, post back here

https://www.youtube.com/user/betangeltv ... preadsheet

Hi Callum

Just after I wrote the post I realised where the "KEEP_ALL" should be placed (L6).

What I am trying to achieve using excel is to create a bot that records the days trading. The recording side of things is nearly complete. I was just struggling with excel to actually place the entry trade.

Thanks for posting a link to the excel videos, those are the ones that sparked me off down this rabbit hole into the world of MS excel.

Gareth

[Gareth1976]

1. Remove the square brackets, they're just for example
2. The KEEP_ALL command is a separate command. You'll want to first tell excel about your bet then when it's reached the market you can change its status in the Global Command area:
— — — — — — — — — — — — — — — — — — — 

◘.PNG

Code: Select all

LAY OFFSET:30 WITH_GREENING:TRUE STOP:10 TRAILING_STOP:TRUE

KEEP_ALL

Thank you, No doubt I will have more questions in the week.

Gareth

[Gareth1976]

I've just remembered my next question.

In the spreadsheet "BetAngel_Multiple" there is no stall draws for the horses. Is there a way of adding that information into the spreadsheet?

Or should I start a new thread for this question

Thanks again

Gareth

[CallumPerry]

Eightbo, I love your dark colour scheme!

There is a section on this forum for workbooks which record the markets. I'm using one currently just to add some fresh 1 second interval data to my collection actually. The hard work has already been done for you if you look in the example spreadsheets section of this forum.

Have a read of this for additional settings:

https://www.betangel.com/user-guide/exc ... _data.html

[Gareth1976]

Eightbo, I love your dark colour scheme!

There is a section on this forum for workbooks which record the markets. I'm using one currently just to add some fresh 1 second interval data to my collection actually. The hard work has already been done for you if you look in the example spreadsheets section of this forum.

Have a read of this for additional settings:

https://www.betangel.com/user-guide/exc ... _data.html

I thought the same when I saw his dark layout. looks very professional.

Dam, there is soo much to this excel and betangel. some good reading to be done.

Thanks again Callum

Gareth