Using multiple sheets!

[cjones198]

Hi all

i plan on testing more than 1 strategy so i am thinking of running 2 different sheets for the same market,
So ones a lay strategy and the other a back,
But if i run them just using one market sheet, keeping track of them separately is a pain,
my main question is

If i have multiple sheets on the same market, if i enter CLOSEC on 1 market will it hedge taking into consideration the other markets?

[Captain Sensible]

I'd imagine CLOSEC takes account of all bets in the market , the same way that MyBets sheet would display all bets. You'll have to keep track of bets placed and write your own closing routines.

The API does have an option of customerStrategyRef where you can add a string to any bets you place so you can keep track of them but it's not being used by Gruss. Maybe suggest it in the suggestions section.

[cjones198]

Yeah thanks Captain, I track the bets in MyBets, then hedge for equal stakes at SP, then Close C code until its closed. It's just I tried to copy my bet when it was placed on to Mybets alongside what Gruss does, but the bet reference is always what was in the cell previous

[cjones198]

So I'm assuming the code is copy and pasting the cell before it gets placed and matched

[Captain Sensible]

... It's just I tried to copy my bet when it was placed on to Mybets alongside what Gruss does, but the bet reference is always what was in the cell previous

Not sure what you mean by that?

I was basically suggesting you'd have to copy the bet ref from column T when you place them then use the MyBets sheet to track their progress. Your other options are using the COM functions to place and monitor the bets progress.

[cjones198]

Whenever I copy bet ref it always copies what was in cell T previous, so for example, if its blank and my first bet is fired in, it copies a blank cell, if it's the 2nd bet it copies the 1st bet ref, etc etc.
The COM function I wouldnt even know where to begin, what is COM

[Captain Sensible]

The bet ref won't get populated until gruss has received the response from Betfair so that would come in the next refresh. You'd have to delay your copy routine at least one refresh.

The com interface just gives you other options to connect and bet via gruss. http://www.gruss-software.co.uk/Betting ... erface.htm

[cjones198]

Thanks Captain! I will just make the code wait for 1 second before it copies, should be a simple soultion
I will star having a read into COM,