I would like to import the price of silver in EUR/kg.
I have already downloaded the historical prices by CSV.
I would like to update the price on a daily basis.
I have the following webpage which has the silver price in EUR/kg:
On the above webpage I have the following table:
Can someone explain how I can scrape the price highlighted above on a daily basis? Is it possible to automate?
Use the json-provider:
https://chart-data.bullionvault.com/prices/prices.json?&version=v2&chartType=CHART_POINTS&securityId=AGX&interval=3600&batch=Full&valuationSecurityId=EUR
$.seriesData.prices[*].priceTime
$.seriesData.prices[*].latestPrice
https://chart-data.bullionvault.com/prices/prices.json?&version=v2&chartType=CHART_POINTS&securityId=AGX&interval=3600&batch=Full&valuationSecurityId=EUR
$.latestPrice.timestamp
$.latestPrice.price
EDIT: at the end of the URLs is =EUR. This is changeable to CAD, USD or GBP.
Wow! Thank you!
So now the live prices will update everyday?
How do you know to use this link in the JSON url:
https://chart-data.bullionvault.com/prices/prices.json?&version=v2&chartType=CHART_POINTS&securityId=AGX&interval=3600&batch=Full&valuationSecurityId=EUR
If I want to also get Platinum and Gold prices in EUR/kg, do I need to change security ID? What should i change them to?
I hope so.
There are already some explanations here in the forum, for example Cannot find investment funds in search - #30 by ProgFriese
securityId=AUX is gold
securityId=PDX is palladium
Hi @ProgFriese , this is awesome! Regarding the historical prices I would assume that this config would also update historical data from the past. I have configured it and it seems to only pull historical prices from the last 7 days. Is it possible to get all prices from 2017 until now? Cheers
What have you configured and how?
Hi @Rafa , I have configured it like in the screenshots and code posted by @ProgFriese here: Importing securities data for silver - #2 by ProgFriese
