Macro software on iPad
No it is not possible. Due to sandbox restrictions built in iOS. 

Even if you develop your own app you can only press a certain spot in your own app. You don't have any access to other apps or the system itself.