|
#1
|
|||
|
|||
![]() I have hit a wall on what to do with this site, all i get with web queries is unsupported browser, hoping someone with more knowledge can get these in to excel.
https://www.tab.com.au/racing/meetings/today/R If you can import these venues i will be able to import what i need.
__________________
One Drive "If the corporates are treating you poorly , just go elsewhere." "If they need you , they will soon find out." "If you need them , you will soon find out." --moeee _______________________________________________ |
#2
|
|||
|
|||
![]() Quote:
You can sign up to receive data free as far as I know via an API? Not important enough for me. Last edited by blackdog1 : 18th March 2016 at 06:57 PM. |
#3
|
|||
|
|||
![]() Quote:
I need a bigger Turnover from the Tab for that as it is only available to Silver and above. I do have another option i have not tried, it won't be pretty but may work, i can write a script using AutoHotKey to create a browser then i can send the contents of that browser to a txt doc then import that to excel, it won't be fully dynamic but it just may get the info that i need, namely exotic payouts.
__________________
One Drive "If the corporates are treating you poorly , just go elsewhere." "If they need you , they will soon find out." "If you need them , you will soon find out." --moeee _______________________________________________ |
#4
|
|||
|
|||
![]() How about we try to use the web browser controls built in to excel to access some of these pages we can't extract data from, i guess it depends on what type of updating you need, i wouldn't use it for live prices but would work for results,scratchings and things like that, i am not sure at this point in time how to get the info from the page to a sheet, but am sure it can be done.
__________________
One Drive "If the corporates are treating you poorly , just go elsewhere." "If they need you , they will soon find out." "If you need them , you will soon find out." --moeee _______________________________________________ |
#5
|
|||
|
|||
![]() Is a bit dirty right now but am sure i can add a bit more functionality to it.
Code:
This just copies the page, you need to add to it to paste it in excel, you will see a browser open and it waits 5 seconds for the page to load, this can be adjusted to less or more, once the contents copied the browser closes, if you choose not to see the browser change ieApp.Visible = True to False and you won't even see the browser but it will still copy the contents. you could set up another timer so it runs every 30 seconds to give you some sort of price update.
__________________
One Drive "If the corporates are treating you poorly , just go elsewhere." "If they need you , they will soon find out." "If you need them , you will soon find out." --moeee _______________________________________________ |
#6
|
|||
|
|||
![]() Seems recently the tab has been blocking some Amazon servers, or as they said specifically Telstra, not sure why but it made it hard for me to get access to the website from my server.
The script above worked fine from my pc but the only way to get access to the site from the server is to use chrome with the Hola browser addon. Problem is excel doesn't play nice with chrome and i couldn't install the Hola addon to IE Still a bit roughm but works. Code:
__________________
One Drive "If the corporates are treating you poorly , just go elsewhere." "If they need you , they will soon find out." "If you need them , you will soon find out." --moeee _______________________________________________ |
![]() |
Thread Tools | Search this Thread |
Display Modes | |
|
|