Become a personal finance expert
Subscribe to our thrice-weekly personal finance newsletter that makes you smarter about your money.
Formulas, shortcuts, and other hot spreadsheet tips.
Confession: I don’t use a personal finance app to track my spending or net worth. For years, I’ve used a Google Sheets spreadsheet, and my only gripe was that I couldn’t easily track my net worth in real-time. That ended when I discovered GOOGLEFINANCE().
The formula returns the live price of a stock, mutual fund, ETF, or cryptocurrency. It can also give you historical prices, fund expense ratios, or number of outstanding shares with a few extra inputs. You can check out its full powers here.
In Excel: Yep, Excel can return stock prices, too. Enter each ticker in its own cell > Highlight the cells > Select “Data” > “Stocks” > Tap the square that appears above your first highlighted cell > Select the data point you want.
In Google Sheets: Type =GOOGLEFINANCE() into an empty cell with the ticker symbol in the parentheses. You can see in the GIF above that I reference a list of sample tickers and multiply the formula by the number of shares owned to sum the portfolio’s worth.
FAQs
You can use the function like =qm_stream_last (“MSFT“) or =qm-stream_last(B2) where cell B2 is the one that contains the stock symbol. As soon as you do that, the stock prices will start showing in your Excel cell.
What is the formula for real time stock price in Excel? ›
A second solution that Excel supports is based on the built-in formula =WEBSERVICE(“some-url-here”). As an example, you may enter the following formula in any cell to get the real time share price of the Google stock from IEX: =WEBSERVICE(“https://api.iextrading.com/1.0/stock/GOOG/quote/latestPrice”).
How do you find realtime stock prices? ›
There are several companies (including Market Data) that can supply live market data for stocks for US markets:
- Market Data API.
- Intrinio.
- Market Stack.
- Finnhub.
- Alphavantage.
- Polygon.
- Tiingo.
- IEX Cloud.
To insert a stock price into Excel, first convert text into the Stocks data type. Then you can use another column to extract certain details relative to that data type, like the stock price, change in price, and so on.
How do you calculate real stock price? ›
The most common way to value a stock is to compute the company's price-to-earnings (P/E) ratio. The P/E ratio equals the company's stock price divided by its most recently reported earnings per share (EPS).
How do I get real time stock data in Excel NSE? ›
Under the Data tab in Excel, select From Web and select Advanced. Enter the URL of the NSE website from where you want to parse the data (copy the Request URL from the Headers section in the Diagnostic pane). Paste the values for accept-encoding, accept-language, and user-agent under HTTP request header parameters.
Is there an algorithm for stock prices? ›
In particular, the LSTM algorithm (Long Short- Term Memory) confirms the stability and efficiency in short-term stock price forecasting.
Is stock price real time data? ›
Real-time market data refers to the immediate and up-to-the-second information about the current state of financial markets, including stock prices, currency exchange rates, commodity prices, and other relevant data.
What is real time data in stock market? ›
Real time refers to information that is relayed at the time it happens, or with only a short delay. In financial markets, real time is a reference to the price of a security and the accuracy of the pricing is crucial to market participants.
Can you get historical stock prices in Excel? ›
The STOCKHISTORY function retrieves historical data about a financial instrument and loads it as an array, which will spill if it's the final result of a formula. This means that Excel will dynamically create the appropriate sized array range when you press ENTER.
The Stock Connector add-in lets you link US stocks, market indexes, mutual funds, international stocks, currencies, crypto, precious metals futures, or ETFs to cells in the spreadsheet and updates them automatically.
How do I find a stock price on a certain date and time? ›
Begin by doing a search using the company ticker symbol. Then choose "Historical Prices" from the blue bar on the left. Choose start and end date. Choose whether you need daily, weekly, or monthly data.
Does fidelity provide real-time quotes? ›
Fidelity offers Real-Time Quotes to help you stay on top of the markets and your investments. Sign up today and you'll be on your way to getting fast and accurate quotes to help you trade more efficiently.
Where can I get historical daily stock prices? ›
Internet Sources for Historical Market & Stock Data
- Yahoo! Finance - Historical Prices. ...
- Dow Jones Industrial Averages. Historical and current performance data. ...
- S&P Indices. Historical performance data.
- IPL Newspaper Collection. ...
- Securities Industry and Financial Markets Association. ...
- FINRA: Market Data Center.
Free Users: TradingView offers near-real-time data for select markets. However, some exchanges may have a delay, usually up to 15 minutes. Paid Users: A paid subscription is necessary to access real-time data across all markets. Plans like Pro, Pro+, and Premium provide this feature.
