I would like to take commodity futures, and options prices and from a web table and have Excel update whenever i open the document or tell it to refresh or something. can it be done?
here is the URL for the table i want
http://www.cmegroup.com/trading/agri...xpMonth=201312
thanks to whoever cares to try!!
Last edited by sniderza; 10-24-2012 at 07:24 PM.
here is another table that might prove easier
http://admis.com/QuotesChartsNews.as...plit&sym=ZCZ13
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Have you tried a web query?
yes but was unable to make it work.... but that was most likely user error
Nothing huh?
If I knew what and where to look for I might be able to help.
For example, where are the commodity futures located on the page?
Are they even on the page that URL leads to?
use the URL in the first post for CME. this will bring you to a page with one row of DEC13 prices I want these, and the table to fallow of options. (calls and puts) however this table only includes prices "at the money" if you change the drop down menu to "all" and hit update you get a full table. I do not know if this will be possible because the URL doe not change when the full table loads, but like i said i dont understand all this stuff i only understand markets. If the you cant get the full table I am still interested because i can do a lot with what is there and see how it is you did it and use that for other commodities.
Thanks, Z.S.
It can be done if you can source out a way to save the page as a text file, which I did manually, the data does appear in the text file.
Last edited by SuitedAces; 11-05-2012 at 07:38 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks