Looking for a Spreadsheet | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

Looking for a Compound Interest Spreadsheet 14 replies

Firehorse's trading spreadsheet 45 replies

Fixed Ratio MM Spreadsheet (looking for) 1 reply

VWB - Average Range Spreadsheet 6 replies

Forex data spreadsheet 11 replies

Attachments: Looking for a Spreadsheet
Exit Attachments

Looking for a Spreadsheet

  • #1
  • First Post: Apr 28, 2007 4:17pm Apr 28, 2007 4:17pm
Greetings,

I am wondering if anyone could help me by developing a very simple Excel spreadsheet. Here is what I need:

 

  1. Place to input my original deposit amount:
  2. Spreadsheet calculates 5% and gives that figure, and let's me enter the date next to when that 5% was reached:
  3. Forecasts the future (account balance and date) based upon the previous 5 dates of when the 5% was reached.

Can anyone help with this?

Thank you in advance for any replies.

Mike

  • #2
  • Apr 28, 2007 6:55pm Apr 28, 2007 6:55pm
http://www.forexfactory.com/showthread.php?t=9599
  • #3
  • Apr 29, 2007 9:50am Apr 29, 2007 9:50am
Quoting mikejody
Greetings,

I am wondering if anyone could help me by developing a very simple Excel spreadsheet. Here is what I need:

 

  1. Place to input my original deposit amount:
  2. Spreadsheet calculates 5% and gives that figure, and let's me enter the date next to when that 5% was reached:
  3. Forecasts the future (account balance and date) based upon the previous 5 dates of when the 5% was reached.

Can anyone help with this?

Thank you in advance for any replies.

Mike


Try this Mike... This lets you change the starting balance, % goal and forecasts an achievement date based on the last 5 actual achievements.

Hope it helps...
Attached File(s)
File Type: zip Forecaster.zip   7 KB | 687 downloads
  • #4
  • Apr 29, 2007 11:42am Apr 29, 2007 11:42am
Here is a spreadsheet that was given to me by another trader.

Macros box comes up when you start it.
Attached File(s)
File Type: zip Forex Trade Progress.zip   54 KB | 795 downloads
- SAFE TRADING MONEY DUCK
  • #5
  • Apr 29, 2007 12:44pm Apr 29, 2007 12:44pm
Quoting AggieTrader
Try this Mike... This lets you change the starting balance, % goal and forecasts an achievement date based on the last 5 actual achievements.

Hope it helps...
Ahh, this is perfect, thank you! The only thing I'd like to be able to do is to change the actual balance, is it possible to do that?

For instance, 5% of $300.00 is $315.00 but when I reach that 5% I close out all my positions and take profit. The actual profit could be more like $314.72 or $316.00, etc.

Do you know if there is a way to modify the "amount" column to put in the actual amount the account is at?

Thanks again for this spreadsheet, it is just what I was looking for.

Mike
  • #6
  • Apr 29, 2007 2:16pm Apr 29, 2007 2:16pm
No problem...

I protected the sheet so you couldn't change anything by accident...

All you need to do is open the spreadsheet then go to Tools>Protection>Unprotect Sheet. Once you do that you can change anything. It may be a good idea to save a backup before you change anything though!

The new "Goal" amount is calculated using the amount right above it. So as you type "314.75" where "315" used to be, the new goal will use your % amount and base that off of the $314.75 you typed in.

Good luck and happy trading...
  • #7
  • Apr 29, 2007 3:15pm Apr 29, 2007 3:15pm
Quoting AggieTrader
No problem...

I protected the sheet so you couldn't change anything by accident...

All you need to do is open the spreadsheet then go to Tools>Protection>Unprotect Sheet. Once you do that you can change anything. It may be a good idea to save a backup before you change anything though!

The new "Goal" amount is calculated using the amount right above it. So as you type "314.75" where "315" used to be, the new goal will use your % amount and base that off of the $314.75 you typed in.

Good luck and happy trading...
This is excellent, thank you again.

I am having a slight problem though with the ### signs, as to what their purpose is. I see that all the dates below them are fictitious, and that if I enter actual dates to the left of them they just slide down one row.

It would be nice if they were not there, is there a way to remove them?

For instance, I populated the five rows in the "date achieved" column with actual dates, but the ##### symbols just moved down, so that the dates below it are not actual dates forecasted from the five columns above, but rather they all say 1/0/1900.

Did I do something wrong?
  • #8
  • Apr 29, 2007 4:17pm Apr 29, 2007 4:17pm
No... you're doing everything fine. It's just not designed to be cosmetic.

I've updated it to be a little cleaner looking. The dates will show when they have 5 past days to calculate. Otherwise it'll be blank.

You'll still have to unprotect it to adjust the balances.


Hope it helps 'ya!
Attached File(s)
File Type: zip Forecaster.zip   7 KB | 620 downloads
  • #9
  • Apr 29, 2007 4:22pm Apr 29, 2007 4:22pm
Quoting AggieTrader
No... you're doing everything fine. It's just not designed to be cosmetic.

I've updated it to be a little cleaner looking. The dates will show when they have 5 past days to calculate. Otherwise it'll be blank.

You'll still have to unprotect it to adjust the balances.


Hope it helps 'ya!
Ah, that is much better and works just fine. Now the only other question I have is, is there a way to have the dates fill in for a year or more in advance, once we populate the 5 dates?
  • #10
  • Last Post: Apr 29, 2007 5:23pm Apr 29, 2007 5:23pm
You could try filling in the "actual dates" in advance... then the projected dates should fill in as well. Then you could use it like you are planning to use the projected balance column.

You could plan what you expect the actual dates to be... then as they occur you can update it.
0 traders viewing now