Advertisement
MS Excel / MT4 Help...
Jan 25, 2017 at 07:54
866 視聴
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からメンバー
11 投稿
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を投稿すると自動的に埋め込まれます！
ヒント：この討論に参加しているユーザー名をオートコンプリートするには、@記号を入力します。
