Today Close

Started the day +0.92%, closed the day +1.842%

interesting is looking at the excel placed linear trendline, looks like it has done some sort of mean reversion:

Anyone have any idea how I can get the trendline to also post a trendline at 1 standard deviation?

Updates

Spread dipped a little bit, but looking to recover.  Added a linear line to try and show mean some sort of mean reversion.

Updates in life:

Dad came home from the hospital Monday, so things are improving.  Updated resume, so lets see if  I can find an internship or something like that.

March 1st update...1.66% in 8 days...

Very interesting...dealing with the long term data I find I made some mistakes possibly, this way I am doing two trades, and actually calculating the PnL...very interesting...

Quant ideas

Ok so this is going to be a rant about something I tried to figure out when I ran a 1 year (May 16 2011 - present) data chart (same as other one posted) for the same stocks.

Realised that it was quite a volatile strategy, so got me into thinking about how to use a mean reversion strategy for this (I think it's called mean reversion?)

So here is what I did:

• Took Stock Prices and imput them to excel (using yahoo finance historical eod data)
• Took the higher priced stock and set base number of shares to 1000.
• calculated how many shares that same dollar amount would be equivellent in the other stock
•  Added both day 1 capital to eachother
• took day 2-day1 as the return on the day
• Calculated the ROR per day
• Calculated STDEV of the ROR
• also calculated -STDEV, 2STDEV,-2STDEV
•  Charted everything

 So what I think I have is the change in the value of the portfolio from day to day.

What I see now is this:

 Notice how there is a giant move on here?

Am wondering now how to profit from this large (possible 3STDEV move)?

Considering this:

• When ROR Breaks 2STDEV:
• Sell portfolio
• When ROR breaks -2STDEV:
• Buy Portfolio

Looking for someone to advise on this.  Please Comment or Find me on Linkedin.

Lost a little today

So decided to just post visual chart instead of actual numbers to keep it easier to follow (plus allows me to play around in excel a little more)...

Top is the dollar amount invested in each stock starting on the 1st day, and the gains/losses from each (in dollars).
Bottom is the spread between the two stocks (in dollars).

As of closing friday..L/S is profitable!

Closing prices today:
BAC: $7.88   $32 071.60 short $284.90
C: $32.35 $32 350.00 $-10
Profit: $274.90

original $ in trade: $64 716.50
profit: 0.425%

notes:
was interesting seeing a reversal and seeing how the short moved enough not just to offset loss on higher priced C, but also to move the pair trade into profitablilty.

Also just completely random but having 284.90 loss on BAC Thursday, and then same amount profit on Friday.

Long/Short Strategy

Closing prices today:
BAC: $8.02   $32 641.40 short $-284.90
C: $32.71 $32 710.00 $+350.00

Profit: $65.10

original $ in trade: $64 716.50
profit: 0.10%