Schultz,

-Put this code into a module ( making sure nothing is red after you
paste it! )
-Type your Ticker into Cell A1
-Type "=GetQuote(A1)" into Cell B1
-You should have your quote in B1

Code:
=======================================================
Option Explicit
Public Const URL As String = "http://finance.yahoo.com/q?s="
Function GetQuote(sTicker As String) As String
'=======================================================
'Fuction written by:  David Miller
'Returns a !Yahoo Finanace quote
'=======================================================
Dim ie As Object
Dim sHTML As String

On Error GoTo GetQuote_Err
Application.ScreenUpdating = False

Set ie = CreateObject("InternetExplorer.Application")

If IsNull(sTicker) Then GoTo GetQuote_Err

With ie
   .Visible = False
   .navigate (URL & sTicker)
   Do Until .readystate = 4
       DoEvents
   Loop
   sHTML = .document.body.innerHTML
   GetQuote = Mid(sHTML, InStr(sHTML, "yfs_l10_" & LCase(sTicker)) +
Len("yfs_l10_" & sTicker & Chr(34) & ">") - 1, 8)
   If InStr(GetQuote, "<") > 0 Then
       GetQuote = Left(GetQuote, InStr(GetQuote, "<") - 1)
   End If
End With

GetQuote_Exit:
   Set ie = Nothing
GetQuote_Err:
   GetQuote = Null
   Resume GetQuote_Exit
End Function

David Miller

Schultz wote:

If you don't use the correct symbol, you won't obtain valid information. You
need to learn how to use the symbol lookup feature of moneycentral.msn.com.

It's not unusual for data providers to have somewhat arcane symbology to
represent indices.

I found the following symbols as variations of your IWD and EWW.  Hopefully one
of them will "fit".

$IWD.EU    iSHARES RUSSELL 1000 VALUE(Estimated Cash Amount Per Creation Unit)
$IWD.NV    iSHARES RUSSELL 1000 VALUE(Net Asset Value)
$IWD.SO    iSHARES RUSSELL 1000 VALUE(Shares Outstanding)
$IWD.TC    iSHARES RUSSELL 1000 VALUE(Total Cash Amount Per Creation Unit)
$IWD.IV    iSHARES RUSSELL 1000 VALUE(Underlying Trading Value)

and for the Mexico Index:

$EWW.EU    iSHARES MSCI MEXICO INDEX FD(Estimated cash amount per creation unit)
$EWW.IV    iSHARES MSCI MEXICO INDEX FD(Indicative Optimized Portfolio Value)
$EWW.NV    iSHARES MSCI MEXICO INDEX FD(Net Asset Value)
$EWW.SO    iSHARES MSCI MEXICO INDEX FD(Shares Outstanding)
$EWW.TC    iSHARES MSCI MEXICO INDEX FD(Total Cash Amount Per Creation Unit)

--ron