ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Specific Formula Syntax Reference
2
3
=GURUF(<ticker>, <calculation>, <date>, <qa_term>, <showdate>, <transpose>, <order>)
*Red parameters are required, the rest are optional.
4
5
<ticker>Ticker is the symbol of company to retrieve data the data for (eg. "AAPL", "NAS:AAPL")
6
<calculation>Calculation to retreive. 3 types of calculation ['price': has daily data, 'finaical'：has quarter and annual Data, 'stock': only has current data]
7
<date>Date to retrieve data, default for the latest or daily value. Not available for stock type calculation (eg. "2008", "2008-10"，"2008-10-1")
8
<qa_term>Annual or Quarter data only for financial calculation, default for 'Annual' (eg. "A", "Annual", "Q")
9
<showdate>Date should be diplayed if it is yes, default is no (eg. "Y", "Yes", "N")
10
<transpose>Change the orientation of the display, default is horizontal (eg. "Horizontal", "H", "Vertical", "V")
11
<order>Change the sort type of datas, default is ascending order (eg. "A", "D", "asc", "desc")
12
13
Example:
14
GURUF("AAPL", "Price")Get Latest price for AAPL
15
GURUF("AAPL", "Price", "2006-10-01")Get October 10, 2016 price for AAPL
16
GURUF("AAPL", "Price", "2006-10-01:2006-10-31")Get October, 2016 price for AAPL
17
GURUF("AAPL", "Price", "-10","","Y" ,"V", "D")Get Last 10 days price for AAPL, displayed with date, transpose to vertical, in descending order
18
GURUF("AAPL", "Revenue", "2006-10:")Get annual revenue after October 10, 2016 for AAPL
19
GURUF("AAPL", "Revenue", ":2006-10")Get annual revenue before October 10, 2016 for AAPL
20
GURUF("AAPL", "Revenue", "-4", "Q")Get quarterly revenue for AAPL for last 4 calandar quarters
21
GURUF("AAPL", "Company")Get company name for AAPL
22
23
Specific Parameters Reference:
24
<ticker> "AAPL" or "aapl"Apple company sybol
25
<ticker> "AAPL:NAS" or "NAS:AAPL"Apple company sybol in NAS exchange
26
<calculation> "REVENUE" or "revenue"Revenue for selected ticker, financial type calculation has annual or quarterly data
27
<calculation> "PRICE" or "price"Price for selected ticker, price type calculation has daily data
28
<calculation> "COMPANY" or "company"Company name for selected ticker, stock type calculation only has current data
29
<date> "-4"Latest 4 values
30
<date> "2007"Data for the year 2007
31
<date> "2007-1-1" or "2007-01-01" or "01/01/2007"Data for the day on Jan. 1, 2007. Only for price type calculation
32
<date> "2007-10:2012-8" or "2007-10:2012-08"Data for the period from October 2007 to August 2012
33
<date> "2007:"Data from 2007 to Current
34
<date> ":2007"Data from the first available date to 2007
35
<date> "2007Q1"Data from the first available quarter of year 2007
36
<qa_term> "A" or "Annual"Default Annual data. Only availble for financial
37
<qa_term> "Q" or "Quarter"Quarterly data. Only availble for financial
38
<qa_term> "FQ" or "Fiscal_Quarter"Fiscal Quarterly data. Only availble for financial
39
<showdate> "Y" or "N"Default is N
40
<transpose> "H" or "V"Change the display orientation. Default is Horizontal
41
<transpose> "A" or "D"Change the order. Default is ascending
42
43
Note: if an item has both current value and historical value, it will only be shown in Guru Function Historical Fields tab
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100