PureBytes Links
Trading Reference Links
|
I'm pretty clueless about the details of web queries and HTML code. I have
access to a long working VBA code module for downloading from Yahoo, and
I'm looking for a download site that I can download directly from for eod
commodities data. Sites such as Bohl need you to log on first, etc.
If you know of such a site could you let me know.
I need to learn the following about the site:
the corresponding search strings:
daily http://chart.yahoo.com/d?s=TICKER
weekly http://chart.yahoo.com/w?s=TICKER
monthly http://chart.yahoo.com/m?s=TICKER
The construction of a search string like the Yahoo search string
strAdd = "a=" & a & "&b=" & b & "&c=" & c & "&d=" & d & "&e=" & e
strAdd = strAdd & "&f=" & f & "&g=" & g & "&s=" & z & "&y=" & y & "&z="
& z
SearchString = "http://chart.yahoo.com/t?" & strAdd
If there are tables, the tags identifying the start of
table, row, data item, i.e., <table>, <tr>, <th>, <td>.
The block after the sepTag,
before the next sepTag, and the remains part.
for table, the two tags: <table, and </table
or others: <tr, <tr; or <th, <th; or <td, <td;
I assume that in the HTML page, there are many <...> kind of tags.
Example:
Before remove: <td> 123 </td>
After remove: 123
Any help in finding out the code of a site would be appreciated.
Best regards
Walter
|