Moving Average Price to Excel | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

MT4 to Excel through Excel RTD (Finally!) 612 replies

Simple Moving Average Vs. Moving Average? 8 replies

Does Moving average actually act as moving S/R ?? 20 replies

Price = Moving average 5 replies

Moving average of another indicator instead of price 3 replies

Attachments: Moving Average Price to Excel
Exit Attachments

Moving Average Price to Excel

  • #1
  • First Post: Jul 5, 2017 6:38pm Jul 5, 2017 6:38pm
Hello,

Im trying to export simple moving average prices to excel at different time frames to do some things to improve my trading methodology but im having some trouble while doing this.. does anyone know what youd be the best way to do this? do I need an api? I dont know if its possible to bring it directly from MT4? I thinks its not..

I found this data feed from interactv brokers on the internet (its paid I think) which I could use... but it's historical data (I have preference for real time updates not historical data). Picture below shows an ideia of what Im looking for.. appreciate any feedback thanks
Attached Image (click to enlarge)
Click to Enlarge Name: Sem título.png Size: 41 KB
  • #2
  • Jul 5, 2017 8:39pm Jul 5, 2017 8:39pm
Its not as easy as it looks, so I doubt you find anything free. I haven't looked in several years, but there are several similar threads and nobody mentioned anything.(
  • #3
  • Jul 6, 2017 8:49am Jul 6, 2017 8:49am
Quoting CodeMeister
Its not as easy as it looks, so I doubt you find anything free. I haven't looked in several years, but there are several similar threads and nobody mentioned anything.(
Thanks for your feedback. Hm well do you know some place that I can get it, even if its paid? Maybe I will need an api service? Find this one at oanda, not sure if this would fit my needs, guess ill ask to them - http://developer.oanda.com/rest-live/rates/
  • #4
  • Jul 6, 2017 2:48pm Jul 6, 2017 2:48pm
My knowledge is several years old, so is of limited value. Here is one of the threads I was referring to. There are others.

https://www.forexfactory.com/showthr...el#post6451643
  • #5
  • Jul 6, 2017 8:02pm Jul 6, 2017 8:02pm
Quoting CodeMeister
My knowledge is several years old, so is of limited value. Here is one of the threads I was referring to. There are others. https://www.forexfactory.com/showthr...el#post6451643
thanks for your help, ill take a look on this thread!
  • #6
  • Jul 7, 2017 12:07am Jul 7, 2017 12:07am
Check out this thread.

https://www.forexfactory.com/showthread.php?t=676853
  • #7
  • Jul 7, 2017 10:50am Jul 7, 2017 10:50am
Quoting Nicholishen
Check out this thread. https://www.forexfactory.com/showthread.php?t=676853
thanks ill take a look
  • #8
  • Jul 8, 2017 5:30pm Jul 8, 2017 5:30pm
Quoting odines
Hello, Im trying to export simple moving average prices to excel at different time frames to do some things to improve my trading methodology but im having some trouble while doing this.. does anyone know what youd be the best way to do this? do I need an api? I dont know if its possible to bring it directly from MT4? I thinks its not.. I found this data feed from interactv brokers on the internet (its paid I think) which I could use... but it's historical data (I have preference for real time updates not historical data). Picture below shows an...
It's an easy task if you use Excels RTD() function.

The Excel RTD app has some built-in indicator calculations which you can request using formulas. You can calculate a simple moving average (i.e. arithmetic mean) using the @sma indicator. For example, the following formula does an average of the median prices for the last 10 bars on GBP/USD M5:

=RTD("YOUR_BROKERS.ExcelRTD", , "YOUR_ACCOUNT_NUMBER", "@sma,GBPUSD,M5,median,10,0")

The indicators parameters are as follows:

Parameter | Meaning
symbol | Symbol name, e.g. GBPUSD
timeframe | Bar timeframe, as a number of minutes or a notation such as H1 or M5
data | Data to use from each bar, e.g. close or high
period | Number of bars to calculate the average over
shift | Bar shift, e.g. zero in order to get the current value of the indicator

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #9
  • Jul 9, 2017 1:13pm Jul 9, 2017 1:13pm
Quoting JibalaPasan
{quote} It's an easy task if you use Excels RTD() function. The Excel RTD app has some built-in indicator calculations which you can request using formulas. You can calculate a simple moving average (i.e. arithmetic mean) using the @sma indicator. For example, the following formula does an average of the median prices for the last 10 bars on GBP/USD M5: =RTD("YOUR_BROKERS.ExcelRTD", , "YOUR_ACCOUNT_NUMBER", "@sma,GBPUSD,M5,median,10,0") The indicators parameters are as follows: Parameter | Meaning symbol | Symbol name, e.g. GBPUSD timeframe | Bar...
wow thanks a lot, thats what im looking for. Ill take a look at which brokers offers this service, thanks a lot
  • #10
  • Jul 10, 2017 1:27pm Jul 10, 2017 1:27pm
