Looking for a simple (if possible) way to get equity quotes in excel. I dont need real-time feeds. but what i need is the ability for the symbol to be referenced in another column. Every solution i have found gives me a bunch of other data or poor formatting. ideally i am looking for something like: A1=IBM A2=quote(IBM) B1=AAPL B2=quote(AAPL) so that i can place a symbol in one cell, and have a quote appear in another cell based on the reference. I am fine if its a external data source that requires manual refresh. This is more for a watch list/ snap shot look, not a trade trigger tool. Thanks.
Exceedingly excellent "Freeware"....and it comes with great support too ! http://finance.groups.yahoo.com/group/smf_addin/ Works with Yahoo's history data banks as well as their delayed (free) or realtime ($$$) data feeds.