In this video I show you how to build your very own stocks tracker dashboard using completely free to use tools and the google finance api.
You'll learn how to build a data studio dashboard that gives lots of KPIs. Stock tracker Google API.
🚨 THE BI ANALYST STARTER PROGRAM - ENROL NOW! - https://geni.us/bicsp_yt
START YOUR BI JOURNEY! - https://learnbi.online
🎥 RECOMMENDED VIEWING
7 Steps to Your 1st BI Analyst Job - https://geni.us/7stepstobivid
Learn Basic SQL in 15 Minutes - https://geni.us/learnbasicsql15-1
BI For Beginners Playlist - https://geni.us/biforbeginners-play
🎓 RECOMMENDED COURSES
SQL For BI Analysts - https://geni.us/lbia_sql
Excel For BI Analysts - https://geni.us/lbia_excel
Power BI For BI Analysts - https://geni.us/lbia_powerbi
Tableau For BI Analysts - https://geni.us/lbia_tableau
Ultimate Guide to Looker Studio - https://geni.us/lbia_lookerstudio
LearnSQL.com - https://geni.us/learnsql
🧰 DATA ANALYST PROJECTS (PAID)
Ben’s Pizza - https://geni.us/pizzaproject
Hotel Reservations - https://geni.us/hotelproject
Multi-Channel Marketing - https://geni.us/multichannelproject
Call Centre - https://geni.us/callcentreproject
📕 FREE EBOOKS
7 Top Tips For Better Dashboard Design - https://geni.us/dashdes-ebook
Skills You Need To Succeed In BI - https://geni.us/biskills-ebook
📊 DATA HUBS & WEBSITES:
Power My Analytics - https://geni.us/YLc9Re
Windsor.ai - https://geni.us/windsorai
Kaggle - https://www.kaggle.com/
Statista - https://www.statista.com/
Data World - https://data.world/
📕THE DATA VISUALISATION BIBLE - https://geni.us/iJTa8
DISCLAIMER: Some of the above links are affiliate links where I'll earn a small commission if you make a purchase using them, at no additional cost to you. It really helps support the channel so thanks in advance if you do use them 🙏
✅ LET'S CONNECT!
BUSINESS INQUIRIES - https://learnbi.online/contact
CONSULTING CALL WITH ADAM - https://geni.us/bookacall-adamfiner
JOIN MY MAILING LIST - https://geni.us/PSgRsF
FACEBOOK GROUP - https://geni.us/learnbi-fbg
#stocks #stocktrading #stockportfolio
** GET ACCESS TO THE GOOGLE SHEETS DATA **
https://geni.us/stockportfoliodata
Google doc for GOOGLEFINANCE API: https://support.google.com/docs/answe...
Formula used for % Gain calculation: (sum(Stock value)-sum(Total investment))/sum(Total investment)
My YouTube Gear - kit.co/adamfiner
Vitamin BI is a Business Intelligence consultancy. Please visit https://www.vitaminbi.com for more information
#stocktrading #freestockstracker #dataviz