1. Newbie
Join Date
Apr 2012
Posts
12

What do you use? is it usefull? what functions whould you want to use that you don't have today? Thanks

2. Newbie
Join Date
Nov 2011
Location
UK
Posts
63
I use excel for anything and everything I can think of, not limited to:

-lot size calculation (risk management) for whether the pair is in US dollars, yen, pounds, NZ dollars
-histograms of win/loss sizes in pips
-pie charts showing trades by currency pair
-pie charts of % wins, losses and break-evens
-bar/pie charts of win ratio, average pips, etc by each currency pair
-pie charts showing trades by day of the week
-pie charts showing trades by what hour of the day the trade was placed
-line charts of balance (\$) over time
-line charts of balance by pips over time
-wins/losses whether they were long/short
-many more

I separate results by daily, weekly, monthly, tax-year, etc.

Basically if I think of something or read about more metrics ideas (such as on today's blog by Dr Pipslow), I will find a way to display it in graph form on excel. I'm currently in the middle of doing the lot size versus win/loss ratio as suggested by the blog.

There are some automated websites that can also do some of these metrics for you such as mt4pips and zulutrader but I prefer an offline method.

3. Master Contributor and Member
Join Date
Sep 2011
Posts
576
Some traders use Excel sheet to manage trading data and it is called excel trading. Even though I did not use excel for trading so far.

4. Newbie
Join Date
Jun 2010
Posts
69
Excel is awesome! I use it as a journal for my trades and also my back test results and analysis similar to kwyjibo above. There aren't really many functions you use, just a matter of using normal mathematical functions and if statements really, well that is mostly how I use it.

5. Absolutely i have several spreadsheets that i use to keep track different aspects of my trading and log them over time. they are critical in my weekly self evaluations and refining myself and my system.

6. Banned Senior Member
Join Date
Apr 2012
Location
Asia
Posts
308
Originally Posted by mikhail86
Excel is awesome! I use it as a journal for my trades and also my back test results and analysis similar to kwyjibo above. There aren't really many functions you use, just a matter of using normal mathematical functions and if statements really, well that is mostly how I use it.
There are some tools available for Excel which makes the process of testing the results of the trading and also analyzing them over the weekend
Last edited by Dominator4fx; 06-02-2012 at 09:12 AM.

7. Newbie
Join Date
Nov 2010
Posts
34
I always calculate my risk before i enter a position. Usually it is 2 to 4 percent. Very important.

8. Banned Newbie
Join Date
May 2012
Posts
55
If you want to track your trading performance then why not use MT4i or Myfxbook?

It's so much easier to have it automated. And it's free.

9. Originally Posted by Nick McDonald
If you want to track your trading performance then why not use MT4i or Myfxbook?

It's so much easier to have it automated. And it's free.
- Easily rigged (I've done it)
- Inaccurate
- Limited in analysis
- Excel has more flexibility in what you do, as well as further analysis methods
- Manually recording thoughts, comments, trades actually helps since you are writing/typing it, and you can learn about yourself than having it automated

Lots of reasons.

10. Hi guyz, can you share any Excel template that could be useful in Forex trading? Thanks.

Page 1 of 4 123 ... Last