Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Current Exchange Rate

Status
Not open for further replies.
Topcat04

Topcat04

Technical User
Sep 14, 2007
121
0
0
GB
Hi all
Is there a way of being able to pull in the current exchange rate for a currency conversion from one of the conversion sites, so that each time I open up excel it represents the latest exchange rate?
Thanks for your help,
 
Sort by date Sort by votes
any conversion site that doesn't charge.
I usually use fxtop.com but they want 400 bucks a year

im guessing there are other options such as xe or yahoo?
 
Upvote 0 Downvote
well it all depends on how the site configures their tables.

A simple Web Query can access current data, assuming you can find the correct table.

Start a web query and see how yu can specify the portion of data that you want to return.

Data > Get external data > From web...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

pendle666
  • Locked
  • Question
Excel 2016 VBA - select current sheet regardless of name 1
Replies
3
Views
49
pendle666
pendle666
SherWat
  • Locked
  • Question
Exchange Server on Prem 2010 version 14.03 archiving user
Replies
0
Views
16
SherWat
SherWat
uniopp
  • Locked
  • Question
Office 365/Exchange POP/IMAP access
Replies
3
Views
26
uniopp
uniopp
dcompto
  • Locked
  • Question
Excel 2010: Exlanation of formula for Thanksgiving date of current year 2
Replies
12
Views
16
zelgar
zelgar
BxWill
  • Locked
  • Question
Copy external worksheets to current workbook, Excel vba 1
Replies
1
Views
10
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top