ExcelBanter - Extract Data using Web query

wrote:
Hi Don,
the url : http://www.investegate.co.uk/
Thanks for taking time looking into this.

cheers, francis

Don Guillett wrote:
url?

--
Don Guillett
SalesAid Software

wrote in message
ups.com...

Don Guillett wrote:
Although you have give almost no information, the answer to your question
is
yes.

--
Don Guillett
SalesAid Software

wrote in message
ups.com...
Hi,

I have created a web query to download table relating to a number of
companies.
Whenever I run the query I need to either type in the unique company
identifier or
point to a cell where the identifier is stored.
Can I get excel to run down a column containing unique identifiers and
automatically pass it to the webquery.

Thanks in advance

cheers, francis

Hi Don,

Thanks for your response. My primary interest is in Corporate events
and dividend announcements data but i thought i would get the whole
thing and then filter it out, in case I need to use the other news
announcements
later.

The procedure is to go to the site. Select the menu companies, Then
search by
the unique identifier (ISIN), which are a combination of alphabets and
numbers .. for example XS01078BMG09, HK0000041570, to get the news
items regarding a company and then download it to excel. With a list of
about 4600 companies i need to enter the isins and the page numbers
manually each time and scrolling up and down to select the destination
cells. This is the kind of thing u would want to automated.

Ideally my program would run like this :

I have the isin nos in the column A, the page numbers say
0,60,120,180...300
max. in column B.

The program selects C1. and then runs the webquery with cell contents
A1 and B1.
A1 for isin and B1 for ls.

One the data is downloaded. The active cell moved down to the end of
data in
column C. Checks to see if it says No announcements. If doesn't say No
announcements Then runs the query again with A1 and B2.

After that is done. let say there was only one of data for this
company. So when the
program runs with A1 and B2 the value No announcement is returned. So
the
program Moves to A2 ( a new isin number) and B1. Then A2 and B2 so and
so forth.

I wouldnt mind just getting the program to run down the isin column
alone with
fixed values for the page number. As i can one page at a time for all
the
companies. so os is fixed at 0 for the first 4600 runs. Then fixed to
60 for the
next 4600 runs etc.

The key point is to get the program to move down automatically to read
and pass
the isins to the query.

Appreciate your assistance.

cheers, francis

Hi Don,

I have mentioned that I wanna use Excel to access the web page and pull
the announcements portion into Excel. The program run like this:
I have the isin nos or company names in the column A
Once the data is downloaded, Excel checks to see if it says No
announcements. If there is an announcements, copy it to a sheet under
the company's name.
Then runs the query again with A2 and so on....

If you have a better idea, I would like to hear from you. My main aim
is to track these companies announcements on dividend, rights issues,
tender offers, bonus, meetings, mergers and earnings.

It is important that Excel can automatically pass the identifiers /
company name's to the web query and pull the relevant data, in this
case Announcements.

Hope I have given you enough info.

Thank you for your assistance.

cheers, francis