xlquotes is based on the formula "=XLQ()", which you can use like the formula "=SUM()". To see how it works type following formula in an empty cell: =XLQ("YHOO", "LAST") If you are connected to the Internet you will see Yahoo!'s share price immediately. Please read the next section to find out all available functions.
Last Price > "LAST"
=XLQ("YHOO", "LAST")
Closing Price > "CLOSE"
=XLQ("YHOO", "CLOSE")
Absolute Change > "CHANGE"
=XLQ("YHOO", "CHANGE")
Change in Percent > "PERCENT"
=XLQ("YHOO", "PERCENT")
Bid Price > "BID"
=XLQ("YHOO", "BID")
Ask Price > "ASK"
=XLQ("YHOO", "ASK")
Opening Price > "OPEN"
=XLQ("YHOO", "OPEN")
Highest Price > "HIGH"
=XLQ("YHOO", "HIGH")
Lowest Price > "LOW"
=XLQ("YHOO", "LOW")
52 Week High > "52WEEKHIGH"
=XLQ("YHOO", "52WEEKHIGH")
52 Week Low > "52WEEKLOW"
=XLQ("YHOO", "52WEEKLOW")
Dividend > "DIVIDEND"
=XLQ("YHOO", "DIVIDEND")
Trading Volume > "VOLUME"
=XLQ("YHOO", "VOLUME")
Historical Prices
Requesting Historical Prices with xlquotes
xlquotes can display historical share prices as well (CLOSE, OPEN, HIGH, LOW, VOLUME). All you have to do is to add a historical date to the XLQ formula.
Example:
=XLQ("YHOO", "CLOSE", "12302005") for the closing price as of 12/30/2005
Alternative:
=XLQ("YHOO", "CLOSE", "12/30/2005")
or
=XLQ("YHOO", "CLOSE", A1) if there is a date in cell "A1"
Retrieving Exchange Rates
xlquotes for Exchange Rates
An exchange rates can be displayed if you put two ISO currency codes together. Further you need to add the extension "=X" to flag the ticker as exchange rate: =XLQ("EURUSD=X", "BID") oder =XLQ("EURUSD=X", "ASK")
