FREE Dividend Meter Template
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This tool is provided for free, feel free to update / expand it as you wish. If you create a better version, let me know on https://steemit.com/@lukascech/ or www.lukascech.com.
ENJOY!
2
The spreadsheet on tab Dividends calc - G is pre-populated with some dummy data so you can see it in action straight away.
3
4
1
Feed me! = populate the source data on sheet TipranksData
5
- Register for free and create a FREE portfolio at Tipranks:
https://www.tipranks.com/smart-portfolio/holdings/holdings
6
- populate with the stock symbols you are interested in. This is useful also outside this spreadsheet, as they provide good stats and change analysis over time for your portfolio
7
- click on Add metrics to chart at bottom right of the table and make sure you have the same metrics selected as on the image - Fig.1 below
8
- scroll down to the bottom of your portfolio table and bottom right click on the Download link
9
- open and copy data to TipranksData tab in this spreadsheet - replace old data:
10
- in downloaded spreadsheet: CTRL+A (select all) and CTRL+C (copy)
11
- in this spreadsheet, TipranksDATA - CTRL+A and then CTRL+V
12
- GLITCH in Tipranks Export - check TipranksData, column N "Dividend". For some reason, they append "false" to the number, so we remove it this way:
13
- select entire column N
14
- press CTRL+F and click on the three vertical dots on the search pop up
15
- find: false, replace with: <leave blank>, click on Replace All
16
- "false" should dissappear from the column
17
2
copy the formulas in row 1
18
3
Copy & paste values from row 4 down to all rows you have just calculated
19
- this ensures that the data is not pulled and recalculated each time you sort the data or delete / add a row
20
21
22
Fig. 1 - select these portfolio metrics (columns)
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...