Thread
:
How can I automatically update stock prices?
View Single Post
#
11
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
How can I automatically update stock prices?
Contact me privately at my address below
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"klkropf" wrote in message
...
Don,
I downloaded YahooMultipleQuotes.xls and I love it! I tried to look at
the
VB
code so I could see how it's working and it's password protected. Is
there any way I can look at he
VB
code?
Thanks
"Don Guillett" wrote:
As I said, glad you like it, BUT the other one would be better for your
ORIGINAL question.
--
Don Guillett
SalesAid Software
"lisgur" wrote in message
...
Thank you. I downloaded your file, "YahooMultipleHistory97a_P.xls,"
and
it
works perfectly.
Lee
"Don Guillett" wrote:
download quotes is NOT my file and I wouldn't use that method.
However,
I
downloaded and changed the symbols to ibm, msft, t and it worked for
me.
look for files with an author of donalb36.
GetYahooMultipleHistory97a_P.xls
Yahoo History & Graph 111 KB donaldb36
YahooMultipleQuotes.xls
YahooMultipleQuotes 41 KB donaldb36
--
Don Guillett
SalesAid Software
"lisgur" wrote in message
...
In groups.yahoo.com/xltraders/files/ something called "Download
Quotes.XLS" I'm using office 2003.
"Don Guillett" wrote:
Which file? What did you do? etc.
--
Don Guillett
SalesAid Software
"lsi" wrote in message
...
Don,
Thanks for the prompt answer. I found the file but in some
respects
I'm a
neophyte. After I downloaded it and fixed my security settings
to
get
it
I
get a visual basic error message, "run-time error 1004."
Saying,
"the
internet site reports that the item you requested could not be
found.
(HTTP/1.0 404)"
Any idea what I'm doing wrong?
Lee
"Don Guillett" wrote:
goto xltradersjoin and download a couple of free files I
have
provided
to
get info from Yahoo.
To visit your group on the web, go to:
http://groups.yahoo.com/group/xltraders/
--
Don Guillett
SalesAid Software
"LSI" wrote in message
...
I have a spread sheet tempate that I made where I write
down
my
daily
stock
transactions. For each position I have in inventory I show
the
closing
price, the quantity and the cost. I would like to be able
to
get
or
create a
function that each time I open the sheet I could login to
say
a
MMoney
file
or my broke and update the current price for each security.
Does
anyone
do
this or know how to do it?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett