Hello,
I am new to Excel Programming and trying to make my personal stock journal which would obtaining actual price from Yahoo Finance.
The goal is read stock symbols in second column and retrieve it's price into third.
Here's what I was trying to manage:
Problem is, it does not do anything.
Please Login or Register to view this content.
Do somebody know what's wrong with that, please?
I would bet something about cell range in the secon line.
Since you didn't include any of your symbols, I couldn't be sure why it's not working.
Splitting responsetext is prone to errors though, it's better to get the actual element.
Here's some code I created for someone else on here the other day:
Set references to Microsoft XML and Microsoft HTML
This gets the current stock price from google finance and works like a function.Please Login or Register to view this content.
So in a cell you could say "=Stockquote(aapl)" and it would get the stock quote for Apple.
I can easily adjust this to yahoo - just give me a link and specify what you'd like to get.
Last edited by JasperD; 05-05-2015 at 06:46 PM.
Please click the * below if this helps
Hi JasperD,
I am totaly new to Excel Programming and I am sure I have done something wrong.
Here's what I've tried:
I have copied the code you provided me and inserted the function as new Module.
Then I have checked up all boxes of Microsoft HTML and XML in Tools-References.
When I type =StockQuote(AAPL) in a cell it retrieves "#VALUE!".
I have also tried to add the function as Object but with the same result.
What can I do to make it work?
Thank you very much.
Does anybody know what I am doing wrong?
Last edited by jirakst; 05-06-2015 at 03:43 PM. Reason: typo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks