The PSQ function
One function, one cell per value. The first argument is the ticker symbol, the second names the value. Without a second argument PSQ returns the last price.
=PSQ(A1) · =PSQ(A1;"OPEN") · =PSQ(A1;"CP")
A German Excel separates arguments with a semicolon, an English one with a comma.
| Second argument | Returns |
|---|---|
PRICE, CLOSE, LAST |
Last price. Also the result without a second argument. |
OPEN |
Opening price |
LOW, HIGH |
Low and high of the day |
LOW52, HIGH52 |
52-week low and high |
VOLUME |
Volume |
CHANGE |
Change against the previous close |
CHANGEPERCENTAGE, CP |
Change in percent |
NAME |
Company name |
TICKER, SYMBOL |
Ticker symbol |
EXCHANGE |
Exchange |
DATE, TIME |
Date and time of the last query, not of the last trade. The Google Finance API stopped returning trade times. |
Versions
- 2007: first version for Excel 2007, user-defined functions plus a ribbon tab, modelled on the MSN add-in
- 2009: installer for Excel 2007 and 2010
- 2013: version for Excel 2013
- 2017: version for Excel 2016
- November 2017: Yahoo terminates its finance API, the add-in stops working
- January 2018: rebuilt on the Google Finance API, with new ticker symbols, a search dialog and more values
- March 2018: Google terminates the service, the add-in stops for good
Screenshots
