MT4 to Excel through Excel RTD (Finally!) | Page 29 | Forex Factory

Options

Go to
Permalinks
Print Thread

Related Instruments

EUR/USD, EUR/JPY, GBP/USD

Similar Threads

Calculating EMA strength like RTD on break free trading 0 replies

MT4 RTD API 0 replies

MT4 export to Excel? 8 replies

How to copy profiles in MT4? How to use Excel with MT4? 7 replies

Integration between excel and MT4 prices 3 replies

Attachments: MT4 to Excel through Excel RTD (Finally!)
Exit Attachments

MT4 to Excel through Excel RTD (Finally!)

  • #561
  • Aug 2, 2021 8:04am Aug 2, 2021 8:04am
[quote=PayItForward;13650887]
Quoting mtharwat
{quote} Two different things. See https://www.forexfactory.com/marialuiza for Gap theory and attached .pdf {image}
Thank you PayITForward as you have cleared a big confusion in my head.

I am doing a very similar thing in Excel but I had no idea it is what is referred to as the (GAP) in the PDF. My head was thinking of Price opening with a GAP (as in stocks) although we do not witness gaps in Forex as in the Stock market.

If it were me, I would use the term (Derived value ) rather than (GAP) as the latter is somehow misleading.

-------------------------

@anyone
interested in understanding the whole concept.


One of the ways to calculate CSM is by measuring (current Price - Low of the interval)/(High of the interval - Low of the Interval) * 100.
Then the outcome of all seven pairs of each Currency group is averaged. Some may give it a score. For example, if the percentage is 70, then assign a score of 6 or 7, etc..



Now, let's come to the term (GAP) or as I prefer to name it (Derived Values).
If we have absolute strength of 80 percent for EUR and 30 Percent for USD. This means that the (GAP) or (Derived Value) for EURUSD is (80-30)=50.
Then we can compare this Derived value per interval against the previous one.

Also we compare this Derived value with the actual/real strength of the current candle.

-----------------------------------------------------------

@PayITForward

Cheers,
  • #562
  • Aug 14, 2021 10:33am Aug 14, 2021 10:33am
I have updated the first post as I have another mistake for the calculations in the RSI template to calculate overall Currency Strength:


In order to calculate the average strength of RSIs for a currency pair, we may calculate the average of RSIs among every seven pairs for each of the eight currency groups.
For example RSI of EURUSD + RSI of EURJPY, etc..... Then add the seven values and divide them by 7.

What I did wrong is calculating the inverse of pairs by multiplying -1 * RSI of EURUSD to get the value USDEUR.
The correct formula is 100 - RSI of EURUSD.
For example, if EURUSD RSI = 70 then RSI of USDEUR = 100-70=30 and not -1*70.
When we have an oscillator that only oscillates between 0 and 100 then the inverse of any pair's indicator will be to subtract the value of 100.
  • #563
  • Sep 15, 2021 5:28pm Sep 15, 2021 5:28pm
Quoting Moxy_UK
{quote} {quote} mtharwat & JibalaPasan .... Thanks for the help. I finally Figured it out!!! Looking at the Excel Options => Add-ins page that shows all the Excel Add-ins that are installed, Active and Inactive. I noticed the fxbluelabs.excelrtd add-in was inactive and there was no Location showing where the file is located.. {image} So, I opened up the installation archive and manually extracted the FXBlueExcelRTD.dll file into a folder. Then I registered the DLL .. {image} The Excel Add-ins page now shows the add-in as active and the file location....
Thank you thank you thank you thank you



You saved the day!!!!

I was just about to reinstall Windows and Office to make RTD work!!
  • #564
  • Edited 9:13am Sep 26, 2021 8:22am | Edited 9:13am
hello everyone, i have been using rtd in mt4 (icmarkets). i use a german excel version (2019). after outputting it in excel, I always only see #NV. What am I doing wrong?

example as I enter. account number is of course adjusted.

=RTD("fxbluelabs.excelrtd";;"123456";"balance")
the highest point comes before the fall
  • #565
  • Sep 26, 2021 9:14am Sep 26, 2021 9:14am
Quoting Pivoter
hello everyone, i have been using rtd in mt4 (icmarkets). i use a german excel version (2019). after outputting it in excel, I always only see #NV. What am I doing wrong? example as I enter. account number is of course adjusted. =RTD("fxbluelabs.excelrtd";;"123456";"balance")
Hello guys, the problem is resolved. I had no excel rtd dll file in excel. now it's working.
the highest point comes before the fall
  • #566
  • Oct 8, 2021 12:58am Oct 8, 2021 12:58am
HI
Can anyone explain why MT4 is not reading the account number when I run RTD?
This works fine on one PC, but not on another.
I installed the ICMArkets RTD program just the same as on the other PC, but when I load the EA I get no account number.
I have tried different real and demo accounts but they all do the same thing. And of course, the Excel sheet I am trying to link to gets no details.
DLL's are enabled.
Anyone can tell me where I am going wrong?
Attached Image (click to enlarge)
Click to Enlarge Name: ExcelRTD.PNG Size: 66 KB


