Return (again)

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

A B
Jan Buy 1000
Feb
Mar
Apr Sell 1200
..
..
..
.. Buy 3000
.. Sell 3500
..
...
.. Buy 10
Jan
Feb Sell 15
Mar

What I have for above table are three returns. But is
there a way of getting a formula to work out the returns.

I had the same problem with a stock market spreadsheet
where by a model would say buy and then say sell and then
say buy again and so on and I just wanted to calculate the
return from this strategy.

Thanks.
 
Frank,

Thanks for your reply. Sadly that is not what I want. Let
me have another go at explaining what I am looking for...

Lets say I buy something at time t for B (for Buy) and
then x-days have lapsed and then I sell for S (for Sell)
this at t+x. I have a whole colomn of B's and S's over a
specified time period. All I want is to work out the
return but I cant sum them because the things I buy are
different but by focusing on the price I can bypass this
problem. But then this leaves me with the problem of
having a forumal for workkng out the return for each
purchase and sale.

example

In Jan buy apples for £2000 and then in March sell them
for £2500.

In April I buy pears for £1500 and sell them for £2000.

The return on 1st transaction is 25% and on the second is
33.3%. But supposed I have a whole list of these but
labeled simply B and S. How do I work out the return?
 
Back
Top