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:
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.