Interactive Broker Auto Excel Trading?

K

katiewc

Hi I have just started using Interactive Broker's API trading through excel. I am a total newb at it and was wondering if the following is possible.

I am doing a pairs trade, when stock X and Y are trading at a premium of greater then 25% I would like to buy x and short Y. WHen it is trading below 12 I'd like to unwind the trade. Anyone know an easy way to do this in Excel? I thought about using if/then statements but not quite sure how. Any help greatly appreciated.
 
I wouldn't trust my money in it if I were desperate.

Go to the library.
Go get a book... dummy books.
Take a night course.
Check the web... there are tons of FREE Excel tutorials... from colleges and universities.

Start reading... and experimenting.
Whether it is easy or not, only you can tell.
 
hmm sorry not quite sure what u mean by wouldn't trust your money in it. I'm just trying to see if anyone knows how to set up an automated trading thing in excel as I don't know how to do it. My rules for trading work fine if that's what you meant, just need to automate it.
 
Quote from katiewc:
hmm sorry not quite sure what u mean by wouldn't trust your money in it. I'm just trying to see if anyone knows how to set up an automated trading thing in excel as I don't know how to do it. My rules for trading work fine if that's what you meant, just need to automate it.
More...
no, I am not referring to your rules... don't know your system, can't comment on it.
 
You must log in or register to reply here.
Back
Top