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 problemthanks for any help!
Bookmarks