Stock Data Not Working

[OldSwimmer1650]

Is anyone having the issue of stock data not updating?
I also noticed they moved the Stock Data type off the DATA tab.
Formulas like =AAPL.Price etc... not updating. I'm getting last Fridays prices.
Is some update going on?

 

[AhoyNC]

It's working for me. I still show Stock Data under the DATA ribbon.

Price in B2 is price today 1/6/25 around 4pm.
Price in B3 is closing price of last Friday 1/3/25.

Book1
	A	B	C
2	APPLE INC. (XNAS:AAPL)	$ 245.00	1/6/2025
3	=STOCKHISTORY("AAPL","1/3/25",,,0,1)	$ 243.36	1/3/2025
Sheet2

Cell Formulas
Range	Formula
B2	B2	=A2.Price
A3	A3	=FORMULATEXT(B3)
B3	B3	=STOCKHISTORY("AAPL","1/3/25",,,0,1)

 

[alansidman]

@AhoyNC
What release are you on? I am on insider release 2501 as of Jan 2, 2025 and it is no longer available. I believe although not entirely positive on this that MS is moving to Copilot to track holdings. Here is what my latest ribbon looks like. StockHistory works for a date range but not current price only.

 

[alansidman]

@OldSwimmer1650

For what it is worth. I have rarely used the DataType Stocks. I use Michael Saunders Addin for tracking. Here is a link to his site.

Stock Connector add-in for Excel

www.michael-saunders.com

 

[OldSwimmer1650]

@AhoyNC
What release are you on? I am on insider release 2501 as of Jan 2, 2025 and it is no longer available. I believe although not entirely positive on this that MS is moving to Copilot to track holdings. Here is what my latest ribbon looks like. StockHistory works for a date range but not current price only.

Yes, I'm on Version 2501
Guess I'll start using an add-in

 

[AhoyNC]

I'm not on the inside release. I very seldom t use the stock data in Excel, I've been using Google finance.

 

[alansidman]

@OldSwimmer1650

Here is a link to what AhoyNC uses

Excel: stock prices from Google Finance

Here's another method of getting stock prices into Excel. It's part of a series: introduction and using MSN Money in Excel. This time we'll use the impr

office-watch.com

 

[OldSwimmer1650]

@OldSwimmer1650

For what it is worth. I have rarely used the DataType Stocks. I use Michael Saunders Addin for tracking. Here is a link to his site.

Stock Connector add-in for Excel

www.michael-saunders.com

I took a look at his add-in. I don't see if you can get the following data: PriceChange, Beta, Extended Hrs price, PriceChange%. Do you know?

 

[AhoyNC]

Here is another link on using GOOGLEFINACE function in Google sheets.

How to use the GOOGLEFINANCE function in Google Sheets - Sheetgo Blog

Learn how to automatically track stock prices and pull real-time securities data into Google Sheets with the GOOGLEFINANCE function.

blog.sheetgo.com

 

[alansidman]

Update to MS office today. 2502 has restored Data Types.