I would like to get mutual fund Yahoo data (qtr. returns) and and other fund data (like alpha,beta) from their financial site via web query. I have a list of funds which I have put into column A. I would be satisfied if excel would pull all data from these funds (I can take it from their), but I would like it to put all the data in one row instead of sparsing it across the page. I have played with web queries and I can't get it right. Here is what I would like to see For example :
A_________B (2007 1st qtr)______C (2006 1st qtr)
LSBRX => (web query)__________5.00__________8.32
GTDDX => _________________5.00__________8.32
FUND C =>
FUND D =>
Bookmarks