Explore

Personal Stock Portfolio Tracker

29 Pins
·
2y
By
All Stacks Developer
a line graph showing the market value versus
Stock Investment
Stock Portfolio
Investment Portfolio
Google Sheets
Risk Management
Evolution
Investment
Built In
Portfolio
Compute daily evolution of a stock investment portfolio by using only built-in functions of Google Sheets
an image of a table with numbers and symbols on it, including the number of columns
Price Chart
Google Apps
Syntax
Best Practice
Financial Advice
GOOGLEFINANCE Best Practices
GOOGLEFINANCE Best Practices
a screenshot of an excel spreadsheet with the date and time fields highlighted
Last Friday
Being Used
Periodic Table
How To Use
How to use WEEKDAY function to get last Friday in Google Sheets
an excel spreadsheet with multiple columns in the bottom row and numbers on top
Best Practices
GOOGLEFINANCE Best Practices
an image of a web page with the text'iff02 dp e9? quannties '
Step By Step
How To Apply
Compute cost basis of stocks with FIFO method in Google Sheets
a screenshot of an email address in google docs
Small Utility
Writing
How to convert column index into letters with Google Apps Script
an image of a table with numbers and times for each item in the chart below
Price Range
Bar Chart
To Create
Range
Use SPARKLINE to create 52-week range price indicator chart for stocks in Google Sheets
a screenshot of a calculator showing the cost of goods sold
Cost Of Goods Sold
Compute cost basis of stocks with FIFO method in Google Sheets
a computer screen with some text on it and two numbers in the bottom right corner
Calculator
Demo how to use XIRR and XNPV functions of Google Sheets to calculate internal rate of return (IRR) and net present value (NPV) for a stock portfolio
a block diagram with multiple blocks labeled in red, white and green on each side
The Net
Floor Plans
How to calculate the internal rate of return (IRR) and the net present value (NPV) of a stock portfolio with Google Sheets
Related searches
Dividend income
Data dashboard
How to introduce yourself
Free portfolio template
Time value of money
an info sheet with graphs and numbers on it, including the number of people in each country
Google Data Studio
Income Tracker
Dividend Income
Create dividend income tracker with Google Data Studio
the chart shows that there are two different types of stocks
Time Value
Time Value Of Money
Money
Time value of money, Present Value (PV), Future Value (FV), Net Present Value (NPV), Internal Rate of Return (IRR)
an excel spreadsheet with multiple columns and numbers in the bottom left hand corner
Pivot Table
Create a dividend income tracker with Google Sheets by simply using pivot tables
an image of a computer screen with numbers and symbols in red, green and white
Stock Correlation Analysis With Google Sheets