+ Reply to Thread
Results 1 to 4 of 4

VBA code to arrange data obtain from website

  1. #1
    Registered User
    Join Date
    12-10-2011
    Location
    KSA
    MS-Off Ver
    Excel 2010
    Posts
    5

    VBA code to arrange data obtain from website

    Hi all,
    its my first post here and I need your help please
    I have been writing this code for almost 3 days and done it with recording macro and I adjust it a bit,

    the thing is I want to take the historical prices from this website, www.tadawul.com.sa and I used web query with recorded macro.

    The problem was how to take all the historical prices of stocks with different pages on the website? I mean I want to take all the prices at one place one column.
    here is my VBA code


    Please Login or Register  to view this content.
    Last edited by Leith Ross; 12-10-2011 at 09:09 PM. Reason: Added Code Tags

  2. #2
    Registered User
    Join Date
    12-10-2011
    Location
    KSA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: VBA code to arrange data obtain from website

    One mistake, I tried the Code above and it give me wrong information, so I upload the code into Txt format bellow.

    Thank you again
    Attached Files Attached Files

  3. #3
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: VBA code to arrange data obtain from website

    Please Login or Register  to view this content.



  4. #4
    Registered User
    Join Date
    12-10-2011
    Location
    KSA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: VBA code to arrange data obtain from website

    Thank you for your reply,

    Actually I didn't get what I want, seems your code is only for general page that I don't want.

    I want the pages of the prices 'Historical prices of the stocks"

    let me explain more:

    Go to this website http://www.tadawul.com.sa/wps/portal...330&tabOrder=2

    Do you see the table of the prices? the table number is "37"

    Now since the prices is in separate pages so I found really a difficult way to obtain theses tables all together at one sheet without header. also I want excel to ask me what symbol number to enter and then I will get historical prices of that symbol for like 5 or 6 years.

    thank you for your reply anyway.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1