Results 1 to 13 of 13
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Get FX rate from web (Excel 2000)

    I would like to get month end currency exchange rates from the web, so no one needs to input them. I think it can be done through a web query, but I've never done this before, plus I couldn't find a site to link to. Could someone help? Thank you!

  2. #2
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Get FX rate from web (Excel 2000)

    Maybe this will get you started in the right direction.

    1) Open and minimize an instance of Excel
    2) Navigate to the folder C:Program FilesMicrosoft OfficeOfficeQueries
    3) Double click on "Microsoft Investor Currency Rates"

    When I did it, it put data from MSN MoneyCentral Investor into my Excel sheet that I had minimized. Where you go from there as far as editing the query I cannot tell you. There may be another way of calling the query without navigating to the folder, but I stumbled upon it the other evening and could not tell you how to otherwise call the query without saving it first.

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Get FX rate from web (Excel 2000)

    Actually, under the Data/Get External Data menu, selecting "Run saved query" will take you to the same spot, plus evidently a few others.

  4. #4
    New Lounger
    Join Date
    Jan 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Get FX rate from web (Excel 2000)

    Mike,
    Thank you for your reply. I did try as you said. Attached is what I got. I couldn't modify the query to give the currencies that I want, or give me the rates at month end. Is there a way to do it?
    Thank you!
    Attached Files Attached Files

  5. #5
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Get FX rate from web (Excel 2000)

    Y...I get the same thing...Since the sites that you are querying are free, I do not imagine that you have many options about which data you wish to display. If you are set up for online trading, I am sure your brokerage firm could help you get the information you need. Otherwise, I have not really felt the need to delve into the web~excel connectivity issue very much, so I am pretty much out of ideas except as outlined above.

  6. #6
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Get FX rate from web (Excel 2000)

    I did a Data | GetExternalData | NewWebQuery to <A target="_blank" HREF=http://www.trustnet.com/general/rates.asp>http://www.trustnet.com/general/rates.asp</A> and experimented until I found that table 9 was what you want. See attached worksheet. HTH --Sam
    Attached Files Attached Files
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  7. #7
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Get FX rate from web (Excel 2000)

    I went to Data | Get external data | NewWebQuery, hit the browse button and go a Message
    "To use this feature, you must have a World Wide Web Browser such as Microsoft Internet Explorer" !!

    Wonder what I have broken now? <img src=/S/fire.gif border=0 alt=fire width=15 height=15>

    Peter

  8. #8
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Get FX rate from web (Excel 2000)

    Do you have a browser connected to the world-wide-web? Should work with IE or Netscape.
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  9. #9
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Get FX rate from web (Excel 2000)

    Yes, I am using IE5 under Win2K. be a job to browse this lounge with out one! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>


    Peter

  10. #10
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Get FX rate from web (Excel 2000)

    Well duh! I'm totally flumoxed, can you use Data | GetExternalData | RunSavedQuery to run one of the precanned MS ones? Do you have XL2K?
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  11. #11
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Get FX rate from web (Excel 2000)

    I have xl2k, I can get the external data ok if I know the path, I just cant use explorer to browse for it. <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

    Peter

  12. #12
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Get FX rate from web (Excel 2000)

    Can you go to the web site in IE, copy the URL, return to the Excel query, and paste it into the query box?
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  13. #13
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Get FX rate from web (Excel 2000)

    I have not tried it with a web site as such, but the saved Querys work and a html file on my harddrive linked in Ok

    Peter

Posting Permissions

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