![]() ![]() To make this work, create a new Google Sheets from the online service (not the downloadable software). 18 different ‘attributes’ for each stock or index – too many to show in a single screen image (they’re listed later in this article). Google’s GoogleFinance() function returns a lot of information about many global stocks and indexes. Once you get the data into a Google Sheet, it can be automatically exported and grabbed by Excel. Google’s version of Excel is Sheets and that has a nifty function that grabs stock prices right into the worksheet. It’s a sad indictment of Microsoft Office that the best place to get stock data is Google. This time we’ll use the improved Query system in recent versions of Excel combined with data from Google Finance. It’s part of a series: introduction and using MSN Money in Excel. Here’s another method of getting stock prices into Excel. Thanks for joining us! You'll get a welcome message in a few moments.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |