Serving the Quantitative Finance Community

 
User avatar
player
Topic Author
Posts: 0
Joined: August 5th, 2002, 10:00 am

yahoo

December 31st, 2007, 9:58 am

How can I link yahoo stock prices into excel so that when I open up excel I will always have the closing/opening price of the stock on the previous date? I'm sure there was an example spreadsheet of this somewhere on this website but I cant find it
Last edited by player on December 30th, 2007, 11:00 pm, edited 1 time in total.
 
User avatar
jwmaiden
Posts: 0
Joined: March 17th, 2007, 4:08 pm

yahoo

December 31st, 2007, 12:33 pm

This is not a spreadsheet, but this thread tells you how to do it. All you have to do is parse a CSV file.http://www.wilmott.com/messageview.cfm? ... adid=55693