Cannot pull table from different tabs within the same webpage.

[mj sachoo]

Hello,

I am trying to obtain the data table from

Australia Stock Market - Investing.com AU

Up-to-date data on the stock market in Australia, including leading stocks, large and small cap stocks.

au.investing.com

website. However, I can only extract the data from the 'Price' tab.

I cannot obtain the tables under the 'Performance', 'Technical and 'Fundamental Tabs.

I get the following error when trying to click the other tabs:

I do not know how to get these tables from other tabs.

Last hope is this website as I have not got anything from other forums or websites.

Please advise.

Thanks

 

[Abdmujib]

Try the following maceo:

Sub Sportrdr()
Dim TbColl As Object, myTab, BColl As Object, pCount As Long
Dim I As Long, J As Long, mySplit, myTim As Single
Dim WPage As New WebDriver
'
Sheets("Foglio3").Select            '<<< The sheet for the results
'
WPage.Start "Chrome", "https://s5.sir.sportradar.com/bet9javirtuals/en/1/season/2477086/fixtures/full"
WPage.Get "/"
'
myTim = Timer
Range("A:E").ClearContents
Range("C:D").NumberFormat = "@"
'
Do
    WPage.Wait 700
    Set BColl = WPage.FindElementsByTag("Button")
    If BColl.Count > 0 And BColl(BColl.Count).Text = "Show more" Then
        BColl(BColl.Count).Click
        WPage.Wait 200
    Else
        Exit Do
    End If
Loop
Set TbColl = WPage.FindElementsByTag("table")
myTab = TbColl(1).AsTable.Data
For I = 1 To UBound(myTab)
    myTab(I, 3) = Left(myTab(I, 3), Len(myTab(I, 3)) / 2)
    myTab(I, 4) = Left(myTab(I, 4), Len(myTab(I, 4)) / 2)
Next I
Range("A1").Resize(UBound(myTab), UBound(myTab, 2)).Value = myTab
End Sub

Thank You so much

I encountered an error attached picture is the error

 

[Anthony47]

To avoid that error you need to set a reference to the "Selenium type library":
-from vba windows...
-Menu /Tools /Reference; scroll the Reference list, select and check "Selenium Type Library"
-press Ok

Retry...

 

[Abdmujib]

To avoid that error you need to set a reference to the "Selenium type library":
-from vba windows...
-Menu /Tools /Reference; scroll the Reference list, select and check "Selenium Type Library"
-press Ok

Retry...

It brought this error sir after effecting the correction

 

[Abdmujib]

It brought this error sir after effecting the correction

View attachment 74748

Highlighted the below code on the attached picture when I pressed debug

 

[Anthony47]

And of course you don't have a sheet named "Foglio3"; so either modify the instruction with YOUR sheet name or name one of your sheets "Foglio3"

 

[Abdmujib]

And of course you don't have a sheet named "Foglio3"; so either modify the instruction with YOUR sheet name or name one of your sheets "Foglio3"

wow I was about to update you that I just discovered from the code that the sheet is names foglio3. then I saw your response.

so when i named it to Foglio is says my chome version and driver are different. so I am about to get a new version of chrome driver.

 

[Anthony47]

You have to replace the old chromedriver.exe with a new one suitable for your chrome version.
Check here:

ChromeDriver - WebDriver for Chrome - Downloads

Current Releases If you are using Chrome version 115 or newer, please consult the Chrome for Testing availability dashboard. This page provides convenient JSON endpoints for specific ChromeDriver version downloading. For older versions of Chrome, please see below for the version of ChromeDriver

sites.google.com

 

[Abdmujib]

You have to replace the old chromedriver.exe with a new one suitable for your chrome version.
Check here:

ChromeDriver - WebDriver for Chrome - Downloads

Current Releases If you are using Chrome version 115 or newer, please consult the Chrome for Testing availability dashboard. This page provides convenient JSON endpoints for specific ChromeDriver version downloading. For older versions of Chrome, please see below for the version of ChromeDriver

sites.google.com

Thank you so much sir.

It worksssssssss

 

[Abdmujib]

Hello Anthony

I tried to but the code to use tonight.

sometimes it loads and sometimes it says "index was outside the bonds of the array".

then It highlighted the code when i clicked on debug.

 

[Abdmujib]

Hello Anthony

I tried to but the code to use tonight.

sometimes it loads and sometimes it says "index was outside the bonds of the array".

then It highlighted the code when i clicked on debug.

View attachment 75094


View attachment 75092

Hello Anthony

I tried to but the code to use tonight.

sometimes it loads and sometimes it says "index was outside the bonds of the array".

then It highlighted the code when i clicked on debug.

View attachment 75094


View attachment 75092

In addition, I need to let you know the following:

A season is two hours plus
I do change the number in the link to the current season current number
The link we have been using is an already played season which has had all it results for all the matches in the season
I need only an ongoing season data to make my prediction which all the result have not been filled except for the ones that has played.
The yet to be played games scores are denoted with an hyphen "-" attached picture. so I am not sure if that was the reason for the problem


thanks