ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
SymbolCompanyReference Price
52-Week Range Column Chart With Reference Price
Normal 52 Week RangeFormula on C columnFormula on D columnFormula on E column
2
EPA:ORAOrange SA10.42=FIFO_UNIT_COST(QUERY(Transactions!A:E,"select D where C='"&A2&"' and B!='DIVIDEND' order by A asc",0),
QUERY(Transactions!A:E,"select E where C='"&A2&"' and B!='DIVIDEND' order by A asc",0))		=SPARKLINE(ARRAYFORMULA(SLICE(INDEX(GOOGLEFINANCE(A2,"price",EDATE(TODAY(),-12),TODAY()),0,2),1)-C2),{"charttype","column";"negcolor","red";"color","green"})=SPARKLINE(INDEX(GOOGLEFINANCE(A2,"price",EDATE(TODAY(),-12),TODAY())))
3
EPA:CW8Amundi MSCI World Swap UCITS ETF EUR Acc393.74=FIFO_UNIT_COST(QUERY(Transactions!A:E,"select D where C='"&A3&"' and B!='DIVIDEND' order by A asc",0),
QUERY(Transactions!A:E,"select E where C='"&A3&"' and B!='DIVIDEND' order by A asc",0))		=SPARKLINE(ARRAYFORMULA(SLICE(INDEX(GOOGLEFINANCE(A3,"price",EDATE(TODAY(),-12),TODAY()),0,2),1)-C3),{"charttype","column";"negcolor","red";"color","green"})=SPARKLINE(INDEX(GOOGLEFINANCE(A3,"price",EDATE(TODAY(),-12),TODAY())))
4
AAPLApple Inc150.00=SPARKLINE(ARRAYFORMULA(SLICE(INDEX(GOOGLEFINANCE(A4,"price",EDATE(TODAY(),-12),TODAY()),0,2),1)-C4),{"charttype","column";"negcolor","red";"color","green"})=SPARKLINE(INDEX(GOOGLEFINANCE(A4,"price",EDATE(TODAY(),-12),TODAY())))
5
MSFTMicrosoft Corp250.00=SPARKLINE(ARRAYFORMULA(SLICE(INDEX(GOOGLEFINANCE(A5,"price",EDATE(TODAY(),-12),TODAY()),0,2),1)-C5),{"charttype","column";"negcolor","red";"color","green"})=SPARKLINE(INDEX(GOOGLEFINANCE(A5,"price",EDATE(TODAY(),-12),TODAY())))
6
AMZNAmazon.com Inc125.00=SPARKLINE(ARRAYFORMULA(SLICE(INDEX(GOOGLEFINANCE(A6,"price",EDATE(TODAY(),-12),TODAY()),0,2),1)-C6),{"charttype","column";"negcolor","red";"color","green"})=SPARKLINE(INDEX(GOOGLEFINANCE(A6,"price",EDATE(TODAY(),-12),TODAY())))
7
TSLATesla Inc275.00=SPARKLINE(ARRAYFORMULA(SLICE(INDEX(GOOGLEFINANCE(A7,"price",EDATE(TODAY(),-12),TODAY()),0,2),1)-C7),{"charttype","column";"negcolor","red";"color","green"})=SPARKLINE(INDEX(GOOGLEFINANCE(A7,"price",EDATE(TODAY(),-12),TODAY())))
8
GOOGLAlphabet Inc Class A110.00=SPARKLINE(ARRAYFORMULA(SLICE(INDEX(GOOGLEFINANCE(A8,"price",EDATE(TODAY(),-12),TODAY()),0,2),1)-C8),{"charttype","column";"negcolor","red";"color","green"})=SPARKLINE(INDEX(GOOGLEFINANCE(A8,"price",EDATE(TODAY(),-12),TODAY())))
9
NVDANVIDIA Corp150.00=SPARKLINE(ARRAYFORMULA(SLICE(INDEX(GOOGLEFINANCE(A9,"price",EDATE(TODAY(),-12),TODAY()),0,2),1)-C9),{"charttype","column";"negcolor","red";"color","green"})=SPARKLINE(INDEX(GOOGLEFINANCE(A9,"price",EDATE(TODAY(),-12),TODAY())))
10
BRK.BBerkshire Hathaway Inc Class B300.00=SPARKLINE(ARRAYFORMULA(SLICE(INDEX(GOOGLEFINANCE(A10,"price",EDATE(TODAY(),-12),TODAY()),0,2),1)-C10),{"charttype","column";"negcolor","red";"color","green"})=SPARKLINE(INDEX(GOOGLEFINANCE(A10,"price",EDATE(TODAY(),-12),TODAY())))
11
12
13
14
15
16
17
18
19
20
21
22
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