Quote from heech:
FYI, I would find it interesting (and others probably would as well) if you ran correlation with S&P weekly numbers.
Just paste your % gains/losses every week into a column, and calculate S&P weekly columns in another. Use Excel's =CORREL().
Quote from prjctdork:
Hey Rol, I'm also considering into automating my system, however I have zero programming experience. I was looking into hiring someone but as I have some free time at nights I would like to take a shot at it myself. How difficult would you say the process is and more importantly how and where do you start?

Hey Roi,Quote from Rol:
Thanks for the idea heech. What I came up with is presented here. It shows my usual % profit vs. SP500, and a correlation chart below it. 1 means it was correlated that week and -1 means it was not. I started out the year highly correlated it would appear, but later on it appears relatively uncorrelated.
Quote from heech:
Hey Roi,
Sorry, gave you incomplete instructions. Run CORREL over both series (like, =CORREL(A1:A25, B1:B:25)). The result should be a single number between -1.0 and +1.0.
Date % Chg SP Chg COR
0.47
12/31/2010 0.00% 0.00%
1/7/2011 1.90% 1.11%
1/14/2011 3.42% 1.70%
1/21/2011 -2.64% -0.72%
1/28/2011 -0.74% -0.51%
2/4/2011 3.09% 2.69%
2/11/2011 4.28% 1.49%
2/18/2011 1.19% 1.07%
2/25/2011 -5.30% -1.64%
3/4/2011 2.73% 0.11%
3/11/2011 2.34% -1.23%
3/18/2011 1.41% -2.35%
3/25/2011 5.40% 2.77%
4/1/2011 1.59% 1.41%
4/8/2011 0.30% -0.22%
4/15/2011 4.24% -0.62%
4/21/2011 1.46% 1.32%
4/29/2011 1.90% 1.98%
5/6/2011 4.67% -1.63%
5/13/2011 2.55% -0.12%
5/20/2011 -0.05% -0.32%
5/27/2011 0.64% -0.07%
6/3/2011 -0.72% -2.31%
6/10/2011 -5.90% -2.16%
6/17/2011 3.40% -0.43%
6/24/2011 4.87% -0.19%
7/1/2011 1.65% 5.61%
7/8/2011 -1.43% 0.47%
7/15/2011 2.61% -2.13%
7/22/2011 2.22% 2.19%
7/29/2011 -8.53% -3.24%
Quote from prjctdork:
I completely understand, and I thank you for the reply. I've developed a strategy that works well for me. However, I would like to be able to automate it to take out the human emotion and anxiety out of the equation. I see myself making the same mistakes over and over again that go against my rules. So, taking out the advice, which books would you recommend someone to read, who has 0 knowledge on programming and when I mean 0, I mean what is coding?![]()
{ Buys if Price crosses over Avg and then stays above Avg for one or more bars }
inputs: Price( Close ), Length( 9 ), ConfirmBars( 1 ) ;
variables: Counter( 0 ) ;
if Price > AverageFC( Price, Length ) then
Counter = Counter + 1
else
Counter = 0 ;
if CurrentBar > ConfirmBars and Counter = ConfirmBars then
{ CB > ConfirmBars check used to avoid spurious cross confirmation
at CB = ConfirmBars }
Buy ( "MACrossLE" ) next bar at market ;
{ ** Copyright (c) 2001 - 2009 TradeStation Technologies, Inc. All rights reserved. **
** TradeStation reserves the right to modify or overwrite this strategy component
with each release. ** }
inputs: Price( Close ), Length( 9 ) ;
variables: Avg( 0 ) ;
Avg = AverageFC( Price, Length ) ;
if CurrentBar > 1 and Price crosses under Avg then
{ CB > 1 check used to avoid spurious cross confirmation at CB = 1 }
Sell ( "MACrossLX" ) next bar at market ;
{ ** Copyright (c) 2001 - 2009 TradeStation Technologies, Inc. All rights reserved. **
** TradeStation reserves the right to modify or overwrite this strategy component
with each release. ** }
Quote from macrotrader:
Rol, do you trade stocks which have released earnings? Quite a few of them fall throw the floor last week. Thanks.