The data comes in HTML but this looks like a pretty clean and
self-explanatory interface for Vanguard US:
https://personal.vanguard.com/us/funds/tools/pricehistorysearch
On Sat, 9 Oct 2021 at 17:55, Aaron Stacy <[email protected]> wrote:
> And of course feel free to share if anyone has ideas for getting stuff
> like this from a proper API 🙂
>
> On Sat, Oct 9, 2021 at 10:54 AM Aaron Stacy <[email protected]>
> wrote:
>
>> ...and I can answer my own question, but I'll post it here in case it
>> saves anyone else some time:
>>
>> The JSON API that now works came from inspecting this page
>> <https://institutional.vanguard.com/investments/product-details/fund/1470>,
>> and searching through the XHRs for the NAV price listed. This came up (no
>> headers seem to be needed):
>>
>>
>> https://eds.ecs.gisp.c1.vanguard.com/eds-eip-distributions-service/price/daily-nav-history/7743.json?start-date=2021-10-08&end-date=2021-10-09
>>
>> Where "7743" is the FIID (fund ID? IDK), and while I don't remember where
>> I originally got 7743, I think it was in the malformed OFX export XML from
>> logging into my Vanguard portal.
>>
>> On Sat, Oct 9, 2021 at 10:53 AM Aaron Stacy <[email protected]>
>> wrote:
>>
>>> I've got a script that fetches prices for Vanguard frunds from one of
>>> the APIs I found their website was making XHR's to. It looks something like
>>> (tho I also needed the "Referer: https://vanguard.com"; header:
>>>
>>>
>>> https://api.vanguard.com/rs/cfv/global/eip-distributions-service-webservice-production-current/rs/price/daily-nav-history/0928.json?start-date=2021-09-30&end-date=2021-10-01
>>>
>>> This has worked for most of a year, up til last month, not only for
>>> ETFs, but also Vanguard funds like their target retirement funds, and even
>>> the target retirement trust fund my company uses for the 401k, but now I'm
>>> getting 404s.
>>>
>>> I've found this will give me JSON of today's price (but not historical):
>>>
>>>
>>> https://invproductsui.vanguard.com/content/site-services/market-data/0928
>>>
>>> And this will give me HTML of historical prices, but not for the Target
>>> Retirement 2050 Trust fund my company uses for their 401k:
>>>
>>>
>>> https://personal.vanguard.com/us/funds/tools/pricehistorysearch?radio=1&results=get&FundType=ExchangeTradedShares&FundIntExt=INT&FundId=0928&fundName=0928&radiobutton2=1&beginDate=01/01/2020&endDate=01/02/2020&year=
>>>
>>> Does anyone know of APIs to fetch NAV prices for these funds by date?
>>>
>> --
>
> ---
> You received this message because you are subscribed to the Google Groups
> "Ledger" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/ledger-cli/CACjABk%3DYC29kxrLsM4n3qm%3DP-oZ0RSZxBEsrWLN4tEvGycpQkg%40mail.gmail.com
> <https://groups.google.com/d/msgid/ledger-cli/CACjABk%3DYC29kxrLsM4n3qm%3DP-oZ0RSZxBEsrWLN4tEvGycpQkg%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
>
--
---
You received this message because you are subscribed to the Google Groups
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/ledger-cli/CAPekLyEv%3DGPCYMRE3A3btbKbhdP1%3DiB0ZKH-60XdXOG447zBJw%40mail.gmail.com.
