|
| I have done this with LibreOffice, an open source office software program.
In my limited experience, if the website is posting the data using a html table it is certainly possible and relatively easy. I have not figured out how to easily scrape the web data if the table is filled using javascript (my thought, true?).
I have attached .ods and .xlsx versions of a spreadsheet I have used in the past. This loads with old data ('23, '24) and would require changing dates to current to see how it works. In LibreOffice pressing the "Allow updating" button will refresh the futures tables. LibreOffice will periodically refresh this based on your setting or manually refresh under "Edit:Links to ...". I am not sure how excel works but have been told it is easier and more powerful.
The .xlsx version is saved from LibreOffice so may need additional work in excel.
Two links that may/may not help:
https://talk.newagtalk.com/forums/thread-view.asp?tid=1158394&mid=10...
https://talk.newagtalk.com/forums/thread-view.asp?tid=1121810&mid=10... (relevant information is towards the bottom)
Attachments
----------------
 Farms download.ods (73KB - 3 downloads)
Farms download.xlsx (55KB - 4 downloads)
| |
|
how to get bids from elevator or CME website onto excel daily?
