Excel 2013 Power Query and share price data

Hi

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?

Improve company productivity with a Business Account.Sign Up

x
 
Zack BarresseConnect With a Mentor CEOCommented:
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:

http://finance.yahoo.com/q?s=MSFT

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.

Zack
0
 
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?

Regards,
Zack Barresse
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Hi

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
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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.

Zack
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Hi
Yes if you could suggest a website that is all I am looking for. Thanks
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much. Very helpful!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.