+ Reply to Thread
Results 1 to 2 of 2

Update external data link (webdata)

  1. #1
    Registered User
    Join Date
    11-22-2012
    Location
    Norway
    MS-Off Ver
    Excel 2003
    Posts
    2

    Update external data link (webdata)

    Hi!

    Question: I have a spreadsheet that is getting data from a website (txodds.com). This is betting prices from a range of bookmakers, and my aim is to comapre the odds and find certain matches that fit criteria I set.

    My first problem in this work is that the link I use uses the date and time interval from my first search, and I can't get it to update the interval. See link below:
    http://txodds.com/ocpage.php?ntb=1&t...18,i_83,i_6&d=2012-11-22 09:41|2012-11-24&sortby=date&sortord=asc&ot=1&md_flags=520&topbar=0

    As you can see in bold, there is a set time and date in the link i get data from, and if I try to update data the next day, the dates are (obviously) still the same, and I get old data, not updated and new which is what I want. Is there any way to "renew" the query-link from within Excel or will I have to update it manually in the "connection" meny under "data"?

    Hope you guys understand my problem thanks for any help!

  2. #2
    Registered User
    Join Date
    11-22-2012
    Location
    Norway
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Update external data link (webdata)

    No one knows? I guess that means that editing a link automatically is not possible....?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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