I have set up similar projects for clients but an easy way to do it is to
goto
http://finance.yahoo.com/
my portfoliosset up one. You get 15 minute delayed quotes showing up in
green and dn in red that change with each trade. Very flexible on what to
show.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Andreas Ingo" <Andreas wrote in message
...
I would really appreciate if someone could help me with some code that
makes
excel import stock prices from a home page on an intra-daily basis, e.g.
every 5th or 10th minute. I do not want to have time series data, it is
enough if one cell is updated each time with the current price.

Furthermore I would like excel to give a pop-up/notice every time a cell
in
the sheet is larger/less than a specific trigger which always is a number.
It
is important that the pop-up always will be seen, i.e. so it does not lay
behind other windows.

I would really appreciate if someone could help me with this.

/Andreas