« Webquery: Scraping stock quotes from MSN | Main | Calculating weighted average »
November 08, 2004
Webquery: Scraping FOREX quotes from Yahoo
As a follow on from the previous tip, I show how to grab FOREX quotes from the Yahoo Finance website.Here is the link to the Yahoo FOREX quote for the US dollar against the Japanese yen. A screen shot is shown below. At any given time, we are interested in two values for each currency pair, the bid and the ask.
The URL in this example is http://finance.yahoo.com/q?s=USDJPY=X and the table is HTML__yfncsumtab.
By selecting Edit - Links, you will get the Links popup editor.
With this, you canreview and modify existing Webquery links in your spreadsheet.
Posted by Dave at November 8, 2004 04:07 AM