Im trying to set up an Excel spreadsheet that will download semi-real time stock prices.
Yahoo has a html web address which will download a quotes.csv file (prices delayed by about 15 min).
http://finance.yahoo.com/d/quotes.csv?s= [SYMBOLS separated by "+" ] &f= [tags]
In the excel spreadsheet i have command button. when i click the command button i would like the stock data to be downloaded and inserted into excel.
The stock symbols will be typed into a cell on the spreadsheet by the user.
The tags will be constant and written into the code.
Any suggestions as to the best way to go about this?
(reposted in response to VB forum reply)
You can use Spearian for Excel, http://spearianforexcel.com, which provides you not just with Yahoo data, but also historical FX rates.
Jiri Pik, firstname.lastname@example.org Web: http://jiripik.com, LinkedIn: http://www.linkedin.com/in/jiripik, Twitter: http://twitter.com/@JiriPik
- Edited by Jiri Pik Saturday, March 30, 2013 12:22 PM