Spreasheet Request | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

request: RSI + ATR 40 replies

VTTrader: Request Indicator or Trading System for VT Trader 167 replies

Spreasheet Request 1 reply

A Request! 0 replies

Request: Reverse Straddle 1 reply

Attachments: Spreasheet Request
Exit Attachments

Spreasheet Request

  • #1
  • First Post: Feb 8, 2008 8:22pm Feb 8, 2008 8:22pm
Greetings, can anyone post a simple Excel spreadsheet that I could use to keep track of pips won/lost on multiple pairs, with a sum total at the bottom? Such as column 1 would be EUR/USD, column 2 would be GBP/USD, etc. and I would just enter the number of pips won/lost for the day and the running total would be at the bottom?

I'm just not good with spreadsheets at all but would sure like to have this, if anyone could put it together.

Thank you in advance.
  • #2
  • Feb 8, 2008 9:59pm Feb 8, 2008 9:59pm
Quoting Dreamliner
Greetings, can anyone post a simple Excel spreadsheet that I could use to keep track of pips won/lost on multiple pairs, with a sum total at the bottom? Such as column 1 would be EUR/USD, column 2 would be GBP/USD, etc. and I would just enter the number of pips won/lost for the day and the running total would be at the bottom?

I'm just not good with spreadsheets at all but would sure like to have this, if anyone could put it together.

Thank you in advance.
Well since you'd be adding data each day, there's no way to know where the "bottom" of the sheet is. So the way to do it is to set it up with two columns for each pair; the first one where you would enter the daily pip totals and a second one which keeps track of the cumulative total. You may want to have a column at the far left for the date also.

Here's a sample of what I'm talking about. The only thing is, there is a formula in each of the "total" columns, so when you get near the end of the colored cells you'll need to copy and paste the last row to extend the sheet down further. All you have to do is just copy the single row and you can paste it over as many new rows as you want in one click. To add new pairs, just copy and paste one of the 2-column setups that's in there and change the name at the top.

If you accidentally type over a formula, just copy and paste the one from above or below it to replace it. Be aware that the topmost formula in each column is different from the rest though.

EDIT: I just upgraded this to eliminate showing a total when there's no daily pip count entered yet.

Attached File(s)
File Type: xls piptotals.xls   17 KB | 541 downloads


Hope it helps! Let me know if there's any problem (or if you don't like the color scheme )
  • #3
  • Feb 9, 2008 2:27am Feb 9, 2008 2:27am
There is a quicker way of doing this, someone wrote an EA that exports your order history to a .csv file that can be opened with any spreadsheet program such as excel.

i've made a quick modification to run it as a script; just put it into your /experts/scripts folder, compile it and then drag it to an chart. the completed file will be in the /experts/files folder with the name OrdersReport.csv

to get a total of profit just select the profit column, the total will appear in the status bar of excel. Or just use the Sum() function.

Note that this outpus the profit/loss in dollars and not in pips; shouldnt be too hard to modify it.
Attached File(s)
File Type: mq4 GetHistory.mq4   1 KB | 372 downloads
  • #4
  • Feb 9, 2008 6:06am Feb 9, 2008 6:06am
This is great, the only thing I am having trouble with is adding more pairs. I'm not sure how to copy the formula to add more pairs. Can you possibly add about another 7 pairs?

Quoting capitalist88
Well since you'd be adding data each day, there's no way to know where the "bottom" of the sheet is. So the way to do it is to set it up with two columns for each pair; the first one where you would enter the daily pip totals and a second one which keeps track of the cumulative total. You may want to have a column at the far left for the date also.

Here's a sample of what I'm talking about. The only thing is, there is a formula in each of the "total" columns, so when you get near the end of the colored cells you'll need to copy and paste the last row to extend the sheet down further. All you have to do is just copy the single row and you can paste it over as many new rows as you want in one click. To add new pairs, just copy and paste one of the 2-column setups that's in there and change the name at the top.

If you accidentally type over a formula, just copy and paste the one from above or below it to replace it. Be aware that the topmost formula in each column is different from the rest though.

EDIT: I just upgraded this to eliminate showing a total when there's no daily pip count entered yet.

Attachment

Hope it helps! Let me know if there's any problem (or if you don't like the color scheme )
  • #5
  • Feb 9, 2008 10:01am Feb 9, 2008 10:01am
