I have had the basic Excel program on my computer for a few years. Now, all of a sudden I have the option of getting live stock price updates. Is this a change that was made into Excel? Or did I accidently somehow subscribe to a service that is going to bill me every year?
I believe the answer to this question no.
I dare say the answer could be yes, but it does not have to be.
Google the following:
“get stock quotes in excel”
and you will see how you can instruct Excel to fetch stock prices.
Whether you are fetching from someone who will expect payment is an issue in all probability only you can address.
A short while ago, I somehow ended up hitting the wrong buttons, and updated to windows 11, I’ll see if they somehow snuck in a subscription to the fancier excel product. Hopefully they did not.
I use Excel a lot. Last I had looked there was no way to bring in stock prices short of paying for some sort of service. So this had me excited! I googled, and found instructions, and opened Excel.
And there was nothing there like the instructions. Go here, click on this… nope, nothing like that. Multiple sites, including Microsoft, gave the same instructions.
Back when I bought this computer I had some issues installing my old copy of Excel. Eventually I threw up my hands and subscribed to Microsoft 365, which is one of those keep-paying-each-month situations. I wondered if somehow the Excel I was running was a vestige of those failed installs, so maybe I had to try starting 365 or something? Somehow I did, and got into Excel, but it opened in my browser. Like Google Docs. And there were all the things the instructions said I would see!
So I googled how to install 365 locally, and followed those instructions. And then I got back into Excel, but it was still the old way.
Apparently if I want to use Excel’s built in support for retrieving stock prices I have to do it in my browser. #!@*&%
Back in the old TMF, there was an Excel board, I think it got lost in the shuffle, but there were a lot of very savvy, heavy users in there, I used to read it, in case something of interest came along… I think we lost another great resource…
(also an Office 365 subscriber)
Apparently you can get the stock prices with the right setup:
Its only in the 365 version:
Great to see the Huskies back on top!!!
Here is a link. I’m wondering if I’m using a “practice worksheet.” I might be hanging out in Queens for awhile this spring, if you want to bop over and have a drink. We were able to tie in with Ira and his better half one night in October, it was neat to meet them both. There is a neat little jazz club in the area, Club Ornithology.
A good article, but when I use the local copy this is not there:
Which is game over.
This was a tough year for the UConn women, but it was good to see the men back on top. I never followed basketball until my wife started watching the UConn women maybe 15 years ago. I still follow them, and watch a bit of WNBA in season.
Thanks for the invite, but I guess I’ve got to pass. Queens (or Brooklyn) is a bit of a haul - a couple of hours - from here. I grew up on LI, but escaped in '76, and all my family is long gone. I think it has been a couple of decades since I’ve gone anywhere that way other than Kennedy airport, and that not often or recently.
We have 3 Mac and my desktop was the only one without the Stocks function. I found the link below and solved my problem. Before you start, a few pointers.
=== This only works for the subscription version of Office according to multiple google found sources.
===I worked through the process completely and it did not work for me.
===At that point, I looked at the last part of the process – Turning on optional connected experiences. Mine was turned on, but just of grins, I turned it off and rebooted Excel, turned it on and rebooted again at that point I had Stock data types. Maybe it was not needed, but I did sign out. The only way I could find was to download and use the SignOut License tool.
Mine was there and ready to roll… No further actions needed other than selecting the ticker, then what information I wanted… I see a new project, maybe go look into the old portfolio…
Prior to catching up to the latest 365 version, I doubt it was available…
My Excel student edition help takes you to the STOCKHISTORY function, which is very powerful, but only available on Office 365 Personal, Family, Business Standard, or Business Premium.
I’ve been told the free spreadsheet from Google has a stock read function.
Or, you can use Google Sheets and the =GOOGLEFINANCE(A3) function to get real time stock price updates for free.
Then download a copy periodically to Excel (or, god forbid, Numbers on the Mac) if necessary. No macros will port, obviously, but most of the formulas will.
No files, button clicks, extensions to pay for, complicated O365 logins and subscriptions or legacy VBA code to maintain. Targeted solution just for that purpose.
A couple of hours? That’s nothing for us when home in northern California. We drive 30 minutes just to see the nearest traffic light. You can always jump on Amtrak, also.
You must be enjoying the pleasures of driving in traffic, surrounded by courteous drivers, where traffic lights can be every few blocks, after such simple, boring trips as that.
Just the other day we’re coming back from Sugar Land doing roughly 70-80 mph and this numb-nut on the inside lane decides at the last minute he want to drive across five (5) lanes of traffic to make an exit. This happens frequently.
I am using the Google Sheets function to follow stock results. Especially 90 day gains. I find i can copy results into Excel using the value option in Paste.