Que's MM Calc and Log | Page 4 | Forex Factory

Options

Go to
Permalinks
Print Thread

Similar Threads

Fibo Calc indicator 74 replies

Replace Moving Average Calc in EA with Calc of MA Indie 2 replies

Multiple currency trading calc 1 reply

MT4 Strategy tester include margin calc in drawdown? 0 replies

Spreadsheet to calc drawdown 0 replies

Attachments: Que's MM Calc and Log
Exit Attachments

Que's MM Calc and Log

  • #61
  • Jan 10, 2009 3:45am Jan 10, 2009 3:45am
Hello Que,

Wow, I am blown away by your spreadsheet, thank you. It is exactly what I have been trying to develop myself over a period of time, but didn't quite get there!

At this stage I have only one question if that is OK, and that is in regards to the base currency.
You have included USD, EUR, GBP and CHF in the list.
However my account is in Australian Dollars (AUD), so I will need to add it in if my figures are going to be accurate.

Would it be possible for you to add this in for me, or tell me how to do it. I am sure it isn't just a matter of adding it to the list.

Your help would be greatly appreciated.

Thanks again for a great tool!

Tim
  • #62
  • Jan 12, 2009 5:22pm Jan 12, 2009 5:22pm
Hi,
Thanks for the very fine work.

I also need to modify it for Yen, as I have a yen account and a US$ account from different brokers. AUD would be great as well.

If you can't modify it could you explain the best way?

As far as I can see the listbox with the currencies is populated via the VB macros for data sheet and the trading log. Is it just a matter of modifying this code? I'm not sure what the key code for the various currencies mean though in the macro?

Any help/guidance appreciated!

Many thanks,
sv
  • #63
  • Apr 25, 2009 8:41am Apr 25, 2009 8:41am
Hello Que,

Woww, I am blown away by your spreadsheet, thank you. It is exactly what I have been trying to develop myself over a period of time, but didn't quite get there!

BTW is awesome!!

Que, how can you add-in new forex data i.e. CAD/JPy or USD/SEK..... I have tried editting and adding this new data fields but have constantly been blocked from editing . So can u pls offer me a way to somehow add-in new data like CAD/JPY into the calulog. thanx

PS... help from other memeber will be greatly appreciated
Prices are never too high to begin buying or too low to begin selling.
  • #64
  • Sep 22, 2009 3:44pm Sep 22, 2009 3:44pm
Bump, because I can...
Que
  • #65
  • Sep 27, 2009 9:03am Sep 27, 2009 9:03am
Thank for your time and effort, I have been currently working on putting together a simpler version of similar calculator in excel, but my math failed me and I put that project of a back shelf. I am glad I stumbled on this one.
Any updates for the C# version?
  • #66
  • Sep 27, 2009 10:44am Sep 27, 2009 10:44am
Quoting LasVahGoose
Really cool spread sheet. I was wondering if there was anyway to add nano lots to it?


Thank You.
This would be useful if you can do it Que. Pretty please.
  • #67
  • Sep 27, 2009 2:57pm Sep 27, 2009 2:57pm
Peter,

I can not promise anything right now. I am kind of busy and to be honest, I am behind the curve on the excel spreadsheet. It has been a long time since I did anything with it. It is pretty complex and there are several places that need to change.

However, I will say that another trader and myself are working on a C# version of this project. I am unsure how much I am allowed to say on this forum (Do not want to break any rules), but it will most likely not be free. We have not determined any price structure (Likely $20 or so), but it will be far more feature rich than this calculator.

Some of the feature we would like to implement:

1. Standard, Mini, Micro, and Nano sizes.
2. Ability import logs from MT4 or other platforms.
3. Ability to pick feeds from other platforms.
4. Search and filtering features with the ability to chart
---- I am not sure if I am saying that right. Basically the ability for you to filter past trades based on pair, long/short, size and even system used. Then graph performance over time.
5. Ability to interact with a custom indicator so that information can be displayed in MT4 directly.
6. More currency pairs.
7. More home currency options.

And many more. This is a pretty big project, but we feel as if it is an integral part of trading. It will not make you a single dime. However, it may save you money in the long run.

Que.


Quoting PeterFM
This would be useful if you can do it Que. Pretty please.
Que
  • #68
  • Sep 27, 2009 3:13pm Sep 27, 2009 3:13pm
Quoting Que
Peter,

... We have not determined any price structure (Likely $20 or so), but it will be far more feature rich than this calculator.

This is a pretty big project, but we feel as if it is an integral part of trading. It will not make you a single dime. However, it may save you money in the long run.

