Can You Change This Excel Spreadsheet? | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

Excel profit / loss tracking spreadsheet? 5 replies

Excel Forex Spreadsheet help needed 6 replies

Need help with importing prices from MT4 into Excel spreadsheet 1 reply

Anyone have a d'alembert excel spreadsheet? 2 replies

Has anyone made an Excel spreadsheet to analyze your MT4 trades? 0 replies

Attachments: Can You Change This Excel Spreadsheet?
Exit Attachments

Can You Change This Excel Spreadsheet?

  • #1
  • First Post: Mar 4, 2011 10:34am Mar 4, 2011 10:34am
Greetings all,

Not sure if this is the correct place to ask this, if not maybe the moderators can move it.

I'm posting a simple Excel compound spreadsheet, and wondering if anybody can modify it.

All I want for the modification is the addition of one more row titled "Deposit" and have the deposit amount figured in to the remaining sheet amounts. Right now there is an "income" row which allows us to take out funds from our trading account, but there is no "Deposit" that allows us to add funds to our trading account.

If anyone can add this row it would be appreciated.

Thank you!
Attached File(s)
File Type: xls Compounding Spreadsheet.xls   123 KB | 1,122 downloads
  • #2
  • Mar 4, 2011 10:40am Mar 4, 2011 10:40am
That can be done easily, but for now, just enter a minus amount in the income, like this

-100


Canadian by birth Australian by choice
  • #3
  • Edited 12:49pm Mar 4, 2011 11:13am | Edited 12:49pm
Here you go, not sure what you want to do with this? If you are going to keep a weekly balance sheet, it won't be easy to do as the PERCENTAGE entry affects the balance, but what do I know.....

You can now enter as many Deposit & Income as you want in the center colums.

Canadian by birth Australian by choice
  • #4
  • Edited 12:17pm Mar 4, 2011 11:54am | Edited 12:17pm
Ah some people are just so smart! Thank you, exactly what I was looking for!

However, just one error that I just found. Try adding $1,000.00 in the "Deposit" row anywhere, like on row 12. It does not adjust the balance up by 1,000.00.

Thank you again.

P.S. As to what I do with it, it just helps me know where to set my take profits.

Quoting TheSnowman
Here you go, not sure what you want to do with this? If you are going to keep a weekly balance sheet, it won't be easy to do as the PERCENTAGE entry affects the balance, but what do I know.....

You can now enter as many Deposit & Income as you want in the center colums.

  • #5
  • Mar 4, 2011 12:19pm Mar 4, 2011 12:19pm
P.S. Maybe you could change the heading "Income" to "Withdrawal"? I know, I'm asking a lot now, right?
  • #6
  • Mar 4, 2011 12:51pm Mar 4, 2011 12:51pm
Quoting Dreamliner
P.S. Maybe you could change the heading "Income" to "Withdrawal"? I know, I'm asking a lot now, right?
I read your mind, now you can use the yellow cells for actual book-keeping, while the green cells give the original compounding amounts.

Sorry about before, forgot to copy cells down
Attached File(s)
File Type: xls Compounding Spreadsheet.001.xls   159 KB | 813 downloads
Canadian by birth Australian by choice
  • #7
  • Mar 4, 2011 12:59pm Mar 4, 2011 12:59pm
Now this is looking really good. You could sell this!

Just one question, how do I get the green shaded cells to change? I changed the starting amount but the green doesn't change.

I'm quite sure I'm doing something wrong, sorry for making you have to support something you didn't even invent.

See attached.

Quoting TheSnowman
I read your mind, now you can use the yellow cells for actual book-keeping, while the green cells give the original compounding amounts.

Sorry about before, forgot to copy cells down
Attached File(s)
File Type: xls FF Spreadsheet.xls   153 KB | 835 downloads
  • #8
  • Mar 4, 2011 1:21pm Mar 4, 2011 1:21pm
OK, the green is linked to the starting amount, or do you want it to link to the actual balance to calculate the % as a weekly target?

I can add another column for that % if needed, so you can have the estimate and the "real" balance & target.

Check way down the bottom and you will see the total for each column, now you can see why the Gain or Loss needs to be entered as + or -
Attached File(s)
File Type: xls FF Spreadsheet.xls   160 KB | 643 downloads
Canadian by birth Australian by choice
  • #9
  • Mar 4, 2011 1:34pm Mar 4, 2011 1:34pm
OK this is getting good now! The only question I have is, would it be easy to make the "Starting Balance" column the exact same as the "Actual End Balance" column, so that the "1%" would be figured on the "Actual End Balance"?

Or even better, just take out the "Starting Balance" column (Column G) entirely and just have the final column be the % return column, figured from the "Actual End Balance" column.

Does that work? Or is that a whole bunch of extra work?

Quoting TheSnowman
OK, the green is linked to the starting amount, or do you want it to link to the actual balance to calculate the % as a weekly target?

I can add another column for that % if needed, so you can have the estimate and the "real" balance & target.

Check way down the bottom and you will see the total for each column, now you can see why the Gain or Loss needs to be entered as + or -
  • #10
  • Mar 4, 2011 2:04pm Mar 4, 2011 2:04pm
OK, added a % column to show actual account gain (does not calculate the deposit or withdrawal, only Gain / Loss amount) and a column to show the $ target based on the account balance and desired % gain eg. 2%

Let me know if that works for you, I'm off to solve the DaVinci Code now.......
:nerd:
Attached File(s)
File Type: xls FF Spreadsheet.xls   206 KB | 863 downloads
Canadian by birth Australian by choice
  • #11
  • Mar 4, 2011 2:30pm Mar 4, 2011 2:30pm
This is absolutely 100 % perfect. Can't thank you enough!

Hey, wasn't this a fun project to collaborate on? Why don't we do this more? You know, I bring the problems, you bring the solution?

Seriously, thanks a bunch, I know this took up your time and I really appreciate it.

By the way, if you need any help solving the da Vinci code problem, let me know. I can do that .

Quoting TheSnowman
OK, added a % column to show actual account gain (does not calculate the deposit or withdrawal, only Gain / Loss amount) and a column to show the $ target based on the account balance and desired % gain eg. 2%

Let me know if that works for you, I'm off to solve the DaVinci Code now.......
:nerd:
  • #12
  • Mar 9, 2011 1:47pm Mar 9, 2011 1:47pm
Hi SnowMan,

The weekly spreadsheet looks great! Can you create a daily trading spreadsheet like the one you did?

Thanks
BD
  • #13
  • Mar 9, 2011 7:38pm Mar 9, 2011 7:38pm
Better than that, check this out. If you are not familiar with these, click the " + " on the left side to expand the 3 sections, should keep you busy for awhile.

You can enter actual amounts, so will suit your purpose
Attached File(s)
File Type: xls GoalTrackerSpreadsheet-2007.xls   55 KB | 1,687 downloads
Canadian by birth Australian by choice
  • #14
  • Last Post: Mar 10, 2011 7:46am Mar 10, 2011 7:46am
Hi Snowman,

It looks great! I believe you are a Math Specialist......Thanks snowman!!!!
0 traders viewing now