Excel Problem Solver: Import Real Time Stock Quotes Without Office 365
Вставка
- Опубліковано 13 жов 2024
- This video shows how to set up an Excel worksheet to update with real time stock quotes using both Google Finance data or stock price data sourced from Office 365's Excel free version.
I was disappointed when Office 2021 came out and the non-365 version did not include the feature for downloading quotes directly. But your method works fine and I thank you for sharing this info. You now have a new subscriber.
This is really a fantastic video which explains the steps in importing the stock data into the stand alone MS Office version (non subscription version). Thanks a lot for the video. Really useful and your efforts are well appreciated.
Wonderful video! After getting the Google data instructions I skipped the MS Outlook bit and got the refresh settings instructions. All worked perfectly. Thank you!
Thank you - This is the best solution I have found to get real-time quotes into Excel 2021 without paying for Office 365 - it works perfectly. I import them as a separate sheet in excel and just refer to them where I need them. also makes it easier to add new symbols. I would have never found the update frequency time setting without your video also!
Awesome. Exactly what I'm looking for
Thank you for the great video. It was very clear and works like a charm. I'm using Excel 2021.
Question: Stock values from Google Sheets comes in as a table. A table within any workbook prevents Custom Views from working (Its greyed out). Is there a way to import stock data, but not as a table, so that the custom views can be used?
Thank you!! your explanation is so easy to follow :)
thank you for this very clear video . i had a problem to get the info into an excel 2013 sheet. i got all kind of errors and gave up. BUT went to another computer where i have excel 2019 and there it worked like a charm. i now have also everything in 1 sheet. after i did the import i did an edit of the query. i selected first row as headers (because i have a header row in googlesheets) and also selected specific colums. so i get the following columns from my google sheet: ticker name currency price 52w-low 52w-high. so the first 6 columns come from google sheet and i can freely use column 7 and further. these are now not effected by the data refresh.
although i managed to get everything working in 1 sheet, i prefer the 2 sheet approach. in that way the query stays simple and all from google sheet is imported in sheet1 and in sheet2 i have my holdings ticker symbol # of shares etc. price info i then get with the excel vlookup function so that ticker symbol in sheet2 is matched with the ticker symbol in sheet1 and i get the correct price info.
you the man!! just the video i needed... thanks
Great trick! You just gained a sub and a like.
THANK YOU VERY MUCH SIR, YOU SAVED US A LOT OF MONEY !
This is really great, thank you so much for putting it on the web
thanks a lot bro!
i done with the auto share price updated in google sheet, but once i public to web and try to get data from web (excel 2021) load the data, all the inform are appear except for my share price (it show "loading..."), wondering where is go wrong, any tips?
I'm using Office Pro Plus 2016 and when I get to 3:57, and go to the "Data" ribbon, there's no "Get Data from the Web" button [and I couldn't find it in the menu to add it to the ribbon].
Is there a workaround or do I need to update Excel?
Does this video help?
ua-cam.com/video/2bYXvtpSeEg/v-deo.html
All I'm getting are script errors. Doesn't work on 2016.
Can I use this method to input real time stock data in my excel app on my iPad Pro?
PUT YOUR IPAD PRO ON YOUR ASS
Very Good ! Thank's !
super stuff - really helpful
BUT does the =googlefinance code just pull it in or does it then update as the stock grows/drops? Or do you need to manually update this info yourself every time?
You can update at any time of your choosing. Otherwise it will update periodically. You can also adjust the update settings as discussed at the end of the video.
Great method, however I run into a problem when I want to 'publish to the web', the .xlsx option is greyed out. Any thoughts would be much appreciated. Cheers
Are you by chance using a version of Excel that predates Excel 2007? Only Excel 2007 and newer versions can read .xlsx files.
@@spreadsheetgeek4070 it’s the 2019 version on Mac. Maybe that’s the problem?
Thanks this is great
this is very good, you can do this free via Microsoft
select the ticker as stock or currency under "data", then it will convert into the symbol, from there, you right-click, a table of contents will appear and select price, or, type "=A2.price" (A2 is an example of the cell)
it does not auto-refresh, but manually "refresh all" - this should be free also
Are you using Office 365? This video was created for Excel 2019 and earlier versions of Excel
So what is the answer?
Thank you!!!
Thank you so much!!!
how do you get it off the web after you publish it there?
Just goto OneDrive or Google Drive and delete the file you created.
So the Office version does not work without 365 subscription nowadays?
Was anyone able to do it in Office free version?
This worked. However, I cannot make the main sheet work directly on the OneDrive. Any ideas?
Does anyone know how to do this in Excel 2016?
This is news to me if it doesn't work in Excel 2016.
"I don't want to upload it to the cloud due to privacy concerns" ## streaming to 12 k viewers , :D
Does anyone knows how to do this in Excel 2019?
Excel 2019 is what I used in the video. As a stand alone, Excel 2019 cannot pull in quotes at this time. As far as I know you will have to get the data from google finance or Microsoft...perhaps other sources.