In this video I show you how to build a simple stock tracker in Google Sheets that pulls live market data from Google Finance. It is easy to create and essential for anyone looking to track the performance of their stock portfolio better. I also build in functionality to accommodate different currencies too, such as the USD, AUD, and NZD.
For an easier option, make sure to check out Sharesight and get four months free at this link: sharesight.com.au/brentcoleman
// FORMULAS
Google Finance Exchange Codes: www.google.com/googlefinance/...
Google Finance Formulas: =googlefinance(stockcode,"function")
Google Fiannce Functions: support.google.com/docs/answe...
Chart: =sparkline(index(googlefinance(C7,"price",today()-365,today()),,2),{"charttype","column";"color","teal"})
Change the 365 to any other number if you want to see a different time span
Change the colour ("teal") to any you prefer!
// SOCIAL
🌏 Follow Me On Instagram @brentcolemaninvesting
// USEFUL LINKS
✅ Sharesight (NZ/AU/US/UK) 4 Months Free: sharesight.com.au/brentcoleman
✅ Dosh NZ - Best Way To Pay: dosh.nz/app and use my referral code 00030886
✅ Get $5 FREE with Sharesies (NZ/AU): sharesies.com/r/C744KD
✅ Get $45 with DoorDash: drd.sh/yzemFEO8gYRTjiKt
✅ Free Month Car Insurance coveinsurance.co.nz/referred/...
✅ Get $10 FREE with Hatch Invest (NZ): app.hatchinvest.nz/share/hmwy...
✅ Hnry (NZ) Free $25 Freelance Accountant: app.hnry.io/r/BRENT82488
I include these links as they often provide a benefit to my viewers. I might receive a commission from these companies, or other third parties, in the case a purchase is made either using a link or signing up for a service via a code. This helps me create high-quality content and I thank you for your support.
// TIMESTAMPS
► 0:00 Intro
► 0:24 Create The Tracker
► 10:53 Charts
► 12:02 Sparklines
► 14:38 Outro
Disclaimer:
I am not a financial adviser. This video is for education and entertainment purposes only. Seek professional help before making any investment decision.
Song: Too Fast - Ooyy
Epidemic Sound
share.epidemicsound.com/g93nl2
25 июл 2024
