Setting up for Excel - help please?

[routus2000]

Hi all

I'm back with my next challenge, which I've messed about with for a few hours and had no real progress.

I want to use Excel to record Back Odds, Lay Odds and traded volume for each runner in each race in the Guardian markets list that my strategy selects, at several set times.

I've added the appropriate columns to the Excel sheet, and know how to link the sheet with Guardian - it does link and the sheets update with the original settings - I'm using the BetAngel_Multiple.xls sheet.
I've added three columns headed: "Back Odds", "Lay Odds" and "Traded" under 12 time settings, ranging from 10 minutes to 20 seconds pre-race. What I haven't been able to do is set up a new rule in the strategy to actually implement this so that it populates the appropriate columns.

10 minute data
Back Odds Lay Odds Traded

I thought it might be best to start a group, but I couldn't figure out how to set it up, and after reading and digging around in the forums and help, as well as BA's AI, I'm not really any closer to solving the puzzle, and my head's spinning!

Has anyone done this - or something similar - and would you mind telling (or showing) me how please? I'm getting pretty adept at editing settings and stuff like that once I have a rule working, I just can't figure out how to do this - an example file with just a couple of random times in would help me massively so that I can see the set up and add in all of the times I need.

Thanks in anticipation

[routus2000]

I'm hopeful that I've sorted this - was over-complicating it I think! Will soon find out when it's (hopefully) due to kick in

[routus2000]

So I haven't sorted this, and really could do with some help please!

I'm happy to share my modified Excel file and the strategy file, and I'll willingly pay for your time if you are able to sort this out for me please.... I'm learning all the time, and realize that what I want to do is "custom" stuff, so won't necessarily be documented. I also understand that I may be moving a little quicker than some "newbies", as I have clear ideas of what I want to do.

The strategy runs fine, Guardian logs are working, the Excel workbook opens, Guardian connects and the original features of the workbook (pre-modification with extra columns) all work.

I need to get the extra columns populating with the relevant data, which I think I have set up correctly in the strategy (but I may not have). If I can get just one tab set up and working, I can duplicate it across the number of tabs I need.

I am open to private messages or emails if you don't want to reply in the forum.

Thank you