Finance, Forex and Investments

Is there any method wherein online data available can be linked to excel sheet for calculations?

we are in forex field. the rates keep changing from min to min. but we operate from india and we require to know the indian value as and when the changes takes place. for instanace INDIAN RS is 45.96 the cross currency of USD VS GBP IS 1.823. THEN indian rupee value of GBP IS 45.96 X 1.823 = 83.785. AS THE VALUE OF GBP CHANGES, WE REQUIRE TO CALCULATE THE INR VALUE. THE WEB HTTP IS ONLINE WITH CHANGES EVERY SECOND OR SO. IS THERE ANY METHOD TO DO THIS. APPRECIATE YOUR HELP.REGARDS

Public Comments

1. It's easy as long as the formatting of the web page is reasonably simple, and unchanging. On the Excel menu, choose: Data -> Import External Data -> New Web Query and follow the step-by-step moron-proof instructions :) Rawlyn.
2. i recommend you use currecny exchange script can exchange from indian rupee to gbp directly, but is use php you can see here one of the script http://dadan.indika.net.id/index.php?scripts
3. Here is an add on to buy: http://www.excelbusinesstools.com/solutions.asp?prod=69 OR Try this: http://www.duncanwil.co.uk/xlimport.html
4. You'll need to use a currency exchange web service from your spreadsheet. I cannot do an in-depth explanation but this article should be able to walk you through EVERYTHING that you need (especially the second half of the article): http://www.windowsdevcenter.com/pub/a/windows/2005/02/08/xcel_mm.html Make sure to download Office Web Services Toolkit for the appropriate version of Excel. Good luck!