If You Bought AMZN Stocks Instead
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMAN
1
If You Bought AMZN Stocks Instead
2
Purpose: Calculates how much AMZN you could have bought with the money spent on Amazon shopping
3
Step 1
Make a copy of this gSheet for your own use (I don't want your data! Also you may see #REF errors but they are resolved once you copy this sheet to your own gDrive and follow steps below)
4
Step 2
Go to this URL -> download your order report -> choose report type: items (you can go as far back as 1997, the year AMZN IPO'd)
5
https://www.amazon.com/gp/b2b/reports
6
Step 3
Copy all of your report (CTRL/CMD+A), select just cell E20 (light blue), and paste (your browser may freeze, choose the wait option several times)
7
Step 4
Make sure that the formulas and total amount encompass all your data rows (see the 5 yellow cells), check out the Example with Data sheet if you are unsure
8
Step 5Weep ๐Ÿ˜ญ
9
Step 6
A. Get a free stock from Robinhood (not AMZN, but you might get AAPL) ๐Ÿ‘‰
https://share.robinhood.com/suetyic
10
B. Start managing your finances and get a $20 AMZN gift card from Personal Capital ๐Ÿ‘‰
https://share.personalcapital.com/x/ZF7kAV
11
C. Buy me a โ˜• ($1-$5) if you'd like, for saving you money in the future ๐Ÿ‘‰
https://paypal.me/christinchong
12
D. If you do A/B/C (or not), let me know on Twitter and I'll follow you back @christintweets ๐Ÿฆ
13
14
Total amount you spent on Amazon
$0.00
15
If you had bought Amazon Stock instead
#REF!
16
Today's AMZN Price
$1,897.83
17
Assumptions/known issues
Assumes $0 transactional costs and ability to buy fraction of a share
18
Assumes buy-and-hold strategy with no dividend
19
20
AMZN Price on Order DateFraction of Amazon ShareHow much it is worth today
Select this cell, copy & paste your full orders report here
21
#REF!#REF!#REF!
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
Loading...