Let’s see how to get Stock Quote in Excel. Get real-time Stock Prices in Excel. You can retrieve stock quotes in Excel by using the MSN MoneyCentral web query – but things have changed a lot now.

In the Current value column for your first stock, input the formula to multiply the number of shares by the price. Excel will ...

For example, typing "MSFT stock" will give you Microsoft's current stock price and other details. ... To get a stock quote in Excel, you need to convert text into the "Stocks" data type.

The forward price-to-earnings ratio (P/E) is a valuation metric that measures and compares a company's earnings using expected earnings per share and the current stock price.