Excel 2013 Power Query and share price data


I am trying to find examples of using Power Query with share price data.

Does anyone have any good articles/links on this or perhaps has actually
used this
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Zack BarresseCEOCommented:
Hi there,

Your question is a little vague. Could you be more specific about what you're trying to do along with the expected results?

Zack Barresse
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:

Power Query allows the user to search the net for information. This includes financial market data. I just wanted to know if it could specifically look for share prices from one of the major markets
Zack BarresseCEOCommented:
I'm familiar with Power Query, but the question is still a little vague. It allows you to do quite a bit more than get data from the web, but that is one portion of it. If you want to get web information, you need to know a website first.

Do you have a specific place in mind, or are you just asking what a good website would be to get share prices? We can't really give you anything as vague as the question is, the answers are too vague as well.

CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Yes if you could suggest a website that is all I am looking for. Thanks
Zack BarresseCEOCommented:
A lot of times people who are serious about getting financial information pay for a subscription to get live data, on request, and up to date. I've used Yahoo Financial before. You just need the company code. For example, this brings you to Microsoft's financial information:


Another example would be Sprint is "S", so you change the "MSFT" above with "S" and you'll get Sprint's information. Add this URL to your Power Query and you'll get a few tables of information.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much. Very helpful!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.