Trade Tracker Code In Google Sheets | Master Portfolio Tracker
Trade Tracker Code In Google Sheets | Master Portfolio Tracker
📈 Link to download all my Portfolio Trackers: https://www.patreon.com/thinkstocks
☑️ Follow me on Twitter: https://twitter.com/KeithFrislid
🌎 Check out my discord server: https://discord.gg/eAMBYqK3t2
🎥 Here is the camera I use for my videos: https://amzn.to/2PB865Q
🔶Get 50% off Seeking Alpha Premium with my Promo Link!!!🔶
https://subscriptions.seekingalpha.com/lp_premium_affiliate_think_stocks/?source=affiliate_program:thinkstocks&utm_medium=affiliate&utm_source=thinkstocks&utm_campaign=campaign_name&variable_key=variable_value
In this video, I will show you how to track every trade you make in Google Sheets so you can create these amazing portfolio trackers. This tutorial will show you how to write your own function to calculate exactly how many stocks you have, how many shares of each stock, and what your average purchase price is! This code is a major update from one of my older portfolio tracker videos. In that video, the code did not account for when you sold off a stock then rebought it at a later date. This would mess up the purchase price.
This video will show you how to fix that problem and how to write a code in google sheets that will no longer count stocks that have been sold off already using the FIFO method or "first in first out".
Link to Portfolio Tracker Video: https://youtu.be/qtY1NOVQ6iE
If you want to support my channel check out both my Patreon and discord below!
AFFILIATE DISCLOSURE: Some of the links on this channel and in video descriptions are affiliate links. At no additional cost to you, we receive a commission if a purchase is made after clicking the link.
#googlesheets #codeingooglesheets #stocksingooglesheets
Видео Trade Tracker Code In Google Sheets | Master Portfolio Tracker канала Think Stocks
📈 Link to download all my Portfolio Trackers: https://www.patreon.com/thinkstocks
☑️ Follow me on Twitter: https://twitter.com/KeithFrislid
🌎 Check out my discord server: https://discord.gg/eAMBYqK3t2
🎥 Here is the camera I use for my videos: https://amzn.to/2PB865Q
🔶Get 50% off Seeking Alpha Premium with my Promo Link!!!🔶
https://subscriptions.seekingalpha.com/lp_premium_affiliate_think_stocks/?source=affiliate_program:thinkstocks&utm_medium=affiliate&utm_source=thinkstocks&utm_campaign=campaign_name&variable_key=variable_value
In this video, I will show you how to track every trade you make in Google Sheets so you can create these amazing portfolio trackers. This tutorial will show you how to write your own function to calculate exactly how many stocks you have, how many shares of each stock, and what your average purchase price is! This code is a major update from one of my older portfolio tracker videos. In that video, the code did not account for when you sold off a stock then rebought it at a later date. This would mess up the purchase price.
This video will show you how to fix that problem and how to write a code in google sheets that will no longer count stocks that have been sold off already using the FIFO method or "first in first out".
Link to Portfolio Tracker Video: https://youtu.be/qtY1NOVQ6iE
If you want to support my channel check out both my Patreon and discord below!
AFFILIATE DISCLOSURE: Some of the links on this channel and in video descriptions are affiliate links. At no additional cost to you, we receive a commission if a purchase is made after clicking the link.
#googlesheets #codeingooglesheets #stocksingooglesheets
Видео Trade Tracker Code In Google Sheets | Master Portfolio Tracker канала Think Stocks
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![FREE Dividend Portfolio Spreadsheet (v3.0) | HUGE Updates + Full Walkthrough](https://i.ytimg.com/vi/Qta1GzXwB4U/default.jpg)
![Google Sheets Master Portfolio Tracker | Dark Theme](https://i.ytimg.com/vi/T47pgIS67_M/default.jpg)
![International Stock Tracker in Google Sheets](https://i.ytimg.com/vi/XCdvEZ8_V8I/default.jpg)
![](https://i.ytimg.com/vi/49Ng95bwjSw/default.jpg)
![Build A Fully Functioning STOCK WATCHLIST With Live Data In Google Sheets](https://i.ytimg.com/vi/cm5ZLtPFisc/default.jpg)
![Automated Email Stock Price Alerts With Google Sheets](https://i.ytimg.com/vi/RYQOR6J6Hvg/default.jpg)
![Get Latest Stock Data in Excel & Create Your Own Stock Portfolio](https://i.ytimg.com/vi/7CqWwbcOxk4/default.jpg)
![Finviz Tracker In Google Sheets](https://i.ytimg.com/vi/SSbOjK0A3DM/default.jpg)
![How to Calculate the Intrinsic Value of a Stock like Benjamin Graham! (Step by Step)](https://i.ytimg.com/vi/8jmjxXc5H8c/default.jpg)
![How To Make A Stock Watchlist In Google Sheets](https://i.ytimg.com/vi/nn-Jv32o-XU/default.jpg)
![Think Stocks Crypto Tracker | Coin Market Cap Data](https://i.ytimg.com/vi/z8tnM1UDKEw/default.jpg)
![How To Pull Dividend Data Into Google Sheets](https://i.ytimg.com/vi/uZY-AeZex2g/default.jpg)
![Stock Portfolio and Dividend Tracker | Google Sheets Spreadsheet Tutorial (Step-by-Step)](https://i.ytimg.com/vi/0tky8n9nUQw/default.jpg)
![How To Make A Day Trading Tracker In Google Sheets](https://i.ytimg.com/vi/OIta3q1YrgA/default.jpg)
![How to Create a Day Trading Tracker in Google Sheets (Step by Step - 2021)](https://i.ytimg.com/vi/fv1h4p2lfvQ/default.jpg)
![Build Your Own Stock Portfolio Tracker On Google Sheets](https://i.ytimg.com/vi/qtY1NOVQ6iE/default.jpg)
![Excel Stock Portfolio Dashboard - FREE File Download](https://i.ytimg.com/vi/D44EDant0rs/default.jpg)
![Investment Tracker in Google Sheets! (Track Stocks, Crypto, ETFs, and Dividends)](https://i.ytimg.com/vi/Ss8lZwYKCmk/default.jpg)
![The Best Monthly Budget Tracker In Google Sheets](https://i.ytimg.com/vi/IAOVEOolTPU/default.jpg)
![How To Pull Stock Data Into Google Sheets | Google Finance Function](https://i.ytimg.com/vi/kjAoOCWM7Ms/default.jpg)