ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
AAPLsymboldateopenhighlowclosevolume
2
MSFTAAPL2025-07-25212.1215.78211.63213.88231062208
3
AAPL2025-08-01214.03214.85201.5202.38319915158
4
AAPL2025-08-08204.51231201.68229.35431826281
5
AAPL2025-08-15227.92235.12224.76231.59295311911
6
MSFT2025-07-25506.71518.29500.7513.7179564733
7
MSFT2025-08-01514.08555.45509.44524.11137752650
8
MSFT2025-08-08528.27538.25517.55522.0497486428
9
MSFT2025-08-15522.3532.7519.08520.17103984799
10
11
12
13
How it works
14
15
Here is an oversimplified example from help
16
17
16
=REDUCE(0,C17:C19,LAMBDA(result,cell,result+cell))
18
2
๐Ÿ‘† this works same way as SUM(C17:C19)
19
3
20
21
What if instead of adding up number we will add ranges ๐Ÿค”
22
23
AAPLsymbol
=REDUCE({"symbol"},C23:C24,LAMBDA(result,symbol,{result;symbol}))
24
MSFTAAPL
๐Ÿ‘† works the same way as previous example, except now we are joining ranges
25
MSFT
26
27
Now we can join googlefinance ๐Ÿ”ฅ
28
29
AAPLsymboldateclose
=REDUCE({"symbol","date","close"},C29:C30,LAMBDA(result,symbol,{result;QUERY(QUERY(GOOGLEFINANCE(symbol,"close",TODAY()-2,TODAY()),"SELECT '"&symbol&"',Col1,Col2"),"OFFSET 1",0)}))
30
MSFTAAPL8/20/2025 16:00:00226.01
๐Ÿ‘† your goal is to pass wanted data to lambda function, just give it a try and try to reverse it
31
AAPL8/21/2025 16:00:00224.9
32
MSFT8/20/2025 16:00:00505.72
33
MSFT8/21/2025 16:00:00504.24
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