How can I automatically update stock prices?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
In groups.yahoo.com/xltraders/files/ something called "Download
Quotes.XLS" I'm using office 2003.
 
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
 
Thank you. I downloaded your file, "YahooMultipleHistory97a_P.xls," and it
works perfectly.

Lee
 
As I said, glad you like it, BUT the other one would be better for your
ORIGINAL question.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error when creating a stock chart from data in .CSV file 9
Stock Quotes 1
stock change 3
Historical Stock Prices in Excel 1
how can I update stock prices daily into excel 2
What is a bank stock? 1
Update Summary Sheet Automatically 7
Update Files Automatically with Links 1

Back
Top