Rated prices, dutching overs in excel

[goldspider]

Hi
I am asking if this may have been done before. I want to have my rated prices in a spreadsheet for all horses, and if at the trigger, the betfair prices are 'x' amount or clicks above the rated prices, the bets are placed. I am new to the forum, but a long time Bet angel user. Have not used spreadsheets before. A point in the right direction appreciated.. Regards, Pat

[rubysglory]

Hi Pat. I am an advocate of rated prices and wish you luck. I personally advise care however if intending to automate any triggers without considering factors such as market over-rounds. Just an observation, but you may find benefit in a Dutching formula that uses your rated prices as it basis as against that being offered.

rg

[goldspider]

Sorry I shouldn't have said all horses. I have two sets of ratings vastly different, and I look at the top 4 of each. This is on Australian racing. Usually 4 to 6 horses are bet. It does well manually and I'd like to automate it in Excel.

Thanks, Pat