Quoting Dreamliner
This is great, the only thing I am having trouble with is adding more pairs. I'm not sure how to copy the formula to add more pairs. Can you possibly add about another 7 pairs?

Yes, I still have the sheet on my desktop. Just list all the pairs in the order you want and I'll post a full spreadsheet here. Do you want a grand total across all pairs at the end too? That's easy to do if you want.
  • #6
  • Feb 9, 2008 12:45pm Feb 9, 2008 12:45pm
Quoting capitalist88
Yes, I still have the sheet on my desktop. Just list all the pairs in the order you want and I'll post a full spreadsheet here. Do you want a grand total across all pairs at the end too? That's easy to do if you want.
Ah, perfect, thank you very much. Here are the pairs:

Eur/Usd
Usd/Chf
Usd/Jpy
Gpb/Usd
Gbp/Jpy
Usd/Cad
Eur/Jpy
Gbp/Chf
Eur/Gbp
Aus/Jpy

And yes, it would be great to have the total as well. Thank you very much.
  • #7
  • Feb 9, 2008 2:13pm Feb 9, 2008 2:13pm
Quoting Dreamliner
Ah, perfect, thank you very much. Here are the pairs:

Eur/Usd
Usd/Chf
Usd/Jpy
Gpb/Usd
Gbp/Jpy
Usd/Cad
Eur/Jpy
Gbp/Chf
Eur/Gbp
Aus/Jpy

And yes, it would be great to have the total as well. Thank you very much.
OK, here's the latest and greatest version. It's set up so that even if you skip a day for a some pairs, it still keeps track of the totals for each pair and across all pairs. I put some fake data in to test it out. You can delete that out of there and change the dates, etc. but remember not to mess with any columns except the ones headed "Date" and "Daily." All the others have formulas in them.

There are enough rows to last you about a month, but if you need to extend it further down, just highlight the last row (cells A33 to W33 I think), right click your mouse, choose "copy", then highlight from cell A34 down to A-whatever, rightclick and choose "paste." You only have to choose column "A" when you paste; it will know to put everything in from A to V because that's what you selected for the copy.

By copying and pasting the last row, you'll be capturing all the formatting and formulas that I put in each cell down into as many future rows as you want.

EDIT: I just included a daily total column too, so you can see the total for the day as well as the grand total for all days.

Attached File(s)
File Type: xls piptotals.xls   32 KB | 366 downloads


Have fun!
  • #8
  • Feb 9, 2008 2:19pm Feb 9, 2008 2:19pm
Now this is perfect, exactly what I was looking for. Thank you so much!

Quoting capitalist88
OK, here's the latest and greatest version. It's set up so that even if you skip a day for a some pairs, it still keeps track of the totals for each pair and across all pairs. I put some fake data in to test it out. You can delete that out of there and change the dates, etc. but remember not to mess with any columns except the ones headed "Date" and "Daily." All the others have formulas in them.

There are enough rows to last you about a month, but if you need to extend it further down, just highlight the last row (cells A33 to V33 I think), right click your mouse, choose "copy", then highlight from cell A34 down to A-whatever, rightclick and choose "paste." You only have to choose column "A" when you paste; it will know to put everything in from A to V because that's what you selected for the copy.

By copying and pasting the last row, you'll be capturing all the formatting and formulas that I put in each cell down into as many future rows as you want.

Attachment

Have fun!
  • #9
  • Feb 9, 2008 2:22pm Feb 9, 2008 2:22pm
Quoting Dreamliner
Now this is perfect, exactly what I was looking for. Thank you so much!

Whoops, you were too fast for me, LOL. I just made another upgrade, so if you download the attachment again you'll have a column that keeps track of just daily totals. The grand total column is still there too.
  • #10
  • Feb 9, 2008 2:37pm Feb 9, 2008 2:37pm
Even better!

Quoting capitalist88
Whoops, you were too fast for me, LOL. I just made another upgrade, so if you download the attachment again you'll have a column that keeps track of just daily totals. The grand total column is still there too.
  • #11
  • Last Post: Feb 9, 2008 3:48pm Feb 9, 2008 3:48pm
Quoting Dreamliner
Even better!
Cool!
0 traders viewing now