Que.
That sounds fair - time is money and all that. Put me down for beta testing if you like and at that price point it looks like it will be money well spent.

Thanks for the response. Good to know you're still looking toward a profitable future in FX.
  • #69
  • Sep 28, 2009 12:25am Sep 28, 2009 12:25am
Quoting Que

I am not sure if I am saying that right. Basically the ability for you to filter past trades based on pair, long/short, size and even system used. Then graph performance over time.

5. Ability to interact with a custom indicator so that information can be displayed in MT4 directly.

It will not make you a single dime. However, it may save you money in the long run.

Que.
Good luck with this projetc, and please be sure to let us know the outcome.

  • #70
  • Oct 1, 2009 9:55pm Oct 1, 2009 9:55pm
Quoting AidanPryde
Hi !
Unprotext ur Cells and then change the following Code @ the "MT4 Exchange Ask " Column..

for example USD/JPY

Original Code: =IF($L$2="Yes";DDE("MT4";"ASK";"USDJPYm");DDE("MT4";"ASK";"USDJPY"))

New Code:
=IF($L$2="Yes";DDE("MT4";"ASK";"USDJPYm");DDE("MT4";"ASK";"USDJPY";1))

Pay Attention that i did not change the USD/JPYm as i dont use an IBFX Mini!

Only add the ;1!
Hey Que thanks for all the hard work on this MM tool. Ive been using the calculator for a while but have finally looked into using the log to help analyze my results. So ive been reviewing this thread trying to get the DDE quotes to work in excel but have been unsuccessful. I have enabled DDE in MT4 options but it still isnt working.

I have also reviewed the above quote but i presume it is intended for OpenOffice which i dont have...is that correct?

Anyway i must be doing something wrong. Im also using the broker, MB Trading, which is a 5 digit broker which might have something to do with it, as it seems youre using a 4 digi broker in your MM.

Any help would be greatly appreciated!

Thanks,

Magellan42
Around the world in 80 pips....
  • #71
  • Dec 24, 2009 4:02am Dec 24, 2009 4:02am
I would be more than willing to pay for an extended version of your MM calc. How's this project going ?
Measure twice, cut once
  • #72
  • Dec 24, 2009 4:48am Dec 24, 2009 4:48am
Quoting Magellan42
....
I have also reviewed the above quote but i presume it is intended for OpenOffice which i dont have...is that correct?...
in case u want it, just fyi, Open Office is free.
  • #73
  • May 21, 2010 4:28pm May 21, 2010 4:28pm
Hi All,

Has anyone developed an excel based money management calculator or log that they feel bests the version that Que loaded at the start of this thread? So far it is the best I've found. I've been working on developing a trading system for about a year now and want to have some very solid money management tools in hand before I start trading a live account.

Thanks Everyone!
  • #74
  • Sep 19, 2010 11:54pm Sep 19, 2010 11:54pm
Hi,

Amazing work, however, i wanted to add an S&P section as i am not using it for just forex.

I tried to un-protect the cells but says i need a password?

If it is possible could anybody provide me with the password? Maybe even guide me on adding a S&P section to the list...I am computer proficient so you won't have to make it amazingly detailed.
  • #75
  • Nov 6, 2010 6:01am Nov 6, 2010 6:01am
Quoting andre3k
Hi,

Amazing work, however, i wanted to add an S&P section as i am not using it for just forex.

I tried to un-protect the cells but says i need a password?

If it is possible could anybody provide me with the password? Maybe even guide me on adding a S&P section to the list...I am computer proficient so you won't have to make it amazingly detailed.
Password = "forex"
w/o double quote
  • #76
  • Mar 10, 2011 10:28am Mar 10, 2011 10:28am
I know I am late to the party, but can I get a copy of that spreadsheet? Or are you selling it?
  • #77
  • Mar 10, 2011 10:31am Mar 10, 2011 10:31am
I am also willing to pay. Please shoo me pm please thnx
  • #78
  • Apr 26, 2012 3:05pm Apr 26, 2012 3:05pm
Does anyone know how to add other pairs to this brilliant MM calculator??

PM me
  • #79
  • Jul 26, 2012 12:09am Jul 26, 2012 12:09am
Has anyone managed to include another base currency? My account is in AUD and the sheet only has USD EUR GBP & CHF. So a work around would be great if anyone has got one

Wilbur
  • #80
  • Aug 24, 2012 2:17pm Aug 24, 2012 2:17pm
Quoting lehmann
Does anyone know how to add other pairs to this brilliant MM calculator??

PM me
Did you ever find how to add a base pair on this sheet?

Wilbur
1 trader viewing now