Forum Discussion

nicol320's avatar
nicol320
Copper Contributor
Aug 22, 2020

scraping data from finviz

hello, i am currently having hard time pulling specific data on the finviz.com table utilizing Data>get data From Web>URL Link"https://elite.finviz.com/quote.ashx?t=expe&ty=c&ta=1&p=d" then click o...
ExcelExciting's avatar
ExcelExciting
MVP
Aug 23, 2020

Hi nicol320,

 

Please note that when you click refresh Power Query will refresh the and get you the latest update. Your challenge here is to source should not get update. Well understanding your query I can propose you two solution. 

  1. Once your data is loaded into Excel delete the connection to you table 
  2. Copy & paste the data to new worksheet as values only, You can configure a macro to do that activity once the data is refreshed.

 Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more

Resources