Yes this can be done via Excel. I've spent the last few months building a macro which will interact with a broker interface, copy and paste prices into excel to work out when to trade etc. It executes, monitors and exits trades also.
It's hard to do, and it doesn't work with brokers with Java...