- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Anyone use excel to track stock prices?
Posted on 9/16/20 at 9:54 am
Posted on 9/16/20 at 9:54 am
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?
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?
4
Posted on 9/16/20 at 11:30 am to thunderbird1100
I need one to automatically import stock prices into Open Office.
I have a spreadsheet that runs calculations off of that.
I have a spreadsheet that runs calculations off of that.
Posted on 9/17/20 at 8:42 am to thunderbird1100
You ever find a solution? Don’t think it’s updating on mine either
Posted on 9/17/20 at 8:51 am to Weagle25
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.
Posted on 9/17/20 at 9:49 am to thunderbird1100
Yeah it's just down, I got redirected to this thread upon my question:
LINK
LINK
Posted on 9/17/20 at 9:55 am to thunderbird1100
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
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.
Posted on 9/17/20 at 9:20 pm to thunderbird1100
Seems to be fixed
Posted on 9/18/20 at 7:28 am to Weagle25
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.
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News