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 SegmentMSFTSalesRevenueNet2016FYCommercialCloudMember 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]2025-12-27
12
Last reported fiscal periodAAPL
[Fiscal Period Focus]
Q1
13
Earning per Share (EPS)NKE[EPS Basic]0.54
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 VolumeMSFT2/24/2026v33,884,654
22
52-wk average Share PriceMSFT2/24/2026avg365$450.75
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