Reklāma
MS Excel / MT4 Help...
Jan 25, 2017 at 07:54
858 Views
1 Replies
Biedrs kopš
1 ieraksti
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?
Biedrs kopš
11 ieraksti
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
*Spams netiks pieļauts, un tā rezultātā var slēgt kontu.
Tip: Posting an image/youtube url will automatically embed it in your post!
Tip: Type the @ sign to auto complete a username participating in this discussion.
