• 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.

Link exchange rate from website to excel

K

KIM Chanthan

Member
Dear sir or Madam,

Do you have any solution if I want to link exchange rate from other website to excel?
Please view attachment for detail.

Thank for help,
 

Attachments

  • Link exchange rate from web.xlsx
    8.1 KB · Views: 30
Hi Chanthan,

You can use the feature Import from Web under Data Tab to import the current conversion rates from Yahoo Finance portal URL mentioned below :

http://finance.yahoo.com/currency-investing#cross-rates

Please follow the steps given below to import the data from Web:
  1. Navigate to Data tab and click on From Web
  2. In the screen that is popped up enter the following URL
  3. Once the page is loaded, click on the Yellow arrow beside the exchange rate table
  4. Once clicked, the arrow will turn into Green check mark and then click on Import to import this information into Excel
  5. You can use the short cut key Ctrl + Alt + F5 to refresh the data

Once the information is imported, you can refer to this information in your tables for calculation.

Hope that helps!!

Thanks,
Ramesh Kumar.P
 
Ramesh said:
Hi Chanthan,

You can use the feature Import from Web under Data Tab to import the current conversion rates from Yahoo Finance portal URL mentioned below :

http://finance.yahoo.com/currency-investing#cross-rates

Please follow the steps given below to import the data from Web:
  1. Navigate to Data tab and click on From Web
  2. In the screen that is popped up enter the following URL
  3. Once the page is loaded, click on the Yellow arrow beside the exchange rate table
  4. Once clicked, the arrow will turn into Green check mark and then click on Import to import this information into Excel
  5. You can use the short cut key Ctrl + Alt + F5 to refresh the data

Once the information is imported, you can refer to this information in your tables for calculation.

Hope that helps!!

Thanks,
Ramesh Kumar.P
Click to expand...
Thank you very much for such useful information, but will it automatically change following the web if I press Ctrl+Alt+F5?
 
This short cut was used for Refreshing the data after the data is imported into Excel from a Web application.. this short cut is no longer active on the current versions of Excel
 
You must log in or register to reply here.
Back
Top