Thanks
  • #567
  • Oct 14, 2021 10:46am Oct 14, 2021 10:46am
Dear excel traders
is there a way to export the whole "data window" to excel? That would be a great help because I am much more familiar in R! than in MQLx language

Thank you for any help

Best hundsbua
  • #568
  • Nov 27, 2021 5:45pm Nov 27, 2021 5:45pm
Hi,
Does anyone know how I can record the Oanda Order book data to excel (RTD)? I've uploaded screenshots of what I mean.
Attached Image (click to enlarge)
Click to Enlarge Name: Oanda order book.jpg Size: 60 KB
Attachment g
Attached Image (click to enlarge)
Click to Enlarge Name: Oanda order book data.jpg Size: 128 KB
  • #569
  • Dec 29, 2021 5:56am Dec 29, 2021 5:56am
I have a problem with my excel. Basically I am loading here all the 36 EMA and 12 EMA on all the timeframes. I don't have any problem with loading the 36 EMA. Only on the daily chart most of the pairs don't give me a value. The cell stays on "wait".

Tried to change the cell in 1440, tried in a blanco sheet with same value.. Tried to reboot my pc multiple times nothing changes....
Attached Image (click to enlarge)
Click to Enlarge Name: screenshot.png Size: 84 KB
  • #570
  • Feb 16, 2022 6:47am Feb 16, 2022 6:47am
Quoting Dham31956
Hi, Does anyone know how I can record the Oanda Order book data to excel (RTD)? I've uploaded screenshots of what I mean.{image}4091567 {image}
Hey Dham31956, were you able to ever discover this?
  • #571
  • Mar 13, 2022 12:37pm Mar 13, 2022 12:37pm
Dear

I have developed my excel
and when I have re-opened it , it took more than 20 minutes to open and all the value has been disappeared while the formula is there

i tried to type in a new formula in a different sheet and it worked
so not sure what's the issue

can someone help me please
Attached Image (click to enlarge)
Click to Enlarge Name: screenshot.png Size: 77 KB
  • #572
  • Mar 13, 2022 12:41pm Mar 13, 2022 12:41pm
I will really appreciate it if someone know how to fix the longtime to open the excel
it really took a very longtime to open after putting all the needed information
  • #573
  • Mar 19, 2022 12:52am Mar 19, 2022 12:52am
Quoting al-sayed
I will really appreciate it if someone know how to fix the long time to open the excel it really took a very long time to open after putting all the needed information
Excel RTD is not the best option when it comes to fast performance, it is very slow. It will take a long time to open if you have a lot of cals to do in excel.
Have you tried to disable the auto calculation to manual? it may help with faster opening of the file but will slow again when you manually trigger the calculation.
Trading is SIMPLE not EASY.
  • #574
  • Apr 22, 2022 5:52am Apr 22, 2022 5:52am
Can U help me?

The question in attached image.

Thank you so much
Attached Image (click to enlarge)
Click to Enlarge Name: Screenshot (450).png Size: 72 KB
  • #575
  • May 17, 2022 3:43am May 17, 2022 3:43am
Hello everyone,

Thanks for everyone who contributed in this great thread, I learned a lot from it.

I was wondering if I can use RTD to send orders to mt4 to draw a horizontal line or a ray? is it possible? and how?
  • #576
  • May 30, 2022 10:30am May 30, 2022 10:30am
Quoting antariks
Is this programmable? I am happy to share a good strategy if this can be done. Thanks {image}
Can anyone add to this file so that they open live positions by the selected frames, sell if all frames are negative, and buy if all frames are positive
  • #577
  • May 31, 2022 1:22pm May 31, 2022 1:22pm
Quoting ahmad-alhwit
{quote} Can anyone add to this file so that they open live positions by the selected frames, sell if all frames are negative, and buy if all frames are positive
I mean by that, Executing a buy or sell order when the condition is met in Excel
  • #578
  • Jun 22, 2022 11:16pm Jun 22, 2022 11:16pm
Hi

Anyone know how to close a certain pair

All i can find is Close all

strResult = cmd.SendCommand(Range("B1").Value, "CLOSEALL", "", 20)

I need to just close GBPAUD for example.

Cheers
  • #579
  • Jul 3, 2022 9:51pm Jul 3, 2022 9:51pm
Close a Certain Symbol

Set cmd = CreateObject("FXBlueLabs.ExcelCommand")
strResult = cmd.SendCommand(Range("B1").Value, "CLOSESYMBOL", "s=EURUSD", 20)


VBA Code to play with down the page there is another one some where also maybe better.

MT4 to Excel through Excel RTD (Finally!) | Page 20 | Forex Factory

All these workbooks that all the members have kindly let be downloaded are a good start for sure
Pity there isn't more code available for us novices

  • #580
  • Jul 7, 2022 12:30am Jul 7, 2022 12:30am
hi im new to excel rtd, have managed to get 30min candle closes but is there a way where it can start forming at 0gmt and then keep going till next day and then reset.
0 traders viewing now