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")ESQ
Syntax: ESQ( symbol )
symbol
Remarks:Example: =ESQ("CSCO")ESQ
Syntax: ESQ( symbol )
symbol
Remarks:Example: =ESQ("CSCO")ESQ
Syntax: ESQ( symbol )
symbol
Remarks:Example: =ESQ("CSCO")ESQ
Syntax: ESQ( symbol )
symbol
Remarks:Example: =ESQ("CSCO")ESQ
Syntax: ESQ( symbol )
symbol
Remarks:Example: =ESQ("CSCO")ESQ
Syntax: ESQ( symbol )
symbol
Remarks:Example: =ESQ("CSCO")ESQ
Syntax: ESQ( symbol )
symbol
Remarks:Example: =ESQ("CSCO")