Que's MM Calc and Log

Yes i did. shoot me a PM

Hello que and other MM Calculog Fans,

I have used this fantastic tool for some time successfully on a German WinXP and in Openoffice 3.1. Thanks a LOT!
However for some time I have a problem that with refreshing the DDE connections to MT4: The calculations don't work probably because of a formatting problem (exchange of . against , ????). Interestingly all the operations in the spreadsheet are displayed in German. ...and it worked!

Could you please clarify how to preserve the format or which language settings or reformatting may help?

Kind regards
shaban55

Hi,
I found the solution myself!

You have to make sure that language and locale are set to English (USA) for the document.

I attach my perfectly working OpenOffice version. As the .ods format is not accepted by the forum you have to change the file extension back from .txt to .ods to make it work.

Thanks again to que for this great tool!

Hi Lehmann
I have sent you a pm about this, thanks.

Hello @Que, thank you for the kind gesture. I am currently using your spreadsheet and made a few mods on the pairs selected.

I noticed I couldn't get the log to calculate correctly on UK.OIL - is this something you can help with pls?

Also, I use MT4 my brokers make their money on bid/ask spreads, the spreadsheet doesn't take account of this so my final figures are inaccurate.

Could you also help with this pls? Many thanks in advance.

Hello,
coming back to this very old thread, I must say that I have found no free tool yet, that matches the cleverness of this spreadsheet. It is just spot on in the calcumation of position sizes. I have not used the other functions as I don't really understand them...
I recently expanded the choice to 28 currency pairs and want to share it here. As I did not have a full undersatnding of the "untouchable fields", I worked with analogies to my existing and working copies, so I hope everything is correct.

Attached are

1. the original version created in LibreOfficeCalc - the extension .txt has to be changed back to .ods to make it work...
2. a copy in Excel format, however I have not tested it...

Happy calculation and good money management!
Please feed back, if you find mistakes...

Sorry, guys!
Please don't use the files from the previous post!
The calculations for GBP/NZD are wrong.
Corrected files attached.

Can anyone delete the previous attachments?
Thanks and all the best
Sh

after coming across this thread, was moved by this Tool. I got mine totally different from this one. I am still sharpening my skills in Excel. Wanted to know if Que can help me with perfecting my tool as well, especially on the Code for checking status and calculating profit or loss automatically.