Excel Tips

Better share price reports with Excel’s new tool


Listen Later

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: 

  • 0:00 – Introduction to Excel Tips podcast 
  • 0:18 – Overview of Stock History function  
  • 0:31 – Using Stock History for reporting share price information  
  • 1:00 – Internet access requirement for Stock History  
  • 1:11 – Disclaimer for information accuracy  
  • 1:35 – Options for reporting frequency (daily, weekly, monthly)  
  • 2:08 – Setting up share code and trading day considerations  
  • 2:47 – Defining start and end dates for reports  
  • 3:45 – Reporting intervals and their corresponding numbers  
  • 4:39 – Using MATCH function for human-friendly reporting  
  • 4:59 – Customising report headers  
  • 5:23 – Defining properties for the Stock History function  
  • 5:35 – How to add multiple properties to reports   
  • 6:30 – Importing stock exchange names and codes  
  • 6:40 – Using Power Query for stock data updates  
  • 7:20 – Overview of Excel stock chart features  
  • 7:30 – Understanding stock price movements in charts  
  • 8:25 – Overview of monthly vs weekly stock charts  
  • 9:44 – Creating combo charts for better comparisons  
  • 10:30 – Introduction to Sparkline charts  
  • 10:05 – Converting vertical to horizontal data for Sparklines  
  • 10:35 – Adjusting Sparkline chart vertical axes  
  • 11:03 – Updating Sparklines for spill ranges  
  • 11:18 – Function updates and internet speed considerations  
  • 11:32 – Conclusion on the usefulness of Stock History 

Listen now to level-up your stock market share price reporting skills in Excel.  

Host: Neale Blackwood CPA. He has more than 20 years of experience as a Microsoft Excel educator and is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants. 

You can find a CPA at our custom portal on the CPA Australia website.  

Would you like to listen to more Excel Tips episodes? Head to CPA Australia’s YouTube channel.  

CPA Australia publishes four podcasts, providing commentary and thought leadership across business, finance, and accounting:  

  • With Interest
  • INTHEBLACK 
  • INTHEBLACK Out Loud
  • Excel Tips 

Search for them in your podcast platform.  

Email the podcast team at [email protected]  

...more
View all episodesView all episodes
Download on the App Store

Excel TipsBy CPA Australia

  • 5
  • 5
  • 5
  • 5
  • 5

5

1 ratings


More shows like Excel Tips

View all
Economist Podcasts by The Economist

Economist Podcasts

4,278 Listeners

HBR IdeaCast by Harvard Business Review

HBR IdeaCast

1,830 Listeners

Planet Money by NPR

Planet Money

30,839 Listeners

Exchanges by Goldman Sachs

Exchanges

991 Listeners

With Interest by CPA Australia

With Interest

4 Listeners

Fintech Insider Podcast by 11:FS by 11:FS

Fintech Insider Podcast by 11:FS

186 Listeners

Worklife with Adam Grant by TED

Worklife with Adam Grant

9,189 Listeners

The Journal. by The Wall Street Journal & Spotify Studios

The Journal.

5,937 Listeners

The World in Brief from The Economist by The Economist

The World in Brief from The Economist

1,080 Listeners

Think Fast Talk Smart: Communication Techniques by Matt Abrahams, Think Fast Talk Smart

Think Fast Talk Smart: Communication Techniques

794 Listeners

Chanticleer by Australian Financial Review

Chanticleer

18 Listeners

INTHEBLACK by CPA Australia

INTHEBLACK

1 Listeners

HBR On Leadership by Harvard Business Review

HBR On Leadership

151 Listeners

INTHEBLACK Out Loud by CPA Australia

INTHEBLACK Out Loud

0 Listeners

15 Minutes with the Boss by The Australian Financial Review

15 Minutes with the Boss

6 Listeners