MS Excel / MT4 Help...
Jan 25, 2017 at 07:54
720 Visa
1 Replies
Medlem sedan Aug 04, 2015
1 inlägg
Jan 25, 2017 at 07:54
Hello everyone,
I'm looking to create a real-time signal scanner in Excel spreadsheet based on my manual trading strategy in MT4. However, the strategy requires me to use Median Renko bars which are time-independent. With the streamed OHLC data being different compared to time-based candles, this coincidently would affect indicator values. Also, the strategy requires me to analyze multiple bar sizes on any given pair and indicator values would need to reflect that as well.
Is there a way to have the Excel spreadsheet assemble the price data in the same format as the Median Renkos would without having to pull up every currency pair, add the renkos to them, and export the data to Excel via DDE link?
What would be the best way to go about this task?
I'm looking to create a real-time signal scanner in Excel spreadsheet based on my manual trading strategy in MT4. However, the strategy requires me to use Median Renko bars which are time-independent. With the streamed OHLC data being different compared to time-based candles, this coincidently would affect indicator values. Also, the strategy requires me to analyze multiple bar sizes on any given pair and indicator values would need to reflect that as well.
Is there a way to have the Excel spreadsheet assemble the price data in the same format as the Median Renkos would without having to pull up every currency pair, add the renkos to them, and export the data to Excel via DDE link?
What would be the best way to go about this task?
Medlem sedan Aug 21, 2014
13 inlägg
Jan 25, 2017 at 15:44
- enable DDE server in your mt4 platform
- in excel, you get data from a certain symbol using a formula that looks like:
='MT4'|BID!AUDCAD
- write your business logic using this starting point and excel formulas :)
best regards,
Raul
- in excel, you get data from a certain symbol using a formula that looks like:
='MT4'|BID!AUDCAD
- write your business logic using this starting point and excel formulas :)
best regards,
Raul
*Kommersiell användning och skräppost tolereras inte och kan leda till att kontot avslutas.
Tips: Om du lägger upp en bild/youtube-adress bäddas den automatiskt in i ditt inlägg!
Tips: Skriv @-tecknet för att automatiskt komplettera ett användarnamn som deltar i den här diskussionen.
