Open Price
The price at which stocks first trade upon opening of the stock market (9:30 AM EST).
Syntax
=mxls.OpenPrice(Symbol)Excel Templates Using Open Price
These ready-made MarketXLS templates call OpenPrice() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS MarketXLS Analytics formulas you can use in the same worksheet:
- Option Symbol Convert
- Percent Below Fifty Two Week High
- Percent Change From 52-Week High
- Percent Change From 52-Week Low
- Pitrioski FScore
- Price At Minute
- Price At Minute
- Price Change From Minute
See OpenPrice used in a complete workbook: AI Agent Stocks Dashboard Excel: Agentic AI Software Screener for Summer 2026
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?