Quoting odines
{quote} wow thanks a lot, thats what im looking for. Ill take a look at which brokers offers this service, thanks a lot
Almost all brokers offer Excel RTD for free if you trade at least a specified amount of lots per month.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #11
  • Jul 10, 2017 7:35pm Jul 10, 2017 7:35pm
Quoting JibalaPasan
{quote} Almost all brokers offer Excel RTD for free if you trade at least a specified amount of lots per month. Jibala
Ye I found some brokers that offers this service, I send a e-mail to Oanda to see if they offer this service because im trading with them atm..

btw I tried to run the Excel RTD EA but im getting "grey arrows", do you know what am I missing? The brokers said it's the firewall/anti-virus but I already turned them off and it still not working
  • #12
  • Jul 11, 2017 2:31pm Jul 11, 2017 2:31pm
Quoting odines
{quote} Ye I found some brokers that offers this service, I send a e-mail to Oanda to see if they offer this service because im trading with them atm.. btw I tried to run the Excel RTD EA but im getting "grey arrows", do you know what am I missing? The brokers said it's the firewall/anti-virus but I already turned them off and it still not working
Imho it has nothing to do with firewall and/or anti-virus. No problem here at all! There might be something wrong with the installation and registration of the system dll's. The setup comes with 3 dll's which are copied to their specific system folders. It's not an EA only! If once the installation is completed and mt4 started you will see a small window which can be pinned on a chart. That's it, you are ready to go!

Attached Image


Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #13
  • Jul 11, 2017 6:56pm Jul 11, 2017 6:56pm
Quoting JibalaPasan
{quote} Imho it has nothing to do with firewall and/or anti-virus. No problem here at all! There might be something wrong with the installation and registration of the system dll's. The setup comes with 3 dll's which are copied to their specific system folders. It's not an EA only! If once the installation is completed and mt4 started you will see a small window which can be pinned on a chart. That's it, you are ready to go! {image} Jibala
alright.. I installed on my computer at office and it worked perfectly, I think there's something wrong with my personal notebook, I dont know what yet. Ill try to reinstall again/check the EA anddlls folders to see what happens, thanks a lot for your help!!
  • #14
  • Jul 13, 2017 6:28am Jul 13, 2017 6:28am
are you looking for a dynamic link which is continually updated and current, or would you be happy with a script that dumps the information into a csv file which could then be opened in excel?

every time you run the script it dumps the new data.
" check out The Traders Outpost "
  • #15
  • Jul 13, 2017 7:45am Jul 13, 2017 7:45am
Quoting RedLineFred
are you looking for a dynamic link which is continually updated and current, or would you be happy with a script that dumps the information into a csv file which could then be opened in excel? every time you run the script it dumps the new data.
Real rime updates.. the Excel RTD already meet my requirements, the only problem im having is that the excel MT4 EA window appears both arrows as grey (insteasted of green) on my trading notebook. I tried on others computers and its working so far so good, couldnt solve this yet
  • #16
  • Jul 13, 2017 1:35pm Jul 13, 2017 1:35pm
Quoting odines
{quote} Real rime updates.. the Excel RTD already meet my requirements, the only problem im having is that the excel MT4 EA window appears both arrows as grey (insteasted of green) on my trading notebook. I tried on others computers and its working so far so good, couldnt solve this yet
Just an idea, but do you have an account with the same Broker you got Excel RTD?

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #17
  • Jul 13, 2017 4:07pm Jul 13, 2017 4:07pm
Quoting JibalaPasan
{quote} Just an idea, but do you have an account with the same Broker you got Excel RTD? Jibala
Not yet, Im using JFD brokers to test Excel RTD.. im probably gonna open a real account with pepperstone to get Excel RTD link I think

I asked jfd about this issue already and they said it was related to firewall/anti-virus or excel security configuration settings
  • #18
  • Last Post: Edited 10:37pm Sep 1, 2019 10:23pm | Edited 10:37pm
Edit: Oh! I just realized I was replying to a one-year-old post. This Excel thing is driving me ....


Quoting odines
{quote} Not yet, Im using JFD brokers to test Excel RTD.. im probably gonna open a real account with pepperstone to get Excel RTD link I think I asked jfd about this issue already and they said it was related to firewall/anti-virus or excel security configuration settings
Hello,

Have a look please at my Thread here, https://www.forexfactory.com/showthread.php?t=944826

and have a look at my second post.

The answer to my question in my second post will be critical if you wish to proceed with an Excel RTD. I have posted the question in MQL5 and in Excel forums and waiting for a response.

When resolved, I intend to make the thread a road map for how to apply all formulas and heatmaps in
Excel, apply TA, etc.. and then backtesting. Generally speaking, my aim from applying TA in Excel is that I want to create scanners for CFDs on Shares. But first I will try to accomplish it with Forex pairs then I will move on with the acquired knowledge to apply the same on shares.

If any of the valuable Excel Brainiacs in this thread have a look at my thread and my second post will be very much appreciated. I know many traders wish to get a kick start with Excel.

I do not want to clutter this thread with my Excel questions. I thought it is not the right place. That is why I pointed out my thread.

Thanks in advance
0 traders viewing now