Set range of ticker symbols to use for quotes.

Syntax: ESQSymbols( Range,Title )

Range is the range of cells containing valid ticker symbols.
Title is the text that will appear in the cell.


Remarks:

• This function must be in your spreadsheet because it actually retrieves the data from the Internet.
• Make sure that when you add new ticker symbols to your spreadsheet that the range includes the new symbols.

Example: Cells A1:A4 contain the following ticker symbols for four stocks: CSCO, INTC,IBM, and NT, respectively.
ESQSymbols(A1:A4,"Symbols")Get last reported trade price for ticker symbol.

Syntax: ESQPrice( Symbol )

Symbol is a valid ticker symbol


Remarks:

• It's possible that the market data returned is 15-20 minutes delayed. If real time quotes are enabled, it's also possible that the quote server doesn't have real time data for this ticker symbol. If the stock is thinly traded, real time data might not be available.
• If you see zero, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the symbols you use, otherwise ESQuotes won't get any data for the symbol.
• Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQPrice(A1)Get today's reported high market price for ticker symbol.

Syntax: ESQHigh( Symbol )

Symbol is a valid ticker symbol


Remarks:

• It's possible that the market data returned is 15-20 minutes delayed. If real time quotes are enabled, it's also possible that the quote server doesn't have real time data for this ticker symbol. If the stock is thinly traded, real time data might not be available.
• If you see zero, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the symbols you use, otherwise ESQuotes won't get any data for the symbol.
• Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQHigh(A1)Get today's reported low market price for ticker symbol.

Syntax: ESQLow( Symbol )

Symbol is a valid ticker symbol


Remarks:

• It's possible that the market data returned is 15-20 minutes delayed. If real time quotes are enabled, it's also possible that the quote server doesn't have real time data for this ticker symbol. If the stock is thinly traded, real time data might not be available.
• If you see zero, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the symbols you use, otherwise ESQuotes won't get any data for the symbol.
• Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQLow(A1)Get today's reported total share volume for ticker symbol.

Syntax: ESQVolume( Symbol )

Symbol is a valid ticker symbol


Remarks:

• It's possible that the market data returned is 15-20 minutes delayed. If real time quotes are enabled, it's also possible that the quote server doesn't have real time data for this ticker symbol. If the stock is thinly traded, real time data might not be available.
• If you see zero, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the symbols you use, otherwise ESQuotes won't get any data for the symbol.
• Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQVolume(A1)Get current price change from previous close for ticker symbol.

Syntax: ESQChange( Symbol )

Symbol is a valid ticker symbol


Remarks:

• It's possible that the market data returned is 15-20 minutes delayed. If real time quotes are enabled, it's also possible that the quote server doesn't have real time data for this ticker symbol. If the stock is thinly traded, real time data might not be available.
• If you see zero, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the symbols you use, otherwise ESQuotes won't get any data for the symbol.
• Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQChange(A1)Get date of last trade for ticker symbol.

Syntax: ESQDate( Symbol )

Symbol is a valid ticker symbol


Remarks:

• It's possible that the market data returned is 15-20 minutes delayed. If real time quotes are enabled, it's also possible that the quote server doesn't have real time data for this ticker symbol. If the stock is thinly traded, real time data might not be available.
• If you see zero, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the symbols you use, otherwise ESQuotes won't get any data for the symbol.
• Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQDate(A1)Get time of last trade for ticker symbol.

Syntax: ESQTime( Symbol )

Symbol is a valid ticker symbol


Remarks:

• A time with a value higher than the current time may indicate that this ticker symbol hasn't had any trades in this session so far.
• Time value is the reported time at the exchange, not necessarily your time zone.
• A date value instead of a time may mean that the stock's last trade was on that date and not today.
• It's possible that the market data returned is 15-20 minutes delayed. If real time quotes are enabled, it's also possible that the quote server doesn't have real time data for this ticker symbol. If the stock is thinly traded, real time data might not be available.
• If you see blank, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the ticker symbols you use, otherwise ESQuotes won't get any data for the symbol.
• Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQTime(A1)Get 52 week high for ticker symbol.

Syntax: ESQ52WkHigh( Symbol )

Symbol is a valid ticker symbol


Remarks:

• It's possible that the market data returned is 15-20 minutes delayed. If real time quotes are enabled, it's also possible that the quote server doesn't have real time data for this ticker symbol. If the stock is thinly traded, real time data might not be available.
• If you see zero, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the symbols you use, otherwise ESQuotes won't get any data for the symbol.
• Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQ52WkHigh(A1)Get 52 week low for ticker symbol.

Syntax: ESQ52WkLow( Symbol )

Symbol is a valid ticker symbol


Remarks:

• It's possible that the market data returned is 15-20 minutes delayed. If real time quotes are enabled, it's also possible that the quote server doesn't have real time data for this ticker symbol. If the stock is thinly traded, real time data might not be available.
• If you see zero, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the symbols you use, otherwise ESQuotes won't get any data for the symbol.
• Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQ52WkLow(A1)Get currency code for ticker symbol.

