I need to update a spreadsheet figure from the internet on a daily basis. the figure is an exchange rate.?

Question

I have a spreadsheet that contains the exchange rate between the £ and the €. I have to update it quite a few times a day from a website. Is there a method whereby I can link that website to the spreadsheet in order that the number will update automatically?

Answer 1

Yes, you have to know VBA or, even better, VB.NET(if your spreadsheet is in MS Excel, there are other languages for other applications), and write a macro which does it for you. Or get the macro written by someone, it wouldn't be a big deal for someone who has programmed both macros and web.

Answer 2

depnds on the spreadsheet you are using you could write a macro / function to retrieve the value. there are also RSS feeeds that do the same job

you will need to carefully design it to handle if the internet connection wasnt working or was broken but it should work OK.

I did soemthing similar a while back using Excel, admittedly on a intranet so we 'knew' the server would always be there, but the principle is the same

if the worst come to the worst you may have to download the page, save it as HTML and readt through the file

Answer 3

depnds on the spreadsheet you're utilising you're able to write a macro / place to retrieve the importance. there are additionally RSS feeeds that do the equivalent activity you're able to have have been given to carefully format it to regulate if the information superhighway connection wasnt working or grew to become into as quickly as broken in spite of the undeniable fact that it would desire to paintings ok. I did soemthing equivalent a on the comparable time lower back utilising Excel, admittedly on a intranet so we 'knew' the server would desire to consistently be there, in spite of the undeniable fact that the belief is the equivalent if the worst come to the worst you additionally can would desire to download the information superhighway website, positioned it aside as HTML and readt via way of the record

Answer 4

Go to somewhere like elance and get a quote for a macro or look at getting an RSS feed from the web site. This can go onto your desktop or feed into your spreadsheet.

Answer 5

Yes, you can make a program in php to do his and will take a timed snapshot of he exchange rate and then reload your spreadsheet.

You would be better to ask for a programmer in php to make a program to be made for you.