Solved

MSFT changed MSN Money website

Posted on 2015-01-30
10
70 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
 

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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Envision that you are chipping away at another e-business site with a team of pundit developers and designers. Everything seems, by all accounts, to be going easily.
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

895 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now