Excel Problem Solver: Import Real Time Stock Quotes Without Office 365
HTML-код
- Опубликовано: 7 мар 2021
- 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.
![Finesse2Tymes - Pretty Ricky [Official Music Video]](http://i.ytimg.com/vi/xIoP_mhYRT0/mqdefault.jpg)
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!
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.
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!! your explanation is so easy to follow :)
you the man!! just the video i needed... thanks
THANK YOU VERY MUCH SIR, YOU SAVED US A LOT OF MONEY !
Great trick! You just gained a sub and a like.
super stuff - really helpful
Thank you so much!!!
Very Good ! Thank's !
thanks a lot bro!
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!!!
Thanks this is great
This is really great, thank you so much for putting it on the web
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.
Can I use this method to input real time stock data in my excel app on my iPad Pro?
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.
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?
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?
All I'm getting are script errors. Doesn't work on 2016.
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?
ruclips.net/video/2bYXvtpSeEg/видео.html
Does anyone know how to do this in Excel 2016?
This is news to me if it doesn't work in Excel 2016.
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?
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.
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.
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?
"I don't want to upload it to the cloud due to privacy concerns" ## streaming to 12 k viewers , :D