MS Excel / MT4 Help...
Jan 25, 2017 at 07:54
843 การดู
1 Replies
เป็นสมาชิกตั้งแต่ Aug 04, 2015
1 โพสต์
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
13 โพสต์
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
*การใช้งานเชิงพาณิชย์และสแปมจะไม่ได้รับการยอมรับ และอาจส่งผลให้บัญชีถูกยกเลิก
เคล็ดลับ: การโพสต์รูปภาพ/youtube url จะฝังลงในโพสต์ของคุณโดยอัตโนมัติ!
เคล็ดลับ: พิมพ์เครื่องหมาย @ เพื่อป้อนชื่อผู้ใช้ที่เข้าร่วมการสนทนานี้โดยอัตโนมัติ
