Sep 24 2017 10:59 PM
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
------------------------------------------------------
Mar 26 2021 08:14 AM
Mar 26 2021 08:25 AM
Thank you. I will try it.
Apr 19 2021 02:07 AM