...
Que
Fibo Calc indicator 72 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
QuoteDislikedBefore 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..
DislikedQue,
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?Ignored
QuoteDislikedI 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.
QuoteDislikedI 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.
QuoteDislikedFinally, 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.
QuoteDislikedThanks for producing and SHARING this incredible tool!
DislikedQue,
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!Ignored
DislikedQue,
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!Ignored
Disliked
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%.Ignored
DislikedI 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.Ignored
DislikedHi 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.Ignored
DislikedYes, 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.Ignored
Disliked1) 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.Ignored