Syntax: ESQCurrency( Symbol )

Symbol is a valid ticker symbol


Remarks:

• If you see blank, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the ticker symbols you use, otherwise ESQuotes won't get any data for the symbol.

Example: A1=CSCO
=ESQCurrency(A1)Get current ask price.

Syntax: ESQAsk( Symbol )

Symbol is a valid ticker symbol


Remarks:

• It's possible that the market data returned is 15-20 minutes delayed. If real time quotes are enabled, it's also possible that the quote server doesn't have real time data for this ticker symbol. If the stock is thinly traded, real time data might not be available.
• If you see zero, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the symbols you use, otherwise ESQuotes won't get any data for the symbol.
• Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQAsk(A1)Get average daily volume.

Syntax: ESQAvgVol( Symbol )

Symbol is a valid ticker symbol


Remarks:

• It's possible that the market data returned is 15-20 minutes delayed. If real time quotes are enabled, it's also possible that the quote server doesn't have real time data for this ticker symbol. If the stock is thinly traded, real time data might not be available.
• If you see zero, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the symbols you use, otherwise ESQuotes won't get any data for the symbol.

Example: A1=CSCO
=ESQAvgVol(A1)Get current bid price.

Syntax: ESQBid( Symbol )

Symbol is a valid ticker symbol


Remarks:

• It's possible that the market data returned is 15-20 minutes delayed. If real time quotes are enabled, it's also possible that the quote server doesn't have real time data for this ticker symbol. If the stock is thinly traded, real time data might not be available.
• If you see zero, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the symbols you use, otherwise ESQuotes won't get any data for the symbol.
• Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQBid(A1)Get dividend per share for ticker symbol.

Syntax: ESQDivShare( Symbol )

Symbol is a valid ticker symbol


Remarks:

• It's possible that the market data returned is 15-20 minutes delayed. If real time quotes are enabled, it's also possible that the quote server doesn't have real time data for this ticker symbol. If the stock is thinly traded, real time data might not be available.
• If you see zero, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the symbols you use, otherwise ESQuotes won't get any data for the symbol.
• Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQDivShare(A1)Get dividend pay date for ticker symbol.

Syntax: ESQDivPayDt( Symbol )

Symbol is a valid ticker symbol


Remarks:

• It's possible that the market data returned is 15-20 minutes delayed. If real time quotes are enabled, it's also possible that the quote server doesn't have real time data for this ticker symbol. If the stock is thinly traded, real time data might not be available.
• If you see zero, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the symbols you use, otherwise ESQuotes won't get any data for the symbol.
• Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQDivPayDt(A1)Get dividend yield for ticker symbol.

Syntax: ESQDivYield( Symbol )

Symbol is a valid ticker symbol


Remarks:

• It's possible that the market data returned is 15-20 minutes delayed. If real time quotes are enabled, it's also possible that the quote server doesn't have real time data for this ticker symbol. If the stock is thinly traded, real time data might not be available.
• If you see zero, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the symbols you use, otherwise ESQuotes won't get any data for the symbol.
• Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQDivYield(A1)Get (EPS) Earnings per Share for ticker symbol.

Syntax: ESQEPS( Symbol )

Symbol is a valid ticker symbol


Remarks:

• It's possible that the market data returned is 15-20 minutes delayed. If real time quotes are enabled, it's also possible that the quote server doesn't have real time data for this ticker symbol. If the stock is thinly traded, real time data might not be available.
• If you see zero, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the symbols you use, otherwise ESQuotes won't get any data for the symbol.
• Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQEPS(A1)Get date of Ex-dividend for ticker symbol.

Syntax: ESQExDiv( Symbol )

Symbol is a valid ticker symbol


Remarks:

• It's possible that the market data returned is 15-20 minutes delayed. If real time quotes are enabled, it's also possible that the quote server doesn't have real time data for this ticker symbol. If the stock is thinly traded, real time data might not be available.
• If you see zero, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the symbols you use, otherwise ESQuotes won't get any data for the symbol.
• Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQExDiv(A1)Get current market cap for ticker symbol.

Syntax: ESQMktCap( Symbol )

Symbol is a valid ticker symbol


Remarks:

• It's possible that the market data returned is 15-20 minutes delayed. If real time quotes are enabled, it's also possible that the quote server doesn't have real time data for this ticker symbol. If the stock is thinly traded, real time data might not be available.
• If you see zero, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the symbols you use, otherwise ESQuotes won't get any data for the symbol.
• Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQMktCap(A1)Get the long name of the ticker symbol.

Syntax: ESQName( Symbol )

Symbol is a valid ticker symbol


Remarks:

• If you see blank, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the ticker symbols you use, otherwise ESQuotes won't get any data for the symbol.

Example: A1=CSCO
=ESQName(A1)Get (PE) price to earnings ratio of ticker symbol.

Syntax: ESQPE( Symbol )

Symbol is a valid ticker symbol


Remarks:

