• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Web Query error

In the attached file, I select the orange cell, then go to Data > From Web or Data > Get Data > From Other Sources > From Web.

In the URL field (with 'Basic' selected) I enter the following website address, to pull in the exchange rate between the US Dollar and the Philippine Peso.

I get the attached error message.

I'm doing this on my personal laptop. How do I fix this error?

Edit: Connecting to https://finance.yahoo.com/quote/EURUSD=X/ seems to work, except I don't see EUR/USD in table 2.
 

Attachments

  • Web Query Error.xlsx
    24.3 KB · Views: 2
  • Web Query Erros Message.png
    Web Query Erros Message.png
    10.6 KB · Views: 1
Last edited:
Cannot replicate your error. When I use PQ to go to the web, it returns several tables without error. Suggest you try again but reboot your machine first.
 
Back
Top