Que's MM Calc and Log | Page 3 | 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

  • #41
  • May 8, 2008 6:44pm May 8, 2008 6:44pm
...
Que
  • #42
  • May 14, 2008 7:46pm May 14, 2008 7:46pm
Hi Que
can you show the step how to install it?

Quote
Before this
I put it inside metatrader folder then open.
1.Then i click UPDATE
2.Remote data not accessible.Start Application "MT4.EXE" (Yes)
3.Cannot run "MT4.EXE".The program or one of its components is damaged or missing..

thanks
  • #43
  • May 14, 2008 7:53pm May 14, 2008 7:53pm
If you are talking about the excel sheet, you do not need to place it in the MT4 folder. You can run it from anywhere.

What you need to do is go into your Metatrader 4 (IBFX or any other OEM version) and go to tools > options; then go to the server tab and make sure Enable DDE server is checked.

You may have to choose mini yes in the spreadsheet in order for it to work if you have a mini account.
Que
  • #44
  • May 26, 2008 12:42am May 26, 2008 12:42am
...
Que
  • #45
  • Edited Jun 14, 2008 3:49pm Jun 13, 2008 6:10pm | Edited Jun 14, 2008 3:49pm
Que,

Thanks for this tool. It is awesome!

I just have a few questions. First, I would like to have two MT4 terminals open and run two different Calculog spreadsheets. Is it possible to do this? Or is it limited because there is no way to differentiate between two instances of MT4.exe running simultaneously?

I see you can make minor balance adjustments to correct rounding discrepancies via the SWAP field. But what about when you deposit or withdraw from your balance in the middle of a month/week? It would be nice to have these situations accounted for without skewing the swap totals. Depending on how you trade, swap can be a significant factor in your overall returns. My suggestion is to add generic balance adjustment and description columns so the balance can be updated for such contingencies on the fly and the user can record a brief comment about the adjustment.

I also notice that winning trades which fail to meet one of the minimum defined R:R categories seem to default into the B/E section. If a trader uses large stops, their W/L ratio will not be accurately reflected unless they set the "C" category to 00:1 R:R. I guess my question here is....shouldn't BE/W/L be determined by whether a trade closed above, below, or equal to it's open price....not on whether the trade met any specific R:R goals? To me, a one pip win is a WIN, not a B/E, even if the R:R fell short of 1:1. That doesn't seem to be happening here. I think it would also be helpful if you could show the R:R information on a per trade basis so we could see which category a particular trade falls into.

Finally, I notice in post #31 you reference a "readme" file that is to be included in the .zip file download, but I do not see it in the download I did today. Please know that I offer these points as potential areas of improvement for your already excellent work.


Thanks for producing and SHARING this incredible tool!
  • #46
  • Jun 16, 2008 2:58pm Jun 16, 2008 2:58pm
Que,

I just wanted to add that it would be nice to have a trade date/time field for the log sheet. I think that completes my "wish list"....

Thanks!
  • #47
  • Jun 18, 2008 11:48am Jun 18, 2008 11:48am
Que,

I have a few more questions about some of the fields and the DDE information.

All the data I've entered until today was for historical trades. I just started using the spreadsheet for my first live trades today and I'm puzzled about the values I see in the last two columns of the log, "Adj P/L" and "Adj Balance". I am assuming the "Adj P/L" would be the fluctuating P/L value of my open position as the currency price is updated by MT4. However, the value looks completely wrong. On trade #32, I have 1.0 lot opened short with a pip value of $9.28. It is currently about -50 pips in drawdown, which should be -$464,00. Yet, the "Adj. P/L" shows a positive fluctuating value of $195,496.69. The "Adj Balance" field shows $255,139.79 which is the exact total from the "Balance" field after my last trade plus the current "Adj P/L" value. The account I'm trading is a standard lot demo with 100:1 leverage.

