Thread
:
Stock prices into excel
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Stock prices into excel
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett