Marketview - User Manual
Marketview - User Manual
In this guide you will find all the useful information to get up and running quickly with Marketview.
Open the sidebar by going to EXTENSIONS > MARKETVIEW > FORMULA BUILDER and follow these s
1) In “Insert in Cell” input the cell reference (e.g. “B2”) of where you want to insert the data
2) In “Ticker Symbol Cell” input the cell reference of where the corresponding ticker* is
located (e.g. “A2”)
3) Select then the Data Type you want to pull and the specific Data Attribute from the dropdown
menus (e.g. “Real Time Data” and “Price”)
4) Once done, click on Create and in a few seconds you’ll see the data generated in the cell
selected in step 1.
*NB: To avoid "Null" results, please use the ticker symbol as reported in our Ticker Database (see
3rd tab). Instrument codes and capital letters included.
Sample formulas
Real Time Data =MARKETVIEW(A2,"price")
=MARKETVIEW(ticker, [attribute])
ticker The ticker symbol for the security to consider.*
- attribute is one of the following for Real Time Data (auto-update every 60 minutes):
price
priceopen
closeyest
change
changepct
high
low
high52
low52
volume
marketcap
beta
pe
eps
dividend
yield
targetestimate
indicator daily
indicator weekly
indicator monthly
sentiment bearish
sentiment bullish
industry
logo
- attribute is one of the following for Historical Data:
change1w
change1m
changeytd
change1y
change3y
Notes
- Ticker symbols: For accurate results and to avoid discrepancies, it’s mandatory to use the ticker symbol
- Data auto-update: All Marketview functions will automatically refresh every 60 mins after the very first op
- Syntax & attributes: All parameters must be enclosed in quotation marks or be references to cells conta
- Some attributes may not yield results for all symbols. Please check our Compatibility Matrix (see 2nd ta
- Localization of syntax: For countries using decimal comma separators (e.g. €2,50), which is most of the
should be swapped with semicolons. To avoid invalid syntax due to your Google Sheets locale, please cr
settings.
- Quotes are not sourced from all markets and may be delayed between 60 and 90 minutes depending on
- Usage restrictions: The data is not for financial industry professional use or use by other professionals a
licensing fees from a third-party data provider.
NSIONS > MARKETVIEW > FORMULA BUILDER and follow these step
W(A2,"price")
W(A7, "change1w")
ol for the security to consider.*
The percentage change in price since the previous trading day's close.
The industry.
The percentage change in price since January 1st of the current year.
s and to avoid discrepancies, it’s mandatory to use the ticker symbol as reported in our Ticker Database (see 3rd tab). Instrum
unctions will automatically refresh every 60 mins after the very first opening of the Formula Builder, which activates the time trig
must be enclosed in quotation marks or be references to cells containing text (e.g. cell reference of where the ticker is located)
lts for all symbols. Please check our Compatibility Matrix (see 2nd tab) for a complete overview of the data supported for each i
s using decimal comma separators (e.g. €2,50), which is most of the EU countries and a select few others, the syntax for formu
To avoid invalid syntax due to your Google Sheets locale, please create the formulas using the Formula Builder to automatica
arkets and may be delayed between 60 and 90 minutes depending on the exchange. Information is provided 'as is' and solely fo
for financial industry professional use or use by other professionals at non-financial firms (including government entities). Profe
provider.
iew.
#NAME?
*NB: It’s mandatory to use the ticker symbol as reported in our Ticker Database (see 3rd tab).
Instrument codes and capital letters included.
's close.
re in Millions).
.
h.
rs.
r symbol as reported in our Ticker Database (see 3rd tab). Instrument codes and capital letters included.
ry first opening of the Formula Builder, which activates the time trigger.
lls containing text (e.g. cell reference of where the ticker is located).
e 2nd tab) for a complete overview of the data supported for each instrument.
ost of the EU countries and a select few others, the syntax for formulas is slightly different and commas
please create the formulas using the Formula Builder to automatically use the correct syntax based on your
ending on the exchange. Information is provided 'as is' and solely for informational purposes, not for trading pu
sionals at non-financial firms (including government entities). Professional use may be subject to additional
Compatibility matrix
See below the data supported for every instrument (green cell=supported; red cell=not supported yet).
US stocks ✓ ✓ ✓
US ETFs ✓ ✓ ✓
Crypto ✓ ✓ ✓
supported yet).
✓ ✓ ✓ ✓ ✓ ✓
✓ ✓ ✓ ✓ ✗ ✗
✓ ✓ ✓ ✓ ✗ ✗
Volume Marketcap (M) Beta PE EPS
#NAME?
✓ ✓ ✓ ✓ ✓
✓ ✗ ✗ ✗ ✗
✓ ✗ ✗ ✗ ✗
Dividend Yield Target estimate Indicator Daily Indicator Weekly
✓ ✓ ✓ ✓ ✓
✗ ✗ ✗ ✓ ✓
✗ ✗ ✗ ✗ ✗
Indicator Monthly Sentiment Bearish Sentiment Bullish Industry Logo
✓ ✓ ✓ ✓ ✓
✓ ✗ ✗ ✗ ✗
✗ ✗ ✗ ✗ ✗
#NAME?
Historical Data
Historical Data
✓ ✓ ✓ ✓ ✓
✓ ✓ ✓ ✓ ✓
✓ ✓ ✓ ✓ ✓
or by ticker
t
ay.
Cryptocurrencies
Name Ticker symbol
1inch 1INCH-USD
Aave AAVE-USD
ABBC Coin ABBC-USD
Alchemy Pay ACH-USD
Achain ACT-USD
Cardano ADA-USD
Aidos Kuneen ADK-USD
Ambire AdEx ADX-USD
Aeternity AE-USD
Aeon AEON-USD
Advanced Internet Blocks AIB-USD
Aion AION-USD
Algorand ALGO-USD
Ambrosus AMB-USD
Amp AMP-USD
Ankr ANKR-USD
Aragon ANT-USD
Apollo Currency APL-USD
Arweave AR-USD
Ardor ARDR-USD
Ark ARK-USD
Pirate Chain ARRR-USD
Cosmos ATOM-USD
Atari Token ATRI-USD
Avalanche AVAX-USD
AXEL AXEL-USD
Axie Infinity AXS-USD
Aryacoin AYA-USD
Band Protocol BAND-USD
Basic Attention Token BAT-USD
Bitcoin Diamond BCD-USD
Bitcoin Cash BCH-USD
Bytecoin BCN-USD
Beldex BDX-USD
Beam BEAM-USD
Bitpanda Ecosystem Token BEST-USD
BitcoinHD BHD-USD
BHPCoin BHP-USD
Minter Network BIP-USD
Blocknet BLOCK-USD
Binance Coin BNB-USD
Bancor BNT-USD
Bonorum BONO-USD
BackPacker Coin BPC-USD
BitcoinPoS BPS-USD
Baer Chain BRC-USD
BlockStamp BST-USD
Bitcoin SV BSV-USD
Bitcoin BTC-USD
Bitcoin2 BTC2-USD
BitcoinDark BTCD-USD
Bitcoin Gold BTG-USD
Bytom BTM-USD
BitShares BTS-USD
BitTorrent BTT-USD
Bitcore BTX-USD
Burst BURST-USD
PancakeSwap CAKE-USD
Counos Coin CCA-USD
Counos X CCXX-USD
Celsius CEL-USD
Celo CELO-USD
Celer Network CELR-USD
CoinEx Token CET-USD
Chiliz CHZ-USD
Nervos Network CKB-USD
Clams CLAM-USD
CyberMiles CMT1-USD
Cryptonex CNX-USD
ColossusXT COLX-USD
Compound Coin COMP-USD
Compound COMP1-USD
COTI COTI-USD
Crypto.com Coin CRO-USD
Crust CRU-USD
Curve DAO Token CRV-USD
CasinoCoin CSC-USD
Creditcoin CTC-USD
Cartesi CTSI-USD
Cortex CTXC-USD
CUTcoin CUT-USD
Civic CVC-USD
Constellation DAG-USD
Dai DAI-USD
Dash DASH-USD
Dentacoin DCN-USD
Decred DCR-USD
Dinastycoin DCY-USD
Dero DERO-USD
DeFiChain DFI-USD
DigiByte DGB-USD
DigixDAO DGD-USD
Divi DIVI-USD
DARMA Cash DMCH-USD
Diamond DMD-USD
Metaverse Dualchain Network Architecture DNA1-USD
district0x DNT-USD
Dogecoin DOGE-USD
Polkadot DOT-USD
DECOIN DTEP-USD
Dynamic DYN-USD
ECC ECC-USD
Elrond EGLD-USD
Elastos ELA-USD
Dogelon Mars ELON-USD
Einsteinium EMC2-USD
Enjin Coin ENJ-USD
EOS EOS-USD
Ergo ERG-USD
Ethereum Classic ETC-USD
Ethereum ETH-USD
Electroneum ETN-USD
Metaverse ETP ETP-USD
Energy Web Token EWT-USD
Factom FCT-USD
Fetch.ai FET-USD
Filecoin FIL-USD
FIO Protocol FIO-USD
Firo FIRO-USD
Flash FLASH-USD
Flow FLOW-USD
FIBOS FO-USD
Fusion FSN-USD
Feathercoin FTC-USD
Fantom FTM-USD
FTX Token FTT-USD
FUNToken FUN-USD
Gala GALA-USD
GameCredits GAME-USD
Gas GAS-USD
Obyte GBYTE-USD
Ghost GHOST-USD
Gleec GLEEC-USD
Golem Migration GLM-USD
Gnosis GNO-USD
Golem GNT-USD
GoChain GO-USD
GridCoin GRC-USD
Grin GRIN-USD
GreenPower GRN-USD
Groestlcoin GRS-USD
The Graph GRT1-USD
GXChain GXC-USD
Hedera HBAR-USD
HyperCash HC-USD
HEX HEX-USD
Hive HIVE-USD
Helleniccoin HNC-USD
Handshake HNS-USD
Helium HNT-USD
Holo HOT1-USD
High Performance Blockchain HPB-USD
Orient Walt HTDF-USD
HYCON HYC-USD
Iconomi ICN-USD
Internet Computer ICP-USD
ICON ICX-USD
Idena IDNA-USD
ILCoin ILC-USD
Insights Network INSTAR-USD
IOST IOST-USD
IoTeX IOTX-USD
IRISnet IRIS-USD
JDCoin JDC-USD
Joule JUL-USD
Kava KAVA-USD
Kadena KDA-USD
Kin KIN-USD
Klaytn KLAY-USD
Komodo KMD-USD
Kyber Network KNC-USD
TerraKRW KRT-USD
Kusama KSM-USD
LBRYCredits LBC-USD
Litecoin Cash LCC-USD
UNUS SED LEO LEO-USD
Chainlink LINK-USD
Lykke LKK-USD
Loki LOKI-USD
Loopring LRC-USD
Largo Coin LRG-USD
Lisk LSK-USD
Litecoin LTC-USD
Terra LUNA1-USD
Lynx LYNX-USD
MaidSafeCoin MAID-USD
Matrix AI Network MAN-USD
Decentraland MANA-USD
Maro MARO-USD
Massnet MASS-USD
Polygon (Matic Network) MATIC-USD
MCO MCO-USD
MediBlocQRC20 MED-USD
Metadium META-USD
MetaHash MHC-USD
IOTA MIOTA-USD
MIRCOIN MIR-USD
Mirror Protocol MIR1-USD
Maker MKR-USD
Melon MLN-USD
MOAC MOAC-USD
MonaCoin MONA-USD
Metrix Coin MRX-USD
Metacoin MTC1-USD
Metal MTL-USD
MultiVAC MTV-USD
MimbleWimbleCoin MWC-USD
Nano NANO-USD
Nebulas NAS-USD
NavCoin NAV-USD
NEAR Protocol NEAR-USD
Neblio NEBL-USD
Neo NEO-USD
Nexo NEXO-USD
Nimiq NIM-USD
NIX NIX-USD
NKN NKN-USD
Gulden NLG-USD
Namecoin NMC-USD
Numeraire NMR-USD
Energi NRG-USD
NuCypher NU-USD
NULS NULS-USD
NerveNetwork NVT-USD
Nexus NXS-USD
Nxt NXT-USD
NewYork Exchange NYE-USD
Observer OBSR-USD
Ocean Protocol OCEAN-USD
Omise GO OMG-USD
ECOMI OMI-USD
Harmony ONE1-USD
Ontology ONT-USD
OTOCASH OTO-USD
Orchid OXT-USD
PAC Global PAC-USD
Project Pai PAI-USD
Particl PART-USD
TenX PAY-USD
ChainX PCX-USD
Phala Network PHA-USD
PCHAIN PI-USD
PIVX PIVX-USD
PLATINCOIN PLC-USD
Pmeer PMEER-USD
POA Network POA-USD
Polis POLIS-USD
Peercoin PPC-USD
Populous PPT-USD
PRIZM PZM-USD
QASH QASH-USD
Quant QNT-USD
Quantum Resistant Ledger QRL-USD
Qtum QTUM-USD
Radium RADS-USD
Raydium RAY-USD
RSK Smart Bitcoin RBTC-USD
Rubycoin RBY-USD
ReddCoin RDD-USD
Ren REN-USD
Augur REP-USD
RChain REV-USD
Revain REV1-USD
RING X PLATFORM RINGX-USD
iExec RLC RLC-USD
Oasis Network ROSE-USD
THORChain RUNE-USD
Ravencoin RVN-USD
SafeMoon SAFEMOON-USD
SALT SALT-USD
The Sandbox SAND-USD
Sapphire SAPP-USD
Steem Dollars SBD-USD
Siacoin SC-USD
SCC DIGforIT SCC3-USD
ScPrime SCP-USD
SuperZero SERO-USD
SafexToken SFT-USD
SHIBA INU SHIB-USD
Shift SHIFT-USD
SKALE Network SKL-USD
Skycoin SKY-USD
SaluS SLS-USD
SmartCash SMART-USD
SingularDTV SNGLS-USD
SONM SNM-USD
Status SNT-USD
Synthetix SNX-USD
Solana SOL-USD
SonoCoin SONO1-USD
Serum SRM-USD
Steem STEEM-USD
Storj STORJ-USD
Stratis STRAX-USD
Stox STX1-USD
Sushi SUSHI-USD
Syscoin SYS-USD
TaaS TAAS-USD
TERA TERA-USD
Theta Fuel TFUEL-USD
THETA THETA-USD
TomoChain TOMO-USD
TrueChain TRUE-USD
TRON TRX-USD
Thunder Token TT-USD
TrueUSD TUSD-USD
Trust Wallet Token TWT-USD
Ubiq UBQ-USD
UMA UMA-USD
Uniswap UNI1-USD
Unobtanium UNO-USD
USD Coin USDC-USD
Tether USDT-USD
NuBits USNBT-USD
Validity VAL-USD
VeriBlock VBK-USD
Veritaseum VERI-USD
VeChain VET-USD
Voyager Token VGX-USD
Viacoin VIA-USD
Vitae VITAE-USD
VITE VITE-USD
Velas VLX-USD
Verasity VRA-USD
VSystems VSYS-USD
Vertcoin VTC-USD
VeThor Token VTHO-USD
Wanchain WAN-USD
Waves WAVES-USD
WAX WAXP-USD
Wrapped Bitcoin WBTC-USD
Wagerr WGR-USD
WaykiChain WICC-USD
EFFORCE WOZX-USD
Waltonchain WTC-USD
Chia Network XCH-USD
Counterparty XCP-USD
XDC Network XDC-USD
DigitalNote XDN-USD
eCash XEC-USD
NEM XEM-USD
Haven Protocol XHV-USD
Stellar XLM-USD
Nexalt XLT-USD
Monero Classic XMC-USD
Monero XMR-USD
Myriad XMY-USD
XeniosCoin XNC-USD
xRhodium XRC-USD
XRP XRP-USD
Stakenet XSN-USD
Tezos XTZ-USD
Verge XVG-USD
WhiteCoin XWC-USD
Zcoin XZC-USD
YEPCOIN YEP-USD
Yearn.finance YFI-USD
YOYOW YOYOW-USD
Zano ZANO-USD
Zcash ZEC-USD
Horizen ZEN-USD
Zilliqa ZIL-USD
Zenon ZNN-USD
0x ZRX-USD
Zynecoin ZYN-USD
Copyright © 2022 Marketview Ltd, All Rights Reserved.