INTHEBLACK May 2025 - Magazine - Page 60
WORK SMART
SUBSCRIBE
EXCEL TIPS
to the podcast
UTILISE THE
STOCKHISTORY FUNCTION
NEALE BLACKWOOD CPA
Learn how to use the STOCKHISTORY function to plot
stock-exchange pricing information using the built-in
Stock chart as well as other Excel charts.
The new STOCKHISTORY function allows formulas to extract historic
share price information from different stock exchanges around the world.
This function can be used with charts to plot the share price and volume
information dynamically.
This new function requires the subscription version of Excel and
an internet connection.
Read the full article
Utilise the STOCKHISTORY function
INTHEBLACK, Neale Blackwood CPA: Excel Tips — Utilise the STOCKHISTORY function
CLICK TO LAUNCH VIDEO IN A NEW WINDOW
60 INTHEBLACK May 2025
UPSKILL
with CPA Australia’s
Excel in-person
workshops and
virtual classrooms