• It's possible that the market data returned is 15-20 minutes delayed. If real time quotes are enabled, it's also possible that the quote server doesn't have real time data for this ticker symbol. If the stock is thinly traded, real time data might not be available.
• If you see zero, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the symbols you use, otherwise ESQuotes won't get any data for the symbol.
• Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQPE(A1)Get closing price for trading day prior to last reported trade.

Syntax: ESQPrevClose( Symbol )

Symbol is a valid ticker symbol


Remarks:

• It's possible that the market data returned is 15-20 minutes delayed. If real time quotes are enabled, it's also possible that the quote server doesn't have real time data for this ticker symbol. If the stock is thinly traded, real time data might not be available.
• If you see zero, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the symbols you use, otherwise ESQuotes won't get any data for the symbol.
• Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQPrevClose(A1)Get option open interest for ticker symbol.

Syntax: ESQOpenInt( Symbol )

Symbol is a valid ticker symbol


Remarks:

• It's possible that the market data returned is 15-20 minutes delayed. If real time quotes are enabled, it's also possible that the quote server doesn't have real time data for this ticker symbol. If the stock is thinly traded, real time data might not be available.
• If you see zero, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the symbols you use, otherwise ESQuotes won't get any data for the symbol.
• Non US exchanges report prices in the currency local to the exchange.

Example: A1=CYQIZ.X
=ESQOpenInt(A1)Get option strike price for ticker symbol.

Syntax: ESQStrike( Symbol )

Symbol is a valid ticker symbol


Remarks:

• It's possible that the market data returned is 15-20 minutes delayed. If real time quotes are enabled, it's also possible that the quote server doesn't have real time data for this ticker symbol. If the stock is thinly traded, real time data might not be available.
• If you see zero, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the symbols you use, otherwise ESQuotes won't get any data for the symbol.
• Non US exchanges report prices in the currency local to the exchange.

Example: A1=CYQIZ.X
=ESQStrike(A1)Get today's trading volume as a % of avg trading volume.

Syntax: ESQVolPct( Symbol )

Symbol is a valid ticker symbol


Remarks:

• Useful to detect either high or low trading activity.
• It's possible that the market data returned is 15-20 minutes delayed. If real time quotes are enabled, it's also possible that the quote server doesn't have real time data for this ticker symbol. If the stock is thinly traded, real time data might not be available.
• If you see zero, the quote server may be down or your Internet connection may have a problem. Go to ESQMgr.exe and click the "Data" tab. Make sure this function is activated. Try forcing a recalculation with F9 or Ctrl+Alt+F9. Check that =ESQSymbols() includes the range of cells for all the symbols you use, otherwise ESQuotes won't get any data for the symbol.

Example: A1=CSCO
=ESQVolPct(A1)Get last 30 days of historical data.

Syntax: ESQHistory( Symbol,Day,Item )

Symbol is a valid ticker symbol
Day
Item


Remarks:

• Day values (1-30)
• As the day is advanced it looks back to previous trading days.
• Item can be: "Date", "Open", "High", "Low", "Close", "Volume", "AdjCls"
• If you only get 5 days of history, then your ESQuotes may be unregistered.
• If your history is a day behind or more, due to caching you will have to close Excel and restart in order to load fresh data.

Example: A1=CSCO
A2=ESQHistory(A1,1,"Close") gets the closing price for previous trading day.Display a graph with a mark between a high value and low value.

Syntax: ESQGraph( Low,High,Current )

Low is the lowest value in the range.
High is the highest value in the range.
Current is the current value in the high/low range.


Remarks:

• Show price channel of today's trading range using ESQHigh(), ESQLow() and ESQPrice()
• Useful to graphically see where the stock is trading.
• It's best to format your cell using a fixed font like "terminal"

Example: A1=CSCO
=ESQGraph(ESQLow(A1),ESQHigh(A1),ESQPrice(A1))Get version of Visual Basic module in workbook.

Syntax: ESQVersion( )




Remarks:

• Useful to see version of VB module.

Example: =ESQVersion()Get version of DLL.

Syntax: ESQDLLVersion( )




Remarks:

• Useful to see what version is in use.

Example: =ESQDLLVersion()Get registration status.

Syntax: ESQRegistration( )




Remarks:

• Useful to know if product thinks you are registered or not.

Example: =ESQRegistration()Get any information from DLL to diagnose a potential problem.

Syntax: ESQInfo( )




Remarks:

• Useful if you are not getting valid information.
• Returns text about any problems.

Example: =ESQInfo()Pop up a modal dialog box on a condition.

Syntax: ESQAlert( Exp,Title )

Exp is an expression that results in True or False.
Title is the text that will appear in the cell.


Remarks:

• Excel will stop responding until your click on "OK" button.

Example: =ESQAlert(ESQPrice("CSCO")>100,"Wow!")Play an audible alert on a condition.

Syntax: ESQAlertPlay( Exp,Title,File )

Exp is an expression that results in True or False.
Title is the text that will appear in the cell.
File is a file name.


Remarks:

• The file name contains the name of the .wav file to play when expression is true.

Example: =AlertPlay(ESQPrice("CSCO")>100,"Wow!","Tada.wav")