Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data From Web to Excel

Data From Web to Excel

ResolvedVersion 2010

Wed 16 Dec 2015, 15:31 Delegate Lauren said...

Lauren has attended:
Excel Advanced - Formulas & Functions course

Data From Web to Excel

Hi

I would like to have a list of the ask price of exchange rates for every day of the year. We currently type these out manually day-by-day, like this:

| 01/01/2015 | 0.7356 |
| 02/01/2015 | 0.7358 |
| 03/01/2015 | 0.7256 |

I wondered if I could use the "Data > From Web" so that it can look against the table online and then I can refresh it to update.

I have tried following the stages (where you select the little yellow box to import) to the website that we currently use called Oanda.com, but it comes up with a script error.

I am not sure where to look on the Bank of England website, which was one of the examples in your lesson.

Hope you can help!

Wed 16 Dec 2015, 16:01 Trainer Jens said...

RE: Data From Web to Excel

Hi Lauren,

Thank you for the forum question.

I have tested Oanda.com and I also got script errors but that is normal when we do this. Just click NO to the errors. Well you cannot set up a link to this website. The website is build very unusual and the queries return no data to Excel

The linked used on the course is the one below but it does not show historical data.

You may have to look after another website with the information you need.

http://www.bankofengland.co.uk/boeapps/iadb/Rates.asp

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Wed 23 Dec 2015: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Filtering Data in an Excel 2010 Worksheet

When you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter.

You will now see arrows in the top row of all the columns. If you click on an arrow, it will give you some filtering options so you can sort your data into ''Smallest to Largest'' or ''Oldest to Newest'' and so on..

To turn off the filtering, go back to the Home tab and click the Filter button again.

View all Excel hints and tips

Data From Web to Excel

Data From Web to Excel

RE: Data From Web to Excel

Excel articles

Excel tip:

Filtering Data in an Excel 2010 Worksheet