Hi all, and thanks to the Dev for what looks like a brilliant bit of software. Unfortunately I am stuck already…
I can’t find common stocks to apply to my spreadsheet. These include the likes of SWDA, EMIM, VMIG - big ETFs. I must be doing something wrong but can anyone help please?
I ment, I havent found it in portfolio performance, but I learned how to upload the table later on my own… Tutorial would be good how to do that for other people
but when I try to get the data there is an error >>503 service unavailable and I don’t have an idea how to overcome this? any suggestions are welcomed. Thanks.
The HyperText Transfer Protocol (HTTP) 503 Service Unavailable server error response code indicates that the server is not ready to handle the request.
Common causes are a server that is down for maintenance or that is overloaded. This response should be used for temporary conditions
Thanks for your answers, after having your screenshots, I tried a lot without luck, after I thought maybe something is wrong with my IP (from Turkey) and connected the same through a VPN (Italy), it is weird that investing.com has some browser/IP controls, but it seems the issue is because of the IP.
Thank you ProgFriese,
those are indeed the values that I would expect to see Historical values would actually be enough for me, since I rarely check prices more than once a day anyway.
I am unclear how to use this link that you’ve sent tho. I made an empty instrument and chose the JSON option under the Historical Quotes tab, then pasted the link you sent into the Feed URL.
This is the right way In addition, you have to specify the correct values for parsing the quote and date fields.
Path to date
$.jsonGraph.fundDetailByUrl[*].priceHistory.value.histories[0].fundPrices[*].asOfDate
Path to close
$.jsonGraph.fundDetailByUrl[*].priceHistory.value.histories[0].fundPrices[*].price
And the last Problem ist the URL (see above) itself
because there is the enddate included. This means that today everything ist fine, but if you look at this fund in PP some weeks in the future, the last quote you will see is from 2023-2-6.
So you have to change the URL
Genius! It works! Thank you very much for your help
I have been struggling with this for a while now, so its great to finally be able to include this fund in my portfolio.
Is there a tutorial about how to do this somewhere?
I have another fund that I would like to add, but don’t want to take up any more of your time with my nonsense requests. Alternatively, I will have a go at tweaking the JSON url that you sent.
Its almost home time here in Germany, but I am going to give this a go first thing tomorrow. I will try to recreate your JSON url first, then go from there. With a bit of luck I should be able to figure this out.
You have been so generous with your time, thank you! Have a great day
I have finally had the time to get back into this today, so that I can learn how to add my other fund. I thought I would start by recreating what you did last time, but I am stuck already.
I opened the website https://www.vanguard.com.au/institutional/products/en/detail/wholesale/8122/equity and investigated the network traffic in Firefox, but I cant find the JSON response you used: