Solved

MSFT changed MSN Money website

Posted on 2015-01-30
10
78 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
10 Comments
 
LVL 30

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 30

Expert Comment

by:gowflow
ID: 40585759
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 30

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 30

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 48

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

Raise the IQ of Your IT Alerts

From IT major incidents to manufacturing line slowdowns, every business process generates insights that need to reach the people required to take action. You need a platform that integrates with your business tools to create fully enabled DevOps toolchains.

You need xMatters.

Question has a verified solution.

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

Although a lot of people devote their energy toward marketing for specific industries, there are some basic principles that can be applied to any sector imaginable. We’ll look at four steps to take and examine how those steps were put into action fo…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Learn how to set-up PayPal payment integration in your Wufoo form. Allow your users to remit payment through PayPal upon completion of your online form. This is helpful for collecting membership payments, customer payments, donations, and more.
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

718 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