excel question

[soler]

Guys,
I'm not efficient in excel so can u help me out please.

on my spreadsheet I want to create a column which has % change.

how do I write it? take my change divided by last? obviously I need to see % up and % down.

thx

 

[covered_call]

Change divided by first (initial price - last price) / initial price

 

[balda]

That is more of a math question than excel.

 

[ProfitTakgFool]

This gives you the decimal. Multiply by 100 to get the whole number. Or, a formula that works for any time period:

(((To/From) ^(1/n)) -1 ) * 100, where,

To is your ending value.
From is your beginning value
n is your period, could be a day, month, year, etc...

Quote from covered_call:

Change divided by first (initial price - last price) / initial price

 

[dtrader98]

fastest method.

Just do =(col A/ col B) -1
and then click format, percentage.

Same as earlier formula, faster easier entry.

 

[ProfitTakgFool]

Here's an example. The first image is the input, the next post will be the formulas. The daily return is your average profit per day and the total return is self explanitory.

 

[Tums]

courtesy The University of South Dakota

http://www.usd.edu/trio/tut/excel/

 

[ProfitTakgFool]

These are the formulas.

 

[soler]

guys,
thanks so much its really appreciated.