How To Embed Stock Price In Excel. In this tutorial, we’ll use the spy etf. Select all of those symbols.
The formulas will update your total stock value when the stock price is. 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. You probably can tailor the query to get just what you want to see, but i have not tried that yet.