Back to today’s briefing

Story perspectives

Unlock Excel's STOCKHISTORY: Subscription Required for Stock Data

5/2/2025

22 2

Summary

Story summary

The STOCKHISTORY function in Excel needs a subscription and internet access for use.
It retrieves stock data with two required inputs: stock code and start date.
Optional inputs include end date, interval, headers, and properties.
By default, it provides daily data and shows errors for dates lacking price information.
Example: Use XASX:CBA for Commonwealth Bank on the Australian stock exchange.

1 of 1

Story summary

The STOCKHISTORY function in Excel needs a subscription and internet access for use.
It retrieves stock data with two required inputs: stock code and start date.
Optional inputs include end date, interval, headers, and properties.
By default, it provides daily data and shows errors for dates lacking price information.
Example: Use XASX:CBA for Commonwealth Bank on the Australian stock exchange.