Stock markets are generally only open during specific times, the “trading day”. For example, the US market is open from 9:30am to 4:00pm (EST).
However, this is not the only period when trading takes place and when prices can change, there is also the pre-market which is “open” before the regular market opens.
This is a time of very little liquidity however trading during this time can enable you to take advantage of any news or events that happen outside normal market hours.
Yahoo Finance provides prices during this period, the pre-market (or before hours) prices.
For example, below we can see the current “before hours” price for Apple stock is 364.00 and the price has moved -2.53 from yesterdays close price of 366.53:
We have recently added some new Excel formulas to the Add-in to provide pre-market prices in Excel:
EPF.Yahoo.PreMarketPriceEPF.Yahoo.PreMarketChangeEPF.Yahoo.PreMarketChangePercentEPF.Yahoo.MarketState
This last formula is used to find the current state for the market eg. whether we are in regular or pre-market trading hours: “REGULAR” or “PRE”.
The example spreadsheet below shows the formulas in action, you can see column C uses the PreMarketPrice formula which references the ticker in column A:
We hope you find these new formulas useful and as ever keep your feedback coming, preferably on the Support Forum or leave a comment below.
The Excel Price Feed Blog 
Dear Support,
This is good indeed. To make it more actionable however, pre-market high and pre-market low are important. Similarly to normal high of day and low of day data. Please keep in mind, that in earning period and in small cap land a lot of things can happen outside regular trading hours.
Thank you for your consideration.
LikeLike
Thanks for your comment.
I agree, pre-market highs and lows would be useful however we can’t currently provide this data as none of our data sources include it.
We do, however, now also provide post-market (after hours) prices which you may find useful.
LikeLike