ABCDEFGH
1
4
Welcome aboard!
5
In this guide you will find all the useful information to get up and running quickly with Marketview.
6
7
How to get started
8
Open the sidebar by going to ADD-ONS > MARKETVIEW > FORMULA BUILDER and follow these steps:
9

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.
10
11
*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.
12
13
14
Sample formulas
15
Real Time Data =MARKETVIEW(A2,"price")
16
Historical Data
=MARKETVIEW(A7, "change1w")
17
18
Syntax & Attributes
19
=MARKETVIEW(ticker, [attribute])
20
ticker
The ticker symbol for the security to consider.*
*NB: It’s mandatory to use the ticker symbol as reported in our Ticker Database (see 3rd tab). Instrument codes and capital letters included.
21
attribute
The attribute to fetch about ticker.
22
- attribute is one of the following for Real Time Data (auto-update every 60 minutes):
23
priceReal-time price quote.
24
priceopenThe price as of market open.
25
closeyestThe previous day's closing price.
26
changeThe price change since the previous trading day's close.
27
changepctThe percentage change in price since the previous trading day's close.
28
highThe current day's high price.
29
lowThe current day's low price.
30
high52The 52-week high price.
31
low52The 52-week low price.
32
volumeThe current day's trading volume.
33
marketcapThe market capitalization of the stock (Results are in Millions).
34
betaThe beta value.
35
peThe price/earnings ratio.
36
epsThe earnings per share.
37
dividendThe forward dividend.
38
yieldThe forward dividend yield.
39
targetestimateThe average analysts 12-month price target.
40
indicator dailyThe daily recommended rating.
41
indicator weeklyThe weekly recommended rating.
42
indicator monthlyThe monthly recommended rating.
43
sentiment bearishThe bearish sentiment.
44
sentiment bullishThe bullish sentiment.
45
industryThe industry.
46
logoThe logo image (Most popular US stocks only).
47
48
- attribute is one of the following for Historical Data:
49
change1wThe percentage change in price in the last week.
50
change1mThe percentage change in price in the last month.
51
changeytdThe percentage change in price since January 1st of the current year.
52
change1yThe percentage change in price in the last year.
53
change3yThe percentage change in price in the last 3 years.
54
55
Notes
56
- Ticker symbols: For accurate results and to avoid discrepancies, it’s mandatory to use the ticker symbol as reported in our Ticker Database (see 3rd tab). Instrument codes and capital letters included.
57
- Data auto-update: All Marketview functions will automatically refresh every 60 mins after the very first opening of the Formula Builder, which activates the time trigger.
58
- Syntax & attributes: All parameters must be enclosed in quotation marks or be references to cells containing text (e.g. cell reference of where the ticker is located).
59
- Some attributes may not yield results for all symbols. Please check our Compatibility Matrix (see 2nd tab) for a complete overview of the data supported for each instrument.
60
- Localization of syntax: For countries using decimal comma separators (e.g. €2,50), which is most of the EU countries and a select few others, the syntax for formulas is slightly different and commas should be swapped with semicolons. To avoid invalid syntax due to your Google Sheets locale, please create the formulas using the Formula Builder to automatically use the correct syntax based on your settings.
61
- Quotes are not sourced from all markets and may be delayed between 60 and 90 minutes depending on the exchange. Information is provided 'as is' and solely for informational purposes, not for trading purposes or advice.
62
- Usage restrictions: The data is not for financial industry professional use or use by other professionals at non-financial firms (including government entities). Professional use may be subject to additional licensing fees from a third-party data provider.
63
64
65
We're here to help
66
If you have any questions or need support, check our FAQs or contact us:
67
➤ FAQ
68
➤ Contact UsCopyright © 2021 Marketview Ltd, All Rights Reserved.
69