Excel Help | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

MT4 to Excel through Excel RTD (Finally!) 612 replies

I need help with a particular Excel Function and Formula 16 replies

Need a little help of a couple simple function in Excel 13 replies

Need help with Microsoft Excel... 13 replies

Excel Help 0 replies

Excel Help

  • #1
  • First Post: Mar 17, 2011 7:24pm Mar 17, 2011 7:24pm
I need some help in regards to grabbing the open for the month, week and day for an Excel spreadsheet application.

I believe

=MT4|HIGH!EURGBP

grabs the open for the day....but how do I grab the open for the week and month?

Thanks
CanuckCT
  • #2
  • Mar 17, 2011 11:48pm Mar 17, 2011 11:48pm
The DDE interface to Excel provides the raw tick data. As you state the high and open values are for the day. Anything else like weekly, monthly values need to be captured programmaticly. You could try to it with VBA in Excel, but I think in the end a script to capture the desired data in a CSV file that is fed into Excel is simplest and most reliable.
  • #3
  • Last Post: Mar 18, 2011 12:51pm Mar 18, 2011 12:51pm
Thanks


Quoting CodeMeister
The DDE interface to Excel provides the raw tick data. As you state the high and open values are for the day. Anything else like weekly, monthly values need to be captured programmaticly. You could try to it with VBA in Excel, but I think in the end a script to capture the desired data in a CSV file that is fed into Excel is simplest and most reliable.
0 traders viewing now