Exchange rates

Topic

New Reply

Good afternoon

I am making a type of dashboard that involves values in £ but I wonder if it is possible to have another couple of cells with Francs and Euro rates of exchange on them which would open and update via the web when the workbook was opened so that I could do live daily conversions.

Has anybody done anything similar to point me on my way?

Reply | Quote

Replies

You could add a webquery to your sheet, e.g. using this url: http://www.thomasexchangeglobal.co.uk/exchange1.php
And use the data of that page to do the calcs.

Reply | Quote

You could add a webquery to your sheet, e.g. using this url: http://www.thomasexchangeglobal.co.uk/exchange1.php
And use the data of that page to do the calcs.

Thanks Jan Karel

I will give this ago, my powers of ‘Google’ must have left me

Reply | Quote

Thanks Jan Karel

I will give this ago, my powers of ‘Google’ must have left me

Following Jan Karel’s excelent advice I made my first web query at work and it worked fine, everytime I opened the WB it updated the table and subsequently worked in my currency calculations.

I saved the WB to my memory stick to work on at home but the little refresh widget malarky has disappeared, 3 questions please

1. How can I open it again
2. How can I have it open whenever the WB opens instead of manually open it, and most preferable
3. Could I make my own button “Refresh rates” for example so I could hide the standard wizard and make my WB look cleverer (?more clever)

Reply | Quote

Following Jan Karel’s excelent advice I made my first web query at work and it worked fine, everytime I opened the WB it updated the table and subsequently worked in my currency calculations.

I saved the WB to my memory stick to work on at home but the little refresh widget malarky has disappeared, 3 questions please

1. How can I open it again
2. How can I have it open whenever the WB opens instead of manually open it, and most preferable
3. Could I make my own button “Refresh rates” for example so I could hide the standard wizard and make my WB look cleverer (?more clever)

Hi all

I have ‘kind of’ sorted it by recording a macro and assigning it to a button

Thanks

Reply | Quote