Automatically extract website data to a spreadsheet

[Corried]

Hello, Thank you for sharing..

I am looking for courses on how to automatically extract data from a website to an excel spreadsheet.

The excel file contains fifty links. Each link has the same process, to create a stock market report for fifty companies. Use macro and chrome to generate data.

Can anyone show me a step by step process on how I can do this?

Please watch the video and Excel workbook below to learn more.

Example STOCK REPORT CARD

Sheet2 CORRIE STOCK REPORT CARD Websites Top 100,Company,Symbol,P/E,Price,Sales Growth Yr Over Yr,Sales, Revenue, Net Income in B=billion or M=million,52-Week Low & High,5 Year High & Low,Market Cap; # Shares,Debt/Equity Ratio,Net Profit,Company: Insider Trading,Operating Margins,Description,New...

docs.google.com

I hope you all understand.

Cheers

 

[Corried]

Do you know how to do that?

I am sorry worf

 

[Corried]

The code below worked for me today, please try it with BTG.

This is the error code: [d2] = driver.FindElementByXPath("//*[@id=""root""]/div[1]/div/div[5]/div/div/div[2]/div/div[2]/div[2]/div[8]/div[2]").Text

 

[Corried]

The code below worked for me today, please try it with BTG.

Hello Worf. I've taken the time to go through the codes you have sent so far. Nothing! Do think

Hello, Thank you for sharing..

I am looking for courses on how to automatically extract data from a website to an excel spreadsheet.

The excel file contains fifty links. Each link has the same process, to create a stock market report for fifty companies. Use macro and chrome to generate data.

Can anyone show me a step by step process on how I can do this?

Please watch the video and Excel workbook below to learn more.

Example STOCK REPORT CARD

Sheet2 CORRIE STOCK REPORT CARD Websites Top 100,Company,Symbol,P/E,Price,Sales Growth Yr Over Yr,Sales, Revenue, Net Income in B=billion or M=million,52-Week Low & High,5 Year High & Low,Market Cap; # Shares,Debt/Equity Ratio,Net Profit,Company: Insider Trading,Operating Margins,Description,New...

docs.google.com

I hope you all understand.

Cheers

Hello, Thank you for sharing..

I am looking for courses on how to automatically extract data from a website to an excel spreadsheet.

The excel file contains fifty links. Each link has the same process, to create a stock market report for fifty companies. Use macro and chrome to generate data.

Can anyone show me a step by step process on how I can do this?

Please watch the video and Excel workbook below to learn more.

Example STOCK REPORT CARD

Sheet2 CORRIE STOCK REPORT CARD Websites Top 100,Company,Symbol,P/E,Price,Sales Growth Yr Over Yr,Sales, Revenue, Net Income in B=billion or M=million,52-Week Low & High,5 Year High & Low,Market Cap; # Shares,Debt/Equity Ratio,Net Profit,Company: Insider Trading,Operating Margins,Description,New...

docs.google.com

I hope you all understand.

Cheers

Hello Worf. I uninstall & reinstall office. Nothing... I tried all the codes recommended. Nothing... What else can a man can try.

 

[Worf]

I am busy this week, will get back here as soon as possible...

 

[Corried]

I am busy this week, will get back here as soon as possible...

Okay. Thanks for not giving up on me...

 

[Worf]

It seems that the source HTML keeps changing.

See below the XPath for the P/E element; the first one is from today, the second one is from post #49, note that they are different.

I do not see how we can overcome this situation.

 

[Corried]

It seems that the source HTML keeps changing.

See below the XPath for the P/E element; the first one is from today, the second one is from post #49, note that they are different.

I do not see how we can overcome this situation.

View attachment 64142

I am not sure which line to change

 

[Corried]

I am not sure which line to change

It seems that the source HTML keeps changing.

See below the XPath for the P/E element; the first one is from today, the second one is from post #49, note that they are different.

I do not see how we can overcome this situation.

View attachment 64142

Is there any way to make it stable

 

[Worf]

Is there any way to make it stable

Not that I am aware of, this is a critical problem.

I will prepare one last version and let us see what happens.

 

[Corried]

Not that I am aware of, this is a critical problem.

I will prepare one last version and let us see what happens.

Okay Thanks