I use excel to do my autotrades, and as far as algorithms i started with Don's framework and traded the openings manually for a while until i got the hang of them (as a human :) ), and gradually moved each element into my spreadsheet as an automated process.
hope this helps
~g