ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Google SymbolCurrent QuoteQuote DateComment
2
VTSAX98.0511/25/2022 0:00:00Mutual Fund
3
VTRIX36.511/25/2022 0:00:00
4
5
GOOG97.611/25/2022 13:05:00Stock
6
GOOGL97.4611/25/2022 13:05:00
7
8
LON:ABD2.6811/25/2022 16:35:03
Uses quote / 100 to convert to pounds from pence
9
10
CADUSD0.746185211/26/2022Currency
11
12
13
Instructions:
14
Automated import into Quicken: https://www.aczoom.com/tech/import-prices-script-for-quicken/
15
This spreadsheet gets the current price for a financial asset, and this can be loaded into Quicken to update its Prices.
16
Make a copy of this spreadsheet. Set "Share" to Allow anyone to view with link.
17
Then use that URL, changing the final "/edit?usp=sharing" to "/export?format=csv and pass it in as /gcsv: option to the import script.
18
19
See the notes in the Current Quote and Quote Date cells for information how to get that column data using =GoogleFinance function.
20
Duplicate rows as needed. Edit the Google Symbol column only. Quote price and date columsn are automically calculated.
21
Google Symbol may be of form exchangename:ticker, example LON:ABD or CURRENCY:CADUSD
22
23
Note that the Download as CSV only works if GOOGLEFINANCE formula is not used for historical dates.
24
So the following will not work - it downloads as N/A values.
25
DateClose
Date cell has: =GOOGLEFINANCE("GOOG", "price", "11/1/2017", 7)
26
11/1/2017 16:00:0051.2811/26/2022
27
11/2/2017 16:00:0051.28
28
11/3/2017 16:00:0051.62
29
11/6/2017 16:00:0051.3
30
11/7/2017 16:00:0051.67
31
11/8/2017 16:00:0051.99
32
11/9/2017 16:00:0051.56
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