How do you pull yields form Vanguard's site?

76 views
Skip to first unread message

userguymobile

unread,
Apr 9, 2018, 10:58:53 AM4/9/18
to Google Finance
Example, I can't load the money market rate here doesn't work with... 


I get the error "*Warning: Vanguard.com will not work properly with JavaScript disabled!*

And  GoogleFinance("VMFXX", "price") is way, way out of date.

Richard

unread,
Apr 9, 2018, 8:00:17 PM4/9/18
to google-...@googlegroups.com
You can pull from any site using a bit of HTML magic. Here's a sample that I use to get one quote:

=IFERROR(MAX(ImportXML("http://quotes.wsj.com/GMWSB", "//span[@id='quote_val']"),10),20)

--
You received this message because you are subscribed to the Google Groups "Google Finance" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-finance+unsubscribe@googlegroups.com.
To post to this group, send email to google-finance@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-finance/fa6345f3-2e05-4d94-bc70-19df20d5d894%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply all
Reply to author
Forward
0 new messages