Solved

MSFT changed MSN Money website

Posted on 2015-01-30
10
74 Views
Last Modified: 2015-03-17
For years, I tracked my stocks using Excel.  The external web queries would get the stock data from MSN Money and populate the fields for high, low, dividends, open, close, etc.  A few months ago, MSFT changed their website and ruined all of my external queries.  I contacted MSFT and they said, "sorry."  Anybody have any thoughts how I can get this data imported automatically into a spreadsheet?  Most of the websites are full of crap and commercials which makes it difficult for an Excel web query to work on a list of 120 stocks.
Thanks!
0
Comment
Question by:LEECHIPTURNER
10 Comments
 
LVL 29

Expert Comment

by:gowflow
ID: 40584326
Can you post a sample of the web data and the address http ?
gowflow
0
 

Author Comment

by:LEECHIPTURNER
ID: 40584698
Thanks for the reply.  Here is the spreadsheet with all the embedded queries.
STOCK-TRACKING-SPREADSHEET.xlsx
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40585759
0
The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

 

Author Comment

by:LEECHIPTURNER
ID: 40586853
Thanks again.  Here is the result.  Lots of errors, and some areas (like last price) do not have selectable arrows.  I am beginning to think MSFT has hosed me again....
errors.pdf
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40586931
I did it for you in this file in cell A1

I don't know about the outcome of data this you are more expert than me in this.
gowflow
Market1.xlsx
0
 

Author Comment

by:LEECHIPTURNER
ID: 40594379
I appreciate the help, but that didn't seem to do it.
Thanks for the effort!
0
 
LVL 40

Assisted Solution

by:Vadim Rapp
Vadim Rapp earned 250 total points
ID: 40614167
If you have Office 2013, you can use function WEBSERVICE with some free public service like http://www.webservicex.net/stockquote.asmx

For earlier Office, there are other solutions, let us know if that's the case.
0
 
LVL 29

Accepted Solution

by:
gowflow earned 250 total points
ID: 40614205
Did you find any solution or still looking for one ? I have receive an alert that this question may still be un-attended.

I have develop a solution separately but don't know if this could be of any help to you, but it does not harm to lay it here.

In the attach file you put in Column A the Stocks that you wish to get info for and in Column B and C start date and End Date this could be 1 day or 1 month or as much as you want and once you hit the Get Data button it will check on a site and get you for the time frame Open/Close High and Low. You may add all the stocks that you want.

Pls try it and will be interested to get your feedback on it.

gowflow
StockMarket-V02.xls
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 40670002
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
There’s a good reason for why it’s called a homepage – it closely resembles that of a physical house and the only real difference is that it’s online. Your website’s homepage is where people come to visit you. It’s the family room of your website wh…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question