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

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.