Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Jenna Ryan   on Nov 08 In MS Office Category.

  
Question Answered By: Mildred Bailey   on Nov 08

My problem is that I have no idea what values would be likely for you
to use for the "words" parameter since I have never used ISINs.
However, using a different example, I was able to use one of my add-in
functions to work on a similar URL. This function call from my
add-in:

=RCHGetHTMLTable("www.investegate.co.uk/Index.aspx\
ndard&Go=search",">Announcement",-1,"",1)

..returns a range of data that contains 61 rows and 5 columns of data.
You could also use that function within VBA by using the add-in as a
reference library. For example:

Sub Test()
aData =
RCHGetHTMLTable("www.investegate.co.uk/Index.aspxn\
dard&Go=search",
">Announcement", -1, "", 1, pDim1:=61, pDim2:=5)
End Sub

"aData" would be a 61 row by 5 column array from which you could
extract the data you want. For example, it appears to me you'll need
to "fill in" the dates, since they don't exist on every row, just when
the date changes. I would think you'd want it populated on every row
if you are creating a "database".

So, you could wrap that statement up within a loop of "os" and "words"
to repetitively get and extract all of your data, generating the new
URL on each iteration. However, I would "batch" it up into manageable
chunks in case something happens during the processing. Or, you could
write the extracted data to a sheet on each iteration, appending to
the "database" as you go...probably adding the "ISIN" as an additional
column in the "database" you are creating?

Share: 

 

This Question has 15 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Web query question Or get search suggestion and latest updates.


Tagged: