Downloading Historical Price Data for ETF

[Gergely2525]

I'd like to use the daily price data of the Invesco S&P 500 ESG UCITS ETF Acc (IE00BKS7L097), listed on the Frankfurt Stock Exchange, as a web data source in my Power BI project – starting from 2024-01-01 up to the present.

The goal is to make it so that the daily closing prices can be refreshed with a single click, so that my table automatically expands with a new row each day.

I’ve tried using the following links, but unfortunately I couldn’t extract the price data from any of them:

• https://www.boerse-frankfurt.de/en/etf/invesco-s-p-500-scored-screened-ucits-etf-acc/price-history/h...

• https://markets.ft.com/data/etfs/tearsheet/historical?s=5ESG:FRA:EUR

• https://finance.yahoo.com/quote/5ESG.DE/history/

I think the best solution would be to use an API, but I haven’t found one (without a subscription).

Could someone help me out with this?

[Gergely2525]

Thank you for your help. You’ve put an end to a lot of searching! 🙂

[OwenAuger · Accepted solution]

Hi @Gergely2525 

stooq.com may be a good source. I've used it a few times for personal projects.

For that particular ETF, I think this is the relevant page, filtered to 2024-01-01 onwards. Please verify it's the right one though! 🙂

https://stooq.com/q/d/?f=20240101&t=99991231&s=5esg.de&c=0

The link at the bottom of the page downloads a CSV, and can be used as a Web source for Power BI:

https://stooq.com/q/d/l/?s=5esg.de&f=20240101&t=99991231&i=d