Posted by
Message
thunderbird1100
LSU Fan
GSU Eagles fan
Member since Oct 2007
60221 posts

Anyone use excel to track stock prices?
The one where under the data tab under data types you use the "Stocks" button to put a ticker symbol in then can track all sorts of various things like the stock price. You "refresh" it to get the newest price possible (usually only lags a little bit behind).

As of this morning my prices arent updating at all upon clicking refresh, they have a "Last Trade Time" field which I selected and all are defaulting to 11:59/midnight yesterday...searched google for this issue and found this thread:
LINK

Seems back in 2018 the feature was down and not working for a few days.

Anyone having similar issues with this in the AM today?


Bestbank Tiger
Tulane Fan
RTWFU
Member since Jan 2005
53201 posts

re: Anyone use excel to track stock prices?
I need one to automatically import stock prices into Open Office.

I have a spreadsheet that runs calculations off of that.


Replies (0)
Replies (0)
00
Weagle25
Auburn Fan
THE Football State.
Member since Oct 2011
38827 posts

re: Anyone use excel to track stock prices?
You ever find a solution? Don’t think it’s updating on mine either


thunderbird1100
LSU Fan
GSU Eagles fan
Member since Oct 2007
60221 posts

re: Anyone use excel to track stock prices?
quote:

You ever find a solution? Don’t think it’s updating on mine either



Posted a thread on Microsoft community forums this morning, still not updating.

I think it has to be a microsoft issue, a link is broken or an update or something screwed it up. In the OP I found a thread from 2 years ago where the conclusion was the feature just went down for a few days basically but fixed itself.


Replies (0)
Replies (0)
00
TD SponsorTD Fan
USA
Member since 2001
Thank you for supporting our sponsors
Advertisement
thunderbird1100
LSU Fan
GSU Eagles fan
Member since Oct 2007
60221 posts

re: Anyone use excel to track stock prices?
Yeah it's just down, I got redirected to this thread upon my question:
LINK


hubertcumberdale
LSU Fan
Member since Nov 2009
2368 posts

re: Anyone use excel to track stock prices?
Not sure if this much different than what you are talking about, but they recently came out with a new formula to show historical prices

Microsoft announces new Excel function that lets you visualize stock history

quote:

Microsoft has announced a new function for Excel, which is designed to help users visualize the historical data data for a company over time. Called STOCKHISTORY, the new function leverages the Stocks data type, and the dynamic arrays feature that was added recently to grab stock values for different dates and list them all.

For those unfamiliar, dynamic arrays made it possible for a function to be introduced in a single cell but spill out data in multiple cells. This capability launched with functions such as SORT, FILTER, and more, but now STOCKHISTORY is also making use of it to display historical stock data.




Replies (0)
Replies (0)
10
Weagle25
Auburn Fan
THE Football State.
Member since Oct 2011
38827 posts

re: Anyone use excel to track stock prices?
Seems to be fixed


thunderbird1100
LSU Fan
GSU Eagles fan
Member since Oct 2007
60221 posts

re: Anyone use excel to track stock prices?
quote:

Seems to be fixed



Can confirm this morning I tried again and it updated to close of yesterday so looks good. Man, not something that should be going down for multiple days at a time.

Literally track my entire fun robinhood portfolio in excel because it makes decision making much easier than trying to follow it all in robinhood.


Replies (0)
Replies (0)
00
first pageprev pagePage 1 of 1next pagelast page
refresh

Back to top

logoFollow TigerDroppings for LSU Football News
Follow us on Twitter, Facebook and Instagram to get the latest updates on LSU Football and Recruiting.

FacebookTwitterInstagram