Currency Import

[DanSD]

Hiya,

i'm currently assembling a basic costing workbook for my company to ease calculations etc. I'd like to import some currency rates as we work in £, $ and R$ but am struggling to access or understand how to do this, can anyone give me some pointers please??

Cheers

Dan

[sudbhavani]

Can you explain it briefly with some examples?

[DanSD]

all i want to do is import the daily rates for Sterling £, US Dollar $ and Brazilian Real R$ so i can cross reference them i.e. £-$, $-R$, £-R$

[cytop]

Import them from where...?

You have to understand you know what you have to work with, no one else does - it's down to you to explain what you're trying to do clearly, and concisely if possible.

[DanSD]

apologies, what i meant to explain that was I didnt know the best place to import from , nor how to!

my bad...

[Tsjallie]

Go to www.xe.com
In the XE Live Exchange Rates table select Change/Remove a currency and select R$ (whatever currency that is)
Right-click somewhere in the table and select Export to Excel

This will open a new workbook with a connection to the XE table.

Go to the Data tab on the ribbon and select Connections
Select Connection and click Properties.
There you can edit the connection name and - more important - the refresh interval.

Finally move the sheet to your workbook and there you have the (up-to-date) currencies available.

[DanSD]

Go to www.xe.com
In the XE Live Exchange Rates table select Change/Remove a currency and select R$ (whatever currency that is)
Right-click somewhere in the table and select Export to Excel

This will open a new workbook with a connection to the XE table.

Go to the Data tab on the ribbon and select Connections
Select Connection and click Properties.
There you can edit the connection name and - more important - the refresh interval.

Finally move the sheet to your workbook and there you have the (up-to-date) currencies available.

All good apart from the fact that i'm now working on a MAC (new to me) so the right click part isn't applicable. - pilot error no doubt, any help?

[Tsjallie]

Never touched a Mac before (only a BigMac) ;-)
I believe pressing the left mouse button while holding the Ctrl button pressed is the Mac-equivalent of the Right-click

[DanSD]

lol, have tried both that and the cmd/apple key and no luck.......just get options for save as, back, forward etc

[Tsjallie]

I'm so happy to have never spend a single penny on Apple
Any chance that you've access to a windows machine?
If not you could post this problem in the Mac-section of the forum.