Thread: [Solved] Web Query - Bank Rates
View Single Post
 
Old 10-16-2014, 04:53 PM
mattjoslyn11 mattjoslyn11 is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Oct 2014
Posts: 1
mattjoslyn11 is on a distinguished road
Unhappy Web Query - Bank Rates

HELP! I've been put in charge of creating a template with which our whole office will use. I need to have the excel doc continually be syncing with the internet. Essentially what I am doing is creating what we call a Loan Matrix and I need the daily market rates updating non-stop. I've read many forums on how to try to do this but to no avail. Here is one I tried:

http://office.microsoft.com/en-001/e...010218472.aspx

For example I want 1 cell to contain a USD 3-Month Libor rate. These rates can be found at: http://online.wsj.com/mdc/public/page/2_3020-libor.html

Please walk me through this process. I can't seem to hone in on that one cell, let alone keep it updating all the time.

Thanks
Reply With Quote