For those who have shares in US stock exchanges and want to see prices in USD. The template is in English.
All you have to do is change the columns A – Share, B – Buy price, C – Shares and D – Date of purchase. The rest is programmed.
By the “rest” we mean:
• Company name, • Current price, • 52 Week High, • 52 Week low, • Buy value, • Current value, • $ up / down, • % up / down, • % of holdings, • How many days has owned, • 1-year chart, • 6 month chart, • 3 month chart.
• Chart over best 3 stocks, • chart over worst 3 stocks, • chart over best %, • chart over % of holdings.
• QR code (you can print and paste somewhere) that shows the profit on the mobile screen.
• Create notifications, warnings for every changes in each cell.
Öppna, Arkiv, Kopiera. Kasta bort mitt exempel, ändra namn på mallen, Ändra kolumner 1 – 4. Klart! (Open, File, Copy. Throw away my ex, rename the template, change the columns 1 to 4. Done!)