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

  • #21
  • Aug 6, 2007 7:27am Aug 6, 2007 7:27am
Hi Que,
The code works perfectly!!! Many thanks!!!
  • #22
  • Aug 6, 2007 6:38pm Aug 6, 2007 6:38pm
Hi... this looks like a very useful tool.

I have a question, though - can someone please explain to me how to get the DDE interation between MetaTrader and OpenOffice Calc working? I've enabled DDE in MT, and had a look at the protected cells that are supposed to pull information over the DDE link, but I can't figure it out and don't want to screw anything up.

Cheers!
  • #23
  • Aug 7, 2007 5:14pm Aug 7, 2007 5:14pm
Quoting stevenrocks
Hi... this looks like a very useful tool.

I have a question, though - can someone please explain to me how to get the DDE interation between MetaTrader and OpenOffice Calc working? I've enabled DDE in MT, and had a look at the protected cells that are supposed to pull information over the DDE link, but I can't figure it out and don't want to screw anything up.

Cheers!
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!

Hope that works for you ! If u have any problem post again but beware i am a noob to OpenOffice Calc/excel but i am studying OpenOffice for Dummies lol!

Have a nice day!
  • #24
  • Aug 11, 2007 8:03pm Aug 11, 2007 8:03pm
Sweet, thanks! I'm pretty sure that worked but since it's the weekend all I'm getting is a bunch of N/A's - we'll see what happens when the market's open again.

Cheers!
  • #25
  • Aug 14, 2007 5:17am Aug 14, 2007 5:17am
Hi Que, you are right---the position value. I just checked out I had mistake in my formula. Thanks!
  • #26
  • Aug 17, 2007 4:46pm Aug 17, 2007 4:46pm
What is MT? I tried the program and it would not work.
Check Mate GAME OVER
  • #27
  • Aug 17, 2007 5:35pm Aug 17, 2007 5:35pm
bunton,
MT = MataTrader , a trading platform, google search it, and you'll find a download link.
Que's spreadsheet receive data from MT, so, you need to have MT open so that you can have data updated automatically. if you don't use MT, you can choose to input Manually(in the yellow column)
  • #28
  • Aug 17, 2007 5:52pm Aug 17, 2007 5:52pm
Quoting imjscn
bunton,
MT = MataTrader , a trading platform, google search it, and you'll find a download link.
Que's spreadsheet receive data from MT, so, you need to have MT open so that you can have data updated automatically. if you don't use MT, you can choose to input Manually(in the yellow column)
imjscn, I got it working. I'm using gft platform so mt will not work. I'll play around with the excel sheets..

Thanks...
Check Mate GAME OVER
  • #29
  • Aug 17, 2007 9:17pm Aug 17, 2007 9:17pm
Quoting bunton
imjscn, I got it working. I'm using gft platform so mt will not work. I'll play around with the excel sheets..

Thanks...

Sorry for te late reply to this, but you can get any Demo Account that uses the MT4 platform and have it work that way. This is what several people who use this spreadsheet do.
Que
  • #30
  • Aug 17, 2007 9:23pm Aug 17, 2007 9:23pm
Hi Que, Thanks for your great work budddy. This may sound like a stupid question to you. How can I find some basic information how to download your indicators to MT4 etc etc. I just checked the Meta trader website. Didnt have much luck understanding what to do..

Thanks in advance
  • #31
  • Aug 17, 2007 9:29pm Aug 17, 2007 9:29pm
If you pulled the Zip file from the thread, there is a readme I made that describes the process.

If you are having troubles you can hit me up on Skype or via PM. I will be glad to help.
Que
  • #32
  • Aug 17, 2007 9:31pm Aug 17, 2007 9:31pm
Quoting Que
If you pulled the Zip file from the thread, there is a readme I made that describes the process.

If you are having troubles you can hit me up on Skype or via PM. I will be glad to help.
Great Que.. I will give it a go.. Sorry for the off topic question
  • #33
  • Aug 17, 2007 9:36pm Aug 17, 2007 9:36pm
Quoting auslanco
Great Que.. I will give it a go.. Sorry for the off topic question
No problem, you will find I am open and will answer anything I can. I try to contribute to the comunity and not just be a leach or someone who constantly puts off negitive vibes....
Que
  • #34
  • Aug 17, 2007 11:34pm Aug 17, 2007 11:34pm
1. download indicators you like;
2. save them to this folder(if you installed MT here, if not, find your path to this folder):
C:\Program Files\MetaTrader 4\experts\indicators
3. close MT platform(if it is still open);
4. open MT platform;
5. in "custom indicators" list, you'll find the indicators you just saved.
  • #35
  • Aug 19, 2007 5:51am Aug 19, 2007 5:51am
Quoting imjscn
1. download indicators you like;
2. save them to this folder(if you installed MT here, if not, find your path to this folder):
C:\Program Files\MetaTrader 4\experts\indicators
3. close MT platform(if it is still open);
4. open MT platform;
5. in "custom indicators" list, you'll find the indicators you just saved.

HI imjscn,
Thanks very much for the step by step guide to set up the indicators. Big help for a tech dummy like myself. I managed to get it on to my MT4 charts.
  • #36
  • Aug 19, 2007 5:53am Aug 19, 2007 5:53am
Quoting Que
No problem, you will find I am open and will answer anything I can. I try to contribute to the comunity and not just be a leach or someone who constantly puts off negitive vibes....
Thanks you Que.. Your indicators are up & running on my MT4 charts. Looks awsome. Cant wait to try them on Monday.
  • #37
  • Apr 12, 2008 8:31pm Apr 12, 2008 8:31pm
Bump
Que
  • #38
  • Apr 14, 2008 2:33pm Apr 14, 2008 2:33pm
Just wanted to say a quick thanks Que. Your MM calc sheet and journal are awesome. I know a lot of work had to go into this, so Thanks! I look forward to using it regularly.
  • #39
  • Apr 20, 2008 6:38pm Apr 20, 2008 6:38pm
np man
Que
  • #40
  • Apr 20, 2008 8:04pm Apr 20, 2008 8:04pm
Hi Que - Nice work. I also have Openoffice - I had no prob w/ DDE - just selected Metatrader and IBFX no and a the sheet started updating as it should. If I run into anything I'll let u know.
In trading, there is no bullshit. You either make money or you don't.
0 traders viewing now