|
PureBytes Links
Trading Reference Links
|
Tomas -- I don't know if it would help or not, but I have an EXCEL
add-in that retrieves over 14,000 different data elements from the
web. The VBA code is open source and available over at:
http://finance.groups.yahoo.com/group/smf_addin/
For 99% of the data elements, I've defined them down to a pattern of
ten parameters. For example:
aParms(10) = "MSN;% Insider Ownership;OWNERSHIP INFORMATION;INSIDER; ;
;0;0;1;0"
....means this is the definition of element #10. The parameters mean:
#1 = Data source ID (I currently have 35 different source web pages)
#2 = Name to use for the element
#3-6 = Strings that define how to find a starting point on the page
#7 = # of rows to skip from there before looking for data
#8 = string to identify end of table if # of rows > 0
#9 = relative # of the cell in the row that contains the data
#10 = # of cells to look at to find data (only used by a few items)
After a web page is retrieved, these 10 parameters are passed to a
small parsing routine that returns the value in the table cell. Each
web page is held in an array, so that if other elements are desired
from that page, it doesn't need to be retrieved again.
|