2 ms·

I've been using the GOOGLEFINANCE function in Google Sheets for this. It works pretty well, but there are some institutional funds in my 401k without tickers, e

I've been using the GOOGLEFINANCE function in Google Sheets for this. It works pretty well, but there are some institutional funds in my 401k without tickers, e.g. "Vanguard Institutional 500 Index Trust". Has anyone seen an API that can deal with funds like that?

anonuser123456 8y ago
For funds that track a well known index (like VFFSX), use a well known fund that tracks the same index (SPDR) and normalize the results. There will be some tracking error, but it should be small enough to not bother correcting.