+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : Importing live forex prices into excel

  1. #1
    Registered User
    Join Date
    12-13-2007
    Posts
    18

    Importing live forex prices into excel

    Hi

    I am having trouble importing the live prices into Excel 2007.

    After looking on the web on how to do it, it says that you can do it from a program called MetaTrader - which I have got on my computer, and the feed comes from there.

    So what it is telling me to do is to post this into the cells and it should work.
    ='MT4'|BID!EURUSD
    ='MT4'|ASK!EURUSD
    ='MT4'|HIGH!EURUSD
    ='MT4'|LOW!EURUSD

    I have enabled the DDE server within Metatrader but with no luck on how to get it working.

    Any help would be appreciated.

    Thanks

    Phil

  2. #2
    Registered User
    Join Date
    05-19-2011
    Location
    Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Importing live forex prices into excel

    1) Download and install Meta Trader 4 program from any brokers
    2) Create new demo account from this installed Meta Trader 4
    3) Log in to your demo account
    4) Open excel
    5) Fomula :
    ='MT4'|BID!EURUSD
    ='MT4'|ASK!EURUSD
    ='MT4'|HIGH!EURUSD
    ='MT4'|LOW!EURUSD

  3. #3
    Registered User
    Join Date
    07-30-2010
    Location
    South Pole
    MS-Off Ver
    Excel 2010
    Posts
    99

    Re: Importing live forex prices into excel

    You can download an Excel spreadsheet that automatically imports daily Forex bid rates into Excel here. You provide a currency pair, two days and then click a button.

  4. #4
    Registered User
    Join Date
    07-30-2010
    Location
    South Pole
    MS-Off Ver
    Excel 2010
    Posts
    99

    Re: Importing live forex prices into excel

    Quote Originally Posted by janschepens View Post
    You can download an Excel spreadsheet that automatically imports daily Forex bid rates into Excel here. You provide a currency pair, two days and then click a button.
    That spreadsheet has moved here: forex excel spreadsheet

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1