Now to add excel and lay price in relation to SP on in play

[topbobby]

I am not sure how to add the Excel calculation into Guardian. I want to lay all horses not just one horse.
I understand how to trigger guardian after the race starts but want to pick up the SP and lay the field at various prices linked to each SP of each selection.
(eg if SP is between 2 and 2.3 then place a lay for £55 at 1.9, if SP is between 2.32 and 2.6 the place a lay for 50 at 2.0, if SP is between 2.62 and 2.9 then lay 40 at 2.5 etc etc).
My question is how to place this calculation into excel and then how to export from excel into Guardian.
Appreciate any help, i am having trouble trying to understand how the excel plug in works.

[6thSense]

I am not sure how to add the Excel calculation into Guardian.

This makes no sense. You can't add Excel calculations to Guardian. Can you rephrase or expand?

I want to lay all horses not just one horse.

In Excel you would need to have the LAY instruction in each instruction cell in column L.

I understand how to trigger guardian after the race starts but want to pick up the SP and lay the field at various prices linked to each SP of each selection. My question is how to place this calculation into excel and then how to export from excel into Guardian.

Thanks to the latest version of Bet Angel making the SP available to Excel, Excel will be able to accept a formula along the lines of 'IF SP=this THEN {REQUESTED ODDS}=that'. This bit sounds straight forward.

Your comment about exporting this to Guardian is throwing me though. You can't export from Excel into Guardian? Guardian will not import Excel files.

Perhaps you mean something else? Apologies if I have misunderstood you completely.