Tracking live fund performance - Vanguard

Matt8888

A directly related question - can you bring up a live value in Excel (as you can for stock prices)? Thanks.

Swipe

Matt8888 said:

A directly related question - can you bring up a live value in Excel (as you can for stock prices)? Thanks.

Yes you can if you know the code. For example, this would be the code for FTSE Global All Cap:

=IMPORTDATA("https://api.vanguard.com/rs/gre/gra/1.7.0/datasets/urd-product-details?path=[id=vanguard-ftse-global-all-cap-index-fund-gbp-acc][0].navPrice.value")

AnotherJoe

Roselondon_2 said:

I'm aware Vanguard doesn't provide any App or live tracking feeds. Is there any 3rd party App or means could be used for monitoring without having to login each time? 

(Not for me, but for my partner who wants to have a better idea of the performance trend before moving forward. I did remind him past performance can't represent the future. ) 

Thanks.

As you say, LOL.

First, seeing an up or downtrend in the past absolutely says nothing about what a fund will do.

Best you could use it for is comparative performance against other things you may benchmark it against.

Second, how is looking at day to day performance from now any different to looking at day to day performance of a week or a month ago? Its still all in the past.

Lastly, and key, with Vanguard since AFAIK all their investment vehicles are "passive" you arent really tracking Vanguard you are tracking the underlying indexe(s) it matches.

Apart from minor differences in costs, Vanguard XYZ fund or ETF will be microscopically different to any other fund that tracks the same index. So, he might as well cut out the middleman and look at those indexes and then see if he can determine, from past movements, what they will do in future.

If he is already able to do this, and assuming you arent living on your own tropical paradise island, then he presumably has a few billion squirrelled away somewhere from all his knowledge of stock market future moves so you two dont need to invest any more.

eskbanker

AnotherJoe said:

Lastly, and key, with Vanguard since AFAIK all their investment vehicles are "passive" you arent really tracking Vanguard you are tracking the underlying indexe(s) it matches.

Apart from minor differences in costs, Vanguard XYZ fund or ETF will be microscopically different to any other fund that tracks the same index. So, he might as well cut out the middleman and look at those indexes and then see if he can determine, from past movements, what they will do in future.

While agreeing with the general thrust of your post, it's perhaps worth noting that one of Vanguard's most popular products, LifeStrategy, isn't an index tracker as such, and so would require a non-trivial exercise to map its constituent funds back to underlying indices, i.e. it's a lot easier simply to track VLS than to reverse engineer its performance to that of its components!

gundo

kuratowski said:

If what you actually want is the past trend, look at Trustnet: https://www2.trustnet.com/Tools/Charting.aspx

This is very handy for plotting the different index funds I have on Vanguard against one another to compare them. Thanks for that.

MarkFromCornwall

gobeye said:

You could knock something up quite easily in Google sheets. Depending upon what you are investing in the GOOGLEFINANCE function will allow you to pull in live prices.

I use Googlefinance functions to get share prices, for example =googlefinance("LON:JLEN","price") gets me the share price for JLEN, but how do you use it to get the price of a Vanguard fund, such as one of the LifeStrategy funds?