It would seem that the "Adj Balance" and the "Adj P/L" field calculations are incorrect. I am also wondering why there is no current fluctuating "PIP P/L" total or "$P/L" shown for the open trades, since the data is obviously being received for it to be calculated. Are the "PIP P/L" and "$P/L" fields just for static closed trade info? That would be a nice feature if they could be updated live.

I am also noticing that some of the values in the "Adj Bal Entry" field and the "Balance" field continue to be updated by DDE on six or seven of my most recently CLOSED trades. Why would new dynamic data be applied to any field of a closed trade?

I hope you can address these and my previous issues and questions. This is a very useful spreadsheet tool and I hope you are able to tweak and correct some of the things I've mentioned.

Thanks again!
Attached Image (click to enlarge)
Click to Enlarge Name: que_sheet1.jpg Size: 238 KB
  • #48
  • Jun 19, 2008 4:53pm Jun 19, 2008 4:53pm
Quoting Pipskateer
Que,

Thanks for this tool. It is awesome!

I just have a few questions. First, I would like to have two MT4 terminals open and run two different Calculog spreadsheets. Is it possible to do this? Or is it limited because there is no way to differentiate between two instances of MT4.exe running simultaneously?
Correct. Excel can only see one MT4.exe, it can not distinguish as far as I am aware.


Quote
I see you can make minor balance adjustments to correct rounding discrepancies via the SWAP field. But what about when you deposit or withdraw from your balance in the middle of a month/week? It would be nice to have these situations accounted for without skewing the swap totals. Depending on how you trade, swap can be a significant factor in your overall returns. My suggestion is to add generic balance adjustment and description columns so the balance can be updated for such contingencies on the fly and the user can record a brief comment about the adjustment.

Very good point, and I have thought about doing just as you said. I may not impliment this into the spreedsheet though as I am working on a C# version of this calculator that will do things like this as well as graph's, multiple accounts, importing etc...


Quote
I also notice that winning trades which fail to meet one of the minimum defined R:R categories seem to default into the B/E section. If a trader uses large stops, their W/L ratio will not be accurately reflected unless they set the "C" category to 00:1 R:R. I guess my question here is....shouldn't BE/W/L be determined by whether a trade closed above, below, or equal to it's open price....not on whether the trade met any specific R:R goals? To me, a one pip win is a WIN, not a B/E, even if the R:R fell short of 1:1. That doesn't seem to be happening here. I think it would also be helpful if you could show the R:R information on a per trade basis so we could see which category a particular trade falls into.

I do not understand, the R:R's are all user configurable. For me a trade is not a winner unless it meets my minimum R:R. If I counted every 1 pip gain as a win, I think my stats would be very misleading as I would essentially be risking 2% to gain .01%.


Quote
Finally, I notice in post #31 you reference a "readme" file that is to be included in the .zip file download, but I do not see it in the download I did today. Please know that I offer these points as potential areas of improvement for your already excellent work.

Actually, I was refering to Auslanco's question about an indicator I made for his trading method.


Quote
Thanks for producing and SHARING this incredible tool!

You're welcome.
Que
  • #49
  • Jun 19, 2008 4:53pm Jun 19, 2008 4:53pm
Quoting Pipskateer
Que,

I just wanted to add that it would be nice to have a trade date/time field for the log sheet. I think that completes my "wish list"....

Thanks!
Again, an addition to the new C# version.
Que
  • #50
  • Jun 19, 2008 4:56pm Jun 19, 2008 4:56pm
Quoting Pipskateer
Que,

I have a few more questions about some of the fields and the DDE information.

All the data I've entered until today was for historical trades. I just started using the spreadsheet for my first live trades today and I'm puzzled about the values I see in the last two columns of the log, "Adj P/L" and "Adj Balance". I am assuming the "Adj P/L" would be the fluctuating P/L value of my open position as the currency price is updated by MT4. However, the value looks completely wrong. On trade #32, I have 1.0 lot opened short with a pip value of $9.28. It is currently about -50 pips in drawdown, which should be -$464,00. Yet, the "Adj. P/L" shows a positive fluctuating value of $195,496.69. The "Adj Balance" field shows $255,139.79 which is the exact total from the "Balance" field after my last trade plus the current "Adj P/L" value. The account I'm trading is a standard lot demo with 100:1 leverage.

