Excel trading automation

I want to code simple RSI strategy in excel VBA and on the basis on overbought/oversold zone place order into NOW terminal.

I am using RTD to fetch data. Please help me with the process to automate trading without using any API.