+ Reply to Thread
Results 1 to 3 of 3

Query web

  1. #1
    Registered User
    Join Date
    02-09-2012
    Location
    Napoli
    MS-Off Ver
    Excel 2010
    Posts
    4

    Query web

    Good morning,

    I write from Italy and I very much appreciate what you have disclosed, and I would ask if you could help me to solve a problem.

    It 's interesting thread: When Web Query Save old data refreshes,

    I'd love to get the data in order to receive as a column and put down.

    That is the last figure should be the bottom.

    I hope I can help.

    greetings

    Carlito

  2. #2
    Registered User
    Join Date
    02-09-2012
    Location
    Napoli
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Query web

    One thing I will say is that the data should not be replaced as they are updated. They must continue to be recorded forever on the last date down as shown in the image.


    Date Open High Low Close Volume
    07-nov-11 42,26 43,18 41,92 42,99 424.740
    08-nov-11 43,33 43,33 42,52 42,87 408.064
    09-nov-11 42,66 43,48 42,23 42,92 473.947
    10-nov-11 42,86 43,24 42,52 42,63 472.051
    11-nov-11 42,51 43,14 42,51 43,1 316.257
    14-nov-11 43 43,25 42,61 42,72 275.820
    15-nov-11 42,72 43,07 42,12 42,56 182.709
    16-nov-11 42,48 42,91 42,15 42,3 288.882
    17-nov-11 42,29 42,4 41,51 41,88 685.788
    18-nov-11 42,26 42,26 41,81 41,89 566.407
    21-nov-11 41,8 42,38 41,56 42,09 1.150.126
    22-nov-11 42,99 44,97 42,58 44,71 1.288.311
    23-nov-11 42,5 42,5 41,74 42,46 1.601.025
    24-nov-11 42,47 42,48 42,28 42,45 91.894
    25-nov-11 42,39 42,51 42,25 42,3 463.536
    28-nov-11 42,52 42,6 42,03 42,1 574.870
    29-nov-11 42,1 42,48 41,9 42,18 376.281
    30-nov-11 42,55 43,25 41,97 43,19 1.112.886
    01-dic-11 43 43,5 42,62 43,02 633.882
    02-dic-11 43,21 43,21 41,75 41,98 531.785
    05-dic-11 41,78 42,37 41,25 41,48 898.969
    06-dic-11 41,12 41,74 41,06 41,46 770.501
    07-dic-11 41,51 41,78 41,47 41,72 457.117
    08-dic-11 41,4 42,29 41,34 41,45 733.997
    09-dic-11 41,5 41,68 41,18 41,35 559.789
    12-dic-11 41,08 41,28 40,62 40,94 668.496
    13-dic-11 40,76 40,9 38,99 39,42 845.592
    14-dic-11 38,93 39,48 38,51 38,86 842.939
    15-dic-11 39,1 39,11 38 38,27 512.900
    16-dic-11 38,5 39,82 38,5 39,53 1.332.169

    Thank you for your help.

  3. #3
    Registered User
    Join Date
    02-09-2012
    Location
    Napoli
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Query web

    One thing I will say is that the data should not be replaced as they are updated. They must continue to be recorded forever on the last date down as shown in the image.
    5.jpg

+ 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