coming up with viable trading strategy

C

chicago1234

hello,
if i have 2 sets of data, e.g. NG and WTI end of day 2 yrs back.
could any1 help me with a trading strategy (in excel)
something like if the spread between the 2 assets moves over 1sd upward from the median then sell and vice versa for buying.

I have some ideas but are completely clueless how to go about it in excel and set this up thru api.

Any help greatly appreciated.
 
Quote from chicago1234:

hello,
if i have 2 sets of data, e.g. NG and WTI end of day 2 yrs back.
could any1 help me with a trading strategy (in excel)
something like if the spread between the 2 assets moves over 1sd upward from the median then sell and vice versa for buying.

I have some ideas but are completely clueless how to go about it in excel and set this up thru api.

Any help greatly appreciated.
More...

You can find cheap programming talent at several places. You describe and post this project, then evaluate their bids/responses at:

Elance.com
Guru.com
RentACoder.com
 
Quote from chicago1234:

hello,
if i have 2 sets of data, e.g. NG and WTI end of day 2 yrs back.
could any1 help me with a trading strategy (in excel)
something like if the spread between the 2 assets moves over 1sd upward from the median then sell and vice versa for buying.

I have some ideas but are completely clueless how to go about it in excel and set this up thru api.

Any help greatly appreciated.
More...
Do you actually want Excel to send the orders or you just want to manually update the daily close and put the orders manually yourself?
 
initially i would put in orders manually as I am not yet well versed in doing anything auto in excel
after it has been working fine id do it thru excel in auto mode
 
You must log in or register to reply here.
Back
Top