importing MSN stock prices into excel 2010

%3CLINGO-SUB%20id%3D%22lingo-sub-110003%22%20slang%3D%22en-US%22%3Eimporting%20MSN%20stock%20prices%20into%20excel%202010%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-110003%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20been%20trying%20to%20import%20stock%20values%20from%20MSN%20(%3CA%20href%3D%22http%3A%2F%2Fwww.msn.com%2Fen-us%2Fmoney%2Fwatchlist%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.msn.com%2Fen-us%2Fmoney%2Fwatchlist%3C%2FA%3E)%20into%20excel%202010%20using%20power%20query.%20When%20I%20open%20the%20link%20in%20a%20browser%20all%20is%20fine%2C%20however%20I%20can't%20link%20the%20data%20to%20my%20excel%20file.%3C%2FP%3E%3CP%3EI%20have%20tried%20changing%20the%20ify%20file%20to%20the%20following%2C%20but%20it%20also%20didn't%20solve%20the%20problem.%3C%2FP%3E%3CP%3ECan%20anyone%20help%20me%3F%3C%2FP%3E%3CP%3E-------------------------------------------%3C%2FP%3E%3CP%3EWEB%3CBR%20%2F%3E1%3CBR%20%2F%3E%3CA%20href%3D%22http%3A%2F%2Fwww.msn.com%2Fen-us%2Fmoney%2Fquoteslookup%3FSYMBOL%3D%5B%26quot%3BQUOTE%26quot%3B%2C%26quot%3BEnter%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.msn.com%2Fen-us%2Fmoney%2Fquoteslookup%3FSYMBOL%3D%5B%22QUOTE%22%2C%22Enter%3C%2FA%3E%20stock%2C%20fund%20or%20other%20MSN%20MoneyCentral%20Investor%20symbols%20separated%20by%20commas.%22%5D%3C%2FP%3E%3CP%3ESelection%3DEntirePage%3CBR%20%2F%3EFormatting%3DAll%3CBR%20%2F%3EPreFormattedTextToColumns%3DTrue%3CBR%20%2F%3EConsecutiveDelimitersAsOne%3DTrue%3CBR%20%2F%3ESingleBlockTextImport%3DFalse%3C%2FP%3E%3CP%3E------------------------------------------------------%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-110003%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2237908%22%20slang%3D%22en-US%22%3ERe%3A%20importing%20MSN%20stock%20prices%20into%20excel%202010%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2237908%22%20slang%3D%22en-US%22%3EHello.%20I'll%20suggest%20using%20iXBRLAnalyst%20rather%20than%20going%20through%20the%20hard%20process.%20They%20provide%20historical%20data%20dating%20from%202009%20in%20excel.%20It%20also%20works%20in%20any%20device.%20Let%20me%20know%20if%20this%20is%20helpful%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2237934%22%20slang%3D%22en-US%22%3ERe%3A%20importing%20MSN%20stock%20prices%20into%20excel%202010%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2237934%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1005836%22%20target%3D%22_blank%22%3E%40Joshua2495%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%20I%20will%20try%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

@Joshua2495 

Thank you. I will try it.

You're welcome