General Topics
Markets
Technical Topics
Brokerage Firms
Community Lounge
Site Support

# excel question

Discussion in 'Trading' started by soler, Jan 8, 2008.

1. ### 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

2. ### covered_call

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

3. ### balda

That is more of a math question than excel.

4. ### 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,

n is your period, could be a day, month, year, etc...

fastest method.

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

Same as earlier formula, faster easier entry.

6. ### 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.

File size:
15 KB
Views:
89

8. ### ProfitTakgFool

These are the formulas.

File size:
17 KB
Views:
82
9. ### soler

guys,
thanks so much its really appreciated.

ET IS FREE BECAUSE OF THE FINANCIAL SUPPORT FROM THESE COMPANIES: