Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Open (On Demand)

Live
Returns the price at which stocks first trade upon market opening (9:30 AM EST).

How calculated

No Calculations

Example usage

=QM_Open("MSFT")

Assets

Stocks ETFs Options Mutual Funds Indices Currencies Cryptocurrencies
Legal
DisclaimerPrivacy PolicyLicense AgreementTerms of UseRefund PolicyDMCA Policy
Company
Contact UsTeamAffiliates
Resources
MarketXLS statusStatus
Knowledge BaseServicesMarketXLS ReviewOptions Trading Plugin
Demos
Book your personal DemoVideo TutorialsVersion History
Data Sources
Toronto Stock Exchange
barchart
quotemedia
FRED data
Nasdaq
iex cloud
Financial Market Data powered by Quotemedia.com. All rights reserved. View the Terms of Use. Data delayed by 15 minutes unless indicated. Real-time data subscriptions available through our data partners and require additional exchange subscription agreements.

MarketXLS does “not” provide its own datafeed or any API access to users of the software for any commercial purposes of the user. The software is for personal use only as defined in our License Agreement. Users may not use the data provided in violation of the terms of our License Agreement.

Information provided in this solution is obtained from sources believed to be reliable. The publishers are not responsible for any errors or omissions contained herein or delivered through the software. Data and functionality of this software is subject to many factors including but not limited to internet connectivity, data interruptions, server breakdowns, trading halts etc.

Financial Market Data copyright © 2019 QuoteMedia. Data delayed 15 minutes unless otherwise indicated (view delay times for all exchanges). RT=Real-Time, EOD=End of Day, PD=Previous Day. Market Data powered by QuoteMedia. Terms of Use.

All data on this website is Copyright © MarketXLS.

© 2021 MarketXLS Limited