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.
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
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