View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F[_2_] Dave F[_2_] is offline
external usenet poster
 
Posts: 187
Default Formula For Regularly Importing Internet Data

What version of Excel are you using? If, for example, you're using XL
03 for Windows you can use the "Get external data" tool under the Data
menu to generate a web query. That web query could be attached to a
button on your spreadsheet to refresh.

That's just one example of how you could do this. There are also
templates available which extract stock prices from various web
services; presumably these could be modified for FOREX purposes.

Dave

On Aug 1, 10:36 am, Jonathan Hartley <Jonathan
wrote:
I was wondering whether it is possible to regularly update a particular piece
of data in excel. I'm currently working with exchange rates, so it would be
wonderful excel to obtain the exact exchange rate from a particular website
and pasting that into a designated cell. If it could do this regularly, that
would be fantastic.

Thanks,
Jonathan