Import and Link Web Data and Information in Excel

[MrDumbace]

Awesome, but got a question. how might I go about having a "CELL" where I input the Ticker, such as MSFT or GOOG and then have the spreadsheet search financial.yahoo.com for the table.... much like what you did, but put the ticker inside excel, and auto extract the exact same tables you posted in this video.

[sammitjain]

Thanks man :)

[hotdragon11]

This tutorial has been very helpful to me.... Thanks guys

[MrSUPERUSER]

Cool, almost exactly what I was looking for. Only I just wanted to import one particular figure, not a whole table.

I'll figure it out, cheers.

[outcoolin]

@MrSUPERUSER did you ever figure out how to import one particular line out of a set of data

[daand87]

@outcoolin I need that too. How to import a line of data based on the position it has on a particular website. If you've found it pls share

[PrincessWithSkills]

Learn how to automatically refresh stock quotes in your Excel spreadsheets.