I knew you could do it! There you go, I was overcomplicating it. What I was trying to do was work out the return at any given time by looking at the amount spent on the stock (why I showed it as negative) against the actual value of the stock. Of course this led to wildly varying percenatge returns, especially after sells as you may only be -$100 (of real spent cash) against a stock value of $2000 which would lead to a return of 2000% or some strange figure. I think I may look at using a fixed value say $2500 which is the max I'll commit to any one stock. I'll go away for a while and thrash around withmy spreadsheets for a bit longer.
Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.