Pre-market stock prices

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:

Apple stock price: live and pre-market

We have recently added some new Excel formulas to the Add-in to provide pre-market prices in Excel:

  • EPF.Yahoo.PreMarketPrice
  • EPF.Yahoo.PreMarketChange
  • EPF.Yahoo.PreMarketChangePercent
  • EPF.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:

Excel Price Feed pre-market stock prices

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s