I have a free open-source add-in I wrote to get financial data off the
Internet. I originally wrote the add-in because of my frustrations
with web  queries in EXCEL.

For example, if I wanted to get the "Market Capitalization" of "IBM"
from the Yahoo Key Statistics page, I would use this function and
parameters from the add-in:

=RCHGetElementNumber("IBM", 941)

The first parameter passes the ticker symbol (which could be a cell
reference) and the second parameter is just an assigned element number
for that particular data element (which could also be passed as a cell
reference). That function has nearly 15000 available elements
preprogrammed. However, there are general usage functions that allow
you to retrieve web page source data, extract HTML tables, even
individual cells from and HTML table.