It would seem that the "Adj Balance" and the "Adj P/L" field calculations are incorrect. I am also wondering why there is no current fluctuating "PIP P/L" total or "$P/L" shown for the open trades, since the data is obviously being received for it to be calculated. Are the "PIP P/L" and "$P/L" fields just for static closed trade info? That would be a nice feature if they could be updated live.

I am also noticing that some of the values in the "Adj Bal Entry" field and the "Balance" field continue to be updated by DDE on six or seven of my most recently CLOSED trades. Why would new dynamic data be applied to any field of a closed trade?

I hope you can address these and my previous issues and questions. This is a very useful spreadsheet tool and I hope you are able to tweak and correct some of the things I've mentioned.

Thanks again!
I am currently looking at this, give me some time to respond. I think it may have to do with you not having any adj stop. Again, give me a bit to look into this.
Que
  • #51
  • Jun 20, 2008 9:06pm Jun 20, 2008 9:06pm
Quoting Que

I do not understand, the R:R's are all user configurable. For me a trade is not a winner unless it meets my minimum R:R. If I counted every 1 pip gain as a win, I think my stats would be very misleading as I would essentially be risking 2% to gain .01%.
Thank you very much for addressing my questions.

Yes, I know that I can adjust the three levels of R:R to suit my needs, but as far as a Win/Loss/BE...to me that is a straight matter of pip count...not whether or not a trade meets a predefined R:R criteria. If I decide to get out of a trade early for 5, 10, or even 1 pip, but in doing so, it fails to meet minimum R:R requirements, that's still a winner in my book. In the example you give, you would still have the data that put that trade into the proper R:R field, but your true W/L/BE totals will be skewed. A one pip trade is still a profit, even though the R:R was not up to snuff. You need to know if you are having those types of trades too. And by blending them into the R:R category, they disappear from your data.

But it's all in how we look at it I guess. I just prefer to be able to distinguish between R:R and Win/Loss/BE, rather than congeal them into one piece of data. Give it some thought, perhaps my way will make sense, perhaps not. Either way, I appreciate your work and you taking the time to respond.

Take care and thank you!
  • #52
  • Jun 25, 2008 11:44am Jun 25, 2008 11:44am
Quoting Que
I am currently looking at this, give me some time to respond. I think it may have to do with you not having any adj stop. Again, give me a bit to look into this.
Yes, I find that if I enter an adjusted stop, the dynamic totals seem to be correct at that point. I perceive an "adjusted stop" to be one where I've moved my stop up from it's original position, thereby decreasing or eliminating my risk.
  • #53
  • Jul 27, 2008 6:14pm Jul 27, 2008 6:14pm
Hi Que,

Just 2 questions if you don’t mind please:

1)
Initial Risk = 100% based upon buying 1 standard lot gbp/usd that is equal to $200,000 Position Size. However one of my brokers leverage is 50:1. Therefore I will need actually $2,000 to purchase 1 lot ($200,000) instead and therefore my Initial Risk would be 2%. Therefore is there a way that I can modify your MM CalcuLog Ver 12 excel in the settings to reflect this calculation of 2% rather than 100% Initial Risk that is shows now.


2)
Could you please also explain/give an example of the following below (Risk Reward Ratio) as I have read you instructions and still need some help in this area?

A Trade %
B Trade %
C Trade %


A Trade R:R
B Trade R:R
C Trade R:R

Many thanks Que for your help and for making this spreadsheet.

Kenu.
  • #54
  • Aug 6, 2008 12:38am Aug 6, 2008 12:38am
Quoting Kenu
Hi Que,

Just 2 questions if you don’t mind please:

