Importing data from web (java/css)

Iron Contributor

Hello, i have one concern, i want to get data from this website Lebanese Lira Today | Dollar to LBP in Black Market | USD to LBP (lirarate.org), particularly i want the excel file from the graph.  is there a way to put the link of this graph so that power query will update by simply a refresh , now i need everytime to download the csv/excel file from the button in the graph, i want it to be automatic, but unable to find the link to this file 

 

Any suggestions?

usd-lbp.png

1 Reply
I would suggest you to get the data from other sources

https://www.investing.com/currencies/usd-lbp-historical-data
https://tradingeconomics.com/lebanon/currency

There you can get an API where you can connect to Excel via Power Query and download the data.