Spreadsheet to track trades

I've done a search but I can't find what I'm looking for. I need a spreadsheet to log trades. I need to be able to put in the date trade was placed, entry price, closing price, and then have it automatically calculate the total pips won or lost. I'm totally lost when it comes to doing spreadsheets. Can anyone help or know where I can find one????

Anyone? I figured someone would have something or could slap one together.

heya, have a look at this post i made in my journal. I think it would have some spreadsheets that i have collected over the years that could be of interest to you.

http://www.forexfactory.com/showpost...7&postcount=63

most notably monthly performance one.

supermatt, I think I could use the monthly one, but do you have one or can modify this one that would include all 12 months instead of starting in March?

yes i had the same issue when i first got it but i soon realized hang on i can just change them to whatever i wanted so i did...
you dont have to stay with the default settings, you just delete all the months and start with whatever month u want . its January now so just write in January. u can change it to whatever you want.

my point is

it says 1/Mar/08


theres nothing stopping you from typing in

27/01/10

and just continuing on from there.

this is the best spreadsheet ur ever likely to find

unless u are some excel wizz and can make one yourself

hope this helps!

Cool, I'll try that. But is there a special way to add more pairs to the dropdown box?