iXBRLAnalyst Primer
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Examples built with iXBRLAnalyst by FinDynamics, Inc.©
2
3
This Primer explains how to use iXBRLAnalyst with Google Sheets to get any fundamental or stock market data.
Use one of the following built-in functions: XBRLFact, FinValue, SharePrice. If you need more functionality, download XBRLAnalyst for Excel (desktop Add-In version).
4
5
Input parametersOutput Result
6
Desired Fundamental Financial ValueCompany ID
(ticker or CIK)
Financial Metric or XBRL tagFiscal YearFiscal PeriodDimension MemberScaleFormula
7
Company Revenue in billion $WMT[Revenue]2015FY 1,000,000,000 486
8
Revenue of Business Segment
MSFTSalesRevenueNet2016FY
CommercialCloudMember
1,000,000 9,500
9
Assets for given quarter in thousands
NKE[Assets]2016Q2 1,000 22,583,000
10
Company Name for CIK code50863
[Company Name]
INTEL CORP
11
End of last reported periodAAPL[End of Period]2016-03-26
12
Last reported fiscal periodAAPL
[Fiscal Period Focus]
Q2
13
Earning per Share (EPS)NKE[EPS Basic]0.56
14
15
16
17
18
Desired Stock Market ValueCompany ID
(ticker or CIK)
DateReturned value (e.g. 'c'-closing)Statistics Period (days)Output Result
19
Closing Share PriceMSFT8/7/2014c$43.23
20
High Price for given dateMSFT8/8/2014h$43.31
21
Last Day's Trading VolumeMSFT12/6/2018v#NAME?
22
52-wk average Share PriceMSFT12/6/2018avg365#NAME?
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
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
Loading...
Main menu