Help w/Mutual Fund Information

[REattempt]

Hi,

I'm hoping someone knows where to get this...

I want to be able to type in a list of funds and get a listing like this:

ARTIX,VFINX | Stock Prices | Quote Comparison | YAHOO! Finance

BUT, I also want the fund Expense ratio on the table in addition to the price, yield...

It needs to be in one table together. I know I can collect it, but I want to automate!

Thoughts?

 

[Midpack]

This might work if you want the results in Excel, I've used it successfully. The Wizard makes it easy peasy(er). However, the tables it draws from have to be reasonably consistent format. If the source keeps changing names, columns, etc., the query gets "confused." Hope it helps...

About using Microsoft Query to retrieve external data - Excel - Office.com

 

[REattempt]

Thanks...I got that half of the equation, now I'm looking for the source of the data.

I don't want to build a query for each of the stocks, I'd like to build one to get yield, price and Exp. Ratio...

 

[Midpack]

Oh. I don't use my XLS file anymore because I'm all VG. When I did, I was querying from Fidelity or Morningstar, can't remember for sure...sorry.

 

[Animorph]

Creating a portfolio at Morningstar.com should allow you to create a customized view. They do have ER available as one of the columns.