Open and close a market

[Rastis]

Hi Folks,

I was hoping someone could let me know if it is possible to use the multiple spreadsheet option to open and then close a position thereafter.

IE, in a football market, when odds get to X back/lay at current odds - then when odds get to Y back/lay etc.

My issue is the use of the "Bet Rules" bit of the sheets. I can sort the first trigger/position, however I can't see how or where I could trigger the closing position.

Any thoughts would be great thanks.

Cheers

[James1st]

Rastis,

Simple enough question but quite a few caveats in the solution.

Presumably you don't want bet Y submitted unless bet X is taken? "Unmatched bet count" (C5) is therefore key to your X bet submission.

However a more complete solution is to write some VB code to cover all the possibilities, including partial acceptance of the stake.

PS Consider using "Last Matched Odds" as a more accurate test than "Current Odds".

When using a spreadsheet for trading it is always best to think of all the things that can go wrong and then double the number of belts and braces you employ.

[LeTiss]

We've seen some people suffer major losses due to badly written bots

My advice on 'in play' football is to only BACK when the price people are asking for reaches x

This is because there will be temporary gaps in the market (especially when a goal has been scored).
We saw a classic case earlier in the season between Bolton & Spurs. Bolton scored and somebody lumped £37000 on Spurs at 1.48, before the market had re-adjusted. This could easily have been a bot waiting to find the price of Spurs dropping to x

[corbus]

excuse my ignorance LeTiss, but as they say "asking when you don't know is never a mistake".
Could you please explain what you mean by "BACK when the price people are asking for reaches x"?

thanks

[LeTiss]

excuse my ignorance LeTiss, but as they say "asking when you don't know is never a mistake".
Could you please explain what you mean by "BACK when the price people are asking for reaches x"?

thanks

I've noticed many people have come unstuck by simply saying triggering a BACK bet when G9 = 'x'

This is due to temporary gaps on 'in play' markets, especially when something has just happened and the market starts to re-adjust

It's sometimes safer not to say
if(G9<=1.57,"BACK",""), but instead
if(H9<=1.58,"BACK","")

[Rastis]

Thanks Folks - very sound advice. To say I'm treading carefully is an understatement - I don't deal well with losses due to ignorance.

With regard to writing the code etc; my understanding of the spreadsheet(s) is that all instructions to BA are conveyed via Column L. So, once the spreadsheet has instructed the first action the relevant cell in Column L has been "used" and can't be used again - or at least I can't see how to use it again coz the previous instruction is still sitting there...

[Rastis]

Righto - after some further relatively successful testing I'm starting to see a way forward - all I need is a ski mask and some weapons.

Sorry, seriously, while my triggers were effective I clearly see that they are loose. Thus, I need some assistance with my Excel coding. I'm about to go trawling the net for the following (for a start);

- entry at Last Matched Odds (following a goal)

- exit at Last Matched Odds with greening

Are there websites out there with this sort of info? Can anyone recommend a website/specialist for this sort of thing?

Cheers

R

[Rastis]

Hi All,

Any thoughts on where I've gone wrong with this:

I manually placed a Lay bet then fired the following instruction into the spreadsheet;
BACK WITH_GREENING:TRUE

Without success.

I had inserted a link to the LTP in the "Odds" column and thought that that may be confusing it but stilled failed once removed.

The frustration of struggling with the most basic commands is driving me mad. Any help would be greatly appreciated...

Cheers

R

[LeTiss]

What were your conditions to fire the BACK command?

[Rastis]

Hi Letiss,

The actual trigger is the odds for 0-0 being greater than 100 (IE, a goal).

However, while testing just now (mucking about with Leicester v Man City), I overroad the trigger manually. I have an additional spreadsheet with the "if" commands etc with the relevant Bet Rules cell linked to it. The command appears in the Bet Rules cell but it doesn't activate BA. Thus, all I can think is that the formula/instruction to BA is wrong

Cheers

[LeTiss]

If you show us what you've actually written into the command cells, one of us might be able to help

[Rastis]

OK - brace yourself LeTiss,

I have linked the CS market to one sheet and the Market Odds to another.

I want the bet to trigger if a goal is scored. Thus, I am using the increase in odds for 0-0 by saying

=IF('Game 2; CS M'!G$9>100,1,0)

Once this cell equals 1 the command BACK WITH_GREENING:TRUE is fired to the relevant Bet Rules cell.

I also have a stop loss "If" command to fire the same command if there is no goal and my liability reaches X.

These triggers, while possibly clumsy, work.

Prior to your advice yesterday my trigger command was simply GREEN. This worked but is too loose...

[LeTiss]

What do you have in the Excel stakes column?

Are you leaving this blank because you are hoping that the BACK command will simply green up your initial manual lay?

[Rastis]

Yes, I leave it blank. The aim is for the BACK bet to green up at the LTP.

[LeTiss]

I'm pretty sure that's not going to work

Because Excel hasn't placed the LAY bet, it has no idea what stakes to place for greening

You need a cell to work out a greening up stakes for you, based on your current Profit & Loss column.