STOCK function - Zoho Sheet - Help Guide

STOCK

Returns the stock details for the stock symbol provided.

 

Syntax

 

STOCK(symbol; [function])

symbol: The stock symbol of the company. E.g. "AAPL"
function: The type of data to return. Defaults to the price value when omitted. E.g. "volume"

 

Supported Functions

price             - price of stock
tradetime     - last traded time of stock in PS
open             - price when the current day opened
high              - highest traded price for the current day
low               - lowest traded price for the current day
volume         - volume of shares traded for the day
close            - price at previous day close
change         - percentage change from previous day close
52weekhigh - highest price in last 52 weeks
52weeklow  - lowest price in last 52 weeks

 


Notes

Remarks


  1. All the symbols except that of the US exchange should be prefixed with the corresponding exchange. Eg: =STOCK("NSE:RELIANCE").
  2. The data provided is for informational purpose only, and may be delayed by up to 60 minutes. Data provided by Twelve Data.



Country



Exchanges




Argentina
BCBA







Austria
VSE







Brazil
Bovespa







Canada
TSXV
TSX
NEO
CSE




Chile
BVS







China
SZSE
SSE






Colombia
BVC







Denmark
OMXC
DSME






Egypt
EGX







Estonia
OMXT







Finland
OMXH







France
Euronext







Germany
XDUS
FSX
Munich
XBER
XSTU
XHAN
XETR
XHAM
Greece
ASE







Hong Kong
HKEX







Iceland
ICEX







India
BSE
NSE






Indonesia
IDX







Ireland
ISE







Israel
TASE







Italy
MTA







Jamaica
JSE







Japan
JPX
XSAP






Kuwait
XKUW







Latvia
OMXR







Lithuania
OMXV







Malaysia
MYX







Mexico
BMV







New Zealand
NZX







Norway
OSE







Pakistan
PSX







Peru
BVL







Philippines
PSE







Poland
GPW







Qatar
QE







Romania
BVB







Russia
MOEX







Saudi Arabia
Tadawul







Singapore
SGX







South Korea
KRX
KOSDAQ
KONEX





Spain
BME







Sweden
OMX
SSME






Switzerland
SIX







Taiwan
TWSE







Thailand
SET







Turkey
BIST







United Arab Emirates
ADX
DFM






United Kingdom
LSE







United States
NYSE
OTC
NASDAQ
CBOE




Venezuela
BVCC










Examples

 

Formula

Result

=STOCK("GOOG";"PRICE")

149.54

=STOCK("NSE:RELIANCE";"PRICE")

2924.25

=STOCK("AAPL";"volume")

67069600

The example data is from 2024





Get a hands-on experience of the function in the embedded range below.
 


Possible Errors

 

Errors

Meaning

Invalid symbol

  • The given stock symbol is not valid.

Invalid Function

  • The given function is not in the supported list or is invalid.

#NAME!

  • The function name is incorrect or invalid.

  • The given defined name (if any) is invalid.

  • There is a typo in the defined name used in the function.

  • Double quotes are missing for text values in the function.

  • Colon missing in a cell range reference.

#REF!

  • The given cell reference is incorrect or invalid. This error may occur when a cell/range has been deleted, moved, or pasted over.