1)
Initial Risk = 100% based upon buying 1 standard lot gbp/usd that is equal to $200,000 Position Size. However one of my brokers leverage is 50:1. Therefore I will need actually $2,000 to purchase 1 lot ($200,000) instead and therefore my Initial Risk would be 2%. Therefore is there a way that I can modify your MM CalcuLog Ver 12 excel in the settings to reflect this calculation of 2% rather than 100% Initial Risk that is shows now.


2)
Could you please also explain/give an example of the following below (Risk Reward Ratio) as I have read you instructions and still need some help in this area?

A Trade %
B Trade %
C Trade %


A Trade R:R
B Trade R:R
C Trade R:R

Many thanks Que for your help and for making this spreadsheet.

Kenu.
1) Yes this calculator is open source. The pasword is forex. Feel free to alter it to your needs.

2)

A Trade %
B Trade %
C Trade %

These are the % of thrade that successfully met the below requirements.

A Trade R:R
B Trade R:R
C Trade R:R

These are the Risk to reward setting you are qualifying your trades for the purpose of stat gathering on A Trade %, B Trade % and C Trade %.

Example:

Default has A Trade R:R as 2.00:1 or better. So if you risked 30 pips on your initial stop, then you will have to make at minimum 60 pips on the trade for the stat to show it as an A trade.
Que
  • #55
  • Aug 6, 2008 12:43am Aug 6, 2008 12:43am
Quoting Pipskateer
Yes, I find that if I enter an adjusted stop, the dynamic totals seem to be correct at that point. I perceive an "adjusted stop" to be one where I've moved my stop up from it's original position, thereby decreasing or eliminating my risk.
Yes this is correct, but for simplicity, you need to set your adjusted stop as it is really your "Current stop"
Que
  • #56
  • Aug 13, 2008 1:34pm Aug 13, 2008 1:34pm
Many thanks Que; much appreciated!


Quoting Que
1) Yes this calculator is open source. The pasword is forex. Feel free to alter it to your needs.

2)

A Trade %
B Trade %
C Trade %

These are the % of thrade that successfully met the below requirements.

A Trade R:R
B Trade R:R
C Trade R:R

These are the Risk to reward setting you are qualifying your trades for the purpose of stat gathering on A Trade %, B Trade % and C Trade %.

Example:

Default has A Trade R:R as 2.00:1 or better. So if you risked 30 pips on your initial stop, then you will have to make at minimum 60 pips on the trade for the stat to show it as an A trade.
  • #57
  • Aug 13, 2008 4:51pm Aug 13, 2008 4:51pm
hi QUE im a silent follower of the forum and i like your work very much , i hope you could help me out whit this problem that i have , i've been learning to program mql4 and just build my first EA , it was working ok whit MG but i switched to Fxpro and they have fractionary spreads , ex 1.49905 , and it doesnt work anymore , only works if i set TP and SL to 0.0 , please could you help me whit this.
Thanks very much .
  • #58
  • Oct 22, 2008 8:42pm Oct 22, 2008 8:42pm
Hey Que,

I have been using your calc and log for sometime until recently switching to a laptop with newest version of Microsoft office. Have you heard of anyone having problems using your calc or log with the new version?

I have made sure the DDE server is enabled, but I'm always prompted about Macros and links being activated. Everytime I enable them, the calc nor log no longer works with the automatic updates... any idea?

Thanks a ton!

Freedom <><
  • #59
  • Nov 15, 2008 4:55pm Nov 15, 2008 4:55pm
Que,
I like your excel sheet.
I will add it to my trading tools

You did mention a C++ Version.
a) will it be free for us?
b) is it done yet? *g*

Regards, Lowen
  • #60
  • Nov 29, 2008 9:08pm Nov 29, 2008 9:08pm
Really cool spread sheet. I was wondering if there was anyway to add nano lots to it?


Thank You.
Don't wish it were easier, wish you were better. ~ Jim Rohn
0 traders viewing now