Advertisement
MS Excel / MT4 Help...
Jan 25, 2017 at 07:54
866 Görüntüleme
1 Replies
Aug 04, 2015 zamanından beri üye
1 iletiler
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?
Aug 21, 2014 zamanından beri üye
11 iletiler
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
*Ticari kullanım ve istenmeyen e-postalara müsamaha gösterilmez ve hesabın feshedilmesine neden olabilir.
İpucu: Bir resim/youtube urlsi yayınlamak, onu otomatik olarak gönderinize gömer!
İpucu: Bu tartışmaya katılan bir kullanıcı adını otomatik olarak tamamlamak için @ işaretini yazın.
