Importing data from web (java/css)

%3CLINGO-SUB%20id%3D%22lingo-sub-2720151%22%20slang%3D%22en-US%22%3EImporting%20data%20from%20web%20(java%2Fcss)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2720151%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20i%20have%20one%20concern%2C%20i%20want%20to%20get%20data%20from%20this%20website%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Flirarate.org%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3ELebanese%20Lira%20Today%20%7C%20Dollar%20to%20LBP%20in%20Black%20Market%20%7C%20USD%20to%20LBP%20(lirarate.org)%3C%2FA%3E%2C%20particularly%20i%20want%20the%20excel%20file%20from%20the%20graph.%26nbsp%3B%20is%20there%20a%20way%20to%20put%20the%20link%20of%20this%20graph%20so%20that%20power%20query%20will%20update%20by%20simply%20a%20refresh%20%2C%20now%20i%20need%20everytime%20to%20download%20the%20csv%2Fexcel%20file%20from%20the%20button%20in%20the%20graph%2C%20i%20want%20it%20to%20be%20automatic%2C%20but%20unable%20to%20find%20the%20link%20to%20this%20file%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22usd-lbp.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308143iFA2B9C9306FDE56C%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22usd-lbp.png%22%20alt%3D%22usd-lbp.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2720151%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2720310%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20data%20from%20web%20(java%2Fcss)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2720310%22%20slang%3D%22en-US%22%3EI%20would%20suggest%20you%20to%20get%20the%20data%20from%20other%20sources%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.investing.com%2Fcurrencies%2Fusd-lbp-historical-data%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.investing.com%2Fcurrencies%2Fusd-lbp-historical-data%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftradingeconomics.com%2Flebanon%2Fcurrency%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftradingeconomics.com%2Flebanon%2Fcurrency%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThere%20you%20can%20get%20an%20API%20where%20you%20can%20connect%20to%20Excel%20via%20Power%20Query%20and%20download%20the%20data.%3C%2FLINGO-BODY%3E
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.