ESQSymbols

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")

ESQPrice

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
Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQPrice(A1)

ESQHigh

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
Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQHigh(A1)

ESQLow

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
Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQLow(A1)

ESQVolume

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
Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQVolume(A1)

ESQChange

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
Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQChange(A1)

ESQDate

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
Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQDate(A1)

ESQTime

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
Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQTime(A1)

ESQOpen

Get opening price for the day; first trade of the day

Syntax: ESQOpen( 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
Non US exchanges report prices in the currency local to the exchange.
This is not always close to the previous day's closing price, especially when company news is released after the stock market closed the previous day.

Example: A1=CSCO
=ESQOpen(A1)

ESQ52WkHigh

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
Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQ52WkHigh(A1)

ESQ52WkLow

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
Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQ52WkLow(A1)

ESQCurrency

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

Example: A1=CSCO
=ESQCurrency(A1)

ESQAsk

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
Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQAsk(A1)

ESQAvgVol

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

Example: A1=CSCO
=ESQAvgVol(A1)

ESQBid

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
Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQBid(A1)

ESQDivShare

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
Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQDivShare(A1)

ESQDivPayDt

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
Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQDivPayDt(A1)

ESQDivYield

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
Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQDivYield(A1)

ESQEPS

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
Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQEPS(A1)

ESQExDiv

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
Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQExDiv(A1)

ESQMktCap

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
Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQMktCap(A1)

ESQName

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

Example: A1=CSCO
=ESQName(A1)

ESQPE

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
Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQPE(A1)

ESQPrevClose

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
Non US exchanges report prices in the currency local to the exchange.

Example: A1=CSCO
=ESQPrevClose(A1)

ESQOpenInt

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
Non US exchanges report prices in the currency local to the exchange.

Example: A1=CYQIZ.X
=ESQOpenInt(A1)

ESQStrike

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
Non US exchanges report prices in the currency local to the exchange.

Example: A1=CYQIZ.X
=ESQStrike(A1)

ESQVolPct

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

Example: A1=CSCO
=ESQVolPct(A1)

ESQHistory

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.

ESQByDate

Get historical data for any specified date

Syntax: ESQByDate( Symbol,Date,Item )

Symbol is a valid ticker symbol
Date
Item

Remarks:

Date can be any valid date
Item can be: "Date", "Open", "High", "Low", "Close", "Volume", "AdjCls"
This function fetches data for each symbol and date separately and can take up to 500 ms to execute. So if you use many of these functions, it can seriously cause your workbook to take a long time to calculate.

Example: A1=CSCO
A2=ESQByDate(A1,"09/23/2005","Close") gets the closing price for date.

ESQGraph

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))

ESQLastDOM

Get last trading date of the month.

Syntax: ESQLastDOM( Date )

Date

Remarks:

Useful to when you want a date for the end of the month.
If last day of month is weekend, it goes back to a day that is not a weekend.
It is possible that a non trading day is returned if a holiday happens to be on the last weekday. There is no holiday calendar feature.

Example: =ESQLastDOM(Now())

ESQNewsHead

Get news headline for specified stock symbol.

Syntax: ESQNewsHead( Symbol,Item )

Symbol is a valid ticker symbol
Item

Remarks:

Item 0 is the 1st news headline, 1 is the second headline, etc..

Example: =HYPERLINK(ESQNewsLink("CSCO",0),ESQNewsHead("CSCO",0)&" ("&ESQNewsDate(CSCO,0)&")")

ESQNewsLink

Get news hyperlink (URL) for the specified stock symbol.

Syntax: ESQNewsLink( Symbol,Item )

Symbol is a valid ticker symbol
Item

Remarks:

Item 0 is the 1st news hyperlink, 1 is the second news item, etc..

Example: =HYPERLINK(ESQNewsLink("CSCO",0),ESQNewsHead("CSCO",0)&" ("&ESQNewsDate(CSCO,0)&")")

ESQNewsDate

Get news date and time for specified stock symbol.

Syntax: ESQNewsDate( Symbol,Item )

Symbol is a valid ticker symbol
Item

Remarks:

Item 0 is the 1st news item, 1 is the second item, etc..

Example: =HYPERLINK(ESQNewsLink("CSCO",0),ESQNewsHead("CSCO",0)&" ("&ESQNewsDate(CSCO,0)&")")

ESQVersion

Get version of Visual Basic module in workbook.

Syntax: ESQVersion( )

Remarks:

Useful to see version of VB module.

Example: =ESQVersion()

ESQDLLVersion

Get version of DLL.

Syntax: ESQDLLVersion( )

Remarks:

Useful to see what version is in use.

Example: =ESQDLLVersion()

ESQRegistration

Get registration status.

Syntax: ESQRegistration( )

Remarks:

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

Example: =ESQRegistration()

ESQInfo

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()

ESQAlert

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!")

ESQAlertPlay

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")

ESQEBITDA

Earnings before interest, taxes, depreciation and amortization

Syntax: ESQEBITDA( Symbol )

Symbol is a valid ticker symbol

Remarks:

Example: =ESQEBITDA("CSCO")