I would like to extract the time series from a XML link provided by the ECB. Unfortunately, I am not able to extract the data time series. May someone be able to help me please?
I start to import the data by
eurusd=Import["https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange _rates/html/usd.xml", "XML"]
Now I would like to build a time series using the
OBS_VALUE out of the
XMLElement. Hence I try to extract them by using the command
series=eurusd[[All,"OBS_VALUE"]]. Unfortunately this does not work. Can someone please tell me how I can extract the time series out of the XML data link?
Thank you in advance!
Best regards Alex