Need to turn stock market data into smart, professional reports? Discover how to use Excel's new and powerful Stock History function to quickly transform raw share price data into clear, insightful reports.
Learn how to streamline reporting, visualise trends and make better-informed decisions with ease.
In this episode, gain the skills to:
- Access daily, weekly or monthly data, including volume, opening/closing prices and highs/lows
- Set up stock codes, choose custom date ranges and define intervals with ease
- Use Power Query to import real-time stock exchange data directly into Excel
- Build interactive, professional-grade charts (including stock and combo charts) to visualise trends
Whether you're preparing reports for clients, internal dashboards or just keeping a close eye on the stock market, this episode gives you the tools, steps and techniques you need to do it with confidence using Excel.
For fast reference, use the episode timestamps:
Popular Podcasts
Las Culturistas with Matt Rogers and Bowen Yang
Ding dong! Join your culture consultants, Matt Rogers and Bowen Yang, on an unforgettable journey into the beating heart of CULTURE. Alongside sizzling special guests, they GET INTO the hottest pop-culture moments of the day and the formative cultural experiences that turned them into Culturistas. Produced by the Big Money Players Network and iHeartRadio.
The Joe Rogan Experience
The official podcast of comedian Joe Rogan.
Stuff You Should Know
If you've ever wanted to know about champagne, satanism, the Stonewall Uprising, chaos theory, LSD, El Nino, true crime and Rosa Parks, then look no further. Josh and Chuck have you covered.