Forum Discussion
importing MSN stock prices into excel 2010
I have been trying to import stock values from MSN (http://www.msn.com/en-us/money/watchlist) into excel 2010 using power query. When I open the link in a browser all is fine, however I can't link the data to my excel file.
I have tried changing the ify file to the following, but it also didn't solve the problem.
Can anyone help me?
-------------------------------------------
WEB
1
http://www.msn.com/en-us/money/quoteslookup?SYMBOL=["QUOTE","Enter stock, fund or other MSN MoneyCentral Investor symbols separated by commas."]
Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
------------------------------------------------------
4 Replies
- Hello. I'll suggest using iXBRLAnalyst rather than going through the hard process. They provide historical data dating from 2009 in excel. It also works in any device. Let me know if this is helpful
Thank you. I will try it.
- You're welcome
