[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

HTTP string queries



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