AgTalk Home
AgTalk Home
Search Forums | Classifieds (46) | Skins | Language
You are logged in as a guest. ( logon | register )

how to get bids from elevator or CME website onto excel daily?
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
WYDave
Posted 11/2/2025 20:17 (#11422310 - in reply to #11421990)
Subject: RE: how to get bids from elevator or CME website onto excel daily?


Wyoming

Please see "Method 4. Using VBA for Custom Web Scraping" to see what I'm referring to. You can program extensions into Excel that will put information from a web page into Excel spreadsheets.

https://techcommunity.microsoft.com/discussions/excelgeneral/adding-futures-indexes-and-commodities-into-excel/4200203

The subroutine "GetStockData()" would need to be modified to go to a different URL (whatever the URL of your futures or elevator page is), and then you'd need to modify the "parse response" and "find and extract data" parts of that Visual Basic macro to start making headway.

Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)