Live Currency Rates in Excel

[mrvino]

Hello

I have a spreadsheet with a long list of prices in GBP that need to be converted to USD, HKD and RMB, they need to be marked up for retail pricing, pull live currency exchange rates and then rounded. I have done this manually but need an embedded solution pulling live exchange rates that can be used ongoing.

What are the ways to make this happen?

Thanks in advance.

 

[mrvino]

Forgot to mention I use Excel 2008 for Mac - if that might make any difference

 

[rs2k]

Hi there and welcome to the board,

I'm not best placed to answer this, but have a look at;
Data>Import External Data>New Web Query

Enter the web site that has the exchange rates, click go. Then choose which tables to import using the yellow arrows. If this works for you, do it all over again but this time record it as a macro, so it will be easy to run whenever you need to update the rates.

Hope this has been of use to you, sorry I cant expand more, but I've only used this on the odd occasion.

Cheers
Colin

 

[pedro-egoli]

This link may be of assistance
http://www.tech-archive.net/Archive/Excel/microsoft.public.excel.programming/2007-06/msg03269.html

Pedro