Stock & crypto tracker templates for Google Sheets (Portfolio, Analysis, Watchlist, Screener)
Get the templates: https://www.spreadsheetclass.com/google-sheets-stock-tracker-templates/
Learn to import CSV files: https://youtu.be/dtAVgCkCtWc
Learn to pull stock prices: https://youtu.be/Cd-DlJdWbsg
Get help with your spreadsheet project, or personalized training:
https://www.spreadsheetclass.com/consulting/
Get the ultimate formulas cheat sheet
https://www.spreadsheetclass.com/best-google-sheets-cheat-sheet/
Learn to build dashboards in Google Sheets:
https://www.spreadsheetclass.com/google-sheets-dashboards-course/
In this video I am going to show you 5 different stock tracker templates for Google Sheets.
You will be able to track your stock portfolio with a simple tracker, or with a more advanced tracker that shows in depth information about your trading performance.
You can also build a watchlist in the stock analysis tracker, and screen your watchlist by custom criteria.
You can keep track of your open trades, as well as your closed trades, and you will be able to see a wide variety of statistics related to your trading performance.
You can also track cryptocurrency profits in the portfolio templates!
You'll see that there are versions of the template that allow you to track your trades manually, and there are also versions that allow you to import a spreadsheet report from your broker to automatically track your trades (Such as a report from Fidelity).
Watch on YouTube ↗
(saves to browser)
Sign in to unlock AI tutor explanation · ⚡30
Playlist
Uploads from Spreadsheet Class · Spreadsheet Class · 52 of 60
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
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
▶
53
54
55
56
57
58
59
60
How to use the FILTER function in Google Sheets (Single or Multiple Conditions)
Spreadsheet Class
5 formulas that combine columns in Google Sheets (Horizontal and Vertical)
Spreadsheet Class
All the ways to extract text and numbers in Google Sheets
Spreadsheet Class
How to filter based on a list in Google Sheets
Spreadsheet Class
How to fix the "FILTER has mismatched range sizes" error in Google Sheets
Spreadsheet Class
How to color cells, and alternate row colors in Google Sheets
Spreadsheet Class
How to automatically create a series of values in Google Sheets
Spreadsheet Class
Google Sheets Beginner Tutorial
Spreadsheet Class
How to make a Dashboard in Google Sheets (Full Tutorial)
Spreadsheet Class
Using the SORT and FILTER function in the same formula in Google Sheets
Spreadsheet Class
ARRAYFORMULA function: Apply a formula to an entire column in Google Sheets
Spreadsheet Class
Automatically resize columns in Google Sheets with Fit to Data
Spreadsheet Class
How to import or convert a CSV file into Google Sheets
Spreadsheet Class
How to export / download a CSV from Google Sheets
Spreadsheet Class
How to change text case in Google Sheets with UPPER LOWER and PROPER
Spreadsheet Class
How to use the Calendar Template in Google Sheets
Spreadsheet Class
How to rotate text in Google Sheets
Spreadsheet Class
How to create charts in Google Sheets (And how to customize them too)
Spreadsheet Class
How to copy formulas, and lock cell references in Google Sheets (Relative & absolute references)
Spreadsheet Class
How to copy and paste values only in Google Sheets
Spreadsheet Class
How to fix the "Circular Dependency Detected" error in Google Sheets
Spreadsheet Class
Evenly space columns in Google Sheets (Make columns the same size quickly)
Spreadsheet Class
Doing math in Google Sheets: Add, Sum, Subtract, Multiply, Divide, Square, Square Root
Spreadsheet Class
How to filter horizontally in Google Sheets (Filter columns)
Spreadsheet Class
UNIQUE function: Removing duplicates with 2 methods in Google Sheets
Spreadsheet Class
Report Builder template for Google Sheets (Automatically organize / calculate your data)
Spreadsheet Class
Build a Google Sheets dashboard with Google Forms data (Automated)
Spreadsheet Class
Guitar tabs template for Google Sheets (& PDF) | Create your songs in a Google spreadsheet
Spreadsheet Class
Interactive Google Sheets dashboard with drop down menus tutorial
Spreadsheet Class
Student attendance dashboard tutorial in Google Sheets: Simple + advanced
Spreadsheet Class
SORT function in Google Sheets (Sort data vertically or horizontally)
Spreadsheet Class
How to use the SORT function in Google Sheets (Quick Version)
Spreadsheet Class
How to copy chart formatting and duplicate charts in Google Sheets
Spreadsheet Class
How to copy a tab to a new file / sheet in Google Sheets
Spreadsheet Class
How to duplicate tabs in Google Sheets
Spreadsheet Class
How to hide and unhide tabs in Google Sheets
Spreadsheet Class
How to make a copy of a file in Google Sheets
Spreadsheet Class
How to change tab color in Google Sheets
Spreadsheet Class
How to insert, delete, rename, and reorder tabs in Google Sheets
Spreadsheet Class
How to move a chart to another sheet in Google Sheets
Spreadsheet Class
How to wrap text, unwrap text, and clip text in Google Sheets
Spreadsheet Class
Switch columns and rows with the TRANSPOSE function in Google Sheets
Spreadsheet Class
Project management timeline template for Google Sheets (Gantt Chart)
Spreadsheet Class
Build a dashboard in 3 simple steps (Google Sheets)
Spreadsheet Class
Pull data from websites in Google Sheets with IMPORTXML function | Web scraping (Stock prices)
Spreadsheet Class
(Quick version) Pulling data from websites with IMPORTXML function | Google Sheets web scraping
Spreadsheet Class
Pull cryptocurrency prices in Google Sheets (2 methods) | GOOGLEFINANCE and IMPORTXML crypto prices
Spreadsheet Class
Fast & simple dashboard tutorial for Google Sheets (Build in under 15 minutes)
Spreadsheet Class
How to create drop-down lists in Google Sheets (Data validation)
Spreadsheet Class
The ultimate cheat sheet for Google Sheets (Formulas, charts, shortcuts, and more)
Spreadsheet Class
3 ways to pull crypto prices into Google Sheets | GOOGLEFINANCE, IMPORTXML, IMPORTDATA
Spreadsheet Class
Stock & crypto tracker templates for Google Sheets (Portfolio, Analysis, Watchlist, Screener)
Spreadsheet Class
How to indent in Google Sheets (5 Methods)
Spreadsheet Class
Pull stock prices & stock data with the GOOGLEFINANCE function in Google Sheets (& Crypto too)
Spreadsheet Class
How to create and customize charts in Google Sheets (Quick version)
Spreadsheet Class
Apply a formula to an entire column in Google Sheets with the ARRAYFORMULA function | Quick Version
Spreadsheet Class
How to insert a new line in a cell (or formula) in Google Sheets
Spreadsheet Class
How to freeze rows & columns (& How to unfreeze) in Google Sheets
Spreadsheet Class
How to add and sum in Google Sheets (Addition and SUM function)
Spreadsheet Class
How to average in Google Sheets (Using the AVERAGE function)
Spreadsheet Class
More on: Data Literacy
View skill →
Related AI Lessons
⚡
⚡
⚡
⚡
Quest ROI on AgentHansa: Why Most Agents Pick the Wrong Quests (48-Quest Data Analysis)
Dev.to AI
Your Pipeline Is 8.3h Behind: Catching Business Sentiment Leads with Pulsebit
Dev.to · Pulsebit News Sentiment API
Why Hiring More Data Engineers Won’t Solve Your Delivery Problem
Forbes Innovation
Comparing Tools for Intelligent Demand Prediction in Retail
Dev.to AI
🎓
Tutor Explanation
DeepCamp AI